jam-cloud/db/up/jam_track_download_rights.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;