liquid_feedback_core

changeset 523:30b67ca0c242

Set notification settings to zero/NULL/DEFAULT for deleted members
author jbe
date Wed May 04 22:46:39 2016 +0200 (2016-05-04)
parents 2f1c06608def
children bc6d9dc60ca4
files update/core-update.v3.2.1-v3.2.2.sql
line diff
     1.1 --- a/update/core-update.v3.2.1-v3.2.2.sql	Wed May 04 21:49:25 2016 +0200
     1.2 +++ b/update/core-update.v3.2.1-v3.2.2.sql	Wed May 04 22:46:39 2016 +0200
     1.3 @@ -4,6 +4,18 @@
     1.4    SELECT * FROM (VALUES ('3.2.2', 3, 2, 2))
     1.5    AS "subquery"("string", "major", "minor", "revision");
     1.6  
     1.7 +UPDATE "member" SET
     1.8 +  "disable_notifications"    = TRUE,
     1.9 +  "notification_counter"     = DEFAULT,
    1.10 +  "notification_sample_size" = 0,
    1.11 +  "notification_dow"         = NULL,
    1.12 +  "notification_hour"        = NULL
    1.13 +  WHERE "last_login" ISNULL
    1.14 +  AND "login" ISNULL
    1.15 +  AND "authority_login" ISNULL
    1.16 +  AND "locked" = TRUE
    1.17 +  AND "active" = FALSE;
    1.18 +
    1.19  CREATE OR REPLACE FUNCTION "featured_initiative"
    1.20    ( "recipient_id_p" "member"."id"%TYPE,
    1.21      "area_id_p"      "area"."id"%TYPE )

Impressum / About Us