# HG changeset patch
# User jbe
# Date 1520005952 -3600
# Node ID f6b84db4dd0c5668e0cd87ad08ed061743ce5c3e
# Parent  02a6149822e08004a9be7fc9526c55be7745f719
Bugfix in index "ignored_area_member_id_fkey"

diff -r 02a6149822e0 -r f6b84db4dd0c core.sql
--- a/core.sql	Thu Feb 22 11:50:20 2018 +0100
+++ b/core.sql	Fri Mar 02 16:52:32 2018 +0100
@@ -6,7 +6,7 @@
 CREATE EXTENSION IF NOT EXISTS latlon;  -- load pgLatLon extenstion
 
 CREATE VIEW "liquid_feedback_version" AS
-  SELECT * FROM (VALUES ('4.0-dev', 4, 0, -1))
+  SELECT * FROM (VALUES ('4.1-dev', 4, 1, -1))
   AS "subquery"("string", "major", "minor", "revision");
 
 
@@ -702,7 +702,7 @@
 
 CREATE TABLE "ignored_area" (
         PRIMARY KEY ("member_id", "area_id"),
-        "member_id"             INT4            REFERENCES "unit" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
+        "member_id"             INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
         "area_id"               INT4            REFERENCES "area" ("id") ON DELETE CASCADE ON UPDATE CASCADE );
 CREATE INDEX "ignored_area_area_id_idx" ON "ignored_area" ("area_id");
 
diff -r 02a6149822e0 -r f6b84db4dd0c update/core-update.v4.0.0-v4.0.1.sql
--- a/update/core-update.v4.0.0-v4.0.1.sql	Thu Feb 22 11:50:20 2018 +0100
+++ b/update/core-update.v4.0.0-v4.0.1.sql	Fri Mar 02 16:52:32 2018 +0100
@@ -1,7 +1,7 @@
 BEGIN;
 
 CREATE OR REPLACE VIEW "liquid_feedback_version" AS
-  SELECT * FROM (VALUES ('4.0.1', 4, 0, 1))
+  SELECT * FROM (VALUES ('4.0.1-dev', 4, 0, -1))
   AS "subquery"("string", "major", "minor", "revision");
 
 ALTER TABLE "member" ADD COLUMN "role" BOOLEAN NOT NULL DEFAULT FALSE;
@@ -16,6 +16,9 @@
 
 COMMENT ON TABLE "agent" IS 'Privileges for role accounts';
 
+ALTER TABLE "ignored_area" DROP CONSTRAINT "ignored_area_member_id_fkey";
+ALTER TABLE "ignored_area" ADD FOREIGN KEY ("member_id") REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
+
 CREATE OR REPLACE VIEW "expired_token" AS
   SELECT * FROM "token" WHERE now() > "expiry" AND NOT (
     "token_type" = 'authorization' AND "used" AND EXISTS (