liquid_feedback_core

changeset 564:dc48b79b8a7e

Bug fix in constr_for_delegation on event table
author bsw
date Mon Sep 25 22:08:06 2017 +0200 (2017-09-25)
parents fc09088587b2
children 74f98b2196ef
files core.sql update/core-update.v3.2.2-v4.0.0.sql
line diff
     1.1 --- a/core.sql	Mon Sep 25 14:44:35 2017 +0200
     1.2 +++ b/core.sql	Mon Sep 25 22:08:06 2017 +0200
     1.3 @@ -1636,7 +1636,7 @@
     1.4          CONSTRAINT "constr_for_delegation" CHECK (
     1.5            "event" != 'delegation' OR (
     1.6              "member_id"       NOTNULL AND
     1.7 -            ("other_member_id" NOTNULL) OR ("boolean_value" = FALSE) AND
     1.8 +            (("other_member_id" ISNULL) OR ("boolean_value" = TRUE)) AND
     1.9              "scope"           NOTNULL AND
    1.10              "unit_id"         NOTNULL AND
    1.11              ("area_id"  NOTNULL) = ("scope" != 'unit'::"delegation_scope") AND
     2.1 --- a/update/core-update.v3.2.2-v4.0.0.sql	Mon Sep 25 14:44:35 2017 +0200
     2.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql	Mon Sep 25 22:08:06 2017 +0200
     2.3 @@ -981,7 +981,7 @@
     2.4  ALTER TABLE "event" ADD CONSTRAINT "constr_for_delegation" CHECK (
     2.5            "event" != 'delegation' OR (
     2.6              "member_id"       NOTNULL AND
     2.7 -            ("other_member_id" NOTNULL) OR ("boolean_value" = FALSE) AND
     2.8 +            (("other_member_id" ISNULL) OR ("boolean_value" = TRUE)) AND
     2.9              "scope"           NOTNULL AND
    2.10              "unit_id"         NOTNULL AND
    2.11              ("area_id"  NOTNULL) = ("scope" != 'unit'::"delegation_scope") AND

Impressum / About Us