I have a table which looks like this:
CREATE TABLE `t_test` (
`T_REGION_ID` int(16) NOT NULL default '0',
`VALID_FROM` varchar(5) NOT NULL default '',
`TXT1` varchar(50) NOT NULL default '',
`DATE_CREATED` datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;
in the db there...