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 (