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

Impressum / About Us