liquid_feedback_core

diff update/core-update.v3.2.2-v4.0.0.sql @ 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
     1.1 --- a/update/core-update.v3.2.2-v4.0.0.sql	Mon Sep 18 01:44:32 2017 +0200
     1.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql	Wed Sep 20 17:57:21 2017 +0200
     1.3 @@ -81,7 +81,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';