# HG changeset patch
# User jbe
# Date 1459706231 -7200
# Node ID d932363da4ee0eef7ec7dd8db397e23f5e00b75c
# Parent  917a65357efbc898305791304c7c4313f379301a
Bugfix in function "get_initiatives_for_notification"

diff -r 917a65357efb -r d932363da4ee core.sql
--- a/core.sql	Sun Apr 03 19:48:32 2016 +0200
+++ b/core.sql	Sun Apr 03 19:57:11 2016 +0200
@@ -3123,8 +3123,8 @@
           VALUES (
             "member_id_p",
             "result_row"."id",
-            "last_draft_id",
-            "last_suggestion_id" )
+            "last_draft_id_v",
+            "last_suggestion_id_v" )
           ON CONFLICT ("member_id", "initiative_id") DO UPDATE SET
             "last_draft_id" = CASE
               WHEN "last_draft_id" > "last_draft_id_v"
diff -r 917a65357efb -r d932363da4ee update/core-update.v3.1.0-v3.2.0.sql
--- a/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 03 19:48:32 2016 +0200
+++ b/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 03 19:57:11 2016 +0200
@@ -287,8 +287,8 @@
           VALUES (
             "member_id_p",
             "result_row"."id",
-            "last_draft_id",
-            "last_suggestion_id" )
+            "last_draft_id_v",
+            "last_suggestion_id_v" )
           ON CONFLICT ("member_id", "initiative_id") DO UPDATE SET
             "last_draft_id" = CASE
               WHEN "last_draft_id" > "last_draft_id_v"