liquid_feedback_core

changeset 396:ad50723ef4ed

Update script to v2.2.6
author jbe
date Fri Oct 11 13:17:29 2013 +0200 (2013-10-11)
parents d93428e4edad
children 1e4fcb7f0eac
files core.sql update/core-update.v2.2.5-v2.2.6.sql
line diff
     1.1 --- a/core.sql	Fri Oct 11 13:05:29 2013 +0200
     1.2 +++ b/core.sql	Fri Oct 11 13:17:29 2013 +0200
     1.3 @@ -7,7 +7,7 @@
     1.4  BEGIN;
     1.5  
     1.6  CREATE VIEW "liquid_feedback_version" AS
     1.7 -  SELECT * FROM (VALUES ('2.2.5', 2, 2, 5))
     1.8 +  SELECT * FROM (VALUES ('2.2.6', 2, 2, 6))
     1.9    AS "subquery"("string", "major", "minor", "revision");
    1.10  
    1.11  
     2.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     2.2 +++ b/update/core-update.v2.2.5-v2.2.6.sql	Fri Oct 11 13:17:29 2013 +0200
     2.3 @@ -0,0 +1,29 @@
     2.4 +BEGIN;
     2.5 +
     2.6 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS
     2.7 +  SELECT * FROM (VALUES ('2.2.6', 2, 2, 6))
     2.8 +  AS "subquery"("string", "major", "minor", "revision");
     2.9 +
    2.10 +ALTER TABLE "issue" ADD COLUMN "order_in_admission_state" INT4;
    2.11 +ALTER TABLE "issue" ADD COLUMN "order_in_open_states"     INT4;
    2.12 +
    2.13 +COMMENT ON COLUMN "issue"."order_in_admission_state" IS 'To be used for sorting issues within an area, when showing only issues in admission state; NULL values sort last; updated by "lf_update_issue_order"';
    2.14 +COMMENT ON COLUMN "issue"."order_in_open_states"     IS 'To be used for sorting issues within an area, when showing all open issues; NULL values sort last; updated by "lf_update_issue_order"';
    2.15 +
    2.16 +CREATE VIEW "issue_supporter_in_admission_state" AS
    2.17 +  SELECT DISTINCT
    2.18 +    "issue"."area_id",
    2.19 +    "issue"."id" AS "issue_id",
    2.20 +    "supporter"."member_id",
    2.21 +    "direct_interest_snapshot"."weight"
    2.22 +  FROM "issue"
    2.23 +  JOIN "supporter" ON "supporter"."issue_id" = "issue"."id"
    2.24 +  JOIN "direct_interest_snapshot"
    2.25 +    ON  "direct_interest_snapshot"."issue_id" = "issue"."id"
    2.26 +    AND "direct_interest_snapshot"."event" = "issue"."latest_snapshot_event"
    2.27 +    AND "direct_interest_snapshot"."member_id" = "supporter"."member_id"
    2.28 +  WHERE "issue"."state" = 'admission'::"issue_state";
    2.29 +
    2.30 +COMMENT ON VIEW "issue_supporter_in_admission_state" IS 'Helper view for "lf_update_issue_order" to allow a (proportional) ordering of issues within an area';
    2.31 +
    2.32 +COMMIT;

Impressum / About Us