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:         "login",
jbe@0:         "password",
jbe@0:         "active",
jbe@0:         "admin",
jbe@7:         "name"
jbe@0:     ) VALUES (
jbe@0:         'admin',
jbe@9:         '$1$.EMPTY.$LDufa24OE2HZFXAXh71Eb1',
jbe@0:         TRUE,
jbe@0:         TRUE,
jbe@7:         'Administrator' );
jbe@0: 
jbe@0: INSERT INTO "policy" (
jbe@9:         "index",
jbe@0:         "active",
jbe@0:         "name",
jbe@0:         "description",
jbe@0:         "admission_time",
jbe@0:         "discussion_time",
jbe@7:         "verification_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@9:         1,
jbe@0:         TRUE,
jbe@0:         'Extensive proceeding',
jbe@0:         DEFAULT,
jbe@0:         '1 month',
jbe@7:         '5 months',
jbe@7:         '1 month',
jbe@0:         '3 weeks',
jbe@7:         10, 100,
jbe@7:         10, 100
jbe@0:     ), (
jbe@9:         2,
jbe@0:         TRUE,
jbe@0:         'Standard proceeding',
jbe@0:         DEFAULT,
jbe@7:         '1 month',
jbe@0:         '1 month',
jbe@0:         '1 week',
jbe@7:         '1 week',
jbe@7:         10, 100,
jbe@7:         10, 100
jbe@0:     ), (
jbe@9:        3,
jbe@0:        TRUE,
jbe@0:        'Fast proceeding',
jbe@0:        DEFAULT,
jbe@7:        '48 hours',
jbe@7:        '3 hours',
jbe@7:        '1 hour',
jbe@0:        '20 hours',
jbe@7:         1, 100,
jbe@0:         1, 100 );
jbe@0: 
jbe@0: INSERT INTO "area" (
jbe@0:         "active",
jbe@0:         "name",
jbe@0:         "description"
jbe@0:     ) VALUES (
jbe@0:         TRUE,
jbe@0:         'Generic area',
jbe@0:         DEFAULT );
jbe@0: 
jbe@0: COMMIT;