diff options
| author | Jeremy Kerr <jk@ozlabs.org> | 2010-08-11 14:16:28 +0800 |
|---|---|---|
| committer | Jeremy Kerr <jk@ozlabs.org> | 2011-04-14 17:23:04 +0800 |
| commit | 41f19b6643b44768dc06561c992c04ed6148477d (patch) | |
| tree | 6f1c3d1fbe5e15e53d3c028a8e654f05b19e68fb /lib/sql/grant-all.mysql.sql | |
| parent | c2c6a408c7764fa29389ce160f52776c9308d50a (diff) | |
| download | patchwork-41f19b6643b44768dc06561c992c04ed6148477d.tar.bz2 patchwork-41f19b6643b44768dc06561c992c04ed6148477d.tar.xz | |
Add email opt-out system
We're going to start generating emails on patchwork updates, so firstly
allow people to opt-out of all patchwork communications.
We do this with a 'mail settings' interface, allowing non-registered
users to set preferences on their email address. Logged-in users can do
this through the user profile view.
Signed-off-by: Jeremy Kerr <jk@ozlabs.org>
Diffstat (limited to 'lib/sql/grant-all.mysql.sql')
| -rw-r--r-- | lib/sql/grant-all.mysql.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/lib/sql/grant-all.mysql.sql b/lib/sql/grant-all.mysql.sql index a3d758c..c272e1e 100644 --- a/lib/sql/grant-all.mysql.sql +++ b/lib/sql/grant-all.mysql.sql @@ -22,6 +22,7 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_project TO 'www-data'@localhos GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_bundle TO 'www-data'@localhost; GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_bundle_patches TO 'www-data'@localhost; GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_patch TO 'www-data'@localhost; +GRANT SELECT, UPDATE, INSERT, DELETE ON patchwork_emailoptout TO 'www-data'@localhost; -- allow the mail user (in this case, 'nobody') to add patches GRANT INSERT, SELECT ON patchwork_patch TO 'nobody'@localhost; |