liquid_feedback_core

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