diff options
| author | community.cacert.org <community.cacert.org@d4452222-2f33-11de-9270-010000000000> | 2009-05-30 02:57:39 +0000 |
|---|---|---|
| committer | community.cacert.org <community.cacert.org@d4452222-2f33-11de-9270-010000000000> | 2009-05-30 02:57:39 +0000 |
| commit | 2538da0568066676379b68e13278340147db76c7 (patch) | |
| tree | 81a361d4191c451ca9c756c2188ba3afd19ab106 /database.sql | |
| parent | f7e4cbc5105c8c33d61a1bbf8047ebc13d092913 (diff) | |
| download | cacert-boardvoting-2538da0568066676379b68e13278340147db76c7.tar.gz cacert-boardvoting-2538da0568066676379b68e13278340147db76c7.tar.xz cacert-boardvoting-2538da0568066676379b68e13278340147db76c7.zip | |
voting types now all implemented. majority and quorum removed from database
git-svn-id: http://svn.cacert.cl/Software/Voting/vote@52 d4452222-2f33-11de-9270-010000000000
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/database.sql b/database.sql index 33386c1..8fcf88d 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), votetype INT4 DEFAULT 0 NOT NULL); +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 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 ''); |