liquid_feedback_core

view init.sql @ 72:dcaa1525c388

Removed unintentionally inserted extra columns in view "global_delegation" in previous commit; Update script from v1.2.5 to v1.2.6 also works with PostgreSQL 8.3 now; Update script from v1.2.6 to v1.2.7 added
author jbe
date Mon Aug 30 23:49:32 2010 +0200 (2010-08-30)
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;

Impressum / About Us