add: implement proxy voting

[motion.git] / sql / from_4.sql

diff --git a/sql/from_4.sql b/sql/from_4.sql
new file mode 100644 (file)
index 0000000..cf1ce70
--- /dev/null
+++ b/sql/from_4.sql
@@ -0,0 +1,3 @@
+ALTER TABLE "vote" ADD COLUMN "proxy_id" INTEGER;
+UPDATE "vote" SET "proxy_id" = "voter_id";
+ALTER TABLE "vote" ALTER COLUMN "proxy_id" SET NOT NULL;