summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJan Dittberner <jandd@cacert.org>2017-04-15 19:23:05 +0200
committerJan Dittberner <jandd@cacert.org>2017-04-15 19:23:05 +0200
commit37c6f2efe60807b23d336f00a740acf7941757a4 (patch)
tree56e30c022437477c6d83cd19907b7a9c3f05e712
parent47b09aee9cf9daf2f2a3f2d3590b20839024499a (diff)
downloadcacert-boardvoting-37c6f2efe60807b23d336f00a740acf7941757a4.tar.gz
cacert-boardvoting-37c6f2efe60807b23d336f00a740acf7941757a4.tar.xz
cacert-boardvoting-37c6f2efe60807b23d336f00a740acf7941757a4.zip
Rewrap database.sql for better readability
-rw-r--r--database.sql35
1 files changed, 31 insertions, 4 deletions
diff --git a/database.sql b/database.sql
index 12e9b84..9c4bb34 100644
--- a/database.sql
+++ b/database.sql
@@ -1,4 +1,31 @@
-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 '');
+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 ''
+);