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