CREATE TABLE IF NOT EXISTS `players` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`group_id` int(11) NOT NULL DEFAULT '1',
`account_id` int(11) NOT NULL DEFAULT '0',
`level` int(11) NOT NULL DEFAULT '1',
`vocation` int(11) NOT NULL DEFAULT '0',
`health` int(11) NOT NULL DEFAULT '150',
`healthmax` int(11) NOT NULL DEFAULT '150',
`experience` bigint(20) NOT NULL DEFAULT '0',
`lookbody` int(11) NOT NULL DEFAULT '0',
`lookfeet` int(11) NOT NULL DEFAULT '0',
`lookhead` int(11) NOT NULL DEFAULT '0',
`looklegs` int(11) NOT NULL DEFAULT '0',
`looktype` int(11) NOT NULL DEFAULT '136',
`lookaddons` int(11) NOT NULL DEFAULT '0',
`maglevel` int(11) NOT NULL DEFAULT '0',
`mana` int(11) NOT NULL DEFAULT '0',
`manamax` int(11) NOT NULL DEFAULT '0',
`manaspent` int(11) unsigned NOT NULL DEFAULT '0',
`soul` int(10) unsigned NOT NULL DEFAULT '0',
`town_id` int(11) NOT NULL DEFAULT '0',
`posx` int(11) NOT NULL DEFAULT '0',
`posy` int(11) NOT NULL DEFAULT '0',
`posz` int(11) NOT NULL DEFAULT '0',
`conditions` blob NOT NULL,
`cap` int(11) NOT NULL DEFAULT '0',
`sex` int(11) NOT NULL DEFAULT '0',
`lastlogin` bigint(20) unsigned NOT NULL DEFAULT '0',
`lastip` int(10) unsigned NOT NULL DEFAULT '0',
`save` tinyint(1) NOT NULL DEFAULT '1',
`skull` tinyint(1) NOT NULL DEFAULT '0',
`skulltime` int(11) NOT NULL DEFAULT '0',
`lastlogout` bigint(20) unsigned NOT NULL DEFAULT '0',
`blessings` tinyint(2) NOT NULL DEFAULT '0',
`onlinetime` int(11) NOT NULL DEFAULT '0',
`deletion` bigint(15) NOT NULL DEFAULT '0',
`balance` bigint(20) unsigned NOT NULL DEFAULT '0',
`offlinetraining_time` smallint(5) unsigned NOT NULL DEFAULT '43200',
`offlinetraining_skill` int(11) NOT NULL DEFAULT '-1',
`stamina` smallint(5) unsigned NOT NULL DEFAULT '2520',
`skill_fist` int(10) unsigned NOT NULL DEFAULT '10',
`skill_fist_tries` bigint(20) unsigned NOT NULL DEFAULT '0',
`skill_club` int(10) unsigned NOT NULL DEFAULT '10',
`skill_club_tries` bigint(20) unsigned NOT NULL DEFAULT '0',
`skill_sword` int(10) unsigned NOT NULL DEFAULT '10',
`skill_sword_tries` bigint(20) unsigned NOT NULL DEFAULT '0',
`skill_axe` int(10) unsigned NOT NULL DEFAULT '10',
`skill_axe_tries` bigint(20) unsigned NOT NULL DEFAULT '0',
`skill_dist` int(10) unsigned NOT NULL DEFAULT '10',
`skill_dist_tries` bigint(20) unsigned NOT NULL DEFAULT '0',
`skill_shielding` int(10) unsigned NOT NULL DEFAULT '10',
`skill_shielding_tries` bigint(20) unsigned NOT NULL DEFAULT '0',
`skill_fishing` int(10) unsigned NOT NULL DEFAULT '10',
`skill_fishing_tries` bigint(20) unsigned NOT NULL DEFAULT '0',
`deleted` tinyint(1) NOT NULL DEFAULT '0',
`description` varchar(255) NOT NULL DEFAULT '',
`comment` text NOT NULL,
`create_ip` int(11) NOT NULL DEFAULT '0',
`create_date` int(11) NOT NULL DEFAULT '0',
`hide_char` int(11) NOT NULL DEFAULT '0',
`cast` tinyint(1) NOT NULL DEFAULT '0',
`skill_critical_hit_chance_tries` bigint(20) unsigned NOT NULL DEFAULT '0',
`skill_critical_hit_damage` int(10) unsigned NOT NULL DEFAULT '0',
`skill_critical_hit_damage_tries` bigint(20) unsigned NOT NULL DEFAULT '0',
`skill_life_leech_chance` int(10) unsigned NOT NULL DEFAULT '0',
`skill_life_leech_chance_tries` bigint(20) unsigned NOT NULL DEFAULT '0',
`skill_life_leech_amount` int(10) unsigned NOT NULL DEFAULT '0',
`skill_life_leech_amount_tries` bigint(20) unsigned NOT NULL DEFAULT '0',
`skill_mana_leech_chance` int(10) unsigned NOT NULL DEFAULT '0',
`skill_mana_leech_chance_tries` bigint(20) unsigned NOT NULL DEFAULT '0',
`skill_mana_leech_amount` int(10) unsigned NOT NULL DEFAULT '0',
`skill_mana_leech_amount_tries` bigint(20) unsigned NOT NULL DEFAULT '0',
`skill_criticalhit_chance_tries` bigint(20) unsigned NOT NULL DEFAULT '0',
`skill_criticalhit_damage` int(10) unsigned NOT NULL DEFAULT '0',
`skill_criticalhit_damage_tries` bigint(20) unsigned NOT NULL DEFAULT '0',
`skill_criticalhit_chance` bigint(20) unsigned NOT NULL DEFAULT '0',
`skill_lifeleech_chance` bigint(20) unsigned NOT NULL DEFAULT '0',
`skill_manaleech_chance` bigint(20) unsigned NOT NULL DEFAULT '0',
`skill_lifeleech_amount` int(10) unsigned NOT NULL DEFAULT '0',
`skill_manaleech_amount` int(10) unsigned NOT NULL DEFAULT '0',
`marriage_status` tinyint(11) NOT NULL DEFAULT '0',
`skill_critical_hit_chance` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `account_id` (`account_id`),
KEY `vocation` (`vocation`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=155 ;