liquid_feedback_core

changeset 514:705097d1b1f3

Include column "published" in view "newsletter_to_send" (to make ordering easier)
author jbe
date Sun Apr 17 15:14:14 2016 +0200 (2016-04-17)
parents bca63fc70e73
children ab05fb3bf974
files core.sql update/core-update.v3.1.0-v3.2.0.sql
line diff
     1.1 --- a/core.sql	Sat Apr 16 20:00:36 2016 +0200
     1.2 +++ b/core.sql	Sun Apr 17 15:14:14 2016 +0200
     1.3 @@ -2722,7 +2722,8 @@
     1.4  CREATE VIEW "newsletter_to_send" AS
     1.5    SELECT
     1.6      "member"."id" AS "recipient_id",
     1.7 -    "newsletter"."id" AS "newsletter_id"
     1.8 +    "newsletter"."id" AS "newsletter_id",
     1.9 +    "newsletter"."published"
    1.10    FROM "newsletter" CROSS JOIN "member"
    1.11    LEFT JOIN "privilege" ON
    1.12      "privilege"."member_id" = "member"."id" AND
    1.13 @@ -2744,6 +2745,8 @@
    1.14  
    1.15  COMMENT ON VIEW "newsletter_to_send" IS 'List of "newsletter_id"s for each member that are due to be sent out';
    1.16  
    1.17 +COMMENT ON COLUMN "newsletter"."published" IS 'Timestamp when the newsletter was supposed to be sent out (can be used for ordering)';
    1.18 +
    1.19  
    1.20  
    1.21  ------------------------------------------------------
     2.1 --- a/update/core-update.v3.1.0-v3.2.0.sql	Sat Apr 16 20:00:36 2016 +0200
     2.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 17 15:14:14 2016 +0200
     2.3 @@ -556,7 +556,8 @@
     2.4  CREATE VIEW "newsletter_to_send" AS
     2.5    SELECT
     2.6      "member"."id" AS "recipient_id",
     2.7 -    "newsletter"."id" AS "newsletter_id"
     2.8 +    "newsletter"."id" AS "newsletter_id",
     2.9 +    "newsletter"."published"
    2.10    FROM "newsletter" CROSS JOIN "member"
    2.11    LEFT JOIN "privilege" ON
    2.12      "privilege"."member_id" = "member"."id" AND
    2.13 @@ -577,6 +578,7 @@
    2.14      "subscription"."member_id" NOTNULL );
    2.15  
    2.16  COMMENT ON VIEW "newsletter_to_send" IS 'List of "newsletter_id"s for each member that are due to be sent out';
    2.17 +COMMENT ON COLUMN "newsletter"."published" IS 'Timestamp when the newsletter was supposed to be sent out (can be used for ordering)';
    2.18  
    2.19  CREATE OR REPLACE FUNCTION "require_transaction_isolation"()
    2.20    RETURNS VOID

Impressum / About Us