liquid_feedback_core

view demo.sql @ 314:5289d62c028c

Minor fix in comment
author jbe
date Fri Feb 01 20:13:01 2013 +0100 (2013-02-01)
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;

Impressum / About Us