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