jbe@0: -- NOTE: This file creates an admin user with an empty password!
jbe@0: 
jbe@0: BEGIN;
jbe@0: 
jbe@0: INSERT INTO "member" (
jbe@0:         "id",
jbe@0:         "login",
jbe@0:         "password",
jbe@0:         "active",
jbe@0:         "admin",
jbe@0:         "name",
jbe@0:         "ident_number"
jbe@0:     ) VALUES (
jbe@0:         DEFAULT,
jbe@0:         'admin',
jbe@0:         '',
jbe@0:         TRUE,
jbe@0:         TRUE,
jbe@0:         'Administrator',
jbe@0:         DEFAULT );
jbe@0: 
jbe@0: INSERT INTO "policy" (
jbe@0:         "id",
jbe@0:         "active",
jbe@0:         "name",
jbe@0:         "description",
jbe@0:         "admission_time",
jbe@0:         "discussion_time",
jbe@0:         "voting_time",
jbe@0:         "issue_quorum_num",
jbe@0:         "issue_quorum_den",
jbe@0:         "initiative_quorum_num",
jbe@0:         "initiative_quorum_den"
jbe@0:     ) VALUES (
jbe@0:         DEFAULT,
jbe@0:         TRUE,
jbe@0:         'Extensive proceeding',
jbe@0:         DEFAULT,
jbe@0:         '1 month',
jbe@0:         '6 months',
jbe@0:         '3 weeks',
jbe@0:         5, 100,
jbe@0:         1, 100
jbe@0:     ), (
jbe@0:         DEFAULT,
jbe@0:         TRUE,
jbe@0:         'Standard proceeding',
jbe@0:         DEFAULT,
jbe@0:         '1 week',
jbe@0:         '1 month',
jbe@0:         '1 week',
jbe@0:         5, 100,
jbe@0:         1, 100
jbe@0:     ), (
jbe@0:        DEFAULT,
jbe@0:        TRUE,
jbe@0:        'Fast proceeding',
jbe@0:        DEFAULT,
jbe@0:        '24 hours',
jbe@0:        '4 hours',
jbe@0:        '20 hours',
jbe@0:         5, 100,
jbe@0:         1, 100 );
jbe@0: 
jbe@0: INSERT INTO "area" (
jbe@0:         "id",
jbe@0:         "active",
jbe@0:         "name",
jbe@0:         "description"
jbe@0:     ) VALUES (
jbe@0:         DEFAULT,
jbe@0:         TRUE,
jbe@0:         'Generic area',
jbe@0:         DEFAULT );
jbe@0: 
jbe@0: COMMIT;