/*
Navicat MySQL Data Transfer
Source Server : MU
Source Server Type : MySQL
Source Server Version : 50743 (5.7.43-log)
Source Host : localhost:3306
Source Schema : muonline
Target Server Type : MySQL
Target Server Version : 50743 (5.7.43-log)
File Encoding : 65001
Date: 08/01/2024 15:37:35
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for account_buff
-- ----------------------------
DROP TABLE IF EXISTS `account_buff`;
CREATE TABLE `account_buff` (
`account_id` int(10) UNSIGNED NOT NULL,
`buff` smallint(5) UNSIGNED NOT NULL,
`effect_1` tinyint(3) UNSIGNED NOT NULL,
`value_1` int(11) NOT NULL,
`effect_2` tinyint(3) UNSIGNED NOT NULL,
`value_2` int(11) NOT NULL,
`effect_3` tinyint(3) UNSIGNED NOT NULL,
`value_3` int(11) NOT NULL,
`duration` bigint(20) NOT NULL,
`flags` tinyint(3) UNSIGNED NOT NULL,
PRIMARY KEY (`account_id`, `buff`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for account_cash_shop_gift
-- ----------------------------
DROP TABLE IF EXISTS `account_cash_shop_gift`;
CREATE TABLE `account_cash_shop_gift` (
`account_id` int(10) UNSIGNED NOT NULL,
`product` int(10) UNSIGNED NOT NULL,
`option` int(10) UNSIGNED NOT NULL,
`serial` int(10) UNSIGNED NOT NULL,
`serial_cash_shop` int(10) UNSIGNED NOT NULL,
`server` smallint(5) UNSIGNED NOT NULL,
`date` bigint(20) NOT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for account_cash_shop_item
-- ----------------------------
DROP TABLE IF EXISTS `account_cash_shop_item`;
CREATE TABLE `account_cash_shop_item` (
`account_id` int(10) UNSIGNED NOT NULL,
`product` int(10) UNSIGNED NOT NULL,
`option` int(10) UNSIGNED NOT NULL,
`serial` int(10) UNSIGNED NOT NULL,
`serial_cash_shop` int(10) UNSIGNED NOT NULL,
`server` smallint(5) UNSIGNED NOT NULL,
`gift` tinyint(3) UNSIGNED NOT NULL,
`date` bigint(20) NOT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for account_data
-- ----------------------------
DROP TABLE IF EXISTS `account_data`;
CREATE TABLE `account_data` (
`account_id` int(10) UNSIGNED NOT NULL,
`vip_status` int(11) NULL DEFAULT NULL,
`vip_duration` bigint(20) NULL DEFAULT NULL,
`expanded_warehouse` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`expanded_warehouse_time` bigint(20) NULL DEFAULT NULL,
`special_character` smallint(5) UNSIGNED NULL DEFAULT NULL,
`credits` int(10) UNSIGNED NULL DEFAULT NULL,
`web_credits` int(10) UNSIGNED NULL DEFAULT NULL,
`current_character` int(10) UNSIGNED NULL DEFAULT NULL,
`current_type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`current_ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`current_mac` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`current_diskserial` int(10) UNSIGNED NULL DEFAULT NULL,
`current_server` smallint(5) UNSIGNED NULL DEFAULT NULL,
`cash_shop_discount_wc` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`cash_shop_discount_gp` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`cash_shop_discount_date` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`account_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for account_warehouse
-- ----------------------------
DROP TABLE IF EXISTS `account_warehouse`;
CREATE TABLE `account_warehouse` (
`account_id` int(10) UNSIGNED NOT NULL,
`money` int(10) UNSIGNED NULL DEFAULT NULL,
`password` smallint(5) UNSIGNED NULL DEFAULT NULL,
`inventory` varbinary(55000) NULL DEFAULT NULL,
`gremory_case_acc` varbinary(10000) NULL DEFAULT NULL,
PRIMARY KEY (`account_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for accounts
-- ----------------------------
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
`guid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`blocked` tinyint(3) UNSIGNED NULL DEFAULT 0,
`security_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0',
`golden_channel` bigint(20) NULL DEFAULT 1500434821,
`facebook_status` tinyint(3) UNSIGNED NULL DEFAULT 0,
`secured` tinyint(3) UNSIGNED NULL DEFAULT 1,
`account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`register` bigint(20) NULL DEFAULT NULL,
`updated_at` datetime NULL DEFAULT NULL,
`created_at` datetime NULL DEFAULT NULL,
`email_verified_at` datetime NULL DEFAULT NULL,
PRIMARY KEY (`guid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for accounts_allowed
-- ----------------------------
DROP TABLE IF EXISTS `accounts_allowed`;
CREATE TABLE `accounts_allowed` (
`account_id` int(10) UNSIGNED NOT NULL,
`guid` int(10) UNSIGNED NULL DEFAULT NULL,
`server` smallint(5) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`account_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for accounts_banned
-- ----------------------------
DROP TABLE IF EXISTS `accounts_banned`;
CREATE TABLE `accounts_banned` (
`account_id` int(10) UNSIGNED NOT NULL,
`guid` int(10) UNSIGNED NULL DEFAULT NULL,
`unban_date` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`account_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for accounts_disconnect
-- ----------------------------
DROP TABLE IF EXISTS `accounts_disconnect`;
CREATE TABLE `accounts_disconnect` (
`account_id` int(10) UNSIGNED NOT NULL,
`server` smallint(5) UNSIGNED NULL DEFAULT NULL,
`masive` tinyint(4) NULL DEFAULT NULL,
PRIMARY KEY (`account_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for accounts_security
-- ----------------------------
DROP TABLE IF EXISTS `accounts_security`;
CREATE TABLE `accounts_security` (
`account_id` int(10) UNSIGNED NOT NULL,
`account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`mac` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`disk_serial` int(10) UNSIGNED NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for accounts_status
-- ----------------------------
DROP TABLE IF EXISTS `accounts_status`;
CREATE TABLE `accounts_status` (
`account_id` int(10) UNSIGNED NOT NULL,
`server_group` smallint(5) UNSIGNED NULL DEFAULT NULL,
`current_server` smallint(5) UNSIGNED NULL DEFAULT NULL,
`start_server` smallint(5) UNSIGNED NULL DEFAULT NULL,
`dest_server` smallint(6) NULL DEFAULT NULL,
`dest_world` smallint(6) NULL DEFAULT NULL,
`dest_x` smallint(6) NULL DEFAULT NULL,
`dest_y` smallint(6) NULL DEFAULT NULL,
`warp_time` int(10) UNSIGNED NULL DEFAULT NULL,
`warp_auth_1` int(10) UNSIGNED NULL DEFAULT NULL,
`warp_auth_2` int(10) UNSIGNED NULL DEFAULT NULL,
`warp_auth_3` int(10) UNSIGNED NULL DEFAULT NULL,
`warp_auth_4` int(10) UNSIGNED NULL DEFAULT NULL,
`last_ip` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NULL DEFAULT NULL,
`last_mac` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NULL DEFAULT NULL,
`last_online` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NULL DEFAULT NULL,
`online` tinyint(4) NULL DEFAULT NULL,
`disk_serial` int(10) UNSIGNED NULL DEFAULT NULL,
`type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`account_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for accounts_validation
-- ----------------------------
DROP TABLE IF EXISTS `accounts_validation`;
CREATE TABLE `accounts_validation` (
`account_id` int(10) UNSIGNED NOT NULL,
`disk_serial` int(10) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`account_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for accounts_warning
-- ----------------------------
DROP TABLE IF EXISTS `accounts_warning`;
CREATE TABLE `accounts_warning` (
`account_id` int(10) UNSIGNED NOT NULL,
`disk_serial` int(10) UNSIGNED NULL DEFAULT NULL,
`block_date` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`account_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for arka_war_data
-- ----------------------------
DROP TABLE IF EXISTS `arka_war_data`;
CREATE TABLE `arka_war_data` (
`id` tinyint(3) UNSIGNED NOT NULL,
`guild` int(10) UNSIGNED NOT NULL,
`attribute` tinyint(3) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`id`, `guild`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for block_diskserial
-- ----------------------------
DROP TABLE IF EXISTS `block_diskserial`;
CREATE TABLE `block_diskserial` (
`disk_serial` int(10) UNSIGNED NOT NULL,
`comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`disk_serial`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for block_ip
-- ----------------------------
DROP TABLE IF EXISTS `block_ip`;
CREATE TABLE `block_ip` (
`ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`ip`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for block_mac
-- ----------------------------
DROP TABLE IF EXISTS `block_mac`;
CREATE TABLE `block_mac` (
`mac` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`mac`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for castle_siege_data
-- ----------------------------
DROP TABLE IF EXISTS `castle_siege_data`;
CREATE TABLE `castle_siege_data` (
`owner` int(10) UNSIGNED NOT NULL,
`status` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`tax_hunt` int(11) NULL DEFAULT NULL,
`tax_chaos` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`tax_store` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`hunt_allowed` tinyint(4) NULL DEFAULT NULL,
`money` bigint(20) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`owner`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for castle_siege_guild
-- ----------------------------
DROP TABLE IF EXISTS `castle_siege_guild`;
CREATE TABLE `castle_siege_guild` (
`guild` int(10) UNSIGNED NOT NULL,
`side` tinyint(3) UNSIGNED NOT NULL,
`score` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`guild`, `side`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for castle_siege_npc
-- ----------------------------
DROP TABLE IF EXISTS `castle_siege_npc`;
CREATE TABLE `castle_siege_npc` (
`uid` bigint(20) NOT NULL AUTO_INCREMENT,
`id` smallint(6) NULL DEFAULT NULL,
`defense_level` smallint(6) NULL DEFAULT NULL,
`regen_level` smallint(6) NULL DEFAULT NULL,
`life_level` smallint(6) NULL DEFAULT NULL,
`life` int(11) NULL DEFAULT NULL,
`npc` smallint(6) NULL DEFAULT NULL,
PRIMARY KEY (`uid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27959 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for castle_siege_registered_guild
-- ----------------------------
DROP TABLE IF EXISTS `castle_siege_registered_guild`;
CREATE TABLE `castle_siege_registered_guild` (
`guild` int(10) UNSIGNED NOT NULL,
`marks` int(10) UNSIGNED NULL DEFAULT NULL,
`register_id` int(10) UNSIGNED NULL DEFAULT NULL,
`level` smallint(5) UNSIGNED NULL DEFAULT NULL,
`level_master` smallint(5) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`guild`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for chaos_castle_survival_hall_of_fame
-- ----------------------------
DROP TABLE IF EXISTS `chaos_castle_survival_hall_of_fame`;
CREATE TABLE `chaos_castle_survival_hall_of_fame` (
`char_id` int(10) UNSIGNED NOT NULL,
`char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`score` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for chaos_castle_survival_ranking
-- ----------------------------
DROP TABLE IF EXISTS `chaos_castle_survival_ranking`;
CREATE TABLE `chaos_castle_survival_ranking` (
`char_id` int(10) UNSIGNED NOT NULL,
`score` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_add_stat
-- ----------------------------
DROP TABLE IF EXISTS `character_add_stat`;
CREATE TABLE `character_add_stat` (
`GUID` int(11) NULL DEFAULT NULL,
`Strenght` int(11) NOT NULL DEFAULT 0,
`Agility` int(11) NOT NULL DEFAULT 0,
`Vitality` int(11) NOT NULL DEFAULT 0,
`Energy` int(11) NOT NULL DEFAULT 0,
`Leadership` int(11) NOT NULL DEFAULT 0
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_buff
-- ----------------------------
DROP TABLE IF EXISTS `character_buff`;
CREATE TABLE `character_buff` (
`char_id` int(10) UNSIGNED NOT NULL,
`buff` smallint(5) UNSIGNED NOT NULL,
`effect_1` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`value_1` int(11) NULL DEFAULT NULL,
`effect_2` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`value_2` int(11) NULL DEFAULT NULL,
`effect_3` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`value_3` int(11) NULL DEFAULT NULL,
`duration` bigint(20) NULL DEFAULT NULL,
`flags` tinyint(3) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`char_id`, `buff`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_chat_block
-- ----------------------------
DROP TABLE IF EXISTS `character_chat_block`;
CREATE TABLE `character_chat_block` (
`char_id` int(10) UNSIGNED NOT NULL,
`blocked` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_date
-- ----------------------------
DROP TABLE IF EXISTS `character_date`;
CREATE TABLE `character_date` (
`char_id` int(10) UNSIGNED NOT NULL,
`id` int(10) UNSIGNED NOT NULL,
`date` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`, `id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_deleted
-- ----------------------------
DROP TABLE IF EXISTS `character_deleted`;
CREATE TABLE `character_deleted` (
`account_id` int(10) UNSIGNED NOT NULL,
`char_id` int(10) UNSIGNED NOT NULL,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`account_id`, `char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_event_count
-- ----------------------------
DROP TABLE IF EXISTS `character_event_count`;
CREATE TABLE `character_event_count` (
`char_id` int(10) UNSIGNED NOT NULL,
`event_id` tinyint(3) UNSIGNED NOT NULL,
`count` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`day` tinyint(3) UNSIGNED NOT NULL,
PRIMARY KEY (`char_id`, `event_id`, `day`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_friend
-- ----------------------------
DROP TABLE IF EXISTS `character_friend`;
CREATE TABLE `character_friend` (
`char_id` int(10) UNSIGNED NOT NULL,
`friend_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`char_id`, `friend_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_gameoption
-- ----------------------------
DROP TABLE IF EXISTS `character_gameoption`;
CREATE TABLE `character_gameoption` (
`char_id` int(10) UNSIGNED NOT NULL,
`game_option` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`chat_window` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`q_key` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`w_key` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`e_key` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`r_key` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`qwer_level` int(11) NULL DEFAULT NULL,
`skill_bind_0` smallint(5) UNSIGNED NULL DEFAULT NULL,
`skill_bind_1` smallint(5) UNSIGNED NULL DEFAULT NULL,
`skill_bind_2` smallint(5) UNSIGNED NULL DEFAULT NULL,
`skill_bind_3` smallint(5) UNSIGNED NULL DEFAULT NULL,
`skill_bind_4` smallint(5) UNSIGNED NULL DEFAULT NULL,
`skill_bind_5` smallint(5) UNSIGNED NULL DEFAULT NULL,
`skill_bind_6` smallint(5) UNSIGNED NULL DEFAULT NULL,
`skill_bind_7` smallint(5) UNSIGNED NULL DEFAULT NULL,
`skill_bind_8` smallint(5) UNSIGNED NULL DEFAULT NULL,
`skill_bind_9` smallint(5) UNSIGNED NULL DEFAULT NULL,
`extra_data` bigint(20) UNSIGNED NULL DEFAULT NULL,
`change_skin` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`additional_options` smallint(5) UNSIGNED NULL DEFAULT NULL,
`button_bind_1` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`button_bind_2` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`button_bind_3` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`button_bind_4` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`button_bind_5` tinyint(3) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_gens
-- ----------------------------
DROP TABLE IF EXISTS `character_gens`;
CREATE TABLE `character_gens` (
`char_id` int(10) UNSIGNED NOT NULL,
`family` tinyint(3) UNSIGNED NOT NULL,
`level` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`contribution` int(11) NULL DEFAULT NULL,
`reward_date` bigint(20) NULL DEFAULT NULL,
`join_date` bigint(20) NULL DEFAULT NULL,
`left_date` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`, `family`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_gens_kill
-- ----------------------------
DROP TABLE IF EXISTS `character_gens_kill`;
CREATE TABLE `character_gens_kill` (
`char_id` int(10) UNSIGNED NULL DEFAULT NULL,
`killed_id` int(10) UNSIGNED NULL DEFAULT NULL,
`count` int(10) UNSIGNED NULL DEFAULT NULL,
`date` bigint(20) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_gremory_case
-- ----------------------------
DROP TABLE IF EXISTS `character_gremory_case`;
CREATE TABLE `character_gremory_case` (
`guid` int(11) NOT NULL,
`gremory_case_char` varbinary(20000) NULL DEFAULT NULL,
`gremory_case_mobile` varbinary(20000) NULL DEFAULT NULL,
`gremory_case_ps` varbinary(20000) NULL DEFAULT NULL,
PRIMARY KEY (`guid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_helper
-- ----------------------------
DROP TABLE IF EXISTS `character_helper`;
CREATE TABLE `character_helper` (
`char_id` int(10) UNSIGNED NOT NULL,
`option_flag_1` int(10) UNSIGNED NULL DEFAULT NULL,
`option_flag_2` int(10) UNSIGNED NULL DEFAULT NULL,
`item_pick_flag` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`hunting_range` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`item_pick_range` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`distance` smallint(5) UNSIGNED NULL DEFAULT NULL,
`attack_skill_1` smallint(5) UNSIGNED NULL DEFAULT NULL,
`attack_sec_skill_1` smallint(5) UNSIGNED NULL DEFAULT NULL,
`attack_sec_skill_2` smallint(5) UNSIGNED NULL DEFAULT NULL,
`attack_sec_delay_1` smallint(5) UNSIGNED NULL DEFAULT NULL,
`attack_sec_delay_2` smallint(5) UNSIGNED NULL DEFAULT NULL,
`buff_skill_1` smallint(5) UNSIGNED NULL DEFAULT NULL,
`buff_skill_2` smallint(5) UNSIGNED NULL DEFAULT NULL,
`buff_skill_3` smallint(5) UNSIGNED NULL DEFAULT NULL,
`time_space_casting` smallint(5) UNSIGNED NULL DEFAULT NULL,
`percent_autopot` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`percent_autoheal` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`percent_partyheal` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`percent_drainlife` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`item_list` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`buff_item_1` smallint(5) UNSIGNED NULL DEFAULT NULL,
`buff_item_2` smallint(5) UNSIGNED NULL DEFAULT NULL,
`buff_item_3` smallint(5) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_hunting_record
-- ----------------------------
DROP TABLE IF EXISTS `character_hunting_record`;
CREATE TABLE `character_hunting_record` (
`char_id` int(10) UNSIGNED NOT NULL,
`world` smallint(5) UNSIGNED NOT NULL,
`year` smallint(5) UNSIGNED NULL DEFAULT NULL,
`month` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`day` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`level` int(10) UNSIGNED NULL DEFAULT NULL,
`duration` int(10) UNSIGNED NULL DEFAULT NULL,
`damage` bigint(20) UNSIGNED NULL DEFAULT NULL,
`elemental_damage` bigint(20) UNSIGNED NULL DEFAULT NULL,
`healing` int(10) UNSIGNED NULL DEFAULT NULL,
`killed_count` int(10) UNSIGNED NULL DEFAULT NULL,
`earned_experience` bigint(20) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`char_id`, `world`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_info
-- ----------------------------
DROP TABLE IF EXISTS `character_info`;
CREATE TABLE `character_info` (
`guid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`account_id` int(10) UNSIGNED NULL DEFAULT NULL,
`authority` tinyint(3) UNSIGNED NULL DEFAULT 0,
`race` smallint(3) UNSIGNED NULL DEFAULT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`slot` tinyint(4) NULL DEFAULT 1,
`level` smallint(6) NULL DEFAULT 0,
`level_master` smallint(6) NULL DEFAULT 0,
`level_majestic` smallint(6) NULL DEFAULT 0,
`experience` bigint(20) NULL DEFAULT 0,
`experience_master` bigint(20) NULL DEFAULT 0,
`experience_majestic` bigint(20) NULL DEFAULT 0,
`points` int(11) NULL DEFAULT 0,
`points_master` int(11) NULL DEFAULT 0,
`points_majestic` int(11) NULL DEFAULT 0,
`strength` int(10) UNSIGNED NULL DEFAULT 0,
`agility` int(10) UNSIGNED NULL DEFAULT 0,
`vitality` int(10) UNSIGNED NULL DEFAULT 0,
`energy` int(10) UNSIGNED NULL DEFAULT 0,
`leadership` int(10) UNSIGNED NULL DEFAULT 0,
`world` smallint(5) UNSIGNED NULL DEFAULT 0,
`world_x` smallint(6) NULL DEFAULT 0,
`world_y` smallint(6) NULL DEFAULT 0,
`direction` tinyint(3) UNSIGNED NULL DEFAULT 0,
`money` int(10) UNSIGNED NULL DEFAULT 0,
`life` int(11) NULL DEFAULT 0,
`mana` int(11) NULL DEFAULT 0,
`shield` int(11) NULL DEFAULT 0,
`stamina` int(11) NULL DEFAULT 0,
`add_fruit_points` int(11) NULL DEFAULT 0,
`dec_fruit_points` int(11) NULL DEFAULT 0,
`expanded_inventory` tinyint(3) UNSIGNED NULL DEFAULT 0,
`mute_time` bigint(20) NULL DEFAULT 0,
`admin_flags` int(10) UNSIGNED NULL DEFAULT 0,
`pk_level` tinyint(3) UNSIGNED NULL DEFAULT 3,
`pk_count` int(11) NULL DEFAULT 0,
`pk_points` int(11) NULL DEFAULT 0,
`first_time` tinyint(3) UNSIGNED NULL DEFAULT 1,
`santa_claus_gift` bigint(20) NULL DEFAULT 0,
`personal_store_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0',
`personal_store_open` tinyint(4) NULL DEFAULT 0,
`goblin_points` int(10) UNSIGNED NULL DEFAULT 0,
`last_use` bigint(20) NULL DEFAULT 0,
`kick_time` bigint(20) NULL DEFAULT 0,
`post_count` int(11) NULL DEFAULT 0,
`post_day` tinyint(3) UNSIGNED NULL DEFAULT 0,
`post_month` tinyint(3) UNSIGNED NULL DEFAULT 0,
`ruud_money` int(10) UNSIGNED NULL DEFAULT 0,
`hunting_log_visible` tinyint(3) UNSIGNED NULL DEFAULT 0,
`create_date` bigint(20) NULL DEFAULT 0,
`online` tinyint(4) NULL DEFAULT 0,
`server_code` smallint(5) UNSIGNED NULL DEFAULT 3,
`reset` int(10) UNSIGNED NULL DEFAULT 0,
`monster_soul_purchase` int(11) NULL DEFAULT 0,
PRIMARY KEY (`guid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 78 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_item_delay
-- ----------------------------
DROP TABLE IF EXISTS `character_item_delay`;
CREATE TABLE `character_item_delay` (
`char_id` int(10) UNSIGNED NULL DEFAULT NULL,
`item` smallint(5) UNSIGNED NULL DEFAULT NULL,
`date` bigint(20) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_item_inventory
-- ----------------------------
DROP TABLE IF EXISTS `character_item_inventory`;
CREATE TABLE `character_item_inventory` (
`GUID` int(11) NOT NULL,
`InventoryData` varbinary(65525) NULL DEFAULT NULL,
PRIMARY KEY (`GUID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_item_pentagram
-- ----------------------------
DROP TABLE IF EXISTS `character_item_pentagram`;
CREATE TABLE `character_item_pentagram` (
`GUID` int(11) NOT NULL,
`PentagramInventoryData` varbinary(65525) NULL DEFAULT NULL,
`INV_TYPE` smallint(6) NULL DEFAULT 0,
PRIMARY KEY (`GUID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_jewel_bingo
-- ----------------------------
DROP TABLE IF EXISTS `character_jewel_bingo`;
CREATE TABLE `character_jewel_bingo` (
`char_id` int(10) UNSIGNED NOT NULL,
`state` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`box` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`count` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`jewel` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`score1` int(11) NULL DEFAULT NULL,
`score2` int(11) NULL DEFAULT NULL,
`score3` int(11) NULL DEFAULT NULL,
`date` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_jewel_bingo_grid
-- ----------------------------
DROP TABLE IF EXISTS `character_jewel_bingo_grid`;
CREATE TABLE `character_jewel_bingo_grid` (
`char_id` int(10) UNSIGNED NOT NULL,
`type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`slot` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`value` tinyint(3) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_kick
-- ----------------------------
DROP TABLE IF EXISTS `character_kick`;
CREATE TABLE `character_kick` (
`char_id` int(10) UNSIGNED NOT NULL,
`character_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_labyrinth
-- ----------------------------
DROP TABLE IF EXISTS `character_labyrinth`;
CREATE TABLE `character_labyrinth` (
`char_id` int(10) UNSIGNED NOT NULL,
`stage` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`id` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`level` smallint(5) UNSIGNED NULL DEFAULT NULL,
`status` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`killed_monsters` int(11) NULL DEFAULT NULL,
`earned_experience` bigint(20) NULL DEFAULT NULL,
`completed_missions` int(11) NULL DEFAULT NULL,
`date` bigint(20) NULL DEFAULT NULL,
`goblin_state` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`day_first` tinyint(3) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_labyrinth_level
-- ----------------------------
DROP TABLE IF EXISTS `character_labyrinth_level`;
CREATE TABLE `character_labyrinth_level` (
`char_id` int(10) UNSIGNED NOT NULL,
`level` smallint(5) UNSIGNED NULL DEFAULT NULL,
`amount` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_labyrinth_zone
-- ----------------------------
DROP TABLE IF EXISTS `character_labyrinth_zone`;
CREATE TABLE `character_labyrinth_zone` (
`char_id` int(10) UNSIGNED NOT NULL,
`idx` tinyint(3) UNSIGNED NOT NULL,
`subidx` tinyint(3) UNSIGNED NOT NULL,
`mission_id_1` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`mission_id_2` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`mission_id_3` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`mission_id_4` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`mission_id_5` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`mission_count_1` int(11) NULL DEFAULT NULL,
`mission_count_2` int(11) NULL DEFAULT NULL,
`mission_count_3` int(11) NULL DEFAULT NULL,
`mission_count_4` int(11) NULL DEFAULT NULL,
`mission_count_5` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`, `idx`, `subidx`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_mail
-- ----------------------------
DROP TABLE IF EXISTS `character_mail`;
CREATE TABLE `character_mail` (
`id` int(10) UNSIGNED NOT NULL,
`char_id` int(10) UNSIGNED NULL DEFAULT NULL,
`from_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`subject` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`message` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`direction` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`action` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`window_guid` int(10) UNSIGNED NULL DEFAULT NULL,
`date` bigint(20) NULL DEFAULT NULL,
`opened` tinyint(3) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_majestic_stats
-- ----------------------------
DROP TABLE IF EXISTS `character_majestic_stats`;
CREATE TABLE `character_majestic_stats` (
`char_id` int(10) UNSIGNED NOT NULL,
`id` tinyint(3) UNSIGNED NOT NULL,
`level` smallint(5) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`char_id`, `id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_majestic_tree
-- ----------------------------
DROP TABLE IF EXISTS `character_majestic_tree`;
CREATE TABLE `character_majestic_tree` (
`char_id` int(10) UNSIGNED NOT NULL,
`type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`section` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`id` smallint(5) UNSIGNED NOT NULL,
`level` tinyint(3) UNSIGNED NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_mini_bomb
-- ----------------------------
DROP TABLE IF EXISTS `character_mini_bomb`;
CREATE TABLE `character_mini_bomb` (
`char_id` int(10) UNSIGNED NOT NULL,
`state` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`score` smallint(5) UNSIGNED NULL DEFAULT NULL,
`total_score` int(11) NULL DEFAULT NULL,
`cdate` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_mini_bomb_grid
-- ----------------------------
DROP TABLE IF EXISTS `character_mini_bomb_grid`;
CREATE TABLE `character_mini_bomb_grid` (
`char_id` int(10) UNSIGNED NOT NULL,
`cell` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`value` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`status` tinyint(3) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_monster_soul
-- ----------------------------
DROP TABLE IF EXISTS `character_monster_soul`;
CREATE TABLE `character_monster_soul` (
`char_id` int(10) UNSIGNED NOT NULL,
`type` int(10) UNSIGNED NULL DEFAULT NULL,
`id` int(10) UNSIGNED NOT NULL,
`amount` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`, `id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_mu_roomy
-- ----------------------------
DROP TABLE IF EXISTS `character_mu_roomy`;
CREATE TABLE `character_mu_roomy` (
`char_id` int(10) UNSIGNED NOT NULL,
`playing` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`score` smallint(5) UNSIGNED NULL DEFAULT NULL,
`card_count` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`special_card_count` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`date` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_mu_roomy_deck
-- ----------------------------
DROP TABLE IF EXISTS `character_mu_roomy_deck`;
CREATE TABLE `character_mu_roomy_deck` (
`char_id` int(10) UNSIGNED NULL DEFAULT NULL,
`type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`slot` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`color` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`number` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`state` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`play_slot` tinyint(3) UNSIGNED NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_mupass
-- ----------------------------
DROP TABLE IF EXISTS `character_mupass`;
CREATE TABLE `character_mupass` (
`guid` bigint(20) NOT NULL AUTO_INCREMENT,
`character_id` bigint(20) NULL DEFAULT NULL,
`pass_level` int(11) NULL DEFAULT NULL,
`pass_exp` bigint(20) NULL DEFAULT NULL,
`gold_enabled` tinyint(1) NULL DEFAULT NULL,
`premiun_enabled` tinyint(1) NULL DEFAULT NULL,
`MuRevardEnabled` tinyint(1) NULL DEFAULT NULL,
`MuRevardGoldEnabled` tinyint(1) NULL DEFAULT NULL,
`MuRevardPremiumEnabled` tinyint(1) NULL DEFAULT NULL,
`TodayMuPassExp` int(11) NULL DEFAULT NULL,
`pass_data` varbinary(30000) NULL DEFAULT NULL,
`pass_reward_data` varbinary(30000) NULL DEFAULT NULL,
PRIMARY KEY (`guid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 54430 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_notification
-- ----------------------------
DROP TABLE IF EXISTS `character_notification`;
CREATE TABLE `character_notification` (
`server_group` smallint(5) UNSIGNED NOT NULL,
`char_name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`facebook_id` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`notification_id` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`notification_data` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`server_group`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_numeric_baseball
-- ----------------------------
DROP TABLE IF EXISTS `character_numeric_baseball`;
CREATE TABLE `character_numeric_baseball` (
`char_id` int(10) UNSIGNED NOT NULL,
`state` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`score` int(11) NULL DEFAULT NULL,
`number_1` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`number_2` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`number_3` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`numbers` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`strikes` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`balls` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_quest_evo
-- ----------------------------
DROP TABLE IF EXISTS `character_quest_evo`;
CREATE TABLE `character_quest_evo` (
`char_id` int(10) UNSIGNED NOT NULL,
`id` tinyint(3) UNSIGNED NOT NULL,
`state` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`kill_count_1` int(11) NULL DEFAULT NULL,
`kill_count_2` int(11) NULL DEFAULT NULL,
`kill_count_3` int(11) NULL DEFAULT NULL,
`kill_count_4` int(11) NULL DEFAULT NULL,
`kill_count_5` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`, `id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_quest_guided
-- ----------------------------
DROP TABLE IF EXISTS `character_quest_guided`;
CREATE TABLE `character_quest_guided` (
`char_id` int(10) UNSIGNED NOT NULL,
`quest` smallint(5) UNSIGNED NOT NULL,
`count` int(11) NULL DEFAULT NULL,
`state` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`date` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`, `quest`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_quest_mu
-- ----------------------------
DROP TABLE IF EXISTS `character_quest_mu`;
CREATE TABLE `character_quest_mu` (
`char_id` int(10) UNSIGNED NOT NULL,
`quest_id` smallint(5) UNSIGNED NOT NULL,
`state` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`objective` smallint(5) UNSIGNED NULL DEFAULT NULL,
`date` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`, `quest_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_restriction
-- ----------------------------
DROP TABLE IF EXISTS `character_restriction`;
CREATE TABLE `character_restriction` (
`char_id` int(10) UNSIGNED NOT NULL,
`restriction` int(10) UNSIGNED NULL DEFAULT NULL,
`time` bigint(20) NULL DEFAULT NULL,
`admin_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_score
-- ----------------------------
DROP TABLE IF EXISTS `character_score`;
CREATE TABLE `character_score` (
`char_id` int(10) UNSIGNED NOT NULL,
`type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`level` int(11) NULL DEFAULT NULL,
`score` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_skill
-- ----------------------------
DROP TABLE IF EXISTS `character_skill`;
CREATE TABLE `character_skill` (
`char_id` int(10) UNSIGNED NOT NULL,
`type` tinyint(3) UNSIGNED NOT NULL,
`skill` smallint(5) UNSIGNED NOT NULL,
`skill_level` tinyint(3) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`char_id`, `type`, `skill`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_statistics
-- ----------------------------
DROP TABLE IF EXISTS `character_statistics`;
CREATE TABLE `character_statistics` (
`char_id` int(10) UNSIGNED NOT NULL,
`statistic_id` int(10) UNSIGNED NOT NULL,
`count` bigint(20) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`char_id`, `statistic_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for character_warp_favorite_list
-- ----------------------------
DROP TABLE IF EXISTS `character_warp_favorite_list`;
CREATE TABLE `character_warp_favorite_list` (
`char_id` int(10) UNSIGNED NOT NULL,
`slot` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`data` smallint(5) UNSIGNED NULL DEFAULT NULL,
`warp_id` smallint(5) UNSIGNED NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for crywolf_data
-- ----------------------------
DROP TABLE IF EXISTS `crywolf_data`;
CREATE TABLE `crywolf_data` (
`state` tinyint(3) UNSIGNED NOT NULL,
PRIMARY KEY (`state`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for event_arka_war_kill
-- ----------------------------
DROP TABLE IF EXISTS `event_arka_war_kill`;
CREATE TABLE `event_arka_war_kill` (
`char_id` int(10) UNSIGNED NULL DEFAULT NULL,
`char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`char_rank` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`player_data_01` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`guild_id_01` int(10) UNSIGNED NULL DEFAULT NULL,
`guild_name_01` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`killer_id` int(10) UNSIGNED NULL DEFAULT NULL,
`killer_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`killer_rank` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`player_data_02` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`guild_id_02` int(10) UNSIGNED NULL DEFAULT NULL,
`guild_name_02` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`world` smallint(5) UNSIGNED NULL DEFAULT NULL,
`world_x` smallint(6) NULL DEFAULT NULL,
`world_y` smallint(6) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for event_arka_war_ranking
-- ----------------------------
DROP TABLE IF EXISTS `event_arka_war_ranking`;
CREATE TABLE `event_arka_war_ranking` (
`guild_id_01` int(10) UNSIGNED NULL DEFAULT NULL,
`guild_name_01` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`guild_id_02` int(10) UNSIGNED NULL DEFAULT NULL,
`guild_name_02` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`character_count` int(11) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for event_castle_siege_kill
-- ----------------------------
DROP TABLE IF EXISTS `event_castle_siege_kill`;
CREATE TABLE `event_castle_siege_kill` (
`char_id` int(10) UNSIGNED NULL DEFAULT NULL,
`char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`char_rank` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`state` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`player_data_01` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`guild_id_01` int(10) UNSIGNED NULL DEFAULT NULL,
`guild_name_01` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`killer_id` int(10) UNSIGNED NULL DEFAULT NULL,
`killer_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`killer_rank` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`player_data_02` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`guild_id_02` int(10) UNSIGNED NULL DEFAULT NULL,
`guild_name_02` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`world` smallint(5) UNSIGNED NULL DEFAULT NULL,
`world_x` smallint(6) NULL DEFAULT NULL,
`world_y` smallint(6) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for event_castle_siege_ranking
-- ----------------------------
DROP TABLE IF EXISTS `event_castle_siege_ranking`;
CREATE TABLE `event_castle_siege_ranking` (
`guild_id` int(10) UNSIGNED NOT NULL,
`guild_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`character_count` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`guild_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for event_castle_siege_time
-- ----------------------------
DROP TABLE IF EXISTS `event_castle_siege_time`;
CREATE TABLE `event_castle_siege_time` (
`char_id` int(10) UNSIGNED NULL DEFAULT NULL,
`char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`char_rank` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`player_data` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`guild_id` int(10) UNSIGNED NULL DEFAULT NULL,
`guild_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`time` int(10) UNSIGNED NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for event_dungeon_instance
-- ----------------------------
DROP TABLE IF EXISTS `event_dungeon_instance`;
CREATE TABLE `event_dungeon_instance` (
`char_id` int(10) UNSIGNED NOT NULL,
`id` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`time` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for event_jewel_bingo_ranking
-- ----------------------------
DROP TABLE IF EXISTS `event_jewel_bingo_ranking`;
CREATE TABLE `event_jewel_bingo_ranking` (
`char_id` int(10) UNSIGNED NOT NULL,
`type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`score1` int(11) NULL DEFAULT NULL,
`score2` int(11) NULL DEFAULT NULL,
`score3` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for event_labyrinth_league
-- ----------------------------
DROP TABLE IF EXISTS `event_labyrinth_league`;
CREATE TABLE `event_labyrinth_league` (
`category` tinyint(3) UNSIGNED NOT NULL,
`char_id` int(10) UNSIGNED NOT NULL,
`char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`char_class` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`score` int(11) NULL DEFAULT NULL,
`league_score` int(11) NULL DEFAULT NULL,
`time` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`, `category`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for event_labyrinth_schedule
-- ----------------------------
DROP TABLE IF EXISTS `event_labyrinth_schedule`;
CREATE TABLE `event_labyrinth_schedule` (
`server` smallint(5) UNSIGNED NOT NULL,
`state` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`start_date` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`server`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for event_mini_bomb_ranking
-- ----------------------------
DROP TABLE IF EXISTS `event_mini_bomb_ranking`;
CREATE TABLE `event_mini_bomb_ranking` (
`char_id` int(10) UNSIGNED NOT NULL,
`state` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`score` smallint(5) UNSIGNED NULL DEFAULT NULL,
`bombs_founded` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`bombs_failed` tinyint(3) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for event_mu_roomy_ranking
-- ----------------------------
DROP TABLE IF EXISTS `event_mu_roomy_ranking`;
CREATE TABLE `event_mu_roomy_ranking` (
`char_id` int(10) UNSIGNED NOT NULL,
`type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`score` smallint(5) UNSIGNED NULL DEFAULT NULL,
`remain_card` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`remain_special_card` tinyint(3) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for event_numeric_baseball_ranking
-- ----------------------------
DROP TABLE IF EXISTS `event_numeric_baseball_ranking`;
CREATE TABLE `event_numeric_baseball_ranking` (
`char_id` int(10) UNSIGNED NOT NULL,
`score` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for event_race_ranking
-- ----------------------------
DROP TABLE IF EXISTS `event_race_ranking`;
CREATE TABLE `event_race_ranking` (
`char_id` int(10) UNSIGNED NOT NULL,
`race` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`start` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`char_id`, `race`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for event_ranking
-- ----------------------------
DROP TABLE IF EXISTS `event_ranking`;
CREATE TABLE `event_ranking` (
`event_id` tinyint(3) UNSIGNED NOT NULL,
`event_ground` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`char_id` int(10) UNSIGNED NOT NULL,
`score` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`event_id`, `char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for event_ranking_labyrinth
-- ----------------------------
DROP TABLE IF EXISTS `event_ranking_labyrinth`;
CREATE TABLE `event_ranking_labyrinth` (
`char_id` int(10) UNSIGNED NOT NULL,
`level` smallint(5) UNSIGNED NULL DEFAULT NULL,
`stage` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`index` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`killed_monsters` int(11) NULL DEFAULT NULL,
`earned_experience` bigint(20) NULL DEFAULT NULL,
`completed_missions` int(11) NULL DEFAULT NULL,
`score` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for event_scramble_ranking
-- ----------------------------
DROP TABLE IF EXISTS `event_scramble_ranking`;
CREATE TABLE `event_scramble_ranking` (
`char_id` int(10) UNSIGNED NOT NULL,
`word` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`shuffle_word` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for event_stage
-- ----------------------------
DROP TABLE IF EXISTS `event_stage`;
CREATE TABLE `event_stage` (
`event_id` tinyint(3) UNSIGNED NOT NULL,
`stage` tinyint(3) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`event_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for gen_ranking
-- ----------------------------
DROP TABLE IF EXISTS `gen_ranking`;
CREATE TABLE `gen_ranking` (
`family` tinyint(3) UNSIGNED NOT NULL,
`level` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`score` int(11) NULL DEFAULT NULL,
`ranking` int(11) NULL DEFAULT NULL,
`char_id` int(10) UNSIGNED NOT NULL,
PRIMARY KEY (`family`, `char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for giant_mount_settings
-- ----------------------------
DROP TABLE IF EXISTS `giant_mount_settings`;
CREATE TABLE `giant_mount_settings` (
`character_id` bigint(20) NOT NULL,
`giant_model` smallint(6) NOT NULL,
`giant_status` smallint(6) NOT NULL,
PRIMARY KEY (`character_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for guild_list
-- ----------------------------
DROP TABLE IF EXISTS `guild_list`;
CREATE TABLE `guild_list` (
`guid` int(10) UNSIGNED NOT NULL,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`emblem` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`hostil` int(10) UNSIGNED NULL DEFAULT NULL,
`alliance` int(10) UNSIGNED NULL DEFAULT NULL,
`notice` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`score` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`guid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for guild_matching
-- ----------------------------
DROP TABLE IF EXISTS `guild_matching`;
CREATE TABLE `guild_matching` (
`guild_id` int(10) UNSIGNED NOT NULL,
`text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`interest_type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`level_range` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`class_type` smallint(5) UNSIGNED NULL DEFAULT NULL,
`board_number` int(10) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`guild_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for guild_members
-- ----------------------------
DROP TABLE IF EXISTS `guild_members`;
CREATE TABLE `guild_members` (
`guild_id` int(10) UNSIGNED NOT NULL,
`char_id` int(10) UNSIGNED NOT NULL,
`id` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`ranking` tinyint(3) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`guild_id`, `char_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for guild_score
-- ----------------------------
DROP TABLE IF EXISTS `guild_score`;
CREATE TABLE `guild_score` (
`guild_id` int(10) UNSIGNED NOT NULL,
`score` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`guild_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for item_recovery
-- ----------------------------
DROP TABLE IF EXISTS `item_recovery`;
CREATE TABLE `item_recovery` (
`char_id` int(10) UNSIGNED NOT NULL,
`item` smallint(5) UNSIGNED NOT NULL,
`level` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`durability` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`skill` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`luck` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`option` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`excellent` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`ancient` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`harmony` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`option_380` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`socket_1` smallint(5) UNSIGNED NULL DEFAULT NULL,
`socket_2` smallint(5) UNSIGNED NULL DEFAULT NULL,
`socket_3` smallint(5) UNSIGNED NULL DEFAULT NULL,
`socket_4` smallint(5) UNSIGNED NULL DEFAULT NULL,
`socket_5` smallint(5) UNSIGNED NULL DEFAULT NULL,
`socket_bonus` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`data_1` int(11) NULL DEFAULT NULL,
`data_2` int(11) NULL DEFAULT NULL,
`data_3` int(11) NULL DEFAULT NULL,
`serial_server` smallint(5) UNSIGNED NULL DEFAULT NULL,
`serial` int(10) UNSIGNED NULL DEFAULT NULL,
`serial_cash_shop` int(10) UNSIGNED NULL DEFAULT NULL,
`flags` int(10) UNSIGNED NULL DEFAULT NULL,
`id` int(10) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`char_id`, `item`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for item_serial
-- ----------------------------
DROP TABLE IF EXISTS `item_serial`;
CREATE TABLE `item_serial` (
`server` int(11) NOT NULL,
`serial` bigint(20) NOT NULL,
`serial_shop` bigint(20) NOT NULL,
PRIMARY KEY (`server`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for lo_de
-- ----------------------------
DROP TABLE IF EXISTS `lo_de`;
CREATE TABLE `lo_de` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
`char_id` int(11) NOT NULL,
`bet_number` int(11) NOT NULL,
`bet_type` int(11) NOT NULL,
`bet_item` int(11) NOT NULL,
`bet_value` int(11) NOT NULL,
`bet_time` datetime(6) NOT NULL,
`reward_value_x` int(11) NOT NULL,
`reward_status` int(11) NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for master_pc
-- ----------------------------
DROP TABLE IF EXISTS `master_pc`;
CREATE TABLE `master_pc` (
`disk_serial` int(10) UNSIGNED NOT NULL,
`mac` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`disk_serial`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for migrations
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int(11) NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for monster_respawn
-- ----------------------------
DROP TABLE IF EXISTS `monster_respawn`;
CREATE TABLE `monster_respawn` (
`server` smallint(5) UNSIGNED NOT NULL,
`guid` smallint(5) UNSIGNED NOT NULL,
`date` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`server`, `guid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for party
-- ----------------------------
DROP TABLE IF EXISTS `party`;
CREATE TABLE `party` (
`guid` smallint(5) UNSIGNED NOT NULL,
`server` smallint(5) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`guid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for party_member
-- ----------------------------
DROP TABLE IF EXISTS `party_member`;
CREATE TABLE `party_member` (
`member` int(10) UNSIGNED NOT NULL,
`server` smallint(5) UNSIGNED NULL DEFAULT NULL,
`party` smallint(5) UNSIGNED NULL DEFAULT NULL,
`position` tinyint(3) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`member`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for password_resets
-- ----------------------------
DROP TABLE IF EXISTS `password_resets`;
CREATE TABLE `password_resets` (
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
INDEX `password_resets_email_index`(`email`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for personal_access_tokens
-- ----------------------------
DROP TABLE IF EXISTS `personal_access_tokens`;
CREATE TABLE `personal_access_tokens` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`tokenable_id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
`last_used_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `personal_access_tokens_token_unique`(`token`) USING BTREE,
INDEX `personal_access_tokens_tokenable_type_tokenable_id_index`(`tokenable_type`, `tokenable_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for serial_check
-- ----------------------------
DROP TABLE IF EXISTS `serial_check`;
CREATE TABLE `serial_check` (
`server` smallint(5) UNSIGNED NOT NULL,
`serial` int(10) UNSIGNED NOT NULL,
`type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`account_id` int(10) UNSIGNED NULL DEFAULT NULL,
`ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`mac` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`disk_serial` int(10) UNSIGNED NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for server_monster_soul_reset
-- ----------------------------
DROP TABLE IF EXISTS `server_monster_soul_reset`;
CREATE TABLE `server_monster_soul_reset` (
`monster_soul_reset` int(11) NULL DEFAULT 0
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for server_ranking
-- ----------------------------
DROP TABLE IF EXISTS `server_ranking`;
CREATE TABLE `server_ranking` (
`guid` int(11) NOT NULL,
`race` int(11) NULL DEFAULT NULL,
`level_normal` int(11) NULL DEFAULT NULL,
`level_master` int(11) NULL DEFAULT NULL,
`level_majestic` int(11) NULL DEFAULT NULL,
`reset` int(11) NULL DEFAULT NULL,
`update_time` datetime(6) NULL DEFAULT NULL,
PRIMARY KEY (`guid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for server_signal
-- ----------------------------
DROP TABLE IF EXISTS `server_signal`;
CREATE TABLE `server_signal` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`server` smallint(5) UNSIGNED NULL DEFAULT NULL,
`signal` smallint(5) UNSIGNED NULL DEFAULT NULL,
`data_1` int(11) NULL DEFAULT NULL,
`data_2` int(11) NULL DEFAULT NULL,
`data_3` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for tormented_square_survival_hall_of_fame
-- ----------------------------
DROP TABLE IF EXISTS `tormented_square_survival_hall_of_fame`;
CREATE TABLE `tormented_square_survival_hall_of_fame` (
`char_id_1` int(10) UNSIGNED NOT NULL,
`char_name_1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`char_id_2` int(10) UNSIGNED NULL DEFAULT NULL,
`char_name_2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`score` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`char_id_1`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for tormented_square_survival_ranking
-- ----------------------------
DROP TABLE IF EXISTS `tormented_square_survival_ranking`;
CREATE TABLE `tormented_square_survival_ranking` (
`type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`ranking` int(11) NULL DEFAULT NULL,
`char_id_1` int(10) UNSIGNED NULL DEFAULT NULL,
`char_name_1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`char_id_2` int(10) UNSIGNED NULL DEFAULT NULL,
`char_name_2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`score` int(11) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for tormented_square_survival_team
-- ----------------------------
DROP TABLE IF EXISTS `tormented_square_survival_team`;
CREATE TABLE `tormented_square_survival_team` (
`char_id_1` int(10) UNSIGNED NULL DEFAULT NULL,
`char_id_2` int(10) UNSIGNED NULL DEFAULT NULL,
`score` int(11) NULL DEFAULT NULL,
`type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
`enter_count` int(11) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
SET FOREIGN_KEY_CHECKS = 1;