liquid_feedback_core
view init.sql @ 491:aa94c7dbb20f
New function "get_initiatives_for_notification"
| author | jbe |
|---|---|
| date | Sun Apr 03 19:42:09 2016 +0200 (2016-04-03) |
| parents | 6fce4f08157b |
| children |
line source
1 -- NOTE: This file creates an admin user with an empty password!
3 BEGIN;
5 INSERT INTO "unit" (
6 "active",
7 "name",
8 "description"
9 ) VALUES (
10 true,
11 'Default unit',
12 'Default unit created by init script.'
13 );
16 INSERT INTO "member" (
17 "login",
18 "password",
19 "active",
20 "admin",
21 "name",
22 "activated",
23 "last_activity"
24 ) VALUES (
25 'admin',
26 '$1$.EMPTY.$LDufa24OE2HZFXAXh71Eb1',
27 TRUE,
28 TRUE,
29 'Administrator',
30 NOW(),
31 NOW()
32 );
34 INSERT INTO "policy" (
35 "index",
36 "active",
37 "name",
38 "description",
39 "admission_time",
40 "discussion_time",
41 "verification_time",
42 "voting_time",
43 "issue_quorum_num",
44 "issue_quorum_den",
45 "initiative_quorum_num",
46 "initiative_quorum_den"
47 ) VALUES (
48 1,
49 TRUE,
50 'Extensive proceeding',
51 DEFAULT,
52 '1 month',
53 '5 months',
54 '1 month',
55 '3 weeks',
56 10, 100,
57 10, 100
58 ), (
59 2,
60 TRUE,
61 'Standard proceeding',
62 DEFAULT,
63 '1 month',
64 '1 month',
65 '1 week',
66 '1 week',
67 10, 100,
68 10, 100
69 ), (
70 3,
71 TRUE,
72 'Fast proceeding',
73 DEFAULT,
74 '48 hours',
75 '3 hours',
76 '1 hour',
77 '20 hours',
78 1, 100,
79 1, 100 );
81 INSERT INTO "area" (
82 "unit_id",
83 "active",
84 "name",
85 "description"
86 ) VALUES (
87 1,
88 TRUE,
89 'Generic area',
90 DEFAULT );
92 COMMIT;