git.ozlabs.org Git - patchwork/blob - lib/sql/migration/004-msgid-uniqueness.sql

   1 BEGIN;
   2 ALTER TABLE patchwork_patch DROP CONSTRAINT "patchwork_patch_msgid_key";
   3 ALTER TABLE patchwork_comment DROP CONSTRAINT "patchwork_comment_msgid_key";
   4
   5 ALTER TABLE patchwork_patch ADD UNIQUE ("msgid", "project_id");
   6 ALTER TABLE patchwork_comment ADD UNIQUE ("msgid", "patch_id");
   7 COMMIT;