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