liquid_feedback_core

changeset 583:f5095a9696eb

Added "unsubscribe_secret" column
author jbe
date Sun Nov 18 00:38:59 2018 +0100 (16 months ago)
parents 225a0c047691
children f9e09710ec60
files .hgtags core.sql update/core-update.v4.0.0-v4.0.1.sql
line diff
     1.1 --- a/.hgtags	Tue Sep 04 14:30:41 2018 +0200
     1.2 +++ b/.hgtags	Sun Nov 18 00:38:59 2018 +0100
     1.3 @@ -77,4 +77,3 @@
     1.4  ab05fb3bf974a8c206124c196fb7db4c1a3cc6a7 v3.2.0
     1.5  e4f619e87664965b1bac84c006e8f043f139392f v3.2.1
     1.6  bc6d9dc60ca4530e25ad401618fd84c109fbf982 v3.2.2
     1.7 -ed3c3d8bd16b4d1689b01e022d58db39646aa86e v4.0.0
     2.1 --- a/core.sql	Tue Sep 04 14:30:41 2018 +0200
     2.2 +++ b/core.sql	Sun Nov 18 00:38:59 2018 +0100
     2.3 @@ -115,6 +115,7 @@
     2.4          "notify_email_secret"          TEXT     UNIQUE,
     2.5          "notify_email_secret_expiry"   TIMESTAMPTZ,
     2.6          "notify_email_lock_expiry"     TIMESTAMPTZ,
     2.7 +        "unsubscribe_secret"    TEXT,
     2.8          "disable_notifications"    BOOLEAN      NOT NULL DEFAULT FALSE,
     2.9          "notification_counter"     INT4         NOT NULL DEFAULT 1,
    2.10          "notification_sample_size" INT4         NOT NULL DEFAULT 3,
    2.11 @@ -179,6 +180,7 @@
    2.12  COMMENT ON COLUMN "member"."notify_email_secret"        IS 'Secret sent to the address in "notify_email_unconformed"';
    2.13  COMMENT ON COLUMN "member"."notify_email_secret_expiry" IS 'Expiry date/time for "notify_email_secret"';
    2.14  COMMENT ON COLUMN "member"."notify_email_lock_expiry"   IS 'Date/time until no further email confirmation mails may be sent (abuse protection)';
    2.15 +COMMENT ON COLUMN "member"."unsubscribe_secret"         IS 'Secret string to be used for a List-Unsubscribe mail header';
    2.16  COMMENT ON COLUMN "member"."disable_notifications"    IS 'TRUE if member does not want to receive notifications';
    2.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)';
    2.18  COMMENT ON COLUMN "member"."notification_sample_size" IS 'Number of featured initiatives per issue in scheduled notification messages';
     3.1 --- a/update/core-update.v4.0.0-v4.0.1.sql	Tue Sep 04 14:30:41 2018 +0200
     3.2 +++ b/update/core-update.v4.0.0-v4.0.1.sql	Sun Nov 18 00:38:59 2018 +0100
     3.3 @@ -4,6 +4,10 @@
     3.4    SELECT * FROM (VALUES ('4.0.1-dev', 4, 0, -1))
     3.5    AS "subquery"("string", "major", "minor", "revision");
     3.6  
     3.7 +ALTER TABLE "member" ADD COLUMN "unsubscribe_secret" TEXT;
     3.8 +
     3.9 +COMMENT ON COLUMN "member"."unsubscribe_secret" IS 'Secret string to be used for a List-Unsubscribe mail header';
    3.10 +
    3.11  ALTER TABLE "member" ADD COLUMN "role" BOOLEAN NOT NULL DEFAULT FALSE;
    3.12  
    3.13  CREATE TABLE "agent" (

Impressum / About Us