annotate init.sql @ 0:8d021cb5eaf4
Version beta1
author |
jbe |
date |
Tue Oct 27 12:00:00 2009 +0100 (2009-10-27) |
parents |
|
children |
69d84040fb93 |
rev |
line source |
jbe@0
|
1 -- NOTE: This file creates an admin user with an empty password!
|
jbe@0
|
2
|
jbe@0
|
3 BEGIN;
|
jbe@0
|
4
|
jbe@0
|
5 INSERT INTO "member" (
|
jbe@0
|
6 "id",
|
jbe@0
|
7 "login",
|
jbe@0
|
8 "password",
|
jbe@0
|
9 "active",
|
jbe@0
|
10 "admin",
|
jbe@0
|
11 "name",
|
jbe@0
|
12 "ident_number"
|
jbe@0
|
13 ) VALUES (
|
jbe@0
|
14 DEFAULT,
|
jbe@0
|
15 'admin',
|
jbe@0
|
16 '',
|
jbe@0
|
17 TRUE,
|
jbe@0
|
18 TRUE,
|
jbe@0
|
19 'Administrator',
|
jbe@0
|
20 DEFAULT );
|
jbe@0
|
21
|
jbe@0
|
22 INSERT INTO "policy" (
|
jbe@0
|
23 "id",
|
jbe@0
|
24 "active",
|
jbe@0
|
25 "name",
|
jbe@0
|
26 "description",
|
jbe@0
|
27 "admission_time",
|
jbe@0
|
28 "discussion_time",
|
jbe@0
|
29 "voting_time",
|
jbe@0
|
30 "issue_quorum_num",
|
jbe@0
|
31 "issue_quorum_den",
|
jbe@0
|
32 "initiative_quorum_num",
|
jbe@0
|
33 "initiative_quorum_den"
|
jbe@0
|
34 ) VALUES (
|
jbe@0
|
35 DEFAULT,
|
jbe@0
|
36 TRUE,
|
jbe@0
|
37 'Extensive proceeding',
|
jbe@0
|
38 DEFAULT,
|
jbe@0
|
39 '1 month',
|
jbe@0
|
40 '6 months',
|
jbe@0
|
41 '3 weeks',
|
jbe@0
|
42 5, 100,
|
jbe@0
|
43 1, 100
|
jbe@0
|
44 ), (
|
jbe@0
|
45 DEFAULT,
|
jbe@0
|
46 TRUE,
|
jbe@0
|
47 'Standard proceeding',
|
jbe@0
|
48 DEFAULT,
|
jbe@0
|
49 '1 week',
|
jbe@0
|
50 '1 month',
|
jbe@0
|
51 '1 week',
|
jbe@0
|
52 5, 100,
|
jbe@0
|
53 1, 100
|
jbe@0
|
54 ), (
|
jbe@0
|
55 DEFAULT,
|
jbe@0
|
56 TRUE,
|
jbe@0
|
57 'Fast proceeding',
|
jbe@0
|
58 DEFAULT,
|
jbe@0
|
59 '24 hours',
|
jbe@0
|
60 '4 hours',
|
jbe@0
|
61 '20 hours',
|
jbe@0
|
62 5, 100,
|
jbe@0
|
63 1, 100 );
|
jbe@0
|
64
|
jbe@0
|
65 INSERT INTO "area" (
|
jbe@0
|
66 "id",
|
jbe@0
|
67 "active",
|
jbe@0
|
68 "name",
|
jbe@0
|
69 "description"
|
jbe@0
|
70 ) VALUES (
|
jbe@0
|
71 DEFAULT,
|
jbe@0
|
72 TRUE,
|
jbe@0
|
73 'Generic area',
|
jbe@0
|
74 DEFAULT );
|
jbe@0
|
75
|
jbe@0
|
76 COMMIT;
|