-- MySQL dump 10.13 Distrib 8.0.42, for Linux (x86_64) -- -- Host: 172.20.0.5 Database: Merge_Pet_1 -- ------------------------------------------------------ -- Server version 8.4.5 /*!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 utf8mb4 */; /*!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 `db_version` -- DROP TABLE IF EXISTS `db_version`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `db_version` ( `version_2018_02_06_13` int unsigned NOT NULL COMMENT 'version' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='数据库版本号'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `db_version` -- LOCK TABLES `db_version` WRITE; /*!40000 ALTER TABLE `db_version` DISABLE KEYS */; /*!40000 ALTER TABLE `db_version` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `system_mail_info` -- DROP TABLE IF EXISTS `system_mail_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `system_mail_info` ( `mail_id` bigint NOT NULL AUTO_INCREMENT COMMENT '邮件ID', `title` varchar(128) DEFAULT '' COMMENT '邮件标题', `content` varchar(2048) DEFAULT '' COMMENT '邮件内容', `title_en` varchar(128) DEFAULT '' COMMENT '英文邮件标题', `content_en` varchar(2048) DEFAULT '' COMMENT '英文邮件内容', `items` varchar(2048) DEFAULT '{}' COMMENT '邮件附件', `start_time` int unsigned NOT NULL DEFAULT '0' COMMENT '开始时间', `register_time` int unsigned NOT NULL DEFAULT '0' COMMENT '注册时间', `end_time` int unsigned NOT NULL DEFAULT '0' COMMENT '结束时间', `mail_type` int unsigned NOT NULL DEFAULT '0' COMMENT '邮件类型', `send_type` int unsigned NOT NULL DEFAULT '0' COMMENT '发送类型', `to_uids` varchar(2048) DEFAULT '' COMMENT '发送者ID', `create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', PRIMARY KEY (`mail_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统邮件'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `system_mail_info` -- LOCK TABLES `system_mail_info` WRITE; /*!40000 ALTER TABLE `system_mail_info` DISABLE KEYS */; /*!40000 ALTER TABLE `system_mail_info` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `t_account` -- DROP TABLE IF EXISTS `t_account`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `t_account` ( `user_name` varchar(50) COLLATE utf8mb4_general_ci NOT NULL, `user_password` varchar(128) COLLATE utf8mb4_general_ci NOT NULL, `login_time` int unsigned DEFAULT '0' COMMENT '上次登录时间', `logout_time` int unsigned DEFAULT '0' COMMENT '上次下线时间', `ip_address` char(24) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '上次登录的ip地址', `gm_level` int DEFAULT '0' COMMENT 'gm等级', `platform` varchar(50) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '平台', `is_online` int unsigned DEFAULT '0' COMMENT '角色是否在线', `channel` varchar(50) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '渠道号', `device_id` varchar(256) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '是否为刷榜账号', `auto_id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `id_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '""', `id_num` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '""', PRIMARY KEY (`auto_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='账号密码对照表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t_account` -- LOCK TABLES `t_account` WRITE; /*!40000 ALTER TABLE `t_account` DISABLE KEYS */; /*!40000 ALTER TABLE `t_account` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `t_gameserver` -- DROP TABLE IF EXISTS `t_gameserver`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `t_gameserver` ( `id` int unsigned NOT NULL COMMENT '服务器id', `start_time` int unsigned DEFAULT NULL COMMENT '开服时间', `close_time` int unsigned DEFAULT NULL COMMENT '关服时间', `is_close` int unsigned DEFAULT NULL COMMENT '是否关服', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='服务器设置'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t_gameserver` -- LOCK TABLES `t_gameserver` WRITE; /*!40000 ALTER TABLE `t_gameserver` DISABLE KEYS */; /*!40000 ALTER TABLE `t_gameserver` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `t_player_baseinfo` -- DROP TABLE IF EXISTS `t_player_baseinfo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `t_player_baseinfo` ( `dwUin` bigint unsigned NOT NULL COMMENT '对应玩家account表中的dwUin', `energy` int unsigned NOT NULL DEFAULT '0' COMMENT '能量', `star` int unsigned NOT NULL DEFAULT '0' COMMENT '星星', `recover_time` int unsigned NOT NULL DEFAULT '0' COMMENT '能量开始恢复时间', `diamond` int unsigned NOT NULL DEFAULT '1' COMMENT '钻石', `level` int unsigned NOT NULL DEFAULT '0' COMMENT '玩家等级', `exp` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000' COMMENT '玩家经验', `start_order_id` varchar(50) DEFAULT NULL COMMENT '配置订单进度', `music_code` int unsigned NOT NULL DEFAULT '0' COMMENT '音效状态码改为GUID免费改名状态', `guild` int unsigned NOT NULL DEFAULT '0' COMMENT '引导进度 ', `pack_unlock_count` int unsigned NOT NULL DEFAULT '0' COMMENT '背包解锁数量', `last_play_time` int NOT NULL DEFAULT '0' COMMENT '广告能量购买时间', `EnergyBuyCount` int NOT NULL DEFAULT '0' COMMENT '能量购买次数', `user_name` varchar(50) NOT NULL DEFAULT '' COMMENT '玩家账号', `nick_name` varchar(50) NOT NULL DEFAULT '' COMMENT '玩家昵称', `login_time` int unsigned NOT NULL DEFAULT '0' COMMENT '上次登录时间', `logout_time` int unsigned NOT NULL DEFAULT '0' COMMENT '上次下线时间', `todayolinetime` int unsigned NOT NULL DEFAULT '0' COMMENT '当天的累计在线时间', `rolecreatetime` int unsigned NOT NULL DEFAULT '0' COMMENT '注册帐号时间', `EmitOrderCnt` int unsigned NOT NULL DEFAULT '0' COMMENT '注册帐号时间', `DailyRenewTime` int unsigned NOT NULL DEFAULT '0' COMMENT '注册帐号时间', `NoAd` int unsigned NOT NULL DEFAULT '0' COMMENT '注册帐号时间', `ChampshipsGroupID` int unsigned NOT NULL DEFAULT '0' COMMENT '注册帐号时间', `LastChampGroupID` int unsigned NOT NULL DEFAULT '0' COMMENT '注册帐号时间', `FaceBookId` varchar(128) DEFAULT '' COMMENT '玩家账号', PRIMARY KEY (`dwUin`), KEY `nick_name` (`nick_name`), KEY `user_name` (`user_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='存储玩家基本信息'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t_player_baseinfo` -- LOCK TABLES `t_player_baseinfo` WRITE; /*!40000 ALTER TABLE `t_player_baseinfo` DISABLE KEYS */; /*!40000 ALTER TABLE `t_player_baseinfo` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `t_player_charge` -- DROP TABLE IF EXISTS `t_player_charge`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `t_player_charge` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '订单id', `Uid` bigint unsigned NOT NULL COMMENT '玩家id', `OrderId` varchar(128) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '订单号', `ProductId` int unsigned NOT NULL DEFAULT '0' COMMENT '商品id', `ProductName` varchar(128) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '商品名称', `ProductDesc` varchar(128) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '商品描述', `Price` float NOT NULL DEFAULT '0' COMMENT '价格', `Currency` varchar(128) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '货币', `CreateTime` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `PayTime` int unsigned NOT NULL DEFAULT '0' COMMENT '支付时间', `PayStatus` int unsigned NOT NULL DEFAULT '0' COMMENT '支付状态 0 未支付 1 已支付 2 支付失败 3 已发货', `PayType` int unsigned NOT NULL DEFAULT '0' COMMENT '支付类型', `PayPlatform` varchar(128) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '支付平台', `PayChannel` varchar(128) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '支付渠道', `PayChannelOrderId` varchar(512) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '支付渠道订单号', `PayChannelUserId` varchar(128) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '支付渠道用户id', `PayChannelExtra` varchar(128) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '支付渠道额外信息', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='玩家订单表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t_player_charge` -- LOCK TABLES `t_player_charge` WRITE; /*!40000 ALTER TABLE `t_player_charge` DISABLE KEYS */; /*!40000 ALTER TABLE `t_player_charge` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `t_player_mod` -- DROP TABLE IF EXISTS `t_player_mod`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `t_player_mod` ( `dwUin` bigint unsigned NOT NULL COMMENT '玩家uid', `mData` blob COMMENT '数据', `updateTime` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', PRIMARY KEY (`dwUin`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='玩家模块表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t_player_mod` -- LOCK TABLES `t_player_mod` WRITE; /*!40000 ALTER TABLE `t_player_mod` DISABLE KEYS */; /*!40000 ALTER TABLE `t_player_mod` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `t_server_mod` -- DROP TABLE IF EXISTS `t_server_mod`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `t_server_mod` ( `id` int NOT NULL AUTO_INCREMENT, `key` varchar(128) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '模块key', `mData` mediumblob COMMENT '数据', `updateTime` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统模块表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t_server_mod` -- LOCK TABLES `t_server_mod` WRITE; /*!40000 ALTER TABLE `t_server_mod` DISABLE KEYS */; /*!40000 ALTER TABLE `t_server_mod` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping routines for database 'Merge_Pet_1' -- /*!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-07-09 2:47:05