liquid_feedback_core

annotate demo.sql @ 545:9c433d24ed00

find changesets by author, revision, files, or words in the commit message
Data migration of accepted terms of use (from "setting" table to "member_settings" table)
author jbe
date Fri Jul 14 21:17:26 2017 +0200 (2017-07-14)
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

Impressum / About Us