jam-cloud/db/up/jam_track_available.sql

4 lines
321 B
SQL

ALTER TABLE jam_tracks ADD COLUMN available BOOLEAN NOT NULL DEFAULT FALSE;
ALTER TABLE notifications DROP CONSTRAINT notifications_jam_track_right_id_fkey;
ALTER TABLE notifications ADD CONSTRAINT notifications_jam_track_right_id_fkey FOREIGN KEY (jam_track_right_id) REFERENCES jam_track_rights(id) ON DELETE CASCADE;