[interchange] Use timestamp datatype for Postgres
Josh Lavin <[email protected]> Wed, 25 Jan 2017 22:12:55 +0000
| Newsgroups | gmane.comp.web.interchange.cvs |
|---|---|
| Message-ID | <[email protected]> |
commit e287246f93151bc165fa8d431997eba5d5a1bb8f Author: Josh Lavin <[email protected]> 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