# HG changeset patch
# User jbe
# Date 1381490249 -7200
# Node ID ad50723ef4ed3b051c7ef3ac8e77396d6fd8005c
# Parent  d93428e4edad9551c2e2881026dbec3b4b525d83
Update script to v2.2.6

diff -r d93428e4edad -r ad50723ef4ed core.sql
--- a/core.sql	Fri Oct 11 13:05:29 2013 +0200
+++ b/core.sql	Fri Oct 11 13:17:29 2013 +0200
@@ -7,7 +7,7 @@
 BEGIN;
 
 CREATE VIEW "liquid_feedback_version" AS
-  SELECT * FROM (VALUES ('2.2.5', 2, 2, 5))
+  SELECT * FROM (VALUES ('2.2.6', 2, 2, 6))
   AS "subquery"("string", "major", "minor", "revision");
 
 
diff -r d93428e4edad -r ad50723ef4ed update/core-update.v2.2.5-v2.2.6.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/update/core-update.v2.2.5-v2.2.6.sql	Fri Oct 11 13:17:29 2013 +0200
@@ -0,0 +1,29 @@
+BEGIN;
+
+CREATE OR REPLACE VIEW "liquid_feedback_version" AS
+  SELECT * FROM (VALUES ('2.2.6', 2, 2, 6))
+  AS "subquery"("string", "major", "minor", "revision");
+
+ALTER TABLE "issue" ADD COLUMN "order_in_admission_state" INT4;
+ALTER TABLE "issue" ADD COLUMN "order_in_open_states"     INT4;
+
+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"';
+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"';
+
+CREATE VIEW "issue_supporter_in_admission_state" AS
+  SELECT DISTINCT
+    "issue"."area_id",
+    "issue"."id" AS "issue_id",
+    "supporter"."member_id",
+    "direct_interest_snapshot"."weight"
+  FROM "issue"
+  JOIN "supporter" ON "supporter"."issue_id" = "issue"."id"
+  JOIN "direct_interest_snapshot"
+    ON  "direct_interest_snapshot"."issue_id" = "issue"."id"
+    AND "direct_interest_snapshot"."event" = "issue"."latest_snapshot_event"
+    AND "direct_interest_snapshot"."member_id" = "supporter"."member_id"
+  WHERE "issue"."state" = 'admission'::"issue_state";
+
+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';
+
+COMMIT;