-- MySQL dump 10.13  Distrib 8.0.42, for Win64 (x86_64)
--
-- Host: ls-84f3877b6ab3a7fb4594cb182f344fe902ecd11b.cxiafl5pqyht.ap-northeast-2.rds.amazonaws.com    Database: logDB_MH
-- ------------------------------------------------------
-- Server version	8.0.40

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `EventDealRankLog`
--

DROP TABLE IF EXISTS `EventDealRankLog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `EventDealRankLog` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `rank` int NOT NULL DEFAULT '0',
  `playerId` bigint NOT NULL DEFAULT '-1',
  `nickname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `score` double NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `create_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`) USING BTREE,
  KEY `create_date` (`create_date`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `dia_compare_log`
--

DROP TABLE IF EXISTS `dia_compare_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dia_compare_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `url_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `diff_dia` double NOT NULL DEFAULT '0',
  `before_dia` double NOT NULL DEFAULT '0',
  `after_dia` double NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`uid`) USING BTREE,
  KEY `playerId` (`playerId`) USING BTREE,
  KEY `url_name` (`url_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=386 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `dia_log`
--

DROP TABLE IF EXISTS `dia_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dia_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `url_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `diff_dia` double NOT NULL DEFAULT '0',
  `before_dia` double NOT NULL DEFAULT '0',
  `after_dia` double NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `update_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`) USING BTREE,
  KEY `playerId` (`playerId`) USING BTREE,
  KEY `url_name` (`url_name`) USING BTREE,
  KEY `update_date` (`update_date`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=82641 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `equipment_log`
--

DROP TABLE IF EXISTS `equipment_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `equipment_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `url_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `itemId` int NOT NULL DEFAULT '-1',
  `preset_type` int NOT NULL DEFAULT '-1',
  `preset_sub_type` int NOT NULL DEFAULT '-1',
  `diff_value` double NOT NULL DEFAULT '0',
  `before_value` double NOT NULL DEFAULT '0',
  `after_value` double NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `update_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`) USING BTREE,
  KEY `playerId` (`playerId`) USING BTREE,
  KEY `url_name` (`url_name`) USING BTREE,
  KEY `itemId_equipType` (`itemId`)
) ENGINE=InnoDB AUTO_INCREMENT=70947 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `error_log`
--

DROP TABLE IF EXISTS `error_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `error_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `error_message` varchar(10000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `guild_attendance_log`
--

DROP TABLE IF EXISTS `guild_attendance_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `guild_attendance_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `guild_uid` bigint NOT NULL DEFAULT '-1',
  `playerId` bigint NOT NULL DEFAULT '-1',
  `guild_exp` int NOT NULL DEFAULT '0',
  `weekly_point` int NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `create_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`),
  KEY `guild_uid` (`guild_uid`),
  KEY `playerId` (`playerId`),
  KEY `create_date` (`create_date`),
  KEY `create_time` (`create_time`),
  KEY `playerId_create_date` (`playerId`,`create_date`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `guild_ban_log`
--

DROP TABLE IF EXISTS `guild_ban_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `guild_ban_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `guild_uid` bigint NOT NULL DEFAULT '-1',
  `master_uid` bigint NOT NULL DEFAULT '-1',
  `member_uid` bigint NOT NULL DEFAULT '-1',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`uid`),
  KEY `guild_uid` (`guild_uid`),
  KEY `playerId` (`master_uid`) USING BTREE,
  KEY `ban_user_id` (`member_uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `guild_mission_log`
--

DROP TABLE IF EXISTS `guild_mission_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `guild_mission_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `guild_uid` bigint NOT NULL DEFAULT '-1',
  `playerId` bigint NOT NULL DEFAULT '-1',
  `missionId` int NOT NULL DEFAULT '-1',
  `guild_exp` int NOT NULL DEFAULT '0',
  `weekly_point` int NOT NULL DEFAULT '0',
  `missionAmount` int NOT NULL DEFAULT '-1',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `create_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`),
  KEY `guild_uid` (`guild_uid`),
  KEY `playerId` (`playerId`),
  KEY `create_time` (`create_time`),
  KEY `create_date` (`create_date`),
  KEY `playerId_create_date` (`playerId`,`create_date`)
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `item_compare_log`
--

DROP TABLE IF EXISTS `item_compare_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `item_compare_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `itemId` int NOT NULL DEFAULT '-1',
  `url_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `diff_value` double NOT NULL DEFAULT '0',
  `before_value` double NOT NULL DEFAULT '0',
  `after_value` double NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`uid`) USING BTREE,
  KEY `playerId` (`playerId`) USING BTREE,
  KEY `itemId` (`itemId`) USING BTREE,
  KEY `url_name` (`url_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1070 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `item_log`
--

DROP TABLE IF EXISTS `item_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `item_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `url_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `itemId` int NOT NULL DEFAULT '-1',
  `diff_value` double NOT NULL DEFAULT '0',
  `before_value` double NOT NULL DEFAULT '0',
  `after_value` double NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `update_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`) USING BTREE,
  KEY `playerId` (`playerId`) USING BTREE,
  KEY `url_name` (`url_name`) USING BTREE,
  KEY `itemId` (`itemId`) USING BTREE,
  KEY `update_date` (`update_date`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1838655 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `origin_tower_re_roll_log`
--

DROP TABLE IF EXISTS `origin_tower_re_roll_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `origin_tower_re_roll_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `preset` int NOT NULL DEFAULT '-1',
  `floor` int NOT NULL DEFAULT '-1',
  `stat_id_list` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `stat_rank_list` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `stat_lock_list` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `create_date` date NOT NULL DEFAULT '1970-01-01',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`uid`),
  KEY `playerId` (`playerId`) /*!80000 INVISIBLE */,
  KEY `create_date` (`create_date`)
) ENGINE=InnoDB AUTO_INCREMENT=2885 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `request_decode_log`
--

