MYSQL Table Structure

[Ernesto]

Dear all, i just solved the issue adding:

ENGINE = MyISAM

at the end of all "CREATE TABLE" command:

for example
-- --------------------------------------------------------
--
-- Table structure for table `tblDocumentContent`
--
CREATE TABLE `tblDocumentContent` (

`document` INT( 11 ) NOT NULL DEFAULT '0',
`version` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`comment` TEXT,
`date` INT( 12 ) DEFAULT NULL ,
`createdBy` INT( 11 ) DEFAULT NULL ,
`dir` VARCHAR( 255 ) NOT NULL DEFAULT '',
`orgFileName` VARCHAR( 150 ) NOT NULL DEFAULT '',
`fileType` VARCHAR( 10 ) NOT NULL DEFAULT '',
`mimeType` VARCHAR( 70 ) NOT NULL DEFAULT '',
PRIMARY KEY ( `document` , `version` )
) ENGINE = MyISAM ;

Rgds.
Ernesto