/*
Navicat Premium Data Transfer
Source Server : Windows-MySQL56
Source Server Type : MySQL
Source Server Version : 50651 (5.6.51-log)
Source Host : localhost:3306
Source Schema : player
Target Server Type : MySQL
Target Server Version : 50651 (5.6.51-log)
File Encoding : 65001
Date: 16/10/2024 00:16:30
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for player_deleted
-- ----------------------------
DROP TABLE IF EXISTS `player_deleted`;
CREATE TABLE `player_deleted` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`account_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
`name` varchar(24) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'NONAME',
`job` tinyint(2) UNSIGNED NOT NULL DEFAULT 0,
`voice` tinyint(1) 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` int(4) NOT NULL DEFAULT 0,
`mp` int(4) NOT NULL DEFAULT 0,
`stamina` smallint(6) NOT NULL DEFAULT 0,
`random_hp` smallint(5) NOT NULL DEFAULT 0,
`random_sp` smallint(5) 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 NULL,
`ip` varchar(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '0.0.0.0',
`part_main` mediumint(6) NOT NULL DEFAULT 0,
`part_base` tinyint(4) NOT NULL DEFAULT 0,
`part_hair` mediumint(4) NOT NULL DEFAULT 0,
`skill_group` tinyint(4) NOT NULL DEFAULT 0,
`skill_level` blob NULL,
`alignment` int(11) NOT NULL DEFAULT 0,
`last_play` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`change_name` tinyint(1) NOT NULL DEFAULT 0,
`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`) USING BTREE,
INDEX `account_id_idx`(`account_id`) USING BTREE,
INDEX `name_idx`(`name`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 10000 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
SET FOREIGN_KEY_CHECKS = 1;