add: user management

[motion.git] / schema.sql

diff --git a/schema.sql b/schema.sql
index b3a6eaff4fc108db7b00420cbf0949859a8cd8aa..ed0d87671c5f38a52da91a234081693425003b02 100644 (file)
--- 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,