liquid_feedback_core

changeset 498:10b90162e982

Corrected comparison operator in view "newsletter_to_send"
author jbe
date Sun Apr 03 20:57:44 2016 +0200 (2016-04-03)
parents 91e3d31c1de2
children bc4b590a8eec
files core.sql update/core-update.v3.1.0-v3.2.0.sql
line diff
     1.1 --- a/core.sql	Sun Apr 03 20:54:45 2016 +0200
     1.2 +++ b/core.sql	Sun Apr 03 20:57:44 2016 +0200
     1.3 @@ -2633,7 +2633,7 @@
     1.4    LEFT JOIN "subscription" ON
     1.5      "subscription"."member_id" = "member"."id" AND
     1.6      "subscription"."unit_id" = "newsletter"."unit_id"
     1.7 -  WHERE "newsletter"."published" >= now()
     1.8 +  WHERE "newsletter"."published" <= now()
     1.9    AND "newsletter"."sent" ISNULL
    1.10    AND "member"."locked" = FALSE
    1.11    AND (
     2.1 --- a/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 03 20:54:45 2016 +0200
     2.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 03 20:57:44 2016 +0200
     2.3 @@ -285,7 +285,7 @@
     2.4    LEFT JOIN "subscription" ON
     2.5      "subscription"."member_id" = "member"."id" AND
     2.6      "subscription"."unit_id" = "newsletter"."unit_id"
     2.7 -  WHERE "newsletter"."published" >= now()
     2.8 +  WHERE "newsletter"."published" <= now()
     2.9    AND "newsletter"."sent" ISNULL
    2.10    AND "member"."locked" = FALSE
    2.11    AND (

Impressum / About Us