DROP TABLE IF EXISTS motion;
CREATE TABLE motion (id serial NOT NULL,
+ identifier VARCHAR(20) NOT NULL,
name VARCHAR(250) NOT NULL,
type VARCHAR(250) NOT NULL,
+ host VARCHAR(500) NOT NULL,
content text NOT NULL,
posed timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
posed_by int NOT NULL,
cancelation_reason text NULL DEFAULT NULL,
canceled_by int NULL DEFAULT NULL,
PRIMARY KEY(id));
-
+CREATE UNIQUE INDEX motion_ident ON motion (identifier);
DROP TABLE IF EXISTS vote;
DROP TYPE IF EXISTS "vote_type";
DROP TABLE IF EXISTS schema_version;
CREATE TABLE schema_version (version INTEGER NOT NULL);
-INSERT INTO schema_version(version) VALUES(1);
+INSERT INTO schema_version(version) VALUES(3);