diff options
| author | Jeremy Kerr <jk@ozlabs.org> | 2011-03-29 11:58:39 +0800 |
|---|---|---|
| committer | Jeremy Kerr <jk@ozlabs.org> | 2011-04-14 17:24:03 +0800 |
| commit | 798a73b8bfb41f742e78e481ab9c961556e117b3 (patch) | |
| tree | c6b89361c98cf6b3d866764eb5b091eee7c8bb71 /lib/sql/migration | |
| parent | 41f19b6643b44768dc06561c992c04ed6148477d (diff) | |
| download | patchwork-798a73b8bfb41f742e78e481ab9c961556e117b3.tar.bz2 patchwork-798a73b8bfb41f742e78e481ab9c961556e117b3.tar.xz | |
models: Add PatchChangeNotification and record patch state changes
Add a PatchChangeNotification model to keep track of changes to a
patch's state. Hook this up to Patch's pre_save signal.
Requires a DB schema upgrade.
Signed-off-by: Jeremy Kerr <jk@ozlabs.org>
Diffstat (limited to 'lib/sql/migration')
| -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; |