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  ------------------------------------------------------