Recuperando un BD de MySQL recibo el siguiente mensaje
#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 ‘USING BTREE,
KEY `FK_ATTRIBUTE_VARCHAR_ENTITY` (`entity_id`),
KEY `FK_CATALO’ at line 9
Al procesar
CREATE TABLE IF NOT EXISTS `catalog_category_entity_varchar` (
`value_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`entity_type_id` SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT ‘0’,
`attribute_id` SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT ‘0’,
`store_id` SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT ‘0’,
`entity_id` INT( 10 ) UNSIGNED NOT NULL DEFAULT ‘0’,
`value` VARCHAR( 255 ) NOT NULL DEFAULT »,
PRIMARY KEY ( `value_id` ) ,
UNIQUE KEY `IDX_BASE` ( `entity_type_id` , `entity_id` , `attribute_id` , `store_id` ) USING BTREE,
KEY `FK_ATTRIBUTE_VARCHAR_ENTITY` ( `entity_id` ) ,
KEY `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_ATTRIBUTE` ( `attribute_id` ) ,
KEY `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_STORE` ( `store_id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT =280;
Solucion
cambio
UNIQUE KEY `IDX_BASE` (`entity_type_id`,`entity_id`,`attribute_id`,`store_id`) USING BTREE,
por
UNIQUE KEY `IDX_BASE` USING BTREE (`entity_type_id`,`entity_id`,`attribute_id`,`store_id`) ,
