webring/migrations/007_fix_sites_constraints.down.sql

4 lines
191 B
SQL

ALTER TABLE sites DROP CONSTRAINT sites_pkey CASCADE;
ALTER TABLE sites ADD PRIMARY KEY (slug);
ALTER TABLE sites ADD CONSTRAINT sites_unique_id
UNIQUE (id) DEFERRABLE INITIALLY DEFERRED;