liquid_feedback_core

changeset 579:f6b84db4dd0c

Bugfix in index "ignored_area_member_id_fkey"
author jbe
date Fri Mar 02 16:52:32 2018 +0100 (2018-03-02)
parents 02a6149822e0
children 78f6833f5f19
files core.sql update/core-update.v4.0.0-v4.0.1.sql
line diff
     1.1 --- a/core.sql	Thu Feb 22 11:50:20 2018 +0100
     1.2 +++ b/core.sql	Fri Mar 02 16:52:32 2018 +0100
     1.3 @@ -6,7 +6,7 @@
     1.4  CREATE EXTENSION IF NOT EXISTS latlon;  -- load pgLatLon extenstion
     1.5  
     1.6  CREATE VIEW "liquid_feedback_version" AS
     1.7 -  SELECT * FROM (VALUES ('4.0-dev', 4, 0, -1))
     1.8 +  SELECT * FROM (VALUES ('4.1-dev', 4, 1, -1))
     1.9    AS "subquery"("string", "major", "minor", "revision");
    1.10  
    1.11  
    1.12 @@ -702,7 +702,7 @@
    1.13  
    1.14  CREATE TABLE "ignored_area" (
    1.15          PRIMARY KEY ("member_id", "area_id"),
    1.16 -        "member_id"             INT4            REFERENCES "unit" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
    1.17 +        "member_id"             INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
    1.18          "area_id"               INT4            REFERENCES "area" ("id") ON DELETE CASCADE ON UPDATE CASCADE );
    1.19  CREATE INDEX "ignored_area_area_id_idx" ON "ignored_area" ("area_id");
    1.20  
     2.1 --- a/update/core-update.v4.0.0-v4.0.1.sql	Thu Feb 22 11:50:20 2018 +0100
     2.2 +++ b/update/core-update.v4.0.0-v4.0.1.sql	Fri Mar 02 16:52:32 2018 +0100
     2.3 @@ -1,7 +1,7 @@
     2.4  BEGIN;
     2.5  
     2.6  CREATE OR REPLACE VIEW "liquid_feedback_version" AS
     2.7 -  SELECT * FROM (VALUES ('4.0.1', 4, 0, 1))
     2.8 +  SELECT * FROM (VALUES ('4.0.1-dev', 4, 0, -1))
     2.9    AS "subquery"("string", "major", "minor", "revision");
    2.10  
    2.11  ALTER TABLE "member" ADD COLUMN "role" BOOLEAN NOT NULL DEFAULT FALSE;
    2.12 @@ -16,6 +16,9 @@
    2.13  
    2.14  COMMENT ON TABLE "agent" IS 'Privileges for role accounts';
    2.15  
    2.16 +ALTER TABLE "ignored_area" DROP CONSTRAINT "ignored_area_member_id_fkey";
    2.17 +ALTER TABLE "ignored_area" ADD FOREIGN KEY ("member_id") REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
    2.18 +
    2.19  CREATE OR REPLACE VIEW "expired_token" AS
    2.20    SELECT * FROM "token" WHERE now() > "expiry" AND NOT (
    2.21      "token_type" = 'authorization' AND "used" AND EXISTS (

Impressum / About Us