diff options
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 ''); |