liquid_feedback_core
annotate demo.sql @ 423:73c2ab2d068f
Work on configuration of complexity of counting of the votes (extent of tie-breaking):
- added configuration field in "policy" table
- calculation of secondary criterion for the defeat strength (tie-breaking of the links) based on initiative id's
- added configuration field in "policy" table
- calculation of secondary criterion for the defeat strength (tie-breaking of the links) based on initiative id's
author | jbe |
---|---|
date | Thu Apr 10 00:20:03 2014 +0200 (2014-04-10) |
parents | a5fed9a4154e |
children | fbb49f35b4e1 |
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 |