liquid_feedback_core
diff update/core-update.v4.0.0-v4.0.1.sql @ 583:f5095a9696eb
Added "unsubscribe_secret" column
author | jbe |
---|---|
date | Sun Nov 18 00:38:59 2018 +0100 (2018-11-18) |
parents | 225a0c047691 |
children |
line diff
1.1 --- a/update/core-update.v4.0.0-v4.0.1.sql Tue Sep 04 14:30:41 2018 +0200 1.2 +++ b/update/core-update.v4.0.0-v4.0.1.sql Sun Nov 18 00:38:59 2018 +0100 1.3 @@ -4,6 +4,10 @@ 1.4 SELECT * FROM (VALUES ('4.0.1-dev', 4, 0, -1)) 1.5 AS "subquery"("string", "major", "minor", "revision"); 1.6 1.7 +ALTER TABLE "member" ADD COLUMN "unsubscribe_secret" TEXT; 1.8 + 1.9 +COMMENT ON COLUMN "member"."unsubscribe_secret" IS 'Secret string to be used for a List-Unsubscribe mail header'; 1.10 + 1.11 ALTER TABLE "member" ADD COLUMN "role" BOOLEAN NOT NULL DEFAULT FALSE; 1.12 1.13 CREATE TABLE "agent" (