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