1 DROP TABLE IF EXISTS voter;
2 CREATE TABLE voter (id serial NOT NULL, email VARCHAR(255) NOT NULL, PRIMARY KEY(id));
5 DROP TABLE IF EXISTS motion;
6 CREATE TABLE motion (id serial NOT NULL,
7 name VARCHAR(250) NOT NULL,
8 type VARCHAR(250) NOT NULL,
10 posed timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
11 posed_by int NOT NULL,
12 deadline timestamp NOT NULL DEFAULT (CURRENT_TIMESTAMP + interval '3 days'),
13 canceled timestamp NULL DEFAULT NULL,
14 cancelation_reason text NULL DEFAULT NULL,
15 canceled_by int NULL DEFAULT NULL,
19 DROP TABLE IF EXISTS vote;
20 DROP TYPE IF EXISTS "vote_type";
21 CREATE TYPE "vote_type" AS ENUM ('yes', 'no', 'abstain');
22 CREATE TABLE vote (motion_id INTEGER NOT NULL,
23 voter_id INTEGER NOT NULL,
24 result vote_type NOT NULL,
25 entered timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
26 PRIMARY KEY(motion_id, voter_id));
28 DROP TABLE IF EXISTS schema_version;
29 CREATE TABLE schema_version (version INTEGER NOT NULL);
30 INSERT INTO schema_version(version) VALUES(1);