log.sql for season 19 Part1-1

/*
 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         : log

 Target Server Type    : MySQL
 Target Server Version : 50743 (5.7.43-log)
 File Encoding         : 65001

 Date: 26/09/2023 21:10:06
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for antihack
-- ----------------------------
DROP TABLE IF EXISTS `antihack`;
CREATE TABLE `antihack`  (
  `server` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `account_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `player_data` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `player_location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `description` 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 item_bag_serial
-- ----------------------------
DROP TABLE IF EXISTS `item_bag_serial`;
CREATE TABLE `item_bag_serial`  (
  `serial` int(10) UNSIGNED NULL DEFAULT NULL,
  `server` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `level` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `account_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name` 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,
  `instance` int(11) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for log_boss_kill
-- ----------------------------
DROP TABLE IF EXISTS `log_boss_kill`;
CREATE TABLE `log_boss_kill`  (
  `boss_index` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `boss_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `boss_id` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `character_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `character_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `damage` bigint(20) NULL DEFAULT NULL,
  `damage_reflect` bigint(20) NULL DEFAULT NULL,
  `damage_debuff` bigint(20) NULL DEFAULT NULL,
  `damage_elemental` bigint(20) NULL DEFAULT NULL,
  `server` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `first_hit` 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 log_cash_shop
-- ----------------------------
DROP TABLE IF EXISTS `log_cash_shop`;
CREATE TABLE `log_cash_shop`  (
  `server_id` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `account_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `player_data` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `dest_char` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `package_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `product_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `option_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `product_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `price_type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `price` int(10) UNSIGNED NULL DEFAULT NULL,
  `gift` tinyint(3) UNSIGNED NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for log_duel_bet
-- ----------------------------
DROP TABLE IF EXISTS `log_duel_bet`;
CREATE TABLE `log_duel_bet`  (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `char_id_1` int(255) NOT NULL,
  `char_name_1` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `char_id_2` int(255) NOT NULL,
  `char_name_2` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `bet_type` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `bet_count` int(255) NOT NULL,
  `player_win` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `duel_start_time` datetime(6) NOT NULL,
  `duel_end_time` datetime(6) NULL DEFAULT NULL,
  `duel_status` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci 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 log_errtel_pentagram
-- ----------------------------
DROP TABLE IF EXISTS `log_errtel_pentagram`;
CREATE TABLE `log_errtel_pentagram`  (
  `server` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `account_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `player_data` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `blessing_spirit` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `result` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `pentagram_data` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `errtel_data` varchar(1000) 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 log_item_buy
-- ----------------------------
DROP TABLE IF EXISTS `log_item_buy`;
CREATE TABLE `log_item_buy`  (
  `server` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `account_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `player_data` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `item_data` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `comment` 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 log_item_create
-- ----------------------------
DROP TABLE IF EXISTS `log_item_create`;
CREATE TABLE `log_item_create`  (
  `account_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `interface_id` 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,
  `server` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `serial` int(10) UNSIGNED NULL DEFAULT NULL,
  `serial_shop` int(10) UNSIGNED NULL DEFAULT NULL,
  `item` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `level` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `item_data` 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 log_item_drop
-- ----------------------------
DROP TABLE IF EXISTS `log_item_drop`;
CREATE TABLE `log_item_drop`  (
  `server` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `account_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `player_data` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `item_data` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `comment` 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 log_item_loot
-- ----------------------------
DROP TABLE IF EXISTS `log_item_loot`;
CREATE TABLE `log_item_loot`  (
  `server` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `account_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `player_data` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `item_data` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `comment` 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 log_item_sell
-- ----------------------------
DROP TABLE IF EXISTS `log_item_sell`;
CREATE TABLE `log_item_sell`  (
  `server` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `account_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `player_data` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `item_data` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `comment` 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 log_jewel_drop
-- ----------------------------
DROP TABLE IF EXISTS `log_jewel_drop`;
CREATE TABLE `log_jewel_drop`  (
  `char_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `account_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `jewel_type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `jewel_index` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `jewel_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `world` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `x` smallint(6) NULL DEFAULT NULL,
  `y` smallint(6) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for log_jewel_mix
-- ----------------------------
DROP TABLE IF EXISTS `log_jewel_mix`;
CREATE TABLE `log_jewel_mix`  (
  `char_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `server` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `mix_type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `mix_id` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `mix_level` tinyint(3) UNSIGNED NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for log_level_up
-- ----------------------------
DROP TABLE IF EXISTS `log_level_up`;
CREATE TABLE `log_level_up`  (
  `char_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `level_normal` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `level_master` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `level_majestic` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `world` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `world_x` smallint(6) NULL DEFAULT NULL,
  `world_y` smallint(6) NULL DEFAULT NULL,
  `event_ground` tinyint(4) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for log_mix
-- ----------------------------
DROP TABLE IF EXISTS `log_mix`;
CREATE TABLE `log_mix`  (
  `server` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `account_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `player_data` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `mix_id` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `mix_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `rate` int(11) NULL DEFAULT NULL,
  `cost` int(10) UNSIGNED NULL DEFAULT NULL,
  `result` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `item_data_before` varchar(15000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `item_data_after` varchar(5000) 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 log_personal_store
-- ----------------------------
DROP TABLE IF EXISTS `log_personal_store`;
CREATE TABLE `log_personal_store`  (
  `server` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `account_id_01` int(10) UNSIGNED NULL DEFAULT NULL,
  `account_01` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_id_01` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name_01` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `player_data_01` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `account_id_02` int(10) UNSIGNED NULL DEFAULT NULL,
  `account_02` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_id_02` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name_02` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `player_data_02` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `offstore` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `item_data` varchar(1000) 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 log_pvp
-- ----------------------------
DROP TABLE IF EXISTS `log_pvp`;
CREATE TABLE `log_pvp`  (
  `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_class_1` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `char_stat_1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_set_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,
  `char_class_2` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `char_stat_2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_set_2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `skill` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `hp_damage` int(11) NULL DEFAULT NULL,
  `sd_damage` int(11) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for log_reset
-- ----------------------------
DROP TABLE IF EXISTS `log_reset`;
CREATE TABLE `log_reset`  (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `char_id` int(255) NOT NULL,
  `char_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `old_rs` int(255) NOT NULL,
  `new_rs` int(255) NOT NULL,
  `time_rs` datetime(6) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for log_trade
-- ----------------------------
DROP TABLE IF EXISTS `log_trade`;
CREATE TABLE `log_trade`  (
  `server` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `account_id_01` int(10) UNSIGNED NULL DEFAULT NULL,
  `account_01` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_id_01` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name_01` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `player_data_01` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `account_id_02` int(10) UNSIGNED NULL DEFAULT NULL,
  `account_02` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_id_02` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name_02` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `player_data_02` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `money` int(10) UNSIGNED NULL DEFAULT NULL,
  `item_data` varchar(18000) 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 mix_recovery
-- ----------------------------
DROP TABLE IF EXISTS `mix_recovery`;
CREATE TABLE `mix_recovery`  (
  `server` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `account_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `player_data` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `item_data` varchar(9999) 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 reward_dungeon
-- ----------------------------
DROP TABLE IF EXISTS `reward_dungeon`;
CREATE TABLE `reward_dungeon`  (
  `server` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `account_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `char_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `player_data` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `type` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `item_data` 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 reward_labyrinth_of_dimensions
-- ----------------------------
DROP TABLE IF EXISTS `reward_labyrinth_of_dimensions`;
CREATE TABLE `reward_labyrinth_of_dimensions`  (
  `server` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `char_id` int(10) UNSIGNED NULL DEFAULT NULL,
  `char_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `category` tinyint(3) UNSIGNED NULL DEFAULT NULL,
  `rank` int(11) NULL DEFAULT NULL,
  `item_data` varchar(10000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;