1.1 --- a/core.sql	Tue Sep 04 14:30:41 2018 +0200
     1.2 +++ b/core.sql	Sun Nov 18 00:38:59 2018 +0100
     1.3 @@ -115,6 +115,7 @@
     1.4          "notify_email_secret"          TEXT     UNIQUE,
     1.5          "notify_email_secret_expiry"   TIMESTAMPTZ,
     1.6          "notify_email_lock_expiry"     TIMESTAMPTZ,
     1.7 +        "unsubscribe_secret"    TEXT,
     1.8          "disable_notifications"    BOOLEAN      NOT NULL DEFAULT FALSE,
     1.9          "notification_counter"     INT4         NOT NULL DEFAULT 1,
    1.10          "notification_sample_size" INT4         NOT NULL DEFAULT 3,
    1.11 @@ -179,6 +180,7 @@
    1.12  COMMENT ON COLUMN "member"."notify_email_secret"        IS 'Secret sent to the address in "notify_email_unconformed"';
    1.13  COMMENT ON COLUMN "member"."notify_email_secret_expiry" IS 'Expiry date/time for "notify_email_secret"';
    1.14  COMMENT ON COLUMN "member"."notify_email_lock_expiry"   IS 'Date/time until no further email confirmation mails may be sent (abuse protection)';
    1.15 +COMMENT ON COLUMN "member"."unsubscribe_secret"         IS 'Secret string to be used for a List-Unsubscribe mail header';
    1.16  COMMENT ON COLUMN "member"."disable_notifications"    IS 'TRUE if member does not want to receive notifications';
    1.17  COMMENT ON COLUMN "member"."notification_counter"     IS 'Sequential number of next scheduled notification message (used as a seed for pseudo-random initiative selection algorithm)';
    1.18  COMMENT ON COLUMN "member"."notification_sample_size" IS 'Number of featured initiatives per issue in scheduled notification messages';