DROP TABLE IF EXISTS `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',
`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;