X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=sql%2Fschema.sql;h=6e0bc561fc317131254f33a35ef1d010cc091d87;hb=0b469b5513c4b042a2e513ce5ec82dc379c78e11;hp=be4b3d2a0ac4cb94c2ea272dcbbeb130e0225ac0;hpb=e59274f6a108ec57931014e8fcb1319c63fa1f2d;p=motion.git

diff --git a/sql/schema.sql b/sql/schema.sql
index be4b3d2..6e0bc56 100644
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -25,6 +25,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 +42,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(5);