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

[cocanwiki.git] / cocanwiki.sql

diff --git a/cocanwiki.sql b/cocanwiki.sql
index 212e74e..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
 );