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';