blob: 8fcf88d6c93cafb75f38ff055de5f8bdd7eb38b4 (
plain)
1
2
3
4
|
CREATE TABLE decisions (id INTEGER PRIMARY KEY, proposed DATETIME, proponent INTEGER, title VARCHAR(255), content TEXT, 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);
CREATE TABLE votes (decision INT4, voter INT4, vote INT4, voted DATETIME, notes text default '');
|
