07-20-2013, 12:43 AM
Make a new Query and past this into it:
DROP TABLE IF EXISTS `bg_user`;
CREATE TABLE `bg_user` (
`user_code` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` varchar(30) NOT NULL DEFAULT 0,
`truepasswd` varchar(30) DEFAULT NULL,
`passwd` varchar(200) NOT NULL DEFAULT 0,
`chk_tester` char(1) NOT NULL DEFAULT N,
`jumin` varchar(20) DEFAULT 0,
`chk_service` char(1) DEFAULT Y,
`partner_id` char(2) NOT NULL DEFAULT LC,
`active_passwd` varchar(15) NOT NULL DEFAULT 0,
`active_time` datetime NOT NULL DEFAULT 0000-00-00 00:00:00,
`create_date` datetime NOT NULL DEFAULT 0000-00-00 00:00:00,
`email` varchar(100) DEFAULT NULL,
`ip` varchar(20) DEFAULT NULL,
`hashigh` smallint(6) DEFAULT NULL,
`send` int(11) DEFAULT 0,
`question` varchar(200) DEFAULT NULL,
`answer` varchar(200) DEFAULT NULL,
`chk_closebeta` char(1) NOT NULL,
`cash` int(10) DEFAULT 0,
`a_cash` int(10) DEFAULT NULL,
`a_online_time` int(10) DEFAULT NULL,
`cellphone` varchar(100) DEFAULT NULL,
`gender` varchar(100) DEFAULT NULL,
`day` varchar(10) DEFAULT NULL,
`month` varchar(50) DEFAULT NULL,
`year` varchar(100) DEFAULT NULL,
`avatar` varchar(500) DEFAULT NULL,
PRIMARY KEY (`user_code`),
UNIQUE KEY `user_id` (`user_id`),
KEY `passwd` (`passwd`)
) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=utf8;
---------------------------------------------------------------------------------------------------------------------------------------------------------
MAKE A BACKUP OF BG_USER BEFORE YOU TRY THIS!