liquid_feedback_frontend

annotate db/vote-test.sql @ 135:02e24b4dd21c

find changesets by author, revision, files, or words in the commit message
fixes bug #50

make info clear that the user does not directly support a initiative but could support it by delegation
author Daniel Poelzleithner <poelzi@poelzi.org>
date Tue Oct 05 21:14:54 2010 +0200 (2010-10-05)
parents 3bfb2fcf7ab9
children
rev   line source
bsw/jbe@0 1 BEGIN;
bsw/jbe@0 2
bsw/jbe@0 3 INSERT INTO "member" ("login", "name", "ident_number") VALUES
bsw/jbe@0 4 ('bernd', 'Bernd', '002'),
bsw/jbe@0 5 ('cesar', 'Cesar', '003'),
bsw/jbe@0 6 ('doris', 'Doris', '004'),
bsw/jbe@0 7 ('emil', 'Emil', '005'),
bsw/jbe@0 8 ('frank', 'Frank', '006'),
bsw/jbe@0 9 ('gerhard', 'Gerhard', '007'),
bsw/jbe@0 10 ('hugo', 'Hugo', '008'),
bsw/jbe@0 11 ('ines', 'Ines', '009'),
bsw/jbe@0 12 ('johann', 'Johann', '010'),
bsw/jbe@0 13 ('klaus', 'Klaus', '011'),
bsw/jbe@0 14 ('lisa', 'Lisa', '012'),
bsw/jbe@0 15 ('monika', 'Monika', '013'),
bsw/jbe@0 16 ('norbert', 'Norbert', '014'),
bsw/jbe@0 17 ('olaf', 'Olaf', '015'),
bsw/jbe@0 18 ('peter', 'Peter', '016'),
bsw/jbe@0 19 ('quinn', 'Quinn', '017'),
bsw/jbe@0 20 ('ralf', 'Ralf', '018'),
bsw/jbe@0 21 ('sabine', 'Sabine', '019'),
bsw/jbe@0 22 ('tobias', 'Tobias', '020'),
bsw/jbe@0 23 ('ulla', 'Ulla', '021'),
bsw/jbe@0 24 ('vincent', 'Vincent', '022'),
bsw/jbe@0 25 ('wolfgang', 'Wolfgang', '023'),
bsw/jbe@0 26 ('xavier', 'Xavier', '024'),
bsw/jbe@0 27 ('yoko', 'Yoko', '025'),
bsw/jbe@0 28 ('zareb', 'Zareb', '026');
bsw/jbe@0 29
bsw/jbe@0 30 INSERT INTO "issue" ("area_id", "policy_id") VALUES (1, 3);
bsw/jbe@0 31 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #1');
bsw/jbe@0 32 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #2');
bsw/jbe@0 33 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #3');
bsw/jbe@0 34 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #4');
bsw/jbe@0 35 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #5');
bsw/jbe@0 36 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #6');
bsw/jbe@0 37 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #7');
bsw/jbe@0 38 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #8');
bsw/jbe@0 39 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #9');
bsw/jbe@0 40 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #10');
bsw/jbe@0 41 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #11');
bsw/jbe@0 42 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #12');
bsw/jbe@0 43 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #13');
bsw/jbe@0 44 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #14');
bsw/jbe@0 45 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #15');
bsw/jbe@0 46 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #16');
bsw/jbe@0 47 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #17');
bsw/jbe@0 48 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #18');
bsw/jbe@0 49 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #19');
bsw/jbe@0 50 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #20');
bsw/jbe@0 51 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #21');
bsw/jbe@0 52 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #22');
bsw/jbe@0 53 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #23');
bsw/jbe@0 54 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #24');
bsw/jbe@0 55 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #25');
bsw/jbe@0 56 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #26');
bsw/jbe@0 57 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #27');
bsw/jbe@0 58 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #28');
bsw/jbe@0 59 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #29');
bsw/jbe@0 60 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #30');
bsw/jbe@0 61
bsw/jbe@0 62 INSERT INTO "draft" ("initiative_id", "content") SELECT "id", 'Lorem ipsum ...' FROM "initiative";
bsw/jbe@0 63 INSERT INTO "initiator" ("member_id", "initiative_id") SELECT 1, "id" FROM "initiative";
bsw/jbe@0 64 INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") SELECT "member"."id", "initiative"."id", "initiative"."id" FROM "member", "initiative";
bsw/jbe@0 65
bsw/jbe@0 66 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 1, 1);
bsw/jbe@0 67 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 2, 2);
bsw/jbe@0 68 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 3, 3);
bsw/jbe@0 69 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 4, 4);
bsw/jbe@0 70 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 5, 5);
bsw/jbe@0 71 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 6, 6);
bsw/jbe@0 72 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 7, 7);
bsw/jbe@0 73 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 8, 8);
bsw/jbe@0 74 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 9, 9);
bsw/jbe@0 75 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 10, 10);
bsw/jbe@0 76 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 11, 11);
bsw/jbe@0 77 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 12, 12);
bsw/jbe@0 78 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 13, 13);
bsw/jbe@0 79 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 14, 14);
bsw/jbe@0 80 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 15, 15);
bsw/jbe@0 81 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 16, 16);
bsw/jbe@0 82 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 17, 17);
bsw/jbe@0 83 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 18, 18);
bsw/jbe@0 84 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 19, 19);
bsw/jbe@0 85 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 20, 20);
bsw/jbe@0 86 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 21, 21);
bsw/jbe@0 87 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 22, 22);
bsw/jbe@0 88 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 23, 23);
bsw/jbe@0 89 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 24, 24);
bsw/jbe@0 90 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 25, 25);
bsw/jbe@0 91 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 26, 26);
bsw/jbe@0 92 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 27, 27);
bsw/jbe@0 93 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 28, 28);
bsw/jbe@0 94 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 29, 29);
bsw/jbe@0 95 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 30, 30);
bsw/jbe@0 96
bsw/jbe@0 97 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 1, 2);
bsw/jbe@0 98 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 2, 1);
bsw/jbe@0 99 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 3, 3);
bsw/jbe@0 100 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 4, 4);
bsw/jbe@0 101 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 5, 5);
bsw/jbe@0 102 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 6, 6);
bsw/jbe@0 103 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 7, 7);
bsw/jbe@0 104 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 8, 8);
bsw/jbe@0 105 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 9, 9);
bsw/jbe@0 106 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 10, 10);
bsw/jbe@0 107 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 11, 11);
bsw/jbe@0 108 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 12, 12);
bsw/jbe@0 109 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 13, 13);
bsw/jbe@0 110 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 14, 14);
bsw/jbe@0 111 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 15, 15);
bsw/jbe@0 112 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 16, 16);
bsw/jbe@0 113 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 17, 17);
bsw/jbe@0 114 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 18, 18);
bsw/jbe@0 115 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 19, 19);
bsw/jbe@0 116 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 20, 20);
bsw/jbe@0 117 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 21, 21);
bsw/jbe@0 118 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 22, 22);
bsw/jbe@0 119 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 23, 23);
bsw/jbe@0 120 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 24, 24);
bsw/jbe@0 121 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 25, 25);
bsw/jbe@0 122 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 26, 26);
bsw/jbe@0 123 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 27, 27);
bsw/jbe@0 124 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 28, 28);
bsw/jbe@0 125 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 29, 29);
bsw/jbe@0 126 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 30, 30);
bsw/jbe@0 127
bsw/jbe@0 128
bsw/jbe@0 129 SELECT check_issues();
bsw/jbe@0 130 UPDATE issue SET frozen = now();
bsw/jbe@0 131
bsw/jbe@0 132 END;
bsw/jbe@0 133
bsw/jbe@0 134 -- UPDATE issue SET closed = now();

Impressum / About Us