add: adjust user handling per host

[motion.git] / sql / schema.sql

diff --git a/sql/schema.sql b/sql/schema.sql
index be4b3d2a0ac4cb94c2ea272dcbbeb130e0225ac0..690425bdbcf697509ac116210c89fd62181190ee 100644 (file)
--- 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;
@@ -25,6 +28,7 @@ CREATE TABLE vote (motion_id INTEGER NOT NULL,
                  voter_id INTEGER NOT NULL,
                  result vote_type NOT NULL,
                  entered timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+                 proxy_id INTEGER NOT NULL,
                  PRIMARY KEY(motion_id, voter_id));
 
 DROP TABLE IF EXISTS proxy;
@@ -41,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(4);
+INSERT INTO schema_version(version) VALUES(6);