# HG changeset patch
# User jbe
# Date 1381702984 -7200
# Node ID f7b4457cf1a6239818a7f468951fb592a0f29881
# Parent  92cdb3af0b5445fe08f691a3cdbffc545f231943
core.sql: Removed "order_in_open_states"

diff -r 92cdb3af0b54 -r f7b4457cf1a6 core.sql
--- a/core.sql	Mon Oct 14 00:20:52 2013 +0200
+++ b/core.sql	Mon Oct 14 00:23:04 2013 +0200
@@ -608,14 +608,12 @@
 
 CREATE TABLE "issue_order" (
         "id"                    INT8            PRIMARY KEY, --REFERENCES "issue" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
-        "order_in_admission_state" INT4,
-        "order_in_open_states"  INT4 );
+        "order_in_admission_state" INT4 );
 
 COMMENT ON TABLE "issue_order" IS 'Ordering information for issues that are not stored in the "issue" table to avoid locking of multiple issues at once';
 
 COMMENT ON COLUMN "issue_order"."id"                       IS 'References "issue" ("id") but has no referential integrity trigger associated, due to performance/locking issues';
-COMMENT ON COLUMN "issue_order"."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"."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"';
+COMMENT ON COLUMN "issue_order"."order_in_admission_state" IS 'To be used for sorting issues within an area, when showing issues in admission state; NULL values sort last; updated by "lf_update_issue_order"';
 
 
 CREATE TABLE "issue_setting" (
@@ -2090,24 +2088,6 @@
 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';
 
 
-CREATE VIEW "open_issues_ordered_with_minimum_position" AS
-  SELECT
-    "area_id",
-    "id" AS "issue_id",
-    "order_in_admission_state" * 2 - 1 AS "minimum_position"
-  FROM "issue" NATURAL LEFT JOIN "issue_order"
-  WHERE "closed" ISNULL
-  ORDER BY
-    coalesce(
-      "fully_frozen" + "voting_time",
-      "half_frozen" + "verification_time",
-      "accepted" + "discussion_time",
-      "created" + "admission_time"
-    ) - now();
-
-COMMENT ON VIEW "open_issues_ordered_with_minimum_position" IS 'Helper view for "lf_update_issue_order" to allow a (mixed) ordering of issues within an area';
-
-
 CREATE VIEW "initiative_suggestion_order_calculation" AS
   SELECT
     "initiative"."id" AS "initiative_id",
diff -r 92cdb3af0b54 -r f7b4457cf1a6 update/core-update.v2.2.5-v2.2.6.sql
--- a/update/core-update.v2.2.5-v2.2.6.sql	Mon Oct 14 00:20:52 2013 +0200
+++ b/update/core-update.v2.2.5-v2.2.6.sql	Mon Oct 14 00:23:04 2013 +0200
@@ -6,14 +6,12 @@
 
 CREATE TABLE "issue_order" (
         "id"                    INT8            PRIMARY KEY, --REFERENCES "issue" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
-        "order_in_admission_state" INT4,
-        "order_in_open_states"  INT4 );
+        "order_in_admission_state" INT4 );
 
 COMMENT ON TABLE "issue_order" IS 'Ordering information for issues that are not stored in the "issue" table to avoid locking of multiple issues at once';
 
 COMMENT ON COLUMN "issue_order"."id"                       IS 'References "issue" ("id") but has no referential integrity trigger associated, due to performance/locking issues';
-COMMENT ON COLUMN "issue_order"."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"."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"';
+COMMENT ON COLUMN "issue_order"."order_in_admission_state" IS 'To be used for sorting issues within an area, when showing issues in admission state; NULL values sort last; updated by "lf_update_issue_order"';
 
 CREATE VIEW "issue_supporter_in_admission_state" AS
   SELECT DISTINCT
@@ -31,21 +29,4 @@
 
 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';
 
-CREATE VIEW "open_issues_ordered_with_minimum_position" AS
-  SELECT
-    "area_id",
-    "id" AS "issue_id",
-    "order_in_admission_state" * 2 - 1 AS "minimum_position"
-  FROM "issue" NATURAL LEFT JOIN "issue_order"
-  WHERE "closed" ISNULL
-  ORDER BY
-    coalesce(
-      "fully_frozen" + "voting_time",
-      "half_frozen" + "verification_time",
-      "accepted" + "discussion_time",
-      "created" + "admission_time"
-    ) - now();
-
-COMMENT ON VIEW "open_issues_ordered_with_minimum_position" IS 'Helper view for "lf_update_issue_order" to allow a (mixed) ordering of issues within an area';
-
 COMMIT;