liquid_feedback_core
diff core.sql @ 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 |
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