X-Git-Url: https://code.wpia.club/?p=motion.git;a=blobdiff_plain;f=sql%2Fschema.sql;h=690425bdbcf697509ac116210c89fd62181190ee;hp=6e0bc561fc317131254f33a35ef1d010cc091d87;hb=1653400a1d07f3433e1f8e10f484de9f88593c3f;hpb=a2361dff44b3bf95ad7f367484b6bc805b22819d

diff --git a/sql/schema.sql b/sql/schema.sql
index 6e0bc56..690425b 100644
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -1,5 +1,8 @@
 DROP TABLE IF EXISTS voter;
-CREATE TABLE voter (id serial NOT NULL, email VARCHAR(255) NOT NULL, PRIMARY KEY(id));
+CREATE TABLE voter (id serial NOT NULL,
+                   email VARCHAR(255) NOT NULL,
+                   host VARCHAR(500) NOT NULL,
+                   PRIMARY KEY(id));
 
 
 DROP TABLE IF EXISTS motion;
@@ -42,4 +45,4 @@ CREATE INDEX proxy_proxy ON proxy (proxy_id);
 
 DROP TABLE IF EXISTS schema_version;
 CREATE TABLE schema_version (version INTEGER NOT NULL);
-INSERT INTO schema_version(version) VALUES(5);
+INSERT INTO schema_version(version) VALUES(6);