When I have the following table:
CREATE TABLE `atable` (
`THEKEYFIELD` int(5) NOT NULL auto_increment,
`SOMETIMESTAMPFIELD` timestamp(14) NOT NULL,
PRIMARY KEY (`THEKEYFIELD`)
) TYPE=MyISAM;
and run it through the Extract/Parse/Execute routines,
the adodb-xmlschema creates the following table:
CREATE TABLE atable (
THEKEYFIELD INTEGER(5) NOT NULL AUTO_INCREMENT,
SOMETIMESTAMPFIELD DATETIME(14),
PRIMARY KEY (THEKEYFIELD)
);
As you can see, the timestamp(14) field is translated
into a datetime(14) field, which creates an error when
I try to use this SQL in MySQL.