1.1 --- a/core.sql	Mon Oct 14 00:58:38 2013 +0200
     1.2 +++ b/core.sql	Mon Oct 14 19:36:33 2013 +0200
     1.3 @@ -606,16 +606,16 @@
     1.4  COMMENT ON COLUMN "issue"."status_quo_schulze_rank" IS 'Schulze rank of status quo, as calculated by "calculate_ranks" function';
     1.5  
     1.6  
     1.7 -CREATE TABLE "issue_order" (
     1.8 +CREATE TABLE "issue_order_in_admission_state" (
     1.9          "id"                    INT8            PRIMARY KEY, --REFERENCES "issue" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
    1.10 -        "order_in_admission_state" INT4,
    1.11 -        "max_supporter_count"   INT4 );
    1.12 -
    1.13 -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';
    1.14 -
    1.15 -COMMENT ON COLUMN "issue_order"."id"                       IS 'References "issue" ("id") but has no referential integrity trigger associated, due to performance/locking issues';
    1.16 -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"';
    1.17 -COMMENT ON COLUMN "issue_order"."max_supporter_count"      IS 'Secondary sorting key when displaying issues in admission state from different areas';
    1.18 +        "order_in_area"         INT4,
    1.19 +        "order_in_unit"         INT4 );
    1.20 +
    1.21 +COMMENT ON TABLE "issue_order_in_admission_state" IS 'Ordering information for issues that are not stored in the "issue" table to avoid locking of multiple issues at once; Filled/updated by "lf_update_issue_order"';
    1.22 +
    1.23 +COMMENT ON COLUMN "issue_order_in_admission_state"."id"            IS 'References "issue" ("id") but has no referential integrity trigger associated, due to performance/locking issues';
    1.24 +COMMENT ON COLUMN "issue_order_in_admission_state"."order_in_area" IS 'Order of issues in admission state within a single area; NULL values sort last';
    1.25 +COMMENT ON COLUMN "issue_order_in_admission_state"."order_in_unit" IS 'Order of issues in admission state within all areas of a unit; NULL values sort last';
    1.26  
    1.27  
    1.28  CREATE TABLE "issue_setting" (
    1.29 @@ -2075,11 +2075,13 @@
    1.30  
    1.31  CREATE VIEW "issue_supporter_in_admission_state" AS
    1.32    SELECT DISTINCT
    1.33 +    "area"."unit_id",
    1.34      "issue"."area_id",
    1.35      "issue"."id" AS "issue_id",
    1.36      "supporter"."member_id",
    1.37      "direct_interest_snapshot"."weight"
    1.38    FROM "issue"
    1.39 +  JOIN "area" ON "area"."id" = "issue"."area_id"
    1.40    JOIN "supporter" ON "supporter"."issue_id" = "issue"."id"
    1.41    JOIN "direct_interest_snapshot"
    1.42      ON  "direct_interest_snapshot"."issue_id" = "issue"."id"