aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMario <mario@mariovavti.com>2021-05-07 12:15:00 +0000
committerMario <mario@mariovavti.com>2021-05-07 12:15:56 +0000
commit605bf3b9d3cb5ad4c3675af5b167dc87a6a20ad5 (patch)
tree5f6473b5831f8fda50519a7f726332f32f5d6ad4
parentd7dcf192c7f07e520f067fc5645bf7cf49855144 (diff)
downloadvolse-hubzilla-605bf3b9d3cb5ad4c3675af5b167dc87a6a20ad5.tar.gz
volse-hubzilla-605bf3b9d3cb5ad4c3675af5b167dc87a6a20ad5.tar.bz2
volse-hubzilla-605bf3b9d3cb5ad4c3675af5b167dc87a6a20ad5.zip
register: postgres - add default values for timestamps
(cherry picked from commit ebd0333256b8209de958085057848b649dbd9283)
-rw-r--r--include/account.php6
1 files changed, 3 insertions, 3 deletions
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,"