jbe@192: -- NOTE: This file requires that sequence generators have not been used.
jbe@192: -- (All new rows need to start with id '1'.)
jbe@192: 
jbe@192: BEGIN;
jbe@192: 
jbe@192: INSERT INTO "system_setting" ("member_ttl") VALUES ('31 days');
jbe@192: 
jbe@445: INSERT INTO "contingent" ("polling", "time_frame", "text_entry_limit", "initiative_limit") VALUES
jbe@445:   (FALSE, '60 minutes', 6, 1),
jbe@445:   (FALSE, '1 day', 60, 10),
jbe@445:   (FALSE, '1 week', 120, 20),
jbe@445:   (TRUE, '60 minutes', 6, 1),
jbe@445:   (TRUE, '1 day', 60, 10),
jbe@445:   (TRUE, '1 week', 120, 20);
jbe@192: 
jbe@192: INSERT INTO "policy" (
jbe@192:     "index",
jbe@192:     "name",
jbe@192:     "admission_time",
jbe@192:     "discussion_time",
jbe@192:     "verification_time",
jbe@192:     "voting_time",
jbe@192:     "issue_quorum_num", "issue_quorum_den",
jbe@192:     "initiative_quorum_num", "initiative_quorum_den",
jbe@192:     "direct_majority_num", "direct_majority_den", "direct_majority_strict",
jbe@192:     "indirect_majority_num", "indirect_majority_den", "indirect_majority_strict",
jbe@192:     "no_reverse_beat_path", "no_multistage_majority"
jbe@192:   ) VALUES (
jbe@192:     1,
jbe@192:     'amendment of the statutes (solar system)',
jbe@192:     '8 days', '15 days', '8 days', '15 days',
jbe@192:     10, 100,
jbe@192:     10, 100,
jbe@192:     1, 2, TRUE,
jbe@192:     2, 3, FALSE,
jbe@192:     TRUE, FALSE
jbe@192:   ), (
jbe@192:     2,
jbe@192:     'amendment of the statutes (earth moon federation)',
jbe@192:     '8 days', '15 days', '8 days', '15 days',
jbe@192:     10, 100,
jbe@192:     10, 100,
jbe@192:     1, 2, TRUE,
jbe@192:     2, 3, FALSE,
jbe@192:     TRUE, FALSE
jbe@192:   ), (
jbe@192:     3,
jbe@192:     'amendment of the statutes (united mars colonies)',
jbe@192:     '8 days', '15 days', '8 days', '15 days',
jbe@192:     10, 100,
jbe@192:     10, 100,
jbe@192:     1, 2, TRUE,
jbe@192:     2, 3, FALSE,
jbe@192:     TRUE, FALSE
jbe@192:   ), (
jbe@192:     4,
jbe@192:     'proposition',
jbe@192:     '8 days', '15 days', '8 days', '15 days',
jbe@192:     10, 100,
jbe@192:     10, 100,
jbe@192:     1, 2, TRUE,
jbe@192:     1, 2, TRUE,
jbe@192:     TRUE, FALSE
jbe@192:   ), (
jbe@192:     5,
jbe@192:     'non-binding survey',
jbe@192:     '2 days', '3 days', '2 days', '3 days',
jbe@192:     5, 100,
jbe@192:     5, 100,
jbe@192:     1, 2, TRUE,
jbe@192:     1, 2, TRUE,
jbe@192:     TRUE, FALSE
jbe@192:   ), (
jbe@192:     6,
jbe@192:     'non-binding survey (super fast)',
jbe@192:     '1 hour', '30 minutes', '15 minutes', '30 minutes',
jbe@192:     5, 100,
jbe@192:     5, 100,
jbe@192:     1, 2, TRUE,
jbe@192:     1, 2, TRUE,
jbe@192:     TRUE, FALSE
jbe@192:   );
jbe@192: 
jbe@192: INSERT INTO "unit" ("parent_id", "name") VALUES
jbe@192:   (NULL, 'Solar System'),           -- id 1
jbe@192:   (1   , 'Earth Moon Federation'),  -- id 2
jbe@192:   (2   , 'Earth'),                  -- id 3
jbe@192:   (2   , 'Moon'),                   -- id 4
jbe@192:   (1   , 'Mars');                   -- id 5
jbe@192: 
jbe@192: INSERT INTO "area" ("unit_id", "name") VALUES
jbe@192:   ( 1, 'Statutes of the United Solar System'),       -- id  1
jbe@192:   ( 2, 'Statutes of the Earth Moon Federation'),     -- id  2
jbe@192:   ( 5, 'Statutes of the United Mars Colonies'),      -- id  3
jbe@192:   ( 1, 'Intra solar space travel'),                  -- id  4
jbe@192:   ( 1, 'Intra solar system trade and taxation'),     -- id  5
jbe@192:   ( 1, 'Comet defense and black holes management'),  -- id  6
jbe@192:   ( 1, 'Alien affairs'),                             -- id  7
jbe@192:   ( 2, 'Foreign affairs'),                           -- id  8
jbe@192:   ( 3, 'Moon affairs'),                              -- id  9
jbe@192:   ( 4, 'Earth affairs'),                             -- id 10
jbe@192:   ( 4, 'Moon tourism'),                              -- id 11
jbe@192:   ( 5, 'Foreign affairs'),                           -- id 12
jbe@192:   ( 2, 'Department of space vehicles'),              -- id 13
jbe@192:   ( 3, 'Environment'),                               -- id 14
jbe@192:   ( 4, 'Energy and oxygen'),                         -- id 15
jbe@192:   ( 5, 'Energy and oxygen'),                         -- id 16
jbe@192:   ( 5, 'Mineral resources');                         -- id 17
jbe@192: 
jbe@192: INSERT INTO "allowed_policy" ("area_id", "policy_id", "default_policy") VALUES
jbe@192:   ( 1, 1, TRUE),
jbe@192:   ( 1, 5, FALSE),
jbe@192:   ( 1, 6, FALSE),
jbe@192:   ( 2, 2, TRUE),
jbe@192:   ( 2, 5, FALSE),
jbe@192:   ( 2, 6, FALSE),
jbe@192:   ( 3, 3, TRUE),
jbe@192:   ( 3, 5, FALSE),
jbe@192:   ( 3, 6, FALSE),
jbe@192:   ( 4, 4, TRUE),
jbe@192:   ( 4, 5, FALSE),
jbe@192:   ( 4, 6, FALSE),
jbe@192:   ( 5, 4, TRUE),
jbe@192:   ( 5, 5, FALSE),
jbe@192:   ( 5, 6, FALSE),
jbe@192:   ( 6, 4, TRUE),
jbe@192:   ( 6, 5, FALSE),
jbe@192:   ( 6, 6, FALSE),
jbe@192:   ( 7, 4, TRUE),
jbe@192:   ( 7, 5, FALSE),
jbe@192:   ( 7, 6, FALSE),
jbe@192:   ( 8, 4, TRUE),
jbe@192:   ( 8, 5, FALSE),
jbe@192:   ( 8, 6, FALSE),
jbe@192:   ( 9, 4, TRUE),
jbe@192:   ( 9, 5, FALSE),
jbe@192:   ( 9, 6, FALSE),
jbe@192:   (10, 4, TRUE),
jbe@192:   (10, 5, FALSE),
jbe@192:   (10, 6, FALSE),
jbe@192:   (11, 4, TRUE),
jbe@192:   (11, 5, FALSE),
jbe@192:   (11, 6, FALSE),
jbe@192:   (12, 4, TRUE),
jbe@192:   (12, 5, FALSE),
jbe@192:   (12, 6, FALSE),
jbe@192:   (13, 4, TRUE),
jbe@192:   (13, 5, FALSE),
jbe@192:   (13, 6, FALSE),
jbe@192:   (14, 4, TRUE),
jbe@192:   (14, 5, FALSE),
jbe@192:   (14, 6, FALSE),
jbe@192:   (15, 4, TRUE),
jbe@192:   (15, 5, FALSE),
jbe@192:   (15, 6, FALSE),
jbe@192:   (16, 4, TRUE),
jbe@192:   (16, 5, FALSE),
jbe@192:   (16, 6, FALSE),
jbe@192:   (17, 4, TRUE),
jbe@192:   (17, 5, FALSE),
jbe@192:   (17, 6, FALSE);
jbe@192: 
jbe@192: END;
jbe@192: