# HG changeset patch
# User jbe
# Date 1459706420 -7200
# Node ID b4b660562322fb974df7aeea278d06bba1f73473
# Parent  d932363da4ee0eef7ec7dd8db397e23f5e00b75c
Another bugfix in function "get_initiatives_for_notification"

diff -r d932363da4ee -r b4b660562322 core.sql
--- a/core.sql	Sun Apr 03 19:57:11 2016 +0200
+++ b/core.sql	Sun Apr 03 20:00:20 2016 +0200
@@ -3127,13 +3127,13 @@
             "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"
-              THEN "last_draft_id"
+              WHEN "initiative_notification_sent"."last_draft_id" > "last_draft_id_v"
+              THEN "initiative_notification_sent"."last_draft_id"
               ELSE "last_draft_id_v"
             END,
             "last_suggestion_id" = CASE
-              WHEN "last_suggestion_id" > "last_suggestion_id_v"
-              THEN "last_suggestion_id"
+              WHEN "initiative_notification_sent"."last_suggestion_id" > "last_suggestion_id_v"
+              THEN "initiative_notification_sent"."last_suggestion_id"
               ELSE "last_suggestion_id_v"
             END;
         RETURN NEXT "result_row";
diff -r d932363da4ee -r b4b660562322 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:57:11 2016 +0200
+++ b/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 03 20:00:20 2016 +0200
@@ -291,13 +291,13 @@
             "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"
-              THEN "last_draft_id"
+              WHEN "initiative_notification_sent"."last_draft_id" > "last_draft_id_v"
+              THEN "initiative_notification_sent"."last_draft_id"
               ELSE "last_draft_id_v"
             END,
             "last_suggestion_id" = CASE
-              WHEN "last_suggestion_id" > "last_suggestion_id_v"
-              THEN "last_suggestion_id"
+              WHEN "initiative_notification_sent"."last_suggestion_id" > "last_suggestion_id_v"
+              THEN "initiative_notification_sent"."last_suggestion_id"
               ELSE "last_suggestion_id_v"
             END;
         RETURN NEXT "result_row";