liquid_feedback_core

diff test.sql @ 532:5855ff9e5c8f

Several changes/additions for upcoming major release

- OAuth 2.0 support
- storing profiles as JSON document
- removed subject area membership
- revised snapshot system
- additional issue limiter (dynamic quorum in subject area)
- extended event logging in "event" table
author jbe
date Thu Mar 30 19:42:38 2017 +0200 (2017-03-30)
parents 3e28fd842354
children
line diff
     1.1 --- a/test.sql	Sun Aug 21 17:31:44 2016 +0200
     1.2 +++ b/test.sql	Thu Mar 30 19:42:38 2017 +0200
     1.3 @@ -42,16 +42,16 @@
     1.4      "discussion_time",
     1.5      "verification_time",
     1.6      "voting_time",
     1.7 -    "issue_quorum",
     1.8 -    "initiative_quorum_num", "initiative_quorum_den",
     1.9 +    "issue_quorum", "issue_quorum_num", "issue_quorum_den",
    1.10 +    "initiative_quorum", "initiative_quorum_num", "initiative_quorum_den",
    1.11      "direct_majority_num", "direct_majority_den", "direct_majority_strict",
    1.12      "no_reverse_beat_path", "no_multistage_majority"
    1.13    ) VALUES (
    1.14      1,
    1.15      'Default policy',
    1.16      '0', '1 hour', '1 hour', '1 hour', '1 hour',
    1.17 -    3,
    1.18 -    30, 100,
    1.19 +    1, 10, 100,
    1.20 +    1, 30, 100,
    1.21      1, 2, TRUE,
    1.22      TRUE, FALSE );
    1.23  
    1.24 @@ -70,11 +70,6 @@
    1.25  
    1.26  INSERT INTO "unit" ("name") VALUES ('Main');
    1.27  
    1.28 -INSERT INTO "admission_rule" ("unit_id", "name") VALUES (1, 'General admission rule');
    1.29 -
    1.30 -INSERT INTO "admission_rule_condition" ("admission_rule_id", "unit_id", "holdoff_time")
    1.31 -  VALUES (1, 1, '0 seconds');
    1.32 -
    1.33  INSERT INTO "privilege" ("unit_id", "member_id", "voting_right")
    1.34    SELECT 1 AS "unit_id", "id" AS "member_id", TRUE AS "voting_right"
    1.35    FROM "member";
    1.36 @@ -409,6 +404,9 @@
    1.37          "verification_time",
    1.38          "voting_time",
    1.39          "issue_quorum",
    1.40 +        "issue_quorum_num",
    1.41 +        "issue_quorum_den",
    1.42 +        "initiative_quorum",
    1.43          "initiative_quorum_num",
    1.44          "initiative_quorum_den"
    1.45      ) VALUES (
    1.46 @@ -421,8 +419,8 @@
    1.47          '1 second',
    1.48          '1 second',
    1.49          '1 second',
    1.50 -        1,
    1.51 -        0, 100
    1.52 +        1, 0, 100,
    1.53 +        1, 0, 100
    1.54      ), (
    1.55          1,
    1.56          TRUE,
    1.57 @@ -433,8 +431,8 @@
    1.58          '2 days',
    1.59          '1 second',
    1.60          '1 second',
    1.61 -        1,
    1.62 -        0, 100
    1.63 +        1, 0, 100,
    1.64 +        1, 0, 100
    1.65      ), (
    1.66          1,
    1.67          TRUE,
    1.68 @@ -445,8 +443,8 @@
    1.69          '5 minutes',
    1.70          '2 days',
    1.71          '1 second',
    1.72 -        1,
    1.73 -        0, 100
    1.74 +        1, 0, 100,
    1.75 +        1, 0, 100
    1.76      ), (
    1.77          1,
    1.78          TRUE,
    1.79 @@ -457,8 +455,8 @@
    1.80          '5 minutes',
    1.81          '1 second',
    1.82          '2 days',
    1.83 -        1,
    1.84 -        0, 100
    1.85 +        1, 0, 100,
    1.86 +        1, 0, 100
    1.87      );
    1.88  
    1.89  END;

Impressum / About Us