liquid_feedback_core

view demo.sql @ 593:e7f772ca0621

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

Impressum / About Us