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

diff --git a/sql/schema.sql b/sql/schema.sql
index 290b9b3..cd47201 100644
--- 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,
+                   host VARCHAR(500) 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);
-INSERT INTO schema_version(version) VALUES(1);
+INSERT INTO schema_version(version) VALUES(3);