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  

Impressum / About Us