liquid_feedback_core
changeset 583:f5095a9696eb
Added "unsubscribe_secret" column
author | jbe |
---|---|
date | Sun Nov 18 00:38:59 2018 +0100 (2018-11-18) |
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" (