summaryrefslogtreecommitdiff
path: root/database.sql
blob: 9c4bb34a588d3879b2d2ce578866907e6a0c61f1 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
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 ''
);