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