rev |
line source |
jbe@0
|
1 -- NOTE: This file requires that sequence generators have not been used.
|
jbe@0
|
2 -- (All new rows need to start with id '1'.)
|
jbe@0
|
3
|
jbe@0
|
4 BEGIN;
|
jbe@0
|
5
|
jbe@333
|
6 -- set transaction isolation level to be able to call "check_everything"() function
|
jbe@333
|
7 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
|
jbe@333
|
8
|
jbe@184
|
9 INSERT INTO "member" ("activated", "last_activity", "active", "login", "name") VALUES
|
jbe@184
|
10 ('now', 'now', TRUE, 'user1', 'User #1'), -- id 1
|
jbe@184
|
11 ('now', 'now', TRUE, 'user2', 'User #2'), -- id 2
|
jbe@184
|
12 ('now', 'now', TRUE, 'user3', 'User #3'), -- id 3
|
jbe@184
|
13 ('now', 'now', TRUE, 'user4', 'User #4'), -- id 4
|
jbe@184
|
14 ('now', 'now', TRUE, 'user5', 'User #5'), -- id 5
|
jbe@184
|
15 ('now', 'now', TRUE, 'user6', 'User #6'), -- id 6
|
jbe@184
|
16 ('now', 'now', TRUE, 'user7', 'User #7'), -- id 7
|
jbe@184
|
17 ('now', 'now', TRUE, 'user8', 'User #8'), -- id 8
|
jbe@184
|
18 ('now', 'now', TRUE, 'user9', 'User #9'), -- id 9
|
jbe@184
|
19 ('now', 'now', TRUE, 'user10', 'User #10'), -- id 10
|
jbe@184
|
20 ('now', 'now', TRUE, 'user11', 'User #11'), -- id 11
|
jbe@184
|
21 ('now', 'now', TRUE, 'user12', 'User #12'), -- id 12
|
jbe@184
|
22 ('now', 'now', TRUE, 'user13', 'User #13'), -- id 13
|
jbe@184
|
23 ('now', 'now', TRUE, 'user14', 'User #14'), -- id 14
|
jbe@184
|
24 ('now', 'now', TRUE, 'user15', 'User #15'), -- id 15
|
jbe@184
|
25 ('now', 'now', TRUE, 'user16', 'User #16'), -- id 16
|
jbe@184
|
26 ('now', 'now', TRUE, 'user17', 'User #17'), -- id 17
|
jbe@184
|
27 ('now', 'now', TRUE, 'user18', 'User #18'), -- id 18
|
jbe@184
|
28 ('now', 'now', TRUE, 'user19', 'User #19'), -- id 19
|
jbe@184
|
29 ('now', 'now', TRUE, 'user20', 'User #20'), -- id 20
|
jbe@184
|
30 ('now', 'now', TRUE, 'user21', 'User #21'), -- id 21
|
jbe@184
|
31 ('now', 'now', TRUE, 'user22', 'User #22'), -- id 22
|
jbe@184
|
32 ('now', 'now', TRUE, 'user23', 'User #23'); -- id 23
|
jbe@0
|
33
|
poelzi@77
|
34 -- set password to "login"
|
poelzi@77
|
35 UPDATE "member" SET "password" = '$1$PcI6b1Bg$2SHjAZH2nMLFp0fxHis.Q0';
|
jbe@0
|
36
|
jbe@0
|
37 INSERT INTO "policy" (
|
jbe@155
|
38 "index",
|
jbe@155
|
39 "name",
|
jbe@155
|
40 "admission_time",
|
jbe@155
|
41 "discussion_time",
|
jbe@155
|
42 "verification_time",
|
jbe@155
|
43 "voting_time",
|
jbe@155
|
44 "issue_quorum_num", "issue_quorum_den",
|
jbe@155
|
45 "initiative_quorum_num", "initiative_quorum_den",
|
jbe@167
|
46 "direct_majority_num", "direct_majority_den", "direct_majority_strict",
|
jbe@304
|
47 "no_reverse_beat_path", "no_multistage_majority"
|
jbe@155
|
48 ) VALUES (
|
jbe@155
|
49 1,
|
jbe@155
|
50 'Default policy',
|
jbe@155
|
51 '1 hour', '1 hour', '1 hour', '1 hour',
|
jbe@155
|
52 25, 100,
|
jbe@155
|
53 20, 100,
|
jbe@155
|
54 1, 2, TRUE,
|
jbe@304
|
55 TRUE, FALSE );
|
jbe@0
|
56
|
jbe@3
|
57 CREATE FUNCTION "time_warp"() RETURNS VOID
|
jbe@3
|
58 LANGUAGE 'plpgsql' VOLATILE AS $$
|
jbe@3
|
59 BEGIN
|
jbe@3
|
60 UPDATE "issue" SET
|
jbe@3
|
61 "snapshot" = "snapshot" - '1 hour 1 minute'::INTERVAL,
|
jbe@3
|
62 "created" = "created" - '1 hour 1 minute'::INTERVAL,
|
jbe@3
|
63 "accepted" = "accepted" - '1 hour 1 minute'::INTERVAL,
|
jbe@3
|
64 "half_frozen" = "half_frozen" - '1 hour 1 minute'::INTERVAL,
|
jbe@3
|
65 "fully_frozen" = "fully_frozen" - '1 hour 1 minute'::INTERVAL;
|
jbe@3
|
66 PERFORM "check_everything"();
|
jbe@3
|
67 RETURN;
|
jbe@3
|
68 END;
|
jbe@3
|
69 $$;
|
jbe@3
|
70
|
jbe@97
|
71 INSERT INTO "unit" ("name") VALUES ('Main');
|
jbe@97
|
72
|
jbe@97
|
73 INSERT INTO "privilege" ("unit_id", "member_id", "voting_right")
|
jbe@97
|
74 SELECT 1 AS "unit_id", "id" AS "member_id", TRUE AS "voting_right"
|
jbe@97
|
75 FROM "member";
|
jbe@97
|
76
|
jbe@97
|
77 INSERT INTO "area" ("unit_id", "name") VALUES
|
jbe@97
|
78 (1, 'Area #1'), -- id 1
|
jbe@97
|
79 (1, 'Area #2'), -- id 2
|
jbe@97
|
80 (1, 'Area #3'), -- id 3
|
jbe@97
|
81 (1, 'Area #4'); -- id 4
|
jbe@0
|
82
|
jbe@9
|
83 INSERT INTO "allowed_policy" ("area_id", "policy_id", "default_policy")
|
jbe@9
|
84 VALUES (1, 1, TRUE), (2, 1, TRUE), (3, 1, TRUE), (4, 1, TRUE);
|
jbe@9
|
85
|
jbe@169
|
86 INSERT INTO "membership" ("area_id", "member_id") VALUES
|
jbe@169
|
87 (1, 9),
|
jbe@169
|
88 (1, 19),
|
jbe@169
|
89 (2, 9),
|
jbe@169
|
90 (2, 10),
|
jbe@169
|
91 (2, 17),
|
jbe@169
|
92 (3, 9),
|
jbe@169
|
93 (3, 11),
|
jbe@169
|
94 (3, 12),
|
jbe@169
|
95 (3, 14),
|
jbe@169
|
96 (3, 20),
|
jbe@169
|
97 (3, 21),
|
jbe@169
|
98 (3, 22),
|
jbe@169
|
99 (4, 6),
|
jbe@169
|
100 (4, 9),
|
jbe@169
|
101 (4, 13),
|
jbe@169
|
102 (4, 22);
|
jbe@0
|
103
|
jbe@0
|
104 -- global delegations
|
jbe@0
|
105 INSERT INTO "delegation"
|
jbe@97
|
106 ("truster_id", "scope", "unit_id", "trustee_id") VALUES
|
jbe@97
|
107 ( 1, 'unit', 1, 9),
|
jbe@97
|
108 ( 2, 'unit', 1, 11),
|
jbe@97
|
109 ( 3, 'unit', 1, 12),
|
jbe@97
|
110 ( 4, 'unit', 1, 13),
|
jbe@97
|
111 ( 5, 'unit', 1, 14),
|
jbe@97
|
112 ( 6, 'unit', 1, 7),
|
jbe@97
|
113 ( 7, 'unit', 1, 8),
|
jbe@97
|
114 ( 8, 'unit', 1, 6),
|
jbe@97
|
115 (10, 'unit', 1, 9),
|
jbe@97
|
116 (11, 'unit', 1, 9),
|
jbe@97
|
117 (12, 'unit', 1, 21),
|
jbe@97
|
118 (15, 'unit', 1, 10),
|
jbe@97
|
119 (16, 'unit', 1, 17),
|
jbe@97
|
120 (17, 'unit', 1, 19),
|
jbe@97
|
121 (18, 'unit', 1, 19),
|
jbe@97
|
122 (23, 'unit', 1, 22);
|
jbe@0
|
123
|
jbe@0
|
124 -- delegations for topics
|
jbe@0
|
125 INSERT INTO "delegation"
|
jbe@10
|
126 ("area_id", "truster_id", "scope", "trustee_id") VALUES
|
jbe@304
|
127 (1, 3, 'area', 17),
|
jbe@10
|
128 (2, 5, 'area', 10),
|
jbe@10
|
129 (2, 9, 'area', 10),
|
jbe@10
|
130 (3, 4, 'area', 14),
|
jbe@10
|
131 (3, 16, 'area', 20),
|
jbe@10
|
132 (3, 19, 'area', 20),
|
jbe@10
|
133 (4, 5, 'area', 13),
|
jbe@10
|
134 (4, 12, 'area', 22);
|
jbe@0
|
135
|
jbe@0
|
136 INSERT INTO "issue" ("area_id", "policy_id") VALUES
|
jbe@0
|
137 (3, 1); -- id 1
|
jbe@0
|
138
|
jbe@0
|
139 INSERT INTO "initiative" ("issue_id", "name") VALUES
|
jbe@0
|
140 (1, 'Initiative #1'), -- id 1
|
jbe@0
|
141 (1, 'Initiative #2'), -- id 2
|
jbe@0
|
142 (1, 'Initiative #3'), -- id 3
|
jbe@0
|
143 (1, 'Initiative #4'), -- id 4
|
jbe@0
|
144 (1, 'Initiative #5'), -- id 5
|
jbe@0
|
145 (1, 'Initiative #6'), -- id 6
|
jbe@0
|
146 (1, 'Initiative #7'); -- id 7
|
jbe@0
|
147
|
jbe@0
|
148 INSERT INTO "draft" ("initiative_id", "author_id", "content") VALUES
|
jbe@0
|
149 (1, 17, 'Lorem ipsum...'), -- id 1
|
jbe@0
|
150 (2, 20, 'Lorem ipsum...'), -- id 2
|
jbe@0
|
151 (3, 20, 'Lorem ipsum...'), -- id 3
|
jbe@0
|
152 (4, 20, 'Lorem ipsum...'), -- id 4
|
jbe@0
|
153 (5, 14, 'Lorem ipsum...'), -- id 5
|
jbe@0
|
154 (6, 11, 'Lorem ipsum...'), -- id 6
|
jbe@0
|
155 (7, 12, 'Lorem ipsum...'); -- id 7
|
jbe@0
|
156
|
jbe@0
|
157 INSERT INTO "initiator" ("initiative_id", "member_id") VALUES
|
jbe@0
|
158 (1, 17),
|
jbe@0
|
159 (1, 19),
|
jbe@0
|
160 (2, 20),
|
jbe@0
|
161 (3, 20),
|
jbe@0
|
162 (4, 20),
|
jbe@0
|
163 (5, 14),
|
jbe@0
|
164 (6, 11),
|
jbe@0
|
165 (7, 12);
|
jbe@0
|
166
|
jbe@0
|
167 INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") VALUES
|
jbe@0
|
168 ( 7, 4, 4),
|
jbe@0
|
169 ( 8, 2, 2),
|
jbe@0
|
170 (11, 6, 6),
|
jbe@0
|
171 (12, 7, 7),
|
jbe@0
|
172 (14, 1, 1),
|
jbe@0
|
173 (14, 2, 2),
|
jbe@0
|
174 (14, 3, 3),
|
jbe@0
|
175 (14, 4, 4),
|
jbe@0
|
176 (14, 5, 5),
|
jbe@0
|
177 (14, 6, 6),
|
jbe@0
|
178 (14, 7, 7),
|
jbe@0
|
179 (17, 1, 1),
|
jbe@0
|
180 (17, 3, 3),
|
jbe@0
|
181 (19, 1, 1),
|
jbe@0
|
182 (19, 2, 2),
|
jbe@0
|
183 (20, 1, 1),
|
jbe@0
|
184 (20, 2, 2),
|
jbe@0
|
185 (20, 3, 3),
|
jbe@0
|
186 (20, 4, 4),
|
jbe@0
|
187 (20, 5, 5);
|
jbe@0
|
188
|
jbe@159
|
189 INSERT INTO "suggestion" ("initiative_id", "author_id", "name", "content") VALUES
|
jbe@0
|
190 (1, 19, 'Suggestion #1', 'Lorem ipsum...'); -- id 1
|
jbe@0
|
191 INSERT INTO "opinion" ("member_id", "suggestion_id", "degree", "fulfilled") VALUES
|
jbe@0
|
192 (14, 1, 2, FALSE);
|
jbe@0
|
193 INSERT INTO "opinion" ("member_id", "suggestion_id", "degree", "fulfilled") VALUES
|
jbe@0
|
194 (19, 1, 2, FALSE);
|
jbe@0
|
195
|
jbe@134
|
196 INSERT INTO "issue" ("area_id", "policy_id") VALUES
|
jbe@134
|
197 (4, 1); -- id 2
|
jbe@134
|
198
|
jbe@134
|
199 INSERT INTO "initiative" ("issue_id", "name") VALUES
|
jbe@139
|
200 (2, 'Initiative A'), -- id 8
|
jbe@139
|
201 (2, 'Initiative B'), -- id 9
|
jbe@139
|
202 (2, 'Initiative C'), -- id 10
|
jbe@139
|
203 (2, 'Initiative D'); -- id 11
|
jbe@134
|
204
|
jbe@134
|
205 INSERT INTO "draft" ("initiative_id", "author_id", "content") VALUES
|
jbe@139
|
206 ( 8, 1, 'Lorem ipsum...'), -- id 8
|
jbe@139
|
207 ( 9, 2, 'Lorem ipsum...'), -- id 9
|
jbe@139
|
208 (10, 3, 'Lorem ipsum...'), -- id 10
|
jbe@139
|
209 (11, 4, 'Lorem ipsum...'); -- id 11
|
jbe@134
|
210
|
jbe@134
|
211 INSERT INTO "initiator" ("initiative_id", "member_id") VALUES
|
jbe@139
|
212 ( 8, 1),
|
jbe@139
|
213 ( 9, 2),
|
jbe@139
|
214 (10, 3),
|
jbe@139
|
215 (11, 4);
|
jbe@134
|
216
|
jbe@134
|
217 INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") VALUES
|
jbe@139
|
218 (1, 8, 8),
|
jbe@139
|
219 (1, 9, 9),
|
jbe@139
|
220 (1, 10, 10),
|
jbe@139
|
221 (1, 11, 11),
|
jbe@139
|
222 (2, 8, 8),
|
jbe@139
|
223 (2, 9, 9),
|
jbe@139
|
224 (2, 10, 10),
|
jbe@139
|
225 (2, 11, 11),
|
jbe@139
|
226 (3, 8, 8),
|
jbe@139
|
227 (3, 9, 9),
|
jbe@139
|
228 (3, 10, 10),
|
jbe@139
|
229 (3, 11, 11),
|
jbe@139
|
230 (4, 8, 8),
|
jbe@139
|
231 (4, 9, 9),
|
jbe@139
|
232 (4, 10, 10),
|
jbe@139
|
233 (4, 11, 11),
|
jbe@139
|
234 (5, 8, 8),
|
jbe@139
|
235 (5, 9, 9),
|
jbe@139
|
236 (5, 10, 10),
|
jbe@139
|
237 (5, 11, 11),
|
jbe@139
|
238 (6, 8, 8),
|
jbe@139
|
239 (6, 9, 9),
|
jbe@139
|
240 (6, 10, 10),
|
jbe@139
|
241 (6, 11, 11);
|
jbe@139
|
242
|
jbe@3
|
243 SELECT "time_warp"();
|
jbe@3
|
244 SELECT "time_warp"();
|
jbe@3
|
245 SELECT "time_warp"();
|
jbe@0
|
246
|
jbe@0
|
247 INSERT INTO "direct_voter" ("member_id", "issue_id") VALUES
|
jbe@0
|
248 ( 8, 1),
|
jbe@0
|
249 ( 9, 1),
|
jbe@0
|
250 (11, 1),
|
jbe@0
|
251 (12, 1),
|
jbe@0
|
252 (14, 1),
|
jbe@0
|
253 (19, 1),
|
jbe@0
|
254 (20, 1),
|
jbe@0
|
255 (21, 1);
|
jbe@0
|
256
|
jbe@0
|
257 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES
|
jbe@0
|
258 ( 8, 1, 1, 1),
|
jbe@0
|
259 ( 8, 1, 2, 1),
|
jbe@0
|
260 ( 8, 1, 3, 1),
|
jbe@0
|
261 ( 8, 1, 4, 1),
|
jbe@0
|
262 ( 8, 1, 5, 1),
|
jbe@0
|
263 ( 8, 1, 6, -1),
|
jbe@0
|
264 ( 8, 1, 7, -1),
|
jbe@0
|
265 ( 9, 1, 1, -2),
|
jbe@0
|
266 ( 9, 1, 2, -3),
|
jbe@0
|
267 ( 9, 1, 3, -2),
|
jbe@0
|
268 ( 9, 1, 4, -2),
|
jbe@0
|
269 ( 9, 1, 5, -2),
|
jbe@0
|
270 ( 9, 1, 6, -1),
|
jbe@0
|
271 (11, 1, 1, -1),
|
jbe@0
|
272 (11, 1, 2, -1),
|
jbe@0
|
273 (11, 1, 3, -1),
|
jbe@0
|
274 (11, 1, 4, -1),
|
jbe@0
|
275 (11, 1, 5, -1),
|
jbe@0
|
276 (11, 1, 6, 2),
|
jbe@0
|
277 (11, 1, 7, 1),
|
jbe@0
|
278 (12, 1, 1, -1),
|
jbe@0
|
279 (12, 1, 3, -1),
|
jbe@0
|
280 (12, 1, 4, -1),
|
jbe@0
|
281 (12, 1, 5, -1),
|
jbe@0
|
282 (12, 1, 6, -2),
|
jbe@0
|
283 (12, 1, 7, 1),
|
jbe@0
|
284 (14, 1, 1, 1),
|
jbe@0
|
285 (14, 1, 2, 3),
|
jbe@0
|
286 (14, 1, 3, 1),
|
jbe@0
|
287 (14, 1, 4, 2),
|
jbe@0
|
288 (14, 1, 5, 1),
|
jbe@0
|
289 (14, 1, 6, 1),
|
jbe@0
|
290 (14, 1, 7, 1),
|
jbe@0
|
291 (19, 1, 1, 3),
|
jbe@0
|
292 (19, 1, 2, 4),
|
jbe@0
|
293 (19, 1, 3, 2),
|
jbe@0
|
294 (19, 1, 4, 2),
|
jbe@0
|
295 (19, 1, 5, 2),
|
jbe@0
|
296 (19, 1, 7, 1),
|
jbe@0
|
297 (20, 1, 1, 1),
|
jbe@0
|
298 (20, 1, 2, 2),
|
jbe@0
|
299 (20, 1, 3, 1),
|
jbe@0
|
300 (20, 1, 4, 1),
|
jbe@0
|
301 (20, 1, 5, 1),
|
jbe@0
|
302 (21, 1, 5, -1);
|
jbe@0
|
303
|
jbe@134
|
304 INSERT INTO "direct_voter" ("member_id", "issue_id") VALUES
|
jbe@134
|
305 ( 1, 2),
|
jbe@134
|
306 ( 2, 2),
|
jbe@134
|
307 ( 3, 2),
|
jbe@134
|
308 ( 4, 2),
|
jbe@134
|
309 ( 5, 2),
|
jbe@134
|
310 ( 6, 2),
|
jbe@134
|
311 ( 7, 2),
|
jbe@134
|
312 ( 8, 2),
|
jbe@134
|
313 ( 9, 2),
|
jbe@134
|
314 (10, 2),
|
jbe@134
|
315 (11, 2),
|
jbe@134
|
316 (12, 2),
|
jbe@134
|
317 (13, 2),
|
jbe@134
|
318 (14, 2),
|
jbe@134
|
319 (15, 2),
|
jbe@134
|
320 (16, 2),
|
jbe@134
|
321 (17, 2),
|
jbe@134
|
322 (18, 2),
|
jbe@134
|
323 (19, 2),
|
jbe@134
|
324 (20, 2);
|
jbe@134
|
325
|
jbe@134
|
326 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES
|
jbe@139
|
327 ( 1, 2, 8, 3),
|
jbe@139
|
328 ( 1, 2, 9, 4),
|
jbe@139
|
329 ( 1, 2, 10, 2),
|
jbe@139
|
330 ( 1, 2, 11, 1),
|
jbe@139
|
331 ( 2, 2, 8, 3),
|
jbe@139
|
332 ( 2, 2, 9, 4),
|
jbe@139
|
333 ( 2, 2, 10, 2),
|
jbe@139
|
334 ( 2, 2, 11, 1),
|
jbe@139
|
335 ( 3, 2, 8, 4),
|
jbe@139
|
336 ( 3, 2, 9, 3),
|
jbe@139
|
337 ( 3, 2, 10, 2),
|
jbe@139
|
338 ( 3, 2, 11, 1),
|
jbe@139
|
339 ( 4, 2, 8, 4),
|
jbe@139
|
340 ( 4, 2, 9, 3),
|
jbe@139
|
341 ( 4, 2, 10, 2),
|
jbe@139
|
342 ( 4, 2, 11, 1),
|
jbe@139
|
343 ( 5, 2, 8, 4),
|
jbe@139
|
344 ( 5, 2, 9, 3),
|
jbe@139
|
345 ( 5, 2, 10, 2),
|
jbe@139
|
346 ( 5, 2, 11, 1),
|
jbe@139
|
347 ( 6, 2, 8, 4),
|
jbe@139
|
348 ( 6, 2, 9, 3),
|
jbe@139
|
349 ( 6, 2, 10, 2),
|
jbe@139
|
350 ( 6, 2, 11, 1),
|
jbe@139
|
351 ( 7, 2, 8, 4),
|
jbe@139
|
352 ( 7, 2, 9, 3),
|
jbe@139
|
353 ( 7, 2, 10, 2),
|
jbe@139
|
354 ( 7, 2, 11, 1),
|
jbe@139
|
355 ( 8, 2, 8, 4),
|
jbe@139
|
356 ( 8, 2, 9, 3),
|
jbe@139
|
357 ( 8, 2, 10, 2),
|
jbe@139
|
358 ( 8, 2, 11, 1),
|
jbe@139
|
359 ( 9, 2, 8, -1),
|
jbe@139
|
360 ( 9, 2, 9, 1),
|
jbe@139
|
361 ( 9, 2, 10, 3),
|
jbe@139
|
362 ( 9, 2, 11, 2),
|
jbe@139
|
363 (10, 2, 8, -1),
|
jbe@139
|
364 (10, 2, 9, 1),
|
jbe@139
|
365 (10, 2, 10, 3),
|
jbe@139
|
366 (10, 2, 11, 2),
|
jbe@139
|
367 (11, 2, 8, -1),
|
jbe@139
|
368 (11, 2, 9, 1),
|
jbe@139
|
369 (11, 2, 10, 3),
|
jbe@139
|
370 (11, 2, 11, 2),
|
jbe@139
|
371 (12, 2, 8, -1),
|
jbe@139
|
372 (12, 2, 9, 1),
|
jbe@139
|
373 (12, 2, 10, 3),
|
jbe@139
|
374 (12, 2, 11, 2),
|
jbe@139
|
375 (13, 2, 8, -1),
|
jbe@139
|
376 (13, 2, 9, 1),
|
jbe@139
|
377 (13, 2, 10, 3),
|
jbe@139
|
378 (13, 2, 11, 2),
|
jbe@139
|
379 (14, 2, 8, -1),
|
jbe@139
|
380 (14, 2, 9, 1),
|
jbe@139
|
381 (14, 2, 10, 3),
|
jbe@139
|
382 (14, 2, 11, 2),
|
jbe@139
|
383 (15, 2, 8, -1),
|
jbe@139
|
384 (15, 2, 9, -3),
|
jbe@139
|
385 (15, 2, 10, -4),
|
jbe@139
|
386 (15, 2, 11, -2),
|
jbe@139
|
387 (16, 2, 8, -1),
|
jbe@139
|
388 (16, 2, 9, -3),
|
jbe@139
|
389 (16, 2, 10, -4),
|
jbe@139
|
390 (16, 2, 11, -2),
|
jbe@139
|
391 (17, 2, 8, -1),
|
jbe@139
|
392 (17, 2, 9, -3),
|
jbe@139
|
393 (17, 2, 10, -4),
|
jbe@139
|
394 (17, 2, 11, -2),
|
jbe@139
|
395 (18, 2, 8, -1),
|
jbe@139
|
396 (18, 2, 9, 1),
|
jbe@139
|
397 (18, 2, 10, -2),
|
jbe@139
|
398 (18, 2, 11, 2),
|
jbe@139
|
399 (19, 2, 8, -1),
|
jbe@139
|
400 (19, 2, 9, 1),
|
jbe@139
|
401 (19, 2, 10, -2),
|
jbe@139
|
402 (19, 2, 11, 2),
|
jbe@139
|
403 (20, 2, 8, 1),
|
jbe@139
|
404 (20, 2, 9, 2),
|
jbe@139
|
405 (20, 2, 10, -1),
|
jbe@139
|
406 (20, 2, 11, 3);
|
jbe@134
|
407
|
jbe@3
|
408 SELECT "time_warp"();
|
jbe@3
|
409
|
jbe@3
|
410 DROP FUNCTION "time_warp"();
|
jbe@0
|
411
|
poelzi@78
|
412 -- Test policies that help with testing specific frontend parts
|
poelzi@78
|
413
|
poelzi@78
|
414 INSERT INTO "policy" (
|
poelzi@78
|
415 "index",
|
poelzi@78
|
416 "active",
|
poelzi@78
|
417 "name",
|
poelzi@78
|
418 "description",
|
poelzi@78
|
419 "admission_time",
|
poelzi@78
|
420 "discussion_time",
|
poelzi@78
|
421 "verification_time",
|
poelzi@78
|
422 "voting_time",
|
poelzi@78
|
423 "issue_quorum_num",
|
poelzi@78
|
424 "issue_quorum_den",
|
poelzi@78
|
425 "initiative_quorum_num",
|
poelzi@78
|
426 "initiative_quorum_den"
|
poelzi@78
|
427 ) VALUES (
|
poelzi@78
|
428 1,
|
poelzi@78
|
429 TRUE,
|
poelzi@78
|
430 'Test New',
|
poelzi@78
|
431 DEFAULT,
|
poelzi@78
|
432 '2 days',
|
poelzi@78
|
433 '1 second',
|
poelzi@78
|
434 '1 second',
|
poelzi@78
|
435 '1 second',
|
poelzi@82
|
436 0, 100,
|
poelzi@82
|
437 0, 100
|
poelzi@78
|
438 ), (
|
poelzi@78
|
439 1,
|
poelzi@78
|
440 TRUE,
|
poelzi@78
|
441 'Test Accept',
|
poelzi@78
|
442 DEFAULT,
|
poelzi@78
|
443 '1 second',
|
poelzi@78
|
444 '2 days',
|
poelzi@78
|
445 '1 second',
|
poelzi@78
|
446 '1 second',
|
poelzi@82
|
447 0, 100,
|
poelzi@82
|
448 0, 100
|
poelzi@78
|
449 ), (
|
poelzi@78
|
450 1,
|
poelzi@78
|
451 TRUE,
|
poelzi@78
|
452 'Test Frozen',
|
poelzi@78
|
453 DEFAULT,
|
poelzi@78
|
454 '1 second',
|
poelzi@78
|
455 '5 minutes',
|
poelzi@78
|
456 '2 days',
|
poelzi@78
|
457 '1 second',
|
poelzi@82
|
458 0, 100,
|
poelzi@82
|
459 0, 100
|
poelzi@78
|
460 ), (
|
poelzi@78
|
461 1,
|
poelzi@78
|
462 TRUE,
|
poelzi@78
|
463 'Test Voting',
|
poelzi@78
|
464 DEFAULT,
|
poelzi@78
|
465 '1 second',
|
poelzi@78
|
466 '5 minutes',
|
poelzi@78
|
467 '1 second',
|
poelzi@78
|
468 '2 days',
|
poelzi@82
|
469 0, 100,
|
poelzi@82
|
470 0, 100
|
poelzi@78
|
471 );
|
jbe@334
|
472
|
jbe@0
|
473 END;
|
jbe@0
|
474
|