X-Git-Url: http://www.controwiki.de/?a=blobdiff_plain;f=schema.sql;h=ed0d87671c5f38a52da91a234081693425003b02;hb=fb14879eed07a490aab3a9263db29e4a0323ae41;hp=b3a6eaff4fc108db7b00420cbf0949859a8cd8aa;hpb=331c032b348bae85ea18da328b12b1d9de172dd3;p=motion.git

diff --git a/schema.sql b/schema.sql
index b3a6eaf..ed0d876 100644
--- a/schema.sql
+++ b/schema.sql
@@ -5,6 +5,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,
                    name VARCHAR(250) NOT NULL,
+                   type VARCHAR(250) NOT NULL,
                    content text NOT NULL,
                    posed timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
                    posed_by int NOT NULL,