liquid_feedback_core
view init.sql @ 8:e6faf5ff83af
Version beta9
Added missing indicies on TSVECTOR fields
New field latest_snapshot_event in table issue specifying the type of the latest snapshot taken
Added weight field also for (intermediate) delegating members in snapshot and voter tables
Possibility for an initiative to specify a URL where an external discussion takes place (discussion_url)
Export concept for creating a database dump, without some non-public information (e.g. private contact data), including:
- Shell script lf_export
- Database function delete_private_data()
Field in member table to be used by a frontend to store information about hints being hidden by the user
Minor cleanup / New comments
Added missing indicies on TSVECTOR fields
New field latest_snapshot_event in table issue specifying the type of the latest snapshot taken
Added weight field also for (intermediate) delegating members in snapshot and voter tables
Possibility for an initiative to specify a URL where an external discussion takes place (discussion_url)
Export concept for creating a database dump, without some non-public information (e.g. private contact data), including:
- Shell script lf_export
- Database function delete_private_data()
Field in member table to be used by a frontend to store information about hints being hidden by the user
Minor cleanup / New comments
| author | jbe |
|---|---|
| date | Mon Nov 30 12:00:00 2009 +0100 (2009-11-30) |
| parents | 69d84040fb93 |
| children | 4af4df1415f9 |
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 ) VALUES (
13 DEFAULT,
14 'admin',
15 '',
16 TRUE,
17 TRUE,
18 'Administrator' );
20 INSERT INTO "policy" (
21 "id",
22 "active",
23 "name",
24 "description",
25 "admission_time",
26 "discussion_time",
27 "verification_time",
28 "voting_time",
29 "issue_quorum_num",
30 "issue_quorum_den",
31 "initiative_quorum_num",
32 "initiative_quorum_den"
33 ) VALUES (
34 DEFAULT,
35 TRUE,
36 'Extensive proceeding',
37 DEFAULT,
38 '1 month',
39 '5 months',
40 '1 month',
41 '3 weeks',
42 10, 100,
43 10, 100
44 ), (
45 DEFAULT,
46 TRUE,
47 'Standard proceeding',
48 DEFAULT,
49 '1 month',
50 '1 month',
51 '1 week',
52 '1 week',
53 10, 100,
54 10, 100
55 ), (
56 DEFAULT,
57 TRUE,
58 'Fast proceeding',
59 DEFAULT,
60 '48 hours',
61 '3 hours',
62 '1 hour',
63 '20 hours',
64 1, 100,
65 1, 100 );
67 INSERT INTO "area" (
68 "id",
69 "active",
70 "name",
71 "description"
72 ) VALUES (
73 DEFAULT,
74 TRUE,
75 'Generic area',
76 DEFAULT );
78 COMMIT;