summaryrefslogtreecommitdiff
path: root/database.sql
diff options
context:
space:
mode:
authorJan Dittberner <jandd@cacert.org>2017-04-21 14:50:34 +0200
committerJan Dittberner <jan@dittberner.info>2017-04-22 00:14:35 +0200
commitc6b1435875594ad568116da1c6ef1b27cb2f2ffe (patch)
tree17962c50dfed3d7a0b579bf969cc34a5aa5b941e /database.sql
parentdad5d581585def23a25a9f54faab2691ccb1fb95 (diff)
downloadcacert-boardvoting-c6b1435875594ad568116da1c6ef1b27cb2f2ffe.tar.gz
cacert-boardvoting-c6b1435875594ad568116da1c6ef1b27cb2f2ffe.tar.xz
cacert-boardvoting-c6b1435875594ad568116da1c6ef1b27cb2f2ffe.zip
Add goose database migrations
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 ''
-);