liquid_feedback_core

diff demo.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: 5d7b482241fa
     1.1 --- a/demo.sql	Thu Dec 10 12:00:00 2009 +0100
     1.2 +++ b/demo.sql	Fri Dec 25 12:00:00 2009 +0100
     1.3 @@ -89,35 +89,35 @@
     1.4  
     1.5  -- global delegations
     1.6  INSERT INTO "delegation"
     1.7 -  ("truster_id", "trustee_id") VALUES
     1.8 -  ( 1,  9),
     1.9 -  ( 2, 11),
    1.10 -  ( 3, 12),
    1.11 -  ( 4, 13),
    1.12 -  ( 5, 14),
    1.13 -  ( 6,  7),
    1.14 -  ( 7,  8),
    1.15 -  ( 8,  6),
    1.16 -  (10,  9),
    1.17 -  (11,  9),
    1.18 -  (12, 21),
    1.19 -  (15, 10),
    1.20 -  (16, 17),
    1.21 -  (17, 19),
    1.22 -  (18, 19),
    1.23 -  (23, 22);
    1.24 +  ("truster_id", "scope", "trustee_id") VALUES
    1.25 +  ( 1, 'global',  9),
    1.26 +  ( 2, 'global', 11),
    1.27 +  ( 3, 'global', 12),
    1.28 +  ( 4, 'global', 13),
    1.29 +  ( 5, 'global', 14),
    1.30 +  ( 6, 'global',  7),
    1.31 +  ( 7, 'global',  8),
    1.32 +  ( 8, 'global',  6),
    1.33 +  (10, 'global',  9),
    1.34 +  (11, 'global',  9),
    1.35 +  (12, 'global', 21),
    1.36 +  (15, 'global', 10),
    1.37 +  (16, 'global', 17),
    1.38 +  (17, 'global', 19),
    1.39 +  (18, 'global', 19),
    1.40 +  (23, 'global', 22);
    1.41  
    1.42  -- delegations for topics
    1.43  INSERT INTO "delegation"
    1.44 -  ("area_id", "truster_id", "trustee_id") VALUES
    1.45 -  (1,  3, 17),
    1.46 -  (2,  5, 10),
    1.47 -  (2,  9, 10),
    1.48 -  (3,  4, 14),
    1.49 -  (3, 16, 20),
    1.50 -  (3, 19, 20),
    1.51 -  (4,  5, 13),
    1.52 -  (4, 12, 22);
    1.53 +  ("area_id", "truster_id", "scope", "trustee_id") VALUES
    1.54 +  (1,  3, 'area', 17),
    1.55 +  (2,  5, 'area', 10),
    1.56 +  (2,  9, 'area', 10),
    1.57 +  (3,  4, 'area', 14),
    1.58 +  (3, 16, 'area', 20),
    1.59 +  (3, 19, 'area', 20),
    1.60 +  (4,  5, 'area', 13),
    1.61 +  (4, 12, 'area', 22);
    1.62  
    1.63  INSERT INTO "issue" ("area_id", "policy_id") VALUES
    1.64    (3, 1);  -- id 1
author	jbe
date	Fri Dec 25 12:00:00 2009 +0100 (2009-12-25)
parents	4af4df1415f9
children	5d7b482241fa