Mailing List Archive

commit e287246f93151bc165fa8d431997eba5d5a1bb8f
Author: Josh Lavin <digory@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

_______________________________________________
interchange-cvs mailing list
interchange-cvs@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-cvs