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
- 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;