From 7ada6ffc7f0bc02f9f9a9484cf30517a8cf6431c Mon Sep 17 00:00:00 2001
From: Christian Weber
Date: Fri, 12 Oct 2007 21:35:02 +0000
Subject: fix field length for time, date and datetime, not just datetime

---
 it_dbi.class | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/it_dbi.class b/it_dbi.class
index 0926a1c..644bec5 100644
--- a/it_dbi.class
+++ b/it_dbi.class
@@ -619,7 +619,7 @@ function _get_field_info()
 	{
 		debug("it_dbi(): no fields for {$this->_p['dbid']}.{$this->_p['table']}, calculating.", 5);
 		for ($res = $this->query('SHOW COLUMNS FROM ' . $this->_p['table']); $field = mysql_fetch_assoc($res);)
-			$this->_fields[$field['Field']] = $field + array('Length' => ($field['Type'] == 'datetime') ? 20 : intval(it::match('\d+', $field['Type'])));
+			$this->_fields[$field['Field']] = $field + array('Length' => preg_match('/date|time/', $field['Type']) ? 20 : intval(it::match('\d+', $field['Type'])));
 
 		$GLOBALS['it_dbi']->_state[$this->_p['dbid']]['fields'][$this->_p['table']] = $this->_fields;
 	}
-- 
cgit v1.2.3