DROPTABLEIFEXISTS`bb_bt_users`;
CREATE TABLE IF NOT EXISTS `bb_bt_users` (
`user_id` mediumint(9) NOT NULL default '0',
`auth_key` char(10) character set utf8 collate utf8_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_up_release` bigint(20) unsigned NOT NULL default '0',
`u_up_bonus` bigint(20) unsigned NOT NULL default '0',
`user_vip` int(4) NOT NULL,
`user_vip_exp` varchar(255) NOT NULL,
`max_up_speed` bigint(20) NOT NULL default '0',
`max_down_speed` bigint(20) NOT NULL default '0',
`u_down_today` bigint(20) NOT NULL default '0',
`u_up_today` bigint(20) NOT NULL default '0',
`u_release_today` bigint(20) NOT NULL default '0',
`u_bonus_today` bigint(20) NOT NULL default '0',
`u_up_speed_today` bigint(20) NOT NULL default '0',
`u_down_speed_today` bigint(20) NOT NULL default '0',
PRIMARY KEY (`user_id`),
UNIQUE KEY `auth_key` (`auth_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;