liquid_feedback_core

view demo.sql @ 309:3ab95ace7ffa

Added tag v2.1.0 for changeset 5c98265b39a0
author jbe
date Mon Oct 15 20:46:11 2012 +0200 (2012-10-15)
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