From ebd0333256b8209de958085057848b649dbd9283 Mon Sep 17 00:00:00 2001 From: Mario Date: Fri, 7 May 2021 12:15:00 +0000 Subject: register: postgres - add default values for timestamps --- include/account.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'include/account.php') diff --git a/include/account.php b/include/account.php index cebcbd7e3..d138dab41 100644 --- a/include/account.php +++ b/include/account.php @@ -875,9 +875,9 @@ function verify_register_scheme() { . "reg_did2 text DEFAULT '' NOT NULL," . "reg_hash text DEFAULT '' NOT NULL," . "reg_email text DEFAULT '' NOT NULL," - . "reg_created timestamp NOT NULL," - . "reg_startup timestamp NOT NULL," - . "reg_expires timestamp NOT NULL," + . "reg_created timestamp NOT NULL DEFAULT '0001-01-01 00:00:00'," + . "reg_startup timestamp NOT NULL DEFAULT '0001-01-01 00:00:00'," + . "reg_expires timestamp NOT NULL DEFAULT '0001-01-01 00:00:00'," . "reg_byc bigint DEFAULT 0 NOT NULL," . "reg_uid bigint DEFAULT 0 NOT NULL," . "reg_atip text DEFAULT '' NOT NULL," -- cgit v1.2.3