summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorcommunity.cacert.org <community.cacert.org@d4452222-2f33-11de-9270-010000000000>2009-06-12 05:09:35 +0000
committercommunity.cacert.org <community.cacert.org@d4452222-2f33-11de-9270-010000000000>2009-06-12 05:09:35 +0000
commit720d6b0a8b8a01f78f9f12da863a88b9a61fdab6 (patch)
tree91c57561991a6c67fa918d50e6c1c50127822545
parentb215c45070a79af876918200c3c08301600475b2 (diff)
downloadcacert-boardvoting-720d6b0a8b8a01f78f9f12da863a88b9a61fdab6.tar.gz
cacert-boardvoting-720d6b0a8b8a01f78f9f12da863a88b9a61fdab6.tar.xz
cacert-boardvoting-720d6b0a8b8a01f78f9f12da863a88b9a61fdab6.zip
fix schema documentation
git-svn-id: http://svn.cacert.cl/Software/Voting/vote@61 d4452222-2f33-11de-9270-010000000000
-rw-r--r--database.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/database.sql b/database.sql
index 8fcf88d..12e9b84 100644
--- a/database.sql
+++ b/database.sql
@@ -1,4 +1,4 @@
-CREATE TABLE decisions (id INTEGER PRIMARY KEY, proposed DATETIME, proponent INTEGER, title VARCHAR(255), content TEXT, status INTEGER, due DATETIME, modified DATETIME, tag varchar(255), votetype INT4 DEFAULT 0 NOT NULL);
+CREATE TABLE decisions (id INTEGER PRIMARY KEY, proposed DATETIME, proponent INTEGER, title VARCHAR(255), content TEXT, quorum INTEGER, majority INTEGER, status INTEGER, due DATETIME, modified DATETIME, tag varchar(255), votetype INT4 DEFAULT 0 NOT NULL);
CREATE TABLE emails (voter INT4, address VARCHAR(255));
-CREATE TABLE voters (id INTEGER PRIMARY KEY, name VARCHAR(255), enabled INTEGER default 0);
+CREATE TABLE voters (id INTEGER PRIMARY KEY, name VARCHAR(255), enabled INTEGER default 0, reminder VARCHAR(255));
CREATE TABLE votes (decision INT4, voter INT4, vote INT4, voted DATETIME, notes text default '');