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"

Impressum / About Us