281 lines
12 KiB
SQL
281 lines
12 KiB
SQL
-- 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
|