ALTER TABLE bands ADD COLUMN band_type VARCHAR(16) DEFAULT '';
ALTER TABLE bands ADD COLUMN band_status VARCHAR(16) DEFAULT '';
ALTER TABLE bands ADD COLUMN concert_count SMALLINT DEFAULT 0;
ALTER TABLE bands ADD COLUMN add_new_members BOOLEAN DEFAULT FALSE;
ALTER TABLE bands ADD COLUMN play_commitment SMALLINT DEFAULT 0;
ALTER TABLE bands ADD COLUMN touring_option BOOLEAN DEFAULT FALSE;
ALTER TABLE bands ADD COLUMN paid_gigs BOOLEAN DEFAULT FALSE;
ALTER TABLE bands ADD COLUMN free_gigs BOOLEAN DEFAULT FALSE;
ALTER TABLE bands ADD COLUMN hourly_rate INT DEFAULT 0;
ALTER TABLE bands ADD COLUMN gig_minimum INT DEFAULT 0;

ALTER TABLE musicians_instruments ALTER COLUMN user_id DROP NOT NULL;
ALTER TABLE musicians_instruments RENAME COLUMN user_id TO player_id;
ALTER TABLE musicians_instruments ADD COLUMN player_type VARCHAR(32) DEFAULT 'user';
ALTER TABLE musicians_instruments DROP CONSTRAINT musicians_instruments_user_id_fkey;

ALTER TABLE performance_samples ALTER COLUMN user_id DROP NOT NULL;
ALTER TABLE performance_samples RENAME COLUMN user_id TO player_id;
ALTER TABLE performance_samples ADD COLUMN player_type VARCHAR(32) DEFAULT 'user';
ALTER TABLE performance_samples DROP CONSTRAINT performance_samples_user_id_fkey;

ALTER TABLE online_presences ALTER COLUMN user_id DROP NOT NULL;
ALTER TABLE online_presences RENAME COLUMN user_id TO player_id;
ALTER TABLE online_presences ADD COLUMN player_type VARCHAR(32) DEFAULT 'user';
ALTER TABLE online_presences DROP CONSTRAINT online_presences_user_id_fkey;