summaryrefslogtreecommitdiffstats
path: root/lib/sql/migration/011-patch-change-notifications.sql
blob: 0a9b9b73bd451243994e3a72c842a5c9f686d23d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
BEGIN;
CREATE TABLE "patchwork_patchchangenotification" (
    "patch_id" integer NOT NULL PRIMARY KEY REFERENCES "patchwork_patch" ("id") DEFERRABLE INITIALLY DEFERRED,
    "last_modified" timestamp with time zone NOT NULL,
    "orig_state_id" integer NOT NULL REFERENCES "patchwork_state" ("id") DEFERRABLE INITIALLY DEFERRED
)
;
ALTER TABLE "patchwork_project" ADD COLUMN
    "send_notifications" boolean NOT NULL DEFAULT False;
ALTER TABLE "patchwork_project" ALTER COLUMN
    "send_notifications" DROP DEFAULT;
COMMIT;