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