DELETE from feeds; ALTER TABLE feeds DROP COLUMN claimed_recording_id; ALTER TABLE feeds ADD COLUMN recording_id VARCHAR(64) UNIQUE REFERENCES recordings(id) ON DELETE CASCADE;