summaryrefslogtreecommitdiff
path: root/database.sql
diff options
context:
space:
mode:
Diffstat (limited to 'database.sql')
-rw-r--r--database.sql31
1 files changed, 0 insertions, 31 deletions
diff --git a/database.sql b/database.sql
deleted file mode 100644
index 9c4bb34..0000000
--- a/database.sql
+++ /dev/null
@@ -1,31 +0,0 @@
-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,
- reminder VARCHAR(255)
-);
-CREATE TABLE votes (
- decision INT4,
- voter INT4,
- vote INT4,
- voted DATETIME,
- notes TEXT DEFAULT ''
-);