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

Impressum / About Us