# HG changeset patch
# User jbe
# Date 1505923041 -7200
# Node ID 25b551e53da2639f1d09a9861e003e2ee3833b25
# Parent  0fc78541dc154115a727792127448ab2b4d2981d
Set default for column "accepted" in "member_useterms"

diff -r 0fc78541dc15 -r 25b551e53da2 core.sql
--- a/core.sql	Mon Sep 18 01:44:32 2017 +0200
+++ b/core.sql	Wed Sep 20 17:57:21 2017 +0200
@@ -248,7 +248,7 @@
 
 CREATE TABLE "member_useterms" (
         "member_id"             INT4            PRIMARY KEY REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
-        "accepted"              TIMESTAMPTZ     NOT NULL,
+        "accepted"              TIMESTAMPTZ     NOT NULL DEFAULT now(),
         "contract_identifier"   TEXT            NOT NULL );
 
 COMMENT ON TABLE "member_useterms" IS 'Keeps record of accepted terms of use; may contain multiple rows per member';
diff -r 0fc78541dc15 -r 25b551e53da2 update/core-update.v3.2.2-v4.0.0.sql
--- a/update/core-update.v3.2.2-v4.0.0.sql	Mon Sep 18 01:44:32 2017 +0200
+++ b/update/core-update.v3.2.2-v4.0.0.sql	Wed Sep 20 17:57:21 2017 +0200
@@ -81,7 +81,7 @@
 
 CREATE TABLE "member_useterms" (
         "member_id"             INT4            PRIMARY KEY REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
-        "accepted"              TIMESTAMPTZ     NOT NULL,
+        "accepted"              TIMESTAMPTZ     NOT NULL DEFAULT now(),
         "contract_identifier"   TEXT            NOT NULL );
 
 COMMENT ON TABLE "member_useterms" IS 'Keeps record of accepted terms of use; may contain multiple rows per member';