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=13 DEFAULT CHARSET=utf8' at line 19 CREATE TABLE `ran_member` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `role_id` mediumint(9) NOT NULL, `account` varchar(64) NOT NULL, `nickname` varchar(50) NOT NULL, `password` char(32) NOT NULL, `last_login_time` int(11) unsigned DEFAULT '0', `last_login_ip` varchar(40) DEFAULT NULL, `login_count` mediumint(8) unsigned NOT NULL DEFAULT '0', `amount` decimal(11,2) NOT NULL, `intergral` int(11) NOT NULL, `email` varchar(50) NOT NULL, `remark` varchar(255) NOT NULL, `status` tinyint(1) NOT NULL, `create_time` int(11) unsigned NOT NULL, `update_time` int(11) unsigned NOT NULL, `thumb` varchar(500) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `account` (`account`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8
|