# HG changeset patch
# User jbe
# Date 1542497939 -3600
# Node ID f5095a9696ebd0390b1509265f7978a437b64854
# Parent  225a0c0476919d13d5ab93eee6222680f09fd975
Added "unsubscribe_secret" column

diff -r 225a0c047691 -r f5095a9696eb .hgtags
--- a/.hgtags	Tue Sep 04 14:30:41 2018 +0200
+++ b/.hgtags	Sun Nov 18 00:38:59 2018 +0100
@@ -77,4 +77,3 @@
 ab05fb3bf974a8c206124c196fb7db4c1a3cc6a7 v3.2.0
 e4f619e87664965b1bac84c006e8f043f139392f v3.2.1
 bc6d9dc60ca4530e25ad401618fd84c109fbf982 v3.2.2
-ed3c3d8bd16b4d1689b01e022d58db39646aa86e v4.0.0
diff -r 225a0c047691 -r f5095a9696eb core.sql
--- a/core.sql	Tue Sep 04 14:30:41 2018 +0200
+++ b/core.sql	Sun Nov 18 00:38:59 2018 +0100
@@ -115,6 +115,7 @@
         "notify_email_secret"          TEXT     UNIQUE,
         "notify_email_secret_expiry"   TIMESTAMPTZ,
         "notify_email_lock_expiry"     TIMESTAMPTZ,
+        "unsubscribe_secret"    TEXT,
         "disable_notifications"    BOOLEAN      NOT NULL DEFAULT FALSE,
         "notification_counter"     INT4         NOT NULL DEFAULT 1,
         "notification_sample_size" INT4         NOT NULL DEFAULT 3,
@@ -179,6 +180,7 @@
 COMMENT ON COLUMN "member"."notify_email_secret"        IS 'Secret sent to the address in "notify_email_unconformed"';
 COMMENT ON COLUMN "member"."notify_email_secret_expiry" IS 'Expiry date/time for "notify_email_secret"';
 COMMENT ON COLUMN "member"."notify_email_lock_expiry"   IS 'Date/time until no further email confirmation mails may be sent (abuse protection)';
+COMMENT ON COLUMN "member"."unsubscribe_secret"         IS 'Secret string to be used for a List-Unsubscribe mail header';
 COMMENT ON COLUMN "member"."disable_notifications"    IS 'TRUE if member does not want to receive notifications';
 COMMENT ON COLUMN "member"."notification_counter"     IS 'Sequential number of next scheduled notification message (used as a seed for pseudo-random initiative selection algorithm)';
 COMMENT ON COLUMN "member"."notification_sample_size" IS 'Number of featured initiatives per issue in scheduled notification messages';
diff -r 225a0c047691 -r f5095a9696eb update/core-update.v4.0.0-v4.0.1.sql
--- a/update/core-update.v4.0.0-v4.0.1.sql	Tue Sep 04 14:30:41 2018 +0200
+++ b/update/core-update.v4.0.0-v4.0.1.sql	Sun Nov 18 00:38:59 2018 +0100
@@ -4,6 +4,10 @@
   SELECT * FROM (VALUES ('4.0.1-dev', 4, 0, -1))
   AS "subquery"("string", "major", "minor", "revision");
 
+ALTER TABLE "member" ADD COLUMN "unsubscribe_secret" TEXT;
+
+COMMENT ON COLUMN "member"."unsubscribe_secret" IS 'Secret string to be used for a List-Unsubscribe mail header';
+
 ALTER TABLE "member" ADD COLUMN "role" BOOLEAN NOT NULL DEFAULT FALSE;
 
 CREATE TABLE "agent" (