X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=sql%2Fsample_data.sql;h=6b8054ee1f14b0106478b1a2e118d69ad5e402d8;hb=refs%2Fheads%2Fmaster;hp=fd762be112631233ab930418e6cdee68f6b7e262;hpb=a7b623959e195264ead5cc778aa4653dff75668f;p=motion.git

diff --git a/sql/sample_data.sql b/sql/sample_data.sql
index fd762be..6b8054e 100644
--- a/sql/sample_data.sql
+++ b/sql/sample_data.sql
@@ -1,7 +1,7 @@
--- sample data for scheme version 3
-INSERT INTO voter (id,email) VALUES (1, 'User A');
-INSERT INTO voter (id,email) VALUES (2, 'User B');
-INSERT INTO voter (id,email) VALUES (3, 'User C');
+-- sample data for scheme version 6
+INSERT INTO voter (id,email, host) VALUES (1, 'User A', '127.0.0.1:5000');
+INSERT INTO voter (id,email, host) VALUES (2, 'User B', '127.0.0.1:5000');
+INSERT INTO voter (id,email, host) VALUES (3, 'User C', '127.0.0.1:5000');
 ALTER SEQUENCE voter_id_seq RESTART WITH 4;
 
 INSERT INTO motion (id,identifier,name,type,host,content,posed,posed_by,deadline,canceled,cancelation_reason,canceled_by) VALUES
@@ -15,10 +15,10 @@ INSERT INTO motion (id,identifier,name,type,host,content,posed,posed_by,deadline
     (4,'g1.20200402.004','Motion D','group1','127.0.0.1:5000','A fourth motion', current_timestamp ,1,current_timestamp + interval '1' day,Null,Null,Null);
 ALTER SEQUENCE motion_id_seq RESTART WITH 5;
 
-INSERT INTO vote (motion_id,voter_id,result,entered) VALUES (1,1,'yes','2020-04-02 21:54:34.469784');
-INSERT INTO vote (motion_id,voter_id,result,entered) VALUES (1,2,'yes','2020-04-02 21:54:34.469784');
-INSERT INTO vote (motion_id,voter_id,result,entered) VALUES (1,3,'no','2020-04-02 21:54:34.469784');
-INSERT INTO vote (motion_id,voter_id,result,entered) VALUES (2,1,'yes','2020-04-02 21:54:34.469784');
-INSERT INTO vote (motion_id,voter_id,result,entered) VALUES (2,2,'no','2020-04-02 21:54:34.469784');
-INSERT INTO vote (motion_id,voter_id,result,entered) VALUES (2,3,'no','2020-04-02 21:54:34.469784');
-INSERT INTO vote (motion_id,voter_id,result,entered) VALUES (3,3,'yes','2020-04-02 21:48:34.469784');
+INSERT INTO vote (motion_id,voter_id,proxy_id,result,entered) VALUES (1,1,1,'yes','2020-04-02 21:54:34.469784');
+INSERT INTO vote (motion_id,voter_id,proxy_id,result,entered) VALUES (1,2,2,'yes','2020-04-02 21:54:34.469784');
+INSERT INTO vote (motion_id,voter_id,proxy_id,result,entered) VALUES (1,3,2,'no','2020-04-02 21:54:34.469784');
+INSERT INTO vote (motion_id,voter_id,proxy_id,result,entered) VALUES (2,1,1,'yes','2020-04-02 21:54:34.469784');
+INSERT INTO vote (motion_id,voter_id,proxy_id,result,entered) VALUES (2,2,2,'no','2020-04-02 21:54:34.469784');
+INSERT INTO vote (motion_id,voter_id,proxy_id,result,entered) VALUES (2,3,3,'no','2020-04-02 21:54:34.469784');
+INSERT INTO vote (motion_id,voter_id,proxy_id,result,entered) VALUES (3,3,3,'yes','2020-04-02 21:48:34.469784');