liquid_feedback_frontend

diff db/vote-test.sql @ 0:3bfb2fcf7ab9

find changesets by author, revision, files, or words in the commit message
Version alpha1
author bsw/jbe
date Wed Nov 18 12:00:00 2009 +0100 (2009-11-18)
parents
children
line diff
     1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/db/vote-test.sql	Wed Nov 18 12:00:00 2009 +0100
     1.3 @@ -0,0 +1,134 @@
     1.4 +BEGIN;
     1.5 +
     1.6 +INSERT INTO "member" ("login", "name", "ident_number") VALUES
     1.7 +  ('bernd',    'Bernd',    '002'),
     1.8 +  ('cesar',    'Cesar',    '003'),
     1.9 +  ('doris',    'Doris',    '004'),
    1.10 +  ('emil',     'Emil',     '005'),
    1.11 +  ('frank',    'Frank',    '006'),
    1.12 +  ('gerhard',  'Gerhard',  '007'),
    1.13 +  ('hugo',     'Hugo',     '008'),
    1.14 +  ('ines',     'Ines',     '009'),
    1.15 +  ('johann',   'Johann',   '010'),
    1.16 +  ('klaus',    'Klaus',    '011'),
    1.17 +  ('lisa',     'Lisa',     '012'),
    1.18 +  ('monika',   'Monika',   '013'),
    1.19 +  ('norbert',  'Norbert',  '014'),
    1.20 +  ('olaf',     'Olaf',     '015'),
    1.21 +  ('peter',    'Peter',    '016'),
    1.22 +  ('quinn',    'Quinn',    '017'),
    1.23 +  ('ralf',     'Ralf',     '018'),
    1.24 +  ('sabine',   'Sabine',   '019'),
    1.25 +  ('tobias',   'Tobias',   '020'),
    1.26 +  ('ulla',     'Ulla',     '021'),
    1.27 +  ('vincent',  'Vincent',  '022'),
    1.28 +  ('wolfgang', 'Wolfgang', '023'),
    1.29 +  ('xavier',   'Xavier',   '024'),
    1.30 +  ('yoko',     'Yoko',     '025'),
    1.31 +  ('zareb',    'Zareb',    '026');
    1.32 +
    1.33 +INSERT INTO "issue" ("area_id", "policy_id") VALUES (1, 3);
    1.34 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #1');
    1.35 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #2');
    1.36 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #3');
    1.37 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #4');
    1.38 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #5');
    1.39 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #6');
    1.40 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #7');
    1.41 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #8');
    1.42 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #9');
    1.43 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #10');
    1.44 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #11');
    1.45 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #12');
    1.46 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #13');
    1.47 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #14');
    1.48 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #15');
    1.49 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #16');
    1.50 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #17');
    1.51 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #18');
    1.52 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #19');
    1.53 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #20');
    1.54 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #21');
    1.55 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #22');
    1.56 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #23');
    1.57 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #24');
    1.58 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #25');
    1.59 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #26');
    1.60 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #27');
    1.61 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #28');
    1.62 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #29');
    1.63 +INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #30');
    1.64 +
    1.65 +INSERT INTO "draft" ("initiative_id", "content") SELECT "id", 'Lorem ipsum ...' FROM "initiative";
    1.66 +INSERT INTO "initiator" ("member_id", "initiative_id") SELECT 1, "id" FROM "initiative";
    1.67 +INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") SELECT "member"."id", "initiative"."id", "initiative"."id" FROM "member", "initiative";
    1.68 +
    1.69 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 1, 1);
    1.70 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 2, 2);
    1.71 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 3, 3);
    1.72 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 4, 4);
    1.73 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 5, 5);
    1.74 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 6, 6);
    1.75 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 7, 7);
    1.76 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 8, 8);
    1.77 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 9, 9);
    1.78 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 10, 10);
    1.79 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 11, 11);
    1.80 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 12, 12);
    1.81 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 13, 13);
    1.82 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 14, 14);
    1.83 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 15, 15);
    1.84 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 16, 16);
    1.85 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 17, 17);
    1.86 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 18, 18);
    1.87 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 19, 19);
    1.88 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 20, 20);
    1.89 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 21, 21);
    1.90 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 22, 22);
    1.91 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 23, 23);
    1.92 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 24, 24);
    1.93 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 25, 25);
    1.94 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 26, 26);
    1.95 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 27, 27);
    1.96 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 28, 28);
    1.97 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 29, 29);
    1.98 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 30, 30);
    1.99 +
   1.100 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 1, 2);
   1.101 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 2, 1);
   1.102 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 3, 3);
   1.103 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 4, 4);
   1.104 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 5, 5);
   1.105 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 6, 6);
   1.106 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 7, 7);
   1.107 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 8, 8);
   1.108 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 9, 9);
   1.109 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 10, 10);
   1.110 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 11, 11);
   1.111 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 12, 12);
   1.112 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 13, 13);
   1.113 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 14, 14);
   1.114 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 15, 15);
   1.115 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 16, 16);
   1.116 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 17, 17);
   1.117 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 18, 18);
   1.118 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 19, 19);
   1.119 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 20, 20);
   1.120 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 21, 21);
   1.121 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 22, 22);
   1.122 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 23, 23);
   1.123 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 24, 24);
   1.124 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 25, 25);
   1.125 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 26, 26);
   1.126 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 27, 27);
   1.127 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 28, 28);
   1.128 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 29, 29);
   1.129 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 30, 30);
   1.130 +
   1.131 +
   1.132 +SELECT check_issues();
   1.133 +UPDATE issue SET frozen = now();
   1.134 +
   1.135 +END;
   1.136 +
   1.137 +-- UPDATE issue SET closed = now();

Impressum / About Us