> I created a database in last version of MySQL. I generated script to
> create tables (for this database). When I try to import this script
> into older version of MySQL (distributed with Fedora 8), I receive
> error that USING BTREE command is not understood. Here is sample table
> from my database:

> DROP TABLE IF EXISTS `estate_types`;
> /*!40101 SET @saved_cs_client     = @@character_set_client */;
> /*!40101 SET character_set_client = utf8 */;
> CREATE TABLE `estate_types` (
>   `estate_type_id` varchar(5) NOT NULL COMMENT 'Rodzaj nieruchomosci',
>   `estate_type_name` varchar(33) NOT NULL COMMENT 'Nazwa rodzaju
> nieruchomosci',
>   PRIMARY KEY (`estate_type_id`),
>   KEY `index_estate_type_name` (`estate_type_name`) USING BTREE
> ) ENGINE=MyISAM DEFAULT CHARSET=latin2 COMMENT='Rodzaje
> nieruchomosci';
> /*!40101 SET character_set_client = @saved_cs_client */;

> The problem is with USING BTREE.
> Question: how to change the syntax to be able to import the script
> into older MySQL?