liquid_feedback_core

diff demo.sql @ 155:043e6e235a53

find changesets by author, revision, files, or words in the commit message
Added configuration option to allow indirect supermajority requirements

- Added column "majority_indirect" to table "policy"
- Do not calculate "attainable" field in function "close_voting" but in function "calculate_ranks"
- Copy "positive_votes" and "negative_votes" from "battle" table, instead of calculating them seperatly
- Optionally regarding indirect (super)majorities in "calculate_ranks"
author jbe
date Fri Jun 03 13:28:51 2011 +0200 (2011-06-03)
parents 8e7d583e02f9
children 32887495ca57
line diff
     1.1 --- a/demo.sql	Fri Jun 03 02:50:59 2011 +0200
     1.2 +++ b/demo.sql	Fri Jun 03 13:28:51 2011 +0200
     1.3 @@ -32,24 +32,26 @@
     1.4  UPDATE "member" SET "password" = '$1$PcI6b1Bg$2SHjAZH2nMLFp0fxHis.Q0';
     1.5  
     1.6  INSERT INTO "policy" (
     1.7 -        "index",
     1.8 -        "name",
     1.9 -        "admission_time",
    1.10 -        "discussion_time",
    1.11 -        "verification_time",
    1.12 -        "voting_time",
    1.13 -        "issue_quorum_num", "issue_quorum_den",
    1.14 -        "initiative_quorum_num", "initiative_quorum_den",
    1.15 -	"majority_num", "majority_den", "majority_strict",
    1.16 -	"no_multistage_majority", "no_reverse_beat_path"
    1.17 -    ) VALUES (
    1.18 -        1,
    1.19 -        'Default policy',
    1.20 -        '1 hour', '1 hour', '1 hour', '1 hour',
    1.21 -        25, 100,
    1.22 -        20, 100,
    1.23 -        1, 2, TRUE,
    1.24 -        TRUE, FALSE );
    1.25 +    "index",
    1.26 +    "name",
    1.27 +    "admission_time",
    1.28 +    "discussion_time",
    1.29 +    "verification_time",
    1.30 +    "voting_time",
    1.31 +    "issue_quorum_num", "issue_quorum_den",
    1.32 +    "initiative_quorum_num", "initiative_quorum_den",
    1.33 +    "majority_num", "majority_den", "majority_strict",
    1.34 +    "majority_indirect",
    1.35 +    "no_reverse_beat_path", "no_multistage_majority"
    1.36 +  ) VALUES (
    1.37 +    1,
    1.38 +    'Default policy',
    1.39 +    '1 hour', '1 hour', '1 hour', '1 hour',
    1.40 +    25, 100,
    1.41 +    20, 100,
    1.42 +    1, 2, TRUE,
    1.43 +    TRUE,
    1.44 +    TRUE, FALSE );
    1.45  
    1.46  CREATE FUNCTION "time_warp"() RETURNS VOID
    1.47    LANGUAGE 'plpgsql' VOLATILE AS $$

Impressum / About Us