X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=sql%2Fschema.sql;h=6e0bc561fc317131254f33a35ef1d010cc091d87;hb=07f80f37659dd3fc0abd112ab6f0fe350ef47ade;hp=cd47201bc863ba6eb894c6a3e9d7d041bf017e1f;hpb=ed68455e7daed0df5bc856110174e874ee721d9e;p=motion.git

diff --git a/sql/schema.sql b/sql/schema.sql
index cd47201..6e0bc56 100644
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -25,8 +25,21 @@ 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;
+CREATE TABLE proxy (id serial NOT NULL,
+                   voter_id INTEGER NOT NULL,
+                   proxy_id INTEGER NOT NULL,
+                   granted timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+                   granted_by int NOT NULL,
+                   revoked timestamp NULL DEFAULT NULL,
+                   revoked_by int NULL DEFAULT NULL,
+                   PRIMARY KEY(id));
+CREATE INDEX proxy_voter ON proxy (voter_id);
+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(3);
+INSERT INTO schema_version(version) VALUES(5);