# HG changeset patch
# User jbe
# Date 1460898854 -7200
# Node ID 705097d1b1f3ee07623fa638b1043c5cd94a0485
# Parent  bca63fc70e73521059f0d95b14caded7d0de788c
Include column "published" in view "newsletter_to_send" (to make ordering easier)

diff -r bca63fc70e73 -r 705097d1b1f3 core.sql
--- a/core.sql	Sat Apr 16 20:00:36 2016 +0200
+++ b/core.sql	Sun Apr 17 15:14:14 2016 +0200
@@ -2722,7 +2722,8 @@
 CREATE VIEW "newsletter_to_send" AS
   SELECT
     "member"."id" AS "recipient_id",
-    "newsletter"."id" AS "newsletter_id"
+    "newsletter"."id" AS "newsletter_id",
+    "newsletter"."published"
   FROM "newsletter" CROSS JOIN "member"
   LEFT JOIN "privilege" ON
     "privilege"."member_id" = "member"."id" AND
@@ -2744,6 +2745,8 @@
 
 COMMENT ON VIEW "newsletter_to_send" IS 'List of "newsletter_id"s for each member that are due to be sent out';
 
+COMMENT ON COLUMN "newsletter"."published" IS 'Timestamp when the newsletter was supposed to be sent out (can be used for ordering)';
+
 
 
 ------------------------------------------------------
diff -r bca63fc70e73 -r 705097d1b1f3 update/core-update.v3.1.0-v3.2.0.sql
--- a/update/core-update.v3.1.0-v3.2.0.sql	Sat Apr 16 20:00:36 2016 +0200
+++ b/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 17 15:14:14 2016 +0200
@@ -556,7 +556,8 @@
 CREATE VIEW "newsletter_to_send" AS
   SELECT
     "member"."id" AS "recipient_id",
-    "newsletter"."id" AS "newsletter_id"
+    "newsletter"."id" AS "newsletter_id",
+    "newsletter"."published"
   FROM "newsletter" CROSS JOIN "member"
   LEFT JOIN "privilege" ON
     "privilege"."member_id" = "member"."id" AND
@@ -577,6 +578,7 @@
     "subscription"."member_id" NOTNULL );
 
 COMMENT ON VIEW "newsletter_to_send" IS 'List of "newsletter_id"s for each member that are due to be sent out';
+COMMENT ON COLUMN "newsletter"."published" IS 'Timestamp when the newsletter was supposed to be sent out (can be used for ordering)';
 
 CREATE OR REPLACE FUNCTION "require_transaction_isolation"()
   RETURNS VOID