liquid_feedback_core
view update/core-update.v2.2.5-v2.2.6.sql @ 396:ad50723ef4ed
Update script to v2.2.6
| author | jbe |
|---|---|
| date | Fri Oct 11 13:17:29 2013 +0200 (2013-10-11) |
| parents | |
| children | 1e4fcb7f0eac |
line source
1 BEGIN;
3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS
4 SELECT * FROM (VALUES ('2.2.6', 2, 2, 6))
5 AS "subquery"("string", "major", "minor", "revision");
7 ALTER TABLE "issue" ADD COLUMN "order_in_admission_state" INT4;
8 ALTER TABLE "issue" ADD COLUMN "order_in_open_states" INT4;
10 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"';
11 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"';
13 CREATE VIEW "issue_supporter_in_admission_state" AS
14 SELECT DISTINCT
15 "issue"."area_id",
16 "issue"."id" AS "issue_id",
17 "supporter"."member_id",
18 "direct_interest_snapshot"."weight"
19 FROM "issue"
20 JOIN "supporter" ON "supporter"."issue_id" = "issue"."id"
21 JOIN "direct_interest_snapshot"
22 ON "direct_interest_snapshot"."issue_id" = "issue"."id"
23 AND "direct_interest_snapshot"."event" = "issue"."latest_snapshot_event"
24 AND "direct_interest_snapshot"."member_id" = "supporter"."member_id"
25 WHERE "issue"."state" = 'admission'::"issue_state";
27 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';
29 COMMIT;