/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 50744 Source Host : localhost:3306 Source Schema : thinkphp6_template Target Server Type : MySQL Target Server Version : 50744 File Encoding : 65001 Date: 18/09/2025 15:02:40 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for tb_admin -- ---------------------------- DROP TABLE IF EXISTS `tb_admin`; CREATE TABLE `tb_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码', `rule_id` int(11) NOT NULL COMMENT '权限组id', `created_at` int(11) NULL DEFAULT NULL COMMENT '创建时间', `updated_at` int(11) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_admin_login_log -- ---------------------------- DROP TABLE IF EXISTS `tb_admin_login_log`; CREATE TABLE `tb_admin_login_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `user_agent` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `created_at` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 108 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_admin_token -- ---------------------------- DROP TABLE IF EXISTS `tb_admin_token`; CREATE TABLE `tb_admin_token` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `expired_at` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 103 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_cdkey -- ---------------------------- DROP TABLE IF EXISTS `tb_cdkey`; CREATE TABLE `tb_cdkey` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cdkey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '兑换码', `game_id` int(11) NOT NULL COMMENT '游戏ID', `expired_at` int(11) NOT NULL COMMENT '过期时间', `user_id` int(11) NULL DEFAULT NULL COMMENT '使用兑换码用户ID', `state` int(11) NOT NULL COMMENT '状态 0:未使用 1:已使用 2:已过期', `use_at` int(11) NULL DEFAULT NULL COMMENT '使用时间', `created_at` int(11) NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_email_captcha -- ---------------------------- DROP TABLE IF EXISTS `tb_email_captcha`; CREATE TABLE `tb_email_captcha` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', `event` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '事件', `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '邮箱', `code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '验证码', `times` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '验证次数', `ip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'IP', `createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 328 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '邮箱验证码表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_feedback -- ---------------------------- DROP TABLE IF EXISTS `tb_feedback`; CREATE TABLE `tb_feedback` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID', `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '投诉/建议内容', `reply_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '回复内容', `is_reply` int(11) NULL DEFAULT 0 COMMENT '是否回复 0未回复 1已回复', `create_at` int(11) NULL DEFAULT NULL COMMENT '创建时间', `update_at` int(11) NULL DEFAULT NULL COMMENT '回复时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '投诉反馈建议表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_forum_category -- ---------------------------- DROP TABLE IF EXISTS `tb_forum_category`; CREATE TABLE `tb_forum_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category_id` int(255) NOT NULL COMMENT '分类id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '版块名称', `description` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '版块描述', `image_url` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '图片URL', `admin_id` int(11) NOT NULL COMMENT '版主用户ID', `priority` int(11) NOT NULL COMMENT '排序优先级，越小越靠前', `created_at` int(11) NULL DEFAULT NULL COMMENT '创建时间', `updated_at` int(11) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_forum_category_notice -- ---------------------------- DROP TABLE IF EXISTS `tb_forum_category_notice`; CREATE TABLE `tb_forum_category_notice` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `category_id` int(11) NOT NULL COMMENT '版块ID', `notice_url` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告URL', `created_at` int(11) NOT NULL COMMENT '创建时间', `updated_at` int(11) NOT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_forum_thread_category -- ---------------------------- DROP TABLE IF EXISTS `tb_forum_thread_category`; CREATE TABLE `tb_forum_thread_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category_id` int(11) NOT NULL COMMENT '版块ID', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类标题', `created_at` int(11) NOT NULL COMMENT '创建时间', `updated_at` int(11) NOT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_friend -- ---------------------------- DROP TABLE IF EXISTS `tb_friend`; CREATE TABLE `tb_friend` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户ID', `friend_id` int(11) NOT NULL COMMENT '好友用户ID', `state` int(11) NOT NULL COMMENT '状态 0:等待验证 1:已通过 2:已拒绝', `msg` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '好友验证消息', `created_at` int(11) NOT NULL COMMENT '创建时间', `updated_at` int(11) NOT NULL COMMENT '更新时间', `expired_at` int(11) NOT NULL COMMENT '验证过期时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_fuzhu -- ---------------------------- DROP TABLE IF EXISTS `tb_fuzhu`; CREATE TABLE `tb_fuzhu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '辅助标题', `image_url` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '辅助图标图片URL', `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '辅助版本', `file_size` int(11) NOT NULL COMMENT '辅助文件大小(字节)', `language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '辅助语言', `game` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '游戏名称', `type` int(11) NOT NULL COMMENT '授权类型 0:免费辅助 1:收费辅助', `priority` int(11) NOT NULL COMMENT '排序优先级，越小越靠前原则', `rate` int(11) NOT NULL COMMENT '评分星星数，最多5分', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '辅助详细描述', `download_url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '下载地址URL', `created_at` int(11) NOT NULL COMMENT '创建时间', `updated_at` int(11) NOT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_fuzhu_download -- ---------------------------- DROP TABLE IF EXISTS `tb_fuzhu_download`; CREATE TABLE `tb_fuzhu_download` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fuzhu_id` int(11) NOT NULL COMMENT '辅助ID', `user_id` int(11) NOT NULL COMMENT '用户ID', `created_at` int(11) NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_fuzhu_vote -- ---------------------------- DROP TABLE IF EXISTS `tb_fuzhu_vote`; CREATE TABLE `tb_fuzhu_vote` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户ID', `fuzhu_id` int(11) NOT NULL COMMENT '辅助ID', `value` int(11) NOT NULL COMMENT '投票值 0:踩 1:赞', `created_at` int(11) NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_game -- ---------------------------- DROP TABLE IF EXISTS `tb_game`; CREATE TABLE `tb_game` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category` int(11) NOT NULL COMMENT '分类ID', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品标题', `image_url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '图片URL', `price` float NOT NULL COMMENT '价格', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '描述', `priority` int(11) NOT NULL COMMENT '优先级，越小越靠前', `browse` int(11) NOT NULL COMMENT '浏览次数', `buy_count` int(11) NOT NULL COMMENT '购买次数', `game_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '游戏版本', `language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '游戏语言', `download_url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '下载链接', `extracted_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '提取码', `created_at` int(11) NOT NULL, `updated_at` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_game_bind_record -- ---------------------------- DROP TABLE IF EXISTS `tb_game_bind_record`; CREATE TABLE `tb_game_bind_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户ID', `game_id` int(11) NOT NULL COMMENT '游戏ID', `machine_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '机器码', `created_at` int(11) NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_game_category -- ---------------------------- DROP TABLE IF EXISTS `tb_game_category`; CREATE TABLE `tb_game_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `image_url` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `priority` int(11) NOT NULL COMMENT '优先级，越大排名越靠前', `created_at` int(11) NOT NULL COMMENT '创建时间', `updated_at` int(11) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_game_machine -- ---------------------------- DROP TABLE IF EXISTS `tb_game_machine`; CREATE TABLE `tb_game_machine` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户ID', `game_id` int(11) NOT NULL COMMENT '游戏ID', `machine_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '机器码', `created_at` int(11) NOT NULL COMMENT '创建时间', `expired_at` int(11) NOT NULL COMMENT '到期时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_global_config -- ---------------------------- DROP TABLE IF EXISTS `tb_global_config`; CREATE TABLE `tb_global_config` ( `id` int(11) NOT NULL AUTO_INCREMENT, `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '配置名称', `value` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '配置值', `description` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '配置描述', `create_at` int(11) NULL DEFAULT NULL COMMENT '创建时间', `update_at` int(11) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '全局配置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_kefu -- ---------------------------- DROP TABLE IF EXISTS `tb_kefu`; CREATE TABLE `tb_kefu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `jump_url` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `type` int(11) NOT NULL COMMENT '客服类型: 1:QQ客服 2:微信客服 3:Telegram客服', `created_at` int(11) NULL DEFAULT NULL, `updated_at` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_message -- ---------------------------- DROP TABLE IF EXISTS `tb_message`; CREATE TABLE `tb_message` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `from_uid` int(11) NOT NULL COMMENT '来自用户ID', `to_uid` int(11) NOT NULL COMMENT '发送到用户ID', `msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消息内容', `is_read` int(11) NOT NULL COMMENT '是否已读1:已读 0:未读', `created_at` int(11) NOT NULL COMMENT '创建时间', `read_at` int(11) NULL DEFAULT NULL COMMENT '读取时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_search_keywords -- ---------------------------- DROP TABLE IF EXISTS `tb_search_keywords`; CREATE TABLE `tb_search_keywords` ( `id` int(11) NOT NULL AUTO_INCREMENT, `keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `created_at` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 761 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_system_avatar -- ---------------------------- DROP TABLE IF EXISTS `tb_system_avatar`; CREATE TABLE `tb_system_avatar` ( `id` int(11) NOT NULL AUTO_INCREMENT, `image_url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '图片URL', `created_at` int(11) NULL DEFAULT NULL COMMENT '创建时间', `updated_at` int(11) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_thread -- ---------------------------- DROP TABLE IF EXISTS `tb_thread`; CREATE TABLE `tb_thread` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category_id` int(11) NOT NULL COMMENT '版块ID', `thread_category` int(11) NOT NULL COMMENT '帖子分类ID', `user_id` int(11) NOT NULL COMMENT '用户ID', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '帖子标题', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '帖子内容', `browse` int(11) NOT NULL COMMENT '浏览次数', `created_at` int(11) NOT NULL COMMENT '创建时间', `updated_at` int(11) NOT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_thread_reply -- ---------------------------- DROP TABLE IF EXISTS `tb_thread_reply`; CREATE TABLE `tb_thread_reply` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户ID', `thread_id` int(11) NOT NULL COMMENT '帖子ID', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '内容', `created_at` int(11) NOT NULL COMMENT '创建时间', `updated_at` int(11) NOT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_thread_visit -- ---------------------------- DROP TABLE IF EXISTS `tb_thread_visit`; CREATE TABLE `tb_thread_visit` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户ID，如果登录后访问，显示用户ID，访客显示0', `is_user` int(11) NOT NULL COMMENT '是否注册会员 1:是 0:不是', `created_at` int(11) NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1747 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_user -- ---------------------------- DROP TABLE IF EXISTS `tb_user`; CREATE TABLE `tb_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码', `created_at` int(11) NOT NULL COMMENT '创建时间', `last_login` int(11) NULL DEFAULT NULL COMMENT '上次登录时间', `login_count` int(11) NOT NULL COMMENT '登录次数', `last_login_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上次登录IP', `avatar` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '头像URL', `state` int(11) NOT NULL COMMENT '状态 0:未激活 1:正常 2:封号', `balance` float NOT NULL COMMENT '余额', `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱账号', `mobile` int(11) NULL DEFAULT NULL COMMENT '手机号', `is_email_verified` int(11) NULL DEFAULT NULL COMMENT '邮箱认证状态 0:未认证 1:已认证', `score` int(11) NULL DEFAULT NULL COMMENT '积分数量', `gold` int(11) NULL DEFAULT NULL COMMENT '金币数量', `exp` int(11) NOT NULL COMMENT '经验值', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_user_balance_record -- ---------------------------- DROP TABLE IF EXISTS `tb_user_balance_record`; CREATE TABLE `tb_user_balance_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `amount` int(11) NOT NULL, `created_at` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_user_bug -- ---------------------------- DROP TABLE IF EXISTS `tb_user_bug`; CREATE TABLE `tb_user_bug` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID', `type` int(11) NULL DEFAULT NULL COMMENT 'Bug类型 1单机游戏 2收费辅助', `game_id` int(11) NULL DEFAULT NULL COMMENT '游戏ID', `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'Bug反馈正文', `is_reply` int(11) NULL DEFAULT 0 COMMENT '是否回复 0否 1是', `reply_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '回复正文', `create_at` int(11) NULL DEFAULT NULL COMMENT 'Bug反馈时间', `update_at` int(11) NULL DEFAULT NULL COMMENT '回复时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 46 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'Bug反馈表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_user_game -- ---------------------------- DROP TABLE IF EXISTS `tb_user_game`; CREATE TABLE `tb_user_game` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `game_id` int(11) NOT NULL, `price` float NOT NULL COMMENT '购买时价格', `channel` int(11) NOT NULL COMMENT '购买渠道 1:站内直购 2:淘宝 3:拼多多', `created_at` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_user_group -- ---------------------------- DROP TABLE IF EXISTS `tb_user_group`; CREATE TABLE `tb_user_group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户组名称', `level` int(11) NOT NULL COMMENT '等级', `exp` int(11) NOT NULL COMMENT '所需经验值', `created_at` int(11) NOT NULL COMMENT '创建时间', `updated_at` int(11) NOT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_user_login_log -- ---------------------------- DROP TABLE IF EXISTS `tb_user_login_log`; CREATE TABLE `tb_user_login_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户ID', `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登录IP地址', `user_agent` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'USER-AGENT', `created_at` int(11) NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 237 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_user_order -- ---------------------------- DROP TABLE IF EXISTS `tb_user_order`; CREATE TABLE `tb_user_order` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户ID', `order_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单号', `balance` float NOT NULL COMMENT '订单金额', `state` int(11) NOT NULL COMMENT '订单状态 0:待支付 1:已支付 3:订单超时', `created_at` int(11) NOT NULL COMMENT '创建时间', `pay_at` int(11) NULL DEFAULT NULL COMMENT '支付完成时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 63 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_user_token -- ---------------------------- DROP TABLE IF EXISTS `tb_user_token`; CREATE TABLE `tb_user_token` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `user_id` int(11) NOT NULL, `expired_at` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 237 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_user_vip -- ---------------------------- DROP TABLE IF EXISTS `tb_user_vip`; CREATE TABLE `tb_user_vip` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户ID', `type` int(11) NOT NULL COMMENT 'VIP类型 1:铂金VIP 2:钻石VIP', `created_at` int(11) NOT NULL COMMENT '创建时间', `expired_at` int(11) NOT NULL COMMENT '到期时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_user_vip_price -- ---------------------------- DROP TABLE IF EXISTS `tb_user_vip_price`; CREATE TABLE `tb_user_vip_price` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户ID', `type` int(11) NOT NULL COMMENT '类型', `duration` int(11) NOT NULL COMMENT '购买周期', `price` int(11) NOT NULL COMMENT '价格', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_user_vip_record -- ---------------------------- DROP TABLE IF EXISTS `tb_user_vip_record`; CREATE TABLE `tb_user_vip_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户ID', `price` int(11) NOT NULL COMMENT '购买时价格', `type` int(11) NOT NULL COMMENT 'VIP类型：1:铂金VIP 2:钻石VIP', `duration` int(11) NOT NULL COMMENT '购买周期（月）', `start_time` int(11) NOT NULL COMMENT '开始时间', `expired_at` int(11) NOT NULL COMMENT '到期时间', `created_at` int(11) NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_website_visit -- ---------------------------- DROP TABLE IF EXISTS `tb_website_visit`; CREATE TABLE `tb_website_visit` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `ip_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'IP地址', `is_user` int(11) NOT NULL COMMENT '是否注册用户', `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID，如没有为NULL', `user_agent` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'user-agent', `created_at` int(11) NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1683 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1;