Hi,
As part of the installation of a contribution I have to run the following SQL database query:
DROP TABLE IF EXISTS `products_cross_sell`;
CREATE TABLE IF NOT EXISTS `products_cross_sell` (
`products_cross_sell_id` int(10) NOT NULL auto_increment,
`products_id` int(10) unsigned NOT NULL default '1',
`cross_sell_id` int(10) unsigned NOT NULL default '1',
`cross_sell_sort_order` int(10) unsigned NOT NULL default '1',
PRIMARY KEY (`products_cross_sell_id`)
) TYPE=MyISAM;
When I do this I get the following error message:
#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 7
Is there an obvious error does anyone know?
Thanks
David