liquid_feedback_core
view init.sql @ 94:fb9688f31740
Corrected "delete_member" and "delete_private_data" functions to refer to "ignored_issue" table instead of non-existing "ignored_voting" table; Delete "ignored_issue" entries in "clean_issue" function as well
| author | jbe |
|---|---|
| date | Sun Oct 31 02:38:05 2010 +0200 (2010-10-31) |
| parents | 4af4df1415f9 |
| children | 58451b5565ae |
line source
1 -- NOTE: This file creates an admin user with an empty password!
3 BEGIN;
5 INSERT INTO "member" (
6 "login",
7 "password",
8 "active",
9 "admin",
10 "name"
11 ) VALUES (
12 'admin',
13 '$1$.EMPTY.$LDufa24OE2HZFXAXh71Eb1',
14 TRUE,
15 TRUE,
16 'Administrator' );
18 INSERT INTO "policy" (
19 "index",
20 "active",
21 "name",
22 "description",
23 "admission_time",
24 "discussion_time",
25 "verification_time",
26 "voting_time",
27 "issue_quorum_num",
28 "issue_quorum_den",
29 "initiative_quorum_num",
30 "initiative_quorum_den"
31 ) VALUES (
32 1,
33 TRUE,
34 'Extensive proceeding',
35 DEFAULT,
36 '1 month',
37 '5 months',
38 '1 month',
39 '3 weeks',
40 10, 100,
41 10, 100
42 ), (
43 2,
44 TRUE,
45 'Standard proceeding',
46 DEFAULT,
47 '1 month',
48 '1 month',
49 '1 week',
50 '1 week',
51 10, 100,
52 10, 100
53 ), (
54 3,
55 TRUE,
56 'Fast proceeding',
57 DEFAULT,
58 '48 hours',
59 '3 hours',
60 '1 hour',
61 '20 hours',
62 1, 100,
63 1, 100 );
65 INSERT INTO "area" (
66 "active",
67 "name",
68 "description"
69 ) VALUES (
70 TRUE,
71 'Generic area',
72 DEFAULT );
74 COMMIT;