X-Git-Url: http://git.annexia.org/?a=blobdiff_plain;f=cocanwiki.sql;h=859eb4b94e4614aef388a9417b3b4e18e437263a;hb=f33343df3525e01f05ecf80628cd46b6e5841001;hp=f6e43852c1ec2e48ce1ecd75f32b12917fe595ad;hpb=50f72e5597bef62747f462d26cae836c7c9ee6b9;p=cocanwiki.git

diff --git a/cocanwiki.sql b/cocanwiki.sql
index f6e4385..859eb4b 100644
--- a/cocanwiki.sql
+++ b/cocanwiki.sql
@@ -499,7 +499,8 @@ CREATE TABLE mailing_lists (
     email text NOT NULL,
     entry_date date DEFAULT ('now'::text)::date NOT NULL,
     pending text,
-    opt_out text NOT NULL
+    opt_out text NOT NULL,
+    name text NOT NULL
 );
 
 
@@ -509,7 +510,7 @@ CREATE TABLE mailing_lists (
 --
 
 REVOKE ALL ON TABLE mailing_lists FROM PUBLIC;
-GRANT SELECT ON TABLE mailing_lists TO "www-data";
+GRANT ALL ON TABLE mailing_lists TO "www-data";
 
 
 SET SESSION AUTHORIZATION 'rich';