bf5b80188f7f71bd83cfa71a9d7d127e1a938be0
1 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));
2 CREATE TABLE emails (voter INT4
, address
VARCHAR(255));
3 CREATE TABLE voters (id INTEGER PRIMARY KEY, name VARCHAR(255), enabled
INTEGER default 0);
4 CREATE TABLE votes (decision INT4
, voter INT4
, vote INT4
, voted DATETIME
, notes
text default '');