Use timestamp datatype for Postgres

interchange · Jan 25, 2017 · e287246 · e287246
1 parent 997abee
commit e287246
Showing 1 changed file with 3 additions and 4 deletions.
diff --git a/dist/strap/dbconf/pgsql/userdb.pgsql b/dist/strap/dbconf/pgsql/userdb.pgsql
@@ -39,7 +39,7 @@ Database  userdb  COLUMN_DEF   "fname=varchar(30)"
 Database  userdb  COLUMN_DEF   "inactive=varchar(8)"
 Database  userdb  COLUMN_DEF   "lname=varchar(30)"
 Database  userdb  COLUMN_DEF   "mail_list=text"
-Database  userdb  COLUMN_DEF   "mod_time=varchar(20)"
+Database  userdb  COLUMN_DEF   "mod_time=timestamp"
 Database  userdb  COLUMN_DEF   "mv_shipmode=varchar(255)"
 Database  userdb  COLUMN_DEF   "owner=varchar(20)"
 Database  userdb  COLUMN_DEF   "p_nickname=text"
@@ -52,8 +52,7 @@ Database  userdb  COLUMN_DEF   "state=varchar(20)"
 Database  userdb  COLUMN_DEF   "updated=varchar(32)"
 Database  userdb  COLUMN_DEF   "zip=varchar(10)"
 Database  userdb  DEFAULT      "inactive=''"
-Database  userdb  PREFER_NULL   usernick
+Database  userdb  PREFER_NULL   usernick mod_time
 Database  userdb  INDEX        "UNIQUE usernick"
 
-# Prevent problems with abstime representation
-UserDB    default    time_field    none
+UserDB    default    iso_time  1