liquid_feedback_core
diff test.sql @ 528:3e28fd842354
Work on new issue admission system (replacing current approach of 1st quorum); Added support for geo-tagging and spatial indexing
author | jbe |
---|---|
date | Sun May 29 20:42:40 2016 +0200 (2016-05-29) |
parents | fae00a5c1c71 |
children | 5855ff9e5c8f |
line diff
1.1 --- a/test.sql Fri May 27 09:48:34 2016 +0200 1.2 +++ b/test.sql Sun May 29 20:42:40 2016 +0200 1.3 @@ -51,7 +51,7 @@ 1.4 'Default policy', 1.5 '0', '1 hour', '1 hour', '1 hour', '1 hour', 1.6 3, 1.7 - 20, 100, 1.8 + 30, 100, 1.9 1, 2, TRUE, 1.10 TRUE, FALSE ); 1.11 1.12 @@ -59,7 +59,6 @@ 1.13 LANGUAGE 'plpgsql' VOLATILE AS $$ 1.14 BEGIN 1.15 UPDATE "issue" SET 1.16 - "snapshot" = "snapshot" - '1 hour 1 minute'::INTERVAL, 1.17 "created" = "created" - '1 hour 1 minute'::INTERVAL, 1.18 "accepted" = "accepted" - '1 hour 1 minute'::INTERVAL, 1.19 "half_frozen" = "half_frozen" - '1 hour 1 minute'::INTERVAL, 1.20 @@ -71,6 +70,11 @@ 1.21 1.22 INSERT INTO "unit" ("name") VALUES ('Main'); 1.23 1.24 +INSERT INTO "admission_rule" ("unit_id", "name") VALUES (1, 'General admission rule'); 1.25 + 1.26 +INSERT INTO "admission_rule_condition" ("admission_rule_id", "unit_id", "holdoff_time") 1.27 + VALUES (1, 1, '0 seconds'); 1.28 + 1.29 INSERT INTO "privilege" ("unit_id", "member_id", "voting_right") 1.30 SELECT 1 AS "unit_id", "id" AS "member_id", TRUE AS "voting_right" 1.31 FROM "member"; 1.32 @@ -84,24 +88,6 @@ 1.33 INSERT INTO "allowed_policy" ("area_id", "policy_id", "default_policy") 1.34 VALUES (1, 1, TRUE), (2, 1, TRUE), (3, 1, TRUE), (4, 1, TRUE); 1.35 1.36 -INSERT INTO "membership" ("area_id", "member_id") VALUES 1.37 - (1, 9), 1.38 - (1, 19), 1.39 - (2, 9), 1.40 - (2, 10), 1.41 - (2, 17), 1.42 - (3, 9), 1.43 - (3, 11), 1.44 - (3, 12), 1.45 - (3, 14), 1.46 - (3, 20), 1.47 - (3, 21), 1.48 - (3, 22), 1.49 - (4, 6), 1.50 - (4, 9), 1.51 - (4, 13), 1.52 - (4, 22); 1.53 - 1.54 -- global delegations 1.55 INSERT INTO "delegation" 1.56 ("truster_id", "scope", "unit_id", "trustee_id") VALUES