liquid_feedback_core

view init.sql @ 10:effdd7a04ea7

Version beta11

Support is now automatically deleted, when interest is deleted

All tables dealing with delegations now contain a column scope (including table delegation)

Changes in fields related to notify_email of member

Policies can now specify larger majorities to be reached (e.g. 2/3)

New column agreed in table initiative to mark, if initiative has reached majority specified by policy

Minor bugfix in constraint non_admitted_initiatives_cant_contain_voting_results of initiative table

Function delete_private_data() no longer deletes invite codes, which have been already used

Removed view battle_participant

Added index on opinion (member_id, initiative_id)
author jbe
date Fri Dec 25 12:00:00 2009 +0100 (2009-12-25)
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