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 +

Impressum / About Us