From 41f19b6643b44768dc06561c992c04ed6148477d Mon Sep 17 00:00:00 2001
From: Jeremy Kerr <jk@ozlabs.org>
Date: Wed, 11 Aug 2010 14:16:28 +0800
Subject: 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>
---
 lib/sql/grant-all.postgres.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'lib/sql/grant-all.postgres.sql')

diff --git a/lib/sql/grant-all.postgres.sql b/lib/sql/grant-all.postgres.sql
index 591ffd0..9b6c862 100644
--- a/lib/sql/grant-all.postgres.sql
+++ b/lib/sql/grant-all.postgres.sql
@@ -22,7 +22,8 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON
 	patchwork_project,
 	patchwork_bundle,
 	patchwork_bundlepatch,
-	patchwork_patch
+	patchwork_patch,
+	patchwork_emailoptout
 TO "www-data";
 GRANT SELECT, UPDATE ON
 	auth_group_id_seq,
-- 
cgit v1.2.3

