1.1 --- a/core.sql	Tue Sep 12 16:54:26 2017 +0200
     1.2 +++ b/core.sql	Sat Sep 16 15:53:31 2017 +0200
     1.3 @@ -575,12 +575,12 @@
     1.4          "description"           TEXT            NOT NULL DEFAULT '',
     1.5          "external_reference"    TEXT,
     1.6          "member_count"          INT4,
     1.7 -        "region"                JSONB,
     1.8 +        "location"              JSONB,
     1.9          "text_search_data"      TSVECTOR );
    1.10  CREATE INDEX "unit_root_idx" ON "unit" ("id") WHERE "parent_id" ISNULL;
    1.11  CREATE INDEX "unit_parent_id_idx" ON "unit" ("parent_id");
    1.12  CREATE INDEX "unit_active_idx" ON "unit" ("active");
    1.13 -CREATE INDEX "unit_region_idx" ON "unit" USING gist ((GeoJSON_to_ecluster("region")));
    1.14 +CREATE INDEX "unit_location_idx" ON "unit" USING gist ((GeoJSON_to_ecluster("location")));
    1.15  CREATE INDEX "unit_text_search_data_idx" ON "unit" USING gin ("text_search_data");
    1.16  CREATE TRIGGER "update_text_search_data"
    1.17    BEFORE INSERT OR UPDATE ON "unit"
    1.18 @@ -594,7 +594,7 @@
    1.19  COMMENT ON COLUMN "unit"."active"             IS 'TRUE means new issues can be created in areas of this unit';
    1.20  COMMENT ON COLUMN "unit"."external_reference" IS 'Opaque data field to store an external reference';
    1.21  COMMENT ON COLUMN "unit"."member_count"       IS 'Count of members as determined by column "voting_right" in table "privilege" (only active members counted)';
    1.22 -COMMENT ON COLUMN "unit"."region"             IS 'Scattered (or hollow) polygon represented as an array of polygons indicating valid coordinates for initiatives of issues with this policy';
    1.23 +COMMENT ON COLUMN "unit"."location"           IS 'Geographic location on earth as GeoJSON object indicating valid coordinates for initiatives of issues with this policy';
    1.24  
    1.25  
    1.26  CREATE TABLE "subscription" (
    1.27 @@ -621,10 +621,10 @@
    1.28          "quorum_den"            INT4            CHECK ("quorum_den" > 0),
    1.29          "issue_quorum"          INT4,
    1.30          "external_reference"    TEXT,
    1.31 -        "region"                JSONB,
    1.32 +        "location"              JSONB,
    1.33          "text_search_data"      TSVECTOR );
    1.34  CREATE INDEX "area_active_idx" ON "area" ("active");
    1.35 -CREATE INDEX "area_region_idx" ON "area" USING gist ((GeoJSON_to_ecluster("region")));
    1.36 +CREATE INDEX "area_location_idx" ON "area" USING gist ((GeoJSON_to_ecluster("location")));
    1.37  CREATE INDEX "area_text_search_data_idx" ON "area" USING gin ("text_search_data");
    1.38  CREATE TRIGGER "update_text_search_data"
    1.39    BEFORE INSERT OR UPDATE ON "area"
    1.40 @@ -643,7 +643,7 @@
    1.41  COMMENT ON COLUMN "area"."quorum_den"         IS 'Parameter for dynamic issue quorum: when set, dynamic quorum is multiplied with "issue"."population" and divided by "quorum_den" (and then rounded up)';
    1.42  COMMENT ON COLUMN "area"."issue_quorum"       IS 'Additional dynamic issue quorum based on the number of open accepted issues; automatically calculated by function "issue_admission"';
    1.43  COMMENT ON COLUMN "area"."external_reference" IS 'Opaque data field to store an external reference';
    1.44 -COMMENT ON COLUMN "area"."region"             IS 'Scattered (or hollow) polygon represented as an array of polygons indicating valid coordinates for initiatives of issues with this policy';
    1.45 +COMMENT ON COLUMN "area"."location"           IS 'Geographic location on earth as GeoJSON object indicating valid coordinates for initiatives of issues with this policy';
    1.46  
    1.47  
    1.48  CREATE TABLE "ignored_area" (