liquid_feedback_core
changeset 493:d932363da4ee
Bugfix in function "get_initiatives_for_notification"
author | jbe |
---|---|
date | Sun Apr 03 19:57:11 2016 +0200 (2016-04-03) |
parents | 917a65357efb |
children | b4b660562322 |
files | core.sql update/core-update.v3.1.0-v3.2.0.sql |
line diff
1.1 --- a/core.sql Sun Apr 03 19:48:32 2016 +0200 1.2 +++ b/core.sql Sun Apr 03 19:57:11 2016 +0200 1.3 @@ -3123,8 +3123,8 @@ 1.4 VALUES ( 1.5 "member_id_p", 1.6 "result_row"."id", 1.7 - "last_draft_id", 1.8 - "last_suggestion_id" ) 1.9 + "last_draft_id_v", 1.10 + "last_suggestion_id_v" ) 1.11 ON CONFLICT ("member_id", "initiative_id") DO UPDATE SET 1.12 "last_draft_id" = CASE 1.13 WHEN "last_draft_id" > "last_draft_id_v"
2.1 --- a/update/core-update.v3.1.0-v3.2.0.sql Sun Apr 03 19:48:32 2016 +0200 2.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql Sun Apr 03 19:57:11 2016 +0200 2.3 @@ -287,8 +287,8 @@ 2.4 VALUES ( 2.5 "member_id_p", 2.6 "result_row"."id", 2.7 - "last_draft_id", 2.8 - "last_suggestion_id" ) 2.9 + "last_draft_id_v", 2.10 + "last_suggestion_id_v" ) 2.11 ON CONFLICT ("member_id", "initiative_id") DO UPDATE SET 2.12 "last_draft_id" = CASE 2.13 WHEN "last_draft_id" > "last_draft_id_v"