13 lines
736 B
MySQL
13 lines
736 B
MySQL
|
ALTER TABLE jam_tracks ADD COLUMN pro_ascap BOOLEAN DEFAULT FALSE NOT NULL;
|
||
|
|
ALTER TABLE jam_tracks ADD COLUMN pro_bmi BOOLEAN DEFAULT FALSE NOT NULL;
|
||
|
|
ALTER TABLE jam_tracks ADD COLUMN pro_sesac BOOLEAN DEFAULT FALSE NOT NULL;
|
||
|
|
UPDATE jam_tracks SET pro_ascap = TRUE WHERE pro = 'ASCAP';
|
||
|
|
UPDATE jam_tracks SET pro_bmi = TRUE WHERE pro = 'BMI';
|
||
|
|
UPDATE jam_tracks SET pro_sesac = TRUE WHERE pro = 'SESAC';
|
||
|
|
ALTER TABLE jam_tracks DROP COLUMN pro;
|
||
|
|
ALTER TABLE jam_tracks DROP Column pro_royalty_amount;
|
||
|
|
ALTER TABLE jam_tracks ADD COLUMN preview_start_time INTEGER;
|
||
|
|
ALTER TABLE jam_tracks RENAME COLUMN url TO preview_url;
|
||
|
|
ALTER TABLE jam_tracks RENAME COLUMN md5 TO preview_md5;
|
||
|
|
ALTER TABLE jam_tracks RENAME COLUMN length TO preview_length;
|