Titlu descrie tot.
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `player_deleted`
-- ----------------------------
DROP TABLE IF EXISTS `player_deleted`;
CREATE TABLE `player_deleted` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL DEFAULT '0',
`name` varchar(24) NOT NULL DEFAULT 'NONAME',
`job` tinyint(2) unsigned NOT NULL DEFAULT '0',
`voice` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dir` tinyint(2) NOT NULL DEFAULT '0',
`x` int(11) NOT NULL DEFAULT '0',
`y` int(11) NOT NULL DEFAULT '0',
`z` int(11) NOT NULL DEFAULT '0',
`map_index` int(11) NOT NULL DEFAULT '0',
`exit_x` int(11) NOT NULL DEFAULT '0',
`exit_y` int(11) NOT NULL DEFAULT '0',
`exit_map_index` int(11) NOT NULL DEFAULT '0',
`hp` smallint(4) NOT NULL DEFAULT '0',
`mp` smallint(4) NOT NULL DEFAULT '0',
`stamina` smallint(6) NOT NULL DEFAULT '0',
`random_hp` smallint(5) unsigned NOT NULL DEFAULT '0',
`random_sp` smallint(5) unsigned NOT NULL DEFAULT '0',
`playtime` int(11) NOT NULL DEFAULT '0',
`level` tinyint(2) unsigned NOT NULL DEFAULT '1',
`level_step` tinyint(1) NOT NULL DEFAULT '0',
`st` smallint(3) NOT NULL DEFAULT '0',
`ht` smallint(3) NOT NULL DEFAULT '0',
`dx` smallint(3) NOT NULL DEFAULT '0',
`iq` smallint(3) NOT NULL DEFAULT '0',
`exp` int(11) NOT NULL DEFAULT '0',
`gold` int(11) NOT NULL DEFAULT '0',
`stat_point` smallint(3) NOT NULL DEFAULT '0',
`skill_point` smallint(3) NOT NULL DEFAULT '0',
`quickslot` tinyblob,
`ip` varchar(15) DEFAULT '0.0.0.0',
`part_main` smallint(6) NOT NULL DEFAULT '0',
`part_base` tinyint(4) NOT NULL DEFAULT '0',
`part_hair` tinyint(4) NOT NULL DEFAULT '0',
`skill_group` tinyint(4) NOT NULL DEFAULT '0',
`skill_level` blob,
`alignment` int(11) NOT NULL DEFAULT '0',
`last_play` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`change_name` tinyint(1) NOT NULL DEFAULT '0',
`mobile` varchar(32) DEFAULT NULL,
`sub_skill_point` smallint(3) NOT NULL DEFAULT '0',
`stat_reset_count` tinyint(4) NOT NULL DEFAULT '0',
`horse_hp` smallint(4) NOT NULL DEFAULT '0',
`horse_stamina` smallint(4) NOT NULL DEFAULT '0',
`horse_level` tinyint(2) unsigned NOT NULL DEFAULT '0',
`horse_hp_droptime` int(10) unsigned NOT NULL DEFAULT '0',
`horse_riding` tinyint(1) NOT NULL DEFAULT '0',
`horse_skill_point` smallint(3) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `account_id_idx` (`account_id`),
KEY `name_idx` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=58014 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of player_deleted
-- ----------------------------