liquid_feedback_core
view init.sql @ 84:b0866d51b754
Backed out changesets dfa8e6a1f1e7, ca13b2614d10, and partly 0758a2e02620
- auto_support feature shall be added but implemented in a different way
- Delegating to non-active members shall be possible in database
- Incoming delegations MUST NOT be deleted when calling "delete_member"
- Index on "initiative"("issue_id") is not neccessary due to UNIQUE ("issue_id", "id") statement
- auto_support feature shall be added but implemented in a different way
- Delegating to non-active members shall be possible in database
- Incoming delegations MUST NOT be deleted when calling "delete_member"
- Index on "initiative"("issue_id") is not neccessary due to UNIQUE ("issue_id", "id") statement
| author | jbe |
|---|---|
| date | Sat Oct 16 23:56:35 2010 +0200 (2010-10-16) |
| 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;