liquid_feedback_frontend

view db/vote-test.sql @ 6:8d91bccab0bf

find changesets by author, revision, files, or words in the commit message
Version beta2

Possibility to browse voters of a closed issue

Registration with invite code

Email confirmation and password recovery

Download function (for database dumps) added

Critical bug solved, which made it impossible to select your opinion on other peoples suggestions

Catching error, when trying to set an opinion on a suggestion which has been meanwhile deleted

Fixed wrong sorting order for "supporters" or "potential supporters"

Added format info for birthday (Error when entering dates in wrong format is NOT fixed in this release)

Strip space characters from certain fields and ensure they contain at least 3 characters

Showing grade in opinion/list as clear text instead of integer value

More information on initiative is displayed while voting

Colored notification box shown on pages of issues or initiatives which are currently in voting state

Changed default filter for issues to "Open"

Back link on suggestion page

Some optical changes

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

Impressum / About Us