# HG changeset patch # User jbe # Date 1506519156 -7200 # Node ID 74f98b2196ef97b9b5e473ee48b6c1c3b9bd7696 # Parent 17c9cca2938b55970e63582175615a6ed16a819a# Parent dc48b79b8a7edff0a3b49ff9e4a04633eac10746 merge diff -r 17c9cca2938b -r 74f98b2196ef core.sql --- a/core.sql Wed Sep 27 15:32:15 2017 +0200 +++ b/core.sql Wed Sep 27 15:32:36 2017 +0200 @@ -1636,7 +1636,7 @@ CONSTRAINT "constr_for_delegation" CHECK ( "event" != 'delegation' OR ( "member_id" NOTNULL AND - ("other_member_id" NOTNULL) OR ("boolean_value" = FALSE) AND + (("other_member_id" ISNULL) OR ("boolean_value" = TRUE)) AND "scope" NOTNULL AND "unit_id" NOTNULL AND ("area_id" NOTNULL) = ("scope" != 'unit'::"delegation_scope") AND diff -r 17c9cca2938b -r 74f98b2196ef update/core-update.v3.2.2-v4.0.0.sql --- a/update/core-update.v3.2.2-v4.0.0.sql Wed Sep 27 15:32:15 2017 +0200 +++ b/update/core-update.v3.2.2-v4.0.0.sql Wed Sep 27 15:32:36 2017 +0200 @@ -981,7 +981,7 @@ ALTER TABLE "event" ADD CONSTRAINT "constr_for_delegation" CHECK ( "event" != 'delegation' OR ( "member_id" NOTNULL AND - ("other_member_id" NOTNULL) OR ("boolean_value" = FALSE) AND + (("other_member_id" ISNULL) OR ("boolean_value" = TRUE)) AND "scope" NOTNULL AND "unit_id" NOTNULL AND ("area_id" NOTNULL) = ("scope" != 'unit'::"delegation_scope") AND