373 lines
24 KiB
SQL
373 lines
24 KiB
SQL
/*
|
||
Navicat Premium Data Transfer
|
||
|
||
Source Server : local
|
||
Source Server Type : MySQL
|
||
Source Server Version : 50640
|
||
Source Host : localhost:3306
|
||
Source Schema : dblog
|
||
|
||
Target Server Type : MySQL
|
||
Target Server Version : 50640
|
||
File Encoding : 65001
|
||
|
||
Date: 04/01/2019 15:45:01
|
||
*/
|
||
|
||
SET NAMES utf8mb4;
|
||
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for biz_article
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `biz_article`;
|
||
CREATE TABLE `biz_article` (
|
||
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '文章标题',
|
||
`user_id` bigint(20) UNSIGNED NOT NULL COMMENT '用户ID',
|
||
`cover_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '文章封面图片',
|
||
`qrcode_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '文章专属二维码地址',
|
||
`is_markdown` tinyint(1) UNSIGNED NULL DEFAULT 1,
|
||
`content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '文章内容',
|
||
`content_md` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT 'markdown版的文章内容',
|
||
`top` tinyint(1) NULL DEFAULT 0 COMMENT '是否置顶',
|
||
`type_id` bigint(20) UNSIGNED NOT NULL COMMENT '类型',
|
||
`status` tinyint(1) UNSIGNED NULL DEFAULT NULL COMMENT '状态',
|
||
`recommended` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否推荐',
|
||
`original` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '是否原创',
|
||
`description` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '文章简介，最多200字',
|
||
`keywords` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '文章关键字，优化搜索',
|
||
`comment` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '是否开启评论',
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for biz_article_look
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `biz_article_look`;
|
||
CREATE TABLE `biz_article_look` (
|
||
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`article_id` bigint(20) UNSIGNED NOT NULL COMMENT '文章ID',
|
||
`user_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '已登录用户ID',
|
||
`user_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户IP',
|
||
`look_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '浏览时间',
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for biz_article_love
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `biz_article_love`;
|
||
CREATE TABLE `biz_article_love` (
|
||
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`article_id` bigint(20) UNSIGNED NOT NULL COMMENT '文章ID',
|
||
`user_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '已登录用户ID',
|
||
`user_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户IP',
|
||
`love_time` datetime(0) NULL DEFAULT NULL COMMENT '浏览时间',
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for biz_article_tags
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `biz_article_tags`;
|
||
CREATE TABLE `biz_article_tags` (
|
||
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`tag_id` bigint(20) UNSIGNED NOT NULL COMMENT '标签表主键',
|
||
`article_id` bigint(20) UNSIGNED NOT NULL COMMENT '文章ID',
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for biz_comment
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `biz_comment`;
|
||
CREATE TABLE `biz_comment` (
|
||
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`sid` bigint(20) NULL DEFAULT NULL COMMENT '被评论的文章或者页面的ID',
|
||
`user_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '评论人的ID',
|
||
`pid` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '父级评论的id',
|
||
`qq` varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '评论人的QQ（未登录用户）',
|
||
`nickname` varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '评论人的昵称（未登录用户）',
|
||
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '评论人的头像地址',
|
||
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '评论人的邮箱地址（未登录用户）',
|
||
`url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '评论人的网站地址（未登录用户）',
|
||
`status` enum('VERIFYING','APPROVED','REJECT','DELETED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'VERIFYING' COMMENT '评论的状态',
|
||
`ip` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '评论时的ip',
|
||
`lng` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '经度',
|
||
`lat` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '纬度',
|
||
`address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '评论时的地址',
|
||
`os` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '评论时的系统类型',
|
||
`os_short_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '评论时的系统的简称',
|
||
`browser` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '评论时的浏览器类型',
|
||
`browser_short_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '评论时的浏览器的简称',
|
||
`content` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '评论的内容',
|
||
`remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注（审核不通过时添加）',
|
||
`support` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '支持（赞）',
|
||
`oppose` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '反对（踩）',
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for biz_tags
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `biz_tags`;
|
||
CREATE TABLE `biz_tags` (
|
||
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '书签名',
|
||
`description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for biz_type
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `biz_type`;
|
||
CREATE TABLE `biz_type` (
|
||
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`pid` bigint(20) UNSIGNED NULL DEFAULT NULL,
|
||
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章类型名',
|
||
`description` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型介绍',
|
||
`sort` int(10) NULL DEFAULT NULL COMMENT '排序',
|
||
`icon` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标',
|
||
`available` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '是否可用',
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_config
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_config`;
|
||
CREATE TABLE `sys_config` (
|
||
`id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`config_key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置关键字',
|
||
`config_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '配置项内容',
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_link
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_link`;
|
||
CREATE TABLE `sys_link` (
|
||
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '链接地址',
|
||
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接名',
|
||
`description` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接介绍',
|
||
`email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '友链站长邮箱',
|
||
`qq` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '友链站长QQ',
|
||
`favicon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
||
`status` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '状态',
|
||
`home_page_display` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '是否首页显示',
|
||
`remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
|
||
`source` enum('ADMIN','AUTOMATIC') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'ADMIN' COMMENT '来源：管理员添加、自动申请',
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_log`;
|
||
CREATE TABLE `sys_log` (
|
||
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`user_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '已登录用户ID',
|
||
`type` enum('SYSTEM','VISIT','ERROR') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'SYSTEM' COMMENT '日志类型（系统操作日志，用户访问日志，异常记录日志）',
|
||
`log_level` enum('ERROR','WARN','INFO') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'INFO' COMMENT '日志级别',
|
||
`content` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志内容（业务操作）',
|
||
`params` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求参数（业务操作）',
|
||
`spider_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '爬虫类型（当访问者被鉴定为爬虫时该字段表示爬虫的类型）',
|
||
`ip` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作用户的ip',
|
||
`ua` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作用户的user_agent',
|
||
`os` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评论时的系统类型',
|
||
`browser` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评论时的浏览器类型',
|
||
`request_url` varchar(3000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求的路径',
|
||
`referer` varchar(3000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求来源地址',
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_notice
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_notice`;
|
||
CREATE TABLE `sys_notice` (
|
||
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`user_id` bigint(20) UNSIGNED NOT NULL COMMENT '被通知的用户ID',
|
||
`status` enum('RELEASE','NOT_RELEASE') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'NOT_RELEASE' COMMENT '通知状态',
|
||
`title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '通知的标题',
|
||
`content` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '通知的内容',
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_resources
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_resources`;
|
||
CREATE TABLE `sys_resources` (
|
||
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
||
`type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
||
`url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
||
`permission` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
||
`parent_id` bigint(20) UNSIGNED NULL DEFAULT 0,
|
||
`sort` int(10) UNSIGNED NULL DEFAULT NULL,
|
||
`external` tinyint(1) UNSIGNED NULL DEFAULT NULL COMMENT '是否外部链接',
|
||
`available` tinyint(1) UNSIGNED NULL DEFAULT 0,
|
||
`icon` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_sys_resource_parent_id`(`parent_id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_role
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_role`;
|
||
CREATE TABLE `sys_role` (
|
||
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名',
|
||
`description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
||
`available` tinyint(1) NULL DEFAULT 0,
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_role_resources
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_role_resources`;
|
||
CREATE TABLE `sys_role_resources` (
|
||
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`role_id` bigint(20) UNSIGNED NOT NULL,
|
||
`resources_id` bigint(20) UNSIGNED NOT NULL,
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_template
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_template`;
|
||
CREATE TABLE `sys_template` (
|
||
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`ref_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '键',
|
||
`ref_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '模板内容',
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_update_recorde
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_update_recorde`;
|
||
CREATE TABLE `sys_update_recorde` (
|
||
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`version` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新版本',
|
||
`description` varchar(2500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新记录备注',
|
||
`recorde_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '项目更新时间',
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_user
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_user`;
|
||
CREATE TABLE `sys_user` (
|
||
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
||
`password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录密码',
|
||
`nickname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '昵称',
|
||
`mobile` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
|
||
`email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱地址',
|
||
`qq` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'QQ',
|
||
`birthday` date NULL DEFAULT NULL COMMENT '生日',
|
||
`gender` smallint(2) NULL DEFAULT NULL COMMENT '性别',
|
||
`avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像地址',
|
||
`user_type` enum('ROOT','ADMIN','USER') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'ADMIN' COMMENT '超级管理员、管理员、普通用户',
|
||
`company` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司',
|
||
`blog` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '个人博客地址',
|
||
`location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
|
||
`source` enum('GITHUB','GITEE','WEIBO','DINGTALK','BAIDU','CSDN','CODING','OSCHINA','TENCENT_CLOUD','ALIPAY','TAOBAO','QQ','WECHAT','GOOGLE','FACEBOOK') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户来源',
|
||
`uuid` varchar(50) NULL COMMENT '用户唯一表示(第三方网站)',
|
||
`privacy` tinyint(2) NULL DEFAULT NULL COMMENT '隐私（1：公开，0：不公开）',
|
||
`notification` tinyint(2) UNSIGNED NULL DEFAULT NULL COMMENT '通知：(1：通知显示消息详情，2：通知不显示详情)',
|
||
`score` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '金币值',
|
||
`experience` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '经验值',
|
||
`reg_ip` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '注册IP',
|
||
`last_login_ip` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最近登录IP',
|
||
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最近登录时间',
|
||
`login_count` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '登录次数',
|
||
`remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户备注',
|
||
`status` int(1) UNSIGNED NULL DEFAULT NULL COMMENT '用户状态',
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_user_role
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_user_role`;
|
||
CREATE TABLE `sys_user_role` (
|
||
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`user_id` bigint(20) UNSIGNED NOT NULL,
|
||
`role_id` bigint(20) UNSIGNED NOT NULL,
|
||
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
||
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for biz_file
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `biz_file`;
|
||
CREATE TABLE `biz_file` (
|
||
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) UNSIGNED NULL DEFAULT NULL,
|
||
`storage_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
|
||
`original_file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
|
||
`size` bigint(20) UNSIGNED NULL DEFAULT NULL,
|
||
`suffix` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
|
||
`width` int(10) UNSIGNED NULL DEFAULT NULL,
|
||
`height` int(10) UNSIGNED NULL DEFAULT NULL,
|
||
`file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
|
||
`full_file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
|
||
`file_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
|
||
`upload_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
|
||
`upload_start_time` datetime(0) NULL DEFAULT NULL,
|
||
`upload_end_time` datetime(0) NULL DEFAULT NULL,
|
||
`create_time` datetime(0) NULL DEFAULT NULL,
|
||
`update_time` datetime(0) NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;
|
||
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1;
|