16 lines
998 B
SQL
16 lines
998 B
SQL
-- tracks how users are progessing through the site: https://jamkazam.atlassian.net/wiki/pages/viewpage.action?pageId=3375145
|
|
|
|
alter table music_sessions_user_history add column max_concurrent_connections integer;
|
|
alter table music_sessions_user_history add column rating integer;
|
|
alter table users add column last_failed_certified_gear_at TIMESTAMP;
|
|
alter table users add column last_failed_certified_gear_reason varchar(256);
|
|
alter table users add column first_downloaded_client_at TIMESTAMP;
|
|
alter table users add column first_ran_client_at TIMESTAMP;
|
|
alter table users add column first_certified_gear_at TIMESTAMP;
|
|
alter table users add column first_music_session_at TIMESTAMP;
|
|
alter table users add column first_real_music_session_at TIMESTAMP;
|
|
alter table users add column first_good_music_session_at TIMESTAMP;
|
|
alter table users add column first_invited_at TIMESTAMP;
|
|
alter table users add column first_friended_at TIMESTAMP;
|
|
alter table users add column first_social_promoted_at TIMESTAMP;
|