ALTER TABLE recordings_users RENAME TO claimed_recordings;
ALTER TABLE claimed_recordings ADD COLUMN id  VARCHAR(64) PRIMARY KEY DEFAULT uuid_generate_v4();
ALTER TABLE claimed_recordings ADD COLUMN name VARCHAR(200) NOT NULL;
ALTER TABLE claimed_recordings ADD COLUMN is_public BOOLEAN NOT NULL DEFAULT true;
ALTER TABLE claimed_recordings ADD COLUMN is_downloadable BOOLEAN NOT NULL DEFAULT true;
ALTER TABLE claimed_recordings ADD COLUMN genre_id VARCHAR(64) NOT NULL REFERENCES genres(id);
ALTER TABLE recordings DROP COLUMN description_tsv;
ALTER TABLE recordings DROP COLUMN description;
ALTER TABLE recordings DROP COLUMN name;
ALTER TABLE recordings DROP COLUMN public;
ALTER TABLE recordings DROP COLUMN is_public;
ALTER TABLE recordings DROP COLUMN is_downloadable;
DROP TRIGGER tsvectorupdate ON recordings;
ALTER TABLE recordings ADD COLUMN duration INTEGER;
ALTER TABLE mixes RENAME COLUMN spec TO manifest;
ALTER TABLE mixes DROP COLUMN url;