DROP TABLE IF EXISTS `request_decode_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `request_decode_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `url_name` varchar(150) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `request_decode` varchar(5000) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `create_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`),
  KEY `playerId` (`playerId`),
  KEY `url_name` (`url_name`),
  KEY `playerId_url_name` (`playerId`,`url_name`)
) ENGINE=InnoDB AUTO_INCREMENT=164671 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `skill_log`
--

DROP TABLE IF EXISTS `skill_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `skill_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `url_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `itemId` int NOT NULL DEFAULT '-1',
  `diff_value` double NOT NULL DEFAULT '0',
  `before_value` double NOT NULL DEFAULT '0',
  `after_value` double NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `update_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`) USING BTREE,
  KEY `playerId` (`playerId`) USING BTREE,
  KEY `url_name` (`url_name`) USING BTREE,
  KEY `itemId` (`itemId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=35727 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `skill_pattern_log`
--

DROP TABLE IF EXISTS `skill_pattern_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `skill_pattern_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '0',
  `itemId` int NOT NULL DEFAULT '0',
  `p0` int NOT NULL DEFAULT '-1',
  `p1` int NOT NULL DEFAULT '-1',
  `p2` int NOT NULL DEFAULT '-1',
  `p3` int NOT NULL DEFAULT '-1',
  `p4` int NOT NULL DEFAULT '-1',
  `p5` int NOT NULL DEFAULT '-1',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `create_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`),
  KEY `playerId` (`playerId`),
  KEY `create_date` (`create_date`),
  KEY `playerId_create_date` (`playerId`,`create_date`)
) ENGINE=InnoDB AUTO_INCREMENT=1111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `summon_contents_option_log`
--

DROP TABLE IF EXISTS `summon_contents_option_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `summon_contents_option_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `itemId` int NOT NULL DEFAULT '-1',
  `optionId` int NOT NULL DEFAULT '-1',
  `preset_type` int NOT NULL DEFAULT '-1',
  `preset_sub_type` int NOT NULL DEFAULT '-1',
  `rank` int NOT NULL DEFAULT '-1',
  `level` int NOT NULL DEFAULT '-1',
  `tryAmount` int NOT NULL DEFAULT '-1',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`) USING BTREE,
  KEY `playerId` (`playerId`) USING BTREE,
  KEY `create_date` (`create_date`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5136 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `summon_creature_log`
--

DROP TABLE IF EXISTS `summon_creature_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `summon_creature_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `itemId` int NOT NULL DEFAULT '-1',
  `itemAmount` int NOT NULL DEFAULT '-1',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `create_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`) USING BTREE,
  KEY `playerId` (`playerId`) USING BTREE,
  KEY `create_date` (`create_date`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2830 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `summon_creature_option_log`
--

DROP TABLE IF EXISTS `summon_creature_option_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `summon_creature_option_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `itemId` int NOT NULL DEFAULT '-1',
  `optionId` int NOT NULL DEFAULT '-1',
  `rank` int NOT NULL DEFAULT '-1',
  `level` int NOT NULL DEFAULT '-1',
  `tryAmount` int NOT NULL DEFAULT '-1',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `create_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`) USING BTREE,
  KEY `playerId` (`playerId`) USING BTREE,
  KEY `create_date` (`create_date`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=567 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `summon_equipment_log`
--

DROP TABLE IF EXISTS `summon_equipment_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `summon_equipment_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `preset_type` int NOT NULL DEFAULT '-1',
  `preset_sub_type` int NOT NULL DEFAULT '-1',
  `itemId` int NOT NULL DEFAULT '-1',
  `itemAmount` int NOT NULL DEFAULT '-1',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`),
  KEY `playerId` (`playerId`),
  KEY `create_date` (`create_date`)
) ENGINE=InnoDB AUTO_INCREMENT=140252 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `summon_equipment_option_log`
--

