add: implement proxy handling

[motion.git] / sql / from_3.sql

diff --git a/sql/from_3.sql b/sql/from_3.sql
new file mode 100644 (file)
index 0000000..7299f75
--- /dev/null
+++ b/sql/from_3.sql
@@ -0,0 +1,11 @@
+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);