liquid_feedback_core
view init.sql @ 142:54ac8c473263
Use an improved definition for "disqualified" initiatives
"initiative"."disqualified" is TRUE, if the initiative may not win, because it either (a) has no better rank than the status quo, or (b) because there exists a better ranked initiative X, which directly beats this initiative, and either more voters prefer X to this initiative than voters preferring X to the status quo or less voters prefer this initiative to X than voters preferring the status quo to X
"initiative"."disqualified" is TRUE, if the initiative may not win, because it either (a) has no better rank than the status quo, or (b) because there exists a better ranked initiative X, which directly beats this initiative, and either more voters prefer X to this initiative than voters preferring X to the status quo or less voters prefer this initiative to X than voters preferring the status quo to X
| author | jbe |
|---|---|
| date | Wed Jun 01 16:58:00 2011 +0200 (2011-06-01) |
| parents | 58451b5565ae |
| children | 6fce4f08157b |
line source
1 -- NOTE: This file creates an admin user with an empty password!
3 BEGIN;
5 INSERT INTO "unit" (
6 "active",
7 "name",
8 "description"
9 ) VALUES (
10 true,
11 'Default unit',
12 'Default unit created by init script.'
13 );
16 INSERT INTO "member" (
17 "login",
18 "password",
19 "active",
20 "admin",
21 "name"
22 ) VALUES (
23 'admin',
24 '$1$.EMPTY.$LDufa24OE2HZFXAXh71Eb1',
25 TRUE,
26 TRUE,
27 'Administrator' );
29 INSERT INTO "policy" (
30 "index",
31 "active",
32 "name",
33 "description",
34 "admission_time",
35 "discussion_time",
36 "verification_time",
37 "voting_time",
38 "issue_quorum_num",
39 "issue_quorum_den",
40 "initiative_quorum_num",
41 "initiative_quorum_den"
42 ) VALUES (
43 1,
44 TRUE,
45 'Extensive proceeding',
46 DEFAULT,
47 '1 month',
48 '5 months',
49 '1 month',
50 '3 weeks',
51 10, 100,
52 10, 100
53 ), (
54 2,
55 TRUE,
56 'Standard proceeding',
57 DEFAULT,
58 '1 month',
59 '1 month',
60 '1 week',
61 '1 week',
62 10, 100,
63 10, 100
64 ), (
65 3,
66 TRUE,
67 'Fast proceeding',
68 DEFAULT,
69 '48 hours',
70 '3 hours',
71 '1 hour',
72 '20 hours',
73 1, 100,
74 1, 100 );
76 INSERT INTO "area" (
77 "unit_id",
78 "active",
79 "name",
80 "description"
81 ) VALUES (
82 1,
83 TRUE,
84 'Generic area',
85 DEFAULT );
87 COMMIT;