jam-cloud/db/up/jam_track_importer.sql

5 lines
315 B
SQL

ALTER TABLE jam_tracks DROP COLUMN available;
ALTER TABLE jam_tracks DROP COLUMN initial_play_silence;
ALTER TABLE jam_tracks ADD COLUMN metalocation VARCHAR UNIQUE;
ALTER TABLE jam_tracks ADD CONSTRAINT plan_code_unique UNIQUE (plan_code);
ALTER TABLE jam_track_rights ADD COLUMN recurly_subscription_uuid VARCHAR;