25 lines
1.1 KiB
SQL
25 lines
1.1 KiB
SQL
ALTER TABLE users ADD COLUMN website varchar(4000) NULL;
|
|
ALTER TABLE users ADD COLUMN skill_level smallint NULL;
|
|
ALTER TABLE users ADD COLUMN concert_count smallint NULL;
|
|
ALTER TABLE users ADD COLUMN studio_session_count smallint NULL;
|
|
|
|
-- virtual band
|
|
ALTER TABLE users ADD COLUMN virtual_band boolean NOT NULL DEFAULT FALSE;
|
|
ALTER TABLE users ADD COLUMN virtual_band_commitment smallint NULL;
|
|
|
|
-- traditional band
|
|
ALTER TABLE users ADD COLUMN traditional_band boolean NOT NULL DEFAULT FALSE;
|
|
ALTER TABLE users ADD COLUMN traditional_band_commitment smallint NULL;
|
|
ALTER TABLE users ADD COLUMN traditional_band_touring boolean NULL;
|
|
|
|
-- paid sessions
|
|
ALTER TABLE users ADD COLUMN paid_sessions boolean NOT NULL DEFAULT FALSE;
|
|
ALTER TABLE users ADD COLUMN paid_sessions_hourly_rate int NULL;
|
|
ALTER TABLE users ADD COLUMN paid_sessions_daily_rate int NULL;
|
|
|
|
-- free sessions
|
|
ALTER TABLE users ADD COLUMN free_sessions boolean NOT NULL DEFAULT FALSE;
|
|
|
|
-- cowriting
|
|
ALTER TABLE users ADD COLUMN cowriting boolean NOT NULL DEFAULT FALSE;
|
|
ALTER TABLE users ADD COLUMN cowriting_purpose smallint NULL; |