Hanut сказал:Ошибки не вижу. Покажите полный запрос на создание таблицы, которая выдает ошибку.
SQL-запрос:
#
# Structure for the `phpbb_bt_users` table :
#
CREATE TABLE `phpbb_bt_users` (
`user_id` MEDIUMINT( 9 ) NOT NULL DEFAULT '0',
`auth_key` CHAR( 10 ) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL DEFAULT '',
`u_up_total` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0',
`u_down_total` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0',
`u_bonus_total` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0',
`max_up_speed` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0',
`max_down_speed` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0' PRIMARY KEY ( `user_id` ) ,
UNIQUE KEY `auth_key` ( `auth_key` )
) ENGINE = MYISAM DEFAULT CHARSET = cp1251;
Ответ 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 '(`user_id`),
UNIQUE KEY `auth_key` (`auth_key`)
) ENGINE=MyISAM DEFAULT CHAR' at line 13