title: mysql syntax error: 'USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 AUTOINCREMENT='
body: <p>Im getting this error: </p>
  
  <pre><code>CREATE TABLE `pdc5l_usergroups` (
  `id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Clave primaria',
  `parent_id` int( 10 ) unsigned NOT NULL DEFAULT '0' COMMENT 'ID Lista de referencia adyacente',
  `lft` int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Anidadas conjunto lft.',
  `rgt` int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Anidadas conjunto rgt.',
  `title` varchar( 100 ) NOT NULL DEFAULT '',
  PRIMARY KEY ( `id` ) ,
  UNIQUE KEY `idx_usergroup_parent_title_lookup` ( `parent_id` , `title` ) ,
  KEY `idx_usergroup_title_lookup` ( `title` ) ,
  KEY `idx_usergroup_adjacency_lookup` ( `parent_id` ) ,
  KEY `idx_usergroup_nested_set_lookup` ( `lft` , `rgt` ) USING BTREE
  ) ENGINE = MYISAM AUTO_INCREMENT =9 DEFAULT CHARSET = utf8AUTOINCREMENT =9;
  
  MySQL said: Documentation
  #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
  ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 AUTOINCREMENT=' at line 11 
  </code></pre>
  
  <p>I have tried these:</p>
  
  <pre><code>) ENGINE = MYISAM AUTO_INCREMENT =9 DEFAULT CHARSET = utf8 AUTO_INCREMENT =9;
  ) ENGINE = MYISAM AUTOINCREMENT =9 DEFAULT CHARSET = utf8 AUTOINCREMENT =9;
  ) ENGINE = MYISAM AUTOINCREMENT =9 DEFAULT CHARSET = utf8 AUTO_INCREMENT =9;
  </code></pre>
  
  <p>but I still get the error.</p>
  
  <p>phpmyadmin says this: <code>MySQL client version: 4.1.22</code></p>