liquid_feedback_core
view demo.sql @ 501:4a8d9f00867b
Use "recipient_id" instead of "member_id" in function "get_initiatives_for_notification"
| author | jbe |
|---|---|
| date | Mon Apr 04 18:51:13 2016 +0200 (2016-04-04) |
| parents | fbb49f35b4e1 |
| children |
line source
1 -- NOTE: This file requires that sequence generators have not been used.
2 -- (All new rows need to start with id '1'.)
4 BEGIN;
6 INSERT INTO "system_setting" ("member_ttl") VALUES ('31 days');
8 INSERT INTO "contingent" ("polling", "time_frame", "text_entry_limit", "initiative_limit") VALUES
9 (FALSE, '60 minutes', 6, 1),
10 (FALSE, '1 day', 60, 10),
11 (FALSE, '1 week', 120, 20),
12 (TRUE, '60 minutes', 6, 1),
13 (TRUE, '1 day', 60, 10),
14 (TRUE, '1 week', 120, 20);
16 INSERT INTO "policy" (
17 "index",
18 "name",
19 "admission_time",
20 "discussion_time",
21 "verification_time",
22 "voting_time",
23 "issue_quorum_num", "issue_quorum_den",
24 "initiative_quorum_num", "initiative_quorum_den",
25 "direct_majority_num", "direct_majority_den", "direct_majority_strict",
26 "indirect_majority_num", "indirect_majority_den", "indirect_majority_strict",
27 "no_reverse_beat_path", "no_multistage_majority"
28 ) VALUES (
29 1,
30 'amendment of the statutes (solar system)',
31 '8 days', '15 days', '8 days', '15 days',
32 10, 100,
33 10, 100,
34 1, 2, TRUE,
35 2, 3, FALSE,
36 TRUE, FALSE
37 ), (
38 2,
39 'amendment of the statutes (earth moon federation)',
40 '8 days', '15 days', '8 days', '15 days',
41 10, 100,
42 10, 100,
43 1, 2, TRUE,
44 2, 3, FALSE,
45 TRUE, FALSE
46 ), (
47 3,
48 'amendment of the statutes (united mars colonies)',
49 '8 days', '15 days', '8 days', '15 days',
50 10, 100,
51 10, 100,
52 1, 2, TRUE,
53 2, 3, FALSE,
54 TRUE, FALSE
55 ), (
56 4,
57 'proposition',
58 '8 days', '15 days', '8 days', '15 days',
59 10, 100,
60 10, 100,
61 1, 2, TRUE,
62 1, 2, TRUE,
63 TRUE, FALSE
64 ), (
65 5,
66 'non-binding survey',
67 '2 days', '3 days', '2 days', '3 days',
68 5, 100,
69 5, 100,
70 1, 2, TRUE,
71 1, 2, TRUE,
72 TRUE, FALSE
73 ), (
74 6,
75 'non-binding survey (super fast)',
76 '1 hour', '30 minutes', '15 minutes', '30 minutes',
77 5, 100,
78 5, 100,
79 1, 2, TRUE,
80 1, 2, TRUE,
81 TRUE, FALSE
82 );
84 INSERT INTO "unit" ("parent_id", "name") VALUES
85 (NULL, 'Solar System'), -- id 1
86 (1 , 'Earth Moon Federation'), -- id 2
87 (2 , 'Earth'), -- id 3
88 (2 , 'Moon'), -- id 4
89 (1 , 'Mars'); -- id 5
91 INSERT INTO "area" ("unit_id", "name") VALUES
92 ( 1, 'Statutes of the United Solar System'), -- id 1
93 ( 2, 'Statutes of the Earth Moon Federation'), -- id 2
94 ( 5, 'Statutes of the United Mars Colonies'), -- id 3
95 ( 1, 'Intra solar space travel'), -- id 4
96 ( 1, 'Intra solar system trade and taxation'), -- id 5
97 ( 1, 'Comet defense and black holes management'), -- id 6
98 ( 1, 'Alien affairs'), -- id 7
99 ( 2, 'Foreign affairs'), -- id 8
100 ( 3, 'Moon affairs'), -- id 9
101 ( 4, 'Earth affairs'), -- id 10
102 ( 4, 'Moon tourism'), -- id 11
103 ( 5, 'Foreign affairs'), -- id 12
104 ( 2, 'Department of space vehicles'), -- id 13
105 ( 3, 'Environment'), -- id 14
106 ( 4, 'Energy and oxygen'), -- id 15
107 ( 5, 'Energy and oxygen'), -- id 16
108 ( 5, 'Mineral resources'); -- id 17
110 INSERT INTO "allowed_policy" ("area_id", "policy_id", "default_policy") VALUES
111 ( 1, 1, TRUE),
112 ( 1, 5, FALSE),
113 ( 1, 6, FALSE),
114 ( 2, 2, TRUE),
115 ( 2, 5, FALSE),
116 ( 2, 6, FALSE),
117 ( 3, 3, TRUE),
118 ( 3, 5, FALSE),
119 ( 3, 6, FALSE),
120 ( 4, 4, TRUE),
121 ( 4, 5, FALSE),
122 ( 4, 6, FALSE),
123 ( 5, 4, TRUE),
124 ( 5, 5, FALSE),
125 ( 5, 6, FALSE),
126 ( 6, 4, TRUE),
127 ( 6, 5, FALSE),
128 ( 6, 6, FALSE),
129 ( 7, 4, TRUE),
130 ( 7, 5, FALSE),
131 ( 7, 6, FALSE),
132 ( 8, 4, TRUE),
133 ( 8, 5, FALSE),
134 ( 8, 6, FALSE),
135 ( 9, 4, TRUE),
136 ( 9, 5, FALSE),
137 ( 9, 6, FALSE),
138 (10, 4, TRUE),
139 (10, 5, FALSE),
140 (10, 6, FALSE),
141 (11, 4, TRUE),
142 (11, 5, FALSE),
143 (11, 6, FALSE),
144 (12, 4, TRUE),
145 (12, 5, FALSE),
146 (12, 6, FALSE),
147 (13, 4, TRUE),
148 (13, 5, FALSE),
149 (13, 6, FALSE),
150 (14, 4, TRUE),
151 (14, 5, FALSE),
152 (14, 6, FALSE),
153 (15, 4, TRUE),
154 (15, 5, FALSE),
155 (15, 6, FALSE),
156 (16, 4, TRUE),
157 (16, 5, FALSE),
158 (16, 6, FALSE),
159 (17, 4, TRUE),
160 (17, 5, FALSE),
161 (17, 6, FALSE);
163 END;