· 8 years ago · Jul 18, 2018, 10:44 PM
1/*
2 Navicat Premium Data Transfer
3
4 Source Server : Hardcore
5 Source Server Type : MySQL
6 Source Server Version : 50634
7 Source Host : 51.254.23.249:3306
8 Source Schema : player
9
10 Target Server Type : MySQL
11 Target Server Version : 50634
12 File Encoding : 65001
13
14 Date: 19/07/2018 00:34:38
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for player_deleted
22-- ----------------------------
23DROP TABLE IF EXISTS `player_deleted`;
24CREATE TABLE `player_deleted` (
25 `id` int(11) NOT NULL AUTO_INCREMENT,
26 `account_id` int(11) NOT NULL DEFAULT 0,
27 `name` varchar(24) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'NONAME',
28 `job` tinyint(2) UNSIGNED NOT NULL DEFAULT 0,
29 `voice` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
30 `dir` tinyint(2) NOT NULL DEFAULT 0,
31 `x` int(11) NOT NULL DEFAULT 0,
32 `y` int(11) NOT NULL DEFAULT 0,
33 `z` int(11) NOT NULL DEFAULT 0,
34 `map_index` int(11) NOT NULL DEFAULT 0,
35 `exit_x` int(11) NOT NULL DEFAULT 0,
36 `exit_y` int(11) NOT NULL DEFAULT 0,
37 `exit_map_index` int(11) NOT NULL DEFAULT 0,
38 `hp` int(4) NOT NULL DEFAULT 0,
39 `mp` int(4) NOT NULL DEFAULT 0,
40 `stamina` int(6) NOT NULL DEFAULT 0,
41 `random_hp` int(5) UNSIGNED NOT NULL DEFAULT 0,
42 `random_sp` int(5) UNSIGNED NOT NULL DEFAULT 0,
43 `playtime` int(11) NOT NULL DEFAULT 0,
44 `level` int(3) UNSIGNED NOT NULL DEFAULT 1,
45 `level_step` tinyint(1) NOT NULL DEFAULT 0,
46 `st` int(3) NOT NULL DEFAULT 0,
47 `ht` int(3) NOT NULL DEFAULT 0,
48 `dx` int(3) NOT NULL DEFAULT 0,
49 `iq` int(3) NOT NULL DEFAULT 0,
50 `exp` int(11) NOT NULL DEFAULT 0,
51 `gold` bigint(20) NOT NULL DEFAULT 0,
52 `stat_point` int(3) NOT NULL DEFAULT 0,
53 `skill_point` int(3) NOT NULL DEFAULT 0,
54 `quickslot` tinyblob NULL,
55 `ip` varchar(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '0.0.0.0',
56 `part_main` mediumint(6) NOT NULL DEFAULT 0,
57 `part_base` tinyint(4) NOT NULL DEFAULT 0,
58 `part_hair` mediumint(4) NOT NULL DEFAULT 0,
59 `part_acce` int(4) UNSIGNED NOT NULL DEFAULT 0,
60 `skill_group` tinyint(4) NOT NULL DEFAULT 0,
61 `skill_level` blob NULL,
62 `alignment` int(11) NOT NULL DEFAULT 0,
63 `prestige` int(4) UNSIGNED NOT NULL DEFAULT 0,
64 `last_play` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
65 `change_name` tinyint(1) NOT NULL DEFAULT 0,
66 `mobile` varchar(24) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
67 `sub_skill_point` int(3) NOT NULL DEFAULT 0,
68 `stat_reset_count` tinyint(4) NOT NULL DEFAULT 0,
69 `horse_hp` int(4) NOT NULL DEFAULT 0,
70 `horse_stamina` int(4) NOT NULL DEFAULT 0,
71 `horse_level` tinyint(2) UNSIGNED NOT NULL DEFAULT 0,
72 `horse_hp_droptime` int(10) UNSIGNED NOT NULL DEFAULT 0,
73 `horse_riding` tinyint(1) NOT NULL DEFAULT 0,
74 `horse_skill_point` int(3) NOT NULL DEFAULT 0,
75 `bonus_costume` char(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
76 PRIMARY KEY (`id`) USING BTREE,
77 INDEX `account_id_idx`(`account_id`) USING BTREE,
78 INDEX `name_idx`(`name`) USING BTREE
79) ENGINE = MyISAM AUTO_INCREMENT = 6626 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
80
81-- ----------------------------
82-- Records of player_deleted
83-- ----------------------------