liquid_feedback_core
view init.sql @ 378:e88d0606891f
Bugfix regarding "proportional_order" of suggestions:
Use NULL values explicitly to be sorted last
(includes new suggestions as well as suggestions without any individual rankings)
Use NULL values explicitly to be sorted last
(includes new suggestions as well as suggestions without any individual rankings)
author | jbe |
---|---|
date | Mon Mar 18 09:36:21 2013 +0100 (2013-03-18) |
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;