CREATE TABLE `person` (
`id` int(11) unsigned NOT NULL default '0',
`user` varchar(30) NOT NULL,
`pass` varchar(32) NOT NULL,
`rank` tinyint(2) unsigned NOT NULL default '0',
`admin` tinyint(1) unsigned NOT NULL default '0',
`bloked` varchar(150) NOT NULL default '0',
`reason` varchar(150) NOT NULL,
`ma_time` int(11) unsigned default '0',
`m_time` int(11) unsigned NOT NULL default '0',
`ch_time` int(11) unsigned default '0',
`f_time` int(11) unsigned default '0',
`for_time` int(11) NOT NULL default '0',
`les` int(11) unsigned NOT NULL default '0',
`t_time` int(11) default '0',
`v_time` int(11) default NULL,
`k_time` int(11) default '0',
`p_time` int(11) default '0',
`o_time` int(11) default '0',
`invisible` int(11) default NULL,
`mutation` int(11) default '0',
`level` int(11) NOT NULL default '0',
`up` int(11) NOT NULL default '0',
`exp` int(11) NOT NULL default '0',
`credits` float(10,2) NOT NULL default '0.00',
`f_credits` float(10,2) NOT NULL default '0.00',
`birja` float(10,2) NOT NULL default '0.00',
`strength` int(6) NOT NULL default '3',
`dex` int(6) NOT NULL default '3',
`agility` int(6) NOT NULL default '3',
`vitality` int(6) NOT NULL default '3',
`power` int(6) NOT NULL default '1',
`razum` int(6) NOT NULL default '0',
`battery` int(6) NOT NULL default '1',
`hp_now` int(11) NOT NULL default '15',
`energy_now` int(11) NOT NULL default '15',
`s_updates` int(5) NOT NULL default '3',
`o_updates` int(5) NOT NULL default '3',
`wins` int(11) NOT NULL default '0',
`losses` int(11) NOT NULL default '0',
`drawn` int(5) NOT NULL default '0',
`room` smallint(4) unsigned NOT NULL default '1',
`ip` varchar(15) NOT NULL default '',
`tribe` varchar(25) NOT NULL default '',
`tribe_rank` varchar(50) NOT NULL default '',
`b_tribe` tinyint(1) unsigned NOT NULL default '0',
`birth` varchar(20) NOT NULL default '',
`birthdate` varchar(25) NOT NULL default '',
`sex` int(1) NOT NULL default '0',
`battle` int(11) unsigned default NULL,
`last_battle` int(11) unsigned NOT NULL default '0',
`offer` int(11) default NULL,
`side` tinyint(4) NOT NULL default '0',
`obraz` varchar(20) NOT NULL default '0',
`color` tinyint(2) unsigned NOT NULL default '0',
`font` tinyint(1) unsigned NOT NULL default '0',
`proff` int(2) NOT NULL default '0',
`proff_exp` varchar(75) NOT NULL default '0|0|0|0|0|0|0|0|0|0|0',
`active` int(1) NOT NULL default '0',
`item_type` tinyint(1) unsigned NOT NULL default '1',
`sign` int(11) NOT NULL default '0',
`travma` int(11) NOT NULL default '0',
`t_level` int(1) NOT NULL default '0',
`t_type` int(1) NOT NULL default '0',
`rase_skill` varchar(14) NOT NULL default '0|0|0|0|0|0',
`lpv` int(10) NOT NULL default '0',
`m_k` int(2) NOT NULL default '0',
`m_m` int(2) NOT NULL default '0',
`m_t` int(2) NOT NULL default '0',
`m_d` int(2) NOT NULL default '0',
`m_p` tinyint(2) unsigned NOT NULL default '0',
`vault_room` int(3) NOT NULL default '0',
`vault_time` int(11) NOT NULL default '0',
`vault_move` int(1) NOT NULL default '0',
`ic` int(11) NOT NULL default '0',
`w_time` int(11) default '0',
`r_time` int(11) NOT NULL default '0',
`r_action` int(1) NOT NULL default '0',
`ustal_now` int(11) NOT NULL default '15',
`immun` int(11) NOT NULL default '0',
`semija` varchar(30) NOT NULL,
`sclon` tinyint(1) unsigned NOT NULL default '0',
`golos` char(2) NOT NULL default '0',
`links` int(10) NOT NULL default '0',
`status` tinyint(1) unsigned NOT NULL default '0',
`cure_hp` int(11) default '0',
`kl_time` int(11) NOT NULL default '0',
`fish_time` int(11) default NULL,
`fish_action` int(1) NOT NULL default '0',
`reit` float(7,2) NOT NULL default '0.00',
`vip` int(1) NOT NULL default '0',
`avatar` int(1) NOT NULL default '0',
`elik_time` int(11) NOT NULL default '0',
`elik_action` varchar(30) NOT NULL default '0|0|0|0|0|0|0',
`bog_time` int(11) NOT NULL default '0',
`bog_dark` int(6) NOT NULL default '0',
`bog_light` int(6) NOT NULL default '0',
`kwest0` int(5) NOT NULL default '0',
`kwest1` int(5) NOT NULL default '0',
`kwest_k` int(5) NOT NULL default '0',
`podzem1` int(2) NOT NULL default '0',
`guild` tinyint(1) unsigned NOT NULL default '0',
`refer` int(11) unsigned NOT NULL default '0',
`aura` smallint(5) unsigned NOT NULL default '0',
`aura_t` int(11) unsigned NOT NULL default '0',
`location` smallint(5) unsigned NOT NULL default '0',
`bs` tinyint(1) unsigned NOT NULL default '0',
`bs_loc` smallint(5) unsigned NOT NULL default '0',
UNIQUE KEY `user` (`user`),
KEY `id` (`id`),
KEY `battle` (`battle`),
KEY `losses` (`losses`),
KEY `wins` (`wins`),
KEY `tribe` (`tribe`),
KEY `item_type` (`item_type`),
KEY `room` (`room`),
KEY `rank` (`rank`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;