diff options
| author | Jeremy Kerr <jk@ozlabs.org> | 2011-09-19 09:42:44 +0800 |
|---|---|---|
| committer | Jeremy Kerr <jk@ozlabs.org> | 2011-09-19 09:42:44 +0800 |
| commit | 75d8cf966034e673afe0077ba393d8b2eb3e9b93 (patch) | |
| tree | 3f6cf6b9f87ad313d23de77b4c33422e7444a1df /lib/sql/migration/011-patch-change-notifications.sql | |
| parent | 539b6596dc1bf1d3118631095625e354026da373 (diff) | |
| parent | f1e5f6a2c9d737f12290f5bd5a934b74c362616f (diff) | |
| download | patchwork-75d8cf966034e673afe0077ba393d8b2eb3e9b93.tar.bz2 patchwork-75d8cf966034e673afe0077ba393d8b2eb3e9b93.tar.xz | |
Merge branch 'notifications'
Diffstat (limited to 'lib/sql/migration/011-patch-change-notifications.sql')
| -rw-r--r-- | lib/sql/migration/011-patch-change-notifications.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/lib/sql/migration/011-patch-change-notifications.sql b/lib/sql/migration/011-patch-change-notifications.sql new file mode 100644 index 0000000..0a9b9b7 --- /dev/null +++ b/lib/sql/migration/011-patch-change-notifications.sql @@ -0,0 +1,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; |