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;