liquid_feedback_core
changeset 506:f5aba1fbb845
Fixed syntax error in "get_initiatives_for_notification"
author | jbe |
---|---|
date | Tue Apr 05 20:33:39 2016 +0200 (2016-04-05) |
parents | be7942edfd1e |
children | 7bc72214ecc9 |
files | core.sql update/core-update.v3.1.0-v3.2.0.sql |
line diff
1.1 --- a/core.sql Tue Apr 05 20:12:24 2016 +0200 1.2 +++ b/core.sql Tue Apr 05 20:33:39 2016 +0200 1.3 @@ -3211,7 +3211,7 @@ 1.4 AND "issue"."id" = "initiative"."issue_id" 1.5 AND ( "issue"."closed" NOTNULL OR "issue"."fully_frozen" NOTNULL ); 1.6 UPDATE "member" SET 1.7 - "notification_counter" = "notification_counter" + 1 AND 1.8 + "notification_counter" = "notification_counter" + 1, 1.9 "notification_sent" = now() 1.10 WHERE "id" = "recipient_id_p"; 1.11 RETURN;
2.1 --- a/update/core-update.v3.1.0-v3.2.0.sql Tue Apr 05 20:12:24 2016 +0200 2.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql Tue Apr 05 20:33:39 2016 +0200 2.3 @@ -439,7 +439,7 @@ 2.4 AND "issue"."id" = "initiative"."issue_id" 2.5 AND ( "issue"."closed" NOTNULL OR "issue"."fully_frozen" NOTNULL ); 2.6 UPDATE "member" SET 2.7 - "notification_counter" = "notification_counter" + 1 AND 2.8 + "notification_counter" = "notification_counter" + 1, 2.9 "notification_sent" = now() 2.10 WHERE "id" = "recipient_id_p"; 2.11 RETURN;