diff options
| author | community.cacert.org <community.cacert.org@d4452222-2f33-11de-9270-010000000000> | 2009-05-27 05:39:41 +0000 |
|---|---|---|
| committer | community.cacert.org <community.cacert.org@d4452222-2f33-11de-9270-010000000000> | 2009-05-27 05:39:41 +0000 |
| commit | 4ce4fa2e05b3a1a0dd56996ef5b540196c96760a (patch) | |
| tree | 7bf639cf62e1e9023bca7dd652d2ab109bf42eb3 /database.sql | |
| parent | 2877a513fed891d90878f0f672b67f2582ab48e8 (diff) | |
| download | cacert-boardvoting-4ce4fa2e05b3a1a0dd56996ef5b540196c96760a.tar.gz cacert-boardvoting-4ce4fa2e05b3a1a0dd56996ef5b540196c96760a.tar.xz cacert-boardvoting-4ce4fa2e05b3a1a0dd56996ef5b540196c96760a.zip | |
add empty SQL structure. Add links to single entities
git-svn-id: http://svn.cacert.cl/Software/Voting/vote@41 d4452222-2f33-11de-9270-010000000000
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/database.sql b/database.sql new file mode 100644 index 0000000..bf5b801 --- /dev/null +++ b/database.sql @@ -0,0 +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 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 ''); |