tupianhecheng-api/db_image_synthesis20230701.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 80012
Source Host           : localhost:3306
Source Database       : db_image_synthesis

Target Server Type    : MYSQL
Target Server Version : 80012
File Encoding         : 65001

Date: 2023-07-01 17:08:56
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `id` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '主键',
  `org_id` int(11) DEFAULT NULL COMMENT '园区代码',
  `dept_no` varchar(18) CHARACTER SET utf8 DEFAULT NULL COMMENT '部门编号(规则：父级关系编码+自己的编码)',
  `name` varchar(300) CHARACTER SET utf8 DEFAULT NULL COMMENT '部门名称',
  `pid` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '父级id',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态(1:正常；0:弃用)',
  `relation_code` varchar(3000) CHARACTER SET utf8 DEFAULT NULL COMMENT '为了维护更深层级关系',
  `dept_manager_id` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '部门经理user_id',
  `manager_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '部门经理名称',
  `phone` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '部门经理联系电话',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(4) DEFAULT NULL COMMENT '是否删除(1未删除；0已删除)',
  `email` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '部门经理邮箱',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统部门';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data` (
  `dict_code` int(11) NOT NULL AUTO_INCREMENT COMMENT '字典编码',
  `dict_sort` int(4) DEFAULT '0' COMMENT '字典排序',
  `dict_label` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '字典标签',
  `dict_value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '字典键值',
  `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '字典类型',
  `css_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
  `list_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '表格回显样式',
  `is_default` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_code`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='字典数据表';

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
INSERT INTO `sys_dict_data` VALUES ('1', '1', '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2023-04-29 12:57:27', '', null, '性别男');
INSERT INTO `sys_dict_data` VALUES ('2', '2', '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '性别女');
INSERT INTO `sys_dict_data` VALUES ('3', '3', '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '性别未知');
INSERT INTO `sys_dict_data` VALUES ('4', '1', '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2023-04-29 12:57:27', '', null, '显示菜单');
INSERT INTO `sys_dict_data` VALUES ('5', '2', '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '隐藏菜单');
INSERT INTO `sys_dict_data` VALUES ('6', '1', '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2023-04-29 12:57:27', '', null, '正常状态');
INSERT INTO `sys_dict_data` VALUES ('7', '2', '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '停用状态');
INSERT INTO `sys_dict_data` VALUES ('8', '1', '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2023-04-29 12:57:27', '', null, '正常状态');
INSERT INTO `sys_dict_data` VALUES ('9', '2', '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '停用状态');
INSERT INTO `sys_dict_data` VALUES ('10', '1', '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2023-04-29 12:57:27', '', null, '默认分组');
INSERT INTO `sys_dict_data` VALUES ('11', '2', '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '系统分组');
INSERT INTO `sys_dict_data` VALUES ('12', '1', '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2023-04-29 12:57:27', '', null, '系统默认是');
INSERT INTO `sys_dict_data` VALUES ('13', '2', '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '系统默认否');
INSERT INTO `sys_dict_data` VALUES ('14', '1', '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2023-04-29 12:57:27', '', null, '通知');
INSERT INTO `sys_dict_data` VALUES ('15', '2', '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '公告');
INSERT INTO `sys_dict_data` VALUES ('16', '1', '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2023-04-29 12:57:27', '', null, '正常状态');
INSERT INTO `sys_dict_data` VALUES ('17', '2', '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '关闭状态');
INSERT INTO `sys_dict_data` VALUES ('18', '99', '其他', '0', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '其他操作');
INSERT INTO `sys_dict_data` VALUES ('19', '1', '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '新增操作');
INSERT INTO `sys_dict_data` VALUES ('20', '2', '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '修改操作');
INSERT INTO `sys_dict_data` VALUES ('21', '3', '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '删除操作');
INSERT INTO `sys_dict_data` VALUES ('22', '4', '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '授权操作');
INSERT INTO `sys_dict_data` VALUES ('23', '5', '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '导出操作');
INSERT INTO `sys_dict_data` VALUES ('24', '6', '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '导入操作');
INSERT INTO `sys_dict_data` VALUES ('25', '7', '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '强退操作');
INSERT INTO `sys_dict_data` VALUES ('26', '8', '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '生成操作');
INSERT INTO `sys_dict_data` VALUES ('27', '9', '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '清空操作');
INSERT INTO `sys_dict_data` VALUES ('28', '1', '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '正常状态');
INSERT INTO `sys_dict_data` VALUES ('29', '2', '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2023-04-29 12:57:27', '', null, '停用状态');
INSERT INTO `sys_dict_data` VALUES ('31', '1', '黑色', 'black', 'sys_color', null, null, 'N', '0', '', null, '', null, '黑色ccceeeee');
INSERT INTO `sys_dict_data` VALUES ('32', '1', '黑色', 'black', 'sys_color', null, null, 'N', '0', '', '2023-06-26 11:11:00', '', '2023-06-26 11:11:15', '黑色ccceeeee');
INSERT INTO `sys_dict_data` VALUES ('33', '1', '黑色', 'black', 'sys_color', null, null, 'N', '0', '', '2023-06-27 10:10:10', '', '2023-06-27 10:10:10', '黑色ccc');
INSERT INTO `sys_dict_data` VALUES ('38', '0', '微软雅黑', '微软雅黑', 'SYS_FONT_STYLE', null, null, 'N', '0', '', '2023-06-27 15:07:34', '', '2023-06-27 15:07:34', '微软雅黑');
INSERT INTO `sys_dict_data` VALUES ('39', '1', '楷体', '楷体', 'SYS_FONT_STYLE', null, null, 'N', '0', '', '2023-06-27 15:07:54', '', '2023-06-27 15:07:54', '楷体');
INSERT INTO `sys_dict_data` VALUES ('40', '2', '宋体', '宋体', 'SYS_FONT_STYLE', null, null, 'N', '0', '', '2023-06-27 15:08:14', '', '2023-06-27 15:08:14', '宋体');
INSERT INTO `sys_dict_data` VALUES ('42', '0', '黑色', 'BLACK', 'SYS_FONT_COLOR', null, null, 'N', '0', '', '2023-06-27 15:11:49', '', '2023-06-27 15:11:49', '');
INSERT INTO `sys_dict_data` VALUES ('43', '1', '白色', 'WHITE', 'SYS_FONT_COLOR', null, null, 'N', '0', '', '2023-06-27 15:12:05', '', '2023-06-27 15:12:05', '');
INSERT INTO `sys_dict_data` VALUES ('44', '2', '灰色', 'GRAY', 'SYS_FONT_COLOR', null, null, 'N', '0', '', '2023-06-27 15:12:32', '', '2023-06-27 15:12:32', '');
INSERT INTO `sys_dict_data` VALUES ('45', '3', '红色', 'RED', 'SYS_FONT_COLOR', null, null, 'N', '0', '', '2023-06-27 15:12:48', '', '2023-06-27 15:12:48', '');
INSERT INTO `sys_dict_data` VALUES ('46', '4', '粉红色', 'PINk', 'SYS_FONT_COLOR', null, null, 'N', '0', '', '2023-06-27 15:13:10', '', '2023-06-27 15:13:10', '');
INSERT INTO `sys_dict_data` VALUES ('47', '5', '橘黄色', 'ORANGE', 'SYS_FONT_COLOR', null, null, 'N', '0', '', '2023-06-27 15:13:28', '', '2023-06-27 15:13:28', '');
INSERT INTO `sys_dict_data` VALUES ('48', '6', '黄色', 'YELLOW', 'SYS_FONT_COLOR', null, null, 'N', '0', '', '2023-06-27 15:14:03', '', '2023-06-27 15:14:03', '');
INSERT INTO `sys_dict_data` VALUES ('49', '3', '西文字体', '西文字体', 'SYS_FONT_STYLE', null, null, 'N', '0', '', '2023-06-27 19:17:58', '', '2023-06-28 10:52:15', '');
INSERT INTO `sys_dict_data` VALUES ('50', '4', '黑体', '黑体', 'SYS_FONT_STYLE', null, null, 'N', '0', '', '2023-06-28 10:13:40', '', '2023-06-28 10:13:40', '');
INSERT INTO `sys_dict_data` VALUES ('51', '5', '华文细黑', '华文细黑', 'SYS_FONT_STYLE', null, null, 'N', '0', '', '2023-06-28 10:51:52', '', '2023-06-28 10:51:52', '');
INSERT INTO `sys_dict_data` VALUES ('52', '6', '行楷', 'Xingkai SC', 'SYS_FONT_STYLE', null, null, 'N', '0', '', '2023-06-28 10:53:48', '', '2023-06-28 11:14:36', '');
INSERT INTO `sys_dict_data` VALUES ('54', '7', '圆体', 'Yuanti SC', 'SYS_FONT_STYLE', null, null, 'N', '0', '', '2023-06-28 10:55:18', '', '2023-06-28 11:15:31', '');
INSERT INTO `sys_dict_data` VALUES ('55', '8', '隶书', 'LiSu', 'SYS_FONT_STYLE', null, null, 'N', '0', '', '2023-06-28 10:55:40', '', '2023-06-28 11:12:37', '');
INSERT INTO `sys_dict_data` VALUES ('56', '9', '中易宋体', '中易宋体', 'SYS_FONT_STYLE', null, null, 'N', '0', '', '2023-06-28 10:56:32', '', '2023-06-28 10:59:20', '');
INSERT INTO `sys_dict_data` VALUES ('58', '11', 'Helvetica', 'Helvetica', 'SYS_FONT_STYLE', null, null, 'N', '0', '', '2023-06-28 10:58:58', '', '2023-06-28 10:58:58', '');

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type` (
  `dict_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
  `dict_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '字典名称',
  `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '字典类型',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_id`),
  UNIQUE KEY `dict_type` (`dict_type`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='字典类型表';

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
INSERT INTO `sys_dict_type` VALUES ('21', '字体颜色', 'SYS_FONT_COLOR', '0', '', '2023-06-27 11:23:21', '', '2023-06-27 11:23:21', '字体颜色列表');
INSERT INTO `sys_dict_type` VALUES ('24', '字体类型', 'SYS_FONT_STYLE', '0', '', '2023-06-27 11:43:06', '', '2023-06-27 11:43:06', '字体类型列表');

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` varchar(64) CHARACTER SET utf8 NOT NULL,
  `user_id` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '用户id',
  `username` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '用户名',
  `operation` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '用户操作',
  `time` int(11) DEFAULT NULL COMMENT '响应时间',
  `method` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '请求方法',
  `params` varchar(5000) CHARACTER SET utf8 DEFAULT NULL COMMENT '请求参数',
  `ip` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT 'IP地址',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统日志';

-- ----------------------------
-- Records of sys_log
-- ----------------------------

-- ----------------------------
-- Table structure for sys_menus
-- ----------------------------
DROP TABLE IF EXISTS `sys_menus`;
CREATE TABLE `sys_menus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单name',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '菜单名称',
  `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '上级id',
  `type` int(11) DEFAULT NULL COMMENT '菜单类型【1菜单2按钮】',
  `path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '路径（URL）',
  `component` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'vue文件路径',
  `redirect` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '重定向',
  `meta` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'meta',
  `sort` int(11) DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '1',
  `deleted_at` datetime DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='菜单表';

-- ----------------------------
-- Records of sys_menus
-- ----------------------------
INSERT INTO `sys_menus` VALUES ('1', '模板管理', 'Infomation', '0', '1', '/Infomation/index', 'Layout', '', '{\"title\":\"模板管理\",\"icon\":\"file-shield-2-line\",\"hidden\":0}', '0', '1', null, '2023-07-01 10:39:24', '2023-07-01 10:39:24');
INSERT INTO `sys_menus` VALUES ('2', '模板列表', 'InfomationList', '1', '1', '/Infomation/index', '@/views/Infomation/index', '', '{\"hidden\":0,\"icon\":\"file-shield-2-line\",\"title\":\"模板列表\"}', '0', '1', null, '2023-07-01 10:40:11', '2023-07-01 15:37:44');
INSERT INTO `sys_menus` VALUES ('3', '系统配置', 'settinglManagement', '0', '1', '/setting', 'Layout', '', '{\"title\":\"系统配置\",\"icon\":\"user-settings-line\",\"hidden\":false}', '0', '1', null, '2023-07-01 10:40:43', '2023-07-01 10:40:43');
INSERT INTO `sys_menus` VALUES ('4', '角色管理', 'RoleManagement', '3', '1', 'roleManagement', '@/views/setting/roleManagement/index', '', '{\"hidden\":0,\"icon\":\"admin-line\",\"title\":\"角色管理\"}', '0', '1', null, '2023-07-01 10:46:07', '2023-07-01 14:28:26');
INSERT INTO `sys_menus` VALUES ('5', '账号管理', 'userManagement', '3', '1', 'userManagement', '@/views/setting/userManagement/index', '', '{\"hidden\":false,\"icon\":\"user-3-line\",\"title\":\"账号管理\"}', '0', '1', null, '2023-07-01 10:47:45', '2023-07-01 14:28:32');
INSERT INTO `sys_menus` VALUES ('6', '菜单管理', 'MenuManagement', '3', '1', 'menuManagement', '@/views/setting/menuManagement/index', '', '{\"hidden\":false,\"icon\":\"menu-2-fill\",\"title\":\"菜单管理\"}', '0', '1', null, '2023-07-01 10:48:20', '2023-07-01 14:28:42');
INSERT INTO `sys_menus` VALUES ('7', '字典管理', 'dictionaryManagement', '3', '1', 'DictionaryManagement', '@/views/setting/dictionaryManagement/index', '', '{\"hidden\":false,\"icon\":\"book-2-line\",\"title\":\"字典管理\"}', '0', '1', null, '2023-07-01 10:49:11', '2023-07-01 14:28:50');
INSERT INTO `sys_menus` VALUES ('8', '修改密码', 'PersonalCenter', '9', '1', 'personalCenter', '@/views/setting/personalCenter/index', '', '{\"hidden\":1,\"icon\":\"map-pin-user-line\",\"title\":\"修改密码\"}', '0', '1', null, '2023-07-01 10:49:57', '2023-07-01 15:44:24');
INSERT INTO `sys_menus` VALUES ('9', '更改密码', 'settingCenter', '0', '1', '/setting', 'Layout', '', '{\"hidden\":1,\"icon\":\"user-settings-line\",\"title\":\"更改密码\"}', '0', '1', null, '2023-07-01 15:44:14', '2023-07-01 15:46:57');

-- ----------------------------
-- Table structure for sys_org
-- ----------------------------
DROP TABLE IF EXISTS `sys_org`;
CREATE TABLE `sys_org` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公司id',
  `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '园区代码',
  `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '园区名称',
  `ent_name` varchar(100) CHARACTER SET utf8 NOT NULL COMMENT '企业名称',
  `company_head` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '公司抬头',
  `open_bank` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '开户银行',
  `account_number` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '银行账号',
  `contact_man` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '联系人',
  `address` varchar(200) CHARACTER SET utf8 NOT NULL COMMENT '企业地址',
  `mobile_phone` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '手机号码',
  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮箱',
  `status` tinyint(4) DEFAULT '1' COMMENT '账户状态(1.正常 2.锁定 )',
  `sex` tinyint(4) DEFAULT NULL COMMENT '性别(1.男 2.女)',
  `remark` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '备注',
  `create_user` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '创建人',
  `update_user` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '更新人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `flag` int(11) DEFAULT '1' COMMENT '公司状态,"1"为启用,"0"为停用',
  `landline` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '固定电话',
  `organization_code` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '统一组织代码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='机构表';

-- ----------------------------
-- Records of sys_org
-- ----------------------------

-- ----------------------------
-- Table structure for sys_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_permission`;
CREATE TABLE `sys_permission` (
  `id` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '主键',
  `name` varchar(300) CHARACTER SET utf8 DEFAULT NULL COMMENT '菜单权限名称',
  `perms` varchar(500) CHARACTER SET utf8 DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：sys:user:add,sys:user:edit)',
  `icon` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '图标',
  `url` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '访问地址URL',
  `target` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT 'a target属性:_self _blank',
  `pid` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '父级菜单权限名称',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  `type` tinyint(4) DEFAULT NULL COMMENT '菜单权限类型(1:目录;2:菜单;3:按钮)',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态1:正常 0：禁用',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(4) DEFAULT NULL COMMENT '是否删除(1未删除；0已删除)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='系统权限(废弃)';

-- ----------------------------
-- Records of sys_permission
-- ----------------------------
INSERT INTO `sys_permission` VALUES ('1671082820195557377', '5555', 'sys:user:add,sys:user:edit', '图标', '/index/staff', null, '0', null, '1', '1', '2023-06-20 17:09:26', '2023-06-20 17:09:26', '1');
INSERT INTO `sys_permission` VALUES ('1671082847685025793', '44444', 'sys:user:add,sys:user:edit', '图标', '/index/staff', null, '0', null, '1', '1', '2023-06-20 17:09:33', '2023-06-20 17:09:33', '1');
INSERT INTO `sys_permission` VALUES ('1671082861513646082', '33333', 'sys:user:add,sys:user:edit', '图标', '/index/staff', null, '0', null, '1', '1', '2023-06-20 17:09:36', '2023-06-20 17:09:36', '1');
INSERT INTO `sys_permission` VALUES ('1671082873811345409', '222222', 'sys:user:add,sys:user:edit', '图标', '/index/staff', null, '0', null, '1', '1', '2023-06-20 17:09:39', '2023-06-20 17:09:39', '1');
INSERT INTO `sys_permission` VALUES ('1671082894690590722', '1111', 'sys:user:add,sys:user:edit', '图标', '/index/staff', null, '0', null, '1', '1', '2023-06-20 17:09:44', '2023-06-20 17:09:44', '1');
INSERT INTO `sys_permission` VALUES ('1671082986742980610', 'qqqqqq', 'sys:user:add,sys:user:edit', '图标', '/index/staff', null, '1671082820195557377', null, '1', '1', '2023-06-20 17:10:06', '2023-06-20 17:10:06', '1');
INSERT INTO `sys_permission` VALUES ('1671082998197624834', 'wwwwww', 'sys:user:add,sys:user:edit', '图标', '/index/staff', null, '1671082820195557377', null, '1', '1', '2023-06-20 17:10:09', '2023-06-20 17:10:09', '1');
INSERT INTO `sys_permission` VALUES ('1671083007940993025', 'eeeee', 'sys:user:add,sys:user:edit', '图标', '/index/staff', null, '1671082820195557377', null, '1', '1', '2023-06-20 17:10:11', '2023-06-20 17:10:11', '1');

-- ----------------------------
-- Table structure for sys_resources
-- ----------------------------
DROP TABLE IF EXISTS `sys_resources`;
CREATE TABLE `sys_resources` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件名',
  `original_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '原文件名',
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '路径',
  `disk` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'disk',
  `url` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'url',
  `size` int(11) NOT NULL DEFAULT '0' COMMENT '大小',
  `language` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'zh_CN',
  `status` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  `deleted_time` datetime DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of sys_resources
-- ----------------------------
INSERT INTO `sys_resources` VALUES ('2', '470_710700-1050.jpg', '700-1050.jpg', '/uploadPath/470_710JD5424Am-700-1050.jpg', 'public', 'http://192.168.12.124:10015/uploadPath/470_710JD5424Am-700-1050.jpg', '0', 'zh_CN', '0', null, '2023-06-30 11:40:22', '2023-06-30 11:40:22');
INSERT INTO `sys_resources` VALUES ('4', '470_710700.jpg', '700.jpg', '/uploadPath/470_71059u10QzM-700.jpg', 'public', 'http://192.168.12.124:10015/uploadPath/470_71059u10QzM-700.jpg', '0', 'zh_CN', '0', null, '2023-06-30 11:40:30', '2023-06-30 11:40:30');
INSERT INTO `sys_resources` VALUES ('8', 't5013o6f-3.jpeg', '3.jpeg', '/uploadPath/t5013o6f-3.jpeg', 'public', 'http://192.168.12.124:10015/uploadPath/t5013o6f-3.jpeg', '0', 'zh_CN', '0', null, '2023-06-30 11:44:39', '2023-06-30 11:44:39');
INSERT INTO `sys_resources` VALUES ('24', 'l711XCXo-700-1050.jpg', '700-1050.jpg', '/uploadPath/l711XCXo-700-1050.jpg', '', 'http://192.168.12.124:10015/uploadPath/l711XCXo-700-1050.jpg', '0', 'zh_CN', '0', null, '2023-06-30 14:53:47', '2023-06-30 14:53:47');
INSERT INTO `sys_resources` VALUES ('25', '470_710700-1050.jpg', '700-1050.jpg', '/uploadPath/470_710l711XCXo-700-1050.jpg', 'public', 'http://192.168.12.124:10015/uploadPath/470_710l711XCXo-700-1050.jpg', '0', 'zh_CN', '0', null, '2023-06-30 14:53:47', '2023-06-30 14:53:47');
INSERT INTO `sys_resources` VALUES ('26', 'z2t467Z9-700.jpg', '700.jpg', '/uploadPath/z2t467Z9-700.jpg', '', 'http://192.168.12.124:10015/uploadPath/z2t467Z9-700.jpg', '0', 'zh_CN', '0', null, '2023-06-30 14:53:51', '2023-06-30 14:53:51');
INSERT INTO `sys_resources` VALUES ('27', '470_710700.jpg', '700.jpg', '/uploadPath/470_710z2t467Z9-700.jpg', 'public', 'http://192.168.12.124:10015/uploadPath/470_710z2t467Z9-700.jpg', '0', 'zh_CN', '0', null, '2023-06-30 14:53:51', '2023-06-30 14:53:51');
INSERT INTO `sys_resources` VALUES ('28', '21G1c946.png', '21G1c946.png', '/uploadPath/21G1c946.png', '', 'http://192.168.12.124:10015/uploadPath/21G1c946.png', '0', 'zh_CN', '0', null, '2023-06-30 14:54:27', '2023-06-30 14:54:27');
INSERT INTO `sys_resources` VALUES ('29', 'aZ7H65iS.png', 'aZ7H65iS.png', '/uploadPath/aZ7H65iS.png', '', 'http://192.168.12.124:10015/uploadPath/aZ7H65iS.png', '0', 'zh_CN', '0', null, '2023-06-30 14:54:36', '2023-06-30 14:54:36');
INSERT INTO `sys_resources` VALUES ('30', 'm1H5H0pF.png', 'm1H5H0pF.png', '/uploadPath/m1H5H0pF.png', '', 'http://192.168.12.124:10015/uploadPath/m1H5H0pF.png', '0', 'zh_CN', '0', null, '2023-06-30 14:54:43', '2023-06-30 14:54:43');
INSERT INTO `sys_resources` VALUES ('31', 'l261w9n2.png', 'l261w9n2.png', '/uploadPath/l261w9n2.png', '', 'http://192.168.12.124:10015/uploadPath/l261w9n2.png', '0', 'zh_CN', '0', null, '2023-06-30 14:54:51', '2023-06-30 14:54:51');
INSERT INTO `sys_resources` VALUES ('32', '041F5r03.png', '041F5r03.png', '/uploadPath/041F5r03.png', '', 'http://192.168.12.124:10015/uploadPath/041F5r03.png', '0', 'zh_CN', '0', null, '2023-06-30 14:54:57', '2023-06-30 14:54:57');
INSERT INTO `sys_resources` VALUES ('33', '550VfGm7.png', '550VfGm7.png', '/uploadPath/550VfGm7.png', '', 'http://192.168.12.124:10015/uploadPath/550VfGm7.png', '0', 'zh_CN', '0', null, '2023-06-30 14:55:04', '2023-06-30 14:55:04');
INSERT INTO `sys_resources` VALUES ('34', '467qT9IT.png', '467qT9IT.png', '/uploadPath/467qT9IT.png', '', 'http://192.168.12.124:10015/uploadPath/467qT9IT.png', '0', 'zh_CN', '0', null, '2023-06-30 14:55:13', '2023-06-30 14:55:13');
INSERT INTO `sys_resources` VALUES ('35', 'b885N2oB.png', 'b885N2oB.png', '/uploadPath/b885N2oB.png', '', 'http://192.168.12.124:10015/uploadPath/b885N2oB.png', '0', 'zh_CN', '0', null, '2023-06-30 14:55:21', '2023-06-30 14:55:21');
INSERT INTO `sys_resources` VALUES ('36', '5g06pVnX.png', '5g06pVnX.png', '/uploadPath/5g06pVnX.png', '', 'http://192.168.12.124:10015/uploadPath/5g06pVnX.png', '0', 'zh_CN', '0', null, '2023-06-30 14:55:26', '2023-06-30 14:55:26');
INSERT INTO `sys_resources` VALUES ('37', '14vkF1X2.png', '14vkF1X2.png', '/uploadPath/14vkF1X2.png', '', 'http://192.168.12.124:10015/uploadPath/14vkF1X2.png', '0', 'zh_CN', '0', null, '2023-06-30 14:55:29', '2023-06-30 14:55:29');
INSERT INTO `sys_resources` VALUES ('38', '7N0D3o04.png', '7N0D3o04.png', '/uploadPath/7N0D3o04.png', '', 'http://192.168.12.124:10015/uploadPath/7N0D3o04.png', '0', 'zh_CN', '0', null, '2023-06-30 14:55:36', '2023-06-30 14:55:36');
INSERT INTO `sys_resources` VALUES ('39', 'fD080T4Z.png', 'fD080T4Z.png', '/uploadPath/fD080T4Z.png', '', 'http://192.168.12.124:10015/uploadPath/fD080T4Z.png', '0', 'zh_CN', '0', null, '2023-06-30 14:55:44', '2023-06-30 14:55:44');
INSERT INTO `sys_resources` VALUES ('40', 'S4G9g0Hn.png', 'S4G9g0Hn.png', '/uploadPath/S4G9g0Hn.png', '', 'http://192.168.12.124:10015/uploadPath/S4G9g0Hn.png', '0', 'zh_CN', '0', null, '2023-06-30 14:55:50', '2023-06-30 14:55:50');
INSERT INTO `sys_resources` VALUES ('41', 'x3707026.png', 'x3707026.png', '/uploadPath/x3707026.png', '', 'http://192.168.12.124:10015/uploadPath/x3707026.png', '0', 'zh_CN', '0', null, '2023-06-30 14:55:57', '2023-06-30 14:55:57');
INSERT INTO `sys_resources` VALUES ('42', 'zKCp6KKc.png', 'zKCp6KKc.png', '/uploadPath/zKCp6KKc.png', '', 'http://192.168.12.124:10015/uploadPath/zKCp6KKc.png', '0', 'zh_CN', '0', null, '2023-06-30 14:56:04', '2023-06-30 14:56:04');

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '主键',
  `org_id` int(11) DEFAULT NULL COMMENT '园区id',
  `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '角色名称',
  `description` varchar(300) CHARACTER SET utf8 DEFAULT NULL,
  `status` tinyint(4) DEFAULT '1' COMMENT '状态(1:正常0:弃用)',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(4) DEFAULT NULL COMMENT '是否删除(1未删除；0已删除)',
  `data_scope` int(11) DEFAULT NULL COMMENT '数据范围（1：所有 2：自定义 3： 本部门及以下部门 4：仅本部门 5:自己）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统角色';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES ('1', null, '管理员', '拥有全部权限', '1', '2023-06-25 17:49:22', '2023-06-25 17:49:24', null, null);
INSERT INTO `sys_role` VALUES ('1674715636060594177', null, '员工', '拥有查询权限55', '1', '2023-06-30 17:44:57', '2023-07-01 09:18:15', '1', null);
INSERT INTO `sys_role` VALUES ('1674948679073447938', null, '2222', '4444', '1', '2023-07-01 09:10:59', '2023-07-01 09:19:56', '1', null);
INSERT INTO `sys_role` VALUES ('1674949623525855233', null, '员工', '拥有查询权限', '1', '2023-07-01 09:14:44', '2023-07-01 09:14:44', '1', null);

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `role_id` int(11) NOT NULL DEFAULT '0' COMMENT '角色ID',
  `menu_id` int(11) NOT NULL DEFAULT '0' COMMENT '菜单ID',
  PRIMARY KEY (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='角色和菜单关联表(废弃)';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES ('1', '1');
INSERT INTO `sys_role_menu` VALUES ('2', '2');
INSERT INTO `sys_role_menu` VALUES ('2', '3');
INSERT INTO `sys_role_menu` VALUES ('2', '4');
INSERT INTO `sys_role_menu` VALUES ('2', '100');
INSERT INTO `sys_role_menu` VALUES ('2', '101');
INSERT INTO `sys_role_menu` VALUES ('2', '102');
INSERT INTO `sys_role_menu` VALUES ('2', '103');
INSERT INTO `sys_role_menu` VALUES ('2', '104');
INSERT INTO `sys_role_menu` VALUES ('2', '105');
INSERT INTO `sys_role_menu` VALUES ('2', '106');
INSERT INTO `sys_role_menu` VALUES ('2', '107');
INSERT INTO `sys_role_menu` VALUES ('2', '108');
INSERT INTO `sys_role_menu` VALUES ('2', '109');
INSERT INTO `sys_role_menu` VALUES ('2', '110');
INSERT INTO `sys_role_menu` VALUES ('2', '111');
INSERT INTO `sys_role_menu` VALUES ('2', '112');
INSERT INTO `sys_role_menu` VALUES ('2', '113');
INSERT INTO `sys_role_menu` VALUES ('2', '114');
INSERT INTO `sys_role_menu` VALUES ('2', '115');
INSERT INTO `sys_role_menu` VALUES ('2', '116');
INSERT INTO `sys_role_menu` VALUES ('2', '117');
INSERT INTO `sys_role_menu` VALUES ('2', '500');
INSERT INTO `sys_role_menu` VALUES ('2', '501');
INSERT INTO `sys_role_menu` VALUES ('2', '1000');
INSERT INTO `sys_role_menu` VALUES ('2', '1001');
INSERT INTO `sys_role_menu` VALUES ('2', '1002');
INSERT INTO `sys_role_menu` VALUES ('2', '1003');
INSERT INTO `sys_role_menu` VALUES ('2', '1004');
INSERT INTO `sys_role_menu` VALUES ('2', '1005');
INSERT INTO `sys_role_menu` VALUES ('2', '1006');
INSERT INTO `sys_role_menu` VALUES ('2', '1007');
INSERT INTO `sys_role_menu` VALUES ('2', '1008');
INSERT INTO `sys_role_menu` VALUES ('2', '1009');
INSERT INTO `sys_role_menu` VALUES ('2', '1010');
INSERT INTO `sys_role_menu` VALUES ('2', '1011');
INSERT INTO `sys_role_menu` VALUES ('2', '1012');
INSERT INTO `sys_role_menu` VALUES ('2', '1013');
INSERT INTO `sys_role_menu` VALUES ('2', '1014');
INSERT INTO `sys_role_menu` VALUES ('2', '1015');
INSERT INTO `sys_role_menu` VALUES ('2', '1016');
INSERT INTO `sys_role_menu` VALUES ('2', '1017');
INSERT INTO `sys_role_menu` VALUES ('2', '1018');
INSERT INTO `sys_role_menu` VALUES ('2', '1019');
INSERT INTO `sys_role_menu` VALUES ('2', '1020');
INSERT INTO `sys_role_menu` VALUES ('2', '1021');
INSERT INTO `sys_role_menu` VALUES ('2', '1022');
INSERT INTO `sys_role_menu` VALUES ('2', '1023');
INSERT INTO `sys_role_menu` VALUES ('2', '1024');
INSERT INTO `sys_role_menu` VALUES ('2', '1025');
INSERT INTO `sys_role_menu` VALUES ('2', '1026');
INSERT INTO `sys_role_menu` VALUES ('2', '1027');
INSERT INTO `sys_role_menu` VALUES ('2', '1028');
INSERT INTO `sys_role_menu` VALUES ('2', '1029');
INSERT INTO `sys_role_menu` VALUES ('2', '1030');
INSERT INTO `sys_role_menu` VALUES ('2', '1031');
INSERT INTO `sys_role_menu` VALUES ('2', '1032');
INSERT INTO `sys_role_menu` VALUES ('2', '1033');
INSERT INTO `sys_role_menu` VALUES ('2', '1034');
INSERT INTO `sys_role_menu` VALUES ('2', '1035');
INSERT INTO `sys_role_menu` VALUES ('2', '1036');
INSERT INTO `sys_role_menu` VALUES ('2', '1037');
INSERT INTO `sys_role_menu` VALUES ('2', '1038');
INSERT INTO `sys_role_menu` VALUES ('2', '1039');
INSERT INTO `sys_role_menu` VALUES ('2', '1040');
INSERT INTO `sys_role_menu` VALUES ('2', '1041');
INSERT INTO `sys_role_menu` VALUES ('2', '1042');
INSERT INTO `sys_role_menu` VALUES ('2', '1043');
INSERT INTO `sys_role_menu` VALUES ('2', '1044');
INSERT INTO `sys_role_menu` VALUES ('2', '1045');
INSERT INTO `sys_role_menu` VALUES ('2', '1046');
INSERT INTO `sys_role_menu` VALUES ('2', '1047');
INSERT INTO `sys_role_menu` VALUES ('2', '1048');
INSERT INTO `sys_role_menu` VALUES ('2', '1049');
INSERT INTO `sys_role_menu` VALUES ('2', '1050');
INSERT INTO `sys_role_menu` VALUES ('2', '1051');
INSERT INTO `sys_role_menu` VALUES ('2', '1052');
INSERT INTO `sys_role_menu` VALUES ('2', '1053');
INSERT INTO `sys_role_menu` VALUES ('2', '1054');
INSERT INTO `sys_role_menu` VALUES ('2', '1055');
INSERT INTO `sys_role_menu` VALUES ('2', '1056');
INSERT INTO `sys_role_menu` VALUES ('2', '1057');
INSERT INTO `sys_role_menu` VALUES ('2', '1058');
INSERT INTO `sys_role_menu` VALUES ('2', '1059');
INSERT INTO `sys_role_menu` VALUES ('2', '1060');

-- ----------------------------
-- Table structure for sys_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_permission`;
CREATE TABLE `sys_role_permission` (
  `id` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '主键',
  `role_id` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '角色id',
  `permission_id` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '菜单权限id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of sys_role_permission
-- ----------------------------
INSERT INTO `sys_role_permission` VALUES ('1674979807629086723', '1670668779026026497', '7', '2023-07-01 11:14:40');
INSERT INTO `sys_role_permission` VALUES ('1675047941815906305', '1', '1', '2023-07-01 15:45:25');
INSERT INTO `sys_role_permission` VALUES ('1675047941815906306', '1', '2', '2023-07-01 15:45:25');
INSERT INTO `sys_role_permission` VALUES ('1675047941815906307', '1', '3', '2023-07-01 15:45:25');
INSERT INTO `sys_role_permission` VALUES ('1675047941815906308', '1', '4', '2023-07-01 15:45:25');
INSERT INTO `sys_role_permission` VALUES ('1675047941815906309', '1', '5', '2023-07-01 15:45:25');
INSERT INTO `sys_role_permission` VALUES ('1675047941815906310', '1', '6', '2023-07-01 15:45:25');
INSERT INTO `sys_role_permission` VALUES ('1675047941815906311', '1', '7', '2023-07-01 15:45:25');
INSERT INTO `sys_role_permission` VALUES ('1675047941815906312', '1', '9', '2023-07-01 15:45:25');
INSERT INTO `sys_role_permission` VALUES ('1675047941815906313', '1', '8', '2023-07-01 15:45:25');
INSERT INTO `sys_role_permission` VALUES ('1675048134611283969', '1674949623525855233', '1', '2023-07-01 15:46:11');
INSERT INTO `sys_role_permission` VALUES ('1675048134611283970', '1674949623525855233', '2', '2023-07-01 15:46:11');
INSERT INTO `sys_role_permission` VALUES ('1675048134611283971', '1674949623525855233', '9', '2023-07-01 15:46:11');
INSERT INTO `sys_role_permission` VALUES ('1675048134611283972', '1674949623525855233', '8', '2023-07-01 15:46:11');

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '用户id',
  `username` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT '账户名称',
  `nick_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '昵称',
  `real_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '真实名称',
  `salt` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '加密盐值',
  `password` varchar(200) CHARACTER SET utf8 NOT NULL COMMENT '用户密码密文',
  `phone` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '手机号码',
  `sex` int(11) DEFAULT '0' COMMENT '性别(1男,2女)',
  `dept_id` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '部门id',
  `org_id` int(11) DEFAULT NULL COMMENT '公司id',
  `email` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '邮箱(唯一)',
  `status` int(11) DEFAULT '1' COMMENT '账户状态(1.正常 2.锁定 3.草稿)',
  `create_id` int(11) DEFAULT NULL COMMENT '创建人',
  `update_id` int(11) DEFAULT NULL COMMENT '更新人',
  `create_where` int(11) DEFAULT NULL COMMENT '创建来源(1.web 2.android 3.ios )',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES ('1670683773461499905', 'admin', '梁寒', null, '74cc45a279d242728459', '295d15e3932a40317143a586d853d6f5', '13203706613', '1', null, null, null, '1', null, null, null, null, '2023-07-01 16:22:19');
INSERT INTO `sys_user` VALUES ('1674985494845210625', 'test', '测试人员账号', null, '3d98282dee694456a00e', '4c9c1765dc56a8c8eeec484212952fb5', '13203706613', '1', null, null, '', '1', null, null, '1', '2023-07-01 11:37:16', '2023-07-01 15:19:18');
INSERT INTO `sys_user` VALUES ('1674988718574669825', 'test3000', 'andy', null, '74cc45a279d242728459', '295d15e3932a40317143a586d853d6f5', '15137865769', '1', null, null, '2423570810@qq.com', '1', null, null, '1', '2023-07-01 11:50:05', '2023-07-01 14:57:07');
INSERT INTO `sys_user` VALUES ('1675028708633579522', 'tetete', '姚x11x', null, '653db030cfae41dba503', '2cc3275c338b9f661f61745b3d993f15', '15137865769', '1', null, null, '24235730810@qq.com', '1', null, null, '1', '2023-07-01 14:28:59', '2023-07-01 14:28:59');

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '用户id',
  `user_id` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
  `role_id` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '角色id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统用户角色';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES ('1674965749098065921', '1674957945016557569', '1', '2023-07-01 10:18:49');
INSERT INTO `sys_user_role` VALUES ('1674965749098065922', '1674957945016557569', '2', '2023-07-01 10:18:49');
INSERT INTO `sys_user_role` VALUES ('1674965749098065923', '1674957945016557569', '3', '2023-07-01 10:18:49');
INSERT INTO `sys_user_role` VALUES ('1674971489372192769', '1674971489351221250', '1', '2023-07-01 10:41:37');
INSERT INTO `sys_user_role` VALUES ('1674971489372192770', '1674971489351221250', '2', '2023-07-01 10:41:37');
INSERT INTO `sys_user_role` VALUES ('1675028708658745345', '1675028708633579522', '1', '2023-07-01 14:28:59');
INSERT INTO `sys_user_role` VALUES ('1675028708658745346', '1675028708633579522', '2', '2023-07-01 14:28:59');
INSERT INTO `sys_user_role` VALUES ('1675028708658745347', '1675028708633579522', '3', '2023-07-01 14:28:59');
INSERT INTO `sys_user_role` VALUES ('1675035797846175745', '1674988718574669825', '1', '2023-07-01 14:57:10');
INSERT INTO `sys_user_role` VALUES ('1675035797846175746', '1674988718574669825', '2', '2023-07-01 14:57:10');
INSERT INTO `sys_user_role` VALUES ('1675035797846175747', '1674988718574669825', '3', '2023-07-01 14:57:10');
INSERT INTO `sys_user_role` VALUES ('1675039727414022145', '1670683773461499905', '1', '2023-07-01 15:12:46');
INSERT INTO `sys_user_role` VALUES ('1675041370608148482', '1674985494845210625', '1674949623525855233', '2023-07-01 15:19:18');

-- ----------------------------
-- Table structure for tb_template
-- ----------------------------
DROP TABLE IF EXISTS `tb_template`;
CREATE TABLE `tb_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',
  `background_url` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '模版图地址',
  `template_url` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '模版成品图地址',
  `status` int(11) DEFAULT '1' COMMENT '状态:1为正常  0为禁用',
  `deleted_at` datetime DEFAULT NULL COMMENT '删除时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='模版表';

-- ----------------------------
-- Records of tb_template
-- ----------------------------
INSERT INTO `tb_template` VALUES ('1', '百家论坛', '/uploadPath/470_710JD5424Am-700-1050.jpg', '/uploadPath/470_71059u10QzM-700.jpg', '1', null, '2023-06-30 11:40:47', '2023-06-30 11:40:47');
INSERT INTO `tb_template` VALUES ('2', '123', '/uploadPath/470_710l711XCXo-700-1050.jpg', '/uploadPath/470_710z2t467Z9-700.jpg', '1', null, '2023-06-30 14:53:53', '2023-06-30 14:53:53');

-- ----------------------------
-- Table structure for tb_template_element
-- ----------------------------
DROP TABLE IF EXISTS `tb_template_element`;
CREATE TABLE `tb_template_element` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `template_id` int(11) DEFAULT NULL COMMENT '模版id',
  `title` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标题',
  `type` int(11) DEFAULT NULL COMMENT '类型:1为图片  2为文字',
  `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT '内容',
  `area` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '位置区域',
  `t_style` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '样式',
  `t_sore` int(11) DEFAULT '0' COMMENT '排序字段',
  `status` int(11) DEFAULT '1' COMMENT '状态:1为正常  0为禁用',
  `deleted_at` datetime DEFAULT NULL COMMENT '删除时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='模版元素表';

-- ----------------------------
-- Records of tb_template_element
-- ----------------------------
INSERT INTO `tb_template_element` VALUES ('1', '1', '百家论坛', '2', '百家论坛', '{\"w\":164,\"x\":181,\"h\":43,\"y\":104}', '{\"color\":\"rgb(38, 117, 191)\",\"size\":\"28\",\"font\":\"楷体\",\"bold\":\"true\",\"lineHeight\":\"28\",\"r\":\"38\",\"g\":\"117\",\"b\":\"191\"}', '0', '1', null, '2023-06-30 11:41:20', '2023-06-30 14:01:38');
INSERT INTO `tb_template_element` VALUES ('2', '1', '雷公', '2', '雷公藤多符抗AML物质基础\n发现及药物研发', '{\"w\":272,\"x\":178,\"h\":57,\"y\":154}', '{\"color\":\"rgb(0, 0, 0)\",\"size\":\"20\",\"font\":\"楷体\",\"bold\":\"true\",\"lineHeight\":\"28\",\"r\":\"0\",\"g\":\"0\",\"b\":\"0\"}', '0', '1', null, '2023-06-30 11:42:29', '2023-06-30 17:50:41');
INSERT INTO `tb_template_element` VALUES ('3', '1', '时间', '2', '时间: 2023年4月22日15:30 - 18:00', '{\"w\":279,\"x\":174,\"h\":26,\"y\":225}', '{\"color\":\"rgb(35, 83, 186)\",\"size\":\"16\",\"font\":\"楷体\",\"bold\":\"false\",\"lineHeight\":\"15\",\"r\":\"35\",\"g\":\"83\",\"b\":\"186\"}', '0', '1', null, '2023-06-30 11:43:27', '2023-06-30 11:43:54');
INSERT INTO `tb_template_element` VALUES ('4', '1', '头像', '1', '/uploadPath/t5013o6f-3.jpeg', '{\"x\":24,\"y\":100,\"w\":134,\"h\":178}', '', '0', '1', null, '2023-06-30 11:44:42', '2023-06-30 11:44:42');
INSERT INTO `tb_template_element` VALUES ('5', '1', '地址', '2', '地点: 俊学楼一楼B101会议室', '{\"x\":178,\"y\":259,\"w\":264,\"h\":28}', '{\"color\":\"rgb(0, 0, 0)\",\"size\":\"16\",\"lineHeight\":\"18\",\"font\":\"宋体\",\"bold\":\"true\",\"r\":\"0\",\"g\":\"0\",\"b\":\"0\"}', '0', '1', null, '2023-06-30 11:45:29', '2023-06-30 11:45:29');
INSERT INTO `tb_template_element` VALUES ('6', '1', '主讲人', '2', '主讲人 | 胡立宏', '{\"w\":137,\"x\":22,\"h\":21,\"y\":295}', '{\"color\":\"rgb(0, 0, 0)\",\"size\":\"16\",\"font\":\"Xingkai SC\",\"bold\":\"true\",\"lineHeight\":\"16\",\"r\":\"0\",\"g\":\"0\",\"b\":\"0\"}', '0', '1', null, '2023-06-30 11:46:25', '2023-06-30 11:46:44');
INSERT INTO `tb_template_element` VALUES ('9', '1', '内容', '2', '胡立宏，现任南京中医药大学副校长、中药功效物质重点实\n验室主任，研究员、国家杰青。\n\n\n长期从事基于中药量丰成分和老药的药物发现研究，发现了一批药\n物候选物，实现了多项发明专利技术成果转化，其中基于老药舒尼替尼\n结构设计、开发的新型 FLT3 抑制剂 XYO206，临床试验结果\n显示其对 FLT3 野生型和突变型具有 68% 的完全缓解率，有望成为\n该类 bestinclass 药物。\n\n\n曾获国家科技进步二等奖、上海市科技进步一等奖、江苏省研究生教\n育改革成果奖二等奖，连续多年入选 EIservier 高被引学者榜单。', '{\"w\":423,\"x\":21,\"h\":273,\"y\":343}', '{\"color\":\"rgb(0, 0, 0)\",\"size\":\"14\",\"font\":\"宋体\",\"bold\":\"false\",\"lineHeight\":\"16\",\"r\":\"0\",\"g\":\"0\",\"b\":\"0\"}', '0', '1', null, '2023-06-30 11:53:06', '2023-06-30 17:55:57');
INSERT INTO `tb_template_element` VALUES ('10', '2', '百家论坛', '2', '百家论坛', '{\"w\":162,\"x\":185,\"h\":43,\"y\":109}', '{\"color\":\"rgb(0, 0, 0)\",\"size\":\"25\",\"font\":\"楷体\",\"bold\":\"true\",\"lineHeight\":\"26\",\"r\":\"0\",\"g\":\"0\",\"b\":\"0\"}', '0', '1', null, '2023-06-30 14:54:22', '2023-06-30 14:56:01');
INSERT INTO `tb_template_element` VALUES ('8', '1', '尾部', '2', '主办单位:科学技术处承办单位: 党委研工部、研究生院', '{\"w\":375,\"x\":18,\"h\":24,\"y\":665}', '{\"color\":\"rgb(0, 0, 0)\",\"size\":\"14\",\"font\":\"黑体\",\"bold\":\"true\",\"lineHeight\":\"14\",\"r\":\"0\",\"g\":\"0\",\"b\":\"0\"}', '0', '1', null, '2023-06-30 11:48:52', '2023-06-30 11:49:26');