DROP TABLE IF EXISTS `summon_equipment_option_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `summon_equipment_option_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `itemId` int NOT NULL DEFAULT '-1',
  `optionId` int NOT NULL DEFAULT '-1',
  `rank` int NOT NULL DEFAULT '-1',
  `level` int NOT NULL DEFAULT '-1',
  `tryAmount` int NOT NULL DEFAULT '-1',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`) USING BTREE,
  KEY `playerId` (`playerId`) USING BTREE,
  KEY `create_date` (`create_date`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=974 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `summon_essence_log`
--

DROP TABLE IF EXISTS `summon_essence_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `summon_essence_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `type` int NOT NULL DEFAULT '0',
  `preset` int NOT NULL DEFAULT '-1',
  `grade_list` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `id_list` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `rank_list` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `try_count` int NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`),
  KEY `playerId` (`playerId`),
  KEY `create_date` (`create_date`)
) ENGINE=InnoDB AUTO_INCREMENT=5055 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `summon_god_weapon_option_log`
--

DROP TABLE IF EXISTS `summon_god_weapon_option_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `summon_god_weapon_option_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `itemId` int NOT NULL DEFAULT '-1',
  `optionId` int NOT NULL DEFAULT '-1',
  `rank` int NOT NULL DEFAULT '-1',
  `level` int NOT NULL DEFAULT '-1',
  `tryAmount` int NOT NULL DEFAULT '-1',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `create_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`) USING BTREE,
  KEY `playerId` (`playerId`) USING BTREE,
  KEY `create_date` (`create_date`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=582 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `summon_jem_option_log`
--

DROP TABLE IF EXISTS `summon_jem_option_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `summon_jem_option_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `itemId` int NOT NULL DEFAULT '-1',
  `optionId` int NOT NULL DEFAULT '-1',
  `rank` int NOT NULL DEFAULT '-1',
  `level` int NOT NULL DEFAULT '-1',
  `tryAmount` int NOT NULL DEFAULT '-1',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `create_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`),
  KEY `playerId` (`playerId`) /*!80000 INVISIBLE */,
  KEY `create_date` (`create_date`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=891 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `summon_skill_log`
--

DROP TABLE IF EXISTS `summon_skill_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `summon_skill_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `itemId` int NOT NULL DEFAULT '-1',
  `itemAmount` int NOT NULL DEFAULT '-1',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`) USING BTREE,
  KEY `playerId` (`playerId`) USING BTREE,
  KEY `create_date` (`create_date`)
) ENGINE=InnoDB AUTO_INCREMENT=1342 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `summon_skill_option_log`
--

DROP TABLE IF EXISTS `summon_skill_option_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `summon_skill_option_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `itemId` int NOT NULL DEFAULT '-1',
  `optionId` int NOT NULL DEFAULT '-1',
  `rank` int NOT NULL DEFAULT '-1',
  `level` int NOT NULL DEFAULT '-1',
  `tryAmount` int NOT NULL DEFAULT '-1',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`) USING BTREE,
  KEY `playerId` (`playerId`) USING BTREE,
  KEY `create_date` (`create_date`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1010 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `system_log`
--

DROP TABLE IF EXISTS `system_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `playerId` bigint NOT NULL DEFAULT '-1',
  `log` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`uid`) USING BTREE,
  KEY `playerId` (`playerId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=36324373 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `wander_season_score_log`
--

DROP TABLE IF EXISTS `wander_season_score_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wander_season_score_log` (
  `uid` bigint NOT NULL AUTO_INCREMENT,
  `seasonId` int NOT NULL DEFAULT '-1',
  `playerId` bigint NOT NULL DEFAULT '-1',
  `rank` int NOT NULL DEFAULT '-1',
  `mapLevel` int NOT NULL DEFAULT '-1',
  `mapId` int NOT NULL DEFAULT '-1',
  `vertexId` int NOT NULL DEFAULT '-1',
  `type` int NOT NULL DEFAULT '-1',
  `score` int NOT NULL DEFAULT '-1',
  `create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `create_date` date NOT NULL DEFAULT '1970-01-01',
  PRIMARY KEY (`uid`),
  KEY `seasonId` (`seasonId`),
  KEY `playerId` (`playerId`),
  KEY `seasonId_playerId` (`seasonId`,`playerId`),
  KEY `create_date` (`create_date`),
  KEY `seasonId_playerId_create_date` (`seasonId`,`playerId`,`create_date`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-05-03 13:23:37
