liquid_feedback_core
view init.sql @ 78:4fc1779a9c98
add test policies
the test policies have values that move them quickly to the target area for frontend development
the test policies have values that move them quickly to the target area for frontend development
author | Daniel Poelzleithner <poelzi@poelzi.org> |
---|---|
date | Mon Oct 04 14:24:29 2010 +0200 (2010-10-04) |
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;