/*
 Navicat Premium Data Transfer

 Source Server         : 木子
 Source Server Type    : MySQL
 Source Server Version : 50650
 Source Host           : localhost:3306
 Source Schema         : sdk

 Target Server Type    : MySQL
 Target Server Version : 50650
 File Encoding         : 65001

 Date: 19/06/2025 11:35:26
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for account_login_logs
-- ----------------------------
DROP TABLE IF EXISTS `account_login_logs`;
CREATE TABLE `account_login_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account` varchar(50) DEFAULT NULL COMMENT '用户ID',
  `login_ip` varchar(50) NOT NULL DEFAULT '0' COMMENT '登录ip',
  `device_no` varchar(100) NOT NULL COMMENT '设备编号',
  `device_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '设备类型 1：ios 2：安卓 3：h5',
  `device_version` varchar(20) NOT NULL DEFAULT '' COMMENT '客户端版本',
  `system_version` varchar(255) NOT NULL COMMENT '系统版本',
  `device_model` varchar(255) NOT NULL COMMENT '设备型号',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `acc_id_index` (`account`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=583819 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='登录日志';

-- ----------------------------
-- Table structure for accounts
-- ----------------------------
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `account` varchar(100) NOT NULL COMMENT '账号',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
  `channel_id` int(11) NOT NULL DEFAULT '0' COMMENT '渠道号',
  `reg_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '注册ip',
  `device_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '注册设备号',
  `reg_device` varchar(255) NOT NULL DEFAULT '' COMMENT '注册设备',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '注册时间',
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=64620 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户表';

-- ----------------------------
-- Table structure for admin_menu
-- ----------------------------
DROP TABLE IF EXISTS `admin_menu`;
CREATE TABLE `admin_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `order` int(11) NOT NULL DEFAULT '0',
  `title` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `icon` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `uri` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for admin_operation_log
-- ----------------------------
DROP TABLE IF EXISTS `admin_operation_log`;
CREATE TABLE `admin_operation_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `method` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `input` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `admin_operation_log_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5454 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for admin_permissions
-- ----------------------------
DROP TABLE IF EXISTS `admin_permissions`;
CREATE TABLE `admin_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admin_permissions_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for admin_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_menu`;
CREATE TABLE `admin_role_menu` (
  `role_id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `admin_role_menu_role_id_menu_id_index` (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for admin_role_permissions
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_permissions`;
CREATE TABLE `admin_role_permissions` (
  `role_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `admin_role_permissions_role_id_permission_id_index` (`role_id`,`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for admin_role_users
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_users`;
CREATE TABLE `admin_role_users` (
  `role_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `admin_role_users_role_id_user_id_index` (`role_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for admin_roles
-- ----------------------------
DROP TABLE IF EXISTS `admin_roles`;
CREATE TABLE `admin_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admin_roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for admin_user_permissions
-- ----------------------------
DROP TABLE IF EXISTS `admin_user_permissions`;
CREATE TABLE `admin_user_permissions` (
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `admin_user_permissions_user_id_permission_id_index` (`user_id`,`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for admin_users
-- ----------------------------
DROP TABLE IF EXISTS `admin_users`;
CREATE TABLE `admin_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(190) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `avatar` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admin_users_username_unique` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for ban_logs
-- ----------------------------
DROP TABLE IF EXISTS `ban_logs`;
CREATE TABLE `ban_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '封禁值',
  `server_id` int(11) NOT NULL COMMENT '服务器id',
  `ban_type` int(11) NOT NULL COMMENT '封禁类型',
  `ban_op` int(11) NOT NULL COMMENT '封禁操作',
  `desc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `start_at` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_at` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `channel_id` int(11) DEFAULT '2',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for base_data
-- ----------------------------
DROP TABLE IF EXISTS `base_data`;
CREATE TABLE `base_data` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `add_user_num` int(11) NOT NULL DEFAULT '0' COMMENT '新增用户数',
  `add_role_num` int(11) NOT NULL DEFAULT '0' COMMENT '新增角色数',
  `add_device_num` int(11) NOT NULL DEFAULT '0' COMMENT '新增设备数',
  `login_user_num` int(11) NOT NULL DEFAULT '0' COMMENT '登陆人数',
  `active_user_num` int(11) NOT NULL DEFAULT '0' COMMENT '活跃人数',
  `pay_user_num` int(11) NOT NULL DEFAULT '0' COMMENT '付费人数',
  `pay_rate` int(11) NOT NULL DEFAULT '0' COMMENT '付费率',
  `first_amount` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '首充金额',
  `arpu` double(8,2) NOT NULL DEFAULT '0.00',
  `arppu` double(8,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  KEY `base_data_date_index` (`date`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for cdk_bags
-- ----------------------------
DROP TABLE IF EXISTS `cdk_bags`;
CREATE TABLE `cdk_bags` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '礼包名',
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `number` tinyint(4) NOT NULL COMMENT '允许次数，0无限次',
  `start_at` timestamp NOT NULL,
  `end_at` timestamp NOT NULL,
  `status` tinyint(4) NOT NULL,
  `items` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '道具',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=218 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for cdk_codes
-- ----------------------------
DROP TABLE IF EXISTS `cdk_codes`;
CREATE TABLE `cdk_codes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bag_id` int(11) NOT NULL COMMENT '礼包id',
  `cdk_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '礼包码',
  `use_num` tinyint(4) NOT NULL DEFAULT '0' COMMENT '使用次数',
  `use_at` timestamp NULL DEFAULT NULL COMMENT '使用时间',
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code_index` (`cdk_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=533199 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for cdk_logs
-- ----------------------------
DROP TABLE IF EXISTS `cdk_logs`;
CREATE TABLE `cdk_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bag_id` int(11) NOT NULL COMMENT '礼包id',
  `cdk_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '礼包码',
  `user_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '使用角色id',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44993 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for game_enter_server
-- ----------------------------
DROP TABLE IF EXISTS `game_enter_server`;
CREATE TABLE `game_enter_server` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `uid` varchar(50) NOT NULL DEFAULT '' COMMENT '区服名',
  `server_id` varchar(50) NOT NULL DEFAULT '' COMMENT '区服id',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '进区时间',
  `first_server_id` varchar(11) NOT NULL DEFAULT '1',
  `tag` int(11) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=71983 DEFAULT CHARSET=utf8mb4 COMMENT='进区记录表';

-- ----------------------------
-- Table structure for game_order
-- ----------------------------
DROP TABLE IF EXISTS `game_order`;
CREATE TABLE `game_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `order_id` varchar(50) NOT NULL DEFAULT '' COMMENT '订单id',
  `uid` varchar(100) NOT NULL DEFAULT '' COMMENT '用户id',
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '订单状态 1未支付 2成功 3失败',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `out_trade_no` varchar(255) NOT NULL DEFAULT '' COMMENT '第三方订单id',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级',
  `role_id` varchar(50) NOT NULL DEFAULT '' COMMENT '角色id',
  `role_name` varchar(100) NOT NULL DEFAULT '' COMMENT '角色名',
  `product_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品id',
  `amount` int(11) NOT NULL DEFAULT '0' COMMENT '订单金额 单位分',
  `server_id` int(11) NOT NULL DEFAULT '0' COMMENT '区服id',
  `is_first` int(11) NOT NULL DEFAULT '0',
  `channel_id` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=76968 DEFAULT CHARSET=utf8mb4 COMMENT='订单表';

-- ----------------------------
-- Table structure for game_server
-- ----------------------------
DROP TABLE IF EXISTS `game_server`;
CREATE TABLE `game_server` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '区服名',
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '状态',
  `ip` varchar(50) NOT NULL DEFAULT '' COMMENT 'ip',
  `port` int(11) NOT NULL DEFAULT '0' COMMENT '端口',
  `tag` int(11) NOT NULL DEFAULT '1' COMMENT '标识',
  `tips` varchar(1000) NOT NULL DEFAULT '服务器当前处于维护或关闭状态，请在公告处查询开服时间并耐心等待' COMMENT '公告',
  `white_list` varchar(1000) NOT NULL DEFAULT '',
  `open_time` int(11) NOT NULL DEFAULT '0' COMMENT '开区时间',
  `db_name` varchar(255) DEFAULT NULL,
  `megre_server` int(11) NOT NULL DEFAULT '0' COMMENT '合服区服id',
  `wss` varchar(255) DEFAULT NULL,
  `sid` int(11) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8mb4 COMMENT='区服表';

-- ----------------------------
-- Table structure for game_version
-- ----------------------------
DROP TABLE IF EXISTS `game_version`;
CREATE TABLE `game_version` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `version` varchar(50) NOT NULL DEFAULT '' COMMENT '版本',
  `download_url` varchar(100) NOT NULL DEFAULT '' COMMENT '下载链接',
  `tag` varchar(50) NOT NULL DEFAULT 'default' COMMENT '标识',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='游戏版本';

-- ----------------------------
-- Table structure for mail_logs
-- ----------------------------
DROP TABLE IF EXISTS `mail_logs`;
CREATE TABLE `mail_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `item` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '道具id',
  `mail_type` int(11) NOT NULL DEFAULT '1' COMMENT '邮件类型',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色列表',
  `server_id` int(11) NOT NULL COMMENT '服务器id',
  `gold` int(11) NOT NULL DEFAULT '0' COMMENT '元宝',
  `exp` int(11) NOT NULL DEFAULT '0' COMMENT '经验',
  `reward` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '奖励数据',
  `ger` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '武将',
  `range` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '等级区间',
  `desc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `content` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邮件内容',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=460 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for password_resets
-- ----------------------------
DROP TABLE IF EXISTS `password_resets`;
CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`),
  KEY `password_resets_token_index` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for remain_data
-- ----------------------------
DROP TABLE IF EXISTS `remain_data`;
CREATE TABLE `remain_data` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `add_user_num` int(11) NOT NULL DEFAULT '0' COMMENT '新增用户数',
  `remain_rate_2` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_2_num` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_3` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_3_num` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_4` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_4_num` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_5` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_5_num` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_6` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_6_num` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_7` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_7_num` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_10` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_10_num` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_15` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_15_num` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_20` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_20_num` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_25` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_25_num` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_30` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_30_num` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_45` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_45_num` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_60` double(8,2) NOT NULL DEFAULT '0.00',
  `remain_rate_60_num` double(8,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  KEY `remain_data_date_index` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for system_config
-- ----------------------------
DROP TABLE IF EXISTS `system_config`;
CREATE TABLE `system_config` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  KEY `system_config_key_index` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for test_servrer
-- ----------------------------
DROP TABLE IF EXISTS `test_servrer`;
CREATE TABLE `test_servrer` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '区服名',
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '状态',
  `ip` varchar(50) NOT NULL DEFAULT '' COMMENT 'ip',
  `port` int(11) NOT NULL DEFAULT '0' COMMENT '端口',
  `tag` varchar(50) NOT NULL DEFAULT 'default' COMMENT '标识',
  `tips` varchar(1000) NOT NULL DEFAULT '' COMMENT '公告',
  `white_list` varchar(1000) NOT NULL DEFAULT '',
  `open_time` int(11) NOT NULL DEFAULT '0' COMMENT '开区时间',
  `db_name` varchar(255) DEFAULT NULL,
  `megre_server` int(11) NOT NULL DEFAULT '0' COMMENT '合服区服id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='区服表';

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

SET FOREIGN_KEY_CHECKS = 1;
