1646 lines
105 KiB
SQL
1646 lines
105 KiB
SQL
/*
|
||
Navicat Premium Dump SQL
|
||
|
||
Source Server : 世博头条测试数据库-亚马逊
|
||
Source Server Type : MySQL
|
||
Source Server Version : 80035 (8.0.35)
|
||
Source Host : 95.40.220.223:3300
|
||
Source Schema : sbnews
|
||
|
||
Target Server Type : MySQL
|
||
Target Server Version : 80035 (8.0.35)
|
||
File Encoding : 65001
|
||
|
||
Date: 23/04/2026 19:29:02
|
||
*/
|
||
|
||
SET NAMES utf8mb4;
|
||
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_admin
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_admin`;
|
||
CREATE TABLE `la_admin` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`root` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否超级管理员 0-否 1-是',
|
||
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
|
||
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户头像',
|
||
`account` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '账号',
|
||
`password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
|
||
`login_time` int NULL DEFAULT NULL COMMENT '最后登录时间',
|
||
`login_ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '最后登录ip',
|
||
`multipoint_login` tinyint UNSIGNED NULL DEFAULT 1 COMMENT '是否支持多处登录：1-是；0-否；',
|
||
`disable` tinyint UNSIGNED NULL DEFAULT 0 COMMENT '是否禁用：0-否；1-是；',
|
||
`create_time` int NOT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '修改时间',
|
||
`delete_time` int NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理员表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_admin_dept
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_admin_dept`;
|
||
CREATE TABLE `la_admin_dept` (
|
||
`admin_id` int NOT NULL DEFAULT 0 COMMENT '管理员id',
|
||
`dept_id` int NOT NULL DEFAULT 0 COMMENT '部门id',
|
||
PRIMARY KEY (`admin_id`, `dept_id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门关联表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_admin_jobs
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_admin_jobs`;
|
||
CREATE TABLE `la_admin_jobs` (
|
||
`admin_id` int NOT NULL COMMENT '管理员id',
|
||
`jobs_id` int NOT NULL COMMENT '岗位id',
|
||
PRIMARY KEY (`admin_id`, `jobs_id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '岗位关联表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_admin_role
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_admin_role`;
|
||
CREATE TABLE `la_admin_role` (
|
||
`admin_id` int NOT NULL COMMENT '管理员id',
|
||
`role_id` int NOT NULL COMMENT '角色id',
|
||
PRIMARY KEY (`admin_id`, `role_id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色关联表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_admin_session
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_admin_session`;
|
||
CREATE TABLE `la_admin_session` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`admin_id` int UNSIGNED NOT NULL COMMENT '用户id',
|
||
`terminal` tinyint(1) NOT NULL DEFAULT 1 COMMENT '客户端类型：1-pc管理后台 2-mobile手机管理后台',
|
||
`token` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '令牌',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '更新时间',
|
||
`expire_time` int NOT NULL COMMENT '到期时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `admin_id_client`(`admin_id` ASC, `terminal` ASC) USING BTREE COMMENT '一个用户在一个终端只有一个token',
|
||
UNIQUE INDEX `token`(`token` ASC) USING BTREE COMMENT 'token是唯一的'
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理员会话表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_ai_analysis
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_ai_analysis`;
|
||
CREATE TABLE `la_ai_analysis` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`type` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '1赛事预测 2资讯分析 3用户可信度 4彩票分析',
|
||
`ref_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '关联ID(match_id/article_id/user_id)',
|
||
`prompt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '发送的prompt',
|
||
`result` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT 'AI返回结果JSON',
|
||
`model` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '使用模型',
|
||
`tokens_used` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '消耗token数',
|
||
`status` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '1成功 2失败 3处理中',
|
||
`error_msg` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '错误信息',
|
||
`expire_time` int UNSIGNED NULL DEFAULT NULL COMMENT '过期时间',
|
||
`create_time` int UNSIGNED NULL DEFAULT NULL,
|
||
`update_time` int UNSIGNED NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_type_ref`(`type` ASC, `ref_id` ASC) USING BTREE,
|
||
INDEX `idx_expire`(`expire_time` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 72 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'AI分析结果缓存表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_ai_config
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_ai_config`;
|
||
CREATE TABLE `la_ai_config` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '配置名',
|
||
`value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '配置值',
|
||
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '备注',
|
||
`create_time` int UNSIGNED NULL DEFAULT NULL,
|
||
`update_time` int UNSIGNED NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_name`(`name` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'AI配置表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_ai_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_ai_log`;
|
||
CREATE TABLE `la_ai_log` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`user_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '请求用户ID',
|
||
`type` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '1赛事预测 2资讯分析 3用户可信度 4彩票分析',
|
||
`ref_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '关联ID',
|
||
`tokens_used` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '消耗token数',
|
||
`cost_ms` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '耗时(毫秒)',
|
||
`status` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '1成功 2失败',
|
||
`create_time` int UNSIGNED NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_user_id`(`user_id` ASC) USING BTREE,
|
||
INDEX `idx_type`(`type` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 72 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'AI调用日志表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_ai_unlock
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_ai_unlock`;
|
||
CREATE TABLE `la_ai_unlock` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`user_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
|
||
`match_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '赛事ID',
|
||
`create_time` int UNSIGNED NULL DEFAULT NULL COMMENT '解锁时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_user_match`(`user_id` ASC, `match_id` ASC) USING BTREE,
|
||
INDEX `idx_user_id`(`user_id` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'AI分析解锁记录' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_article
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_article`;
|
||
CREATE TABLE `la_article` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '文章id',
|
||
`article_id` int NOT NULL DEFAULT 0 COMMENT '懂球帝文章ID',
|
||
`cid` int NOT NULL COMMENT '文章分类',
|
||
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章标题',
|
||
`desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '简介',
|
||
`abstract` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '文章摘要',
|
||
`image` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文章图片',
|
||
`thumb` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '缩略图',
|
||
`is_video` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '0图文1视频',
|
||
`duration` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '视频时长',
|
||
`video_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '视频地址',
|
||
`author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '作者',
|
||
`published_at` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '发布时间',
|
||
`category` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '分类',
|
||
`source_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '原文链接',
|
||
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '文章内容',
|
||
`content_retry` tinyint NOT NULL DEFAULT 0 COMMENT '正文抓取重试次数，>=3则永久跳过',
|
||
`ext` json NULL COMMENT '原始扩展数据',
|
||
`click_virtual` int NULL DEFAULT 0 COMMENT '虚拟浏览量',
|
||
`click_actual` int NULL DEFAULT 0 COMMENT '实际浏览量',
|
||
`like_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '点赞数',
|
||
`dislike_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '踩数',
|
||
`comment_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '评论数',
|
||
`is_show` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否显示:1-是.0-否',
|
||
`is_recommend` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否推荐 0否 1是',
|
||
`sort` int NULL DEFAULT 0 COMMENT '排序',
|
||
`create_time` int NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '更新时间',
|
||
`delete_time` int NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_article_id`(`article_id` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 302008 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文章表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_article_cate
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_article_cate`;
|
||
CREATE TABLE `la_article_cate` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '文章分类id',
|
||
`pid` int NOT NULL DEFAULT 0 COMMENT '父级id',
|
||
`name` varchar(90) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类名称',
|
||
`sort` int NULL DEFAULT 0 COMMENT '排序',
|
||
`is_show` tinyint(1) NULL DEFAULT 1 COMMENT '是否显示:1-是;0-否',
|
||
`create_time` int NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '更新时间',
|
||
`delete_time` int NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文章分类表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_article_collect
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_article_collect`;
|
||
CREATE TABLE `la_article_collect` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`user_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
|
||
`article_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '文章ID',
|
||
`status` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '收藏状态 0-未收藏 1-已收藏',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
|
||
`update_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
|
||
`delete_time` int NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文章收藏表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_article_comment
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_article_comment`;
|
||
CREATE TABLE `la_article_comment` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`article_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '文章ID',
|
||
`user_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
|
||
`parent_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '父评论ID(0为一级评论)',
|
||
`reply_user_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '回复目标用户ID',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '评论内容',
|
||
`like_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '点赞数',
|
||
`is_show` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否显示',
|
||
`create_time` int UNSIGNED NULL DEFAULT NULL,
|
||
`update_time` int UNSIGNED NULL DEFAULT NULL,
|
||
`delete_time` int UNSIGNED NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_article_id`(`article_id` ASC) USING BTREE,
|
||
INDEX `idx_user_id`(`user_id` ASC) USING BTREE,
|
||
INDEX `idx_parent_id`(`parent_id` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '文章评论表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_article_vote
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_article_vote`;
|
||
CREATE TABLE `la_article_vote` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`article_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '文章ID',
|
||
`user_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
|
||
`vote_type` tinyint NOT NULL DEFAULT 1 COMMENT '1点赞 2踩',
|
||
`create_time` int UNSIGNED NULL DEFAULT NULL,
|
||
`update_time` int UNSIGNED NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_article_user`(`article_id` ASC, `user_id` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '文章投票表(点赞/踩)' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_community_comment
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_community_comment`;
|
||
CREATE TABLE `la_community_comment` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`post_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '帖子ID',
|
||
`user_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '评论用户ID',
|
||
`parent_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '父评论ID(0为一级评论)',
|
||
`reply_user_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '回复目标用户ID',
|
||
`content` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '评论内容',
|
||
`like_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '点赞数',
|
||
`status` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '0待审核1正常2隐藏',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
`delete_time` int UNSIGNED NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_post`(`post_id` ASC) USING BTREE,
|
||
INDEX `idx_user`(`user_id` ASC) USING BTREE,
|
||
INDEX `idx_parent`(`parent_id` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '评论' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_community_follow
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_community_follow`;
|
||
CREATE TABLE `la_community_follow` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`user_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '关注者',
|
||
`follow_user_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '被关注者',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_follow`(`user_id` ASC, `follow_user_id` ASC) USING BTREE,
|
||
INDEX `idx_user`(`user_id` ASC) USING BTREE,
|
||
INDEX `idx_follow`(`follow_user_id` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '关注' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_community_like
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_community_like`;
|
||
CREATE TABLE `la_community_like` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`user_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
|
||
`target_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '目标ID',
|
||
`target_type` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '1帖子2评论',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_user_target`(`user_id` ASC, `target_id` ASC, `target_type` ASC) USING BTREE,
|
||
INDEX `idx_target`(`target_id` ASC, `target_type` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '点赞' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_community_post
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_community_post`;
|
||
CREATE TABLE `la_community_post` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`origin_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '来源标识:原始ID，如 truthsocial:123456',
|
||
`user_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '帖子内容',
|
||
`images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '图片地址JSON数组',
|
||
`post_type` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '0普通帖1赛事推荐2战绩分享',
|
||
`match_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '关联赛事ID(推荐帖)',
|
||
`is_paid` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '0免费1付费',
|
||
`price_points` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '所需积分',
|
||
`free_content_len` int UNSIGNED NOT NULL DEFAULT 100 COMMENT '免费预览字数',
|
||
`paid_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '已购买人数',
|
||
`view_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '浏览数',
|
||
`like_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '点赞数',
|
||
`comment_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '评论数',
|
||
`share_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '分享数',
|
||
`ext` json NULL COMMENT '原始扩展数据',
|
||
`is_top` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '0否1置顶',
|
||
`is_hot` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '0否1热门',
|
||
`is_recommend` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否推荐 0否 1是',
|
||
`status` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '0待审核1正常2隐藏',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
`update_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
`delete_time` int UNSIGNED NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `idx_origin_id`(`origin_id` ASC) USING BTREE,
|
||
INDEX `idx_user`(`user_id` ASC) USING BTREE,
|
||
INDEX `idx_type`(`post_type` ASC) USING BTREE,
|
||
INDEX `idx_status`(`status` ASC) USING BTREE,
|
||
INDEX `idx_create`(`create_time` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 331 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '社区帖子' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_community_post_image
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_community_post_image`;
|
||
CREATE TABLE `la_community_post_image` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`post_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '帖子ID',
|
||
`image_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图片地址',
|
||
`sort` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_post`(`post_id` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 82 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '帖子图片' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_community_post_purchase
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_community_post_purchase`;
|
||
CREATE TABLE `la_community_post_purchase` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`user_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '购买用户',
|
||
`post_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '帖子ID',
|
||
`points` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '消费积分',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '购买时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_user_post`(`user_id` ASC, `post_id` ASC) USING BTREE,
|
||
INDEX `idx_post`(`post_id` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '帖子购买记录' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_community_post_tag
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_community_post_tag`;
|
||
CREATE TABLE `la_community_post_tag` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`post_id` int UNSIGNED NOT NULL DEFAULT 0,
|
||
`tag_id` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_post_tag`(`post_id` ASC, `tag_id` ASC) USING BTREE,
|
||
INDEX `idx_tag`(`tag_id` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 273 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '帖子标签关联' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_community_tag
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_community_tag`;
|
||
CREATE TABLE `la_community_tag` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '标签名',
|
||
`icon` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图标',
|
||
`sort` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
|
||
`post_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '帖子数',
|
||
`is_hot` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '0否1热门',
|
||
`status` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '0禁用1启用',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_name`(`name` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '标签' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_config
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_config`;
|
||
CREATE TABLE `la_config` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型',
|
||
`name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
|
||
`value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '值',
|
||
`create_time` int NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '配置表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_crawl_error_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_crawl_error_log`;
|
||
CREATE TABLE `la_crawl_error_log` (
|
||
`id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`task_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
|
||
`request_url` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
|
||
`request_method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'GET',
|
||
`request_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
||
`http_status` int NOT NULL DEFAULT 0,
|
||
`error_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
|
||
`error_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
||
`response_body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
||
`channel` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
|
||
`notified` tinyint NOT NULL DEFAULT 0,
|
||
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_notified`(`notified` ASC) USING BTREE,
|
||
INDEX `idx_task_created`(`task_name` ASC, `created_at` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '爬虫请求错误日志' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_crawl_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_crawl_log`;
|
||
CREATE TABLE `la_crawl_log` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增ID',
|
||
`crawl_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '爬取类型',
|
||
`match_type_id` int NULL DEFAULT NULL COMMENT '比赛类型ID',
|
||
`api_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'API地址',
|
||
`status_code` int NULL DEFAULT NULL COMMENT 'HTTP状态码',
|
||
`response_size` int NULL DEFAULT NULL COMMENT '响应大小',
|
||
`response_time` float NULL DEFAULT NULL COMMENT '响应时间(秒)',
|
||
`success` tinyint NULL DEFAULT 0 COMMENT '是否成功',
|
||
`error_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '错误信息',
|
||
`match_count` int NULL DEFAULT 0 COMMENT '爬取到的比赛数量',
|
||
`crawler_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '爬虫IP',
|
||
`user_agent` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'User-Agent',
|
||
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_crawl_type`(`crawl_type` ASC) USING BTREE,
|
||
INDEX `idx_match_type`(`match_type_id` ASC) USING BTREE,
|
||
INDEX `idx_success`(`success` ASC) USING BTREE,
|
||
INDEX `idx_created_at`(`created_at` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 82734 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '爬取日志表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_crawl_task
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_crawl_task`;
|
||
CREATE TABLE `la_crawl_task` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增ID',
|
||
`task_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务ID',
|
||
`task_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务类型',
|
||
`match_type_id` int NULL DEFAULT NULL COMMENT '比赛类型ID',
|
||
`api_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'API地址',
|
||
`status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'pending' COMMENT '任务状态',
|
||
`priority` int NULL DEFAULT 0 COMMENT '优先级',
|
||
`retry_count` int NULL DEFAULT 0 COMMENT '重试次数',
|
||
`max_retries` int NULL DEFAULT 3 COMMENT '最大重试次数',
|
||
`worker_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '工作节点ID',
|
||
`started_at` timestamp NULL DEFAULT NULL COMMENT '开始时间',
|
||
`completed_at` timestamp NULL DEFAULT NULL COMMENT '完成时间',
|
||
`result` json NULL COMMENT '任务结果',
|
||
`error_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '错误信息',
|
||
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_task_id`(`task_id` ASC) USING BTREE,
|
||
INDEX `idx_task_type`(`task_type` ASC) USING BTREE,
|
||
INDEX `idx_status`(`status` ASC) USING BTREE,
|
||
INDEX `idx_priority`(`priority` ASC) USING BTREE,
|
||
INDEX `idx_created_at`(`created_at` ASC) USING BTREE,
|
||
INDEX `idx_worker_id`(`worker_id` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '爬取任务表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_decorate_page
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_decorate_page`;
|
||
CREATE TABLE `la_decorate_page` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`type` tinyint UNSIGNED NOT NULL DEFAULT 10 COMMENT '页面类型 1=商城首页, 2=个人中心, 3=客服设置 4-PC首页',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '页面名称',
|
||
`data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '页面数据',
|
||
`meta` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '页面设置',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
|
||
`update_time` int UNSIGNED NOT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '装修页面配置表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_decorate_tabbar
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_decorate_tabbar`;
|
||
CREATE TABLE `la_decorate_tabbar` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '导航名称',
|
||
`selected` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '未选图标',
|
||
`unselected` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '已选图标',
|
||
`link` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '链接地址',
|
||
`is_show` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '显示状态',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
|
||
`update_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 73 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '装修底部导航表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_dept
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_dept`;
|
||
CREATE TABLE `la_dept` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '部门名称',
|
||
`pid` bigint NOT NULL DEFAULT 0 COMMENT '上级部门id',
|
||
`sort` int NOT NULL DEFAULT 0 COMMENT '排序',
|
||
`leader` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人',
|
||
`mobile` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话',
|
||
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '部门状态（0停用 1正常）',
|
||
`create_time` int NOT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '修改时间',
|
||
`delete_time` int NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_dev_crontab
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_dev_crontab`;
|
||
CREATE TABLE `la_dev_crontab` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '定时任务名称',
|
||
`type` tinyint(1) NOT NULL COMMENT '类型 1-定时任务',
|
||
`system` tinyint NULL DEFAULT 0 COMMENT '是否系统任务 0-否 1-是',
|
||
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
|
||
`command` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '命令内容',
|
||
`params` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '参数',
|
||
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 1-运行 2-停止 3-错误',
|
||
`expression` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '运行规则',
|
||
`error` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '运行失败原因',
|
||
`last_time` int NULL DEFAULT NULL COMMENT '最后执行时间',
|
||
`time` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '实时执行时长',
|
||
`max_time` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '最大执行时长',
|
||
`create_time` int NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '更新时间',
|
||
`delete_time` int NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '计划任务表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_dev_crontab_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_dev_crontab_log`;
|
||
CREATE TABLE `la_dev_crontab_log` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`crontab_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '任务ID',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '任务名称',
|
||
`command` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '执行命令',
|
||
`params` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '参数',
|
||
`status` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '0执行中 1成功 2失败',
|
||
`output` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '执行输出',
|
||
`elapsed` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '执行耗时(秒)',
|
||
`trigger_type` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '1自动 2手动',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_crontab_id`(`crontab_id` ASC) USING BTREE,
|
||
INDEX `idx_create_time`(`create_time` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 104519 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '定时任务执行日志' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_dev_pay_config
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_dev_pay_config`;
|
||
CREATE TABLE `la_dev_pay_config` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '模版名称',
|
||
`pay_way` tinyint(1) NOT NULL COMMENT '支付方式:1-余额支付;2-微信支付;3-支付宝支付;',
|
||
`config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '对应支付配置(json字符串)',
|
||
`icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图标',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序',
|
||
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付配置表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_dev_pay_way
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_dev_pay_way`;
|
||
CREATE TABLE `la_dev_pay_way` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`pay_config_id` int NOT NULL COMMENT '支付配置ID',
|
||
`scene` tinyint(1) NOT NULL COMMENT '场景:1-微信小程序;2-微信公众号;3-H5;4-PC;5-APP;',
|
||
`is_default` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否默认支付:0-否;1-是;',
|
||
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态:0-关闭;1-开启;',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付方式表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_dict_data
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_dict_data`;
|
||
CREATE TABLE `la_dict_data` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '数据名称',
|
||
`value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '数据值',
|
||
`type_id` int NOT NULL COMMENT '字典类型id',
|
||
`type_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典类型',
|
||
`sort` int NULL DEFAULT 0 COMMENT '排序值',
|
||
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0-停用 1-正常',
|
||
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
|
||
`create_time` int NOT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '修改时间',
|
||
`delete_time` int NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字典数据表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_dict_type
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_dict_type`;
|
||
CREATE TABLE `la_dict_type` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字典名称',
|
||
`type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字典类型名称',
|
||
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0-停用 1-正常',
|
||
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
|
||
`create_time` int NOT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '修改时间',
|
||
`delete_time` int 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 la_file
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_file`;
|
||
CREATE TABLE `la_file` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`cid` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '类目ID',
|
||
`source_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '上传者id',
|
||
`source` tinyint(1) NOT NULL DEFAULT 0 COMMENT '来源类型[0-后台,1-用户]',
|
||
`type` tinyint UNSIGNED NOT NULL DEFAULT 10 COMMENT '类型[10=图片, 20=视频]',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件名称',
|
||
`uri` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件路径',
|
||
`create_time` int UNSIGNED NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '更新时间',
|
||
`delete_time` int NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 71 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文件表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_file_cate
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_file_cate`;
|
||
CREATE TABLE `la_file_cate` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`pid` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '父级ID',
|
||
`type` tinyint UNSIGNED NOT NULL DEFAULT 10 COMMENT '类型[10=图片，20=视频，30=文件]',
|
||
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类名称',
|
||
`create_time` int UNSIGNED NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int UNSIGNED NULL DEFAULT NULL COMMENT '更新时间',
|
||
`delete_time` int UNSIGNED NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文件分类表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_generate_column
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_generate_column`;
|
||
CREATE TABLE `la_generate_column` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`table_id` int NOT NULL DEFAULT 0 COMMENT '表id',
|
||
`column_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字段名称',
|
||
`column_comment` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字段描述',
|
||
`column_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字段类型',
|
||
`is_required` tinyint(1) NULL DEFAULT 0 COMMENT '是否必填 0-非必填 1-必填',
|
||
`is_pk` tinyint(1) NULL DEFAULT 0 COMMENT '是否为主键 0-不是 1-是',
|
||
`is_insert` tinyint(1) NULL DEFAULT 0 COMMENT '是否为插入字段 0-不是 1-是',
|
||
`is_update` tinyint(1) NULL DEFAULT 0 COMMENT '是否为更新字段 0-不是 1-是',
|
||
`is_lists` tinyint(1) NULL DEFAULT 0 COMMENT '是否为列表字段 0-不是 1-是',
|
||
`is_query` tinyint(1) NULL DEFAULT 0 COMMENT '是否为查询字段 0-不是 1-是',
|
||
`query_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '=' COMMENT '查询类型',
|
||
`view_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'input' COMMENT '显示类型',
|
||
`dict_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典类型',
|
||
`create_time` int NOT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '修改时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成表字段信息表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_generate_table
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_generate_table`;
|
||
CREATE TABLE `la_generate_table` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`table_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '表名称',
|
||
`table_comment` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '表描述',
|
||
`template_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '模板类型 0-单表(curd) 1-树表(curd)',
|
||
`author` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '作者',
|
||
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
|
||
`generate_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '生成方式 0-压缩包下载 1-生成到模块',
|
||
`module_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '模块名',
|
||
`class_dir` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '类目录名',
|
||
`class_comment` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '类描述',
|
||
`admin_id` int NULL DEFAULT 0 COMMENT '管理员id',
|
||
`menu` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '菜单配置',
|
||
`delete` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '删除配置',
|
||
`tree` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '树表配置',
|
||
`relations` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '关联配置',
|
||
`create_time` int NOT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '修改时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成表信息表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_hot_search
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_hot_search`;
|
||
CREATE TABLE `la_hot_search` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关键词',
|
||
`sort` smallint UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序号',
|
||
`create_time` int NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '热门搜索表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_jobs
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_jobs`;
|
||
CREATE TABLE `la_jobs` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位名称',
|
||
`code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位编码',
|
||
`sort` int NULL DEFAULT 0 COMMENT '显示顺序',
|
||
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态（0停用 1正常）',
|
||
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
|
||
`create_time` int NOT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '修改时间',
|
||
`delete_time` int NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '岗位表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_league
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_league`;
|
||
CREATE TABLE `la_league` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增主键',
|
||
`tab_id` int NOT NULL DEFAULT 0 COMMENT '懂球帝 tab ID（原始 id）',
|
||
`league_id` int NOT NULL DEFAULT 0 COMMENT '懂球帝联赛 ID',
|
||
`label` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '联赛显示名称',
|
||
`type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '类型标识: league/important/lottery',
|
||
`sport_type` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '运动类型: 1=足球 2=篮球 3=网球 4=电竞 5=综合',
|
||
`api` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '懂球帝 API 地址',
|
||
`icon` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
|
||
`sort` int NOT NULL DEFAULT 0 COMMENT '排序权重（越小越靠前）',
|
||
`is_show` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否显示: 0=隐藏 1=显示',
|
||
`extra_data` json NULL COMMENT '额外数据（如 calendar 等）',
|
||
`sessionid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Session ID',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
|
||
`update_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
|
||
`delete_time` int UNSIGNED NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_tab_id`(`tab_id` ASC) USING BTREE,
|
||
INDEX `idx_league_id`(`league_id` ASC) USING BTREE,
|
||
INDEX `idx_type`(`type` ASC) USING BTREE,
|
||
INDEX `idx_sort`(`sort` ASC) USING BTREE,
|
||
INDEX `idx_sport_type`(`sport_type` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 50 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '联赛配置表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_lottery_category
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_lottery_category`;
|
||
CREATE TABLE `la_lottery_category` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '彩种名称',
|
||
`code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '彩种编码(如hk6,mc6)',
|
||
`region` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '地区:hongkong/macau',
|
||
`icon` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图标',
|
||
`description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '描述',
|
||
`draw_rule` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '开奖规则说明',
|
||
`draw_time` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '开奖时间说明',
|
||
`is_show` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否显示',
|
||
`sort` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
`update_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_code`(`code` ASC) USING BTREE,
|
||
INDEX `idx_region`(`region` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '彩票分类表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_lottery_draw
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_lottery_draw`;
|
||
CREATE TABLE `la_lottery_draw` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`category_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '彩种ID',
|
||
`period` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '期号(如2024001)',
|
||
`draw_date` date NOT NULL COMMENT '开奖日期',
|
||
`draw_time` datetime NULL DEFAULT NULL COMMENT '开奖时间',
|
||
`numbers` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '开奖号码(JSON数组)',
|
||
`special_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '特别号码',
|
||
`zodiac` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '生肖(JSON)',
|
||
`elements` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '五行(JSON)',
|
||
`color` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '波色(JSON: red/blue/green)',
|
||
`total_sales` bigint UNSIGNED NOT NULL DEFAULT 0 COMMENT '总销售额(分)',
|
||
`pool_amount` bigint UNSIGNED NOT NULL DEFAULT 0 COMMENT '奖池金额(分)',
|
||
`prize_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '奖项详情(JSON)',
|
||
`status` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '0待开奖 1已开奖',
|
||
`is_show` tinyint UNSIGNED NOT NULL DEFAULT 1,
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
`update_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_category_period`(`category_id` ASC, `period` ASC) USING BTREE,
|
||
INDEX `idx_category_date`(`category_id` ASC, `draw_date` ASC) USING BTREE,
|
||
INDEX `idx_status`(`status` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 165 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '彩票开奖记录表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_lottery_draw_result
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_lottery_draw_result`;
|
||
CREATE TABLE `la_lottery_draw_result` (
|
||
`id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '彩种编码(关联la_lottery_game.code)',
|
||
`issue` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '期号',
|
||
`draw_time` datetime NULL DEFAULT NULL COMMENT '开奖时间',
|
||
`draw_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '开奖号码(逗号分隔)',
|
||
`draw_ext` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '扩展号码(台湾宾果等)',
|
||
`status` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '开奖状态 1已开奖 4停售等',
|
||
`idx` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '当日期数索引(index)',
|
||
`next_issue` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '下期期号',
|
||
`next_time` datetime NULL DEFAULT NULL COMMENT '下期开奖时间',
|
||
`trend` json NULL COMMENT '走势数据(JSON)',
|
||
`s_time` datetime NULL DEFAULT NULL COMMENT '数据同步时间(API sTime)',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
`update_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_code_issue`(`code` ASC, `issue` ASC) USING BTREE,
|
||
INDEX `idx_code_draw_time`(`code` ASC, `draw_time` ASC) USING BTREE,
|
||
INDEX `idx_draw_time`(`draw_time` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 19294849 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '彩种开奖结果表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_lottery_game
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_lottery_game`;
|
||
CREATE TABLE `la_lottery_game` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '彩种编码(如HK6/JISUSC)',
|
||
`template` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '模板类型(HK6/PKS/SSC/KS/KLSF/QG/KLC/PCDD/BINGO/SYXW/YDH)',
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '彩种名称',
|
||
`icon` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图标',
|
||
`status` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '状态 0启用',
|
||
`open_status` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '开奖状态 0正常',
|
||
`category` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '所属分类(关联la_lottery_game_category.value)',
|
||
`group_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '分组ID',
|
||
`open_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '每日开奖期数',
|
||
`sort` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序(order)',
|
||
`has_video` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否有视频开奖',
|
||
`official_website` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '官方网站名称',
|
||
`official_website_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '官方网站URL',
|
||
`is_rnd_num` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否随机号码',
|
||
`has_ft` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT 'hasFT标记',
|
||
`is_show` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否显示',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
`update_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_code`(`code` ASC) USING BTREE,
|
||
INDEX `idx_category`(`category` ASC) USING BTREE,
|
||
INDEX `idx_template`(`template` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 65 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '彩种游戏表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_lottery_game_category
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_lottery_game_category`;
|
||
CREATE TABLE `la_lottery_game_category` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`label` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '分类名称',
|
||
`value` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '分类值(对应API category)',
|
||
`is_show` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否显示',
|
||
`sort` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
`update_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_value`(`value` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '彩种大分类表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_lottery_number_mapping
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_lottery_number_mapping`;
|
||
CREATE TABLE `la_lottery_number_mapping` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`year` smallint UNSIGNED NOT NULL COMMENT '年份',
|
||
`type` tinyint UNSIGNED NOT NULL COMMENT '类型: 1=生肖zodiac 2=波色color 3=五行element',
|
||
`attr_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '属性名称(马/蛇/红波/金...)',
|
||
`attr_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '属性编码(horse/red/jin...)',
|
||
`numbers` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '对应号码JSON数组',
|
||
`sort` smallint UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序(生肖排序等)',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
`update_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_year_type_attr`(`year` ASC, `type` ASC, `attr_name` ASC) USING BTREE,
|
||
INDEX `idx_year_type`(`year` ASC, `type` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '彩票号码映射表(生肖/波色/五行)' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_lottery_region
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_lottery_region`;
|
||
CREATE TABLE `la_lottery_region` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`label` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'Tab显示名',
|
||
`value` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '地区值(all/hongkong/macau)',
|
||
`icon` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图标相对路径',
|
||
`sort` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
|
||
`is_show` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否显示',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
`update_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '彩票地区Tab配置' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_match
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_match`;
|
||
CREATE TABLE `la_match` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`match_id` bigint NOT NULL DEFAULT 0 COMMENT '懂球帝比赛ID',
|
||
`competition_id` int NOT NULL DEFAULT 0 COMMENT '懂球帝赛事ID',
|
||
`home_team_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '主队ID',
|
||
`away_team_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '客队ID',
|
||
`league_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '联赛名称',
|
||
`round_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '场次名称(第5轮/季前赛/半决赛等)',
|
||
`stage` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '赛事阶段(小组赛/淘汰赛/常规赛等)',
|
||
live_url varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '第三方直播链接',
|
||
`league_icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '联赛图标',
|
||
`home_team` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '主队名称',
|
||
`home_icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '主队图标',
|
||
`home_score` smallint NOT NULL DEFAULT 0,
|
||
`away_team` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '客队名称',
|
||
`away_icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '客队图标',
|
||
`away_score` smallint NOT NULL DEFAULT 0,
|
||
`sport_type` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '运动类型 1足球 2篮球 3网球 4电竞',
|
||
`status` tinyint NOT NULL DEFAULT 0 COMMENT '状态 0未开始 1进行中 2已结束 3推迟',
|
||
`match_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '比赛时间戳',
|
||
`current_minute` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '当前比赛分钟(进行中)',
|
||
`half_score` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '半场比分 如 1-0',
|
||
`home_odds` decimal(5, 2) NOT NULL DEFAULT 0.00 COMMENT '主胜赔率',
|
||
`draw_odds` decimal(5, 2) NOT NULL DEFAULT 0.00 COMMENT '平局赔率',
|
||
`away_odds` decimal(5, 2) NOT NULL DEFAULT 0.00 COMMENT '客胜赔率',
|
||
`home_corner` tinyint NOT NULL DEFAULT 0 COMMENT '主队角球',
|
||
`away_corner` tinyint NOT NULL DEFAULT 0 COMMENT '客队角球',
|
||
`home_yellow` tinyint NOT NULL DEFAULT 0 COMMENT '主队黄牌',
|
||
`away_yellow` tinyint NOT NULL DEFAULT 0 COMMENT '客队黄牌',
|
||
`home_red` tinyint NOT NULL DEFAULT 0 COMMENT '主队红牌',
|
||
`away_red` tinyint NOT NULL DEFAULT 0 COMMENT '客队红牌',
|
||
`is_hot` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否热门 0否 1是',
|
||
`is_show` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否显示',
|
||
`sort` int NOT NULL DEFAULT 0 COMMENT '排序',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
`update_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
`delete_time` int UNSIGNED NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_match_id`(`match_id` ASC) USING BTREE,
|
||
INDEX `idx_status`(`status` ASC) USING BTREE,
|
||
INDEX `idx_match_time`(`match_time` ASC) USING BTREE,
|
||
INDEX `idx_sport_type`(`sport_type` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1518218 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '赛事表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_match_data
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_match_data`;
|
||
CREATE TABLE `la_match_data` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增ID',
|
||
`match_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '比赛ID',
|
||
`relate_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'match' COMMENT '关联类型',
|
||
`relate_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '关联ID',
|
||
`team_A_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主队ID',
|
||
`team_A_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主队名称',
|
||
`team_A_logo` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '主队logo',
|
||
`team_B_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '客队ID',
|
||
`team_B_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '客队名称',
|
||
`team_B_logo` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '客队logo',
|
||
`date_utc` date NOT NULL COMMENT '比赛日期',
|
||
`time_utc` time NULL DEFAULT NULL COMMENT '比赛时间',
|
||
`start_play` datetime NULL DEFAULT NULL COMMENT '开始时间',
|
||
`end_play` datetime NULL DEFAULT NULL COMMENT '结束时间',
|
||
`sort_timestamp` int NULL DEFAULT NULL COMMENT '排序时间戳',
|
||
`status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '比赛状态',
|
||
`fs_A` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '主队分数',
|
||
`fs_B` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '客队分数',
|
||
`competition_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '赛事ID',
|
||
`competition_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '赛事名称',
|
||
`competition_color` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '赛事颜色',
|
||
`round_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '轮次名称',
|
||
`gameweek` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '比赛周',
|
||
`playing_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '进行时间',
|
||
`minute` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '分钟',
|
||
`minute_period` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '时段',
|
||
`match_type_id` int NULL DEFAULT NULL COMMENT '比赛类型ID',
|
||
`match_type_label` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '比赛类型标签',
|
||
`raw_data` json NULL COMMENT '原始数据',
|
||
`crawl_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '爬取时间',
|
||
`match_date` date GENERATED ALWAYS AS (cast(`start_play` as date)) STORED COMMENT '比赛日期(生成列)' NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_match_id`(`match_id` ASC) USING BTREE,
|
||
INDEX `idx_team_A`(`team_A_id` ASC) USING BTREE,
|
||
INDEX `idx_team_B`(`team_B_id` ASC) USING BTREE,
|
||
INDEX `idx_competition`(`competition_id` ASC) USING BTREE,
|
||
INDEX `idx_date`(`date_utc` ASC) USING BTREE,
|
||
INDEX `idx_status`(`status` ASC) USING BTREE,
|
||
INDEX `idx_match_type`(`match_type_id` ASC) USING BTREE,
|
||
INDEX `idx_crawl_time`(`crawl_time` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2964 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '比赛数据表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_match_event
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_match_event`;
|
||
CREATE TABLE `la_match_event` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`match_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '关联赛事ID',
|
||
`minute` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '事件时间(分钟)',
|
||
`event_type` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '1进球2黄牌3红牌4换人5点球6乌龙球7助攻',
|
||
`team_side` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '1主队2客队',
|
||
`player_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '球员名',
|
||
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '事件描述',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_match`(`match_id` ASC) USING BTREE,
|
||
INDEX `idx_type`(`event_type` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '比赛事件/精彩瞬间' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_match_history
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_match_history`;
|
||
CREATE TABLE `la_match_history` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`home_team` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '主队',
|
||
`away_team` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '客队',
|
||
`home_score` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '主队得分',
|
||
`away_score` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '客队得分',
|
||
`league_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '联赛名称',
|
||
`match_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '比赛时间',
|
||
`sport_type` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '1足球2篮球',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_teams`(`home_team` ASC, `away_team` ASC) USING BTREE,
|
||
INDEX `idx_time`(`match_time` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 3651 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '对赛往绩' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_match_live_text
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_match_live_text`;
|
||
CREATE TABLE `la_match_live_text` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`match_id` bigint NOT NULL DEFAULT 0 COMMENT '比赛ID',
|
||
`msg_id` int NOT NULL DEFAULT 0 COMMENT '消息ID（API返回的id）',
|
||
`event_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '事件类型',
|
||
`username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '发送者',
|
||
`avatar` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '头像',
|
||
`message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '文字内容',
|
||
`image` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图片URL',
|
||
`timestamp` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '时间戳文本',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_match_msg`(`match_id` ASC, `msg_id` ASC) USING BTREE,
|
||
INDEX `idx_match_id`(`match_id` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 26503 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '比赛文字直播' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_match_recent
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_match_recent`;
|
||
CREATE TABLE `la_match_recent` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`team_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '球队名称',
|
||
`opponent` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '对手',
|
||
`team_score` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '本队得分',
|
||
`opponent_score` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '对手得分',
|
||
`result` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'W胜D平L负',
|
||
`league_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '联赛名称',
|
||
`match_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '比赛时间',
|
||
`is_home` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '1主场0客场',
|
||
`sport_type` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '1足球2篮球',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_team`(`team_name` ASC) USING BTREE,
|
||
INDEX `idx_time`(`match_time` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 16816 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '近期战绩' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_match_round
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_match_round`;
|
||
CREATE TABLE `la_match_round` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`league_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'la_league.id',
|
||
`season_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '????ID',
|
||
`round_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '?ִ?ID',
|
||
`round_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '?ִ??',
|
||
`gameweek` int NOT NULL DEFAULT 0 COMMENT '?ܴ',
|
||
`url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '?ִ?API??ַ',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
`update_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_season_round_gw`(`season_id` ASC, `round_id` ASC, `gameweek` ASC) USING BTREE,
|
||
INDEX `idx_league`(`league_id` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 102997 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '?????ִα' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_match_type_config
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_match_type_config`;
|
||
CREATE TABLE `la_match_type_config` (
|
||
`id` int NOT NULL COMMENT '类型ID',
|
||
`label` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '显示名称',
|
||
`type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '类型标识',
|
||
`sort` int NULL DEFAULT 0 COMMENT '排序权重',
|
||
`api` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'API地址',
|
||
`shield` tinyint NULL DEFAULT 0 COMMENT '屏蔽状态',
|
||
`extra_data` json NULL COMMENT '额外数据',
|
||
`sessionid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Session ID',
|
||
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_type`(`type` ASC) USING BTREE,
|
||
INDEX `idx_sort`(`sort` ASC) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '比赛类型配置表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_matches
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_matches`;
|
||
CREATE TABLE `la_matches` (
|
||
`id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`match_id` bigint NOT NULL,
|
||
`season_id` int NOT NULL,
|
||
`round_number` int NULL DEFAULT 0,
|
||
`round_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',
|
||
`match_date` datetime NULL DEFAULT NULL,
|
||
`status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'fixture',
|
||
`home_team_id` int NULL DEFAULT NULL,
|
||
`home_team_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',
|
||
`home_team_logo` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',
|
||
`away_team_id` int NULL DEFAULT NULL,
|
||
`away_team_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',
|
||
`away_team_logo` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',
|
||
`home_score` int NULL DEFAULT NULL,
|
||
`away_score` int NULL DEFAULT NULL,
|
||
`halftime_score` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',
|
||
`venue` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',
|
||
`competition_id` int NULL DEFAULT NULL,
|
||
`competition_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',
|
||
`created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
||
`updated_at` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_match_id`(`match_id` ASC) USING BTREE,
|
||
INDEX `idx_season`(`season_id` ASC) USING BTREE,
|
||
INDEX `idx_status`(`status` ASC) USING BTREE,
|
||
INDEX `idx_date`(`match_date` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_notice_record
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_notice_record`;
|
||
CREATE TABLE `la_notice_record` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`user_id` int UNSIGNED NOT NULL COMMENT '用户id',
|
||
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标题',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '内容',
|
||
`scene_id` int UNSIGNED NULL DEFAULT 0 COMMENT '场景',
|
||
`read` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态;0-未读,1-已读',
|
||
`recipient` tinyint(1) NULL DEFAULT 0 COMMENT '通知接收对象类型;1-会员;2-商家;3-平台;4-游客(未注册用户)',
|
||
`send_type` tinyint(1) NULL DEFAULT 0 COMMENT '通知发送类型 1-系统通知 2-短信通知 3-微信模板 4-微信小程序',
|
||
`notice_type` tinyint(1) NULL DEFAULT NULL COMMENT '通知类型 1-业务通知 2-验证码',
|
||
`extra` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '其他',
|
||
`create_time` int NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '更新时间',
|
||
`delete_time` int NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知记录表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_notice_setting
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_notice_setting`;
|
||
CREATE TABLE `la_notice_setting` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`scene_id` int NOT NULL COMMENT '场景id',
|
||
`scene_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '场景名称',
|
||
`scene_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '场景描述',
|
||
`recipient` tinyint(1) NOT NULL DEFAULT 1 COMMENT '接收者 1-用户 2-平台',
|
||
`type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '通知类型: 1-业务通知 2-验证码',
|
||
`system_notice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '系统通知设置',
|
||
`sms_notice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '短信通知设置',
|
||
`oa_notice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '公众号通知设置',
|
||
`mnp_notice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '小程序通知设置',
|
||
`support` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '支持的发送类型 1-系统通知 2-短信通知 3-微信模板消息 4-小程序提醒',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知设置表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_official_account_reply
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_official_account_reply`;
|
||
CREATE TABLE `la_official_account_reply` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '规则名称',
|
||
`keyword` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关键词',
|
||
`reply_type` tinyint(1) NOT NULL COMMENT '回复类型 1-关注回复 2-关键字回复 3-默认回复',
|
||
`matching_type` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '匹配方式：1-全匹配；2-模糊匹配',
|
||
`content_type` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '内容类型：1-文本',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '回复内容',
|
||
`status` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '启动状态：1-启动；0-关闭',
|
||
`sort` int UNSIGNED NOT NULL DEFAULT 50 COMMENT '排序',
|
||
`create_time` int NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '更新时间',
|
||
`delete_time` int NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '公众号消息回调表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_operation_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_operation_log`;
|
||
CREATE TABLE `la_operation_log` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`admin_id` int NOT NULL COMMENT '管理员ID',
|
||
`admin_name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '管理员名称',
|
||
`account` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '管理员账号',
|
||
`action` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作名称',
|
||
`type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求方式',
|
||
`url` varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '访问链接',
|
||
`params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '请求数据',
|
||
`result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '请求结果',
|
||
`ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'ip地址',
|
||
`create_time` int NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2518 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统日志表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_proxy_pool
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_proxy_pool`;
|
||
CREATE TABLE `la_proxy_pool` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '自增ID',
|
||
`proxy_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '代理地址',
|
||
`proxy_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'http' COMMENT '代理类型',
|
||
`username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名',
|
||
`password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',
|
||
`country` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '国家',
|
||
`city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '城市',
|
||
`latency` float NULL DEFAULT 0 COMMENT '延迟(秒)',
|
||
`success_rate` float NULL DEFAULT 0 COMMENT '成功率',
|
||
`total_requests` int NULL DEFAULT 0 COMMENT '总请求数',
|
||
`success_requests` int NULL DEFAULT 0 COMMENT '成功请求数',
|
||
`last_success` timestamp NULL DEFAULT NULL COMMENT '最后成功时间',
|
||
`last_failure` timestamp NULL DEFAULT NULL COMMENT '最后失败时间',
|
||
`failure_count` int NULL DEFAULT 0 COMMENT '失败次数',
|
||
`is_active` tinyint NULL DEFAULT 1 COMMENT '是否激活',
|
||
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_proxy_url`(`proxy_url` ASC) USING BTREE,
|
||
INDEX `idx_proxy_type`(`proxy_type` ASC) USING BTREE,
|
||
INDEX `idx_country`(`country` ASC) USING BTREE,
|
||
INDEX `idx_latency`(`latency` ASC) USING BTREE,
|
||
INDEX `idx_success_rate`(`success_rate` ASC) USING BTREE,
|
||
INDEX `idx_is_active`(`is_active` ASC) USING BTREE,
|
||
INDEX `idx_last_success`(`last_success` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '代理池表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_recharge_order
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_recharge_order`;
|
||
CREATE TABLE `la_recharge_order` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`sn` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单编号',
|
||
`user_id` int NOT NULL COMMENT '用户id',
|
||
`pay_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '支付编号-冗余字段，针对微信同一主体不同客户端支付需用不同订单号预留。',
|
||
`pay_way` tinyint NOT NULL DEFAULT 2 COMMENT '支付方式 2-微信支付 3-支付宝支付',
|
||
`pay_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '支付状态：0-待支付；1-已支付',
|
||
`pay_time` int NULL DEFAULT NULL COMMENT '支付时间',
|
||
`order_amount` decimal(10, 2) NOT NULL COMMENT '充值金额',
|
||
`order_terminal` tinyint(1) NULL DEFAULT 1 COMMENT '终端 1-PC端 2-移动端 3-小程序',
|
||
`transaction_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台交易流水号',
|
||
`refund_status` tinyint(1) NULL DEFAULT 0 COMMENT '退款状态 0-未退款 1-已退款',
|
||
`refund_transaction_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '退款交易流水号',
|
||
`create_time` int NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '更新时间',
|
||
`delete_time` int NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '充值订单表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_refund_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_refund_log`;
|
||
CREATE TABLE `la_refund_log` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`sn` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编号',
|
||
`record_id` int NOT NULL COMMENT '退款记录id',
|
||
`user_id` int NOT NULL DEFAULT 0 COMMENT '关联用户',
|
||
`handle_id` int NOT NULL DEFAULT 0 COMMENT '处理人id（管理员id）',
|
||
`order_amount` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '订单总的应付款金额，冗余字段',
|
||
`refund_amount` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '本次退款金额',
|
||
`refund_status` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '退款状态 0-退款中 1-退款成功 2-退款失败',
|
||
`refund_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '退款信息',
|
||
`create_time` int UNSIGNED NULL DEFAULT 0 COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '退款日志表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_refund_record
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_refund_record`;
|
||
CREATE TABLE `la_refund_record` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`sn` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '退款编号',
|
||
`user_id` int NOT NULL DEFAULT 0 COMMENT '关联用户',
|
||
`order_id` int NOT NULL DEFAULT 0 COMMENT '来源订单id',
|
||
`order_sn` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '来源单号',
|
||
`order_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'order' COMMENT '订单来源 order-商品订单 recharge-充值订单',
|
||
`order_amount` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '订单总的应付款金额，冗余字段',
|
||
`refund_amount` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '本次退款金额',
|
||
`transaction_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台交易流水号',
|
||
`refund_way` tinyint(1) NOT NULL DEFAULT 1 COMMENT '退款方式 1-线上退款 2-线下退款',
|
||
`refund_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '退款类型 1-后台退款',
|
||
`refund_status` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '退款状态 0-退款中 1-退款成功 2-退款失败',
|
||
`create_time` int UNSIGNED NULL DEFAULT 0 COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '退款记录表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_short_link
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_short_link`;
|
||
CREATE TABLE `la_short_link` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`code` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
||
`page_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
|
||
`page_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
|
||
`params` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
|
||
`path` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
|
||
`qrcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '二维码图片相对路径',
|
||
`user_id` int UNSIGNED NOT NULL DEFAULT 0,
|
||
`click_count` int UNSIGNED NOT NULL DEFAULT 0,
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_code`(`code` ASC) USING BTREE,
|
||
INDEX `idx_page`(`page_type` ASC, `page_id` ASC) USING BTREE,
|
||
INDEX `idx_user`(`user_id` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_short_link_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_short_link_log`;
|
||
CREATE TABLE `la_short_link_log` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`short_link_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '短链接ID',
|
||
`code` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '短链接code',
|
||
`ip` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '访问IP',
|
||
`user_agent` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'UserAgent',
|
||
`referer` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '来源页面',
|
||
`fingerprint` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '浏览器指纹(前端传入)',
|
||
`platform` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '平台: ios/android/pc/wechat等',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_link`(`short_link_id` ASC) USING BTREE,
|
||
INDEX `idx_code`(`code` ASC) USING BTREE,
|
||
INDEX `idx_ip`(`ip` ASC) USING BTREE,
|
||
INDEX `idx_time`(`create_time` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '短链接访问日志' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_sms_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_sms_log`;
|
||
CREATE TABLE `la_sms_log` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`scene_id` int NOT NULL COMMENT '场景id',
|
||
`mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号码',
|
||
`content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '发送内容',
|
||
`code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发送关键字（注册、找回密码）',
|
||
`is_verify` tinyint(1) NULL DEFAULT 0 COMMENT '是否已验证；0-否；1-是',
|
||
`check_num` int NULL DEFAULT 0 COMMENT '验证次数',
|
||
`send_status` tinyint(1) NOT NULL COMMENT '发送状态：0-发送中；1-发送成功；2-发送失败',
|
||
`send_time` int NOT NULL COMMENT '发送时间',
|
||
`results` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '短信结果',
|
||
`create_time` int NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '更新时间',
|
||
`delete_time` int NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '短信记录表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_standings
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_standings`;
|
||
CREATE TABLE `la_standings` (
|
||
`id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`season_id` int NOT NULL,
|
||
`round_number` int NOT NULL DEFAULT 0,
|
||
`team_id` int NOT NULL,
|
||
`team_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
|
||
`team_logo` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',
|
||
`rank` int NOT NULL DEFAULT 0,
|
||
`points` int NOT NULL DEFAULT 0,
|
||
`played` int NOT NULL DEFAULT 0,
|
||
`won` int NOT NULL DEFAULT 0,
|
||
`drawn` int NOT NULL DEFAULT 0,
|
||
`lost` int NOT NULL DEFAULT 0,
|
||
`goals_for` int NOT NULL DEFAULT 0,
|
||
`goals_against` int NOT NULL DEFAULT 0,
|
||
`goal_diff` int NOT NULL DEFAULT 0,
|
||
`recent_form` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',
|
||
`deduction_points` int NULL DEFAULT 0,
|
||
`deduction_reason` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',
|
||
`created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
||
`updated_at` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_season_round_team`(`season_id` ASC, `round_number` ASC, `team_id` ASC) USING BTREE,
|
||
INDEX `idx_season`(`season_id` ASC) USING BTREE,
|
||
INDEX `idx_team`(`team_id` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_system_menu
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_system_menu`;
|
||
CREATE TABLE `la_system_menu` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`pid` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '上级菜单',
|
||
`type` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '权限类型: M=目录，C=菜单，A=按钮',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '菜单名称',
|
||
`icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '菜单图标',
|
||
`sort` smallint UNSIGNED NOT NULL DEFAULT 0 COMMENT '菜单排序',
|
||
`perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '权限标识',
|
||
`paths` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '路由地址',
|
||
`component` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '前端组件',
|
||
`selected` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '选中路径',
|
||
`params` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '路由参数',
|
||
`is_cache` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否缓存: 0=否, 1=是',
|
||
`is_show` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否显示: 0=否, 1=是',
|
||
`is_disable` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否禁用: 0=否, 1=是',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
|
||
`update_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 529 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统菜单表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_system_role
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_system_role`;
|
||
CREATE TABLE `la_system_role` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
|
||
`desc` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '描述',
|
||
`sort` int NULL DEFAULT 0 COMMENT '排序',
|
||
`create_time` int NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '更新时间',
|
||
`delete_time` int NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_system_role_menu
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_system_role_menu`;
|
||
CREATE TABLE `la_system_role_menu` (
|
||
`role_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '角色ID',
|
||
`menu_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '菜单ID',
|
||
PRIMARY KEY (`role_id`, `menu_id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色菜单关系表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_tls_fingerprint
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_tls_fingerprint`;
|
||
CREATE TABLE `la_tls_fingerprint` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '自增ID',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '指纹名称',
|
||
`browser_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '浏览器类型',
|
||
`tls_version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'TLS版本',
|
||
`cipher_suites` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '加密套件',
|
||
`extensions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT 'TLS扩展',
|
||
`signature_algorithms` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '签名算法',
|
||
`supported_groups` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '支持群组',
|
||
`ja3_hash` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'JA3哈希',
|
||
`ja3s_hash` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'JA3S哈希',
|
||
`user_agent_pattern` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'User-Agent模式',
|
||
`is_active` tinyint NULL DEFAULT 1 COMMENT '是否激活',
|
||
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_name`(`name` ASC) USING BTREE,
|
||
INDEX `idx_browser_type`(`browser_type` ASC) USING BTREE,
|
||
INDEX `idx_is_active`(`is_active` ASC) USING BTREE,
|
||
INDEX `idx_ja3_hash`(`ja3_hash` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'TLS指纹表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_user
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_user`;
|
||
CREATE TABLE `la_user` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`sn` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '编号',
|
||
`avatar` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '头像',
|
||
`real_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '真实姓名',
|
||
`nickname` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户昵称',
|
||
`account` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户账号',
|
||
`password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户密码',
|
||
`mobile` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户电话',
|
||
`sex` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户性别: [1=男, 2=女]',
|
||
`channel` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '注册渠道: [1-微信小程序 2-微信公众号 3-手机H5 4-电脑PC 5-苹果APP 6-安卓APP]',
|
||
`is_disable` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否禁用: [0=否, 1=是]',
|
||
`login_ip` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '最后登录IP',
|
||
`login_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '最后登录时间',
|
||
`is_new_user` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否是新注册用户: [1-是, 0-否]',
|
||
`is_vip` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT 'VIP状态:0=普通,1=VIP',
|
||
`vip_level` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT 'VIP等级:0=无,1=月卡,2=季卡,3=年卡',
|
||
`vip_expire_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'VIP到期时间戳',
|
||
`ai_free_count` int UNSIGNED NOT NULL DEFAULT 3 COMMENT '今日AI免费分析剩余次数',
|
||
`ai_free_date` date NULL DEFAULT NULL COMMENT 'AI免费次数重置日期',
|
||
`invite_code` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '邀请码',
|
||
`inviter_id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '邀请人ID',
|
||
`user_money` decimal(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '用户余额',
|
||
`user_points` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户积分',
|
||
`total_recharge_amount` decimal(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '累计充值',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
|
||
`update_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
|
||
`delete_time` int UNSIGNED NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `sn`(`sn` ASC) USING BTREE COMMENT '编号唯一',
|
||
UNIQUE INDEX `account`(`account` ASC) USING BTREE COMMENT '账号唯一'
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_user_account_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_user_account_log`;
|
||
CREATE TABLE `la_user_account_log` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`sn` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '流水号',
|
||
`user_id` int NOT NULL COMMENT '用户id',
|
||
`change_object` tinyint(1) NOT NULL DEFAULT 0 COMMENT '变动对象',
|
||
`change_type` smallint NOT NULL COMMENT '变动类型',
|
||
`action` tinyint(1) NOT NULL DEFAULT 0 COMMENT '动作 1-增加 2-减少',
|
||
`change_amount` decimal(10, 2) NOT NULL COMMENT '变动数量',
|
||
`left_amount` decimal(10, 2) NOT NULL DEFAULT 100.00 COMMENT '变动后数量',
|
||
`source_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联单号',
|
||
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
|
||
`extra` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '预留扩展字段',
|
||
`create_time` int NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '更新时间',
|
||
`delete_time` int NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户账户变动日志表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_user_auth
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_user_auth`;
|
||
CREATE TABLE `la_user_auth` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`user_id` int NOT NULL COMMENT '用户id',
|
||
`openid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '微信openid',
|
||
`unionid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '微信unionid',
|
||
`terminal` tinyint(1) NOT NULL DEFAULT 1 COMMENT '客户端类型：1-微信小程序；2-微信公众号；3-手机H5；4-电脑PC；5-苹果APP；6-安卓APP',
|
||
`create_time` int NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `openid`(`openid` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户授权表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_user_channel_config
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_user_channel_config`;
|
||
CREATE TABLE `la_user_channel_config` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`user_id` int UNSIGNED NOT NULL COMMENT '用户ID',
|
||
`channel_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '频道ID列表JSON',
|
||
`create_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
`update_time` int UNSIGNED NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `uk_user_id`(`user_id` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户频道配置' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_user_session
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_user_session`;
|
||
CREATE TABLE `la_user_session` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`user_id` int NOT NULL COMMENT '用户id',
|
||
`terminal` tinyint(1) NOT NULL DEFAULT 1 COMMENT '客户端类型：1-微信小程序；2-微信公众号；3-手机H5；4-电脑PC；5-苹果APP；6-安卓APP',
|
||
`token` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '令牌',
|
||
`update_time` int NULL DEFAULT NULL COMMENT '更新时间',
|
||
`expire_time` int NOT NULL COMMENT '到期时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `admin_id_client`(`user_id` ASC, `terminal` ASC) USING BTREE COMMENT '一个用户在一个终端只有一个token',
|
||
UNIQUE INDEX `token`(`token` ASC) USING BTREE COMMENT 'token是唯一的'
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户会话表' ROW_FORMAT = Dynamic;
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1;
|