liquid_feedback_core
changeset 540:ec84707b459a
Changed detection method for removed members in event trigger
author | jbe |
---|---|
date | Mon Jun 26 18:25:42 2017 +0200 (2017-06-26) |
parents | eaa330e4c0fb |
children | 5d96f5fc4af0 |
files | core.sql update/core-update.v3.2.2-v4.0.0.sql |
line diff
1.1 --- a/core.sql Mon Jun 26 18:25:29 2017 +0200 1.2 +++ b/core.sql Mon Jun 26 18:25:42 2017 +0200 1.3 @@ -2099,8 +2099,7 @@ 1.4 END IF; 1.5 IF 1.6 OLD."activated" NOTNULL AND 1.7 - -- TODO: NEW."activated" ISNULL? OLD."login" NOTNULL? 1.8 - NEW."last_login" ISNULL AND 1.9 + (OLD."login" NOTNULL OR OLD."authority_login" NOTNULL) AND 1.10 NEW."login" ISNULL AND 1.11 NEW."authority_login" ISNULL AND 1.12 NEW."locked" = TRUE
2.1 --- a/update/core-update.v3.2.2-v4.0.0.sql Mon Jun 26 18:25:29 2017 +0200 2.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql Mon Jun 26 18:25:42 2017 +0200 2.3 @@ -1230,7 +1230,7 @@ 2.4 END IF; 2.5 IF 2.6 OLD."activated" NOTNULL AND 2.7 - NEW."last_login" ISNULL AND 2.8 + (OLD."login" NOTNULL OR OLD."authority_login" NOTNULL) AND 2.9 NEW."login" ISNULL AND 2.10 NEW."authority_login" ISNULL AND 2.11 NEW."locked" = TRUE