liquid_feedback_core
view init.sql @ 6:3ea7a72ed7e7
Version beta7
Fixed bug in function close_voting(...) leading to wrong voter_count values in issue table
Added avatar column to member table for storing a small picture of the member
Fixed bug in function close_voting(...) leading to wrong voter_count values in issue table
Added avatar column to member table for storing a small picture of the member
| author | jbe |
|---|---|
| date | Wed Nov 18 12:00:00 2009 +0100 (2009-11-18) |
| parents | 8d021cb5eaf4 |
| children | 69d84040fb93 |
line source
1 -- NOTE: This file creates an admin user with an empty password!
3 BEGIN;
5 INSERT INTO "member" (
6 "id",
7 "login",
8 "password",
9 "active",
10 "admin",
11 "name",
12 "ident_number"
13 ) VALUES (
14 DEFAULT,
15 'admin',
16 '',
17 TRUE,
18 TRUE,
19 'Administrator',
20 DEFAULT );
22 INSERT INTO "policy" (
23 "id",
24 "active",
25 "name",
26 "description",
27 "admission_time",
28 "discussion_time",
29 "voting_time",
30 "issue_quorum_num",
31 "issue_quorum_den",
32 "initiative_quorum_num",
33 "initiative_quorum_den"
34 ) VALUES (
35 DEFAULT,
36 TRUE,
37 'Extensive proceeding',
38 DEFAULT,
39 '1 month',
40 '6 months',
41 '3 weeks',
42 5, 100,
43 1, 100
44 ), (
45 DEFAULT,
46 TRUE,
47 'Standard proceeding',
48 DEFAULT,
49 '1 week',
50 '1 month',
51 '1 week',
52 5, 100,
53 1, 100
54 ), (
55 DEFAULT,
56 TRUE,
57 'Fast proceeding',
58 DEFAULT,
59 '24 hours',
60 '4 hours',
61 '20 hours',
62 5, 100,
63 1, 100 );
65 INSERT INTO "area" (
66 "id",
67 "active",
68 "name",
69 "description"
70 ) VALUES (
71 DEFAULT,
72 TRUE,
73 'Generic area',
74 DEFAULT );
76 COMMIT;