Added a "name" field to the mailing list entries.

[cocanwiki.git] / cocanwiki.sql

diff --git a/cocanwiki.sql b/cocanwiki.sql
index f6e4385..859eb4b 100644 (file)
--- 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';