创建 demo项目表

2024-02-01 21:36•mysql•阅读 92

Navicat Premium Data Transfer

Source Server : localhost

Source Server Type : MySQL

Source Server Version : 80023

Source Host : 127.0.0.1:3306

Source Schema : demo

Target Server Type : MySQL

Target Server Version : 80023

File Encoding : 65001

Date: 09/08/2021 00:10:13

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------

-- Table structure for cs_t_area

-- ----------------------------

DROP TABLE IF EXISTS `cs_t_area`;

CREATE TABLE `cs_t_area` (

`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',

`area_code` int(0) UNSIGNED NOT NULL COMMENT '区域编码',

`city_code` int(0) NULL DEFAULT NULL COMMENT '父级市代码',

`area_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '市名称',

`short_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '简称',

`lng` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '经度',

`lat` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '纬度',

`sort` int(0) NULL DEFAULT NULL COMMENT '排序',

`memo` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',

`data_state` int(0) NULL DEFAULT NULL COMMENT '状态',

`tenant_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '租户ID',

`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后更新时间',

`deleted` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',

PRIMARY KEY (`id`) USING BTREE,

INDEX `inx_id_tenant_code`(`area_code`, `tenant_code`) USING BTREE,

INDEX `inx_city_code`(`city_code`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '参数地区表' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Table structure for cs_t_city

-- ----------------------------

DROP TABLE IF EXISTS `cs_t_city`;

CREATE TABLE `cs_t_city` (

`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '自增列',

`city_code` int(0) UNSIGNED NOT NULL COMMENT '市代码',

`city_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '市名称',

`short_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '简称',

`province_code` int(0) NULL DEFAULT NULL COMMENT '省代码',

`lng` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '经度',

`lat` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '纬度',

`sort` int(0) NULL DEFAULT NULL COMMENT '排序',

`memo` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',

`data_state` int(0) NULL DEFAULT NULL COMMENT '状态',

`tenant_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '租户ID',

`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',

`deleted` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',

PRIMARY KEY (`id`) USING BTREE,

INDEX `Index_1`(`city_code`, `tenant_code`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '参数城市表' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Table structure for cs_t_dict

-- ----------------------------

DROP TABLE IF EXISTS `cs_t_dict`;

CREATE TABLE `cs_t_dict` (

`id` bigint(0) NOT NULL AUTO_INCREMENT,

`type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字典类型',

`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字典名称',

`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '描述',

`create_by` bigint(0) NULL DEFAULT NULL COMMENT '创建人',

`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`update_by` bigint(0) NULL DEFAULT NULL COMMENT '更新人',

`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

`deleted` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '参数字典表' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Table structure for cs_t_dict_item

-- ----------------------------

DROP TABLE IF EXISTS `cs_t_dict_item`;

CREATE TABLE `cs_t_dict_item` (

`id` bigint(0) NOT NULL AUTO_INCREMENT,

`dict_id` bigint(0) NULL DEFAULT NULL COMMENT '字典id',

`type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字典类型',

`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字典名称',

`pkey` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字典项键',

`pval` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字典项值',

`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '描述',

`order_num` int(0) NULL DEFAULT NULL COMMENT '排序',

`create_by` bigint(0) NULL DEFAULT NULL COMMENT '创建人',

`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`update_by` bigint(0) NULL DEFAULT NULL COMMENT '更新人',

`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

`deleted` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------

-- Table structure for cs_t_oss

-- ----------------------------

DROP TABLE IF EXISTS `cs_t_oss`;

CREATE TABLE `cs_t_oss` (

`id` bigint(0) NOT NULL,

`yun_id` bigint(0) NULL DEFAULT NULL COMMENT '云id',

`type` int(0) NOT NULL COMMENT '业务类型',

`description` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '业务描述',

`bucket` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'oss Bucket名称',

`oss_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'oss路径',

`create_by` bigint(0) NULL DEFAULT NULL COMMENT '创建人',

`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`update_by` bigint(0) NULL DEFAULT NULL COMMENT '更新人',

`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

`deleted` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '参数 OSS配置表' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Table structure for cs_t_province

-- ----------------------------

DROP TABLE IF EXISTS `cs_t_province`;

CREATE TABLE `cs_t_province` (

`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '自增列',

`province_code` int(0) NOT NULL COMMENT '省份代码',

`province_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '省份名称',

`short_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '简称',

`lng` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经度',

`lat` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纬度',

`sort` int(0) NULL DEFAULT NULL COMMENT '排序',

`memo` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',

`data_state` int(0) NULL DEFAULT NULL COMMENT '状态',

`tenant_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',

`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',

`deleted` tinyint(1) NOT NULL DEFAULT 0,

PRIMARY KEY (`id`) USING BTREE,

INDEX `Index_1`(`province_code`, `tenant_code`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '参数省份表' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Table structure for cs_t_sms

-- ----------------------------

DROP TABLE IF EXISTS `cs_t_sms`;

CREATE TABLE `cs_t_sms` (

`id` bigint(0) NOT NULL DEFAULT 0,

`yun_id` bigint(0) NULL DEFAULT NULL COMMENT '云id',

`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

`job_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

`template_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

`type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

`status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

`sms_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

`create_by` bigint(0) NULL DEFAULT NULL COMMENT '创建人',

`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`update_by` bigint(0) NULL DEFAULT NULL COMMENT '更新人',

`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

`deleted` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '参数短信模板表' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Table structure for cs_t_timer

-- ----------------------------

DROP TABLE IF EXISTS `cs_t_timer`;

CREATE TABLE `cs_t_timer` (

`id` bigint(0) NOT NULL AUTO_INCREMENT,

`task_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '任务方法',

`task_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '任务名称',

`task_params` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '任务参数',

`create_by` bigint(0) NULL DEFAULT NULL COMMENT '创建人',

`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`update_by` bigint(0) NULL DEFAULT NULL COMMENT '更新人',

`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

`deleted` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '参数定时任务表' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Table structure for cs_t_yun

-- ----------------------------

DROP TABLE IF EXISTS `cs_t_yun`;

CREATE TABLE `cs_t_yun` (

`id` bigint(0) NOT NULL DEFAULT 0,

`type` smallint(0) NULL DEFAULT NULL,

`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '配置名称',

`access_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'AccesskeyID',

`access_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'AccessKeySecret',

`region_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '发短信 regionId',

`dysms_api` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'dysmsApi',

`sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '签名',

`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

`deleted` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除'

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '参数云配置表' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Table structure for sys_t_element

-- ----------------------------

DROP TABLE IF EXISTS `sys_t_element`;

CREATE TABLE `sys_t_element` (

`id` bigint(0) NOT NULL AUTO_INCREMENT,

`menu_id` bigint(0) NULL DEFAULT NULL,

`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

`method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

`deleted` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统菜单元素表' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Table structure for sys_t_login_log

-- ----------------------------

DROP TABLE IF EXISTS `sys_t_login_log`;

CREATE TABLE `sys_t_login_log` (

`id` int(0) NOT NULL,

`login_host` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登录主机',

`login_user_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登录用户名',

`status` tinyint(1) NULL DEFAULT NULL COMMENT '登录状态',

`login_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登录结果',

`owner_id` bigint(0) NULL DEFAULT NULL COMMENT '所属机构',

`create_by` bigint(0) NULL DEFAULT NULL COMMENT '创建人',

`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

`deleted` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统登录日志表' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Table structure for sys_t_menu

-- ----------------------------

DROP TABLE IF EXISTS `sys_t_menu`;

CREATE TABLE `sys_t_menu` (

`id` bigint(0) NOT NULL,

`code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

`title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

`pid` bigint(0) NULL DEFAULT NULL,

`icon` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

`path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

`enabled` tinyint(1) NULL DEFAULT NULL,

`view_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

`deleted` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统菜单表' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Table structure for sys_t_operate_log

-- ----------------------------

DROP TABLE IF EXISTS `sys_t_operate_log`;

CREATE TABLE `sys_t_operate_log` (

`id` bigint(0) NOT NULL AUTO_INCREMENT,

`uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '资源路径',

`operate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作',

`operate_host` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作主机',

`params` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作参数',

`owner_id` bigint(0) NULL DEFAULT NULL COMMENT '所属机构',

`create_by` bigint(0) NULL DEFAULT NULL COMMENT '创建人',

`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

`deleted` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统操作日志表' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Table structure for sys_t_role

-- ----------------------------

DROP TABLE IF EXISTS `sys_t_role`;

CREATE TABLE `sys_t_role` (

`id` bigint(0) NOT NULL AUTO_INCREMENT,

`code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '角色编码',

`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '角色名称',

`parent_id` bigint(0) NULL DEFAULT NULL COMMENT '上级节点',

`path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '树状关系',

`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '角色描述',

`owner_id` bigint(0) NULL DEFAULT NULL COMMENT '所属机构',

`status` tinyint(1) NULL DEFAULT 1 COMMENT '是否启用：0禁用，1启用,默认为1',

`create_by` bigint(0) NULL DEFAULT NULL COMMENT '创建人',

`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`update_by` bigint(0) NULL DEFAULT NULL COMMENT '更新人',

`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

`deleted` tinyint(1) UNSIGNED ZEROFILL NULL DEFAULT 0 COMMENT '是否删除',

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统角色（组、部门、岗位）表' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Table structure for sys_t_role_member

-- ----------------------------

DROP TABLE IF EXISTS `sys_t_role_member`;

CREATE TABLE `sys_t_role_member` (

`id` bigint(0) NOT NULL AUTO_INCREMENT,

`role_id` bigint(0) NULL DEFAULT NULL COMMENT '角色组id',

`user_id` bigint(0) NULL DEFAULT NULL COMMENT '用户id',

`is_leader` tinyint(1) NOT NULL COMMENT '是否是领导: 0不是、1是',

`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

`create_time` datetime(0) NULL DEFAULT NULL,

`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),

`deleted` tinyint(1) NULL DEFAULT 0,

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统角色用户关系表' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Table structure for sys_t_role_resource

-- ----------------------------

DROP TABLE IF EXISTS `sys_t_role_resource`;

CREATE TABLE `sys_t_role_resource` (

`id` bigint(0) NOT NULL AUTO_INCREMENT,

`role_id` bigint(0) NULL DEFAULT NULL COMMENT '角色ID',

`resource_type` tinyint(1) NULL DEFAULT NULL COMMENT '资源类型1菜单2按钮',

`resource_id` bigint(0) NULL DEFAULT NULL COMMENT '资源ID',

`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '描述',

`create_by` bigint(0) NULL DEFAULT NULL COMMENT '创建人',

`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`update_by` bigint(0) NULL DEFAULT NULL COMMENT '更新人',

`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

`deleted` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统角色资源关系表' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Table structure for sys_t_timer_log

-- ----------------------------

DROP TABLE IF EXISTS `sys_t_timer_log`;

CREATE TABLE `sys_t_timer_log` (

`id` bigint(0) NOT NULL AUTO_INCREMENT,

`task_id` bigint(0) NULL DEFAULT NULL COMMENT '任务id',

`task_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '任务方法',

`task_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '任务名称',

`task_params` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '任务参数',

`exec_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行结果',

`exec_time` int(0) NULL DEFAULT NULL COMMENT '执行时长',

`exec_date` datetime(0) NULL DEFAULT NULL COMMENT '执行日期',

`status` tinyint(1) NULL DEFAULT 1 COMMENT '运行状态',

`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

`deleted` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统定时任务日志' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Table structure for sys_t_user

-- ----------------------------

DROP TABLE IF EXISTS `sys_t_user`;

CREATE TABLE `sys_t_user` (

`id` bigint(0) NOT NULL AUTO_INCREMENT,

`user_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名',

`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',

`mobile_phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手机号',

`sex` tinyint(1) NULL DEFAULT NULL COMMENT '性别',

`status` tinyint(1) NULL DEFAULT 1 COMMENT '状态',

`nickname` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '昵称',

`email` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮箱',

`owner_id` bigint(0) NULL DEFAULT NULL COMMENT '所属机构',

`create_by` bigint(0) NULL DEFAULT NULL COMMENT '创建人',

`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`update_by` bigint(0) NULL DEFAULT NULL COMMENT '更新人',

`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

`deleted` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',

`password1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '历史密码1',

`password2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '历史密码2',

`password3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '历史密码3',

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统用户表' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

上一篇 »数据结构与算法之线性表(超详细顺序表、链表)
下一篇 »第一个ext.js demo

创建 demo项目表

相关推荐

爬虫1：html页面+beautifulsoap模块+get方式+demo

[PHP] 项目实践中使用的IOC容器思想

自己用的PHP源码批量压缩

PHP开发之thinkPHP分层设计

爬虫2：html页面+beautifulsoap模块+post方式+demo

爬虫3：html页面+webdriver模块+demo

Linux发行版：CentOS、Ubuntu、RedHat、Android、Tizen、MeeGo

Strophe Javascript XMPP实现库 Hello World