15 lines
743 B
SQL
15 lines
743 B
SQL
ALTER TABLE jam_tracks ADD COLUMN download_price numeric;
|
|
UPDATE jam_tracks SET download_price = 2.99;
|
|
ALTER TABLE jam_track_rights ADD COLUMN can_download BOOLEAN NOT NULL DEFAULT FALSE;
|
|
UPDATE jam_track_rights SET can_download = TRUE;
|
|
ALTER TABLE shopping_carts ADD COLUMN variant VARCHAR;
|
|
UPDATE shopping_carts set variant = 'stream' where cart_type = 'JamTrack';
|
|
ALTER TABLE sale_line_items ADD COLUMN variant VARCHAR;
|
|
UPDATE sale_line_items set variant = 'full';
|
|
|
|
|
|
-- paste this in once more when web app updated
|
|
-- UPDATE jam_track_rights SET can_download = TRUE;
|
|
-- UPDATE shopping_carts set variant = 'stream' where cart_type = 'JamTrack';
|
|
-- UPDATE sale_line_items set variant = 'full';
|
|
-- UPDATE jam_tracks SET download_price = 2.99; |