Merge branch 'css' into 'master'

[motion.git] / sql / schema.sql

diff --git a/sql/schema.sql b/sql/schema.sql
index 290b9b32deb0b16e4f9fbfff8431b5eb14998d67..cd47201bc863ba6eb894c6a3e9d7d041bf017e1f 100644 (file)
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -7,6 +7,7 @@ CREATE TABLE motion (id serial NOT NULL,
                    identifier VARCHAR(20) NOT NULL,
                    name VARCHAR(250) NOT NULL,
                    type VARCHAR(250) 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,
                    content text NOT NULL,
                    posed timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
                    posed_by int NOT NULL,


@@ -28,4 +29,4 @@ CREATE TABLE vote (motion_id INTEGER NOT NULL,
 
 DROP TABLE IF EXISTS schema_version;
 CREATE TABLE schema_version (version INTEGER NOT NULL);
 
 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);