/* 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');