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