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 )