--
-- Struktura tabeli dla `statystyki`
--
CREATE TABLE IF NOT EXISTS `statystyki` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`nick` varchar(24) CHARACTER SET ascii NOT NULL,
`password` varchar(32) NOT NULL,
`ip_registered` varchar(16) NOT NULL,
`ip_last` varchar(16) NOT NULL,
`datetime_registered` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`datetime_last` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`session` bigint(11) NOT NULL,
`level` tinyint(4) NOT NULL,
`gang` int(11) NOT NULL,
`language` tinyint(4) NOT NULL,
`ban_count` mediumint(9) NOT NULL,
`kick_count` mediumint(9) NOT NULL,
`login_count` mediumint(9) NOT NULL,
`kill_count` mediumint(9) NOT NULL,
`teamkill_count` mediumint(9) NOT NULL,
`death_count` mediumint(9) NOT NULL,
`suicide_count` mediumint(9) NOT NULL,
`respect` int(11) NOT NULL,
`skill` mediumint(9) NOT NULL,
`next_nick_change` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`bank_money` int(11) NOT NULL,
`wallet_money` int(11) NOT NULL,
`hitman_prize` int(11) NOT NULL,
`jail` mediumint(9) NOT NULL DEFAULT '-1',
`last_skin` smallint(5) unsigned NOT NULL DEFAULT '0',
`mute` mediumint(9) NOT NULL DEFAULT '0',
`hud0` tinyint(1) NOT NULL DEFAULT '1',
`hud1` tinyint(1) NOT NULL DEFAULT '1',
`hud2` tinyint(1) NOT NULL DEFAULT '1',
`hud3` tinyint(1) NOT NULL DEFAULT '1',
`hud4` tinyint(1) NOT NULL DEFAULT '1',
`hud5` tinyint(1) NOT NULL DEFAULT '1',
`hud6` tinyint(1) NOT NULL DEFAULT '1',
`hud7` tinyint(1) NOT NULL DEFAULT '1',
`hud8` tinyint(1) NOT NULL DEFAULT '1',
`gender` tinyint(1) NOT NULL DEFAULT '0',
UNIQUE
KEY `nick`
(`nick`
), KEY `session`
(`session`
), KEY `respect`
(`respect`
), FULLTEXT
KEY `ip_last`
(`ip_last`
)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=17017 ;
--
-- Zrzut danych tabeli