liquid_feedback_core

diff update/core-update.v3.2.2-v4.0.0.sql @ 564:dc48b79b8a7e

find changesets by author, revision, files, or words in the commit message
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
line diff
     1.1 --- a/update/core-update.v3.2.2-v4.0.0.sql	Mon Sep 25 14:44:35 2017 +0200
     1.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql	Mon Sep 25 22:08:06 2017 +0200
     1.3 @@ -981,7 +981,7 @@
     1.4  ALTER TABLE "event" ADD 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

Impressum / About Us