# HG changeset patch # User jbe # Date 1498494342 -7200 # Node ID ec84707b459a351d92f52f7dbcab943ece94c190 # Parent eaa330e4c0fbbf935ac132ff162cde01b9395d61 Changed detection method for removed members in event trigger diff -r eaa330e4c0fb -r ec84707b459a core.sql --- a/core.sql Mon Jun 26 18:25:29 2017 +0200 +++ b/core.sql Mon Jun 26 18:25:42 2017 +0200 @@ -2099,8 +2099,7 @@ END IF; IF OLD."activated" NOTNULL AND - -- TODO: NEW."activated" ISNULL? OLD."login" NOTNULL? - NEW."last_login" ISNULL AND + (OLD."login" NOTNULL OR OLD."authority_login" NOTNULL) AND NEW."login" ISNULL AND NEW."authority_login" ISNULL AND NEW."locked" = TRUE diff -r eaa330e4c0fb -r ec84707b459a update/core-update.v3.2.2-v4.0.0.sql --- a/update/core-update.v3.2.2-v4.0.0.sql Mon Jun 26 18:25:29 2017 +0200 +++ b/update/core-update.v3.2.2-v4.0.0.sql Mon Jun 26 18:25:42 2017 +0200 @@ -1230,7 +1230,7 @@ END IF; IF OLD."activated" NOTNULL AND - NEW."last_login" ISNULL AND + (OLD."login" NOTNULL OR OLD."authority_login" NOTNULL) AND NEW."login" ISNULL AND NEW."authority_login" ISNULL AND NEW."locked" = TRUE