summaryrefslogtreecommitdiffstats
path: root/lib/sql/grant-all.postgres.sql
diff options
context:
space:
mode:
authorJeremy Kerr <jk@ozlabs.org>2011-03-29 11:58:39 +0800
committerJeremy Kerr <jk@ozlabs.org>2011-04-14 17:24:03 +0800
commit798a73b8bfb41f742e78e481ab9c961556e117b3 (patch)
treec6b89361c98cf6b3d866764eb5b091eee7c8bb71 /lib/sql/grant-all.postgres.sql
parent41f19b6643b44768dc06561c992c04ed6148477d (diff)
downloadpatchwork-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/grant-all.postgres.sql')
-rw-r--r--lib/sql/grant-all.postgres.sql6
1 files changed, 4 insertions, 2 deletions
diff --git a/lib/sql/grant-all.postgres.sql b/lib/sql/grant-all.postgres.sql
index 9b6c862..72abb57 100644
--- a/lib/sql/grant-all.postgres.sql
+++ b/lib/sql/grant-all.postgres.sql
@@ -23,7 +23,8 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON
patchwork_bundle,
patchwork_bundlepatch,
patchwork_patch,
- patchwork_emailoptout
+ patchwork_emailoptout,
+ patchwork_patchchangenotification
TO "www-data";
GRANT SELECT, UPDATE ON
auth_group_id_seq,
@@ -45,7 +46,8 @@ GRANT SELECT, UPDATE ON
patchwork_state_id_seq,
patchwork_emailconfirmation_id_seq,
patchwork_userprofile_id_seq,
- patchwork_userprofile_maintainer_projects_id_seq
+ patchwork_userprofile_maintainer_projects_id_seq,
+ patchwork_patchchangenotification_id_seq
TO "www-data";
-- allow the mail user (in this case, 'nobody') to add patches