Implement motion editing
[cacert-boardvoting.git] / database.sql
1 CREATE TABLE decisions (
2 id INTEGER PRIMARY KEY,
3 proposed DATETIME,
4 proponent INTEGER,
5 title VARCHAR(255),
6 content TEXT,
7 quorum INTEGER,
8 majority INTEGER,
9 status INTEGER,
10 due DATETIME,
11 modified DATETIME,
12 tag VARCHAR(255),
13 votetype INT4 DEFAULT 0 NOT NULL
14 );
15 CREATE TABLE emails (
16 voter INT4,
17 address VARCHAR(255)
18 );
19 CREATE TABLE voters (
20 id INTEGER PRIMARY KEY,
21 name VARCHAR(255),
22 enabled INTEGER DEFAULT 0,
23 reminder VARCHAR(255)
24 );
25 CREATE TABLE votes (
26 decision INT4,
27 voter INT4,
28 vote INT4,
29 voted DATETIME,
30 notes TEXT DEFAULT ''
31 );