1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/init.sql	Tue Oct 27 12:00:00 2009 +0100
     1.3 @@ -0,0 +1,76 @@
     1.4 +-- NOTE: This file creates an admin user with an empty password!
     1.5 +
     1.6 +BEGIN;
     1.7 +
     1.8 +INSERT INTO "member" (
     1.9 +        "id",
    1.10 +        "login",
    1.11 +        "password",
    1.12 +        "active",
    1.13 +        "admin",
    1.14 +        "name",
    1.15 +        "ident_number"
    1.16 +    ) VALUES (
    1.17 +        DEFAULT,
    1.18 +        'admin',
    1.19 +        '',
    1.20 +        TRUE,
    1.21 +        TRUE,
    1.22 +        'Administrator',
    1.23 +        DEFAULT );
    1.24 +
    1.25 +INSERT INTO "policy" (
    1.26 +        "id",
    1.27 +        "active",
    1.28 +        "name",
    1.29 +        "description",
    1.30 +        "admission_time",
    1.31 +        "discussion_time",
    1.32 +        "voting_time",
    1.33 +        "issue_quorum_num",
    1.34 +        "issue_quorum_den",
    1.35 +        "initiative_quorum_num",
    1.36 +        "initiative_quorum_den"
    1.37 +    ) VALUES (
    1.38 +        DEFAULT,
    1.39 +        TRUE,
    1.40 +        'Extensive proceeding',
    1.41 +        DEFAULT,
    1.42 +        '1 month',
    1.43 +        '6 months',
    1.44 +        '3 weeks',
    1.45 +        5, 100,
    1.46 +        1, 100
    1.47 +    ), (
    1.48 +        DEFAULT,
    1.49 +        TRUE,
    1.50 +        'Standard proceeding',
    1.51 +        DEFAULT,
    1.52 +        '1 week',
    1.53 +        '1 month',
    1.54 +        '1 week',
    1.55 +        5, 100,
    1.56 +        1, 100
    1.57 +    ), (
    1.58 +       DEFAULT,
    1.59 +       TRUE,
    1.60 +       'Fast proceeding',
    1.61 +       DEFAULT,
    1.62 +       '24 hours',
    1.63 +       '4 hours',
    1.64 +       '20 hours',
    1.65 +        5, 100,
    1.66 +        1, 100 );
    1.67 +
    1.68 +INSERT INTO "area" (
    1.69 +        "id",
    1.70 +        "active",
    1.71 +        "name",
    1.72 +        "description"
    1.73 +    ) VALUES (
    1.74 +        DEFAULT,
    1.75 +        TRUE,
    1.76 +        'Generic area',
    1.77 +        DEFAULT );
    1.78 +
    1.79 +COMMIT;