git.ozlabs.org Git - patchwork/blob - lib/sql/migration/011-patch-change-notifications.sql

   1 BEGIN;
   2 CREATE TABLE "patchwork_patchchangenotification" (
   3     "patch_id" integer NOT NULL PRIMARY KEY REFERENCES "patchwork_patch" ("id") DEFERRABLE INITIALLY DEFERRED,
   4     "last_modified" timestamp with time zone NOT NULL,
   5     "orig_state_id" integer NOT NULL REFERENCES "patchwork_state" ("id") DEFERRABLE INITIALLY DEFERRED
   6 )
   7 ;
   8 ALTER TABLE "patchwork_project" ADD COLUMN
   9     "send_notifications" boolean NOT NULL DEFAULT False;
  10 ALTER TABLE "patchwork_project" ALTER COLUMN
  11     "send_notifications" DROP DEFAULT;
  12 COMMIT;