1.1 --- a/update/core-update.v4.0.0-v4.0.1.sql	Thu Feb 22 11:50:20 2018 +0100
     1.2 +++ b/update/core-update.v4.0.0-v4.0.1.sql	Fri Mar 02 16:52:32 2018 +0100
     1.3 @@ -1,7 +1,7 @@
     1.4  BEGIN;
     1.5  
     1.6  CREATE OR REPLACE VIEW "liquid_feedback_version" AS
     1.7 -  SELECT * FROM (VALUES ('4.0.1', 4, 0, 1))
     1.8 +  SELECT * FROM (VALUES ('4.0.1-dev', 4, 0, -1))
     1.9    AS "subquery"("string", "major", "minor", "revision");
    1.10  
    1.11  ALTER TABLE "member" ADD COLUMN "role" BOOLEAN NOT NULL DEFAULT FALSE;
    1.12 @@ -16,6 +16,9 @@
    1.13  
    1.14  COMMENT ON TABLE "agent" IS 'Privileges for role accounts';
    1.15  
    1.16 +ALTER TABLE "ignored_area" DROP CONSTRAINT "ignored_area_member_id_fkey";
    1.17 +ALTER TABLE "ignored_area" ADD FOREIGN KEY ("member_id") REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
    1.18 +
    1.19  CREATE OR REPLACE VIEW "expired_token" AS
    1.20    SELECT * FROM "token" WHERE now() > "expiry" AND NOT (
    1.21      "token_type" = 'authorization' AND "used" AND EXISTS (