/* Navicat MySQL Data Transfer Source Server : major-adjust Source Server Version : 80022 Source Host : 106.52.229.24:3308 Source Database : ry_vue Target Server Type : MYSQL Target Server Version : 80022 File Encoding : 65001 Date: 2022-03-20 17:52:00 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for gen_table -- ---------------------------- DROP TABLE IF EXISTS `gen_table`; CREATE TABLE `gen_table` ( `table_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `table_name` varchar(200) DEFAULT '' COMMENT '表名称', `table_comment` varchar(500) DEFAULT '' COMMENT '表描述', `sub_table_name` varchar(64) DEFAULT NULL COMMENT '关联子表的表名', `sub_table_fk_name` varchar(64) DEFAULT NULL COMMENT '子表关联的外键名', `class_name` varchar(100) DEFAULT '' COMMENT '实体类名称', `tpl_category` varchar(200) DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作）', `package_name` varchar(100) DEFAULT NULL COMMENT '生成包路径', `module_name` varchar(30) DEFAULT NULL COMMENT '生成模块名', `business_name` varchar(30) DEFAULT NULL COMMENT '生成业务名', `function_name` varchar(50) DEFAULT NULL COMMENT '生成功能名', `function_author` varchar(50) DEFAULT NULL COMMENT '生成功能作者', `gen_type` char(1) DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）', `gen_path` varchar(200) DEFAULT '/' COMMENT '生成路径（不填默认项目路径）', `options` varchar(1000) DEFAULT NULL COMMENT '其它生成选项', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`table_id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='代码生成业务表'; -- ---------------------------- -- Records of gen_table -- ---------------------------- INSERT INTO `gen_table` VALUES ('1', 'QRTZ_PAUSED_TRIGGER_GRPS', '暂停的触发器表', null, null, 'QrtzPausedTriggerGrps', 'crud', 'com.ruoyi.system', 'system', 'GRPS', '暂停的触发器', 'ruoyi', '0', '/', null, 'admin', '2022-01-27 07:50:11', '', null, null); INSERT INTO `gen_table` VALUES ('5', 'm_adjust_result', '分流结果表', null, null, 'AdjustResult', 'crud', 'com.admin.major', 'major', 'result', '分流结果', 'zewei', '0', '/', null, 'admin', '2022-03-20 08:47:38', '', null, null); INSERT INTO `gen_table` VALUES ('6', 'm_major_apply', '专业分流申请表', null, null, 'MajorApply', 'crud', 'com.admin.major', 'major', 'apply', '专业分流申请', 'zewei', '0', '/', null, 'admin', '2022-03-20 08:47:38', '', null, null); INSERT INTO `gen_table` VALUES ('7', 'm_major_info', '专业信息表', null, null, 'MajorInfo', 'crud', 'com.admin.major', 'major', 'info', '专业信息', 'zewei', '0', '/', null, 'admin', '2022-03-20 08:47:39', '', null, null); INSERT INTO `gen_table` VALUES ('8', 'm_schedule_arrange', '日程安排', null, null, 'ScheduleArrange', 'crud', 'com.admin.major', 'major', 'arrange', '日程安排', 'zewei', '0', '/', '{}', 'admin', '2022-03-20 08:47:39', '', '2022-03-20 09:28:57', null); INSERT INTO `gen_table` VALUES ('9', 'm_special_apply', '特别申请', null, null, 'SpecialApply', 'crud', 'com.admin.major', 'major', 'apply', '特别申请', 'zewei', '0', '/', null, 'admin', '2022-03-20 08:47:39', '', null, null); INSERT INTO `gen_table` VALUES ('10', 'm_student_info', '学生信息表', null, null, 'StudentInfo', 'crud', 'com.admin.major', 'major', 'info', '学生信息', 'zewei', '0', '/', null, 'admin', '2022-03-20 08:47:40', '', null, null); -- ---------------------------- -- Table structure for gen_table_column -- ---------------------------- DROP TABLE IF EXISTS `gen_table_column`; CREATE TABLE `gen_table_column` ( `column_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `table_id` varchar(64) DEFAULT NULL COMMENT '归属表编号', `column_name` varchar(200) DEFAULT NULL COMMENT '列名称', `column_comment` varchar(500) DEFAULT NULL COMMENT '列描述', `column_type` varchar(100) DEFAULT NULL COMMENT '列类型', `java_type` varchar(500) DEFAULT NULL COMMENT 'JAVA类型', `java_field` varchar(200) DEFAULT NULL COMMENT 'JAVA字段名', `is_pk` char(1) DEFAULT NULL COMMENT '是否主键（1是）', `is_increment` char(1) DEFAULT NULL COMMENT '是否自增（1是）', `is_required` char(1) DEFAULT NULL COMMENT '是否必填（1是）', `is_insert` char(1) DEFAULT NULL COMMENT '是否为插入字段（1是）', `is_edit` char(1) DEFAULT NULL COMMENT '是否编辑字段（1是）', `is_list` char(1) DEFAULT NULL COMMENT '是否列表字段（1是）', `is_query` char(1) DEFAULT NULL COMMENT '是否查询字段（1是）', `query_type` varchar(200) DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）', `html_type` varchar(200) DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）', `dict_type` varchar(200) DEFAULT '' COMMENT '字典类型', `sort` int DEFAULT NULL COMMENT '排序', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`column_id`) ) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='代码生成业务表字段'; -- ---------------------------- -- Records of gen_table_column -- ---------------------------- INSERT INTO `gen_table_column` VALUES ('1', '1', 'sched_name', '调度名称', 'varchar(120)', 'String', 'schedName', '1', '0', null, '1', null, null, null, 'LIKE', 'input', '', '1', 'admin', '2022-01-27 07:50:11', '', null); INSERT INTO `gen_table_column` VALUES ('2', '1', 'trigger_group', 'qrtz_triggers表trigger_group的外键', 'varchar(200)', 'String', 'triggerGroup', '1', '0', null, '1', null, null, null, 'EQ', 'input', '', '2', 'admin', '2022-01-27 07:50:11', '', null); INSERT INTO `gen_table_column` VALUES ('43', '5', 'batch_id', '分流批次', 'char(8)', 'String', 'batchId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '1', 'admin', '2022-03-20 08:47:38', '', null); INSERT INTO `gen_table_column` VALUES ('44', '5', 'student_id', '学生id', 'varchar(32)', 'String', 'studentId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '2', 'admin', '2022-03-20 08:47:38', '', null); INSERT INTO `gen_table_column` VALUES ('45', '5', 'admit_major_id', '录取专业', 'varchar(32)', 'String', 'admitMajorId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '3', 'admin', '2022-03-20 08:47:38', '', null); INSERT INTO `gen_table_column` VALUES ('46', '5', 'special_flag', '是否特殊审批', 'tinyint', 'Long', 'specialFlag', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '4', 'admin', '2022-03-20 08:47:38', '', null); INSERT INTO `gen_table_column` VALUES ('47', '5', 'adjust_flag', '是否调剂分配', 'tinyint', 'Long', 'adjustFlag', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '5', 'admin', '2022-03-20 08:47:38', '', null); INSERT INTO `gen_table_column` VALUES ('48', '5', 'college_id', '学院id', 'bigint', 'Long', 'collegeId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '6', 'admin', '2022-03-20 08:47:38', '', null); INSERT INTO `gen_table_column` VALUES ('49', '6', 'major_apply_id', null, 'varchar(32)', 'String', 'majorApplyId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '1', 'admin', '2022-03-20 08:47:38', '', null); INSERT INTO `gen_table_column` VALUES ('50', '6', 'student_id', '学生id', 'varchar(32)', 'String', 'studentId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '2', 'admin', '2022-03-20 08:47:38', '', null); INSERT INTO `gen_table_column` VALUES ('51', '6', 'major_id_1st', '第一志愿', 'varchar(32)', 'String', 'majorId1st', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '3', 'admin', '2022-03-20 08:47:38', '', null); INSERT INTO `gen_table_column` VALUES ('52', '6', 'major_id_2nd', '第二志愿', 'varchar(32)', 'String', 'majorId2nd', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '4', 'admin', '2022-03-20 08:47:38', '', null); INSERT INTO `gen_table_column` VALUES ('53', '6', 'major_id_3rd', '第三志愿', 'varchar(32)', 'String', 'majorId3rd', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '5', 'admin', '2022-03-20 08:47:38', '', null); INSERT INTO `gen_table_column` VALUES ('54', '6', 'major_id_4th', '第四志愿', 'varchar(32)', 'String', 'majorId4th', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '6', 'admin', '2022-03-20 08:47:38', '', null); INSERT INTO `gen_table_column` VALUES ('55', '6', 'major_id_5th', '第五志愿', 'varchar(32)', 'String', 'majorId5th', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '7', 'admin', '2022-03-20 08:47:39', '', null); INSERT INTO `gen_table_column` VALUES ('56', '6', 'sign', '学生签名', 'text', 'String', 'sign', '0', '0', null, '1', '1', '1', '1', 'EQ', 'textarea', '', '8', 'admin', '2022-03-20 08:47:39', '', null); INSERT INTO `gen_table_column` VALUES ('57', '6', 'apply_status', '申请状态（0未提交 1已提交 2通过 3驳回）', 'char(1)', 'String', 'applyStatus', '0', '0', null, '1', '1', '1', '1', 'EQ', 'radio', '', '9', 'admin', '2022-03-20 08:47:39', '', null); INSERT INTO `gen_table_column` VALUES ('58', '6', 'status', '状态（1启用 0弃用）', 'char(1)', 'String', 'status', '0', '0', null, '1', '1', '1', '1', 'EQ', 'radio', '', '10', 'admin', '2022-03-20 08:47:39', '', null); INSERT INTO `gen_table_column` VALUES ('59', '6', 'apply_date', '申请时间', 'datetime', 'Date', 'applyDate', '0', '0', null, '1', '1', '1', '1', 'EQ', 'datetime', '', '11', 'admin', '2022-03-20 08:47:39', '', null); INSERT INTO `gen_table_column` VALUES ('60', '6', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', null, '1', null, null, null, 'EQ', 'datetime', '', '12', 'admin', '2022-03-20 08:47:39', '', null); INSERT INTO `gen_table_column` VALUES ('61', '6', 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', null, '1', '1', null, null, 'EQ', 'datetime', '', '13', 'admin', '2022-03-20 08:47:39', '', null); INSERT INTO `gen_table_column` VALUES ('62', '7', 'major_id', '专业id', 'varchar(32)', 'String', 'majorId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '1', 'admin', '2022-03-20 08:47:39', '', null); INSERT INTO `gen_table_column` VALUES ('63', '7', 'major_name', '专业名称', 'varchar(32)', 'String', 'majorName', '0', '0', null, '1', '1', '1', '1', 'LIKE', 'input', '', '2', 'admin', '2022-03-20 08:47:39', '', null); INSERT INTO `gen_table_column` VALUES ('64', '7', 'plan_num', '计划数', 'int', 'Long', 'planNum', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '3', 'admin', '2022-03-20 08:47:39', '', null); INSERT INTO `gen_table_column` VALUES ('65', '7', 'status', '状态', 'char(1)', 'String', 'status', '0', '0', null, '1', '1', '1', '1', 'EQ', 'radio', '', '4', 'admin', '2022-03-20 08:47:39', '', null); INSERT INTO `gen_table_column` VALUES ('66', '7', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', null, '1', null, null, null, 'EQ', 'datetime', '', '5', 'admin', '2022-03-20 08:47:39', '', null); INSERT INTO `gen_table_column` VALUES ('67', '7', 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', null, '1', '1', null, null, 'EQ', 'datetime', '', '6', 'admin', '2022-03-20 08:47:39', '', null); INSERT INTO `gen_table_column` VALUES ('68', '7', 'update_user_id', '更新用户', 'varchar(32)', 'String', 'updateUserId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '7', 'admin', '2022-03-20 08:47:39', '', null); INSERT INTO `gen_table_column` VALUES ('69', '7', 'create_user_id', '创建用户', 'varchar(32)', 'String', 'createUserId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '8', 'admin', '2022-03-20 08:47:39', '', null); INSERT INTO `gen_table_column` VALUES ('70', '7', 'college_id', '学院id', 'bigint', 'Long', 'collegeId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '9', 'admin', '2022-03-20 08:47:39', '', null); INSERT INTO `gen_table_column` VALUES ('71', '8', 'orgin_id', '源数据id', 'varchar(32)', 'String', 'orginId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '1', 'admin', '2022-03-20 08:47:39', '', '2022-03-20 09:28:57'); INSERT INTO `gen_table_column` VALUES ('72', '8', 'schedule_id', '日程id', 'int', 'Long', 'scheduleId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '2', 'admin', '2022-03-20 08:47:39', '', '2022-03-20 09:28:57'); INSERT INTO `gen_table_column` VALUES ('73', '8', 'schedule_name', '日程名称', 'varchar(32)', 'String', 'scheduleName', '0', '0', null, '1', '1', '1', '1', 'LIKE', 'input', '', '3', 'admin', '2022-03-20 08:47:39', '', '2022-03-20 09:28:57'); INSERT INTO `gen_table_column` VALUES ('74', '8', 'year', '年份', 'varchar(4)', 'String', 'year', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '4', 'admin', '2022-03-20 08:47:39', '', '2022-03-20 09:28:57'); INSERT INTO `gen_table_column` VALUES ('75', '8', 'start_date', '开始时间', 'date', 'Date', 'startDate', '0', '0', null, '1', '1', '1', '1', 'EQ', 'datetime', '', '5', 'admin', '2022-03-20 08:47:39', '', '2022-03-20 09:28:57'); INSERT INTO `gen_table_column` VALUES ('76', '8', 'end_date', '结束时间', 'date', 'Date', 'endDate', '0', '0', null, '1', '1', '1', '1', 'EQ', 'datetime', '', '6', 'admin', '2022-03-20 08:47:39', '', '2022-03-20 09:28:57'); INSERT INTO `gen_table_column` VALUES ('77', '8', 'status', '状态', 'tinyint', 'Long', 'status', '0', '0', null, '1', '1', '1', '1', 'EQ', 'radio', '', '7', 'admin', '2022-03-20 08:47:39', '', '2022-03-20 09:28:57'); INSERT INTO `gen_table_column` VALUES ('78', '8', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', null, '1', null, null, null, 'EQ', 'datetime', '', '8', 'admin', '2022-03-20 08:47:39', '', '2022-03-20 09:28:57'); INSERT INTO `gen_table_column` VALUES ('79', '8', 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', null, '1', '1', null, null, 'EQ', 'datetime', '', '9', 'admin', '2022-03-20 08:47:39', '', '2022-03-20 09:28:57'); INSERT INTO `gen_table_column` VALUES ('80', '8', 'update_user_id', '更新用户', 'varchar(32)', 'String', 'updateUserId', '0', '0', null, '1', '1', null, null, 'EQ', 'input', '', '10', 'admin', '2022-03-20 08:47:39', '', '2022-03-20 09:28:57'); INSERT INTO `gen_table_column` VALUES ('81', '8', 'create_user_id', '创建用户', 'varchar(32)', 'String', 'createUserId', '0', '0', null, '1', null, null, null, 'EQ', 'input', '', '11', 'admin', '2022-03-20 08:47:39', '', '2022-03-20 09:28:57'); INSERT INTO `gen_table_column` VALUES ('82', '8', 'college_id', '学院id', 'bigint', 'Long', 'collegeId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '12', 'admin', '2022-03-20 08:47:39', '', '2022-03-20 09:28:57'); INSERT INTO `gen_table_column` VALUES ('83', '9', 'special_apply_id', null, 'varchar(32)', 'String', 'specialApplyId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '1', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('84', '9', 'student_id', '学生id', 'varchar(32)', 'String', 'studentId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '2', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('85', '9', 'major_id', '专业id', 'varchar(32)', 'String', 'majorId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '3', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('86', '9', 'apply_reason', '申请原因', 'text', 'String', 'applyReason', '0', '0', null, '1', '1', '1', '1', 'EQ', 'textarea', '', '4', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('87', '9', 'college_opinion', '学院意见（保留字段）', 'text', 'String', 'collegeOpinion', '0', '0', null, '1', '1', '1', '1', 'EQ', 'textarea', '', '5', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('88', '9', 'aca_affairs_opinion', '教导处意见（保留字段）', 'text', 'String', 'acaAffairsOpinion', '0', '0', null, '1', '1', '1', '1', 'EQ', 'textarea', '', '6', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('89', '9', 'leader_opinion', '领导意见（保留字段）', 'text', 'String', 'leaderOpinion', '0', '0', null, '1', '1', '1', '1', 'EQ', 'textarea', '', '7', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('90', '9', 'sign', '学生签名', 'text', 'String', 'sign', '0', '0', null, '1', '1', '1', '1', 'EQ', 'textarea', '', '8', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('91', '9', 'guardin_sign', '领导签名', 'text', 'String', 'guardinSign', '0', '0', null, '1', '1', '1', '1', 'EQ', 'textarea', '', '9', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('92', '9', 'apply_status', '申请状态（0未提交 1已提交 2通过 3驳回）', 'char(1)', 'String', 'applyStatus', '0', '0', null, '1', '1', '1', '1', 'EQ', 'radio', '', '10', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('93', '9', 'status', '状态（1启用 0弃用）', 'char(1)', 'String', 'status', '0', '0', null, '1', '1', '1', '1', 'EQ', 'radio', '', '11', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('94', '9', 'apply_date', '提交时间', 'datetime', 'Date', 'applyDate', '0', '0', null, '1', '1', '1', '1', 'EQ', 'datetime', '', '12', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('95', '9', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', null, '1', null, null, null, 'EQ', 'datetime', '', '13', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('96', '9', 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', null, '1', '1', null, null, 'EQ', 'datetime', '', '14', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('97', '9', 'update_user_id', '更新用户', 'char(10)', 'String', 'updateUserId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '15', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('98', '10', 'orgin_id', '源数据id', 'varchar(32)', 'String', 'orginId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '1', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('99', '10', 'open_id', null, 'varchar(48)', 'String', 'openId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '2', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('100', '10', 'student_id', '学号', 'varchar(32)', 'String', 'studentId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '3', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('101', '10', 'student_name', '学生名称', 'char(10)', 'String', 'studentName', '0', '0', null, '1', '1', '1', '1', 'LIKE', 'input', '', '4', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('102', '10', 'class_name', '班级名称', 'varchar(32)', 'String', 'className', '0', '0', null, '1', '1', '1', '1', 'LIKE', 'input', '', '5', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('103', '10', 'score', '绩点', 'decimal(4,4)', 'BigDecimal', 'score', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '6', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('104', '10', 'rank', '排名', 'int', 'Long', 'rank', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '7', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('105', '10', 'phonenumber', '联系号码', 'char(11)', 'String', 'phonenumber', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '8', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('106', '10', 'email', '邮箱', 'varchar(50)', 'String', 'email', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '9', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('107', '10', 'gender', '性别', 'char(1)', 'String', 'gender', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '10', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('108', '10', 'guardian_phone', '监护人号码', 'char(11)', 'String', 'guardianPhone', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '11', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('109', '10', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', null, '1', null, null, null, 'EQ', 'datetime', '', '12', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('110', '10', 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', null, '1', '1', null, null, 'EQ', 'datetime', '', '13', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('111', '10', 'create_user_id', '创建用户', 'varchar(32)', 'String', 'createUserId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '14', 'admin', '2022-03-20 08:47:40', '', null); INSERT INTO `gen_table_column` VALUES ('112', '10', 'update_user_id', '更新用户id', 'varchar(32)', 'String', 'updateUserId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '15', 'admin', '2022-03-20 08:47:41', '', null); INSERT INTO `gen_table_column` VALUES ('113', '10', 'college_id', '学院id', 'bigint', 'Long', 'collegeId', '0', '0', null, '1', '1', '1', '1', 'EQ', 'input', '', '16', 'admin', '2022-03-20 08:47:41', '', null); -- ---------------------------- -- Table structure for m_adjust_result -- ---------------------------- DROP TABLE IF EXISTS `m_adjust_result`; CREATE TABLE `m_adjust_result` ( `batch_id` char(8) DEFAULT NULL COMMENT '分流批次', `student_id` varchar(32) DEFAULT NULL COMMENT '学生id', `admit_major_id` varchar(32) DEFAULT NULL COMMENT '录取专业', `special_flag` tinyint DEFAULT NULL COMMENT '是否特殊审批', `adjust_flag` tinyint DEFAULT NULL COMMENT '是否调剂分配', `college_id` bigint DEFAULT NULL COMMENT '学院id' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='分流结果表'; -- ---------------------------- -- Records of m_adjust_result -- ---------------------------- -- ---------------------------- -- Table structure for m_major_apply -- ---------------------------- DROP TABLE IF EXISTS `m_major_apply`; CREATE TABLE `m_major_apply` ( `major_apply_id` varchar(32) DEFAULT NULL, `student_id` varchar(32) DEFAULT NULL COMMENT '学生id', `major_id_1st` varchar(32) DEFAULT NULL COMMENT '第一志愿', `major_id_2nd` varchar(32) DEFAULT NULL COMMENT '第二志愿', `major_id_3rd` varchar(32) DEFAULT NULL COMMENT '第三志愿', `major_id_4th` varchar(32) DEFAULT NULL COMMENT '第四志愿', `major_id_5th` varchar(32) DEFAULT NULL COMMENT '第五志愿', `sign` text COMMENT '学生签名', `apply_status` char(1) DEFAULT NULL COMMENT '申请状态（0未提交 1已提交 2通过 3驳回）', `status` char(1) DEFAULT NULL COMMENT '状态（1启用 0弃用）', `apply_date` datetime DEFAULT NULL COMMENT '申请时间', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '更新时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='专业分流申请表'; -- ---------------------------- -- Records of m_major_apply -- ---------------------------- -- ---------------------------- -- Table structure for m_major_info -- ---------------------------- DROP TABLE IF EXISTS `m_major_info`; CREATE TABLE `m_major_info` ( `major_id` varchar(32) DEFAULT NULL COMMENT '专业id', `major_name` varchar(32) DEFAULT NULL COMMENT '专业名称', `plan_num` int DEFAULT NULL COMMENT '计划数', `status` char(1) DEFAULT NULL COMMENT '状态', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `update_user_id` varchar(32) DEFAULT NULL COMMENT '更新用户', `create_user_id` varchar(32) DEFAULT NULL COMMENT '创建用户', `college_id` bigint DEFAULT NULL COMMENT '学院id' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='专业信息表'; -- ---------------------------- -- Records of m_major_info -- ---------------------------- -- ---------------------------- -- Table structure for m_schedule_arrange -- ---------------------------- DROP TABLE IF EXISTS `m_schedule_arrange`; CREATE TABLE `m_schedule_arrange` ( `orgin_id` varchar(32) DEFAULT NULL COMMENT '源数据id', `schedule_id` int DEFAULT NULL COMMENT '日程id', `schedule_name` varchar(32) DEFAULT NULL COMMENT '日程名称', `year` varchar(4) DEFAULT NULL COMMENT '年份', `start_date` date DEFAULT NULL COMMENT '开始时间', `end_date` date DEFAULT NULL COMMENT '结束时间', `status` tinyint DEFAULT NULL COMMENT '状态', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `update_user_id` varchar(32) DEFAULT NULL COMMENT '更新用户', `create_user_id` varchar(32) DEFAULT NULL COMMENT '创建用户', `college_id` bigint DEFAULT NULL COMMENT '学院id' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='日程安排'; -- ---------------------------- -- Records of m_schedule_arrange -- ---------------------------- INSERT INTO `m_schedule_arrange` VALUES (null, '1', '001', '2020', '2022-03-07', '2022-03-24', '0', '2022-03-20 17:20:28', null, '001', '001', '1'); -- ---------------------------- -- Table structure for m_special_apply -- ---------------------------- DROP TABLE IF EXISTS `m_special_apply`; CREATE TABLE `m_special_apply` ( `special_apply_id` varchar(32) DEFAULT NULL, `student_id` varchar(32) DEFAULT NULL COMMENT '学生id', `major_id` varchar(32) DEFAULT NULL COMMENT '专业id', `apply_reason` text COMMENT '申请原因', `college_opinion` text COMMENT '学院意见（保留字段）', `aca_affairs_opinion` text COMMENT '教导处意见（保留字段）', `leader_opinion` text COMMENT '领导意见（保留字段）', `sign` text COMMENT '学生签名', `guardin_sign` text COMMENT '领导签名', `apply_status` char(1) DEFAULT NULL COMMENT '申请状态（0未提交 1已提交 2通过 3驳回）', `status` char(1) DEFAULT NULL COMMENT '状态（1启用 0弃用）', `apply_date` datetime DEFAULT NULL COMMENT '提交时间', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `update_user_id` char(10) DEFAULT NULL COMMENT '更新用户' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='特别申请'; -- ---------------------------- -- Records of m_special_apply -- ---------------------------- -- ---------------------------- -- Table structure for m_student_info -- ---------------------------- DROP TABLE IF EXISTS `m_student_info`; CREATE TABLE `m_student_info` ( `orgin_id` varchar(32) DEFAULT NULL COMMENT '源数据id', `open_id` varchar(48) DEFAULT NULL, `student_id` varchar(32) DEFAULT NULL COMMENT '学号', `student_name` char(10) DEFAULT NULL COMMENT '学生名称', `class_name` varchar(32) DEFAULT NULL COMMENT '班级名称', `score` decimal(4,4) DEFAULT NULL COMMENT '绩点', `rank` int DEFAULT NULL COMMENT '排名', `phonenumber` char(11) DEFAULT NULL COMMENT '联系号码', `email` varchar(50) DEFAULT NULL COMMENT '邮箱', `gender` char(1) DEFAULT NULL COMMENT '性别', `guardian_phone` char(11) DEFAULT NULL COMMENT '监护人号码', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `create_user_id` varchar(32) DEFAULT NULL COMMENT '创建用户', `update_user_id` varchar(32) DEFAULT NULL COMMENT '更新用户id', `college_id` bigint DEFAULT NULL COMMENT '学院id' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='学生信息表'; -- ---------------------------- -- Records of m_student_info -- ---------------------------- -- ---------------------------- -- Table structure for QRTZ_BLOB_TRIGGERS -- ---------------------------- DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`; CREATE TABLE `QRTZ_BLOB_TRIGGERS` ( `sched_name` varchar(120) NOT NULL COMMENT '调度名称', `trigger_name` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键', `trigger_group` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键', `blob_data` blob COMMENT '存放持久化Trigger对象', PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`), CONSTRAINT `QRTZ_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `QRTZ_TRIGGERS` (`sched_name`, `trigger_name`, `trigger_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Blob类型的触发器表'; -- ---------------------------- -- Records of QRTZ_BLOB_TRIGGERS -- ---------------------------- -- ---------------------------- -- Table structure for QRTZ_CALENDARS -- ---------------------------- DROP TABLE IF EXISTS `QRTZ_CALENDARS`; CREATE TABLE `QRTZ_CALENDARS` ( `sched_name` varchar(120) NOT NULL COMMENT '调度名称', `calendar_name` varchar(200) NOT NULL COMMENT '日历名称', `calendar` blob NOT NULL COMMENT '存放持久化calendar对象', PRIMARY KEY (`sched_name`,`calendar_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='日历信息表'; -- ---------------------------- -- Records of QRTZ_CALENDARS -- ---------------------------- -- ---------------------------- -- Table structure for QRTZ_CRON_TRIGGERS -- ---------------------------- DROP TABLE IF EXISTS `QRTZ_CRON_TRIGGERS`; CREATE TABLE `QRTZ_CRON_TRIGGERS` ( `sched_name` varchar(120) NOT NULL COMMENT '调度名称', `trigger_name` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键', `trigger_group` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键', `cron_expression` varchar(200) NOT NULL COMMENT 'cron表达式', `time_zone_id` varchar(80) DEFAULT NULL COMMENT '时区', PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`), CONSTRAINT `QRTZ_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `QRTZ_TRIGGERS` (`sched_name`, `trigger_name`, `trigger_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Cron类型的触发器表'; -- ---------------------------- -- Records of QRTZ_CRON_TRIGGERS -- ---------------------------- INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', '0/10 * * * * ?', 'Asia/Shanghai'); INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', '0/15 * * * * ?', 'Asia/Shanghai'); INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', '0/20 * * * * ?', 'Asia/Shanghai'); -- ---------------------------- -- Table structure for QRTZ_FIRED_TRIGGERS -- ---------------------------- DROP TABLE IF EXISTS `QRTZ_FIRED_TRIGGERS`; CREATE TABLE `QRTZ_FIRED_TRIGGERS` ( `sched_name` varchar(120) NOT NULL COMMENT '调度名称', `entry_id` varchar(95) NOT NULL COMMENT '调度器实例id', `trigger_name` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键', `trigger_group` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键', `instance_name` varchar(200) NOT NULL COMMENT '调度器实例名', `fired_time` bigint NOT NULL COMMENT '触发的时间', `sched_time` bigint NOT NULL COMMENT '定时器制定的时间', `priority` int NOT NULL COMMENT '优先级', `state` varchar(16) NOT NULL COMMENT '状态', `job_name` varchar(200) DEFAULT NULL COMMENT '任务名称', `job_group` varchar(200) DEFAULT NULL COMMENT '任务组名', `is_nonconcurrent` varchar(1) DEFAULT NULL COMMENT '是否并发', `requests_recovery` varchar(1) DEFAULT NULL COMMENT '是否接受恢复执行', PRIMARY KEY (`sched_name`,`entry_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='已触发的触发器表'; -- ---------------------------- -- Records of QRTZ_FIRED_TRIGGERS -- ---------------------------- -- ---------------------------- -- Table structure for QRTZ_JOB_DETAILS -- ---------------------------- DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`; CREATE TABLE `QRTZ_JOB_DETAILS` ( `sched_name` varchar(120) NOT NULL COMMENT '调度名称', `job_name` varchar(200) NOT NULL COMMENT '任务名称', `job_group` varchar(200) NOT NULL COMMENT '任务组名', `description` varchar(250) DEFAULT NULL COMMENT '相关介绍', `job_class_name` varchar(250) NOT NULL COMMENT '执行任务类名称', `is_durable` varchar(1) NOT NULL COMMENT '是否持久化', `is_nonconcurrent` varchar(1) NOT NULL COMMENT '是否并发', `is_update_data` varchar(1) NOT NULL COMMENT '是否更新数据', `requests_recovery` varchar(1) NOT NULL COMMENT '是否接受恢复执行', `job_data` blob COMMENT '存放持久化job对象', PRIMARY KEY (`sched_name`,`job_name`,`job_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='任务详细信息表'; -- ---------------------------- -- Records of QRTZ_JOB_DETAILS -- ---------------------------- INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', null, 'com.admin.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001E636F6D2E61646D696E2E71756172747A2E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E000978720027636F6D2E61646D696E2E636F6D6D6F6E2E636F72652E646F6D61696E2E42617365456E7469747900000000000000010200074C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0006706172616D7371007E00034C000672656D61726B71007E00094C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000C787074000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000017E98908C4878707400007070707400013174000E302F3130202A202A202A202A203F74001172795461736B2E72794E6F506172616D7374000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000001740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E697A0E58F82EFBC8974000133740001317800); INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', null, 'com.admin.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001E636F6D2E61646D696E2E71756172747A2E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E000978720027636F6D2E61646D696E2E636F6D6D6F6E2E636F72652E646F6D61696E2E42617365456E7469747900000000000000010200074C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0006706172616D7371007E00034C000672656D61726B71007E00094C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000C787074000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000017E9890903078707400007070707400013174000E302F3135202A202A202A202A203F74001572795461736B2E7279506172616D7328277279272974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000002740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E69C89E58F82EFBC8974000133740001317800); INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', null, 'com.admin.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001E636F6D2E61646D696E2E71756172747A2E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E000978720027636F6D2E61646D696E2E636F6D6D6F6E2E636F72652E646F6D61696E2E42617365456E7469747900000000000000010200074C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0006706172616D7371007E00034C000672656D61726B71007E00094C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000C787074000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000017E9890903078707400007070707400013174000E302F3230202A202A202A202A203F74003872795461736B2E72794D756C7469706C65506172616D7328277279272C20747275652C20323030304C2C203331362E3530442C203130302974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000003740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E5A49AE58F82EFBC8974000133740001317800); -- ---------------------------- -- Table structure for QRTZ_LOCKS -- ---------------------------- DROP TABLE IF EXISTS `QRTZ_LOCKS`; CREATE TABLE `QRTZ_LOCKS` ( `sched_name` varchar(120) NOT NULL COMMENT '调度名称', `lock_name` varchar(40) NOT NULL COMMENT '悲观锁名称', PRIMARY KEY (`sched_name`,`lock_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='存储的悲观锁信息表'; -- ---------------------------- -- Records of QRTZ_LOCKS -- ---------------------------- INSERT INTO `QRTZ_LOCKS` VALUES ('RuoyiScheduler', 'STATE_ACCESS'); INSERT INTO `QRTZ_LOCKS` VALUES ('RuoyiScheduler', 'TRIGGER_ACCESS'); -- ---------------------------- -- Table structure for QRTZ_PAUSED_TRIGGER_GRPS -- ---------------------------- DROP TABLE IF EXISTS `QRTZ_PAUSED_TRIGGER_GRPS`; CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS` ( `sched_name` varchar(120) NOT NULL COMMENT '调度名称', `trigger_group` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键', PRIMARY KEY (`sched_name`,`trigger_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='暂停的触发器表'; -- ---------------------------- -- Records of QRTZ_PAUSED_TRIGGER_GRPS -- ---------------------------- -- ---------------------------- -- Table structure for QRTZ_SCHEDULER_STATE -- ---------------------------- DROP TABLE IF EXISTS `QRTZ_SCHEDULER_STATE`; CREATE TABLE `QRTZ_SCHEDULER_STATE` ( `sched_name` varchar(120) NOT NULL COMMENT '调度名称', `instance_name` varchar(200) NOT NULL COMMENT '实例名称', `last_checkin_time` bigint NOT NULL COMMENT '上次检查时间', `checkin_interval` bigint NOT NULL COMMENT '检查间隔时间', PRIMARY KEY (`sched_name`,`instance_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='调度器状态表'; -- ---------------------------- -- Records of QRTZ_SCHEDULER_STATE -- ---------------------------- INSERT INTO `QRTZ_SCHEDULER_STATE` VALUES ('RuoyiScheduler', 'surface1647766660843', '1647769922131', '15000'); -- ---------------------------- -- Table structure for QRTZ_SIMPLE_TRIGGERS -- ---------------------------- DROP TABLE IF EXISTS `QRTZ_SIMPLE_TRIGGERS`; CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` ( `sched_name` varchar(120) NOT NULL COMMENT '调度名称', `trigger_name` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键', `trigger_group` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键', `repeat_count` bigint NOT NULL COMMENT '重复的次数统计', `repeat_interval` bigint NOT NULL COMMENT '重复的间隔时间', `times_triggered` bigint NOT NULL COMMENT '已经触发的次数', PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`), CONSTRAINT `QRTZ_SIMPLE_TRIGGERS_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `QRTZ_TRIGGERS` (`sched_name`, `trigger_name`, `trigger_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='简单触发器的信息表'; -- ---------------------------- -- Records of QRTZ_SIMPLE_TRIGGERS -- ---------------------------- -- ---------------------------- -- Table structure for QRTZ_SIMPROP_TRIGGERS -- ---------------------------- DROP TABLE IF EXISTS `QRTZ_SIMPROP_TRIGGERS`; CREATE TABLE `QRTZ_SIMPROP_TRIGGERS` ( `sched_name` varchar(120) NOT NULL COMMENT '调度名称', `trigger_name` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键', `trigger_group` varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键', `str_prop_1` varchar(512) DEFAULT NULL COMMENT 'String类型的trigger的第一个参数', `str_prop_2` varchar(512) DEFAULT NULL COMMENT 'String类型的trigger的第二个参数', `str_prop_3` varchar(512) DEFAULT NULL COMMENT 'String类型的trigger的第三个参数', `int_prop_1` int DEFAULT NULL COMMENT 'int类型的trigger的第一个参数', `int_prop_2` int DEFAULT NULL COMMENT 'int类型的trigger的第二个参数', `long_prop_1` bigint DEFAULT NULL COMMENT 'long类型的trigger的第一个参数', `long_prop_2` bigint DEFAULT NULL COMMENT 'long类型的trigger的第二个参数', `dec_prop_1` decimal(13,4) DEFAULT NULL COMMENT 'decimal类型的trigger的第一个参数', `dec_prop_2` decimal(13,4) DEFAULT NULL COMMENT 'decimal类型的trigger的第二个参数', `bool_prop_1` varchar(1) DEFAULT NULL COMMENT 'Boolean类型的trigger的第一个参数', `bool_prop_2` varchar(1) DEFAULT NULL COMMENT 'Boolean类型的trigger的第二个参数', PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`), CONSTRAINT `QRTZ_SIMPROP_TRIGGERS_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `QRTZ_TRIGGERS` (`sched_name`, `trigger_name`, `trigger_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='同步机制的行锁表'; -- ---------------------------- -- Records of QRTZ_SIMPROP_TRIGGERS -- ---------------------------- -- ---------------------------- -- Table structure for QRTZ_TRIGGERS -- ---------------------------- DROP TABLE IF EXISTS `QRTZ_TRIGGERS`; CREATE TABLE `QRTZ_TRIGGERS` ( `sched_name` varchar(120) NOT NULL COMMENT '调度名称', `trigger_name` varchar(200) NOT NULL COMMENT '触发器的名字', `trigger_group` varchar(200) NOT NULL COMMENT '触发器所属组的名字', `job_name` varchar(200) NOT NULL COMMENT 'qrtz_job_details表job_name的外键', `job_group` varchar(200) NOT NULL COMMENT 'qrtz_job_details表job_group的外键', `description` varchar(250) DEFAULT NULL COMMENT '相关介绍', `next_fire_time` bigint DEFAULT NULL COMMENT '上一次触发时间（毫秒）', `prev_fire_time` bigint DEFAULT NULL COMMENT '下一次触发时间（默认为-1表示不触发）', `priority` int DEFAULT NULL COMMENT '优先级', `trigger_state` varchar(16) NOT NULL COMMENT '触发器状态', `trigger_type` varchar(8) NOT NULL COMMENT '触发器的类型', `start_time` bigint NOT NULL COMMENT '开始时间', `end_time` bigint DEFAULT NULL COMMENT '结束时间', `calendar_name` varchar(200) DEFAULT NULL COMMENT '日程表名称', `misfire_instr` smallint DEFAULT NULL COMMENT '补偿执行的策略', `job_data` blob COMMENT '存放持久化job对象', PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`), KEY `sched_name` (`sched_name`,`job_name`,`job_group`), CONSTRAINT `QRTZ_TRIGGERS_ibfk_1` FOREIGN KEY (`sched_name`, `job_name`, `job_group`) REFERENCES `QRTZ_JOB_DETAILS` (`sched_name`, `job_name`, `job_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='触发器详细信息表'; -- ---------------------------- -- Records of QRTZ_TRIGGERS -- ---------------------------- INSERT INTO `QRTZ_TRIGGERS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', 'TASK_CLASS_NAME1', 'DEFAULT', null, '1647766670000', '-1', '5', 'PAUSED', 'CRON', '1647766661000', '0', null, '2', ''); INSERT INTO `QRTZ_TRIGGERS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', 'TASK_CLASS_NAME2', 'DEFAULT', null, '1647766665000', '-1', '5', 'PAUSED', 'CRON', '1647766661000', '0', null, '2', ''); INSERT INTO `QRTZ_TRIGGERS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', 'TASK_CLASS_NAME3', 'DEFAULT', null, '1647766680000', '-1', '5', 'PAUSED', 'CRON', '1647766662000', '0', null, '2', ''); -- ---------------------------- -- Table structure for sys_config -- ---------------------------- DROP TABLE IF EXISTS `sys_config`; CREATE TABLE `sys_config` ( `config_id` int NOT NULL AUTO_INCREMENT COMMENT '参数主键', `config_name` varchar(100) DEFAULT '' COMMENT '参数名称', `config_key` varchar(100) DEFAULT '' COMMENT '参数键名', `config_value` varchar(500) DEFAULT '' COMMENT '参数键值', `config_type` char(1) DEFAULT 'N' COMMENT '系统内置（Y是 N否）', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`config_id`) ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='参数配置表'; -- ---------------------------- -- Records of sys_config -- ---------------------------- INSERT INTO `sys_config` VALUES ('1', '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2022-01-27 06:45:15', '', null, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow'); INSERT INTO `sys_config` VALUES ('2', '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2022-01-27 06:45:16', '', null, '初始化密码 123456'); INSERT INTO `sys_config` VALUES ('3', '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2022-01-27 06:45:16', '', null, '深色主题theme-dark，浅色主题theme-light'); INSERT INTO `sys_config` VALUES ('4', '账号自助-验证码开关', 'sys.account.captchaOnOff', 'false', 'N', 'admin', '2022-01-27 06:45:16', 'admin', '2022-03-17 07:59:55', '是否开启验证码功能（true开启，false关闭）'); INSERT INTO `sys_config` VALUES ('5', '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2022-01-27 06:45:16', '', null, '是否开启注册用户功能（true开启，false关闭）'); -- ---------------------------- -- Table structure for sys_dept -- ---------------------------- DROP TABLE IF EXISTS `sys_dept`; CREATE TABLE `sys_dept` ( `dept_id` bigint NOT NULL AUTO_INCREMENT COMMENT '部门id', `parent_id` bigint DEFAULT '0' COMMENT '父部门id', `ancestors` varchar(50) DEFAULT '' COMMENT '祖级列表', `dept_name` varchar(30) DEFAULT '' COMMENT '部门名称', `order_num` int DEFAULT '0' COMMENT '显示顺序', `leader` varchar(20) DEFAULT NULL COMMENT '负责人', `phone` varchar(11) DEFAULT NULL COMMENT '联系电话', `email` varchar(50) DEFAULT NULL COMMENT '邮箱', `status` char(1) DEFAULT '0' COMMENT '部门状态（0正常 1停用）', `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`dept_id`) ) ENGINE=InnoDB AUTO_INCREMENT=200 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='部门表'; -- ---------------------------- -- Records of sys_dept -- ---------------------------- INSERT INTO `sys_dept` VALUES ('100', '0', '0', '学校', '0', 'admin', '15888888888', 'admin@qq.com', '0', '0', 'admin', '2022-01-27 06:44:38', 'admin', '2022-03-20 09:03:04'); INSERT INTO `sys_dept` VALUES ('101', '100', '0,100', '水利学院', '1', 'admin', '15888888888', 'admin@qq.com', '0', '0', 'admin', '2022-01-27 06:44:38', 'admin', '2022-03-20 09:03:32'); INSERT INTO `sys_dept` VALUES ('102', '100', '0,100', '长沙分公司', '2', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-01-27 06:44:38', '', null); INSERT INTO `sys_dept` VALUES ('103', '101', '0,100,101', '研发部门', '1', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-01-27 06:44:38', '', null); INSERT INTO `sys_dept` VALUES ('104', '101', '0,100,101', '市场部门', '2', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-01-27 06:44:39', '', null); INSERT INTO `sys_dept` VALUES ('105', '101', '0,100,101', '测试部门', '3', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-01-27 06:44:39', '', null); INSERT INTO `sys_dept` VALUES ('106', '101', '0,100,101', '财务部门', '4', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-01-27 06:44:39', '', null); INSERT INTO `sys_dept` VALUES ('107', '101', '0,100,101', '运维部门', '5', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-01-27 06:44:39', '', null); INSERT INTO `sys_dept` VALUES ('108', '102', '0,100,102', '市场部门', '1', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-01-27 06:44:39', '', null); INSERT INTO `sys_dept` VALUES ('109', '102', '0,100,102', '财务部门', '2', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-01-27 06:44:39', '', null); -- ---------------------------- -- Table structure for sys_dict_data -- ---------------------------- DROP TABLE IF EXISTS `sys_dict_data`; CREATE TABLE `sys_dict_data` ( `dict_code` bigint NOT NULL AUTO_INCREMENT COMMENT '字典编码', `dict_sort` int DEFAULT '0' COMMENT '字典排序', `dict_label` varchar(100) DEFAULT '' COMMENT '字典标签', `dict_value` varchar(100) DEFAULT '' COMMENT '字典键值', `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型', `css_class` varchar(100) DEFAULT NULL COMMENT '样式属性（其他样式扩展）', `list_class` varchar(100) DEFAULT NULL COMMENT '表格回显样式', `is_default` char(1) DEFAULT 'N' COMMENT '是否默认（Y是 N否）', `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`dict_code`) ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='字典数据表'; -- ---------------------------- -- Records of sys_dict_data -- ---------------------------- INSERT INTO `sys_dict_data` VALUES ('1', '1', '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2022-01-27 06:45:10', '', null, '性别男'); INSERT INTO `sys_dict_data` VALUES ('2', '2', '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2022-01-27 06:45:10', '', null, '性别女'); INSERT INTO `sys_dict_data` VALUES ('3', '3', '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2022-01-27 06:45:10', 'admin', '2022-03-17 03:33:57', '性别未知'); INSERT INTO `sys_dict_data` VALUES ('4', '1', '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2022-01-27 06:45:11', '', null, '显示菜单'); INSERT INTO `sys_dict_data` VALUES ('5', '2', '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2022-01-27 06:45:11', '', null, '隐藏菜单'); INSERT INTO `sys_dict_data` VALUES ('6', '1', '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2022-01-27 06:45:11', '', null, '正常状态'); INSERT INTO `sys_dict_data` VALUES ('7', '2', '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2022-01-27 06:45:11', '', null, '停用状态'); INSERT INTO `sys_dict_data` VALUES ('8', '1', '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2022-01-27 06:45:11', '', null, '正常状态'); INSERT INTO `sys_dict_data` VALUES ('9', '2', '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2022-01-27 06:45:11', '', null, '停用状态'); INSERT INTO `sys_dict_data` VALUES ('10', '1', '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2022-01-27 06:45:12', '', null, '默认分组'); INSERT INTO `sys_dict_data` VALUES ('11', '2', '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2022-01-27 06:45:12', '', null, '系统分组'); INSERT INTO `sys_dict_data` VALUES ('12', '1', '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2022-01-27 06:45:12', '', null, '系统默认是'); INSERT INTO `sys_dict_data` VALUES ('13', '2', '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2022-01-27 06:45:12', '', null, '系统默认否'); INSERT INTO `sys_dict_data` VALUES ('14', '1', '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2022-01-27 06:45:12', '', null, '通知'); INSERT INTO `sys_dict_data` VALUES ('15', '2', '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2022-01-27 06:45:13', '', null, '公告'); INSERT INTO `sys_dict_data` VALUES ('16', '1', '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2022-01-27 06:45:13', '', null, '正常状态'); INSERT INTO `sys_dict_data` VALUES ('17', '2', '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2022-01-27 06:45:13', '', null, '关闭状态'); INSERT INTO `sys_dict_data` VALUES ('18', '1', '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2022-01-27 06:45:13', '', null, '新增操作'); INSERT INTO `sys_dict_data` VALUES ('19', '2', '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2022-01-27 06:45:13', '', null, '修改操作'); INSERT INTO `sys_dict_data` VALUES ('20', '3', '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-01-27 06:45:13', '', null, '删除操作'); INSERT INTO `sys_dict_data` VALUES ('21', '4', '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2022-01-27 06:45:14', '', null, '授权操作'); INSERT INTO `sys_dict_data` VALUES ('22', '5', '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-01-27 06:45:14', '', null, '导出操作'); INSERT INTO `sys_dict_data` VALUES ('23', '6', '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-01-27 06:45:14', '', null, '导入操作'); INSERT INTO `sys_dict_data` VALUES ('24', '7', '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-01-27 06:45:14', '', null, '强退操作'); INSERT INTO `sys_dict_data` VALUES ('25', '8', '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-01-27 06:45:14', '', null, '生成操作'); INSERT INTO `sys_dict_data` VALUES ('26', '9', '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-01-27 06:45:14', '', null, '清空操作'); INSERT INTO `sys_dict_data` VALUES ('27', '1', '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2022-01-27 06:45:15', '', null, '正常状态'); INSERT INTO `sys_dict_data` VALUES ('28', '2', '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2022-01-27 06:45:15', '', null, '停用状态'); -- ---------------------------- -- Table structure for sys_dict_type -- ---------------------------- DROP TABLE IF EXISTS `sys_dict_type`; CREATE TABLE `sys_dict_type` ( `dict_id` bigint NOT NULL AUTO_INCREMENT COMMENT '字典主键', `dict_name` varchar(100) DEFAULT '' COMMENT '字典名称', `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型', `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`dict_id`), UNIQUE KEY `dict_type` (`dict_type`) ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='字典类型表'; -- ---------------------------- -- Records of sys_dict_type -- ---------------------------- INSERT INTO `sys_dict_type` VALUES ('1', '用户性别', 'sys_user_sex', '0', 'admin', '2022-01-27 06:45:08', '', null, '用户性别列表'); INSERT INTO `sys_dict_type` VALUES ('2', '菜单状态', 'sys_show_hide', '0', 'admin', '2022-01-27 06:45:08', '', null, '菜单状态列表'); INSERT INTO `sys_dict_type` VALUES ('3', '系统开关', 'sys_normal_disable', '0', 'admin', '2022-01-27 06:45:08', '', null, '系统开关列表'); INSERT INTO `sys_dict_type` VALUES ('4', '任务状态', 'sys_job_status', '0', 'admin', '2022-01-27 06:45:09', '', null, '任务状态列表'); INSERT INTO `sys_dict_type` VALUES ('5', '任务分组', 'sys_job_group', '0', 'admin', '2022-01-27 06:45:09', '', null, '任务分组列表'); INSERT INTO `sys_dict_type` VALUES ('6', '系统是否', 'sys_yes_no', '0', 'admin', '2022-01-27 06:45:09', '', null, '系统是否列表'); INSERT INTO `sys_dict_type` VALUES ('7', '通知类型', 'sys_notice_type', '0', 'admin', '2022-01-27 06:45:09', '', null, '通知类型列表'); INSERT INTO `sys_dict_type` VALUES ('8', '通知状态', 'sys_notice_status', '0', 'admin', '2022-01-27 06:45:09', '', null, '通知状态列表'); INSERT INTO `sys_dict_type` VALUES ('9', '操作类型', 'sys_oper_type', '0', 'admin', '2022-01-27 06:45:10', '', null, '操作类型列表'); INSERT INTO `sys_dict_type` VALUES ('10', '系统状态', 'sys_common_status', '0', 'admin', '2022-01-27 06:45:10', '', null, '登录状态列表'); -- ---------------------------- -- Table structure for sys_job -- ---------------------------- DROP TABLE IF EXISTS `sys_job`; CREATE TABLE `sys_job` ( `job_id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务ID', `job_name` varchar(64) NOT NULL DEFAULT '' COMMENT '任务名称', `job_group` varchar(64) NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名', `invoke_target` varchar(500) NOT NULL COMMENT '调用目标字符串', `cron_expression` varchar(255) DEFAULT '' COMMENT 'cron执行表达式', `misfire_policy` varchar(20) DEFAULT '3' COMMENT '计划执行错误策略（1立即执行 2执行一次 3放弃执行）', `concurrent` char(1) DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）', `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1暂停）', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT '' COMMENT '备注信息', PRIMARY KEY (`job_id`,`job_name`,`job_group`) ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='定时任务调度表'; -- ---------------------------- -- Records of sys_job -- ---------------------------- INSERT INTO `sys_job` VALUES ('1', '系统默认（无参）', 'DEFAULT', 'ryTask.ryNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', '2022-01-27 06:45:17', '', null, ''); INSERT INTO `sys_job` VALUES ('2', '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(\'ry\')', '0/15 * * * * ?', '3', '1', '1', 'admin', '2022-01-27 06:45:18', '', null, ''); INSERT INTO `sys_job` VALUES ('3', '系统默认（多参）', 'DEFAULT', 'ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', '2022-01-27 06:45:18', '', null, ''); -- ---------------------------- -- Table structure for sys_job_log -- ---------------------------- DROP TABLE IF EXISTS `sys_job_log`; CREATE TABLE `sys_job_log` ( `job_log_id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务日志ID', `job_name` varchar(64) NOT NULL COMMENT '任务名称', `job_group` varchar(64) NOT NULL COMMENT '任务组名', `invoke_target` varchar(500) NOT NULL COMMENT '调用目标字符串', `job_message` varchar(500) DEFAULT NULL COMMENT '日志信息', `status` char(1) DEFAULT '0' COMMENT '执行状态（0正常 1失败）', `exception_info` varchar(2000) DEFAULT '' COMMENT '异常信息', `create_time` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`job_log_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='定时任务调度日志表'; -- ---------------------------- -- Records of sys_job_log -- ---------------------------- -- ---------------------------- -- Table structure for sys_logininfor -- ---------------------------- DROP TABLE IF EXISTS `sys_logininfor`; CREATE TABLE `sys_logininfor` ( `info_id` bigint NOT NULL AUTO_INCREMENT COMMENT '访问ID', `user_name` varchar(50) DEFAULT '' COMMENT '用户账号', `ipaddr` varchar(128) DEFAULT '' COMMENT '登录IP地址', `login_location` varchar(255) DEFAULT '' COMMENT '登录地点', `browser` varchar(50) DEFAULT '' COMMENT '浏览器类型', `os` varchar(50) DEFAULT '' COMMENT '操作系统', `status` char(1) DEFAULT '0' COMMENT '登录状态（0成功 1失败）', `msg` varchar(255) DEFAULT '' COMMENT '提示消息', `login_time` datetime DEFAULT NULL COMMENT '访问时间', PRIMARY KEY (`info_id`) ) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统访问记录'; -- ---------------------------- -- Records of sys_logininfor -- ---------------------------- INSERT INTO `sys_logininfor` VALUES ('100', 'admin', '127.0.0.1', '内网IP', 'Chrome 8', 'Windows 10', '1', '验证码已失效', '2022-01-27 07:47:18'); INSERT INTO `sys_logininfor` VALUES ('101', 'admin', '127.0.0.1', '内网IP', 'Chrome 8', 'Windows 10', '0', '登录成功', '2022-01-27 07:47:24'); INSERT INTO `sys_logininfor` VALUES ('102', 'admin', '127.0.0.1', '内网IP', 'Chrome 8', 'Windows 10', '0', '登录成功', '2022-01-27 08:27:52'); INSERT INTO `sys_logininfor` VALUES ('103', 'admin', '127.0.0.1', '内网IP', 'Chrome 8', 'Windows 10', '0', '登录成功', '2022-03-08 05:52:34'); INSERT INTO `sys_logininfor` VALUES ('104', 'admin', '127.0.0.1', '内网IP', 'Chrome 8', 'Windows 10', '0', '退出成功', '2022-03-08 05:56:09'); INSERT INTO `sys_logininfor` VALUES ('105', 'admin', '127.0.0.1', '内网IP', 'Chrome 8', 'Windows 10', '0', '登录成功', '2022-03-08 05:56:17'); INSERT INTO `sys_logininfor` VALUES ('106', 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '1', '验证码错误', '2022-03-12 07:45:27'); INSERT INTO `sys_logininfor` VALUES ('107', 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '1', '验证码错误', '2022-03-12 07:45:41'); INSERT INTO `sys_logininfor` VALUES ('108', 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '1', '验证码错误', '2022-03-12 07:45:48'); INSERT INTO `sys_logininfor` VALUES ('109', 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2022-03-12 07:45:56'); INSERT INTO `sys_logininfor` VALUES ('110', 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2022-03-12 07:51:50'); INSERT INTO `sys_logininfor` VALUES ('111', 'admin', '127.0.0.1', '内网IP', 'Chrome 58', 'Windows 10', '0', '登录成功', '2022-03-17 02:15:06'); INSERT INTO `sys_logininfor` VALUES ('112', 'admin', '127.0.0.1', '内网IP', 'Chrome 58', 'Windows 10', '0', '登录成功', '2022-03-17 03:00:34'); INSERT INTO `sys_logininfor` VALUES ('113', 'admin', '127.0.0.1', '内网IP', 'Chrome 58', 'Windows 10', '0', '登录成功', '2022-03-17 03:47:37'); INSERT INTO `sys_logininfor` VALUES ('114', 'admin', '127.0.0.1', '内网IP', 'Chrome 8', 'Windows 10', '0', '登录成功', '2022-03-17 07:27:34'); INSERT INTO `sys_logininfor` VALUES ('115', 'admin', '127.0.0.1', '内网IP', 'Chrome 8', 'Windows 10', '1', '验证码已失效', '2022-03-17 07:55:32'); INSERT INTO `sys_logininfor` VALUES ('116', 'admin', '127.0.0.1', '内网IP', 'Chrome 8', 'Windows 10', '0', '登录成功', '2022-03-17 07:58:57'); INSERT INTO `sys_logininfor` VALUES ('117', 'admin', '127.0.0.1', '内网IP', 'Chrome 8', 'Windows 10', '0', '退出成功', '2022-03-17 08:01:05'); INSERT INTO `sys_logininfor` VALUES ('118', 'admin', '127.0.0.1', '内网IP', 'Chrome 8', 'Windows 10', '0', '登录成功', '2022-03-17 08:01:08'); INSERT INTO `sys_logininfor` VALUES ('119', 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2022-03-20 08:15:22'); INSERT INTO `sys_logininfor` VALUES ('120', 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2022-03-20 08:53:34'); INSERT INTO `sys_logininfor` VALUES ('121', 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2022-03-20 08:55:56'); INSERT INTO `sys_logininfor` VALUES ('122', 'major01', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2022-03-20 09:05:18'); INSERT INTO `sys_logininfor` VALUES ('123', 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2022-03-20 09:10:26'); INSERT INTO `sys_logininfor` VALUES ('124', 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2022-03-20 09:17:36'); INSERT INTO `sys_logininfor` VALUES ('125', 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2022-03-20 09:23:38'); INSERT INTO `sys_logininfor` VALUES ('126', 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2022-03-20 09:28:54'); -- ---------------------------- -- Table structure for sys_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_menu`; CREATE TABLE `sys_menu` ( `menu_id` bigint NOT NULL AUTO_INCREMENT COMMENT '菜单ID', `menu_name` varchar(50) NOT NULL COMMENT '菜单名称', `parent_id` bigint DEFAULT '0' COMMENT '父菜单ID', `order_num` int DEFAULT '0' COMMENT '显示顺序', `path` varchar(200) DEFAULT '' COMMENT '路由地址', `component` varchar(255) DEFAULT NULL COMMENT '组件路径', `query` varchar(255) DEFAULT NULL COMMENT '路由参数', `is_frame` int DEFAULT '1' COMMENT '是否为外链（0是 1否）', `is_cache` int DEFAULT '0' COMMENT '是否缓存（0缓存 1不缓存）', `menu_type` char(1) DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）', `visible` char(1) DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）', `status` char(1) DEFAULT '0' COMMENT '菜单状态（0正常 1停用）', `perms` varchar(100) DEFAULT NULL COMMENT '权限标识', `icon` varchar(100) DEFAULT '#' COMMENT '菜单图标', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT '' COMMENT '备注', PRIMARY KEY (`menu_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2002 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='菜单权限表'; -- ---------------------------- -- Records of sys_menu -- ---------------------------- INSERT INTO `sys_menu` VALUES ('1', '系统管理', '0', '1', 'system', null, '', '1', '0', 'M', '0', '0', '', 'system', 'admin', '2022-01-27 06:44:41', '', null, '系统管理目录'); INSERT INTO `sys_menu` VALUES ('2', '系统监控', '0', '2', 'monitor', null, '', '1', '0', 'M', '0', '0', '', 'monitor', 'admin', '2022-01-27 06:44:42', '', null, '系统监控目录'); INSERT INTO `sys_menu` VALUES ('3', '系统工具', '0', '3', 'tool', null, '', '1', '0', 'M', '0', '0', '', 'tool', 'admin', '2022-01-27 06:44:42', '', null, '系统工具目录'); INSERT INTO `sys_menu` VALUES ('4', '若依官网', '0', '4', 'http://ruoyi.vip', null, '', '0', '0', 'M', '1', '0', '', 'guide', 'admin', '2022-01-27 06:44:42', 'admin', '2022-03-20 08:22:17', '若依官网地址'); INSERT INTO `sys_menu` VALUES ('100', '用户管理', '1', '1', 'user', 'system/user/index', '', '1', '0', 'C', '0', '0', 'system:user:list', 'user', 'admin', '2022-01-27 06:44:42', '', null, '用户管理菜单'); INSERT INTO `sys_menu` VALUES ('101', '角色管理', '1', '2', 'role', 'system/role/index', '', '1', '0', 'C', '0', '0', 'system:role:list', 'peoples', 'admin', '2022-01-27 06:44:42', '', null, '角色管理菜单'); INSERT INTO `sys_menu` VALUES ('102', '菜单管理', '1', '3', 'menu', 'system/menu/index', '', '1', '0', 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', '2022-01-27 06:44:42', '', null, '菜单管理菜单'); INSERT INTO `sys_menu` VALUES ('103', '部门管理', '1', '4', 'dept', 'system/dept/index', '', '1', '0', 'C', '0', '0', 'system:dept:list', 'tree', 'admin', '2022-01-27 06:44:42', '', null, '部门管理菜单'); INSERT INTO `sys_menu` VALUES ('104', '岗位管理', '1', '5', 'post', 'system/post/index', '', '1', '0', 'C', '0', '0', 'system:post:list', 'post', 'admin', '2022-01-27 06:44:42', '', null, '岗位管理菜单'); INSERT INTO `sys_menu` VALUES ('105', '字典管理', '1', '6', 'dict', 'system/dict/index', '', '1', '0', 'C', '0', '0', 'system:dict:list', 'dict', 'admin', '2022-01-27 06:44:43', '', null, '字典管理菜单'); INSERT INTO `sys_menu` VALUES ('106', '参数设置', '1', '7', 'config', 'system/config/index', '', '1', '0', 'C', '0', '0', 'system:config:list', 'edit', 'admin', '2022-01-27 06:44:43', '', null, '参数设置菜单'); INSERT INTO `sys_menu` VALUES ('107', '通知公告', '1', '8', 'notice', 'system/notice/index', '', '1', '0', 'C', '0', '0', 'system:notice:list', 'message', 'admin', '2022-01-27 06:44:43', '', null, '通知公告菜单'); INSERT INTO `sys_menu` VALUES ('108', '日志管理', '1', '9', 'log', '', '', '1', '0', 'M', '0', '0', '', 'log', 'admin', '2022-01-27 06:44:43', '', null, '日志管理菜单'); INSERT INTO `sys_menu` VALUES ('109', '在线用户', '2', '1', 'online', 'monitor/online/index', '', '1', '0', 'C', '0', '0', 'monitor:online:list', 'online', 'admin', '2022-01-27 06:44:43', '', null, '在线用户菜单'); INSERT INTO `sys_menu` VALUES ('110', '定时任务', '2', '2', 'job', 'monitor/job/index', '', '1', '0', 'C', '0', '0', 'monitor:job:list', 'job', 'admin', '2022-01-27 06:44:43', '', null, '定时任务菜单'); INSERT INTO `sys_menu` VALUES ('111', '数据监控', '2', '3', 'druid', 'monitor/druid/index', '', '1', '0', 'C', '0', '0', 'monitor:druid:list', 'druid', 'admin', '2022-01-27 06:44:43', '', null, '数据监控菜单'); INSERT INTO `sys_menu` VALUES ('112', '服务监控', '2', '4', 'server', 'monitor/server/index', '', '1', '0', 'C', '0', '0', 'monitor:server:list', 'server', 'admin', '2022-01-27 06:44:43', '', null, '服务监控菜单'); INSERT INTO `sys_menu` VALUES ('113', '缓存监控', '2', '5', 'cache', 'monitor/cache/index', '', '1', '0', 'C', '0', '0', 'monitor:cache:list', 'redis', 'admin', '2022-01-27 06:44:44', '', null, '缓存监控菜单'); INSERT INTO `sys_menu` VALUES ('114', '表单构建', '3', '1', 'build', 'tool/build/index', '', '1', '0', 'C', '0', '0', 'tool:build:list', 'build', 'admin', '2022-01-27 06:44:44', '', null, '表单构建菜单'); INSERT INTO `sys_menu` VALUES ('115', '代码生成', '3', '2', 'gen', 'tool/gen/index', '', '1', '0', 'C', '0', '0', 'tool:gen:list', 'code', 'admin', '2022-01-27 06:44:44', '', null, '代码生成菜单'); INSERT INTO `sys_menu` VALUES ('116', '系统接口', '3', '3', 'swagger', 'tool/swagger/index', '', '1', '0', 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', '2022-01-27 06:44:44', '', null, '系统接口菜单'); INSERT INTO `sys_menu` VALUES ('500', '操作日志', '108', '1', 'operlog', 'monitor/operlog/index', '', '1', '0', 'C', '0', '0', 'monitor:operlog:list', 'form', 'admin', '2022-01-27 06:44:44', '', null, '操作日志菜单'); INSERT INTO `sys_menu` VALUES ('501', '登录日志', '108', '2', 'logininfor', 'monitor/logininfor/index', '', '1', '0', 'C', '0', '0', 'monitor:logininfor:list', 'logininfor', 'admin', '2022-01-27 06:44:44', '', null, '登录日志菜单'); INSERT INTO `sys_menu` VALUES ('1001', '用户查询', '100', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:user:query', '#', 'admin', '2022-01-27 06:44:44', '', null, ''); INSERT INTO `sys_menu` VALUES ('1002', '用户新增', '100', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:user:add', '#', 'admin', '2022-01-27 06:44:44', '', null, ''); INSERT INTO `sys_menu` VALUES ('1003', '用户修改', '100', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:user:edit', '#', 'admin', '2022-01-27 06:44:44', '', null, ''); INSERT INTO `sys_menu` VALUES ('1004', '用户删除', '100', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:user:remove', '#', 'admin', '2022-01-27 06:44:45', '', null, ''); INSERT INTO `sys_menu` VALUES ('1005', '用户导出', '100', '5', '', '', '', '1', '0', 'F', '0', '0', 'system:user:export', '#', 'admin', '2022-01-27 06:44:45', '', null, ''); INSERT INTO `sys_menu` VALUES ('1006', '用户导入', '100', '6', '', '', '', '1', '0', 'F', '0', '0', 'system:user:import', '#', 'admin', '2022-01-27 06:44:45', '', null, ''); INSERT INTO `sys_menu` VALUES ('1007', '重置密码', '100', '7', '', '', '', '1', '0', 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', '2022-01-27 06:44:45', '', null, ''); INSERT INTO `sys_menu` VALUES ('1008', '角色查询', '101', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:role:query', '#', 'admin', '2022-01-27 06:44:45', '', null, ''); INSERT INTO `sys_menu` VALUES ('1009', '角色新增', '101', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:role:add', '#', 'admin', '2022-01-27 06:44:45', '', null, ''); INSERT INTO `sys_menu` VALUES ('1010', '角色修改', '101', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:role:edit', '#', 'admin', '2022-01-27 06:44:45', '', null, ''); INSERT INTO `sys_menu` VALUES ('1011', '角色删除', '101', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:role:remove', '#', 'admin', '2022-01-27 06:44:45', '', null, ''); INSERT INTO `sys_menu` VALUES ('1012', '角色导出', '101', '5', '', '', '', '1', '0', 'F', '0', '0', 'system:role:export', '#', 'admin', '2022-01-27 06:44:46', '', null, ''); INSERT INTO `sys_menu` VALUES ('1013', '菜单查询', '102', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:query', '#', 'admin', '2022-01-27 06:44:46', '', null, ''); INSERT INTO `sys_menu` VALUES ('1014', '菜单新增', '102', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:add', '#', 'admin', '2022-01-27 06:44:46', '', null, ''); INSERT INTO `sys_menu` VALUES ('1015', '菜单修改', '102', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:edit', '#', 'admin', '2022-01-27 06:44:46', '', null, ''); INSERT INTO `sys_menu` VALUES ('1016', '菜单删除', '102', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:remove', '#', 'admin', '2022-01-27 06:44:46', '', null, ''); INSERT INTO `sys_menu` VALUES ('1017', '部门查询', '103', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:query', '#', 'admin', '2022-01-27 06:44:46', '', null, ''); INSERT INTO `sys_menu` VALUES ('1018', '部门新增', '103', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:add', '#', 'admin', '2022-01-27 06:44:46', '', null, ''); INSERT INTO `sys_menu` VALUES ('1019', '部门修改', '103', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:edit', '#', 'admin', '2022-01-27 06:44:46', '', null, ''); INSERT INTO `sys_menu` VALUES ('1020', '部门删除', '103', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:remove', '#', 'admin', '2022-01-27 06:44:46', '', null, ''); INSERT INTO `sys_menu` VALUES ('1021', '岗位查询', '104', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:post:query', '#', 'admin', '2022-01-27 06:44:47', '', null, ''); INSERT INTO `sys_menu` VALUES ('1022', '岗位新增', '104', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:post:add', '#', 'admin', '2022-01-27 06:44:47', '', null, ''); INSERT INTO `sys_menu` VALUES ('1023', '岗位修改', '104', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:post:edit', '#', 'admin', '2022-01-27 06:44:47', '', null, ''); INSERT INTO `sys_menu` VALUES ('1024', '岗位删除', '104', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:post:remove', '#', 'admin', '2022-01-27 06:44:47', '', null, ''); INSERT INTO `sys_menu` VALUES ('1025', '岗位导出', '104', '5', '', '', '', '1', '0', 'F', '0', '0', 'system:post:export', '#', 'admin', '2022-01-27 06:44:47', '', null, ''); INSERT INTO `sys_menu` VALUES ('1026', '字典查询', '105', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:query', '#', 'admin', '2022-01-27 06:44:47', '', null, ''); INSERT INTO `sys_menu` VALUES ('1027', '字典新增', '105', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:add', '#', 'admin', '2022-01-27 06:44:47', '', null, ''); INSERT INTO `sys_menu` VALUES ('1028', '字典修改', '105', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:edit', '#', 'admin', '2022-01-27 06:44:47', '', null, ''); INSERT INTO `sys_menu` VALUES ('1029', '字典删除', '105', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:remove', '#', 'admin', '2022-01-27 06:44:47', '', null, ''); INSERT INTO `sys_menu` VALUES ('1030', '字典导出', '105', '5', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:export', '#', 'admin', '2022-01-27 06:44:48', '', null, ''); INSERT INTO `sys_menu` VALUES ('1031', '参数查询', '106', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:query', '#', 'admin', '2022-01-27 06:44:48', '', null, ''); INSERT INTO `sys_menu` VALUES ('1032', '参数新增', '106', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:add', '#', 'admin', '2022-01-27 06:44:48', '', null, ''); INSERT INTO `sys_menu` VALUES ('1033', '参数修改', '106', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:edit', '#', 'admin', '2022-01-27 06:44:48', '', null, ''); INSERT INTO `sys_menu` VALUES ('1034', '参数删除', '106', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:remove', '#', 'admin', '2022-01-27 06:44:48', '', null, ''); INSERT INTO `sys_menu` VALUES ('1035', '参数导出', '106', '5', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:export', '#', 'admin', '2022-01-27 06:44:48', '', null, ''); INSERT INTO `sys_menu` VALUES ('1036', '公告查询', '107', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:notice:query', '#', 'admin', '2022-01-27 06:44:48', '', null, ''); INSERT INTO `sys_menu` VALUES ('1037', '公告新增', '107', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:notice:add', '#', 'admin', '2022-01-27 06:44:49', '', null, ''); INSERT INTO `sys_menu` VALUES ('1038', '公告修改', '107', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:notice:edit', '#', 'admin', '2022-01-27 06:44:49', '', null, ''); INSERT INTO `sys_menu` VALUES ('1039', '公告删除', '107', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:notice:remove', '#', 'admin', '2022-01-27 06:44:49', '', null, ''); INSERT INTO `sys_menu` VALUES ('1040', '操作查询', '500', '1', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:operlog:query', '#', 'admin', '2022-01-27 06:44:49', '', null, ''); INSERT INTO `sys_menu` VALUES ('1041', '操作删除', '500', '2', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:operlog:remove', '#', 'admin', '2022-01-27 06:44:49', '', null, ''); INSERT INTO `sys_menu` VALUES ('1042', '日志导出', '500', '4', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:operlog:export', '#', 'admin', '2022-01-27 06:44:49', '', null, ''); INSERT INTO `sys_menu` VALUES ('1043', '登录查询', '501', '1', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:logininfor:query', '#', 'admin', '2022-01-27 06:44:49', '', null, ''); INSERT INTO `sys_menu` VALUES ('1044', '登录删除', '501', '2', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:logininfor:remove', '#', 'admin', '2022-01-27 06:44:49', '', null, ''); INSERT INTO `sys_menu` VALUES ('1045', '日志导出', '501', '3', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:logininfor:export', '#', 'admin', '2022-01-27 06:44:50', '', null, ''); INSERT INTO `sys_menu` VALUES ('1046', '在线查询', '109', '1', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:online:query', '#', 'admin', '2022-01-27 06:44:50', '', null, ''); INSERT INTO `sys_menu` VALUES ('1047', '批量强退', '109', '2', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', '2022-01-27 06:44:50', '', null, ''); INSERT INTO `sys_menu` VALUES ('1048', '单条强退', '109', '3', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', '2022-01-27 06:44:50', '', null, ''); INSERT INTO `sys_menu` VALUES ('1049', '任务查询', '110', '1', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:job:query', '#', 'admin', '2022-01-27 06:44:50', '', null, ''); INSERT INTO `sys_menu` VALUES ('1050', '任务新增', '110', '2', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:job:add', '#', 'admin', '2022-01-27 06:44:50', '', null, ''); INSERT INTO `sys_menu` VALUES ('1051', '任务修改', '110', '3', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:job:edit', '#', 'admin', '2022-01-27 06:44:50', '', null, ''); INSERT INTO `sys_menu` VALUES ('1052', '任务删除', '110', '4', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:job:remove', '#', 'admin', '2022-01-27 06:44:50', '', null, ''); INSERT INTO `sys_menu` VALUES ('1053', '状态修改', '110', '5', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', '2022-01-27 06:44:50', '', null, ''); INSERT INTO `sys_menu` VALUES ('1054', '任务导出', '110', '7', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:job:export', '#', 'admin', '2022-01-27 06:44:51', '', null, ''); INSERT INTO `sys_menu` VALUES ('1055', '生成查询', '115', '1', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:query', '#', 'admin', '2022-01-27 06:44:51', '', null, ''); INSERT INTO `sys_menu` VALUES ('1056', '生成修改', '115', '2', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:edit', '#', 'admin', '2022-01-27 06:44:51', '', null, ''); INSERT INTO `sys_menu` VALUES ('1057', '生成删除', '115', '3', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:remove', '#', 'admin', '2022-01-27 06:44:51', '', null, ''); INSERT INTO `sys_menu` VALUES ('1058', '导入代码', '115', '2', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:import', '#', 'admin', '2022-01-27 06:44:51', '', null, ''); INSERT INTO `sys_menu` VALUES ('1059', '预览代码', '115', '4', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:preview', '#', 'admin', '2022-01-27 06:44:51', '', null, ''); INSERT INTO `sys_menu` VALUES ('1060', '生成代码', '115', '5', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:code', '#', 'admin', '2022-01-27 06:44:51', '', null, ''); INSERT INTO `sys_menu` VALUES ('2000', '专业分流', '0', '3', 'major', null, null, '1', '0', 'M', '0', '0', null, 'education', 'admin', '2022-03-20 08:19:59', '', null, ''); INSERT INTO `sys_menu` VALUES ('2001', '日程安排', '2000', '1', '/major/arrange', 'major/arrange/index', null, '1', '0', 'C', '0', '0', 'major:arrange:list', 'build', 'admin', '2022-03-20 08:53:37', '', null, ''); -- ---------------------------- -- Table structure for sys_notice -- ---------------------------- DROP TABLE IF EXISTS `sys_notice`; CREATE TABLE `sys_notice` ( `notice_id` int NOT NULL AUTO_INCREMENT COMMENT '公告ID', `notice_title` varchar(50) NOT NULL COMMENT '公告标题', `notice_type` char(1) NOT NULL COMMENT '公告类型（1通知 2公告）', `notice_content` longblob COMMENT '公告内容', `status` char(1) DEFAULT '0' COMMENT '公告状态（0正常 1关闭）', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(255) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`notice_id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='通知公告表'; -- ---------------------------- -- Records of sys_notice -- ---------------------------- INSERT INTO `sys_notice` VALUES ('1', '温馨提醒：2018-07-01 若依新版本发布啦', '2', 0xE696B0E78988E69CACE58685E5AEB9, '0', 'admin', '2022-01-27 06:45:19', '', null, '管理员'); INSERT INTO `sys_notice` VALUES ('2', '维护通知：2018-07-01 若依系统凌晨维护', '1', 0xE7BBB4E68AA4E58685E5AEB9, '0', 'admin', '2022-01-27 06:45:19', '', null, '管理员'); -- ---------------------------- -- Table structure for sys_oper_log -- ---------------------------- DROP TABLE IF EXISTS `sys_oper_log`; CREATE TABLE `sys_oper_log` ( `oper_id` bigint NOT NULL AUTO_INCREMENT COMMENT '日志主键', `title` varchar(50) DEFAULT '' COMMENT '模块标题', `business_type` int DEFAULT '0' COMMENT '业务类型（0其它 1新增 2修改 3删除）', `method` varchar(100) DEFAULT '' COMMENT '方法名称', `request_method` varchar(10) DEFAULT '' COMMENT '请求方式', `operator_type` int DEFAULT '0' COMMENT '操作类别（0其它 1后台用户 2手机端用户）', `oper_name` varchar(50) DEFAULT '' COMMENT '操作人员', `dept_name` varchar(50) DEFAULT '' COMMENT '部门名称', `oper_url` varchar(255) DEFAULT '' COMMENT '请求URL', `oper_ip` varchar(128) DEFAULT '' COMMENT '主机地址', `oper_location` varchar(255) DEFAULT '' COMMENT '操作地点', `oper_param` varchar(2000) DEFAULT '' COMMENT '请求参数', `json_result` varchar(2000) DEFAULT '' COMMENT '返回参数', `status` int DEFAULT '0' COMMENT '操作状态（0正常 1异常）', `error_msg` varchar(2000) DEFAULT '' COMMENT '错误消息', `oper_time` datetime DEFAULT NULL COMMENT '操作时间', PRIMARY KEY (`oper_id`) ) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='操作日志记录'; -- ---------------------------- -- Records of sys_oper_log -- ---------------------------- INSERT INTO `sys_oper_log` VALUES ('100', '代码生成', '6', 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', '1', 'admin', null, '/tool/gen/importTable', '127.0.0.1', '内网IP', 'QRTZ_PAUSED_TRIGGER_GRPS', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-01-27 07:50:11'); INSERT INTO `sys_oper_log` VALUES ('101', '代码生成', '8', 'com.ruoyi.generator.controller.GenController.batchGenCode()', 'GET', '1', 'admin', null, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{}', null, '0', null, '2022-01-27 07:50:17'); INSERT INTO `sys_oper_log` VALUES ('102', '用户管理', '1', 'com.admin.web.controller.system.SysUserController.add()', 'POST', '1', 'admin', null, '/system/user', '127.0.0.1', '内网IP', '{\"phonenumber\":\"18318303030\",\"admin\":false,\"remark\":\"cscscsccsccscscscscsscsc\",\"password\":\"$2a$10$vtIfboe7vdn5Ol.uQy9XmuazuPlFFoDS.uXEY/Vxkr2OXo7vy1PFK\",\"postIds\":[4],\"email\":\"809268652@qq.com\",\"nickName\":\"ljx\",\"sex\":\"0\",\"deptId\":103,\"params\":{},\"userName\":\"ljx\",\"userId\":100,\"createBy\":\"admin\",\"roleIds\":[2],\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-17 03:02:53'); INSERT INTO `sys_oper_log` VALUES ('103', '用户管理', '1', 'com.admin.web.controller.system.SysUserController.add()', 'POST', '1', 'admin', null, '/system/user', '127.0.0.1', '内网IP', '{\"phonenumber\":\"18318303030\",\"admin\":false,\"remark\":\"cscscsccsccscscscscsscsc\",\"password\":\"123456\",\"postIds\":[4],\"email\":\"809268652@qq.com\",\"nickName\":\"ljx\",\"sex\":\"0\",\"deptId\":103,\"params\":{},\"userName\":\"ljx\",\"roleIds\":[2],\"status\":\"0\"}', '{\"msg\":\"新增用户\'ljx\'失败，登录账号已存在\",\"code\":500}', '0', null, '2022-03-17 03:03:03'); INSERT INTO `sys_oper_log` VALUES ('104', '字典数据', '2', 'com.admin.web.controller.system.SysDictDataController.edit()', 'PUT', '1', 'admin', null, '/system/dict/data', '127.0.0.1', '内网IP', '{\"dictValue\":\"2\",\"listClass\":\"\",\"dictSort\":3,\"remark\":\"性别未知\",\"params\":{},\"dictType\":\"sys_user_sex\",\"dictLabel\":\"未知\",\"createBy\":\"admin\",\"default\":false,\"isDefault\":\"N\",\"cssClass\":\"\",\"createTime\":1643237110000,\"dictCode\":3,\"updateBy\":\"admin\",\"status\":\"1\"}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-17 03:33:36'); INSERT INTO `sys_oper_log` VALUES ('105', '字典数据', '2', 'com.admin.web.controller.system.SysDictDataController.edit()', 'PUT', '1', 'admin', null, '/system/dict/data', '127.0.0.1', '内网IP', '{\"dictValue\":\"2\",\"listClass\":\"\",\"dictSort\":3,\"remark\":\"性别未知\",\"params\":{},\"dictType\":\"sys_user_sex\",\"dictLabel\":\"未知\",\"createBy\":\"admin\",\"default\":false,\"isDefault\":\"N\",\"cssClass\":\"\",\"createTime\":1643237110000,\"dictCode\":3,\"updateBy\":\"admin\",\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-17 03:33:57'); INSERT INTO `sys_oper_log` VALUES ('106', '字典类型', '9', 'com.admin.web.controller.system.SysDictTypeController.refreshCache()', 'DELETE', '1', 'admin', null, '/system/dict/type/refreshCache', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-17 03:37:54'); INSERT INTO `sys_oper_log` VALUES ('107', '参数管理', '2', 'com.admin.web.controller.system.SysConfigController.edit()', 'PUT', '1', 'admin', null, '/system/config', '127.0.0.1', '内网IP', '{\"configName\":\"账号自助-验证码开关\",\"configKey\":\"sys.account.captchaOnOff\",\"createBy\":\"admin\",\"createTime\":1643237116000,\"updateBy\":\"admin\",\"configId\":4,\"remark\":\"是否开启验证码功能（true开启，false关闭）\",\"configType\":\"N\",\"configValue\":\"true\",\"params\":{}}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-17 07:28:25'); INSERT INTO `sys_oper_log` VALUES ('108', '参数管理', '9', 'com.admin.web.controller.system.SysConfigController.refreshCache()', 'DELETE', '1', 'admin', null, '/system/config/refreshCache', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-17 07:28:42'); INSERT INTO `sys_oper_log` VALUES ('109', '参数管理', '2', 'com.admin.web.controller.system.SysConfigController.edit()', 'PUT', '1', 'admin', null, '/system/config', '127.0.0.1', '内网IP', '{\"configName\":\"账号自助-验证码开关\",\"configKey\":\"sys.account.captchaOnOff\",\"createBy\":\"admin\",\"createTime\":1643237116000,\"updateBy\":\"admin\",\"configId\":4,\"remark\":\"是否开启验证码功能（true开启，false关闭）\",\"updateTime\":1647473305000,\"configType\":\"N\",\"configValue\":\"false\",\"params\":{}}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-17 07:59:55'); INSERT INTO `sys_oper_log` VALUES ('110', '参数管理', '9', 'com.admin.web.controller.system.SysConfigController.refreshCache()', 'DELETE', '1', 'admin', null, '/system/config/refreshCache', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-17 07:59:59'); INSERT INTO `sys_oper_log` VALUES ('111', '菜单管理', '3', 'com.admin.web.controller.system.SysMenuController.remove()', 'DELETE', '1', 'admin', null, '/system/menu/4', '127.0.0.1', '内网IP', '{menuId=4}', '{\"msg\":\"菜单已分配,不允许删除\",\"code\":500}', '0', null, '2022-03-20 08:16:19'); INSERT INTO `sys_oper_log` VALUES ('112', '菜单管理', '1', 'com.admin.web.controller.system.SysMenuController.add()', 'POST', '1', 'admin', null, '/system/menu', '127.0.0.1', '内网IP', '{\"visible\":\"0\",\"icon\":\"education\",\"orderNum\":3,\"menuName\":\"专业分流\",\"params\":{},\"parentId\":0,\"isCache\":\"0\",\"path\":\"major\",\"createBy\":\"admin\",\"children\":[],\"isFrame\":\"1\",\"menuType\":\"M\",\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-20 08:19:59'); INSERT INTO `sys_oper_log` VALUES ('113', '菜单管理', '3', 'com.admin.web.controller.system.SysMenuController.remove()', 'DELETE', '1', 'admin', null, '/system/menu/4', '127.0.0.1', '内网IP', '{menuId=4}', '{\"msg\":\"菜单已分配,不允许删除\",\"code\":500}', '0', null, '2022-03-20 08:21:46'); INSERT INTO `sys_oper_log` VALUES ('114', '菜单管理', '2', 'com.admin.web.controller.system.SysMenuController.edit()', 'PUT', '1', 'admin', null, '/system/menu', '127.0.0.1', '内网IP', '{\"visible\":\"1\",\"query\":\"\",\"icon\":\"guide\",\"orderNum\":4,\"menuName\":\"若依官网\",\"params\":{},\"parentId\":0,\"isCache\":\"0\",\"path\":\"http://ruoyi.vip\",\"children\":[],\"createTime\":1643237082000,\"updateBy\":\"admin\",\"isFrame\":\"0\",\"menuId\":4,\"menuType\":\"M\",\"perms\":\"\",\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-20 08:22:17'); INSERT INTO `sys_oper_log` VALUES ('115', '代码生成', '6', 'com.admin.generator.controller.GenController.importTableSave()', 'POST', '1', 'admin', null, '/tool/gen/importTable', '127.0.0.1', '内网IP', 'm_schedule_arrange,m_student_info', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-20 08:28:56'); INSERT INTO `sys_oper_log` VALUES ('116', '代码生成', '2', 'com.admin.generator.controller.GenController.editSave()', 'PUT', '1', 'admin', null, '/tool/gen', '127.0.0.1', '内网IP', '{\"sub\":false,\"functionAuthor\":\"ruoyi\",\"columns\":[{\"capJavaField\":\"OrginId\",\"usableColumn\":false,\"columnId\":3,\"isIncrement\":\"0\",\"increment\":false,\"insert\":true,\"isList\":\"1\",\"dictType\":\"\",\"required\":false,\"superColumn\":false,\"updateBy\":\"\",\"isInsert\":\"1\",\"javaField\":\"orginId\",\"htmlType\":\"input\",\"edit\":true,\"query\":true,\"columnComment\":\"源数据id\",\"isQuery\":\"1\",\"sort\":1,\"list\":true,\"params\":{},\"javaType\":\"String\",\"queryType\":\"EQ\",\"columnType\":\"varchar(32)\",\"createBy\":\"admin\",\"isPk\":\"0\",\"createTime\":1647736135000,\"isEdit\":\"1\",\"tableId\":2,\"pk\":false,\"columnName\":\"orgin_id\"},{\"capJavaField\":\"ScheduleId\",\"usableColumn\":false,\"columnId\":4,\"isIncrement\":\"0\",\"increment\":false,\"insert\":true,\"isList\":\"1\",\"dictType\":\"\",\"required\":false,\"superColumn\":false,\"updateBy\":\"\",\"isInsert\":\"1\",\"javaField\":\"scheduleId\",\"htmlType\":\"input\",\"edit\":true,\"query\":true,\"columnComment\":\"日程id\",\"isQuery\":\"1\",\"sort\":2,\"list\":true,\"params\":{},\"javaType\":\"Long\",\"queryType\":\"EQ\",\"columnType\":\"int\",\"createBy\":\"admin\",\"isPk\":\"0\",\"createTime\":1647736135000,\"isEdit\":\"1\",\"tableId\":2,\"pk\":false,\"columnName\":\"schedule_id\"},{\"capJavaField\":\"ScheduleName\",\"usableColumn\":false,\"columnId\":5,\"isIncrement\":\"0\",\"increment\":false,\"insert\":true,\"isList\":\"1\",\"dictType\":\"\",\"required\":false,\"superColumn\":false,\"updateBy\":\"\",\"isInsert\":\"1\",\"javaField\":\"scheduleName\",\"htmlType\":\"input\",\"edit\":true,\"query\":true,\"columnComment\":\"日程名称\",\"isQuery\":\"1\",\"sort\":3,\"list\":true,\"params\":{},\"javaType\":\"String\",\"queryType\":\"LIKE\",\"columnType\":\"varchar(32)\",\"createBy\":\"admin\",\"isPk\":\"0\",\"createTime\":1647736135000,\"isEdit\":\"1\",\"tableId\":2,\"pk\":false,\"columnName\":\"schedule_name\"},{\"capJavaField\":\"Year\",\"usableColumn\":false,\"columnId\":6,\"isIncrement\":\"0\",\"increment\":false,\"insert\":true,\"isList\":\"1\",\"dictType\":\"\",\"required\":false,\"superColumn\":false,\"updateBy\":\"\",\"isInsert\":\"1\",\"javaField\":\"year\",\"htmlType\":\"input\",\"edit\":true,\"query\":true,\"columnComment\":\"年份\",\"isQuery\":\"1\",\"sort\":4,\"list\":true,\"params\":{},\"javaType\":\"String\",\"queryType\":\"EQ\",\"co', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-20 08:30:27'); INSERT INTO `sys_oper_log` VALUES ('117', '代码生成', '8', 'com.admin.generator.controller.GenController.batchGenCode()', 'GET', '1', 'admin', null, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{}', null, '0', null, '2022-03-20 08:31:05'); INSERT INTO `sys_oper_log` VALUES ('118', '代码生成', '3', 'com.admin.generator.controller.GenController.remove()', 'DELETE', '1', 'admin', null, '/tool/gen/2', '127.0.0.1', '内网IP', '{tableIds=2}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-20 08:46:19'); INSERT INTO `sys_oper_log` VALUES ('119', '代码生成', '6', 'com.admin.generator.controller.GenController.importTableSave()', 'POST', '1', 'admin', null, '/tool/gen/importTable', '127.0.0.1', '内网IP', 'm_schedule_arrange', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-20 08:46:34'); INSERT INTO `sys_oper_log` VALUES ('120', '代码生成', '3', 'com.admin.generator.controller.GenController.remove()', 'DELETE', '1', 'admin', null, '/tool/gen/3,4', '127.0.0.1', '内网IP', '{tableIds=3,4}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-20 08:46:50'); INSERT INTO `sys_oper_log` VALUES ('121', '代码生成', '6', 'com.admin.generator.controller.GenController.importTableSave()', 'POST', '1', 'admin', null, '/tool/gen/importTable', '127.0.0.1', '内网IP', 'm_student_info,m_special_apply,m_major_apply,m_major_info,m_schedule_arrange,m_adjust_result', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-20 08:47:41'); INSERT INTO `sys_oper_log` VALUES ('122', '代码生成', '8', 'com.admin.generator.controller.GenController.batchGenCode()', 'GET', '1', 'admin', null, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{}', null, '0', null, '2022-03-20 08:48:15'); INSERT INTO `sys_oper_log` VALUES ('123', '菜单管理', '1', 'com.admin.web.controller.system.SysMenuController.add()', 'POST', '1', 'admin', null, '/system/menu', '127.0.0.1', '内网IP', '{\"visible\":\"0\",\"icon\":\"build\",\"orderNum\":1,\"menuName\":\"日程安排\",\"params\":{},\"parentId\":2000,\"isCache\":\"0\",\"path\":\"/major/arrange\",\"component\":\"major/arrange/index\",\"createBy\":\"admin\",\"children\":[],\"isFrame\":\"1\",\"menuType\":\"C\",\"perms\":\"major:arrange:list\",\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-20 08:53:37'); INSERT INTO `sys_oper_log` VALUES ('124', '角色管理', '1', 'com.admin.web.controller.system.SysRoleController.add()', 'POST', '1', 'admin', null, '/system/role', '127.0.0.1', '内网IP', '{\"flag\":false,\"roleId\":100,\"admin\":false,\"params\":{},\"roleSort\":\"3\",\"deptCheckStrictly\":true,\"createBy\":\"admin\",\"menuCheckStrictly\":true,\"roleKey\":\"major\",\"roleName\":\"专业分流管理\",\"deptIds\":[],\"menuIds\":[2000,2001],\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-20 09:01:38'); INSERT INTO `sys_oper_log` VALUES ('125', '部门管理', '2', 'com.admin.web.controller.system.SysDeptController.edit()', 'PUT', '1', 'admin', null, '/system/dept', '127.0.0.1', '内网IP', '{\"deptName\":\"学校\",\"leader\":\"admin\",\"deptId\":100,\"orderNum\":\"0\",\"delFlag\":\"0\",\"params\":{},\"parentId\":0,\"createBy\":\"admin\",\"children\":[],\"createTime\":1643237078000,\"phone\":\"15888888888\",\"updateBy\":\"admin\",\"ancestors\":\"0\",\"email\":\"admin@qq.com\",\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-20 09:03:04'); INSERT INTO `sys_oper_log` VALUES ('126', '部门管理', '2', 'com.admin.web.controller.system.SysDeptController.edit()', 'PUT', '1', 'admin', null, '/system/dept', '127.0.0.1', '内网IP', '{\"deptName\":\"水利学院\",\"leader\":\"admin\",\"deptId\":101,\"orderNum\":\"1\",\"delFlag\":\"0\",\"params\":{},\"parentId\":100,\"createBy\":\"admin\",\"children\":[],\"createTime\":1643237078000,\"phone\":\"15888888888\",\"updateBy\":\"admin\",\"ancestors\":\"0,100\",\"email\":\"admin@qq.com\",\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-20 09:03:33'); INSERT INTO `sys_oper_log` VALUES ('127', '用户管理', '1', 'com.admin.web.controller.system.SysUserController.add()', 'POST', '1', 'admin', null, '/system/user', '127.0.0.1', '内网IP', '{\"admin\":false,\"password\":\"$2a$10$bBu9vXbvHdI4CySJU1sSpeQviBR72iDevP5DdPLgQcTGJZgrte.v2\",\"postIds\":[2],\"nickName\":\"分流测试01\",\"deptId\":101,\"params\":{},\"userName\":\"major01\",\"userId\":101,\"createBy\":\"admin\",\"roleIds\":[100],\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-20 09:05:00'); INSERT INTO `sys_oper_log` VALUES ('128', '日程安排', '2', 'com.admin.major.controller.ScheduleArrangeController.edit()', 'PUT', '1', 'admin', null, '/major/arrange', '127.0.0.1', '内网IP', '{\"scheduleName\":\"特别申请\",\"endDate\":1647705600000,\"year\":\"2020\",\"updateTime\":1647767430629,\"params\":{},\"orginId\":\"001\",\"scheduleId\":1,\"startDate\":1646150400000,\"status\":0}', '{\"msg\":\"操作失败\",\"code\":500}', '0', null, '2022-03-20 09:10:29'); INSERT INTO `sys_oper_log` VALUES ('129', '日程安排', '2', 'com.admin.major.controller.ScheduleArrangeController.edit()', 'PUT', '1', 'admin', null, '/major/arrange', '127.0.0.1', '内网IP', '{\"scheduleName\":\"特别申请\",\"createUserId\":\"1\",\"endDate\":1647705600000,\"updateUserId\":\"1\",\"year\":\"2020\",\"updateTime\":1647767436156,\"params\":{},\"collegeId\":1,\"orginId\":\"001\",\"scheduleId\":1,\"startDate\":1646150400000,\"status\":0}', '{\"msg\":\"操作失败\",\"code\":500}', '0', null, '2022-03-20 09:10:35'); INSERT INTO `sys_oper_log` VALUES ('130', '日程安排', '2', 'com.admin.major.controller.ScheduleArrangeController.edit()', 'PUT', '1', 'admin', null, '/major/arrange', '127.0.0.1', '内网IP', '{\"scheduleName\":\"特别申请\",\"createUserId\":\"001\",\"endDate\":1648656000000,\"updateUserId\":\"001\",\"year\":\"2020\",\"updateTime\":1647767499880,\"params\":{},\"collegeId\":1,\"orginId\":\"001\",\"scheduleId\":1,\"startDate\":1647705600000,\"status\":0}', '{\"msg\":\"操作失败\",\"code\":500}', '0', null, '2022-03-20 09:11:38'); INSERT INTO `sys_oper_log` VALUES ('131', '日程安排', '2', 'com.admin.major.controller.ScheduleArrangeController.edit()', 'PUT', '1', 'admin', null, '/major/arrange', '127.0.0.1', '内网IP', '{\"scheduleName\":\"特别申请\",\"createUserId\":\"001\",\"endDate\":1648656000000,\"updateUserId\":\"001\",\"year\":\"2020\",\"updateTime\":1647767696758,\"params\":{},\"collegeId\":1,\"orginId\":\"001\",\"scheduleId\":1,\"startDate\":1647705600000,\"status\":0}', '{\"msg\":\"操作失败\",\"code\":500}', '0', null, '2022-03-20 09:14:55'); INSERT INTO `sys_oper_log` VALUES ('132', '日程安排', '2', 'com.admin.major.controller.ScheduleArrangeController.edit()', 'PUT', '1', 'admin', null, '/major/arrange', '127.0.0.1', '内网IP', '{\"scheduleName\":\"特别申请\",\"createUserId\":\"001\",\"endDate\":1648656000000,\"updateUserId\":\"001\",\"year\":\"2020\",\"updateTime\":1647767713757,\"params\":{},\"collegeId\":1,\"orginId\":\"001\",\"scheduleId\":1,\"startDate\":1647705600000,\"status\":0}', '{\"msg\":\"操作失败\",\"code\":500}', '0', null, '2022-03-20 09:15:12'); INSERT INTO `sys_oper_log` VALUES ('133', '日程安排', '2', 'com.admin.major.controller.ScheduleArrangeController.edit()', 'PUT', '1', 'admin', null, '/major/arrange', '127.0.0.1', '内网IP', '{\"scheduleName\":\"特别申请\",\"createUserId\":\"001\",\"endDate\":1648656000000,\"updateUserId\":\"001\",\"year\":\"2020\",\"updateTime\":1647767766836,\"params\":{},\"collegeId\":1,\"orginId\":\"001\",\"scheduleId\":1,\"startDate\":1647705600000,\"status\":0}', '{\"msg\":\"操作失败\",\"code\":500}', '0', null, '2022-03-20 09:16:32'); INSERT INTO `sys_oper_log` VALUES ('134', '日程安排', '2', 'com.admin.major.controller.ScheduleArrangeController.edit()', 'PUT', '1', 'admin', null, '/major/arrange', '127.0.0.1', '内网IP', '{\"scheduleName\":\"001\",\"createUserId\":\"001\",\"endDate\":1648483200000,\"updateUserId\":\"001\",\"year\":\"001\",\"updateTime\":1647767947227,\"params\":{},\"collegeId\":1,\"orginId\":\"\",\"scheduleId\":1,\"startDate\":1647705600000,\"status\":0}', '{\"msg\":\"操作失败\",\"code\":500}', '0', null, '2022-03-20 09:19:06'); INSERT INTO `sys_oper_log` VALUES ('135', '日程安排', '2', 'com.admin.major.controller.ScheduleArrangeController.edit()', 'PUT', '1', 'admin', null, '/major/arrange', '127.0.0.1', '内网IP', '{\"scheduleName\":\"001\",\"createUserId\":\"001\",\"endDate\":1648483200000,\"updateUserId\":\"001\",\"year\":\"001\",\"updateTime\":1647768001958,\"params\":{},\"collegeId\":1,\"orginId\":\"\",\"scheduleId\":1,\"startDate\":1647705600000,\"status\":0}', '{\"msg\":\"操作失败\",\"code\":500}', '0', null, '2022-03-20 09:20:00'); INSERT INTO `sys_oper_log` VALUES ('136', '日程安排', '1', 'com.admin.major.controller.ScheduleArrangeController.add()', 'POST', '1', 'admin', null, '/major/arrange', '127.0.0.1', '内网IP', '{\"scheduleName\":\"001\",\"createUserId\":\"001\",\"endDate\":1648051200000,\"updateUserId\":\"001\",\"year\":\"2020\",\"params\":{},\"createTime\":1647768027628,\"collegeId\":1,\"scheduleId\":1,\"startDate\":1646582400000,\"status\":0}', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-20 09:20:26'); INSERT INTO `sys_oper_log` VALUES ('137', '代码生成', '2', 'com.admin.generator.controller.GenController.editSave()', 'PUT', '1', 'admin', null, '/tool/gen', '127.0.0.1', '内网IP', '{\"sub\":false,\"functionAuthor\":\"zewei\",\"columns\":[{\"capJavaField\":\"OrginId\",\"usableColumn\":false,\"columnId\":71,\"isIncrement\":\"0\",\"increment\":false,\"insert\":true,\"isList\":\"1\",\"dictType\":\"\",\"required\":false,\"superColumn\":false,\"updateBy\":\"\",\"isInsert\":\"1\",\"javaField\":\"orginId\",\"htmlType\":\"input\",\"edit\":true,\"query\":true,\"columnComment\":\"源数据id\",\"isQuery\":\"1\",\"sort\":1,\"list\":true,\"params\":{},\"javaType\":\"String\",\"queryType\":\"EQ\",\"columnType\":\"varchar(32)\",\"createBy\":\"admin\",\"isPk\":\"0\",\"createTime\":1647737259000,\"isEdit\":\"1\",\"tableId\":8,\"pk\":false,\"columnName\":\"orgin_id\"},{\"capJavaField\":\"ScheduleId\",\"usableColumn\":false,\"columnId\":72,\"isIncrement\":\"0\",\"increment\":false,\"insert\":true,\"isList\":\"1\",\"dictType\":\"\",\"required\":false,\"superColumn\":false,\"updateBy\":\"\",\"isInsert\":\"1\",\"javaField\":\"scheduleId\",\"htmlType\":\"input\",\"edit\":true,\"query\":true,\"columnComment\":\"日程id\",\"isQuery\":\"1\",\"sort\":2,\"list\":true,\"params\":{},\"javaType\":\"Long\",\"queryType\":\"EQ\",\"columnType\":\"int\",\"createBy\":\"admin\",\"isPk\":\"0\",\"createTime\":1647737259000,\"isEdit\":\"1\",\"tableId\":8,\"pk\":false,\"columnName\":\"schedule_id\"},{\"capJavaField\":\"ScheduleName\",\"usableColumn\":false,\"columnId\":73,\"isIncrement\":\"0\",\"increment\":false,\"insert\":true,\"isList\":\"1\",\"dictType\":\"\",\"required\":false,\"superColumn\":false,\"updateBy\":\"\",\"isInsert\":\"1\",\"javaField\":\"scheduleName\",\"htmlType\":\"input\",\"edit\":true,\"query\":true,\"columnComment\":\"日程名称\",\"isQuery\":\"1\",\"sort\":3,\"list\":true,\"params\":{},\"javaType\":\"String\",\"queryType\":\"LIKE\",\"columnType\":\"varchar(32)\",\"createBy\":\"admin\",\"isPk\":\"0\",\"createTime\":1647737259000,\"isEdit\":\"1\",\"tableId\":8,\"pk\":false,\"columnName\":\"schedule_name\"},{\"capJavaField\":\"Year\",\"usableColumn\":false,\"columnId\":74,\"isIncrement\":\"0\",\"increment\":false,\"insert\":true,\"isList\":\"1\",\"dictType\":\"\",\"required\":false,\"superColumn\":false,\"updateBy\":\"\",\"isInsert\":\"1\",\"javaField\":\"year\",\"htmlType\":\"input\",\"edit\":true,\"query\":true,\"columnComment\":\"年份\",\"isQuery\":\"1\",\"sort\":4,\"list\":true,\"params\":{},\"javaType\":\"String\",\"queryType\":\"EQ\"', '{\"msg\":\"操作成功\",\"code\":200}', '0', null, '2022-03-20 09:28:57'); -- ---------------------------- -- Table structure for sys_post -- ---------------------------- DROP TABLE IF EXISTS `sys_post`; CREATE TABLE `sys_post` ( `post_id` bigint NOT NULL AUTO_INCREMENT COMMENT '岗位ID', `post_code` varchar(64) NOT NULL COMMENT '岗位编码', `post_name` varchar(50) NOT NULL COMMENT '岗位名称', `post_sort` int NOT NULL COMMENT '显示顺序', `status` char(1) NOT NULL COMMENT '状态（0正常 1停用）', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`post_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='岗位信息表'; -- ---------------------------- -- Records of sys_post -- ---------------------------- INSERT INTO `sys_post` VALUES ('1', 'ceo', '董事长', '1', '0', 'admin', '2022-01-27 06:44:40', '', null, ''); INSERT INTO `sys_post` VALUES ('2', 'se', '项目经理', '2', '0', 'admin', '2022-01-27 06:44:40', '', null, ''); INSERT INTO `sys_post` VALUES ('3', 'hr', '人力资源', '3', '0', 'admin', '2022-01-27 06:44:40', '', null, ''); INSERT INTO `sys_post` VALUES ('4', 'user', '普通员工', '4', '0', 'admin', '2022-01-27 06:44:41', '', null, ''); -- ---------------------------- -- Table structure for sys_role -- ---------------------------- DROP TABLE IF EXISTS `sys_role`; CREATE TABLE `sys_role` ( `role_id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID', `role_name` varchar(30) NOT NULL COMMENT '角色名称', `role_key` varchar(100) NOT NULL COMMENT '角色权限字符串', `role_sort` int NOT NULL COMMENT '显示顺序', `data_scope` char(1) DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）', `menu_check_strictly` tinyint(1) DEFAULT '1' COMMENT '菜单树选择项是否关联显示', `dept_check_strictly` tinyint(1) DEFAULT '1' COMMENT '部门树选择项是否关联显示', `status` char(1) NOT NULL COMMENT '角色状态（0正常 1停用）', `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`role_id`) ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色信息表'; -- ---------------------------- -- Records of sys_role -- ---------------------------- INSERT INTO `sys_role` VALUES ('1', '超级管理员', 'admin', '1', '1', '1', '1', '0', '0', 'admin', '2022-01-27 06:44:41', '', null, '超级管理员'); INSERT INTO `sys_role` VALUES ('2', '普通角色', 'common', '2', '2', '1', '1', '0', '0', 'admin', '2022-01-27 06:44:41', '', null, '普通角色'); INSERT INTO `sys_role` VALUES ('100', '专业分流管理', 'major', '3', '1', '1', '1', '0', '0', 'admin', '2022-03-20 09:01:37', '', null, null); -- ---------------------------- -- Table structure for sys_role_dept -- ---------------------------- DROP TABLE IF EXISTS `sys_role_dept`; CREATE TABLE `sys_role_dept` ( `role_id` bigint NOT NULL COMMENT '角色ID', `dept_id` bigint NOT NULL COMMENT '部门ID', PRIMARY KEY (`role_id`,`dept_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色和部门关联表'; -- ---------------------------- -- Records of sys_role_dept -- ---------------------------- INSERT INTO `sys_role_dept` VALUES ('2', '100'); INSERT INTO `sys_role_dept` VALUES ('2', '101'); INSERT INTO `sys_role_dept` VALUES ('2', '105'); -- ---------------------------- -- Table structure for sys_role_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_role_menu`; CREATE TABLE `sys_role_menu` ( `role_id` bigint NOT NULL COMMENT '角色ID', `menu_id` bigint NOT NULL COMMENT '菜单ID', PRIMARY KEY (`role_id`,`menu_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色和菜单关联表'; -- ---------------------------- -- Records of sys_role_menu -- ---------------------------- INSERT INTO `sys_role_menu` VALUES ('2', '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', '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'); INSERT INTO `sys_role_menu` VALUES ('100', '2000'); INSERT INTO `sys_role_menu` VALUES ('100', '2001'); -- ---------------------------- -- Table structure for sys_user -- ---------------------------- DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `user_id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID', `dept_id` bigint DEFAULT NULL COMMENT '部门ID', `user_name` varchar(30) NOT NULL COMMENT '用户账号', `nick_name` varchar(30) NOT NULL COMMENT '用户昵称', `user_type` varchar(2) DEFAULT '00' COMMENT '用户类型（00系统用户）', `email` varchar(50) DEFAULT '' COMMENT '用户邮箱', `phonenumber` varchar(11) DEFAULT '' COMMENT '手机号码', `sex` char(1) DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）', `avatar` varchar(100) DEFAULT '' COMMENT '头像地址', `password` varchar(100) DEFAULT '' COMMENT '密码', `status` char(1) DEFAULT '0' COMMENT '帐号状态（0正常 1停用）', `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `login_ip` varchar(128) DEFAULT '' COMMENT '最后登录IP', `login_date` datetime DEFAULT NULL COMMENT '最后登录时间', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户信息表'; -- ---------------------------- -- Records of sys_user -- ---------------------------- INSERT INTO `sys_user` VALUES ('1', '103', 'admin', '若依', '00', 'ry@163.com', '15888888888', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', '2022-03-20 17:28:56', 'admin', '2022-01-27 06:44:40', '', '2022-03-20 09:28:54', '管理员'); INSERT INTO `sys_user` VALUES ('2', '105', 'ry', '若依', '00', 'ry@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', '2022-01-27 06:44:40', 'admin', '2022-01-27 06:44:40', '', null, '测试员'); INSERT INTO `sys_user` VALUES ('100', '103', 'ljx', 'ljx', '00', '809268652@qq.com', '18318303030', '0', '', '$2a$10$vtIfboe7vdn5Ol.uQy9XmuazuPlFFoDS.uXEY/Vxkr2OXo7vy1PFK', '0', '0', '', null, 'admin', '2022-03-17 03:02:52', '', null, 'cscscsccsccscscscscsscsc'); INSERT INTO `sys_user` VALUES ('101', '101', 'major01', '分流测试01', '00', '', '', '0', '', '$2a$10$bBu9vXbvHdI4CySJU1sSpeQviBR72iDevP5DdPLgQcTGJZgrte.v2', '0', '0', '127.0.0.1', '2022-03-20 17:05:19', 'admin', '2022-03-20 09:05:00', '', '2022-03-20 09:05:18', null); -- ---------------------------- -- Table structure for sys_user_post -- ---------------------------- DROP TABLE IF EXISTS `sys_user_post`; CREATE TABLE `sys_user_post` ( `user_id` bigint NOT NULL COMMENT '用户ID', `post_id` bigint NOT NULL COMMENT '岗位ID', PRIMARY KEY (`user_id`,`post_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户与岗位关联表'; -- ---------------------------- -- Records of sys_user_post -- ---------------------------- INSERT INTO `sys_user_post` VALUES ('1', '1'); INSERT INTO `sys_user_post` VALUES ('2', '2'); INSERT INTO `sys_user_post` VALUES ('100', '4'); INSERT INTO `sys_user_post` VALUES ('101', '2'); -- ---------------------------- -- Table structure for sys_user_role -- ---------------------------- DROP TABLE IF EXISTS `sys_user_role`; CREATE TABLE `sys_user_role` ( `user_id` bigint NOT NULL COMMENT '用户ID', `role_id` bigint NOT NULL COMMENT '角色ID', PRIMARY KEY (`user_id`,`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户和角色关联表'; -- ---------------------------- -- Records of sys_user_role -- ---------------------------- INSERT INTO `sys_user_role` VALUES ('1', '1'); INSERT INTO `sys_user_role` VALUES ('2', '2'); INSERT INTO `sys_user_role` VALUES ('100', '2'); INSERT INTO `sys_user_role` VALUES ('101', '100');