annotate init.sql @ 569:622c71ca6428
Bugfix in view "unit_member" (wrong ON clause for JOIN)
| author |
jbe |
| date |
Fri Sep 29 19:37:49 2017 +0200 (2017-09-29) |
| parents |
6fce4f08157b |
| children |
|
| 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@97
|
5 INSERT INTO "unit" (
|
|
jbe@97
|
6 "active",
|
|
jbe@97
|
7 "name",
|
|
jbe@97
|
8 "description"
|
|
jbe@97
|
9 ) VALUES (
|
|
jbe@97
|
10 true,
|
|
jbe@97
|
11 'Default unit',
|
|
jbe@97
|
12 'Default unit created by init script.'
|
|
jbe@97
|
13 );
|
|
jbe@97
|
14
|
|
jbe@97
|
15
|
|
jbe@0
|
16 INSERT INTO "member" (
|
|
jbe@0
|
17 "login",
|
|
jbe@0
|
18 "password",
|
|
jbe@0
|
19 "active",
|
|
jbe@0
|
20 "admin",
|
|
lars@208
|
21 "name",
|
|
lars@208
|
22 "activated",
|
|
lars@208
|
23 "last_activity"
|
|
jbe@0
|
24 ) VALUES (
|
|
jbe@0
|
25 'admin',
|
|
jbe@9
|
26 '$1$.EMPTY.$LDufa24OE2HZFXAXh71Eb1',
|
|
jbe@0
|
27 TRUE,
|
|
jbe@0
|
28 TRUE,
|
|
lars@208
|
29 'Administrator',
|
|
lars@208
|
30 NOW(),
|
|
lars@208
|
31 NOW()
|
|
lars@208
|
32 );
|
|
jbe@0
|
33
|
|
jbe@0
|
34 INSERT INTO "policy" (
|
|
jbe@9
|
35 "index",
|
|
jbe@0
|
36 "active",
|
|
jbe@0
|
37 "name",
|
|
jbe@0
|
38 "description",
|
|
jbe@0
|
39 "admission_time",
|
|
jbe@0
|
40 "discussion_time",
|
|
jbe@7
|
41 "verification_time",
|
|
jbe@0
|
42 "voting_time",
|
|
jbe@0
|
43 "issue_quorum_num",
|
|
jbe@0
|
44 "issue_quorum_den",
|
|
jbe@0
|
45 "initiative_quorum_num",
|
|
jbe@0
|
46 "initiative_quorum_den"
|
|
jbe@0
|
47 ) VALUES (
|
|
jbe@9
|
48 1,
|
|
jbe@0
|
49 TRUE,
|
|
jbe@0
|
50 'Extensive proceeding',
|
|
jbe@0
|
51 DEFAULT,
|
|
jbe@0
|
52 '1 month',
|
|
jbe@7
|
53 '5 months',
|
|
jbe@7
|
54 '1 month',
|
|
jbe@0
|
55 '3 weeks',
|
|
jbe@7
|
56 10, 100,
|
|
jbe@7
|
57 10, 100
|
|
jbe@0
|
58 ), (
|
|
jbe@9
|
59 2,
|
|
jbe@0
|
60 TRUE,
|
|
jbe@0
|
61 'Standard proceeding',
|
|
jbe@0
|
62 DEFAULT,
|
|
jbe@7
|
63 '1 month',
|
|
jbe@0
|
64 '1 month',
|
|
jbe@0
|
65 '1 week',
|
|
jbe@7
|
66 '1 week',
|
|
jbe@7
|
67 10, 100,
|
|
jbe@7
|
68 10, 100
|
|
jbe@0
|
69 ), (
|
|
jbe@9
|
70 3,
|
|
jbe@0
|
71 TRUE,
|
|
jbe@0
|
72 'Fast proceeding',
|
|
jbe@0
|
73 DEFAULT,
|
|
jbe@7
|
74 '48 hours',
|
|
jbe@7
|
75 '3 hours',
|
|
jbe@7
|
76 '1 hour',
|
|
jbe@0
|
77 '20 hours',
|
|
jbe@7
|
78 1, 100,
|
|
jbe@0
|
79 1, 100 );
|
|
jbe@0
|
80
|
|
jbe@0
|
81 INSERT INTO "area" (
|
|
jbe@97
|
82 "unit_id",
|
|
jbe@0
|
83 "active",
|
|
jbe@0
|
84 "name",
|
|
jbe@0
|
85 "description"
|
|
jbe@0
|
86 ) VALUES (
|
|
jbe@97
|
87 1,
|
|
jbe@0
|
88 TRUE,
|
|
jbe@0
|
89 'Generic area',
|
|
jbe@0
|
90 DEFAULT );
|
|
jbe@0
|
91
|
|
jbe@0
|
92 COMMIT;
|