|
|
/*
|
|
|
SQLyog Ultimate v12.09 (64 bit)
|
|
|
MySQL - 5.7.26 : Database - mes-majoys
|
|
|
*********************************************************************
|
|
|
*/
|
|
|
|
|
|
|
|
|
/*!40101 SET NAMES utf8 */;
|
|
|
|
|
|
/*!40101 SET SQL_MODE=''*/;
|
|
|
|
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
CREATE DATABASE /*!32312 IF NOT EXISTS*/`mes-majoys` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
|
|
|
|
|
|
USE `mes-majoys`;
|
|
|
|
|
|
/*Table structure for table `infra_api_access_log` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `infra_api_access_log`;
|
|
|
|
|
|
CREATE TABLE `infra_api_access_log` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
|
|
|
`trace_id` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '链路追踪编号',
|
|
|
`user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户编号',
|
|
|
`user_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '用户类型',
|
|
|
`application_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '应用名',
|
|
|
`request_method` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '请求方法名',
|
|
|
`request_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '请求地址',
|
|
|
`request_params` text COLLATE utf8mb4_unicode_ci COMMENT '请求参数',
|
|
|
`user_ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户 IP',
|
|
|
`user_agent` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '浏览器 UA',
|
|
|
`begin_time` datetime NOT NULL COMMENT '开始请求时间',
|
|
|
`end_time` datetime NOT NULL COMMENT '结束请求时间',
|
|
|
`duration` int(11) NOT NULL COMMENT '执行时长',
|
|
|
`result_code` int(11) NOT NULL DEFAULT '0' COMMENT '结果码',
|
|
|
`result_msg` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '结果提示',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
|
KEY `idx_create_time` (`create_time`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='API 访问日志表';
|
|
|
|
|
|
/*Table structure for table `infra_api_error_log` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `infra_api_error_log`;
|
|
|
|
|
|
CREATE TABLE `infra_api_error_log` (
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`trace_id` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '链路追踪编号\n *\n * 一般来说，通过链路追踪编号，可以将访问日志，错误日志，链路追踪日志，logger 打印日志等，结合在一起，从而进行排错。',
|
|
|
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户编号',
|
|
|
`user_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '用户类型',
|
|
|
`application_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '应用名\n *\n * 目前读取 spring.application.name',
|
|
|
`request_method` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '请求方法名',
|
|
|
`request_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '请求地址',
|
|
|
`request_params` text COLLATE utf8mb4_unicode_ci COMMENT '请求参数',
|
|
|
`user_ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户 IP',
|
|
|
`user_agent` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '浏览器 UA',
|
|
|
`exception_time` datetime NOT NULL COMMENT '异常发生时间',
|
|
|
`exception_name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '异常名\n *\n * {@link Throwable#getClass()} 的类全名',
|
|
|
`exception_message` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '异常导致的消息\n *\n * {@link cn.iocoder.common.framework.util.ExceptionUtil#getMessage(Throwable)}',
|
|
|
`exception_root_cause_message` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '异常导致的根消息\n *\n * {@link cn.iocoder.common.framework.util.ExceptionUtil#getRootCauseMessage(Throwable)}',
|
|
|
`exception_stack_trace` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '异常的栈轨迹\n *\n * {@link cn.iocoder.common.framework.util.ExceptionUtil#getServiceException(Exception)}',
|
|
|
`exception_class_name` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '异常发生的类全名\n *\n * {@link StackTraceElement#getClassName()}',
|
|
|
`exception_file_name` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '异常发生的类文件\n *\n * {@link StackTraceElement#getFileName()}',
|
|
|
`exception_method_name` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '异常发生的方法名\n *\n * {@link StackTraceElement#getMethodName()}',
|
|
|
`exception_line_number` int(11) NOT NULL COMMENT '异常发生的方法所在行\n *\n * {@link StackTraceElement#getLineNumber()}',
|
|
|
`process_status` tinyint(4) NOT NULL COMMENT '处理状态',
|
|
|
`process_time` datetime DEFAULT NULL COMMENT '处理时间',
|
|
|
`process_user_id` int(11) DEFAULT '0' COMMENT '处理用户编号',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='系统异常日志';
|
|
|
|
|
|
/*Table structure for table `infra_codegen_column` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `infra_codegen_column`;
|
|
|
|
|
|
CREATE TABLE `infra_codegen_column` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`table_id` bigint(20) NOT NULL COMMENT '表编号',
|
|
|
`column_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字段名',
|
|
|
`data_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字段类型',
|
|
|
`column_comment` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字段描述',
|
|
|
`nullable` bit(1) NOT NULL COMMENT '是否允许为空',
|
|
|
`primary_key` bit(1) NOT NULL COMMENT '是否主键',
|
|
|
`auto_increment` char(1) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '是否自增',
|
|
|
`ordinal_position` int(11) NOT NULL COMMENT '排序',
|
|
|
`java_type` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Java 属性类型',
|
|
|
`java_field` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Java 属性名',
|
|
|
`dict_type` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '字典类型',
|
|
|
`example` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '数据示例',
|
|
|
`create_operation` bit(1) NOT NULL COMMENT '是否为 Create 创建操作的字段',
|
|
|
`update_operation` bit(1) NOT NULL COMMENT '是否为 Update 更新操作的字段',
|
|
|
`list_operation` bit(1) NOT NULL COMMENT '是否为 List 查询操作的字段',
|
|
|
`list_operation_condition` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '=' COMMENT 'List 查询操作的条件类型',
|
|
|
`list_operation_result` bit(1) NOT NULL COMMENT '是否为 List 查询操作的返回字段',
|
|
|
`html_type` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '显示类型',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='代码生成表字段定义';
|
|
|
|
|
|
/*Table structure for table `infra_codegen_table` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `infra_codegen_table`;
|
|
|
|
|
|
CREATE TABLE `infra_codegen_table` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`data_source_config_id` bigint(20) NOT NULL COMMENT '数据源配置的编号',
|
|
|
`scene` tinyint(4) NOT NULL DEFAULT '1' COMMENT '生成场景',
|
|
|
`table_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '表名称',
|
|
|
`table_comment` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '表描述',
|
|
|
`remark` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
|
|
|
`module_name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模块名',
|
|
|
`business_name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '业务名',
|
|
|
`class_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '类名称',
|
|
|
`class_comment` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '类描述',
|
|
|
`author` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '作者',
|
|
|
`template_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '模板类型',
|
|
|
`front_type` tinyint(4) NOT NULL COMMENT '前端类型',
|
|
|
`parent_menu_id` bigint(20) DEFAULT NULL COMMENT '父菜单编号',
|
|
|
`master_table_id` bigint(20) DEFAULT NULL COMMENT '主表的编号',
|
|
|
`sub_join_column_id` bigint(20) DEFAULT NULL COMMENT '子表关联主表的字段编号',
|
|
|
`sub_join_many` bit(1) DEFAULT NULL COMMENT '主表与子表是否一对多',
|
|
|
`tree_parent_column_id` bigint(20) DEFAULT NULL COMMENT '树表的父字段编号',
|
|
|
`tree_name_column_id` bigint(20) DEFAULT NULL COMMENT '树表的名字字段编号',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='代码生成表定义';
|
|
|
|
|
|
/*Table structure for table `infra_config` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `infra_config`;
|
|
|
|
|
|
CREATE TABLE `infra_config` (
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '参数主键',
|
|
|
`category` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '参数分组',
|
|
|
`type` tinyint(4) NOT NULL COMMENT '参数类型',
|
|
|
`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '参数名称',
|
|
|
`config_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '参数键名',
|
|
|
`value` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '参数键值',
|
|
|
`visible` bit(1) NOT NULL COMMENT '是否可见',
|
|
|
`remark` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='参数配置表';
|
|
|
|
|
|
/*Table structure for table `infra_data_source_config` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `infra_data_source_config`;
|
|
|
|
|
|
CREATE TABLE `infra_data_source_config` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键编号',
|
|
|
`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '参数名称',
|
|
|
`url` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '数据源连接',
|
|
|
`username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名',
|
|
|
`password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '密码',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='数据源配置表';
|
|
|
|
|
|
/*Table structure for table `infra_demo01_contact` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `infra_demo01_contact`;
|
|
|
|
|
|
CREATE TABLE `infra_demo01_contact` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名字',
|
|
|
`sex` tinyint(1) NOT NULL COMMENT '性别',
|
|
|
`birthday` datetime NOT NULL COMMENT '出生年',
|
|
|
`description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '简介',
|
|
|
`avatar` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '头像',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='示例联系人表';
|
|
|
|
|
|
/*Table structure for table `infra_demo02_category` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `infra_demo02_category`;
|
|
|
|
|
|
CREATE TABLE `infra_demo02_category` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名字',
|
|
|
`parent_id` bigint(20) NOT NULL COMMENT '父级编号',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='示例分类表';
|
|
|
|
|
|
/*Table structure for table `infra_demo03_course` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `infra_demo03_course`;
|
|
|
|
|
|
CREATE TABLE `infra_demo03_course` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`student_id` bigint(20) NOT NULL COMMENT '学生编号',
|
|
|
`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名字',
|
|
|
`score` tinyint(4) NOT NULL COMMENT '分数',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='学生课程表';
|
|
|
|
|
|
/*Table structure for table `infra_demo03_grade` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `infra_demo03_grade`;
|
|
|
|
|
|
CREATE TABLE `infra_demo03_grade` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`student_id` bigint(20) NOT NULL COMMENT '学生编号',
|
|
|
`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名字',
|
|
|
`teacher` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '班主任',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='学生班级表';
|
|
|
|
|
|
/*Table structure for table `infra_demo03_student` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `infra_demo03_student`;
|
|
|
|
|
|
CREATE TABLE `infra_demo03_student` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名字',
|
|
|
`sex` tinyint(4) NOT NULL COMMENT '性别',
|
|
|
`birthday` datetime NOT NULL COMMENT '出生日期',
|
|
|
`description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '简介',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='学生表';
|
|
|
|
|
|
/*Table structure for table `infra_file` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `infra_file`;
|
|
|
|
|
|
CREATE TABLE `infra_file` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '文件编号',
|
|
|
`config_id` bigint(20) DEFAULT NULL COMMENT '配置编号',
|
|
|
`business_type` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '业务类型 用于业务关联',
|
|
|
`business_id` bigint(20) DEFAULT NULL COMMENT '业务id',
|
|
|
`business_file_type` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '业务文件类型 用于区分不同业务类型文件',
|
|
|
`name` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件名',
|
|
|
`path` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '文件路径',
|
|
|
`url` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '文件 URL',
|
|
|
`type` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件类型',
|
|
|
`size` int(11) NOT NULL COMMENT '文件大小',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
|
KEY `idx_business` (`business_type`,`business_id`,`business_file_type`)
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='文件表';
|
|
|
|
|
|
/*Table structure for table `infra_file_config` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `infra_file_config`;
|
|
|
|
|
|
CREATE TABLE `infra_file_config` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`name` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '配置名',
|
|
|
`storage` tinyint(4) NOT NULL COMMENT '存储器',
|
|
|
`remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
|
|
|
`master` bit(1) NOT NULL COMMENT '是否为主配置',
|
|
|
`config` varchar(4096) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '存储配置',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='文件配置表';
|
|
|
|
|
|
/*Table structure for table `infra_file_content` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `infra_file_content`;
|
|
|
|
|
|
CREATE TABLE `infra_file_content` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`config_id` bigint(20) NOT NULL COMMENT '配置编号',
|
|
|
`path` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '文件路径',
|
|
|
`content` mediumblob NOT NULL COMMENT '文件内容',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='文件表';
|
|
|
|
|
|
/*Table structure for table `infra_job` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `infra_job`;
|
|
|
|
|
|
CREATE TABLE `infra_job` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务编号',
|
|
|
`name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '任务名称',
|
|
|
`status` tinyint(4) NOT NULL COMMENT '任务状态',
|
|
|
`handler_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '处理器的名字',
|
|
|
`handler_param` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '处理器的参数',
|
|
|
`cron_expression` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'CRON 表达式',
|
|
|
`retry_count` int(11) NOT NULL DEFAULT '0' COMMENT '重试次数',
|
|
|
`retry_interval` int(11) NOT NULL DEFAULT '0' COMMENT '重试间隔',
|
|
|
`monitor_timeout` int(11) NOT NULL DEFAULT '0' COMMENT '监控超时时间',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='定时任务表';
|
|
|
|
|
|
/*Table structure for table `infra_job_log` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `infra_job_log`;
|
|
|
|
|
|
CREATE TABLE `infra_job_log` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志编号',
|
|
|
`job_id` bigint(20) NOT NULL COMMENT '任务编号',
|
|
|
`handler_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '处理器的名字',
|
|
|
`handler_param` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '处理器的参数',
|
|
|
`execute_index` tinyint(4) NOT NULL DEFAULT '1' COMMENT '第几次执行',
|
|
|
`begin_time` datetime NOT NULL COMMENT '开始执行时间',
|
|
|
`end_time` datetime DEFAULT NULL COMMENT '结束执行时间',
|
|
|
`duration` int(11) DEFAULT NULL COMMENT '执行时长',
|
|
|
`status` tinyint(4) NOT NULL COMMENT '任务状态',
|
|
|
`result` varchar(4000) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '结果数据',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='定时任务日志表';
|
|
|
|
|
|
/*Table structure for table `qrtz_calendars` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `qrtz_calendars`;
|
|
|
|
|
|
CREATE TABLE `qrtz_calendars` (
|
|
|
`SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`CALENDAR_NAME` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`CALENDAR` blob NOT NULL,
|
|
|
PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
|
|
/*Table structure for table `qrtz_cron_triggers` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
|
|
|
|
|
|
CREATE TABLE `qrtz_cron_triggers` (
|
|
|
`SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`TRIGGER_NAME` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`TRIGGER_GROUP` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`CRON_EXPRESSION` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`TIME_ZONE_ID` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
|
|
|
CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE NO ACTION ON UPDATE NO ACTION
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
|
|
/*Table structure for table `qrtz_fired_triggers` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
|
|
|
|
|
|
CREATE TABLE `qrtz_fired_triggers` (
|
|
|
`SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`ENTRY_ID` varchar(95) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`TRIGGER_NAME` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`TRIGGER_GROUP` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`INSTANCE_NAME` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`FIRED_TIME` bigint(20) NOT NULL,
|
|
|
`SCHED_TIME` bigint(20) NOT NULL,
|
|
|
`PRIORITY` int(11) NOT NULL,
|
|
|
`STATE` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`JOB_NAME` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
`JOB_GROUP` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
`IS_NONCONCURRENT` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
`REQUESTS_RECOVERY` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
|
|
/*Table structure for table `qrtz_job_details` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `qrtz_job_details`;
|
|
|
|
|
|
CREATE TABLE `qrtz_job_details` (
|
|
|
`SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`JOB_NAME` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`JOB_GROUP` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`DESCRIPTION` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
`JOB_CLASS_NAME` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`IS_DURABLE` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`IS_NONCONCURRENT` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`IS_UPDATE_DATA` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`REQUESTS_RECOVERY` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`JOB_DATA` blob,
|
|
|
PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
|
|
/*Table structure for table `qrtz_locks` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `qrtz_locks`;
|
|
|
|
|
|
CREATE TABLE `qrtz_locks` (
|
|
|
`SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`LOCK_NAME` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
|
|
/*Table structure for table `qrtz_paused_trigger_grps` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
|
|
|
|
|
|
CREATE TABLE `qrtz_paused_trigger_grps` (
|
|
|
`SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`TRIGGER_GROUP` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
|
|
/*Table structure for table `qrtz_scheduler_state` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
|
|
|
|
|
|
CREATE TABLE `qrtz_scheduler_state` (
|
|
|
`SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`INSTANCE_NAME` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`LAST_CHECKIN_TIME` bigint(20) NOT NULL,
|
|
|
`CHECKIN_INTERVAL` bigint(20) NOT NULL,
|
|
|
PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
|
|
/*Table structure for table `qrtz_simple_triggers` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
|
|
|
|
|
|
CREATE TABLE `qrtz_simple_triggers` (
|
|
|
`SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`TRIGGER_NAME` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`TRIGGER_GROUP` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`REPEAT_COUNT` bigint(20) NOT NULL,
|
|
|
`REPEAT_INTERVAL` bigint(20) NOT NULL,
|
|
|
`TIMES_TRIGGERED` bigint(20) NOT NULL,
|
|
|
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
|
|
|
CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE NO ACTION ON UPDATE NO ACTION
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
|
|
/*Table structure for table `qrtz_simprop_triggers` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
|
|
|
|
|
|
CREATE TABLE `qrtz_simprop_triggers` (
|
|
|
`SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`TRIGGER_NAME` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`TRIGGER_GROUP` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`STR_PROP_1` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
`STR_PROP_2` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
`STR_PROP_3` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
`INT_PROP_1` int(11) DEFAULT NULL,
|
|
|
`INT_PROP_2` int(11) DEFAULT NULL,
|
|
|
`LONG_PROP_1` bigint(20) DEFAULT NULL,
|
|
|
`LONG_PROP_2` bigint(20) DEFAULT NULL,
|
|
|
`DEC_PROP_1` decimal(13,4) DEFAULT NULL,
|
|
|
`DEC_PROP_2` decimal(13,4) DEFAULT NULL,
|
|
|
`BOOL_PROP_1` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
`BOOL_PROP_2` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
|
|
|
CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE NO ACTION ON UPDATE NO ACTION
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
|
|
/*Table structure for table `qrtz_triggers` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `qrtz_triggers`;
|
|
|
|
|
|
CREATE TABLE `qrtz_triggers` (
|
|
|
`SCHED_NAME` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`TRIGGER_NAME` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`TRIGGER_GROUP` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`JOB_NAME` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`JOB_GROUP` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`DESCRIPTION` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
`NEXT_FIRE_TIME` bigint(20) DEFAULT NULL,
|
|
|
`PREV_FIRE_TIME` bigint(20) DEFAULT NULL,
|
|
|
`PRIORITY` int(11) DEFAULT NULL,
|
|
|
`TRIGGER_STATE` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`TRIGGER_TYPE` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
`START_TIME` bigint(20) NOT NULL,
|
|
|
`END_TIME` bigint(20) DEFAULT NULL,
|
|
|
`CALENDAR_NAME` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
`MISFIRE_INSTR` smallint(6) DEFAULT NULL,
|
|
|
`JOB_DATA` blob,
|
|
|
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`) USING BTREE,
|
|
|
KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
|
|
|
CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ON DELETE NO ACTION ON UPDATE NO ACTION
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
|
|
/*Table structure for table `system_dept` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_dept`;
|
|
|
|
|
|
CREATE TABLE `system_dept` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门id',
|
|
|
`name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '部门名称',
|
|
|
`parent_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '父部门id',
|
|
|
`sort` int(11) NOT NULL DEFAULT '0' COMMENT '显示顺序',
|
|
|
`leader_user_id` bigint(20) DEFAULT NULL COMMENT '负责人',
|
|
|
`phone` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '联系电话',
|
|
|
`email` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
|
|
|
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '部门状态（1正常 2停用）',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='部门表';
|
|
|
|
|
|
/*Table structure for table `system_dict_data` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_dict_data`;
|
|
|
|
|
|
CREATE TABLE `system_dict_data` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典编码',
|
|
|
`sort` int(11) NOT NULL DEFAULT '0' COMMENT '字典排序',
|
|
|
`label` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '字典标签',
|
|
|
`value` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '字典键值',
|
|
|
`dict_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '字典类型',
|
|
|
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
|
|
|
`color_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '颜色类型',
|
|
|
`css_class` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'css 样式',
|
|
|
`remark` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='字典数据表';
|
|
|
|
|
|
/*Table structure for table `system_dict_type` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_dict_type`;
|
|
|
|
|
|
CREATE TABLE `system_dict_type` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
|
|
|
`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '字典名称',
|
|
|
`type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '字典类型',
|
|
|
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
|
|
|
`remark` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`deleted_time` datetime DEFAULT NULL COMMENT '删除时间',
|
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
|
UNIQUE KEY `dict_type` (`type`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='字典类型表';
|
|
|
|
|
|
/*Table structure for table `system_error_code` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_error_code`;
|
|
|
|
|
|
CREATE TABLE `system_error_code` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '错误码编号',
|
|
|
`type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '错误码类型',
|
|
|
`application_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '应用名',
|
|
|
`code` int(11) NOT NULL DEFAULT '0' COMMENT '错误码编码',
|
|
|
`message` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '错误码错误提示',
|
|
|
`memo` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='错误码表';
|
|
|
|
|
|
/*Table structure for table `system_login_log` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_login_log`;
|
|
|
|
|
|
CREATE TABLE `system_login_log` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问ID',
|
|
|
`log_type` bigint(20) NOT NULL COMMENT '日志类型',
|
|
|
`trace_id` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '链路追踪编号',
|
|
|
`user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户编号',
|
|
|
`user_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '用户类型',
|
|
|
`username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户账号',
|
|
|
`result` tinyint(4) NOT NULL COMMENT '登陆结果',
|
|
|
`user_ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户 IP',
|
|
|
`user_agent` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '浏览器 UA',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='系统访问记录';
|
|
|
|
|
|
/*Table structure for table `system_mail_account` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_mail_account`;
|
|
|
|
|
|
CREATE TABLE `system_mail_account` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
|
|
`mail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邮箱',
|
|
|
`username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名',
|
|
|
`password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码',
|
|
|
`host` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'SMTP 服务器域名',
|
|
|
`port` int(11) NOT NULL COMMENT 'SMTP 服务器端口',
|
|
|
`ssl_enable` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否开启 SSL',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='邮箱账号表';
|
|
|
|
|
|
/*Table structure for table `system_mail_log` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_mail_log`;
|
|
|
|
|
|
CREATE TABLE `system_mail_log` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`user_id` bigint(20) DEFAULT NULL COMMENT '用户编号',
|
|
|
`user_type` tinyint(4) DEFAULT NULL COMMENT '用户类型',
|
|
|
`to_mail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '接收邮箱地址',
|
|
|
`account_id` bigint(20) NOT NULL COMMENT '邮箱账号编号',
|
|
|
`from_mail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '发送邮箱地址',
|
|
|
`template_id` bigint(20) NOT NULL COMMENT '模板编号',
|
|
|
`template_code` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模板编码',
|
|
|
`template_nickname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模版发送人名称',
|
|
|
`template_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邮件标题',
|
|
|
`template_content` varchar(10240) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邮件内容',
|
|
|
`template_params` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邮件参数',
|
|
|
`send_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '发送状态',
|
|
|
`send_time` datetime DEFAULT NULL COMMENT '发送时间',
|
|
|
`send_message_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发送返回的消息 ID',
|
|
|
`send_exception` varchar(4096) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发送异常',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='邮件日志表';
|
|
|
|
|
|
/*Table structure for table `system_mail_template` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_mail_template`;
|
|
|
|
|
|
CREATE TABLE `system_mail_template` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`name` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模板名称',
|
|
|
`code` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模板编码',
|
|
|
`account_id` bigint(20) NOT NULL COMMENT '发送的邮箱账号编号',
|
|
|
`nickname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发送人名称',
|
|
|
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模板标题',
|
|
|
`content` varchar(10240) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模板内容',
|
|
|
`params` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '参数数组',
|
|
|
`status` tinyint(4) NOT NULL COMMENT '开启状态',
|
|
|
`remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='邮件模版表';
|
|
|
|
|
|
/*Table structure for table `system_menu` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_menu`;
|
|
|
|
|
|
CREATE TABLE `system_menu` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
|
|
|
`name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '菜单名称',
|
|
|
`permission` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '权限标识',
|
|
|
`type` tinyint(4) NOT NULL COMMENT '菜单类型',
|
|
|
`sort` int(11) NOT NULL DEFAULT '0' COMMENT '显示顺序',
|
|
|
`parent_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '父菜单ID',
|
|
|
`path` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '路由地址',
|
|
|
`icon` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '#' COMMENT '菜单图标',
|
|
|
`component` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '组件路径',
|
|
|
`component_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '组件名',
|
|
|
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '菜单状态',
|
|
|
`visible` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否可见',
|
|
|
`keep_alive` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否缓存',
|
|
|
`always_show` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否总是显示',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='菜单权限表';
|
|
|
|
|
|
/*Table structure for table `system_notice` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_notice`;
|
|
|
|
|
|
CREATE TABLE `system_notice` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '公告ID',
|
|
|
`title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公告标题',
|
|
|
`content` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公告内容',
|
|
|
`type` tinyint(4) NOT NULL COMMENT '公告类型（1通知 2公告）',
|
|
|
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='通知公告表';
|
|
|
|
|
|
/*Table structure for table `system_notify_message` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_notify_message`;
|
|
|
|
|
|
CREATE TABLE `system_notify_message` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
|
|
|
`user_id` bigint(20) NOT NULL COMMENT '用户id',
|
|
|
`user_type` tinyint(4) NOT NULL COMMENT '用户类型',
|
|
|
`template_id` bigint(20) NOT NULL COMMENT '模版编号',
|
|
|
`template_code` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模板编码',
|
|
|
`template_nickname` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模版发送人名称',
|
|
|
`template_content` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模版内容',
|
|
|
`template_type` int(11) NOT NULL COMMENT '模版类型',
|
|
|
`template_params` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模版参数',
|
|
|
`read_status` bit(1) NOT NULL COMMENT '是否已读',
|
|
|
`read_time` datetime DEFAULT NULL COMMENT '阅读时间',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='站内信消息表';
|
|
|
|
|
|
/*Table structure for table `system_notify_template` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_notify_template`;
|
|
|
|
|
|
CREATE TABLE `system_notify_template` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
|
|
`name` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模板名称',
|
|
|
`code` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模版编码',
|
|
|
`nickname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '发送人名称',
|
|
|
`content` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模版内容',
|
|
|
`type` tinyint(4) NOT NULL COMMENT '类型',
|
|
|
`params` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '参数数组',
|
|
|
`status` tinyint(4) NOT NULL COMMENT '状态',
|
|
|
`remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='站内信模板表';
|
|
|
|
|
|
/*Table structure for table `system_oauth2_access_token` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_oauth2_access_token`;
|
|
|
|
|
|
CREATE TABLE `system_oauth2_access_token` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`user_id` bigint(20) NOT NULL COMMENT '用户编号',
|
|
|
`user_type` tinyint(4) NOT NULL COMMENT '用户类型',
|
|
|
`access_token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '访问令牌',
|
|
|
`refresh_token` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '刷新令牌',
|
|
|
`client_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '客户端编号',
|
|
|
`scopes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '授权范围',
|
|
|
`expires_time` datetime NOT NULL COMMENT '过期时间',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
|
KEY `idx_access_token` (`access_token`) USING BTREE,
|
|
|
KEY `idx_refresh_token` (`refresh_token`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='OAuth2 访问令牌';
|
|
|
|
|
|
/*Table structure for table `system_oauth2_approve` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_oauth2_approve`;
|
|
|
|
|
|
CREATE TABLE `system_oauth2_approve` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`user_id` bigint(20) NOT NULL COMMENT '用户编号',
|
|
|
`user_type` tinyint(4) NOT NULL COMMENT '用户类型',
|
|
|
`client_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '客户端编号',
|
|
|
`scope` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '授权范围',
|
|
|
`approved` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否接受',
|
|
|
`expires_time` datetime NOT NULL COMMENT '过期时间',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='OAuth2 批准表';
|
|
|
|
|
|
/*Table structure for table `system_oauth2_client` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_oauth2_client`;
|
|
|
|
|
|
CREATE TABLE `system_oauth2_client` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`client_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '客户端编号',
|
|
|
`secret` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '客户端密钥',
|
|
|
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '应用名',
|
|
|
`logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '应用图标',
|
|
|
`description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '应用描述',
|
|
|
`status` tinyint(4) NOT NULL COMMENT '状态',
|
|
|
`access_token_validity_seconds` int(11) NOT NULL COMMENT '访问令牌的有效期',
|
|
|
`refresh_token_validity_seconds` int(11) NOT NULL COMMENT '刷新令牌的有效期',
|
|
|
`redirect_uris` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '可重定向的 URI 地址',
|
|
|
`authorized_grant_types` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '授权类型',
|
|
|
`scopes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '授权范围',
|
|
|
`auto_approve_scopes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自动通过的授权范围',
|
|
|
`authorities` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '权限',
|
|
|
`resource_ids` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '资源',
|
|
|
`additional_information` varchar(4096) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '附加信息',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='OAuth2 客户端表';
|
|
|
|
|
|
/*Table structure for table `system_oauth2_code` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_oauth2_code`;
|
|
|
|
|
|
CREATE TABLE `system_oauth2_code` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`user_id` bigint(20) NOT NULL COMMENT '用户编号',
|
|
|
`user_type` tinyint(4) NOT NULL COMMENT '用户类型',
|
|
|
`code` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '授权码',
|
|
|
`client_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '客户端编号',
|
|
|
`scopes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '授权范围',
|
|
|
`expires_time` datetime NOT NULL COMMENT '过期时间',
|
|
|
`redirect_uri` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '可重定向的 URI 地址',
|
|
|
`state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '状态',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='OAuth2 授权码表';
|
|
|
|
|
|
/*Table structure for table `system_oauth2_refresh_token` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_oauth2_refresh_token`;
|
|
|
|
|
|
CREATE TABLE `system_oauth2_refresh_token` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`user_id` bigint(20) NOT NULL COMMENT '用户编号',
|
|
|
`refresh_token` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '刷新令牌',
|
|
|
`user_type` tinyint(4) NOT NULL COMMENT '用户类型',
|
|
|
`client_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '客户端编号',
|
|
|
`scopes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '授权范围',
|
|
|
`expires_time` datetime NOT NULL COMMENT '过期时间',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='OAuth2 刷新令牌';
|
|
|
|
|
|
/*Table structure for table `system_operate_log` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_operate_log`;
|
|
|
|
|
|
CREATE TABLE `system_operate_log` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
|
|
|
`trace_id` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '链路追踪编号',
|
|
|
`business_type` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '业务类型 用于业务关联',
|
|
|
`business_id` bigint(20) DEFAULT NULL COMMENT '业务id',
|
|
|
`user_id` bigint(20) NOT NULL COMMENT '用户编号',
|
|
|
`user_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '用户类型',
|
|
|
`module` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模块标题',
|
|
|
`name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '操作名',
|
|
|
`type` bigint(20) NOT NULL DEFAULT '0' COMMENT '操作分类',
|
|
|
`content` text COLLATE utf8mb4_unicode_ci COMMENT '操作内容',
|
|
|
`exts` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '拓展字段',
|
|
|
`request_method` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '请求方法名',
|
|
|
`request_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '请求地址',
|
|
|
`user_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户 IP',
|
|
|
`user_agent` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '浏览器 UA',
|
|
|
`java_method` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Java 方法名',
|
|
|
`java_method_args` text COLLATE utf8mb4_unicode_ci COMMENT 'Java 方法的参数',
|
|
|
`start_time` datetime NOT NULL COMMENT '操作时间',
|
|
|
`duration` int(11) NOT NULL COMMENT '执行时长',
|
|
|
`result_code` int(11) NOT NULL DEFAULT '0' COMMENT '结果码',
|
|
|
`result_msg` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '结果提示',
|
|
|
`result_data` text COLLATE utf8mb4_unicode_ci COMMENT '结果数据',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
|
KEY `idx_business` (`business_type`,`business_id`)
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='操作日志记录';
|
|
|
|
|
|
/*Table structure for table `system_post` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_post`;
|
|
|
|
|
|
CREATE TABLE `system_post` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
|
|
|
`code` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '岗位编码',
|
|
|
`name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '岗位名称',
|
|
|
`sort` int(11) NOT NULL COMMENT '显示顺序',
|
|
|
`status` tinyint(4) NOT NULL COMMENT '状态（0正常 1停用）',
|
|
|
`remark` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='岗位信息表';
|
|
|
|
|
|
/*Table structure for table `system_role` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_role`;
|
|
|
|
|
|
CREATE TABLE `system_role` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
|
|
|
`name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色名称',
|
|
|
`code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色权限字符串',
|
|
|
`sort` int(11) NOT NULL COMMENT '显示顺序',
|
|
|
`data_scope` tinyint(4) NOT NULL DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
|
|
|
`data_scope_dept_ids` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '数据范围(指定部门数组)',
|
|
|
`status` tinyint(4) NOT NULL COMMENT '角色状态（0正常 1停用）',
|
|
|
`type` tinyint(4) NOT NULL COMMENT '角色类型',
|
|
|
`remark` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='角色信息表';
|
|
|
|
|
|
/*Table structure for table `system_role_menu` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_role_menu`;
|
|
|
|
|
|
CREATE TABLE `system_role_menu` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增编号',
|
|
|
`role_id` bigint(20) NOT NULL COMMENT '角色ID',
|
|
|
`menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='角色和菜单关联表';
|
|
|
|
|
|
/*Table structure for table `system_sensitive_word` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_sensitive_word`;
|
|
|
|
|
|
CREATE TABLE `system_sensitive_word` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '敏感词',
|
|
|
`description` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
|
|
|
`tags` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标签数组',
|
|
|
`status` tinyint(4) NOT NULL COMMENT '状态',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='敏感词';
|
|
|
|
|
|
/*Table structure for table `system_sms_channel` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_sms_channel`;
|
|
|
|
|
|
CREATE TABLE `system_sms_channel` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`signature` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '短信签名',
|
|
|
`code` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '渠道编码',
|
|
|
`status` tinyint(4) NOT NULL COMMENT '开启状态',
|
|
|
`remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
|
|
|
`api_key` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '短信 API 的账号',
|
|
|
`api_secret` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '短信 API 的秘钥',
|
|
|
`callback_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '短信发送回调 URL',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='短信渠道';
|
|
|
|
|
|
/*Table structure for table `system_sms_code` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_sms_code`;
|
|
|
|
|
|
CREATE TABLE `system_sms_code` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`mobile` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '手机号',
|
|
|
`code` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '验证码',
|
|
|
`create_ip` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '创建 IP',
|
|
|
`scene` tinyint(4) NOT NULL COMMENT '发送场景',
|
|
|
`today_index` tinyint(4) NOT NULL COMMENT '今日发送的第几条',
|
|
|
`used` tinyint(4) NOT NULL COMMENT '是否使用',
|
|
|
`used_time` datetime DEFAULT NULL COMMENT '使用时间',
|
|
|
`used_ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '使用 IP',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
|
KEY `idx_mobile` (`mobile`) USING BTREE COMMENT '手机号'
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='手机验证码';
|
|
|
|
|
|
/*Table structure for table `system_sms_log` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_sms_log`;
|
|
|
|
|
|
CREATE TABLE `system_sms_log` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`channel_id` bigint(20) NOT NULL COMMENT '短信渠道编号',
|
|
|
`channel_code` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '短信渠道编码',
|
|
|
`template_id` bigint(20) NOT NULL COMMENT '模板编号',
|
|
|
`template_code` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模板编码',
|
|
|
`template_type` tinyint(4) NOT NULL COMMENT '短信类型',
|
|
|
`template_content` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '短信内容',
|
|
|
`template_params` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '短信参数',
|
|
|
`api_template_id` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '短信 API 的模板编号',
|
|
|
`mobile` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '手机号',
|
|
|
`user_id` bigint(20) DEFAULT NULL COMMENT '用户编号',
|
|
|
`user_type` tinyint(4) DEFAULT NULL COMMENT '用户类型',
|
|
|
`send_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '发送状态',
|
|
|
`send_time` datetime DEFAULT NULL COMMENT '发送时间',
|
|
|
`api_send_code` varchar(63) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '短信 API 发送结果的编码',
|
|
|
`api_send_msg` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '短信 API 发送失败的提示',
|
|
|
`api_request_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '短信 API 发送返回的唯一请求 ID',
|
|
|
`api_serial_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '短信 API 发送返回的序号',
|
|
|
`receive_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '接收状态',
|
|
|
`receive_time` datetime DEFAULT NULL COMMENT '接收时间',
|
|
|
`api_receive_code` varchar(63) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'API 接收结果的编码',
|
|
|
`api_receive_msg` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'API 接收结果的说明',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='短信日志';
|
|
|
|
|
|
/*Table structure for table `system_sms_template` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_sms_template`;
|
|
|
|
|
|
CREATE TABLE `system_sms_template` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`type` tinyint(4) NOT NULL COMMENT '短信签名',
|
|
|
`status` tinyint(4) NOT NULL COMMENT '开启状态',
|
|
|
`code` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模板编码',
|
|
|
`name` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模板名称',
|
|
|
`content` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模板内容',
|
|
|
`params` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '参数数组',
|
|
|
`remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
|
|
|
`api_template_id` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '短信 API 的模板编号',
|
|
|
`channel_id` bigint(20) NOT NULL COMMENT '短信渠道编号',
|
|
|
`channel_code` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '短信渠道编码',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='短信模板';
|
|
|
|
|
|
/*Table structure for table `system_social_client` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_social_client`;
|
|
|
|
|
|
CREATE TABLE `system_social_client` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
|
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '应用名',
|
|
|
`social_type` tinyint(4) NOT NULL COMMENT '社交平台的类型',
|
|
|
`user_type` tinyint(4) NOT NULL COMMENT '用户类型',
|
|
|
`client_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '客户端编号',
|
|
|
`client_secret` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '客户端密钥',
|
|
|
`agent_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '代理编号',
|
|
|
`status` tinyint(4) NOT NULL COMMENT '状态',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='社交客户端表';
|
|
|
|
|
|
/*Table structure for table `system_social_user` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_social_user`;
|
|
|
|
|
|
CREATE TABLE `system_social_user` (
|
|
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键(自增策略)',
|
|
|
`type` tinyint(4) NOT NULL COMMENT '社交平台的类型',
|
|
|
`openid` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '社交 openid',
|
|
|
`token` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '社交 token',
|
|
|
`raw_token_info` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '原始 Token 数据，一般是 JSON 格式',
|
|
|
`nickname` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户昵称',
|
|
|
`avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户头像',
|
|
|
`raw_user_info` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '原始用户数据，一般是 JSON 格式',
|
|
|
`code` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '最后一次的认证 code',
|
|
|
`state` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '最后一次的认证 state',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='社交用户表';
|
|
|
|
|
|
/*Table structure for table `system_social_user_bind` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_social_user_bind`;
|
|
|
|
|
|
CREATE TABLE `system_social_user_bind` (
|
|
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键(自增策略)',
|
|
|
`user_id` bigint(20) NOT NULL COMMENT '用户编号',
|
|
|
`user_type` tinyint(4) NOT NULL COMMENT '用户类型',
|
|
|
`social_type` tinyint(4) NOT NULL COMMENT '社交平台的类型',
|
|
|
`social_user_id` bigint(20) NOT NULL COMMENT '社交用户的编号',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='社交绑定表';
|
|
|
|
|
|
/*Table structure for table `system_tenant` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_tenant`;
|
|
|
|
|
|
CREATE TABLE `system_tenant` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '租户编号',
|
|
|
`name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '租户名',
|
|
|
`contact_user_id` bigint(20) DEFAULT NULL COMMENT '联系人的用户编号',
|
|
|
`contact_name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '联系人',
|
|
|
`contact_mobile` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '联系手机',
|
|
|
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '租户状态（0正常 1停用）',
|
|
|
`website` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '绑定域名',
|
|
|
`package_id` bigint(20) NOT NULL COMMENT '租户套餐编号',
|
|
|
`expire_time` datetime NOT NULL COMMENT '过期时间',
|
|
|
`account_count` int(11) NOT NULL COMMENT '账号数量',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='租户表';
|
|
|
|
|
|
/*Table structure for table `system_tenant_package` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_tenant_package`;
|
|
|
|
|
|
CREATE TABLE `system_tenant_package` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '套餐编号',
|
|
|
`name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '套餐名',
|
|
|
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '租户状态（0正常 1停用）',
|
|
|
`remark` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注',
|
|
|
`menu_ids` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '关联的菜单编号',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='租户套餐表';
|
|
|
|
|
|
/*Table structure for table `system_user_post` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_user_post`;
|
|
|
|
|
|
CREATE TABLE `system_user_post` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
|
|
`user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户ID',
|
|
|
`post_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '岗位ID',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='用户岗位表';
|
|
|
|
|
|
/*Table structure for table `system_user_role` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_user_role`;
|
|
|
|
|
|
CREATE TABLE `system_user_role` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增编号',
|
|
|
`user_id` bigint(20) NOT NULL COMMENT '用户ID',
|
|
|
`role_id` bigint(20) NOT NULL COMMENT '角色ID',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='用户和角色关联表';
|
|
|
|
|
|
/*Table structure for table `system_users` */
|
|
|
|
|
|
DROP TABLE IF EXISTS `system_users`;
|
|
|
|
|
|
CREATE TABLE `system_users` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
|
|
|
`username` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户账号',
|
|
|
`password` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '密码',
|
|
|
`nickname` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户昵称',
|
|
|
`remark` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
|
|
|
`dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
|
|
|
`post_ids` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '岗位编号数组',
|
|
|
`email` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '用户邮箱',
|
|
|
`mobile` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '手机号码',
|
|
|
`sex` tinyint(4) DEFAULT '0' COMMENT '用户性别',
|
|
|
`avatar` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '头像地址',
|
|
|
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '帐号状态（1正常 2停用）',
|
|
|
`login_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '最后登录IP',
|
|
|
`login_date` datetime DEFAULT NULL COMMENT '最后登录时间',
|
|
|
`creator` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
|
`updater` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
|
|
`tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
|
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
|
UNIQUE KEY `idx_username` (`username`,`update_time`,`tenant_id`) USING BTREE
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='用户信息表';
|
|
|
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
