liquid_feedback_core
changeset 558:25b551e53da2
Set default for column "accepted" in "member_useterms"
author | jbe |
---|---|
date | Wed Sep 20 17:57:21 2017 +0200 (2017-09-20) |
parents | 0fc78541dc15 |
children | 71f431fb78d4 |
files | core.sql update/core-update.v3.2.2-v4.0.0.sql |
line diff
1.1 --- a/core.sql Mon Sep 18 01:44:32 2017 +0200 1.2 +++ b/core.sql Wed Sep 20 17:57:21 2017 +0200 1.3 @@ -248,7 +248,7 @@ 1.4 1.5 CREATE TABLE "member_useterms" ( 1.6 "member_id" INT4 PRIMARY KEY REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.7 - "accepted" TIMESTAMPTZ NOT NULL, 1.8 + "accepted" TIMESTAMPTZ NOT NULL DEFAULT now(), 1.9 "contract_identifier" TEXT NOT NULL ); 1.10 1.11 COMMENT ON TABLE "member_useterms" IS 'Keeps record of accepted terms of use; may contain multiple rows per member';
2.1 --- a/update/core-update.v3.2.2-v4.0.0.sql Mon Sep 18 01:44:32 2017 +0200 2.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql Wed Sep 20 17:57:21 2017 +0200 2.3 @@ -81,7 +81,7 @@ 2.4 2.5 CREATE TABLE "member_useterms" ( 2.6 "member_id" INT4 PRIMARY KEY REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 2.7 - "accepted" TIMESTAMPTZ NOT NULL, 2.8 + "accepted" TIMESTAMPTZ NOT NULL DEFAULT now(), 2.9 "contract_identifier" TEXT NOT NULL ); 2.10 2.11 COMMENT ON TABLE "member_useterms" IS 'Keeps record of accepted terms of use; may contain multiple rows per member';