[interchange] Use timestamp datatype for Postgres

Josh Lavin interchange-cvs at icdevgroup.org
Wed Jan 25 22:12:55 UTC 2017


commit e287246f93151bc165fa8d431997eba5d5a1bb8f
Author: Josh Lavin <digory at cpan.org>
Date:   Wed Jan 25 14:12:30 2017 -0800

    Use timestamp datatype for Postgres

 dist/strap/dbconf/pgsql/userdb.pgsql |    7 +++----
 1 files changed, 3 insertions(+), 4 deletions(-)
---
diff --git a/dist/strap/dbconf/pgsql/userdb.pgsql b/dist/strap/dbconf/pgsql/userdb.pgsql
index dd492c8..1f69051 100644
--- 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



More information about the interchange-cvs mailing list