# HG changeset patch
# User jbe
# Date 1459709170 -7200
# Node ID 044af1eec28b66eecaf08fa4c4ce7fd95de81069
# Parent  bb420abbc2faa96a2b3ba540f2eafbb611475616
New table "newsletter"

diff -r bb420abbc2fa -r 044af1eec28b core.sql
--- a/core.sql	Sun Apr 03 20:04:31 2016 +0200
+++ b/core.sql	Sun Apr 03 20:46:10 2016 +0200
@@ -1279,6 +1279,19 @@
 CREATE INDEX "initiative_notification_sent_initiative_idx" ON "initiative_notification_sent" ("initiative_id");
 
 
+CREATE TABLE "newsletter" (
+        "id"                    SERIAL4         PRIMARY KEY,
+        "published"             TIMESTAMPTZ     NOT NULL,
+        "unit_id"               INT4            REFERENCES "unit" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
+        "include_all_members"   BOOLEAN         NOT NULL,
+        "sent"                  TIMESTAMPTZ,
+        "subject"               TEXT            NOT NULL,
+        "content"               TEXT            NOT NULL );
+CREATE INDEX "newsletter_unit_id_idx" ON "newsletter" ("unit_id", "published");
+CREATE INDEX "newsletter_all_units_published_idx" ON "newsletter" ("published") WHERE "unit_id" ISNULL;
+CREATE INDEX "newsletter_published_idx" ON "newsletter" ("published");
+
+
 
 ----------------------------------------------
 -- Writing of history entries and event log --
diff -r bb420abbc2fa -r 044af1eec28b update/core-update.v3.1.0-v3.2.0.sql
--- a/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 03 20:04:31 2016 +0200
+++ b/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 03 20:46:10 2016 +0200
@@ -36,6 +36,18 @@
         "last_suggestion_id"    INT8 );
 CREATE INDEX "initiative_notification_sent_initiative_idx" ON "initiative_notification_sent" ("initiative_id");
 
+CREATE TABLE "newsletter" (
+        "id"                    SERIAL4         PRIMARY KEY,
+        "published"             TIMESTAMPTZ     NOT NULL,
+        "unit_id"               INT4            REFERENCES "unit" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
+        "include_all_members"   BOOLEAN         NOT NULL,
+        "sent"                  TIMESTAMPTZ,
+        "subject"               TEXT            NOT NULL,
+        "content"               TEXT            NOT NULL );
+CREATE INDEX "newsletter_unit_id_idx" ON "newsletter" ("unit_id", "published");
+CREATE INDEX "newsletter_all_units_published_idx" ON "newsletter" ("published") WHERE "unit_id" ISNULL;
+CREATE INDEX "newsletter_published_idx" ON "newsletter" ("published");
+
 CREATE VIEW "updated_initiative" AS
   SELECT
     "supporter"."member_id" AS "seen_by_member_id",