liquid_feedback_core

diff update/core-update.v3.2.2-v4.0.0.sql @ 551:deabd90adae8

find changesets by author, revision, files, or words in the commit message
Renamed "region" (for "unit" and "area") to "location"
author jbe
date Sat Sep 16 15:53:31 2017 +0200 (2017-09-16)
parents 81a35235b450
children a676d305502f
line diff
     1.1 --- a/update/core-update.v3.2.2-v4.0.0.sql	Tue Sep 12 16:54:26 2017 +0200
     1.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql	Sat Sep 16 15:53:31 2017 +0200
     1.3 @@ -441,12 +441,12 @@
     1.4  COMMENT ON COLUMN "policy"."initiative_quorum_den" IS 'Denominator of satisfied supporter quorum to be reached by an initiative to be "admitted" for voting';
     1.5  
     1.6  
     1.7 -ALTER TABLE "unit" ADD COLUMN "region" JSONB;
     1.8 -
     1.9 -CREATE INDEX "unit_region_idx" ON "unit" USING gist ((GeoJSON_to_ecluster("region")));
    1.10 +ALTER TABLE "unit" ADD COLUMN "location" JSONB;
    1.11 +
    1.12 +CREATE INDEX "unit_location_idx" ON "unit" USING gist ((GeoJSON_to_ecluster("location")));
    1.13  
    1.14  COMMENT ON COLUMN "unit"."member_count" IS 'Count of members as determined by column "voting_right" in table "privilege" (only active members counted)';
    1.15 -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.16 +COMMENT ON COLUMN "unit"."location"     IS 'Geographic location on earth as GeoJSON object indicating valid coordinates for initiatives of issues with this policy';
    1.17   
    1.18  
    1.19  DROP INDEX "area_unit_id_idx";
    1.20 @@ -459,12 +459,12 @@
    1.21  ALTER TABLE "area" ADD COLUMN "quorum_factor"   NUMERIC  NOT NULL DEFAULT 2 CHECK ("quorum_factor" >= 1);
    1.22  ALTER TABLE "area" ADD COLUMN "quorum_den"      INT4     CHECK ("quorum_den" > 0);
    1.23  ALTER TABLE "area" ADD COLUMN "issue_quorum"    INT4;
    1.24 -ALTER TABLE "area" ADD COLUMN "region"          JSONB;
    1.25 +ALTER TABLE "area" ADD COLUMN "location"        JSONB;
    1.26  
    1.27  ALTER TABLE "area" DROP COLUMN "direct_member_count";
    1.28  ALTER TABLE "area" DROP COLUMN "member_weight";
    1.29  
    1.30 -CREATE INDEX "area_region_idx" ON "area" USING gist ((GeoJSON_to_ecluster("region")));
    1.31 +CREATE INDEX "area_location_idx" ON "area" USING gist ((GeoJSON_to_ecluster("location")));
    1.32  
    1.33  COMMENT ON COLUMN "area"."quorum_standard"    IS 'Parameter for dynamic issue quorum: default quorum';
    1.34  COMMENT ON COLUMN "area"."quorum_issues"      IS 'Parameter for dynamic issue quorum: number of open issues for default quorum';
    1.35 @@ -474,7 +474,7 @@
    1.36  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.37  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.38  COMMENT ON COLUMN "area"."external_reference" IS 'Opaque data field to store an external reference';
    1.39 -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.40 +COMMENT ON COLUMN "area"."location"           IS 'Geographic location on earth as GeoJSON object indicating valid coordinates for initiatives of issues with this policy';
    1.41   
    1.42   
    1.43  CREATE TABLE "snapshot" (

Impressum / About Us