liquid_feedback_core
changeset 192:a5fed9a4154e
Created new demo.sql with basic settings and units and areas for an imaginary "Solar System" installation
author | jbe |
---|---|
date | Sun Sep 04 23:42:05 2011 +0200 (2011-09-04) |
parents | 44e489d77306 |
children | 055d232404d6 |
files | demo.sql |
line diff
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/demo.sql Sun Sep 04 23:42:05 2011 +0200 1.3 @@ -0,0 +1,161 @@ 1.4 +-- NOTE: This file requires that sequence generators have not been used. 1.5 +-- (All new rows need to start with id '1'.) 1.6 + 1.7 +BEGIN; 1.8 + 1.9 +INSERT INTO "system_setting" ("member_ttl") VALUES ('31 days'); 1.10 + 1.11 +INSERT INTO "contingent" ("time_frame", "text_entry_limit", "initiative_limit") VALUES 1.12 + ('60 minutes', 6, 1), 1.13 + ('1 day', 60, 10), 1.14 + ('1 week', 120, 20); 1.15 + 1.16 +INSERT INTO "policy" ( 1.17 + "index", 1.18 + "name", 1.19 + "admission_time", 1.20 + "discussion_time", 1.21 + "verification_time", 1.22 + "voting_time", 1.23 + "issue_quorum_num", "issue_quorum_den", 1.24 + "initiative_quorum_num", "initiative_quorum_den", 1.25 + "direct_majority_num", "direct_majority_den", "direct_majority_strict", 1.26 + "indirect_majority_num", "indirect_majority_den", "indirect_majority_strict", 1.27 + "no_reverse_beat_path", "no_multistage_majority" 1.28 + ) VALUES ( 1.29 + 1, 1.30 + 'amendment of the statutes (solar system)', 1.31 + '8 days', '15 days', '8 days', '15 days', 1.32 + 10, 100, 1.33 + 10, 100, 1.34 + 1, 2, TRUE, 1.35 + 2, 3, FALSE, 1.36 + TRUE, FALSE 1.37 + ), ( 1.38 + 2, 1.39 + 'amendment of the statutes (earth moon federation)', 1.40 + '8 days', '15 days', '8 days', '15 days', 1.41 + 10, 100, 1.42 + 10, 100, 1.43 + 1, 2, TRUE, 1.44 + 2, 3, FALSE, 1.45 + TRUE, FALSE 1.46 + ), ( 1.47 + 3, 1.48 + 'amendment of the statutes (united mars colonies)', 1.49 + '8 days', '15 days', '8 days', '15 days', 1.50 + 10, 100, 1.51 + 10, 100, 1.52 + 1, 2, TRUE, 1.53 + 2, 3, FALSE, 1.54 + TRUE, FALSE 1.55 + ), ( 1.56 + 4, 1.57 + 'proposition', 1.58 + '8 days', '15 days', '8 days', '15 days', 1.59 + 10, 100, 1.60 + 10, 100, 1.61 + 1, 2, TRUE, 1.62 + 1, 2, TRUE, 1.63 + TRUE, FALSE 1.64 + ), ( 1.65 + 5, 1.66 + 'non-binding survey', 1.67 + '2 days', '3 days', '2 days', '3 days', 1.68 + 5, 100, 1.69 + 5, 100, 1.70 + 1, 2, TRUE, 1.71 + 1, 2, TRUE, 1.72 + TRUE, FALSE 1.73 + ), ( 1.74 + 6, 1.75 + 'non-binding survey (super fast)', 1.76 + '1 hour', '30 minutes', '15 minutes', '30 minutes', 1.77 + 5, 100, 1.78 + 5, 100, 1.79 + 1, 2, TRUE, 1.80 + 1, 2, TRUE, 1.81 + TRUE, FALSE 1.82 + ); 1.83 + 1.84 +INSERT INTO "unit" ("parent_id", "name") VALUES 1.85 + (NULL, 'Solar System'), -- id 1 1.86 + (1 , 'Earth Moon Federation'), -- id 2 1.87 + (2 , 'Earth'), -- id 3 1.88 + (2 , 'Moon'), -- id 4 1.89 + (1 , 'Mars'); -- id 5 1.90 + 1.91 +INSERT INTO "area" ("unit_id", "name") VALUES 1.92 + ( 1, 'Statutes of the United Solar System'), -- id 1 1.93 + ( 2, 'Statutes of the Earth Moon Federation'), -- id 2 1.94 + ( 5, 'Statutes of the United Mars Colonies'), -- id 3 1.95 + ( 1, 'Intra solar space travel'), -- id 4 1.96 + ( 1, 'Intra solar system trade and taxation'), -- id 5 1.97 + ( 1, 'Comet defense and black holes management'), -- id 6 1.98 + ( 1, 'Alien affairs'), -- id 7 1.99 + ( 2, 'Foreign affairs'), -- id 8 1.100 + ( 3, 'Moon affairs'), -- id 9 1.101 + ( 4, 'Earth affairs'), -- id 10 1.102 + ( 4, 'Moon tourism'), -- id 11 1.103 + ( 5, 'Foreign affairs'), -- id 12 1.104 + ( 2, 'Department of space vehicles'), -- id 13 1.105 + ( 3, 'Environment'), -- id 14 1.106 + ( 4, 'Energy and oxygen'), -- id 15 1.107 + ( 5, 'Energy and oxygen'), -- id 16 1.108 + ( 5, 'Mineral resources'); -- id 17 1.109 + 1.110 +INSERT INTO "allowed_policy" ("area_id", "policy_id", "default_policy") VALUES 1.111 + ( 1, 1, TRUE), 1.112 + ( 1, 5, FALSE), 1.113 + ( 1, 6, FALSE), 1.114 + ( 2, 2, TRUE), 1.115 + ( 2, 5, FALSE), 1.116 + ( 2, 6, FALSE), 1.117 + ( 3, 3, TRUE), 1.118 + ( 3, 5, FALSE), 1.119 + ( 3, 6, FALSE), 1.120 + ( 4, 4, TRUE), 1.121 + ( 4, 5, FALSE), 1.122 + ( 4, 6, FALSE), 1.123 + ( 5, 4, TRUE), 1.124 + ( 5, 5, FALSE), 1.125 + ( 5, 6, FALSE), 1.126 + ( 6, 4, TRUE), 1.127 + ( 6, 5, FALSE), 1.128 + ( 6, 6, FALSE), 1.129 + ( 7, 4, TRUE), 1.130 + ( 7, 5, FALSE), 1.131 + ( 7, 6, FALSE), 1.132 + ( 8, 4, TRUE), 1.133 + ( 8, 5, FALSE), 1.134 + ( 8, 6, FALSE), 1.135 + ( 9, 4, TRUE), 1.136 + ( 9, 5, FALSE), 1.137 + ( 9, 6, FALSE), 1.138 + (10, 4, TRUE), 1.139 + (10, 5, FALSE), 1.140 + (10, 6, FALSE), 1.141 + (11, 4, TRUE), 1.142 + (11, 5, FALSE), 1.143 + (11, 6, FALSE), 1.144 + (12, 4, TRUE), 1.145 + (12, 5, FALSE), 1.146 + (12, 6, FALSE), 1.147 + (13, 4, TRUE), 1.148 + (13, 5, FALSE), 1.149 + (13, 6, FALSE), 1.150 + (14, 4, TRUE), 1.151 + (14, 5, FALSE), 1.152 + (14, 6, FALSE), 1.153 + (15, 4, TRUE), 1.154 + (15, 5, FALSE), 1.155 + (15, 6, FALSE), 1.156 + (16, 4, TRUE), 1.157 + (16, 5, FALSE), 1.158 + (16, 6, FALSE), 1.159 + (17, 4, TRUE), 1.160 + (17, 5, FALSE), 1.161 + (17, 6, FALSE); 1.162 + 1.163 +END; 1.164 +