summaryrefslogtreecommitdiff
path: root/database.sql
diff options
context:
space:
mode:
authorcommunity.cacert.org <community.cacert.org@d4452222-2f33-11de-9270-010000000000>2009-05-30 02:08:30 +0000
committercommunity.cacert.org <community.cacert.org@d4452222-2f33-11de-9270-010000000000>2009-05-30 02:08:30 +0000
commitf7e4cbc5105c8c33d61a1bbf8047ebc13d092913 (patch)
treec25b17745472db174c3754b57c6ab1cd68ec3ae6 /database.sql
parentcbb2a993d4644871aff1db8218f69beb701684a7 (diff)
downloadcacert-boardvoting-f7e4cbc5105c8c33d61a1bbf8047ebc13d092913.tar.gz
cacert-boardvoting-f7e4cbc5105c8c33d61a1bbf8047ebc13d092913.tar.xz
cacert-boardvoting-f7e4cbc5105c8c33d61a1bbf8047ebc13d092913.zip
add 28 day due option. authenticate proponent properly. prepare for static list of vote types
git-svn-id: http://svn.cacert.cl/Software/Voting/vote@51 d4452222-2f33-11de-9270-010000000000
Diffstat (limited to 'database.sql')
-rw-r--r--database.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/database.sql b/database.sql
index bf5b801..33386c1 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, quorum INTEGER, majority INTEGER, status INTEGER, due DATETIME, modified DATETIME, tag varchar(255));
+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 votes (decision INT4, voter INT4, vote INT4, voted DATETIME, notes text default '');