X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=sql%2Fschema.sql;fp=sql%2Fschema.sql;h=290b9b32deb0b16e4f9fbfff8431b5eb14998d67;hb=224b4a836fd7588b653baf91b004a7ae62ec49c9;hp=116e76f79b9ca1a05e41247a90663115208c5f88;hpb=c164275cb983d523731b6346296bc256e1ff02bb;p=motion.git

diff --git a/sql/schema.sql b/sql/schema.sql
index 116e76f..290b9b3 100644
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -4,6 +4,7 @@ CREATE TABLE voter (id serial NOT NULL, email VARCHAR(255) NOT NULL, PRIMARY KEY
 
 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,
                    content text NOT NULL,
@@ -14,7 +15,7 @@ CREATE TABLE motion (id serial 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";