Invalid query:
CREATE TABLE `fts_datacache` (
`variantid` INT UNSIGNED NOT NULL ,
`productid` INT UNSIGNED NOT NULL ,
`sku` VARCHAR( 255 ) NOT NULL ,
`product` VARCHAR( 255 ) NOT NULL ,
`provider` VARCHAR( 255 ) NOT NULL ,
`weight` VARCHAR( 255 ) NOT NULL ,
`list_price` VARCHAR( 255 ) NOT NULL ,
`descr` TEXT NOT NULL ,
`fulldescr` TEXT NOT NULL ,
`avail` INT NOT NULL ,
`forsale` VARCHAR( 255 ) NOT NULL ,
`adddate` INT UNSIGNED NOT NULL ,
`shipping_freight` DECIMAL( 6, 2 ) NOT NULL ,
`free_shipping` VARCHAR( 255 ) NOT NULL ,
`free_tax` VARCHAR( 255 ) NOT NULL ,
`main_category` VARCHAR( 255 ) NOT NULL,
`manufacturer` VARCHAR( 255 ) NOT NULL ,
`categories` TEXT NOT NULL ,
`categoryids` TEXT NOT NULL ,
`price` DECIMAL( 10, 2 ) NOT NULL ,
`shipping_price` DECIMAL( 6, 2 ) NOT NULL ,
`tax` DECIMAL( 10, 2 ) NOT NULL ,
`extra_fields` TEXT NOT NULL ,
`thumb` VARCHAR( 255 ) NOT NULL ,
`product_image` VARCHAR( 255 ) NOT NULL,
`detailed_images` TEXT NOT NULL ,
`product_url` VARCHAR( 255 ) NOT NULL,
`variant_options` TEXT NOT NULL,
`product_options` TEXT NOT NULL,
PRIMARY KEY ( `variantid`, `productid` )
) TYPE = MYISAM ;
MySQL[1064]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE = MYISAM' at line 32