/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 50730
 Source Host           : localhost:3306
 Source Schema         : campus-reservation

 Target Server Type    : MySQL
 Target Server Version : 50730
 File Encoding         : 65001

 Date: 04/04/2024 17:09:19
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cr_campus
-- ----------------------------
DROP TABLE IF EXISTS `cr_campus`;
CREATE TABLE `cr_campus`  (
  `campus_id` int(11) NOT NULL AUTO_INCREMENT,
  `campus_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `campus_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `campus_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `campus_capacity` int(11) NULL DEFAULT NULL COMMENT '校区预约最大人数',
  PRIMARY KEY (`campus_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of cr_campus
-- ----------------------------
INSERT INTO `cr_campus` VALUES (1, '粤海校区', '粤海校区', '粤海校区', '0', '', '2024-03-17 15:31:10', '', '2024-03-17 15:31:42', '111', 20);
INSERT INTO `cr_campus` VALUES (2, '丽湖小区', '丽湖小区', '222', '0', '', '2024-03-17 15:31:30', '', NULL, '222', 15);

-- ----------------------------
-- Table structure for cr_reservation
-- ----------------------------
DROP TABLE IF EXISTS `cr_reservation`;
CREATE TABLE `cr_reservation`  (
  `reservation_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `reservation_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预约状态，（0未到参观时间  1生效中  2已过参观时间 3已取消）',
  `audit_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '报名状态，（0报名审核中 2报名成功 3报名失败）',
  `entry_time` datetime(0) NULL DEFAULT NULL COMMENT '实际入校时间',
  `leave_time` datetime(0) NULL DEFAULT NULL COMMENT '离校时间',
  `audit_opinion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核意见',
  `audit_user_id` bigint(20) NULL DEFAULT NULL COMMENT '审核人id',
  `audit_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核时间',
  `audit_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核人姓名',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '预约参观人id',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预约参观人姓名',
  `user_phone_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '预约参观人手机号',
  `user_id_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '预约参观人身份证号',
  `campus_id` int(11) NOT NULL COMMENT '校区id',
  `campus_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '校区名称',
  `reservation_date` date NOT NULL COMMENT '入校时间（日期）',
  `user_companion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '随行人员名称',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `is_hasten` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '是否催办（0为否，1为是）',
  PRIMARY KEY (`reservation_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 58 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of cr_reservation
-- ----------------------------
INSERT INTO `cr_reservation` VALUES (43, '1', '2', NULL, NULL, '手动阀手动阀', 100, '2024-04-04 15:02:40.98', '123', 100, '2222', '22222222222', '1324522662543', 1, '粤海校区', '2024-03-24', '22221,222222', '0', '', '2024-03-24 14:32:07', '', '2024-04-04 15:02:41', NULL, '0');
INSERT INTO `cr_reservation` VALUES (44, '1', '2', NULL, NULL, NULL, 1, '2024-04-04 11:38:03.166', 'admin', 100, '33333', '222223333222', '13245622262543', 2, '丽湖校区', '2024-03-24', '3331,3332', '0', '', '2024-03-24 14:32:07', '', '2024-04-04 11:38:03', NULL, '0');
INSERT INTO `cr_reservation` VALUES (45, '1', '3', NULL, NULL, '不行', 1, '2024-04-04 11:38:27.511', 'admin', 102, 'root', '123123123', '123123123', 1, '粤海校区', '2024-03-24', 'sdaasda', '0', '', '2024-03-24 14:33:44', '', '2024-04-04 11:38:28', '2024-03-24', '0');
INSERT INTO `cr_reservation` VALUES (46, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, 102, 'root', '123123123', '123123123', 1, '粤海校区', '2024-03-25', 'sdaasda', '0', '', '2024-03-24 14:33:44', '', NULL, '2024-03-25', '0');
INSERT INTO `cr_reservation` VALUES (47, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, 102, '手动阀手动阀', '123123', '123123', 2, '丽湖小区', '2024-03-25', '', '0', '', '2024-03-24 14:53:39', '', NULL, '2024-03-25', '0');
INSERT INTO `cr_reservation` VALUES (48, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, 102, 'marui', '123123', '123123123', 2, '丽湖小区', '2024-03-25', '123123', '0', '', '2024-03-24 15:02:23', '', NULL, '2024-03-25', '0');
INSERT INTO `cr_reservation` VALUES (49, '1', '0', NULL, NULL, NULL, NULL, NULL, NULL, 102, 'marui', '123123', '123123123', 1, '粤海校区', '2024-03-24', '123123', '0', '', '2024-03-24 15:02:23', '', NULL, '2024-03-24', '0');
INSERT INTO `cr_reservation` VALUES (50, '1', '0', NULL, NULL, NULL, NULL, NULL, NULL, 102, 'marui', '123123', '123123123', 2, '丽湖小区', '2024-03-24', '强强强强', '0', '', '2024-03-24 15:17:55', '', NULL, '2024-03-24', '0');
INSERT INTO `cr_reservation` VALUES (51, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, 102, 'marui', '123123', '123123123', 1, '粤海校区', '2024-03-25', '强强强强', '0', '', '2024-03-24 15:17:55', '', NULL, '2024-03-25', '0');
INSERT INTO `cr_reservation` VALUES (52, '1', '0', NULL, NULL, NULL, NULL, NULL, NULL, 102, '312312', '123123', '123123', 1, '粤海校区', '2024-03-24', 'qwer,df', '0', '', '2024-03-24 15:27:52', '', NULL, '2024-03-24', '0');
INSERT INTO `cr_reservation` VALUES (53, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, 102, '312312', '123123', '123123', 2, '丽湖小区', '2024-03-25', 'qwer,df', '0', '', '2024-03-24 15:27:52', '', NULL, '2024-03-25', '0');
INSERT INTO `cr_reservation` VALUES (54, '3', '0', NULL, NULL, NULL, NULL, NULL, NULL, 101, '马瑞', '123123123', '123123', 1, '粤海校区', '2024-03-25', '李刚', '0', '', '2024-03-24 21:25:36', '', '2024-03-24 21:41:11', '2024-03-25', '0');
INSERT INTO `cr_reservation` VALUES (55, '3', '0', NULL, NULL, NULL, NULL, NULL, NULL, 101, '马瑞', '123123123', '123123', 2, '丽湖小区', '2024-03-25', '李刚', '0', '', '2024-03-24 21:25:36', '', '2024-03-24 21:43:38', '2024-03-25', '0');
INSERT INTO `cr_reservation` VALUES (56, '3', '0', NULL, NULL, NULL, NULL, NULL, NULL, 101, 'marui', '231231', '123123', 1, '粤海校区', '2024-03-25', '123123', '0', '', '2024-03-24 21:45:48', '', '2024-03-24 21:49:28', '2024-03-25', '0');
INSERT INTO `cr_reservation` VALUES (57, '3', '0', NULL, NULL, NULL, NULL, NULL, NULL, 101, 'marui', '231231', '123123', 2, '丽湖小区', '2024-03-25', '123123', '0', '', '2024-03-24 21:45:48', '', '2024-03-24 21:50:18', '2024-03-25', '0');

-- ----------------------------
-- Table structure for cr_user_companion
-- ----------------------------
DROP TABLE IF EXISTS `cr_user_companion`;
CREATE TABLE `cr_user_companion`  (
  `user_companion_id` int(11) NOT NULL AUTO_INCREMENT,
  `reservation_id` bigint(20) NOT NULL COMMENT '预约id',
  `user_companion_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '陪同人员姓名',
  `user_companion_phone_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '陪同人员手机号',
  `user_companion_id_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '陪同人员身份证号',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`user_companion_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 50 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of cr_user_companion
-- ----------------------------
INSERT INTO `cr_user_companion` VALUES (1, 1, '开发区1', '2345364636', '45676543', '0', '', '2024-03-23 11:34:53', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (2, 1, '开发区2', '2345364636', '45676543', '0', '', '2024-03-23 11:34:53', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (3, 2, '22221', '2345364636', '45676543', '0', '', '2024-03-23 14:05:18', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (4, 2, '222222', '2345364636', '45676543', '0', '', '2024-03-23 14:05:18', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (5, 3, '3331', '2345364636', '45676543', '0', '', '2024-03-23 14:05:18', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (6, 3, '3332', '2345364636', '45676543', '0', '', '2024-03-23 14:05:18', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (7, 4, '22221', '2345364636', '45676543', '0', '', '2024-03-23 15:31:07', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (8, 4, '222222', '2345364636', '45676543', '0', '', '2024-03-23 15:31:07', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (9, 5, '3331', '2345364636', '45676543', '0', '', '2024-03-23 15:31:07', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (10, 5, '3332', '2345364636', '45676543', '0', '', '2024-03-23 15:31:07', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (11, 8, '22221', '2345364636', '45676543', '0', '', '2024-03-23 16:17:41', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (12, 8, '222222', '2345364636', '45676543', '0', '', '2024-03-23 16:17:41', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (13, 9, '3331', '2345364636', '45676543', '0', '', '2024-03-23 16:17:41', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (14, 9, '3332', '2345364636', '45676543', '0', '', '2024-03-23 16:17:41', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (15, 10, '22221', '2345364636', '45676543', '0', '', '2024-03-23 16:17:43', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (16, 10, '222222', '2345364636', '45676543', '0', '', '2024-03-23 16:17:43', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (17, 11, '3331', '2345364636', '45676543', '0', '', '2024-03-23 16:17:43', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (18, 11, '3332', '2345364636', '45676543', '0', '', '2024-03-23 16:17:43', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (19, 12, '22221', '2345364636', '45676543', '0', '', '2024-03-23 16:19:07', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (20, 12, '222222', '2345364636', '45676543', '0', '', '2024-03-23 16:19:07', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (21, 13, '3331', '2345364636', '45676543', '0', '', '2024-03-23 16:19:07', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (22, 13, '3332', '2345364636', '45676543', '0', '', '2024-03-23 16:19:07', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (23, 14, '112312', '123123', '213123', '0', '', '2024-03-24 10:28:14', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (24, 23, 'ligao', '123123', '12312312', '0', '', '2024-03-24 11:07:24', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (25, 24, 'ligao', '123123', '12312312', '0', '', '2024-03-24 11:07:24', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (26, 27, '22221', '2345364636', '45676543', '0', '', '2024-03-24 13:10:08', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (27, 27, '222222', '2345364636', '45676543', '0', '', '2024-03-24 13:10:08', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (28, 28, '3331', '2345364636', '45676543', '0', '', '2024-03-24 13:10:08', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (29, 28, '3332', '2345364636', '45676543', '0', '', '2024-03-24 13:10:08', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (30, 39, 'marui', '123123123', '123123', '0', '', '2024-03-24 14:21:15', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (31, 40, 'marui', '123123123', '123123', '0', '', '2024-03-24 14:21:15', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (32, 43, '22221', '2345364636', '45676543', '0', '', '2024-03-24 14:32:07', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (33, 43, '222222', '2345364636', '45676543', '0', '', '2024-03-24 14:32:07', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (34, 44, '3331', '2345364636', '45676543', '0', '', '2024-03-24 14:32:07', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (35, 44, '3332', '2345364636', '45676543', '0', '', '2024-03-24 14:32:07', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (36, 45, 'sdaasda', '123123', '123123', '2', '', '2024-03-24 14:33:44', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (37, 46, 'sdaasda', '123123', '123123', '0', '', '2024-03-24 14:33:44', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (38, 48, '123123', '123123', '123123', '0', '', '2024-03-24 15:02:23', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (39, 49, '123123', '123123', '123123', '0', '', '2024-03-24 15:02:23', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (40, 50, '强强强强', '123123', '123123', '0', '', '2024-03-24 15:17:55', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (41, 51, '强强强强', '123123', '123123', '0', '', '2024-03-24 15:17:55', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (42, 52, 'qwer', '123123', '123123', '0', '', '2024-03-24 15:27:52', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (43, 52, 'df', '123123', '123123', '0', '', '2024-03-24 15:27:52', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (44, 53, 'qwer', '123123', '123123', '0', '', '2024-03-24 15:27:52', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (45, 53, 'df', '123123', '123123', '0', '', '2024-03-24 15:27:52', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (46, 54, '李刚', '123123', '1231231', '0', '', '2024-03-24 21:25:36', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (47, 55, '李刚', '123123', '1231231', '0', '', '2024-03-24 21:25:36', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (48, 56, '123123', '123123', '123123', '0', '', '2024-03-24 21:45:48', '', NULL, NULL);
INSERT INTO `cr_user_companion` VALUES (49, 57, '123123', '123123', '123123', '0', '', '2024-03-24 21:45:48', '', NULL, NULL);

-- ----------------------------
-- Table structure for gen_table
-- ----------------------------
DROP TABLE IF EXISTS `gen_table`;
CREATE TABLE `gen_table`  (
  `table_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `table_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '表名称',
  `table_comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '表描述',
  `sub_table_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联子表的表名',
  `sub_table_fk_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '子表关联的外键名',
  `class_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '实体类名称',
  `tpl_category` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作）',
  `tpl_web_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '前端模板类型（element-ui模版 element-plus模版）',
  `package_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成包路径',
  `module_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成模块名',
  `business_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成业务名',
  `function_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成功能名',
  `function_author` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成功能作者',
  `gen_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）',
  `gen_path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '/' COMMENT '生成路径（不填默认项目路径）',
  `options` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '其它生成选项',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`table_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成业务表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of gen_table
-- ----------------------------
INSERT INTO `gen_table` VALUES (1, 'cr_campus', '校区管理表', NULL, NULL, 'CrCampus', 'crud', 'element-ui', 'com.ruoyi.system', 'system', 'campus', '校区管理', 'ruoyi', '0', '/', '{\"parentMenuId\":\"1\"}', 'admin', '2024-03-17 15:01:02', '', '2024-03-17 15:28:38', NULL);
INSERT INTO `gen_table` VALUES (2, 'cr_reservation', '校园预约表', NULL, NULL, 'CrReservation', 'crud', 'element-ui', 'com.ruoyi.system', 'system', 'reservation', '校园预约表', 'ruoyi', '0', '/', '{\"parentMenuId\":\"1\"}', 'admin', '2024-03-17 15:01:02', '', '2024-03-17 16:05:40', NULL);
INSERT INTO `gen_table` VALUES (3, 'cr_user_companion', '校园参观陪同人员表', NULL, NULL, 'CrUserCompanion', 'crud', 'element-ui', 'com.ruoyi.system', 'system', 'companion', '校园参观陪同人员表', 'ruoyi', '0', '/', '{\"parentMenuId\":1}', 'admin', '2024-03-17 15:01:02', '', '2024-03-17 15:03:49', NULL);

-- ----------------------------
-- Table structure for gen_table_column
-- ----------------------------
DROP TABLE IF EXISTS `gen_table_column`;
CREATE TABLE `gen_table_column`  (
  `column_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `table_id` bigint(20) NULL DEFAULT NULL COMMENT '归属表编号',
  `column_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '列名称',
  `column_comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '列描述',
  `column_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '列类型',
  `java_type` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'JAVA类型',
  `java_field` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'JAVA字段名',
  `is_pk` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否主键（1是）',
  `is_increment` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否自增（1是）',
  `is_required` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否必填（1是）',
  `is_insert` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否为插入字段（1是）',
  `is_edit` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否编辑字段（1是）',
  `is_list` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否列表字段（1是）',
  `is_query` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否查询字段（1是）',
  `query_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）',
  `html_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',
  `dict_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典类型',
  `sort` int(11) NULL DEFAULT NULL COMMENT '排序',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`column_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 47 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成业务表字段' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of gen_table_column
-- ----------------------------
INSERT INTO `gen_table_column` VALUES (1, 1, 'campus_id', '', 'int(11)', 'Long', 'campusId', '1', '1', '0', '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2024-03-17 15:01:02', '', '2024-03-23 15:37:55');
INSERT INTO `gen_table_column` VALUES (2, 1, 'campus_name', '', 'varchar(255)', 'String', 'campusName', '0', '0', '0', '1', '1', '1', '1', 'LIKE', 'input', '', 2, 'admin', '2024-03-17 15:01:02', '', '2024-03-23 15:37:55');
INSERT INTO `gen_table_column` VALUES (3, 1, 'campus_desc', '', 'varchar(255)', 'String', 'campusDesc', '0', '0', '0', '1', '1', '1', '1', 'EQ', 'input', '', 3, 'admin', '2024-03-17 15:01:02', '', '2024-03-23 15:37:55');
INSERT INTO `gen_table_column` VALUES (4, 1, 'campus_location', '', 'varchar(255)', 'String', 'campusLocation', '0', '0', '0', '1', '1', '1', '1', 'EQ', 'input', '', 4, 'admin', '2024-03-17 15:01:02', '', '2024-03-23 15:37:55');
INSERT INTO `gen_table_column` VALUES (5, 1, 'del_flag', '删除标志（0代表存在 2代表删除）', 'char(1)', 'String', 'delFlag', '0', '0', '0', '1', NULL, NULL, NULL, 'EQ', 'input', '', 5, 'admin', '2024-03-17 15:01:02', '', '2024-03-23 15:37:55');
INSERT INTO `gen_table_column` VALUES (6, 1, 'create_by', '创建者', 'varchar(64)', 'String', 'createBy', '0', '0', '0', '1', NULL, NULL, NULL, 'EQ', 'input', '', 6, 'admin', '2024-03-17 15:01:02', '', '2024-03-23 15:37:55');
INSERT INTO `gen_table_column` VALUES (7, 1, 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', '0', '1', NULL, NULL, NULL, 'EQ', 'datetime', '', 7, 'admin', '2024-03-17 15:01:02', '', '2024-03-23 15:37:55');
INSERT INTO `gen_table_column` VALUES (8, 1, 'update_by', '更新者', 'varchar(64)', 'String', 'updateBy', '0', '0', '0', '1', '1', NULL, NULL, 'EQ', 'input', '', 8, 'admin', '2024-03-17 15:01:02', '', '2024-03-23 15:37:55');
INSERT INTO `gen_table_column` VALUES (9, 1, 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', '0', '1', '1', NULL, NULL, 'EQ', 'datetime', '', 9, 'admin', '2024-03-17 15:01:02', '', '2024-03-23 15:37:55');
INSERT INTO `gen_table_column` VALUES (10, 1, 'remark', '备注', 'varchar(500)', 'String', 'remark', '0', '0', '0', '1', '1', '1', NULL, 'EQ', 'textarea', '', 10, 'admin', '2024-03-17 15:01:02', '', '2024-03-23 15:37:55');
INSERT INTO `gen_table_column` VALUES (11, 2, 'reservation_id', '主键', 'bigint(20)', 'Long', 'reservationId', '1', '1', '0', '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (12, 2, 'reservation_status', '预约状态，（0未到参观时间  1生效中  2已过参观时间 3已取消）', 'varchar(255)', 'String', 'reservationStatus', '0', '0', '0', '1', '1', '1', '1', 'EQ', 'radio', '', 2, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (13, 2, 'audit_status', '报名状态，（0报名审核中 2报名成功 3报名失败）', 'varchar(255)', 'String', 'auditStatus', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'radio', '', 3, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (14, 2, 'entry_time', '实际入校时间', 'datetime', 'Date', 'entryTime', '0', '0', '0', '1', '1', '1', '1', 'EQ', 'datetime', '', 4, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (15, 2, 'leave_time', '离校时间', 'datetime', 'Date', 'leaveTime', '0', '0', '0', '1', '1', '1', '1', 'EQ', 'datetime', '', 5, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (16, 2, 'audit_opinion', '审核意见', 'varchar(255)', 'String', 'auditOpinion', '0', '0', '0', '1', '1', '1', '1', 'EQ', 'input', '', 6, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (17, 2, 'audit_user_id', '审核人id', 'bigint(20)', 'Long', 'auditUserId', '0', '0', '0', '1', '1', '1', '1', 'EQ', 'input', '', 7, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (18, 2, 'audit_time', '审核时间', 'varchar(255)', 'String', 'auditTime', '0', '0', '0', '1', '1', '1', '1', 'EQ', 'input', '', 8, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (19, 2, 'audit_user_name', '审核人姓名', 'varchar(255)', 'String', 'auditUserName', '0', '0', '0', '1', '1', '1', '1', 'LIKE', 'input', '', 9, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (20, 2, 'user_name', '预约参观人姓名', 'varchar(255)', 'String', 'userName', '0', '0', '0', '1', '1', '1', '1', 'LIKE', 'input', '', 11, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (21, 2, 'user_phone_number', '预约参观人手机号', 'varchar(255)', 'String', 'userPhoneNumber', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 12, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (22, 2, 'user_id_number', '预约参观人身份证号', 'varchar(255)', 'String', 'userIdNumber', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 13, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (23, 2, 'campus_id', '校区id', 'int(11)', 'Long', 'campusId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 14, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (24, 2, 'campus_name', '校区名称', 'varchar(255)', 'String', 'campusName', '0', '0', '0', '1', '1', '1', '1', 'LIKE', 'input', '', 15, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (25, 2, 'reservation_date', '入校时间（日期）', 'date', 'Date', 'reservationDate', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'datetime', '', 16, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (26, 2, 'user_companion', '随行人员名称', 'varchar(255)', 'String', 'userCompanion', '0', '0', '0', '1', '1', '1', '1', 'EQ', 'input', '', 17, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (27, 2, 'del_flag', '删除标志（0代表存在 2代表删除）', 'char(1)', 'String', 'delFlag', '0', '0', '0', '1', NULL, NULL, NULL, 'EQ', 'input', '', 18, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (28, 2, 'create_by', '创建者', 'varchar(64)', 'String', 'createBy', '0', '0', '0', '1', NULL, NULL, NULL, 'EQ', 'input', '', 19, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (29, 2, 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', '0', '1', NULL, NULL, NULL, 'EQ', 'datetime', '', 20, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (30, 2, 'update_by', '更新者', 'varchar(64)', 'String', 'updateBy', '0', '0', '0', '1', '1', NULL, NULL, 'EQ', 'input', '', 21, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (31, 2, 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', '0', '1', '1', NULL, NULL, 'EQ', 'datetime', '', 22, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (32, 2, 'remark', '备注', 'varchar(500)', 'String', 'remark', '0', '0', '0', '1', '1', '1', NULL, 'EQ', 'textarea', '', 23, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (33, 3, 'user_companion_id', '', 'int(11)', 'Long', 'userCompanionId', '1', '1', '0', '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 15:05:01');
INSERT INTO `gen_table_column` VALUES (34, 3, 'user_companion_name', '陪同人员姓名', 'varchar(255)', 'String', 'userCompanionName', '0', '0', '0', '1', '1', '1', '1', 'LIKE', 'input', '', 3, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 15:05:01');
INSERT INTO `gen_table_column` VALUES (35, 3, 'user_companion_phone_number', '陪同人员手机号', 'varchar(255)', 'String', 'userCompanionPhoneNumber', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 4, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 15:05:01');
INSERT INTO `gen_table_column` VALUES (36, 3, 'user_companion_id_number', '陪同人员身份证号', 'varchar(255)', 'String', 'userCompanionIdNumber', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 5, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 15:05:01');
INSERT INTO `gen_table_column` VALUES (37, 3, 'del_flag', '删除标志（0代表存在 2代表删除）', 'char(1)', 'String', 'delFlag', '0', '0', '0', '1', NULL, NULL, NULL, 'EQ', 'input', '', 6, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 15:05:01');
INSERT INTO `gen_table_column` VALUES (38, 3, 'create_by', '创建者', 'varchar(64)', 'String', 'createBy', '0', '0', '0', '1', NULL, NULL, NULL, 'EQ', 'input', '', 7, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 15:05:01');
INSERT INTO `gen_table_column` VALUES (39, 3, 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', '0', '1', NULL, NULL, NULL, 'EQ', 'datetime', '', 8, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 15:05:01');
INSERT INTO `gen_table_column` VALUES (40, 3, 'update_by', '更新者', 'varchar(64)', 'String', 'updateBy', '0', '0', '0', '1', '1', NULL, NULL, 'EQ', 'input', '', 9, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 15:05:01');
INSERT INTO `gen_table_column` VALUES (41, 3, 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', '0', '1', '1', NULL, NULL, 'EQ', 'datetime', '', 10, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 15:05:01');
INSERT INTO `gen_table_column` VALUES (42, 3, 'remark', '备注', 'varchar(500)', 'String', 'remark', '0', '0', '0', '1', '1', '1', NULL, 'EQ', 'textarea', '', 11, 'admin', '2024-03-17 15:01:02', '', '2024-03-17 15:05:01');
INSERT INTO `gen_table_column` VALUES (43, 3, 'reservation_id', '预约id', 'bigint(20)', 'Long', 'reservationId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 2, '', '2024-03-17 15:04:44', '', '2024-03-17 15:05:01');
INSERT INTO `gen_table_column` VALUES (44, 2, 'user_id', '预约参观人id', 'bigint(20)', 'Long', 'userId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 10, '', '2024-03-17 16:04:49', '', '2024-03-17 17:12:41');
INSERT INTO `gen_table_column` VALUES (45, 2, 'is_hasten', '是否催办（0为否，1为是）', 'varchar(255)', 'String', 'isHasten', '0', '0', '0', '1', '1', '1', '1', 'EQ', 'input', '', 24, '', '2024-03-17 17:12:41', '', NULL);
INSERT INTO `gen_table_column` VALUES (46, 1, 'campus_capacity', '校区预约最大人数', 'int(11)', 'Long', 'campusCapacity', '0', '0', '0', '1', '1', '1', '1', 'EQ', 'input', '', 11, '', '2024-03-23 15:37:55', '', NULL);

-- ----------------------------
-- Table structure for qrtz_blob_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_blob_triggers`;
CREATE TABLE `qrtz_blob_triggers`  (
  `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
  `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  `blob_data` blob NULL COMMENT '存放持久化Trigger对象',
  PRIMARY KEY (`sched_name`, `trigger_name`, `trigger_group`) USING BTREE,
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'Blob类型的触发器表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of qrtz_blob_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_calendars
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_calendars`;
CREATE TABLE `qrtz_calendars`  (
  `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调度名称',
  `calendar_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日历名称',
  `calendar` blob NOT NULL COMMENT '存放持久化calendar对象',
  PRIMARY KEY (`sched_name`, `calendar_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '日历信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
  `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  `cron_expression` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'cron表达式',
  `time_zone_id` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '时区',
  PRIMARY KEY (`sched_name`, `trigger_name`, `trigger_group`) USING BTREE,
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'Cron类型的触发器表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of qrtz_cron_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_fired_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
CREATE TABLE `qrtz_fired_triggers`  (
  `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调度名称',
  `entry_id` varchar(95) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调度器实例id',
  `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
  `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  `instance_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调度器实例名',
  `fired_time` bigint(13) NOT NULL COMMENT '触发的时间',
  `sched_time` bigint(13) NOT NULL COMMENT '定时器制定的时间',
  `priority` int(11) NOT NULL COMMENT '优先级',
  `state` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态',
  `job_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '任务名称',
  `job_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '任务组名',
  `is_nonconcurrent` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否并发',
  `requests_recovery` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否接受恢复执行',
  PRIMARY KEY (`sched_name`, `entry_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '已触发的触发器表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调度名称',
  `job_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务名称',
  `job_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务组名',
  `description` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '相关介绍',
  `job_class_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '执行任务类名称',
  `is_durable` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '是否持久化',
  `is_nonconcurrent` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '是否并发',
  `is_update_data` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '是否更新数据',
  `requests_recovery` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '是否接受恢复执行',
  `job_data` blob NULL COMMENT '存放持久化job对象',
  PRIMARY KEY (`sched_name`, `job_name`, `job_group`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务详细信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of qrtz_job_details
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_locks
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_locks`;
CREATE TABLE `qrtz_locks`  (
  `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调度名称',
  `lock_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '悲观锁名称',
  PRIMARY KEY (`sched_name`, `lock_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '存储的悲观锁信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of qrtz_locks
-- ----------------------------

-- ----------------------------
-- 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调度名称',
  `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  PRIMARY KEY (`sched_name`, `trigger_group`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '暂停的触发器表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调度名称',
  `instance_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '实例名称',
  `last_checkin_time` bigint(13) NOT NULL COMMENT '上次检查时间',
  `checkin_interval` bigint(13) NOT NULL COMMENT '检查间隔时间',
  PRIMARY KEY (`sched_name`, `instance_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '调度器状态表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of qrtz_scheduler_state
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_simple_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
CREATE TABLE `qrtz_simple_triggers`  (
  `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
  `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  `repeat_count` bigint(7) NOT NULL COMMENT '重复的次数统计',
  `repeat_interval` bigint(12) NOT NULL COMMENT '重复的间隔时间',
  `times_triggered` bigint(10) NOT NULL COMMENT '已经触发的次数',
  PRIMARY KEY (`sched_name`, `trigger_name`, `trigger_group`) USING BTREE,
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '简单触发器的信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
  `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  `str_prop_1` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'String类型的trigger的第一个参数',
  `str_prop_2` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'String类型的trigger的第二个参数',
  `str_prop_3` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'String类型的trigger的第三个参数',
  `int_prop_1` int(11) NULL DEFAULT NULL COMMENT 'int类型的trigger的第一个参数',
  `int_prop_2` int(11) NULL DEFAULT NULL COMMENT 'int类型的trigger的第二个参数',
  `long_prop_1` bigint(20) NULL DEFAULT NULL COMMENT 'long类型的trigger的第一个参数',
  `long_prop_2` bigint(20) NULL DEFAULT NULL COMMENT 'long类型的trigger的第二个参数',
  `dec_prop_1` decimal(13, 4) NULL DEFAULT NULL COMMENT 'decimal类型的trigger的第一个参数',
  `dec_prop_2` decimal(13, 4) NULL DEFAULT NULL COMMENT 'decimal类型的trigger的第二个参数',
  `bool_prop_1` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Boolean类型的trigger的第一个参数',
  `bool_prop_2` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Boolean类型的trigger的第二个参数',
  PRIMARY KEY (`sched_name`, `trigger_name`, `trigger_group`) USING BTREE,
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '同步机制的行锁表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of qrtz_simprop_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_triggers`;
CREATE TABLE `qrtz_triggers`  (
  `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '触发器的名字',
  `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '触发器所属组的名字',
  `job_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_job_details表job_name的外键',
  `job_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_job_details表job_group的外键',
  `description` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '相关介绍',
  `next_fire_time` bigint(13) NULL DEFAULT NULL COMMENT '上一次触发时间（毫秒）',
  `prev_fire_time` bigint(13) NULL DEFAULT NULL COMMENT '下一次触发时间（默认为-1表示不触发）',
  `priority` int(11) NULL DEFAULT NULL COMMENT '优先级',
  `trigger_state` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '触发器状态',
  `trigger_type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '触发器的类型',
  `start_time` bigint(13) NOT NULL COMMENT '开始时间',
  `end_time` bigint(13) NULL DEFAULT NULL COMMENT '结束时间',
  `calendar_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日程表名称',
  `misfire_instr` smallint(2) NULL DEFAULT NULL COMMENT '补偿执行的策略',
  `job_data` blob NULL COMMENT '存放持久化job对象',
  PRIMARY KEY (`sched_name`, `trigger_name`, `trigger_group`) USING BTREE,
  INDEX `sched_name`(`sched_name`, `job_name`, `job_group`) USING BTREE,
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `job_name`, `job_group`) REFERENCES `qrtz_job_details` (`sched_name`, `job_name`, `job_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '触发器详细信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of qrtz_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config`  (
  `config_id` int(5) NOT NULL AUTO_INCREMENT COMMENT '参数主键',
  `config_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '参数名称',
  `config_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '参数键名',
  `config_value` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '参数键值',
  `config_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`config_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '参数配置表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_config
-- ----------------------------
INSERT INTO `sys_config` VALUES (1, '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2024-03-17 11:44:17', '', NULL, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
INSERT INTO `sys_config` VALUES (2, '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2024-03-17 11:44:17', '', NULL, '初始化密码 123456');
INSERT INTO `sys_config` VALUES (3, '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2024-03-17 11:44:17', '', NULL, '深色主题theme-dark，浅色主题theme-light');
INSERT INTO `sys_config` VALUES (4, '账号自助-验证码开关', 'sys.account.captchaEnabled', 'false', 'Y', 'admin', '2024-03-17 11:44:17', '', NULL, '是否开启验证码功能（true开启，false关闭）');
INSERT INTO `sys_config` VALUES (5, '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'true', 'Y', 'admin', '2024-03-17 11:44:17', '', NULL, '是否开启注册用户功能（true开启，false关闭）');
INSERT INTO `sys_config` VALUES (6, '用户登录-黑名单列表', 'sys.login.blackIPList', '', 'Y', 'admin', '2024-03-17 11:44:17', '', NULL, '设置登录IP黑名单限制，多个匹配项以;分隔，支持匹配（*通配、网段）');

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept`  (
  `dept_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门id',
  `parent_id` bigint(20) NULL DEFAULT 0 COMMENT '父部门id',
  `ancestors` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '祖级列表',
  `dept_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称',
  `order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序',
  `leader` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人',
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 200 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
INSERT INTO `sys_dept` VALUES (100, 0, '0', '若依科技', 0, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2024-03-17 11:44:17', '', NULL);
INSERT INTO `sys_dept` VALUES (101, 100, '0,100', '深圳总公司', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2024-03-17 11:44:17', '', NULL);
INSERT INTO `sys_dept` VALUES (102, 100, '0,100', '长沙分公司', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2024-03-17 11:44:17', '', NULL);
INSERT INTO `sys_dept` VALUES (103, 101, '0,100,101', '研发部门', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2024-03-17 11:44:17', '', NULL);
INSERT INTO `sys_dept` VALUES (104, 101, '0,100,101', '市场部门', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2024-03-17 11:44:17', '', NULL);
INSERT INTO `sys_dept` VALUES (105, 101, '0,100,101', '测试部门', 3, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2024-03-17 11:44:17', '', NULL);
INSERT INTO `sys_dept` VALUES (106, 101, '0,100,101', '财务部门', 4, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2024-03-17 11:44:17', '', NULL);
INSERT INTO `sys_dept` VALUES (107, 101, '0,100,101', '运维部门', 5, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2024-03-17 11:44:17', '', NULL);
INSERT INTO `sys_dept` VALUES (108, 102, '0,100,102', '市场部门', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2024-03-17 11:44:17', '', NULL);
INSERT INTO `sys_dept` VALUES (109, 102, '0,100,102', '财务部门', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2024-03-17 11:44:17', '', NULL);

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

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
INSERT INTO `sys_dict_data` VALUES (1, 1, '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '性别男');
INSERT INTO `sys_dict_data` VALUES (2, 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '性别女');
INSERT INTO `sys_dict_data` VALUES (3, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '性别未知');
INSERT INTO `sys_dict_data` VALUES (4, 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '显示菜单');
INSERT INTO `sys_dict_data` VALUES (5, 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '隐藏菜单');
INSERT INTO `sys_dict_data` VALUES (6, 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '正常状态');
INSERT INTO `sys_dict_data` VALUES (7, 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '停用状态');
INSERT INTO `sys_dict_data` VALUES (8, 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '正常状态');
INSERT INTO `sys_dict_data` VALUES (9, 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '停用状态');
INSERT INTO `sys_dict_data` VALUES (10, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '默认分组');
INSERT INTO `sys_dict_data` VALUES (11, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '系统分组');
INSERT INTO `sys_dict_data` VALUES (12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '系统默认是');
INSERT INTO `sys_dict_data` VALUES (13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '系统默认否');
INSERT INTO `sys_dict_data` VALUES (14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '通知');
INSERT INTO `sys_dict_data` VALUES (15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '公告');
INSERT INTO `sys_dict_data` VALUES (16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '正常状态');
INSERT INTO `sys_dict_data` VALUES (17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '关闭状态');
INSERT INTO `sys_dict_data` VALUES (18, 99, '其他', '0', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '其他操作');
INSERT INTO `sys_dict_data` VALUES (19, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '新增操作');
INSERT INTO `sys_dict_data` VALUES (20, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '修改操作');
INSERT INTO `sys_dict_data` VALUES (21, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '删除操作');
INSERT INTO `sys_dict_data` VALUES (22, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '授权操作');
INSERT INTO `sys_dict_data` VALUES (23, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '导出操作');
INSERT INTO `sys_dict_data` VALUES (24, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '导入操作');
INSERT INTO `sys_dict_data` VALUES (25, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '强退操作');
INSERT INTO `sys_dict_data` VALUES (26, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '生成操作');
INSERT INTO `sys_dict_data` VALUES (27, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '清空操作');
INSERT INTO `sys_dict_data` VALUES (28, 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '正常状态');
INSERT INTO `sys_dict_data` VALUES (29, 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '停用状态');

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

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
INSERT INTO `sys_dict_type` VALUES (1, '用户性别', 'sys_user_sex', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '用户性别列表');
INSERT INTO `sys_dict_type` VALUES (2, '菜单状态', 'sys_show_hide', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '菜单状态列表');
INSERT INTO `sys_dict_type` VALUES (3, '系统开关', 'sys_normal_disable', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '系统开关列表');
INSERT INTO `sys_dict_type` VALUES (4, '任务状态', 'sys_job_status', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '任务状态列表');
INSERT INTO `sys_dict_type` VALUES (5, '任务分组', 'sys_job_group', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '任务分组列表');
INSERT INTO `sys_dict_type` VALUES (6, '系统是否', 'sys_yes_no', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '系统是否列表');
INSERT INTO `sys_dict_type` VALUES (7, '通知类型', 'sys_notice_type', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '通知类型列表');
INSERT INTO `sys_dict_type` VALUES (8, '通知状态', 'sys_notice_status', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '通知状态列表');
INSERT INTO `sys_dict_type` VALUES (9, '操作类型', 'sys_oper_type', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '操作类型列表');
INSERT INTO `sys_dict_type` VALUES (10, '系统状态', 'sys_common_status', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '登录状态列表');

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job`  (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务ID',
  `job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '任务名称',
  `job_group` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名',
  `invoke_target` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调用目标字符串',
  `cron_expression` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'cron执行表达式',
  `misfire_policy` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '3' COMMENT '计划执行错误策略（1立即执行 2执行一次 3放弃执行）',
  `concurrent` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '状态（0正常 1暂停）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注信息',
  PRIMARY KEY (`job_id`, `job_name`, `job_group`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '定时任务调度表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_job
-- ----------------------------
INSERT INTO `sys_job` VALUES (1, '系统默认（无参）', 'DEFAULT', 'ryTask.ryNoParams', '0 0 18 * * ? ', '3', '1', '0', 'admin', '2024-03-17 11:44:17', 'admin', '2024-03-25 19:02:45', '');
INSERT INTO `sys_job` VALUES (2, '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(\'ry\')', '0 0 8 * * ? ', '3', '1', '0', 'admin', '2024-03-17 11:44:17', 'admin', '2024-03-25 19:02:26', '');
INSERT INTO `sys_job` VALUES (3, '系统默认（多参）', 'DEFAULT', 'ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', '2024-03-17 11:44:17', '', NULL, '');

-- ----------------------------
-- Table structure for sys_job_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_job_log`;
CREATE TABLE `sys_job_log`  (
  `job_log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志ID',
  `job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务名称',
  `job_group` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务组名',
  `invoke_target` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调用目标字符串',
  `job_message` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日志信息',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '执行状态（0正常 1失败）',
  `exception_info` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '异常信息',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`job_log_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '定时任务调度日志表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_job_log
-- ----------------------------
INSERT INTO `sys_job_log` VALUES (1, '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(\'ry\')', '系统默认（有参） 总共耗时：142毫秒', '0', '', '2024-03-26 08:00:00');

-- ----------------------------
-- Table structure for sys_logininfor
-- ----------------------------
DROP TABLE IF EXISTS `sys_logininfor`;
CREATE TABLE `sys_logininfor`  (
  `info_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问ID',
  `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户账号',
  `ipaddr` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录IP地址',
  `login_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录地点',
  `browser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '浏览器类型',
  `os` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作系统',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
  `msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '提示消息',
  `login_time` datetime(0) NULL DEFAULT NULL COMMENT '访问时间',
  PRIMARY KEY (`info_id`) USING BTREE,
  INDEX `idx_sys_logininfor_s`(`status`) USING BTREE,
  INDEX `idx_sys_logininfor_lt`(`login_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 153 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统访问记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_logininfor
-- ----------------------------
INSERT INTO `sys_logininfor` VALUES (100, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-03-17 14:55:35');
INSERT INTO `sys_logininfor` VALUES (101, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-03-23 11:04:40');
INSERT INTO `sys_logininfor` VALUES (102, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-03-23 16:38:41');
INSERT INTO `sys_logininfor` VALUES (103, 'admin', '172.16.18.203', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-03-23 16:56:14');
INSERT INTO `sys_logininfor` VALUES (104, 'admin', '172.16.18.203', '内网IP', 'Chrome 12', 'Windows 10', '0', '退出成功', '2024-03-23 17:13:50');
INSERT INTO `sys_logininfor` VALUES (105, '12314', '172.16.18.203', '内网IP', 'Chrome 12', 'Windows 10', '1', '用户不存在/密码错误', '2024-03-23 17:14:21');
INSERT INTO `sys_logininfor` VALUES (106, '12314', '172.16.18.203', '内网IP', 'Chrome 12', 'Windows 10', '1', '用户不存在/密码错误', '2024-03-23 17:14:33');
INSERT INTO `sys_logininfor` VALUES (107, '123', '172.16.18.203', '内网IP', 'Chrome 12', 'Windows 10', '0', '注册成功', '2024-03-23 17:19:43');
INSERT INTO `sys_logininfor` VALUES (108, '123', '172.16.18.203', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-03-23 17:23:30');
INSERT INTO `sys_logininfor` VALUES (109, 'aaa', '127.0.0.1', '内网IP', 'Mobile Safari', 'Mac OS X (iPhone)', '1', '用户不存在/密码错误', '2024-03-24 10:20:26');
INSERT INTO `sys_logininfor` VALUES (110, 'aaa', '127.0.0.1', '内网IP', 'Mobile Safari', 'Mac OS X (iPhone)', '0', '注册成功', '2024-03-24 10:20:44');
INSERT INTO `sys_logininfor` VALUES (111, 'aaa', '127.0.0.1', '内网IP', 'Mobile Safari', 'Mac OS X (iPhone)', '0', '登录成功', '2024-03-24 10:22:36');
INSERT INTO `sys_logininfor` VALUES (112, 'aaa', '127.0.0.1', '内网IP', 'Mobile Safari', 'Mac OS X (iPhone)', '0', '登录成功', '2024-03-24 10:23:38');
INSERT INTO `sys_logininfor` VALUES (113, 'aaa', '127.0.0.1', '内网IP', 'Mobile Safari', 'Mac OS X (iPhone)', '0', '登录成功', '2024-03-24 10:26:36');
INSERT INTO `sys_logininfor` VALUES (114, 'aaa', '127.0.0.1', '内网IP', 'Mobile Safari', 'Mac OS X (iPhone)', '0', '登录成功', '2024-03-24 10:27:07');
INSERT INTO `sys_logininfor` VALUES (115, '123', '127.0.0.1', '内网IP', 'Unknown', 'Unknown', '0', '登录成功', '2024-03-24 13:09:32');
INSERT INTO `sys_logininfor` VALUES (116, 'aaa', '127.0.0.1', '内网IP', 'Mobile Safari', 'Mac OS X (iPhone)', '0', '登录成功', '2024-03-24 13:40:40');
INSERT INTO `sys_logininfor` VALUES (117, '123', '127.0.0.1', '内网IP', 'Mobile Safari', 'Mac OS X (iPhone)', '1', '密码输入错误1次', '2024-03-24 14:23:25');
INSERT INTO `sys_logininfor` VALUES (118, '123', '127.0.0.1', '内网IP', 'Mobile Safari', 'Mac OS X (iPhone)', '1', '用户不存在/密码错误', '2024-03-24 14:23:25');
INSERT INTO `sys_logininfor` VALUES (119, '123123', '127.0.0.1', '内网IP', 'Mobile Safari', 'Mac OS X (iPhone)', '0', '注册成功', '2024-03-24 14:23:39');
INSERT INTO `sys_logininfor` VALUES (120, '123123', '127.0.0.1', '内网IP', 'Mobile Safari', 'Mac OS X (iPhone)', '0', '登录成功', '2024-03-24 14:23:46');
INSERT INTO `sys_logininfor` VALUES (121, 'aaa', '127.0.0.1', '内网IP', 'Mobile Safari', 'Mac OS X (iPhone)', '0', '登录成功', '2024-03-24 21:23:08');
INSERT INTO `sys_logininfor` VALUES (122, 'aaa', '127.0.0.1', '内网IP', 'Mobile Safari', 'Mac OS X (iPhone)', '0', '登录成功', '2024-03-24 21:42:08');
INSERT INTO `sys_logininfor` VALUES (123, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-03-25 18:30:43');
INSERT INTO `sys_logininfor` VALUES (124, '123', '172.16.18.203', '内网IP', 'Chrome 12', 'Windows 10', '0', '退出成功', '2024-03-25 18:59:53');
INSERT INTO `sys_logininfor` VALUES (125, 'admin', '172.16.18.203', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-03-25 18:59:55');
INSERT INTO `sys_logininfor` VALUES (126, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '退出成功', '2024-03-25 19:56:52');
INSERT INTO `sys_logininfor` VALUES (127, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-03-25 19:57:55');
INSERT INTO `sys_logininfor` VALUES (128, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '退出成功', '2024-03-25 20:11:08');
INSERT INTO `sys_logininfor` VALUES (129, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-03-25 20:11:15');
INSERT INTO `sys_logininfor` VALUES (130, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-04-04 11:36:01');
INSERT INTO `sys_logininfor` VALUES (131, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '退出成功', '2024-04-04 12:03:54');
INSERT INTO `sys_logininfor` VALUES (132, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-04-04 12:03:57');
INSERT INTO `sys_logininfor` VALUES (133, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '退出成功', '2024-04-04 12:10:44');
INSERT INTO `sys_logininfor` VALUES (134, 'ry', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-04-04 12:10:54');
INSERT INTO `sys_logininfor` VALUES (135, 'ry', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '退出成功', '2024-04-04 14:55:36');
INSERT INTO `sys_logininfor` VALUES (136, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-04-04 14:55:40');
INSERT INTO `sys_logininfor` VALUES (137, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '退出成功', '2024-04-04 14:59:44');
INSERT INTO `sys_logininfor` VALUES (138, 'ry', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-04-04 14:59:54');
INSERT INTO `sys_logininfor` VALUES (139, 'ry', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '退出成功', '2024-04-04 15:02:14');
INSERT INTO `sys_logininfor` VALUES (140, '123', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-04-04 15:02:29');
INSERT INTO `sys_logininfor` VALUES (141, '123', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '退出成功', '2024-04-04 15:04:02');
INSERT INTO `sys_logininfor` VALUES (142, 'aaa', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-04-04 15:04:15');
INSERT INTO `sys_logininfor` VALUES (143, 'aaa', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '退出成功', '2024-04-04 15:04:39');
INSERT INTO `sys_logininfor` VALUES (144, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-04-04 15:04:42');
INSERT INTO `sys_logininfor` VALUES (145, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '退出成功', '2024-04-04 15:06:23');
INSERT INTO `sys_logininfor` VALUES (146, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-04-04 15:07:16');
INSERT INTO `sys_logininfor` VALUES (147, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '退出成功', '2024-04-04 15:13:25');
INSERT INTO `sys_logininfor` VALUES (148, 'ry', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-04-04 15:13:37');
INSERT INTO `sys_logininfor` VALUES (149, 'aaa', '127.0.0.1', '内网IP', 'Mobile Safari', 'Mac OS X (iPhone)', '1', '密码输入错误1次', '2024-04-04 16:54:30');
INSERT INTO `sys_logininfor` VALUES (150, 'aaa', '127.0.0.1', '内网IP', 'Mobile Safari', 'Mac OS X (iPhone)', '1', '用户不存在/密码错误', '2024-04-04 16:54:30');
INSERT INTO `sys_logininfor` VALUES (151, 'abc', '127.0.0.1', '内网IP', 'Mobile Safari', 'Mac OS X (iPhone)', '0', '注册成功', '2024-04-04 16:54:46');
INSERT INTO `sys_logininfor` VALUES (152, 'abc', '127.0.0.1', '内网IP', 'Mobile Safari', 'Mac OS X (iPhone)', '0', '登录成功', '2024-04-04 16:54:55');

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`  (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `menu_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单名称',
  `parent_id` bigint(20) NULL DEFAULT 0 COMMENT '父菜单ID',
  `order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序',
  `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '路由地址',
  `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组件路径',
  `query` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '路由参数',
  `is_frame` int(1) NULL DEFAULT 1 COMMENT '是否为外链（0是 1否）',
  `is_cache` int(1) NULL DEFAULT 0 COMMENT '是否缓存（0缓存 1不缓存）',
  `menu_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
  `visible` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
  `perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '#' COMMENT '菜单图标',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2028 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单权限表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES (1, '系统管理', 0, 1, 'system', NULL, '', 1, 0, 'M', '0', '0', '', 'system', 'admin', '2024-03-17 11:44:17', '', NULL, '系统管理目录');
INSERT INTO `sys_menu` VALUES (2, '系统监控', 0, 2, 'monitor', NULL, '', 1, 0, 'M', '0', '0', '', 'monitor', 'admin', '2024-03-17 11:44:17', '', NULL, '系统监控目录');
INSERT INTO `sys_menu` VALUES (3, '系统工具', 0, 3, 'tool', NULL, '', 1, 0, 'M', '0', '0', '', 'tool', 'admin', '2024-03-17 11:44:17', '', NULL, '系统工具目录');
INSERT INTO `sys_menu` VALUES (4, '若依官网', 0, 4, 'http://ruoyi.vip', NULL, '', 0, 0, 'M', '0', '0', '', 'guide', 'admin', '2024-03-17 11:44:17', '', NULL, '若依官网地址');
INSERT INTO `sys_menu` VALUES (100, '用户管理', 1, 1, 'user', 'system/user/index', '', 1, 0, 'C', '0', '0', 'system:user:list', 'user', 'admin', '2024-03-17 11:44:17', '', NULL, '用户管理菜单');
INSERT INTO `sys_menu` VALUES (101, '角色管理', 1, 2, 'role', 'system/role/index', '', 1, 0, 'C', '0', '0', 'system:role:list', 'peoples', 'admin', '2024-03-17 11:44:17', '', NULL, '角色管理菜单');
INSERT INTO `sys_menu` VALUES (102, '菜单管理', 1, 3, 'menu', 'system/menu/index', '', 1, 0, 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', '2024-03-17 11:44:17', '', NULL, '菜单管理菜单');
INSERT INTO `sys_menu` VALUES (103, '部门管理', 1, 4, 'dept', 'system/dept/index', '', 1, 0, 'C', '0', '0', 'system:dept:list', 'tree', 'admin', '2024-03-17 11:44:17', '', NULL, '部门管理菜单');
INSERT INTO `sys_menu` VALUES (104, '岗位管理', 1, 5, 'post', 'system/post/index', '', 1, 0, 'C', '0', '0', 'system:post:list', 'post', 'admin', '2024-03-17 11:44:17', '', NULL, '岗位管理菜单');
INSERT INTO `sys_menu` VALUES (105, '字典管理', 1, 6, 'dict', 'system/dict/index', '', 1, 0, 'C', '0', '0', 'system:dict:list', 'dict', 'admin', '2024-03-17 11:44:17', '', NULL, '字典管理菜单');
INSERT INTO `sys_menu` VALUES (106, '参数设置', 1, 7, 'config', 'system/config/index', '', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 'admin', '2024-03-17 11:44:17', '', NULL, '参数设置菜单');
INSERT INTO `sys_menu` VALUES (107, '通知公告', 1, 8, 'notice', 'system/notice/index', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', '2024-03-17 11:44:17', '', NULL, '通知公告菜单');
INSERT INTO `sys_menu` VALUES (108, '日志管理', 1, 9, 'log', '', '', 1, 0, 'M', '0', '0', '', 'log', 'admin', '2024-03-17 11:44:17', '', NULL, '日志管理菜单');
INSERT INTO `sys_menu` VALUES (109, '在线用户', 2, 1, 'online', 'monitor/online/index', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 'admin', '2024-03-17 11:44:17', '', NULL, '在线用户菜单');
INSERT INTO `sys_menu` VALUES (110, '定时任务', 2, 2, 'job', 'monitor/job/index', '', 1, 0, 'C', '0', '0', 'monitor:job:list', 'job', 'admin', '2024-03-17 11:44:17', '', NULL, '定时任务菜单');
INSERT INTO `sys_menu` VALUES (111, '数据监控', 2, 3, 'druid', 'monitor/druid/index', '', 1, 0, 'C', '0', '0', 'monitor:druid:list', 'druid', 'admin', '2024-03-17 11:44:17', '', NULL, '数据监控菜单');
INSERT INTO `sys_menu` VALUES (112, '服务监控', 2, 4, 'server', 'monitor/server/index', '', 1, 0, 'C', '0', '0', 'monitor:server:list', 'server', 'admin', '2024-03-17 11:44:17', '', NULL, '服务监控菜单');
INSERT INTO `sys_menu` VALUES (113, '缓存监控', 2, 5, 'cache', 'monitor/cache/index', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis', 'admin', '2024-03-17 11:44:17', '', NULL, '缓存监控菜单');
INSERT INTO `sys_menu` VALUES (114, '缓存列表', 2, 6, 'cacheList', 'monitor/cache/list', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis-list', 'admin', '2024-03-17 11:44:17', '', NULL, '缓存列表菜单');
INSERT INTO `sys_menu` VALUES (115, '表单构建', 3, 1, 'build', 'tool/build/index', '', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 'admin', '2024-03-17 11:44:17', '', NULL, '表单构建菜单');
INSERT INTO `sys_menu` VALUES (116, '代码生成', 3, 2, 'gen', 'tool/gen/index', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 'admin', '2024-03-17 11:44:17', '', NULL, '代码生成菜单');
INSERT INTO `sys_menu` VALUES (117, '系统接口', 3, 3, 'swagger', 'tool/swagger/index', '', 1, 0, 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', '2024-03-17 11:44:17', '', NULL, '系统接口菜单');
INSERT INTO `sys_menu` VALUES (500, '操作日志', 108, 1, 'operlog', 'monitor/operlog/index', '', 1, 0, 'C', '0', '0', 'monitor:operlog:list', 'form', 'admin', '2024-03-17 11:44:17', '', NULL, '操作日志菜单');
INSERT INTO `sys_menu` VALUES (501, '登录日志', 108, 2, 'logininfor', 'monitor/logininfor/index', '', 1, 0, 'C', '0', '0', 'monitor:logininfor:list', 'logininfor', 'admin', '2024-03-17 11:44:17', '', NULL, '登录日志菜单');
INSERT INTO `sys_menu` VALUES (1000, '用户查询', 100, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1001, '用户新增', 100, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1002, '用户修改', 100, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1003, '用户删除', 100, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1004, '用户导出', 100, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1005, '用户导入', 100, 6, '', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1006, '重置密码', 100, 7, '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1007, '角色查询', 101, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1008, '角色新增', 101, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1009, '角色修改', 101, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1010, '角色删除', 101, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1011, '角色导出', 101, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1012, '菜单查询', 102, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1013, '菜单新增', 102, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1014, '菜单修改', 102, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1015, '菜单删除', 102, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1016, '部门查询', 103, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1017, '部门新增', 103, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1018, '部门修改', 103, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1019, '部门删除', 103, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1020, '岗位查询', 104, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1021, '岗位新增', 104, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1022, '岗位修改', 104, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1023, '岗位删除', 104, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1024, '岗位导出', 104, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1025, '字典查询', 105, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1026, '字典新增', 105, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1027, '字典修改', 105, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1028, '字典删除', 105, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1029, '字典导出', 105, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1030, '参数查询', 106, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1031, '参数新增', 106, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1032, '参数修改', 106, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1033, '参数删除', 106, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1034, '参数导出', 106, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1035, '公告查询', 107, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1036, '公告新增', 107, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1037, '公告修改', 107, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1038, '公告删除', 107, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1039, '操作查询', 500, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:query', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1040, '操作删除', 500, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:remove', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1041, '日志导出', 500, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:export', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1042, '登录查询', 501, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:query', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1043, '登录删除', 501, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:remove', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1044, '日志导出', 501, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:export', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1045, '账户解锁', 501, 4, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:unlock', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1046, '在线查询', 109, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1047, '批量强退', 109, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1048, '单条强退', 109, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1049, '任务查询', 110, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:query', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1050, '任务新增', 110, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:add', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1051, '任务修改', 110, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:edit', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1052, '任务删除', 110, 4, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:remove', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1053, '状态修改', 110, 5, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1054, '任务导出', 110, 6, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:export', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1055, '生成查询', 116, 1, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1056, '生成修改', 116, 2, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1057, '生成删除', 116, 3, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1058, '导入代码', 116, 4, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1059, '预览代码', 116, 5, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1060, '生成代码', 116, 6, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2000, '校区管理', 1, 0, 'campus', 'system/campus/index', NULL, 1, 0, 'C', '0', '0', 'system:campus:list', 'drag', 'admin', '2024-03-17 15:27:22', 'admin', '2024-04-04 15:05:15', '校区管理菜单');
INSERT INTO `sys_menu` VALUES (2001, '校区管理查询', 2000, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:campus:query', '#', 'admin', '2024-03-17 15:27:22', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2002, '校区管理新增', 2000, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:campus:add', '#', 'admin', '2024-03-17 15:27:22', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2003, '校区管理修改', 2000, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:campus:edit', '#', 'admin', '2024-03-17 15:27:22', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2004, '校区管理删除', 2000, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:campus:remove', '#', 'admin', '2024-03-17 15:27:22', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2005, '校区管理导出', 2000, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:campus:export', '#', 'admin', '2024-03-17 15:27:22', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2006, '参观陪同人员表', 1, 0, 'companion', 'system/companion/index', NULL, 1, 0, 'C', '0', '0', 'system:companion:list', 'documentation', 'admin', '2024-03-17 15:27:22', 'admin', '2024-04-04 15:05:28', '校园参观陪同人员表菜单');
INSERT INTO `sys_menu` VALUES (2007, '校园参观陪同人员表查询', 2006, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:companion:query', '#', 'admin', '2024-03-17 15:27:22', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2008, '校园参观陪同人员表新增', 2006, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:companion:add', '#', 'admin', '2024-03-17 15:27:22', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2009, '校园参观陪同人员表修改', 2006, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:companion:edit', '#', 'admin', '2024-03-17 15:27:22', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2010, '校园参观陪同人员表删除', 2006, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:companion:remove', '#', 'admin', '2024-03-17 15:27:22', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2011, '校园参观陪同人员表导出', 2006, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:companion:export', '#', 'admin', '2024-03-17 15:27:22', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2012, '校园预约表', 1, 0, 'reservation', 'system/reservation/index', NULL, 1, 0, 'C', '0', '0', 'system:reservation:list', 'excel', 'admin', '2024-03-17 15:27:22', 'admin', '2024-04-04 15:05:51', '校园预约表菜单');
INSERT INTO `sys_menu` VALUES (2013, '校园预约表查询', 2012, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:reservation:query', '#', 'admin', '2024-03-17 15:27:22', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2014, '校园预约表新增', 2012, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:reservation:add', '#', 'admin', '2024-03-17 15:27:22', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2015, '校园预约表修改', 2012, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:reservation:edit', '#', 'admin', '2024-03-17 15:27:22', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2016, '校园预约表删除', 2012, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:reservation:remove', '#', 'admin', '2024-03-17 15:27:22', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2017, '校园预约表导出', 2012, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:reservation:export', '#', 'admin', '2024-03-17 15:27:22', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2024, '审核预约列表', 1, 0, 'auditRole', 'system/reservation/auditRole', NULL, 1, 0, 'C', '0', '0', '', 'edit', 'admin', '2024-04-04 11:57:29', 'admin', '2024-04-04 15:06:02', '');
INSERT INTO `sys_menu` VALUES (2025, '预约列表查询', 2024, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:reservation:query', '#', 'admin', '2024-04-04 11:59:49', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2026, '确认预约列表', 1, 0, 'schoolRole', 'system/reservation/schoolRole', NULL, 1, 0, 'C', '0', '0', '', 'example', 'admin', '2024-04-04 12:01:16', 'admin', '2024-04-04 15:06:12', '');
INSERT INTO `sys_menu` VALUES (2027, '预约列表查询', 2026, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:reservation:query', '#', 'admin', '2024-04-04 12:01:46', '', NULL, '');

-- ----------------------------
-- Table structure for sys_notice
-- ----------------------------
DROP TABLE IF EXISTS `sys_notice`;
CREATE TABLE `sys_notice`  (
  `notice_id` int(4) NOT NULL AUTO_INCREMENT COMMENT '公告ID',
  `notice_title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告标题',
  `notice_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告类型（1通知 2公告）',
  `notice_content` longblob NULL COMMENT '公告内容',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`notice_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知公告表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_notice
-- ----------------------------
INSERT INTO `sys_notice` VALUES (1, '温馨提醒：2018-07-01 若依新版本发布啦', '2', 0xE696B0E78988E69CACE58685E5AEB9, '0', 'admin', '2024-03-17 11:44:17', '', NULL, '管理员');
INSERT INTO `sys_notice` VALUES (2, '维护通知：2018-07-01 若依系统凌晨维护', '1', 0xE7BBB4E68AA4E58685E5AEB9, '0', 'admin', '2024-03-17 11:44:17', '', NULL, '管理员');

-- ----------------------------
-- Table structure for sys_oper_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_oper_log`;
CREATE TABLE `sys_oper_log`  (
  `oper_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '模块标题',
  `business_type` int(2) NULL DEFAULT 0 COMMENT '业务类型（0其它 1新增 2修改 3删除）',
  `method` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '方法名称',
  `request_method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '请求方式',
  `operator_type` int(1) NULL DEFAULT 0 COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
  `oper_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作人员',
  `dept_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称',
  `oper_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '请求URL',
  `oper_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '主机地址',
  `oper_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作地点',
  `oper_param` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '请求参数',
  `json_result` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '返回参数',
  `status` int(1) NULL DEFAULT 0 COMMENT '操作状态（0正常 1异常）',
  `error_msg` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '错误消息',
  `oper_time` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
  `cost_time` bigint(20) NULL DEFAULT 0 COMMENT '消耗时间',
  PRIMARY KEY (`oper_id`) USING BTREE,
  INDEX `idx_sys_oper_log_bt`(`business_type`) USING BTREE,
  INDEX `idx_sys_oper_log_s`(`status`) USING BTREE,
  INDEX `idx_sys_oper_log_ot`(`oper_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 205 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '操作日志记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_oper_log
-- ----------------------------
INSERT INTO `sys_oper_log` VALUES (100, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', '研发部门', '/tool/gen/importTable', '127.0.0.1', '内网IP', '{\"tables\":\"cr_user_companion,cr_reservation,cr_campus\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-17 15:01:02', 107);
INSERT INTO `sys_oper_log` VALUES (101, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '研发部门', '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"campus\",\"className\":\"CrCampus\",\"columns\":[{\"capJavaField\":\"CampusId\",\"columnId\":1,\"columnName\":\"campus_id\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isPk\":\"1\",\"isRequired\":\"0\",\"javaField\":\"campusId\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":1,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"CampusName\",\"columnId\":2,\"columnName\":\"campus_name\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"0\",\"javaField\":\"campusName\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"LIKE\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":1,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"CampusDesc\",\"columnId\":3,\"columnName\":\"campus_desc\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"0\",\"javaField\":\"campusDesc\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":1,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"CampusLocation\",\"columnId\":4,\"columnName\":\"campus_location\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"0\",\"javaField\":\"campusLocation\",\"javaType\":\"String\",\"list\"', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-17 15:02:23', 28);
INSERT INTO `sys_oper_log` VALUES (102, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '研发部门', '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"campus\",\"className\":\"CrCampus\",\"columns\":[{\"capJavaField\":\"CampusId\",\"columnId\":1,\"columnName\":\"campus_id\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isPk\":\"1\",\"isRequired\":\"0\",\"javaField\":\"campusId\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":1,\"updateBy\":\"\",\"updateTime\":\"2024-03-17 15:02:23\",\"usableColumn\":false},{\"capJavaField\":\"CampusName\",\"columnId\":2,\"columnName\":\"campus_name\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"0\",\"javaField\":\"campusName\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"LIKE\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":1,\"updateBy\":\"\",\"updateTime\":\"2024-03-17 15:02:23\",\"usableColumn\":false},{\"capJavaField\":\"CampusDesc\",\"columnId\":3,\"columnName\":\"campus_desc\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"0\",\"javaField\":\"campusDesc\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":1,\"updateBy\":\"\",\"updateTime\":\"2024-03-17 15:02:23\",\"usableColumn\":false},{\"capJavaField\":\"CampusLocation\",\"columnId\":4,\"columnName\":\"campus_location\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isLi', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-17 15:02:36', 47);
INSERT INTO `sys_oper_log` VALUES (103, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '研发部门', '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"reservation\",\"className\":\"CrReservation\",\"columns\":[{\"capJavaField\":\"ReservationId\",\"columnComment\":\"主键\",\"columnId\":11,\"columnName\":\"reservation_id\",\"columnType\":\"bigint(20)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isPk\":\"1\",\"isRequired\":\"0\",\"javaField\":\"reservationId\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":2,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"ReservationStatus\",\"columnComment\":\"预约状态，未到参观时间   生效中   已过参观时间\",\"columnId\":12,\"columnName\":\"reservation_status\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"radio\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"0\",\"javaField\":\"reservationStatus\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":2,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"AuditStatus\",\"columnComment\":\"报名状态，报名审核中 报名成功 报名失败\",\"columnId\":13,\"columnName\":\"audit_status\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"radio\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"1\",\"javaField\":\"auditStatus\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":true,\"sort\":3,\"superColumn\":false,\"tableId\":2,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"EntryTime\",\"columnComment\":\"实际入校时间\",\"columnId\":14,\"columnName\":\"entry_time\",\"columnType\":\"datetime\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"datetime\",\"increment\":fals', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-17 15:03:04', 54);
INSERT INTO `sys_oper_log` VALUES (104, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '研发部门', '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"reservation\",\"className\":\"CrReservation\",\"columns\":[{\"capJavaField\":\"ReservationId\",\"columnComment\":\"主键\",\"columnId\":11,\"columnName\":\"reservation_id\",\"columnType\":\"bigint(20)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isPk\":\"1\",\"isRequired\":\"0\",\"javaField\":\"reservationId\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":2,\"updateBy\":\"\",\"updateTime\":\"2024-03-17 15:03:04\",\"usableColumn\":false},{\"capJavaField\":\"ReservationStatus\",\"columnComment\":\"预约状态，未到参观时间   生效中   已过参观时间\",\"columnId\":12,\"columnName\":\"reservation_status\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"radio\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"0\",\"javaField\":\"reservationStatus\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":2,\"updateBy\":\"\",\"updateTime\":\"2024-03-17 15:03:04\",\"usableColumn\":false},{\"capJavaField\":\"AuditStatus\",\"columnComment\":\"报名状态，报名审核中 报名成功 报名失败\",\"columnId\":13,\"columnName\":\"audit_status\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"radio\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"1\",\"javaField\":\"auditStatus\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":true,\"sort\":3,\"superColumn\":false,\"tableId\":2,\"updateBy\":\"\",\"updateTime\":\"2024-03-17 15:03:04\",\"usableColumn\":false},{\"capJavaField\":\"EntryTime\",\"columnComment\":\"实际入校时间\",\"columnId\":14,\"columnName\":\"entry_time\",\"columnType\":\"datetime\",\"createBy\":\"a', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-17 15:03:17', 50);
INSERT INTO `sys_oper_log` VALUES (105, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '研发部门', '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"companion\",\"className\":\"CrUserCompanion\",\"columns\":[{\"capJavaField\":\"UserCompanionId\",\"columnId\":33,\"columnName\":\"user_companion_id\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isPk\":\"1\",\"isRequired\":\"0\",\"javaField\":\"userCompanionId\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":3,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"UserCompanionName\",\"columnComment\":\"陪同人员姓名\",\"columnId\":34,\"columnName\":\"user_companion_name\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"0\",\"javaField\":\"userCompanionName\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"LIKE\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":3,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"UserCompanionPhoneNumber\",\"columnComment\":\"陪同人员手机号\",\"columnId\":35,\"columnName\":\"user_companion_phone_number\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"1\",\"javaField\":\"userCompanionPhoneNumber\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":true,\"sort\":3,\"superColumn\":false,\"tableId\":3,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"UserCompanionIdNumber\",\"columnComment\":\"陪同人员身份证号\",\"columnId\":36,\"columnName\":\"user_companion_id_number\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-17 15:03:49', 38);
INSERT INTO `sys_oper_log` VALUES (106, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.synchDb()', 'GET', 1, 'admin', '研发部门', '/tool/gen/synchDb/cr_user_companion', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-17 15:04:44', 42);
INSERT INTO `sys_oper_log` VALUES (107, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.synchDb()', 'GET', 1, 'admin', '研发部门', '/tool/gen/synchDb/cr_user_companion', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-17 15:05:01', 37);
INSERT INTO `sys_oper_log` VALUES (108, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', '研发部门', '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"cr_campus,cr_reservation,cr_user_companion\"}', NULL, 0, NULL, '2024-03-17 15:05:04', 75);
INSERT INTO `sys_oper_log` VALUES (109, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '研发部门', '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"campus\",\"className\":\"CrCampus\",\"columns\":[{\"capJavaField\":\"CampusId\",\"columnComment\":\"校区id\",\"columnId\":1,\"columnName\":\"campus_id\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isPk\":\"1\",\"isRequired\":\"0\",\"javaField\":\"campusId\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":1,\"updateBy\":\"\",\"updateTime\":\"2024-03-17 15:02:36\",\"usableColumn\":false},{\"capJavaField\":\"CampusName\",\"columnComment\":\"校区name\",\"columnId\":2,\"columnName\":\"campus_name\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"0\",\"javaField\":\"campusName\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"LIKE\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":1,\"updateBy\":\"\",\"updateTime\":\"2024-03-17 15:02:36\",\"usableColumn\":false},{\"capJavaField\":\"CampusDesc\",\"columnComment\":\"校区desc\",\"columnId\":3,\"columnName\":\"campus_desc\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"0\",\"javaField\":\"campusDesc\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":1,\"updateBy\":\"\",\"updateTime\":\"2024-03-17 15:02:36\",\"usableColumn\":false},{\"capJavaField\":\"CampusLocation\",\"columnComment\":\"校区location\",\"columnId\":4,\"columnName\":\"campus_location\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-17 15:28:38', 51);
INSERT INTO `sys_oper_log` VALUES (110, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', '研发部门', '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"cr_campus\"}', NULL, 0, NULL, '2024-03-17 15:28:47', 105);
INSERT INTO `sys_oper_log` VALUES (111, '校区管理', 1, 'com.ruoyi.web.controller.system.CrCampusController.add()', 'POST', 1, 'admin', '研发部门', '/system/campus', '127.0.0.1', '内网IP', '{\"campusDesc\":\"11\",\"campusId\":1,\"campusLocation\":\"粤海校区\",\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-17 15:31:10\",\"params\":{},\"remark\":\"111\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-17 15:31:10', 15);
INSERT INTO `sys_oper_log` VALUES (112, '校区管理', 1, 'com.ruoyi.web.controller.system.CrCampusController.add()', 'POST', 1, 'admin', '研发部门', '/system/campus', '127.0.0.1', '内网IP', '{\"campusDesc\":\"丽湖小区\",\"campusId\":2,\"campusLocation\":\"222\",\"campusName\":\"丽湖小区\",\"createTime\":\"2024-03-17 15:31:29\",\"params\":{},\"remark\":\"222\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-17 15:31:29', 17);
INSERT INTO `sys_oper_log` VALUES (113, '校区管理', 2, 'com.ruoyi.web.controller.system.CrCampusController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/campus', '127.0.0.1', '内网IP', '{\"campusDesc\":\"粤海校区\",\"campusId\":1,\"campusLocation\":\"粤海校区\",\"campusName\":\"粤海校区\",\"createBy\":\"\",\"createTime\":\"2024-03-17 15:31:10\",\"delFlag\":\"0\",\"params\":{},\"remark\":\"111\",\"updateBy\":\"\",\"updateTime\":\"2024-03-17 15:31:41\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-17 15:31:41', 8);
INSERT INTO `sys_oper_log` VALUES (114, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.synchDb()', 'GET', 1, 'admin', '研发部门', '/tool/gen/synchDb/cr_reservation', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-17 16:04:49', 118);
INSERT INTO `sys_oper_log` VALUES (115, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '研发部门', '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"reservation\",\"className\":\"CrReservation\",\"columns\":[{\"capJavaField\":\"ReservationId\",\"columnComment\":\"主键\",\"columnId\":11,\"columnName\":\"reservation_id\",\"columnType\":\"bigint(20)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":false,\"isIncrement\":\"1\",\"isInsert\":\"0\",\"isPk\":\"1\",\"isRequired\":\"0\",\"javaField\":\"reservationId\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":2,\"updateBy\":\"\",\"updateTime\":\"2024-03-17 16:04:49\",\"usableColumn\":false},{\"capJavaField\":\"ReservationStatus\",\"columnComment\":\"预约状态，（0未到参观时间  1生效中  2已过参观时间 3已取消）\",\"columnId\":12,\"columnName\":\"reservation_status\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"radio\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"0\",\"javaField\":\"reservationStatus\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":2,\"updateBy\":\"\",\"updateTime\":\"2024-03-17 16:04:49\",\"usableColumn\":false},{\"capJavaField\":\"AuditStatus\",\"columnComment\":\"报名状态，（0报名审核中 2报名成功 3报名失败）\",\"columnId\":13,\"columnName\":\"audit_status\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 15:01:02\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"radio\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"1\",\"javaField\":\"auditStatus\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":true,\"sort\":3,\"superColumn\":false,\"tableId\":2,\"updateBy\":\"\",\"updateTime\":\"2024-03-17 16:04:49\",\"usableColumn\":false},{\"capJavaField\":\"EntryTime\",\"columnComment\":\"实际入校时间\",\"columnId\":14,\"columnName\":\"entry_time\",\"columnType\":\"datetime\"', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-17 16:05:41', 58);
INSERT INTO `sys_oper_log` VALUES (116, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', '研发部门', '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"cr_reservation\"}', NULL, 0, NULL, '2024-03-17 16:05:50', 108);
INSERT INTO `sys_oper_log` VALUES (117, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.synchDb()', 'GET', 1, 'admin', '研发部门', '/tool/gen/synchDb/cr_reservation', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-17 17:12:41', 132);
INSERT INTO `sys_oper_log` VALUES (118, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'admin', '研发部门', '/system/reservation', '127.0.0.1', '内网IP', '{\"params\":{}}', NULL, 1, '', '2024-03-23 11:05:54', 5);
INSERT INTO `sys_oper_log` VALUES (119, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'admin', '研发部门', '/system/reservation', '127.0.0.1', '内网IP', '{\"params\":{}}', NULL, 1, '', '2024-03-23 11:06:35', 0);
INSERT INTO `sys_oper_log` VALUES (120, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'admin', '研发部门', '/system/reservation', '127.0.0.1', '内网IP', '{\"params\":{}}', '{\"msg\":\"预约日期不能为空\",\"code\":500}', 0, NULL, '2024-03-23 11:12:30', 7);
INSERT INTO `sys_oper_log` VALUES (121, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'admin', '研发部门', '/system/reservation', '127.0.0.1', '内网IP', '{\"campusId\":1,\"campusName\":\"3125\",\"params\":{},\"reservationDate\":\"2024-03-22 00:00:00\",\"userCompanion\":\"\",\"userIdNumber\":\"13245662543\",\"userName\":\"111\",\"userPhoneNumber\":\"22222222\"}', '{\"msg\":\"当前时间段无法预约当天参观\",\"code\":500}', 0, NULL, '2024-03-23 11:13:40', 0);
INSERT INTO `sys_oper_log` VALUES (122, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'admin', '研发部门', '/system/reservation', '127.0.0.1', '内网IP', '{\"campusId\":1,\"campusName\":\"3125\",\"params\":{},\"reservationDate\":\"2024-03-23 08:00:00\",\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userId\":1,\"userIdNumber\":\"13245662543\",\"userName\":\"111\",\"userPhoneNumber\":\"22222222\"}', NULL, 1, '', '2024-03-23 11:19:22', 7);
INSERT INTO `sys_oper_log` VALUES (123, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'admin', '研发部门', '/system/reservation', '127.0.0.1', '内网IP', '{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-23 11:33:23\",\"params\":{},\"reservationDate\":\"2024-03-23 08:00:00\",\"reservationStatus\":\"1\",\"userCompanion\":\"开发区1,开发区2\",\"userCompanionList\":[{\"params\":{},\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"开发区1\",\"userCompanionPhoneNumber\":\"2345364636\"},{\"params\":{},\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"开发区2\",\"userCompanionPhoneNumber\":\"2345364636\"}],\"userIdNumber\":\"13245662543\",\"userName\":\"111\",\"userPhoneNumber\":\"22222222\"}', NULL, 1, '\r\n### Error updating database.  Cause: java.sql.SQLException: Field \'user_id\' doesn\'t have a default value\r\n### The error may exist in file [D:\\project\\code\\campus-reservation\\ruoyi-system\\target\\classes\\mapper\\system\\CrReservationMapper.xml]\r\n### The error may involve com.ruoyi.system.mapper.CrReservationMapper.insertCrReservation-Inline\r\n### The error occurred while setting parameters\r\n### SQL: insert into cr_reservation          ( reservation_status,                                                                                                                     user_name,             user_phone_number,             user_id_number,             campus_id,             campus_name,             reservation_date,             user_companion,                                       create_time )           values ( ?,                                                                                                                     ?,             ?,             ?,             ?,             ?,             ?,             ?,                                       ? )\r\n### Cause: java.sql.SQLException: Field \'user_id\' doesn\'t have a default value\n; Field \'user_id\' doesn\'t have a default value; nested exception is java.sql.SQLException: Field \'user_id\' doesn\'t have a default value', '2024-03-23 11:33:23', 55);
INSERT INTO `sys_oper_log` VALUES (124, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'admin', '研发部门', '/system/reservation', '127.0.0.1', '内网IP', '{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-23 11:34:52\",\"params\":{},\"reservationDate\":\"2024-03-23 08:00:00\",\"reservationId\":1,\"reservationStatus\":\"1\",\"userCompanion\":\"开发区1,开发区2\",\"userCompanionList\":[{\"createTime\":\"2024-03-23 11:34:52\",\"params\":{},\"reservationId\":1,\"userCompanionId\":1,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"开发区1\",\"userCompanionPhoneNumber\":\"2345364636\"},{\"createTime\":\"2024-03-23 11:34:52\",\"params\":{},\"reservationId\":1,\"userCompanionId\":2,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"开发区2\",\"userCompanionPhoneNumber\":\"2345364636\"}],\"userId\":1,\"userIdNumber\":\"13245662543\",\"userName\":\"111\",\"userPhoneNumber\":\"22222222\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-23 11:34:52', 40);
INSERT INTO `sys_oper_log` VALUES (125, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'admin', '研发部门', '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-23 14:05:18\",\"params\":{},\"reservationDate\":\"2024-03-23 08:00:00\",\"reservationId\":2,\"reservationStatus\":\"1\",\"userCompanion\":\"22221,222222\",\"userCompanionList\":[{\"createTime\":\"2024-03-23 14:05:18\",\"params\":{},\"reservationId\":2,\"userCompanionId\":3,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"22221\",\"userCompanionPhoneNumber\":\"2345364636\"},{\"createTime\":\"2024-03-23 14:05:18\",\"params\":{},\"reservationId\":2,\"userCompanionId\":4,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"222222\",\"userCompanionPhoneNumber\":\"2345364636\"}],\"userId\":1,\"userIdNumber\":\"1324522662543\",\"userName\":\"2222\",\"userPhoneNumber\":\"22222222222\"},{\"campusId\":1,\"campusName\":\"丽湖校区\",\"createTime\":\"2024-03-23 14:05:18\",\"params\":{},\"reservationDate\":\"2024-03-23 08:00:00\",\"reservationId\":3,\"reservationStatus\":\"1\",\"userCompanion\":\"3331,3332\",\"userCompanionList\":[{\"createTime\":\"2024-03-23 14:05:18\",\"params\":{},\"reservationId\":3,\"userCompanionId\":5,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"3331\",\"userCompanionPhoneNumber\":\"2345364636\"},{\"createTime\":\"2024-03-23 14:05:18\",\"params\":{},\"reservationId\":3,\"userCompanionId\":6,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"3332\",\"userCompanionPhoneNumber\":\"2345364636\"}],\"userId\":1,\"userIdNumber\":\"13245622262543\",\"userName\":\"33333\",\"userPhoneNumber\":\"222223333222\"}]', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-23 14:05:18', 80);
INSERT INTO `sys_oper_log` VALUES (126, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'admin', '研发部门', '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-23 15:31:06\",\"params\":{},\"reservationDate\":\"2024-03-23 08:05:11\",\"reservationId\":4,\"reservationStatus\":\"1\",\"userCompanion\":\"22221,222222\",\"userCompanionList\":[{\"createTime\":\"2024-03-23 15:31:06\",\"params\":{},\"reservationId\":4,\"userCompanionId\":7,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"22221\",\"userCompanionPhoneNumber\":\"2345364636\"},{\"createTime\":\"2024-03-23 15:31:06\",\"params\":{},\"reservationId\":4,\"userCompanionId\":8,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"222222\",\"userCompanionPhoneNumber\":\"2345364636\"}],\"userId\":1,\"userIdNumber\":\"1324522662543\",\"userName\":\"2222\",\"userPhoneNumber\":\"22222222222\"},{\"campusId\":1,\"campusName\":\"丽湖校区\",\"createTime\":\"2024-03-23 15:31:06\",\"params\":{},\"reservationDate\":\"2024-03-23 08:00:00\",\"reservationId\":5,\"reservationStatus\":\"1\",\"userCompanion\":\"3331,3332\",\"userCompanionList\":[{\"createTime\":\"2024-03-23 15:31:06\",\"params\":{},\"reservationId\":5,\"userCompanionId\":9,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"3331\",\"userCompanionPhoneNumber\":\"2345364636\"},{\"createTime\":\"2024-03-23 15:31:06\",\"params\":{},\"reservationId\":5,\"userCompanionId\":10,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"3332\",\"userCompanionPhoneNumber\":\"2345364636\"}],\"userId\":1,\"userIdNumber\":\"13245622262543\",\"userName\":\"33333\",\"userPhoneNumber\":\"222223333222\"}]', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-23 15:31:06', 74);
INSERT INTO `sys_oper_log` VALUES (127, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.synchDb()', 'GET', 1, 'admin', '研发部门', '/tool/gen/synchDb/cr_campus', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-23 15:37:55', 68);
INSERT INTO `sys_oper_log` VALUES (128, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', '研发部门', '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"cr_campus\"}', NULL, 0, NULL, '2024-03-23 15:38:02', 167);
INSERT INTO `sys_oper_log` VALUES (129, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 10:28:14\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":14,\"reservationStatus\":\"1\",\"userCompanion\":\"112312\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 10:28:14\",\"params\":{},\"reservationId\":14,\"userCompanionId\":23,\"userCompanionIdNumber\":\"213123\",\"userCompanionName\":\"112312\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"李刚（数字日照）\",\"userPhoneNumber\":\"123123\"}]', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-24 10:28:14', 48);
INSERT INTO `sys_oper_log` VALUES (130, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 10:35:05\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":15,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"李刚（数字日照）\",\"userPhoneNumber\":\"123123\"}]', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-24 10:35:05', 17);
INSERT INTO `sys_oper_log` VALUES (131, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 10:38:30\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":16,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123123\",\"userName\":\"szrz\",\"userPhoneNumber\":\"123123\"}]', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-24 10:38:30', 12);
INSERT INTO `sys_oper_log` VALUES (132, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 10:39:09\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":17,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"admin\",\"userPhoneNumber\":\"23123\"}]', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-24 10:39:09', 14);
INSERT INTO `sys_oper_log` VALUES (133, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 10:39:59\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":18,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"admin\",\"userPhoneNumber\":\"asdasd\"}]', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-24 10:39:59', 16);
INSERT INTO `sys_oper_log` VALUES (134, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 10:40:54\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":19,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"ruoyi\",\"userPhoneNumber\":\"213123\"}]', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-24 10:40:54', 9);
INSERT INTO `sys_oper_log` VALUES (135, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 10:41:52\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":20,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"1231231\",\"userName\":\"root\",\"userPhoneNumber\":\"123123\"}]', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-24 10:41:52', 9);
INSERT INTO `sys_oper_log` VALUES (136, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 10:42:22\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":21,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"szrz\",\"userPhoneNumber\":\"123123\"}]', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-24 10:42:22', 16);
INSERT INTO `sys_oper_log` VALUES (137, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 10:43:46\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":22,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"root\",\"userPhoneNumber\":\"123123\"}]', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-24 10:43:46', 10);
INSERT INTO `sys_oper_log` VALUES (138, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 11:07:24\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":23,\"reservationStatus\":\"0\",\"userCompanion\":\"ligao\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 11:07:24\",\"params\":{},\"reservationId\":23,\"userCompanionId\":24,\"userCompanionIdNumber\":\"12312312\",\"userCompanionName\":\"ligao\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":101,\"userIdNumber\":\"1231231\",\"userName\":\"marui\",\"userPhoneNumber\":\"123123\"},{\"campusId\":2,\"campusName\":\"丽湖小区\",\"createTime\":\"2024-03-24 11:07:24\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":24,\"reservationStatus\":\"1\",\"userCompanion\":\"ligao\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 11:07:24\",\"params\":{},\"reservationId\":24,\"userCompanionId\":25,\"userCompanionIdNumber\":\"12312312\",\"userCompanionName\":\"ligao\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":101,\"userIdNumber\":\"1231231\",\"userName\":\"marui\",\"userPhoneNumber\":\"123123\"}]', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-24 11:07:24', 41);
INSERT INTO `sys_oper_log` VALUES (139, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 11:39:42\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":25,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"szrz\",\"userPhoneNumber\":\"123123\"}]', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-24 11:39:42', 20);
INSERT INTO `sys_oper_log` VALUES (140, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, '123', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:10:08\",\"params\":{},\"reservationDate\":\"2024-03-24 08:05:11\",\"reservationId\":27,\"reservationStatus\":\"1\",\"userCompanion\":\"22221,222222\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 13:10:08\",\"params\":{},\"reservationId\":27,\"userCompanionId\":26,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"22221\",\"userCompanionPhoneNumber\":\"2345364636\"},{\"createTime\":\"2024-03-24 13:10:08\",\"params\":{},\"reservationId\":27,\"userCompanionId\":27,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"222222\",\"userCompanionPhoneNumber\":\"2345364636\"}],\"userId\":100,\"userIdNumber\":\"1324522662543\",\"userName\":\"2222\",\"userPhoneNumber\":\"22222222222\"},{\"campusId\":2,\"campusName\":\"丽湖校区\",\"createTime\":\"2024-03-24 13:10:08\",\"params\":{},\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":28,\"reservationStatus\":\"1\",\"userCompanion\":\"3331,3332\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 13:10:08\",\"params\":{},\"reservationId\":28,\"userCompanionId\":28,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"3331\",\"userCompanionPhoneNumber\":\"2345364636\"},{\"createTime\":\"2024-03-24 13:10:08\",\"params\":{},\"reservationId\":28,\"userCompanionId\":29,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"3332\",\"userCompanionPhoneNumber\":\"2345364636\"}],\"userId\":100,\"userIdNumber\":\"13245622262543\",\"userName\":\"33333\",\"userPhoneNumber\":\"222223333222\"}]', '{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:10:08\",\"params\":{},\"reservationDate\":\"2024-03-24 08:05:11\",\"reservationId\":27,\"reservationStatus\":\"1\",\"userCompanion\":\"22221,222222\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 13:10:08\",\"params\":{},\"reservationId\":27,\"userCompanionId\":26,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"22221\",\"userCompanionPhoneNumber\":\"2345364636\"},{\"createTime\":\"2024-03-24 13:10:08\",\"params\":{},\"reservationId\":27,\"userCompanionId\":27,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"222222\",\"userCompanionPhoneNumber\":\"2345364636\"}],\"userId\":100,\"userIdNumber\":\"1324522662543\",\"userName\":\"2222\",\"userPhoneNumber\":\"22222222222\"},{\"campusId\":2,\"campusName\":\"丽湖校区\",\"createTime\":\"2024-03-24 13:10:08\",\"params\":{},\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":28,\"reservationStatus\":\"1\",\"userCompanion\":\"3331,3332\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 13:10:08\",\"params\":{},\"reservationId\":28,\"userCompanionId\":28,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"3331\",\"userCompanionPhoneNumber\":\"2345364636\"},{\"createTime\":\"2024-03-24 13:10:08\",\"params\":{},\"reservationId\":28,\"userCompanionId\":29,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"3332\",\"userCompanionPhoneNumber\":\"2345364636\"}],\"userId\":100,\"userIdNumber\":\"13245622262543\",\"userName\":\"33333\",\"userPhoneNumber\":\"222223333222\"}]}', 0, NULL, '2024-03-24 13:10:08', 86);
INSERT INTO `sys_oper_log` VALUES (141, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:41:05\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":29,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"12312312\",\"userName\":\"admin\",\"userPhoneNumber\":\"123123\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:41:05\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":30,\"reservationStatus\":\"0\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"12312312\",\"userName\":\"admin\",\"userPhoneNumber\":\"123123\"}]', '{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:41:05\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":29,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"12312312\",\"userName\":\"admin\",\"userPhoneNumber\":\"123123\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:41:05\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":30,\"reservationStatus\":\"0\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"12312312\",\"userName\":\"admin\",\"userPhoneNumber\":\"123123\"}]}', 0, NULL, '2024-03-24 13:41:05', 52);
INSERT INTO `sys_oper_log` VALUES (142, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:42:11\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":31,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123123\",\"userName\":\"root\",\"userPhoneNumber\":\"1231231\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:42:11\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":32,\"reservationStatus\":\"0\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123123\",\"userName\":\"root\",\"userPhoneNumber\":\"1231231\"}]', '{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:42:11\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":31,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123123\",\"userName\":\"root\",\"userPhoneNumber\":\"1231231\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:42:11\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":32,\"reservationStatus\":\"0\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123123\",\"userName\":\"root\",\"userPhoneNumber\":\"1231231\"}]}', 0, NULL, '2024-03-24 13:42:11', 36);
INSERT INTO `sys_oper_log` VALUES (143, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:46:17\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":33,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"szrz\",\"userPhoneNumber\":\"213123123\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:46:17\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":34,\"reservationStatus\":\"0\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"szrz\",\"userPhoneNumber\":\"213123123\"}]', '{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:46:17\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":33,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"szrz\",\"userPhoneNumber\":\"213123123\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:46:17\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":34,\"reservationStatus\":\"0\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"szrz\",\"userPhoneNumber\":\"213123123\"}]}', 0, NULL, '2024-03-24 13:46:17', 36);
INSERT INTO `sys_oper_log` VALUES (144, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:50:17\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":35,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"root\",\"userPhoneNumber\":\"123123\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:50:17\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":36,\"reservationStatus\":\"0\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"root\",\"userPhoneNumber\":\"123123\"}]', '{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:50:17\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":35,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"root\",\"userPhoneNumber\":\"123123\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:50:17\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":36,\"reservationStatus\":\"0\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"root\",\"userPhoneNumber\":\"123123\"}]}', 0, NULL, '2024-03-24 13:50:17', 23);
INSERT INTO `sys_oper_log` VALUES (145, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:50:48\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":37,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"admin\",\"userPhoneNumber\":\"12312312\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:50:48\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":38,\"reservationStatus\":\"0\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"admin\",\"userPhoneNumber\":\"12312312\"}]', '{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:50:48\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":37,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"admin\",\"userPhoneNumber\":\"12312312\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 13:50:48\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":38,\"reservationStatus\":\"0\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"admin\",\"userPhoneNumber\":\"12312312\"}]}', 0, NULL, '2024-03-24 13:50:48', 22);
INSERT INTO `sys_oper_log` VALUES (146, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 14:21:14\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":39,\"reservationStatus\":\"1\",\"userCompanion\":\"marui\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 14:21:14\",\"params\":{},\"reservationId\":39,\"userCompanionId\":30,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"marui\",\"userCompanionPhoneNumber\":\"123123123\"}],\"userId\":101,\"userIdNumber\":\"123123123\",\"userName\":\"李刚（数字日照）\",\"userPhoneNumber\":\"123123123\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 14:21:14\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":40,\"reservationStatus\":\"0\",\"userCompanion\":\"marui\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 14:21:14\",\"params\":{},\"reservationId\":40,\"userCompanionId\":31,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"marui\",\"userCompanionPhoneNumber\":\"123123123\"}],\"userId\":101,\"userIdNumber\":\"123123123\",\"userName\":\"李刚（数字日照）\",\"userPhoneNumber\":\"123123123\"}]', '{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 14:21:14\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":39,\"reservationStatus\":\"1\",\"userCompanion\":\"marui\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 14:21:14\",\"params\":{},\"reservationId\":39,\"userCompanionId\":30,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"marui\",\"userCompanionPhoneNumber\":\"123123123\"}],\"userId\":101,\"userIdNumber\":\"123123123\",\"userName\":\"李刚（数字日照）\",\"userPhoneNumber\":\"123123123\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 14:21:14\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":40,\"reservationStatus\":\"0\",\"userCompanion\":\"marui\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 14:21:14\",\"params\":{},\"reservationId\":40,\"userCompanionId\":31,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"marui\",\"userCompanionPhoneNumber\":\"123123123\"}],\"userId\":101,\"userIdNumber\":\"123123123\",\"userName\":\"李刚（数字日照）\",\"userPhoneNumber\":\"123123123\"}]}', 0, NULL, '2024-03-24 14:21:14', 49);
INSERT INTO `sys_oper_log` VALUES (147, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, '123123', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 14:24:08\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":41,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":102,\"userIdNumber\":\"123123123\",\"userName\":\"marui\",\"userPhoneNumber\":\"123123\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 14:24:08\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":42,\"reservationStatus\":\"0\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":102,\"userIdNumber\":\"123123123\",\"userName\":\"marui\",\"userPhoneNumber\":\"123123\"}]', '{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 14:24:08\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":41,\"reservationStatus\":\"1\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":102,\"userIdNumber\":\"123123123\",\"userName\":\"marui\",\"userPhoneNumber\":\"123123\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 14:24:08\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":42,\"reservationStatus\":\"0\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":102,\"userIdNumber\":\"123123123\",\"userName\":\"marui\",\"userPhoneNumber\":\"123123\"}]}', 0, NULL, '2024-03-24 14:24:08', 30);
INSERT INTO `sys_oper_log` VALUES (148, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, '123', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 14:32:06\",\"params\":{},\"reservationDate\":\"2024-03-24 08:05:11\",\"reservationId\":43,\"reservationStatus\":\"1\",\"userCompanion\":\"22221,222222\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 14:32:06\",\"params\":{},\"reservationId\":43,\"userCompanionId\":32,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"22221\",\"userCompanionPhoneNumber\":\"2345364636\"},{\"createTime\":\"2024-03-24 14:32:06\",\"params\":{},\"reservationId\":43,\"userCompanionId\":33,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"222222\",\"userCompanionPhoneNumber\":\"2345364636\"}],\"userId\":100,\"userIdNumber\":\"1324522662543\",\"userName\":\"2222\",\"userPhoneNumber\":\"22222222222\"},{\"campusId\":2,\"campusName\":\"丽湖校区\",\"createTime\":\"2024-03-24 14:32:06\",\"params\":{},\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":44,\"reservationStatus\":\"1\",\"userCompanion\":\"3331,3332\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 14:32:06\",\"params\":{},\"reservationId\":44,\"userCompanionId\":34,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"3331\",\"userCompanionPhoneNumber\":\"2345364636\"},{\"createTime\":\"2024-03-24 14:32:06\",\"params\":{},\"reservationId\":44,\"userCompanionId\":35,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"3332\",\"userCompanionPhoneNumber\":\"2345364636\"}],\"userId\":100,\"userIdNumber\":\"13245622262543\",\"userName\":\"33333\",\"userPhoneNumber\":\"222223333222\"}]', '{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 14:32:06\",\"params\":{},\"reservationDate\":\"2024-03-24 08:05:11\",\"reservationId\":43,\"reservationStatus\":\"1\",\"userCompanion\":\"22221,222222\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 14:32:06\",\"params\":{},\"reservationId\":43,\"userCompanionId\":32,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"22221\",\"userCompanionPhoneNumber\":\"2345364636\"},{\"createTime\":\"2024-03-24 14:32:06\",\"params\":{},\"reservationId\":43,\"userCompanionId\":33,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"222222\",\"userCompanionPhoneNumber\":\"2345364636\"}],\"userId\":100,\"userIdNumber\":\"1324522662543\",\"userName\":\"2222\",\"userPhoneNumber\":\"22222222222\"},{\"campusId\":2,\"campusName\":\"丽湖校区\",\"createTime\":\"2024-03-24 14:32:06\",\"params\":{},\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":44,\"reservationStatus\":\"1\",\"userCompanion\":\"3331,3332\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 14:32:06\",\"params\":{},\"reservationId\":44,\"userCompanionId\":34,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"3331\",\"userCompanionPhoneNumber\":\"2345364636\"},{\"createTime\":\"2024-03-24 14:32:06\",\"params\":{},\"reservationId\":44,\"userCompanionId\":35,\"userCompanionIdNumber\":\"45676543\",\"userCompanionName\":\"3332\",\"userCompanionPhoneNumber\":\"2345364636\"}],\"userId\":100,\"userIdNumber\":\"13245622262543\",\"userName\":\"33333\",\"userPhoneNumber\":\"222223333222\"}]}', 0, NULL, '2024-03-24 14:32:06', 134);
INSERT INTO `sys_oper_log` VALUES (149, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, '123123', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 14:33:44\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":45,\"reservationStatus\":\"1\",\"userCompanion\":\"sdaasda\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 14:33:44\",\"params\":{},\"reservationId\":45,\"userCompanionId\":36,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"sdaasda\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":102,\"userIdNumber\":\"123123123\",\"userName\":\"root\",\"userPhoneNumber\":\"123123123\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 14:33:44\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":46,\"reservationStatus\":\"0\",\"userCompanion\":\"sdaasda\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 14:33:44\",\"params\":{},\"reservationId\":46,\"userCompanionId\":37,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"sdaasda\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":102,\"userIdNumber\":\"123123123\",\"userName\":\"root\",\"userPhoneNumber\":\"123123123\"}]', '{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 14:33:44\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":45,\"reservationStatus\":\"1\",\"userCompanion\":\"sdaasda\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 14:33:44\",\"params\":{},\"reservationId\":45,\"userCompanionId\":36,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"sdaasda\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":102,\"userIdNumber\":\"123123123\",\"userName\":\"root\",\"userPhoneNumber\":\"123123123\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 14:33:44\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":46,\"reservationStatus\":\"0\",\"userCompanion\":\"sdaasda\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 14:33:44\",\"params\":{},\"reservationId\":46,\"userCompanionId\":37,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"sdaasda\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":102,\"userIdNumber\":\"123123123\",\"userName\":\"root\",\"userPhoneNumber\":\"123123123\"}]}', 0, NULL, '2024-03-24 14:33:44', 37);
INSERT INTO `sys_oper_log` VALUES (150, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, '123123', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":2,\"campusName\":\"丽湖小区\",\"createTime\":\"2024-03-24 14:53:38\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":47,\"reservationStatus\":\"0\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":102,\"userIdNumber\":\"123123\",\"userName\":\"手动阀手动阀\",\"userPhoneNumber\":\"123123\"}]', '{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"campusId\":2,\"campusName\":\"丽湖小区\",\"createTime\":\"2024-03-24 14:53:38\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":47,\"reservationStatus\":\"0\",\"userCompanion\":\"\",\"userCompanionList\":[],\"userId\":102,\"userIdNumber\":\"123123\",\"userName\":\"手动阀手动阀\",\"userPhoneNumber\":\"123123\"}]}', 0, NULL, '2024-03-24 14:53:38', 22);
INSERT INTO `sys_oper_log` VALUES (151, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, '123123', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":2,\"campusName\":\"丽湖小区\",\"createTime\":\"2024-03-24 15:02:22\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":48,\"reservationStatus\":\"0\",\"userCompanion\":\"123123\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 15:02:22\",\"params\":{},\"reservationId\":48,\"userCompanionId\":38,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"123123\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":102,\"userIdNumber\":\"123123123\",\"userName\":\"marui\",\"userPhoneNumber\":\"123123\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 15:02:22\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":49,\"reservationStatus\":\"1\",\"userCompanion\":\"123123\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 15:02:22\",\"params\":{},\"reservationId\":49,\"userCompanionId\":39,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"123123\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":102,\"userIdNumber\":\"123123123\",\"userName\":\"marui\",\"userPhoneNumber\":\"123123\"}]', '{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"campusId\":2,\"campusName\":\"丽湖小区\",\"createTime\":\"2024-03-24 15:02:22\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":48,\"reservationStatus\":\"0\",\"userCompanion\":\"123123\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 15:02:22\",\"params\":{},\"reservationId\":48,\"userCompanionId\":38,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"123123\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":102,\"userIdNumber\":\"123123123\",\"userName\":\"marui\",\"userPhoneNumber\":\"123123\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 15:02:22\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":49,\"reservationStatus\":\"1\",\"userCompanion\":\"123123\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 15:02:22\",\"params\":{},\"reservationId\":49,\"userCompanionId\":39,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"123123\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":102,\"userIdNumber\":\"123123123\",\"userName\":\"marui\",\"userPhoneNumber\":\"123123\"}]}', 0, NULL, '2024-03-24 15:02:22', 36);
INSERT INTO `sys_oper_log` VALUES (152, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, '123123', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":2,\"campusName\":\"丽湖小区\",\"createTime\":\"2024-03-24 15:17:54\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":50,\"reservationStatus\":\"1\",\"userCompanion\":\"强强强强\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 15:17:54\",\"params\":{},\"reservationId\":50,\"userCompanionId\":40,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"强强强强\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":102,\"userIdNumber\":\"123123123\",\"userName\":\"marui\",\"userPhoneNumber\":\"123123\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 15:17:54\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":51,\"reservationStatus\":\"0\",\"userCompanion\":\"强强强强\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 15:17:54\",\"params\":{},\"reservationId\":51,\"userCompanionId\":41,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"强强强强\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":102,\"userIdNumber\":\"123123123\",\"userName\":\"marui\",\"userPhoneNumber\":\"123123\"}]', '{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"campusId\":2,\"campusName\":\"丽湖小区\",\"createTime\":\"2024-03-24 15:17:54\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":50,\"reservationStatus\":\"1\",\"userCompanion\":\"强强强强\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 15:17:54\",\"params\":{},\"reservationId\":50,\"userCompanionId\":40,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"强强强强\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":102,\"userIdNumber\":\"123123123\",\"userName\":\"marui\",\"userPhoneNumber\":\"123123\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 15:17:54\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":51,\"reservationStatus\":\"0\",\"userCompanion\":\"强强强强\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 15:17:54\",\"params\":{},\"reservationId\":51,\"userCompanionId\":41,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"强强强强\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":102,\"userIdNumber\":\"123123123\",\"userName\":\"marui\",\"userPhoneNumber\":\"123123\"}]}', 0, NULL, '2024-03-24 15:17:54', 42);
INSERT INTO `sys_oper_log` VALUES (153, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, '123123', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 15:27:51\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":52,\"reservationStatus\":\"1\",\"userCompanion\":\"qwer,df\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 15:27:51\",\"params\":{},\"reservationId\":52,\"userCompanionId\":42,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"qwer\",\"userCompanionPhoneNumber\":\"123123\"},{\"createTime\":\"2024-03-24 15:27:51\",\"params\":{},\"reservationId\":52,\"userCompanionId\":43,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"df\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":102,\"userIdNumber\":\"123123\",\"userName\":\"312312\",\"userPhoneNumber\":\"123123\"},{\"campusId\":2,\"campusName\":\"丽湖小区\",\"createTime\":\"2024-03-24 15:27:51\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":53,\"reservationStatus\":\"0\",\"userCompanion\":\"qwer,df\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 15:27:51\",\"params\":{},\"reservationId\":53,\"userCompanionId\":44,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"qwer\",\"userCompanionPhoneNumber\":\"123123\"},{\"createTime\":\"2024-03-24 15:27:51\",\"params\":{},\"reservationId\":53,\"userCompanionId\":45,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"df\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":102,\"userIdNumber\":\"123123\",\"userName\":\"312312\",\"userPhoneNumber\":\"123123\"}]', '{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 15:27:51\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"reservationId\":52,\"reservationStatus\":\"1\",\"userCompanion\":\"qwer,df\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 15:27:51\",\"params\":{},\"reservationId\":52,\"userCompanionId\":42,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"qwer\",\"userCompanionPhoneNumber\":\"123123\"},{\"createTime\":\"2024-03-24 15:27:51\",\"params\":{},\"reservationId\":52,\"userCompanionId\":43,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"df\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":102,\"userIdNumber\":\"123123\",\"userName\":\"312312\",\"userPhoneNumber\":\"123123\"},{\"campusId\":2,\"campusName\":\"丽湖小区\",\"createTime\":\"2024-03-24 15:27:51\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":53,\"reservationStatus\":\"0\",\"userCompanion\":\"qwer,df\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 15:27:51\",\"params\":{},\"reservationId\":53,\"userCompanionId\":44,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"qwer\",\"userCompanionPhoneNumber\":\"123123\"},{\"createTime\":\"2024-03-24 15:27:51\",\"params\":{},\"reservationId\":53,\"userCompanionId\":45,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"df\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":102,\"userIdNumber\":\"123123\",\"userName\":\"312312\",\"userPhoneNumber\":\"123123\"}]}', 0, NULL, '2024-03-24 15:27:51', 49);
INSERT INTO `sys_oper_log` VALUES (154, '校园预约表', 2, 'com.ruoyi.web.controller.system.CrReservationController.edit()', 'PUT', 1, '123123', NULL, '/system/reservation', '127.0.0.1', '内网IP', '{\"params\":{},\"reservationId\":45}', NULL, 1, '', '2024-03-24 16:09:14', 34);
INSERT INTO `sys_oper_log` VALUES (155, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"userCompanionList\":[{\"params\":{},\"userCompanionIdNumber\":\"1231231231\",\"userCompanionName\":\"李刚\",\"userCompanionPhoneNumber\":\"123123123\"}],\"userIdNumber\":\"123123123\",\"userName\":\"马瑞\",\"userPhoneNumber\":\"123123123123\"},{\"campusId\":2,\"campusName\":\"丽湖小区\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"userCompanionList\":[{\"params\":{},\"userCompanionIdNumber\":\"1231231231\",\"userCompanionName\":\"李刚\",\"userCompanionPhoneNumber\":\"123123123\"}],\"userIdNumber\":\"123123123\",\"userName\":\"马瑞\",\"userPhoneNumber\":\"123123123123\"}]', '{\"msg\":\"当前时间段无法预约当天参观\",\"code\":500}', 0, NULL, '2024-03-24 21:23:54', 13);
INSERT INTO `sys_oper_log` VALUES (156, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"userCompanionList\":[{\"params\":{},\"userCompanionIdNumber\":\"1231231231\",\"userCompanionName\":\"李刚\",\"userCompanionPhoneNumber\":\"123123123\"}],\"userIdNumber\":\"123123123\",\"userName\":\"马瑞\",\"userPhoneNumber\":\"123123123123\"},{\"campusId\":2,\"campusName\":\"丽湖小区\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"userCompanionList\":[{\"params\":{},\"userCompanionIdNumber\":\"1231231231\",\"userCompanionName\":\"李刚\",\"userCompanionPhoneNumber\":\"123123123\"}],\"userIdNumber\":\"123123123\",\"userName\":\"马瑞\",\"userPhoneNumber\":\"123123123123\"}]', '{\"msg\":\"当前时间段无法预约当天参观\",\"code\":500}', 0, NULL, '2024-03-24 21:23:59', 0);
INSERT INTO `sys_oper_log` VALUES (157, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"params\":{},\"remark\":\"2024-03-24\",\"reservationDate\":\"2024-03-24 08:00:00\",\"userCompanionList\":[{\"params\":{},\"userCompanionIdNumber\":\"1231231\",\"userCompanionName\":\"李刚\",\"userCompanionPhoneNumber\":\"123123\"}],\"userIdNumber\":\"123123\",\"userName\":\"马瑞\",\"userPhoneNumber\":\"123123123\"},{\"campusId\":1,\"campusName\":\"粤海校区\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"userCompanionList\":[{\"params\":{},\"userCompanionIdNumber\":\"1231231\",\"userCompanionName\":\"李刚\",\"userCompanionPhoneNumber\":\"123123\"}],\"userIdNumber\":\"123123\",\"userName\":\"马瑞\",\"userPhoneNumber\":\"123123123\"},{\"campusId\":2,\"campusName\":\"丽湖小区\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"userCompanionList\":[{\"params\":{},\"userCompanionIdNumber\":\"1231231\",\"userCompanionName\":\"李刚\",\"userCompanionPhoneNumber\":\"123123\"}],\"userIdNumber\":\"123123\",\"userName\":\"马瑞\",\"userPhoneNumber\":\"123123123\"}]', '{\"msg\":\"当前时间段无法预约当天参观\",\"code\":500}', 0, NULL, '2024-03-24 21:25:31', 2);
INSERT INTO `sys_oper_log` VALUES (158, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 21:25:35\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":54,\"reservationStatus\":\"0\",\"userCompanion\":\"李刚\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 21:25:35\",\"params\":{},\"reservationId\":54,\"userCompanionId\":46,\"userCompanionIdNumber\":\"1231231\",\"userCompanionName\":\"李刚\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"马瑞\",\"userPhoneNumber\":\"123123123\"},{\"campusId\":2,\"campusName\":\"丽湖小区\",\"createTime\":\"2024-03-24 21:25:35\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":55,\"reservationStatus\":\"0\",\"userCompanion\":\"李刚\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 21:25:35\",\"params\":{},\"reservationId\":55,\"userCompanionId\":47,\"userCompanionIdNumber\":\"1231231\",\"userCompanionName\":\"李刚\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"马瑞\",\"userPhoneNumber\":\"123123123\"}]', '{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 21:25:35\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":54,\"reservationStatus\":\"0\",\"userCompanion\":\"李刚\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 21:25:35\",\"params\":{},\"reservationId\":54,\"userCompanionId\":46,\"userCompanionIdNumber\":\"1231231\",\"userCompanionName\":\"李刚\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"马瑞\",\"userPhoneNumber\":\"123123123\"},{\"campusId\":2,\"campusName\":\"丽湖小区\",\"createTime\":\"2024-03-24 21:25:35\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":55,\"reservationStatus\":\"0\",\"userCompanion\":\"李刚\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 21:25:35\",\"params\":{},\"reservationId\":55,\"userCompanionId\":47,\"userCompanionIdNumber\":\"1231231\",\"userCompanionName\":\"李刚\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"马瑞\",\"userPhoneNumber\":\"123123123\"}]}', 0, NULL, '2024-03-24 21:25:35', 66);
INSERT INTO `sys_oper_log` VALUES (159, '预约参观 取消预约', 2, 'com.ruoyi.web.controller.system.CrReservationController.reservationHasten()', 'POST', 1, 'aaa', NULL, '/system/reservation/cancelReservation', '127.0.0.1', '内网IP', '{\"reservationId\":\"55\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-24 21:43:38', 36);
INSERT INTO `sys_oper_log` VALUES (160, '校园预约表', 1, 'com.ruoyi.web.controller.system.CrReservationController.add()', 'POST', 1, 'aaa', NULL, '/system/reservation', '127.0.0.1', '内网IP', '[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 21:45:48\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":56,\"reservationStatus\":\"0\",\"userCompanion\":\"123123\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 21:45:48\",\"params\":{},\"reservationId\":56,\"userCompanionId\":48,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"123123\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"marui\",\"userPhoneNumber\":\"231231\"},{\"campusId\":2,\"campusName\":\"丽湖小区\",\"createTime\":\"2024-03-24 21:45:48\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":57,\"reservationStatus\":\"0\",\"userCompanion\":\"123123\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 21:45:48\",\"params\":{},\"reservationId\":57,\"userCompanionId\":49,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"123123\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"marui\",\"userPhoneNumber\":\"231231\"}]', '{\"msg\":\"操作成功\",\"code\":200,\"data\":[{\"campusId\":1,\"campusName\":\"粤海校区\",\"createTime\":\"2024-03-24 21:45:48\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":56,\"reservationStatus\":\"0\",\"userCompanion\":\"123123\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 21:45:48\",\"params\":{},\"reservationId\":56,\"userCompanionId\":48,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"123123\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"marui\",\"userPhoneNumber\":\"231231\"},{\"campusId\":2,\"campusName\":\"丽湖小区\",\"createTime\":\"2024-03-24 21:45:48\",\"params\":{},\"remark\":\"2024-03-25\",\"reservationDate\":\"2024-03-25 08:00:00\",\"reservationId\":57,\"reservationStatus\":\"0\",\"userCompanion\":\"123123\",\"userCompanionList\":[{\"createTime\":\"2024-03-24 21:45:48\",\"params\":{},\"reservationId\":57,\"userCompanionId\":49,\"userCompanionIdNumber\":\"123123\",\"userCompanionName\":\"123123\",\"userCompanionPhoneNumber\":\"123123\"}],\"userId\":101,\"userIdNumber\":\"123123\",\"userName\":\"marui\",\"userPhoneNumber\":\"231231\"}]}', 0, NULL, '2024-03-24 21:45:48', 56);
INSERT INTO `sys_oper_log` VALUES (161, '预约参观 取消预约', 2, 'com.ruoyi.web.controller.system.CrReservationController.reservationHasten()', 'POST', 1, 'aaa', NULL, '/system/reservation/cancelReservation', '127.0.0.1', '内网IP', '{\"reservationId\":\"56\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-24 21:49:27', 16);
INSERT INTO `sys_oper_log` VALUES (162, '预约参观 取消预约', 2, 'com.ruoyi.web.controller.system.CrReservationController.reservationHasten()', 'POST', 1, 'aaa', NULL, '/system/reservation/cancelReservation', '127.0.0.1', '内网IP', '{\"reservationId\":\"57\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-24 21:50:17', 17);
INSERT INTO `sys_oper_log` VALUES (163, '定时任务', 2, 'com.ruoyi.quartz.controller.SysJobController.edit()', 'PUT', 1, 'admin', '研发部门', '/monitor/job', '172.16.18.203', '内网IP', '{\"concurrent\":\"1\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 11:44:17\",\"cronExpression\":\"0 0 8 * * ? \",\"invokeTarget\":\"ryTask.ryParams(\'ry\')\",\"jobGroup\":\"DEFAULT\",\"jobId\":2,\"jobName\":\"系统默认（有参）\",\"misfirePolicy\":\"3\",\"nextValidTime\":\"2024-03-26 08:00:00\",\"params\":{},\"remark\":\"\",\"status\":\"1\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-25 19:02:24', 41);
INSERT INTO `sys_oper_log` VALUES (164, '定时任务', 2, 'com.ruoyi.quartz.controller.SysJobController.changeStatus()', 'PUT', 1, 'admin', '研发部门', '/monitor/job/changeStatus', '172.16.18.203', '内网IP', '{\"jobId\":2,\"misfirePolicy\":\"0\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-25 19:02:26', 11);
INSERT INTO `sys_oper_log` VALUES (165, '定时任务', 2, 'com.ruoyi.quartz.controller.SysJobController.edit()', 'PUT', 1, 'admin', '研发部门', '/monitor/job', '172.16.18.203', '内网IP', '{\"concurrent\":\"1\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 11:44:17\",\"cronExpression\":\"0 0 18 * * ? \",\"invokeTarget\":\"ryTask.ryNoParams\",\"jobGroup\":\"DEFAULT\",\"jobId\":1,\"jobName\":\"系统默认（无参）\",\"misfirePolicy\":\"3\",\"nextValidTime\":\"2024-03-26 18:00:00\",\"params\":{},\"remark\":\"\",\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-25 19:02:45', 15);
INSERT INTO `sys_oper_log` VALUES (166, '预约参观 入校', 2, 'com.ruoyi.web.controller.system.CrReservationController.entryCampus()', 'POST', 1, 'admin', '研发部门', '/system/reservation/entryCampus', '127.0.0.1', '内网IP', '{\"campusId\":\"2\",\"userIdNumber\":\"13245622262543\"}', '{\"msg\":\"未查询到今日预约\",\"code\":500}', 0, NULL, '2024-03-25 19:32:36', 10);
INSERT INTO `sys_oper_log` VALUES (167, '预约参观 入校', 2, 'com.ruoyi.web.controller.system.CrReservationController.entryCampus()', 'POST', 1, 'admin', '研发部门', '/system/reservation/entryCampus', '127.0.0.1', '内网IP', '{\"campusId\":\"1\",\"userIdNumber\":\"1324522662543\"}', '{\"msg\":\"未查询到今日预约\",\"code\":500}', 0, NULL, '2024-03-25 19:34:39', 4);
INSERT INTO `sys_oper_log` VALUES (168, '预约参观  审核', 2, 'com.ruoyi.web.controller.system.CrReservationController.reservationAudit()', 'POST', 1, 'admin', '研发部门', '/system/reservation/reservationAudit', '127.0.0.1', '内网IP', '{\"auditOpinion\":\"手动阀手动阀\",\"auditStatus\":\"3\",\"reservationId\":43}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-03-25 20:12:36', 20);
INSERT INTO `sys_oper_log` VALUES (169, '预约参观  审核', 2, 'com.ruoyi.web.controller.system.CrReservationController.reservationAudit()', 'POST', 1, 'admin', '研发部门', '/system/reservation/reservationAudit', '127.0.0.1', '内网IP', '{\"auditStatus\":\"2\",\"reservationId\":44}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 11:37:30', 29);
INSERT INTO `sys_oper_log` VALUES (170, '预约参观  审核', 2, 'com.ruoyi.web.controller.system.CrReservationController.reservationAudit()', 'POST', 1, 'admin', '研发部门', '/system/reservation/reservationAudit', '127.0.0.1', '内网IP', '{\"auditStatus\":\"2\",\"reservationId\":44}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 11:38:03', 20);
INSERT INTO `sys_oper_log` VALUES (171, '预约参观  审核', 2, 'com.ruoyi.web.controller.system.CrReservationController.reservationAudit()', 'POST', 1, 'admin', '研发部门', '/system/reservation/reservationAudit', '127.0.0.1', '内网IP', '{\"auditStatus\":\"2\",\"reservationId\":45}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 11:38:11', 10);
INSERT INTO `sys_oper_log` VALUES (172, '预约参观  审核', 2, 'com.ruoyi.web.controller.system.CrReservationController.reservationAudit()', 'POST', 1, 'admin', '研发部门', '/system/reservation/reservationAudit', '127.0.0.1', '内网IP', '{\"auditOpinion\":\"不行\",\"auditStatus\":\"3\",\"reservationId\":45}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 11:38:27', 14);
INSERT INTO `sys_oper_log` VALUES (173, '角色管理', 2, 'com.ruoyi.web.controller.system.SysRoleController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/role', '127.0.0.1', '内网IP', '{\"admin\":false,\"createTime\":\"2024-03-17 11:44:17\",\"dataScope\":\"2\",\"delFlag\":\"0\",\"deptCheckStrictly\":true,\"flag\":false,\"menuCheckStrictly\":true,\"menuIds\":[1,100,1000,1001,1002,1003,1004,1005,1006,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,101,1007,1008,1009,1010,1011,102,1012,1013,1014,1015],\"params\":{},\"remark\":\"管理员\",\"roleId\":2,\"roleKey\":\"common\",\"roleName\":\"管理员\",\"roleSort\":2,\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 11:44:46', 70);
INSERT INTO `sys_oper_log` VALUES (174, '角色管理', 1, 'com.ruoyi.web.controller.system.SysRoleController.add()', 'POST', 1, 'admin', '研发部门', '/system/role', '127.0.0.1', '内网IP', '{\"admin\":false,\"createBy\":\"admin\",\"deptCheckStrictly\":true,\"deptIds\":[],\"flag\":false,\"menuCheckStrictly\":true,\"menuIds\":[1,2012,2013,2014,2015,2016,2017],\"params\":{},\"roleId\":100,\"roleKey\":\"*\",\"roleName\":\"审核员\",\"roleSort\":2,\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 11:45:28', 42);
INSERT INTO `sys_oper_log` VALUES (175, '角色管理', 1, 'com.ruoyi.web.controller.system.SysRoleController.add()', 'POST', 1, 'admin', '研发部门', '/system/role', '127.0.0.1', '内网IP', '{\"admin\":false,\"deptCheckStrictly\":true,\"deptIds\":[],\"flag\":false,\"menuCheckStrictly\":true,\"menuIds\":[1,2000,2001,2002,2003,2004,2005,2012,2013,2014,2015,2016,2017],\"params\":{},\"roleKey\":\"*\",\"roleName\":\"学校方\",\"roleSort\":2,\"status\":\"0\"}', '{\"msg\":\"新增角色\'学校方\'失败，角色权限已存在\",\"code\":500}', 0, NULL, '2024-04-04 11:46:04', 9);
INSERT INTO `sys_oper_log` VALUES (176, '角色管理', 1, 'com.ruoyi.web.controller.system.SysRoleController.add()', 'POST', 1, 'admin', '研发部门', '/system/role', '127.0.0.1', '内网IP', '{\"admin\":false,\"createBy\":\"admin\",\"deptCheckStrictly\":true,\"deptIds\":[],\"flag\":false,\"menuCheckStrictly\":true,\"menuIds\":[1,2000,2001,2002,2003,2004,2005,2012,2013,2014,2015,2016,2017],\"params\":{},\"roleId\":101,\"roleKey\":\"/\",\"roleName\":\"学校方\",\"roleSort\":2,\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 11:46:11', 29);
INSERT INTO `sys_oper_log` VALUES (177, '角色管理', 1, 'com.ruoyi.web.controller.system.SysRoleController.add()', 'POST', 1, 'admin', '研发部门', '/system/role', '127.0.0.1', '内网IP', '{\"admin\":false,\"createBy\":\"admin\",\"deptCheckStrictly\":true,\"deptIds\":[],\"flag\":false,\"menuCheckStrictly\":true,\"menuIds\":[],\"params\":{},\"roleId\":102,\"roleKey\":\"-\",\"roleName\":\"普通用户\",\"roleSort\":2,\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 11:47:51', 16);
INSERT INTO `sys_oper_log` VALUES (178, '用户管理', 2, 'com.ruoyi.web.controller.system.SysUserController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/user', '127.0.0.1', '内网IP', '{\"admin\":false,\"avatar\":\"\",\"createBy\":\"admin\",\"createTime\":\"2024-03-17 11:44:17\",\"delFlag\":\"0\",\"dept\":{\"ancestors\":\"0,100,101\",\"children\":[],\"deptId\":105,\"deptName\":\"测试部门\",\"leader\":\"若依\",\"orderNum\":3,\"params\":{},\"parentId\":101,\"status\":\"0\"},\"deptId\":105,\"email\":\"ry@qq.com\",\"loginDate\":\"2024-03-17 11:44:17\",\"loginIp\":\"127.0.0.1\",\"nickName\":\"管理员\",\"params\":{},\"phonenumber\":\"15666666666\",\"postIds\":[2],\"remark\":\"测试员\",\"roleIds\":[2],\"roles\":[{\"admin\":false,\"dataScope\":\"2\",\"deptCheckStrictly\":false,\"flag\":false,\"menuCheckStrictly\":false,\"params\":{},\"roleId\":2,\"roleKey\":\"common\",\"roleName\":\"管理员\",\"roleSort\":2,\"status\":\"0\"}],\"sex\":\"0\",\"status\":\"0\",\"updateBy\":\"admin\",\"userId\":2,\"userName\":\"ry\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 11:49:34', 45);
INSERT INTO `sys_oper_log` VALUES (179, '用户管理', 2, 'com.ruoyi.web.controller.system.SysUserController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/user', '127.0.0.1', '内网IP', '{\"admin\":false,\"avatar\":\"\",\"createBy\":\"\",\"createTime\":\"2024-03-23 17:19:43\",\"delFlag\":\"0\",\"email\":\"\",\"loginDate\":\"2024-03-24 13:09:33\",\"loginIp\":\"127.0.0.1\",\"nickName\":\"123\",\"params\":{},\"phonenumber\":\"\",\"postIds\":[],\"roleIds\":[100],\"roles\":[],\"sex\":\"0\",\"status\":\"0\",\"updateBy\":\"admin\",\"userId\":100,\"userName\":\"123\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 11:49:47', 19);
INSERT INTO `sys_oper_log` VALUES (180, '用户管理', 2, 'com.ruoyi.web.controller.system.SysUserController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/user', '127.0.0.1', '内网IP', '{\"admin\":false,\"avatar\":\"\",\"createBy\":\"\",\"createTime\":\"2024-03-24 10:20:44\",\"delFlag\":\"0\",\"email\":\"\",\"loginDate\":\"2024-03-24 21:42:08\",\"loginIp\":\"127.0.0.1\",\"nickName\":\"aaa\",\"params\":{},\"phonenumber\":\"\",\"postIds\":[],\"roleIds\":[101],\"roles\":[],\"sex\":\"0\",\"status\":\"0\",\"updateBy\":\"admin\",\"userId\":101,\"userName\":\"aaa\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 11:49:57', 39);
INSERT INTO `sys_oper_log` VALUES (181, '菜单管理', 1, 'com.ruoyi.web.controller.system.SysMenuController.add()', 'POST', 1, 'admin', '研发部门', '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"ss\",\"createBy\":\"admin\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuName\":\"审核预约列表\",\"menuType\":\"C\",\"orderNum\":5,\"params\":{},\"parentId\":1,\"path\":\"asdsss\",\"status\":\"0\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 11:57:29', 18);
INSERT INTO `sys_oper_log` VALUES (182, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"system/reservation/auditRole\",\"createTime\":\"2024-04-04 11:57:29\",\"icon\":\"#\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2024,\"menuName\":\"审核预约列表\",\"menuType\":\"C\",\"orderNum\":1,\"params\":{},\"parentId\":1,\"path\":\"auditRole\",\"perms\":\"\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 11:58:55', 14);
INSERT INTO `sys_oper_log` VALUES (183, '菜单管理', 1, 'com.ruoyi.web.controller.system.SysMenuController.add()', 'POST', 1, 'admin', '研发部门', '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"createBy\":\"admin\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuName\":\"预约列表查询\",\"menuType\":\"F\",\"orderNum\":1,\"params\":{},\"parentId\":2024,\"perms\":\"system:reservation:query\",\"status\":\"0\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 11:59:49', 10);
INSERT INTO `sys_oper_log` VALUES (184, '菜单管理', 1, 'com.ruoyi.web.controller.system.SysMenuController.add()', 'POST', 1, 'admin', '研发部门', '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"system/reservation/schoolRole\",\"createBy\":\"admin\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuName\":\"确认预约列表\",\"menuType\":\"C\",\"orderNum\":1,\"params\":{},\"parentId\":1,\"path\":\"schoolRole\",\"status\":\"0\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 12:01:16', 11);
INSERT INTO `sys_oper_log` VALUES (185, '菜单管理', 1, 'com.ruoyi.web.controller.system.SysMenuController.add()', 'POST', 1, 'admin', '研发部门', '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"createBy\":\"admin\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuName\":\"预约列表查询\",\"menuType\":\"F\",\"orderNum\":1,\"params\":{},\"parentId\":2026,\"perms\":\"system:reservation:query\",\"status\":\"0\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 12:01:46', 8);
INSERT INTO `sys_oper_log` VALUES (186, '用户管理', 2, 'com.ruoyi.web.controller.system.SysUserController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/user', '127.0.0.1', '内网IP', '{\"admin\":false,\"avatar\":\"\",\"createBy\":\"\",\"createTime\":\"2024-03-23 17:19:43\",\"delFlag\":\"0\",\"email\":\"\",\"loginDate\":\"2024-03-24 13:09:33\",\"loginIp\":\"127.0.0.1\",\"nickName\":\"审核\",\"params\":{},\"phonenumber\":\"\",\"postIds\":[],\"roleIds\":[100],\"roles\":[{\"admin\":false,\"dataScope\":\"1\",\"deptCheckStrictly\":false,\"flag\":false,\"menuCheckStrictly\":false,\"params\":{},\"roleId\":100,\"roleKey\":\"*\",\"roleName\":\"审核员\",\"roleSort\":2,\"status\":\"0\"}],\"sex\":\"0\",\"status\":\"0\",\"updateBy\":\"admin\",\"userId\":100,\"userName\":\"123\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 12:06:55', 24);
INSERT INTO `sys_oper_log` VALUES (187, '用户管理', 2, 'com.ruoyi.web.controller.system.SysUserController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/user', '127.0.0.1', '内网IP', '{\"admin\":false,\"avatar\":\"\",\"createBy\":\"\",\"createTime\":\"2024-03-24 10:20:44\",\"delFlag\":\"0\",\"email\":\"\",\"loginDate\":\"2024-03-24 21:42:08\",\"loginIp\":\"127.0.0.1\",\"nickName\":\"学校\",\"params\":{},\"phonenumber\":\"\",\"postIds\":[],\"roleIds\":[101],\"roles\":[{\"admin\":false,\"dataScope\":\"1\",\"deptCheckStrictly\":false,\"flag\":false,\"menuCheckStrictly\":false,\"params\":{},\"roleId\":101,\"roleKey\":\"/\",\"roleName\":\"学校方\",\"roleSort\":2,\"status\":\"0\"}],\"sex\":\"0\",\"status\":\"0\",\"updateBy\":\"admin\",\"userId\":101,\"userName\":\"aaa\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 12:07:09', 30);
INSERT INTO `sys_oper_log` VALUES (188, '用户管理', 3, 'com.ruoyi.web.controller.system.SysUserController.remove()', 'DELETE', 1, 'admin', '研发部门', '/system/user/102', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 12:07:16', 30);
INSERT INTO `sys_oper_log` VALUES (189, '角色管理', 2, 'com.ruoyi.web.controller.system.SysRoleController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/role', '127.0.0.1', '内网IP', '{\"admin\":false,\"createTime\":\"2024-04-04 11:45:28\",\"dataScope\":\"1\",\"delFlag\":\"0\",\"deptCheckStrictly\":true,\"flag\":false,\"menuCheckStrictly\":true,\"menuIds\":[1,2024,2025],\"params\":{},\"roleId\":100,\"roleKey\":\"*\",\"roleName\":\"审核员\",\"roleSort\":2,\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 12:09:46', 15);
INSERT INTO `sys_oper_log` VALUES (190, '角色管理', 2, 'com.ruoyi.web.controller.system.SysRoleController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/role', '127.0.0.1', '内网IP', '{\"admin\":false,\"createTime\":\"2024-04-04 11:46:11\",\"dataScope\":\"1\",\"delFlag\":\"0\",\"deptCheckStrictly\":true,\"flag\":false,\"menuCheckStrictly\":true,\"menuIds\":[1,2000,2001,2002,2003,2004,2005,2026,2027],\"params\":{},\"roleId\":101,\"roleKey\":\"/\",\"roleName\":\"学校方\",\"roleSort\":2,\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 12:10:08', 17);
INSERT INTO `sys_oper_log` VALUES (191, '用户管理', 2, 'com.ruoyi.web.controller.system.SysUserController.resetPwd()', 'PUT', 1, 'admin', '研发部门', '/system/user/resetPwd', '127.0.0.1', '内网IP', '{\"admin\":false,\"params\":{},\"updateBy\":\"admin\",\"userId\":2}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 12:10:39', 93);
INSERT INTO `sys_oper_log` VALUES (192, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"system/campus/index\",\"createTime\":\"2024-03-17 15:27:22\",\"icon\":\"drag\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2000,\"menuName\":\"校区管理\",\"menuType\":\"C\",\"orderNum\":1,\"params\":{},\"parentId\":1,\"path\":\"campus\",\"perms\":\"system:campus:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 14:56:15', 7);
INSERT INTO `sys_oper_log` VALUES (193, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"system/companion/index\",\"createTime\":\"2024-03-17 15:27:22\",\"icon\":\"documentation\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2006,\"menuName\":\"参观陪同人员表\",\"menuType\":\"C\",\"orderNum\":1,\"params\":{},\"parentId\":1,\"path\":\"companion\",\"perms\":\"system:companion:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 14:56:35', 6);
INSERT INTO `sys_oper_log` VALUES (194, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"system/reservation/index\",\"createTime\":\"2024-03-17 15:27:22\",\"icon\":\"excel\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2012,\"menuName\":\"校园预约表\",\"menuType\":\"C\",\"orderNum\":1,\"params\":{},\"parentId\":1,\"path\":\"reservation\",\"perms\":\"system:reservation:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 14:56:46', 7);
INSERT INTO `sys_oper_log` VALUES (195, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"system/reservation/auditRole\",\"createTime\":\"2024-04-04 11:57:29\",\"icon\":\"edit\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2024,\"menuName\":\"审核预约列表\",\"menuType\":\"C\",\"orderNum\":1,\"params\":{},\"parentId\":1,\"path\":\"auditRole\",\"perms\":\"\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 14:57:00', 6);
INSERT INTO `sys_oper_log` VALUES (196, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"system/reservation/schoolRole\",\"createTime\":\"2024-04-04 12:01:16\",\"icon\":\"example\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2026,\"menuName\":\"确认预约列表\",\"menuType\":\"C\",\"orderNum\":1,\"params\":{},\"parentId\":1,\"path\":\"schoolRole\",\"perms\":\"\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 14:57:20', 6);
INSERT INTO `sys_oper_log` VALUES (197, '用户管理', 2, 'com.ruoyi.web.controller.system.SysUserController.resetPwd()', 'PUT', 1, 'admin', '研发部门', '/system/user/resetPwd', '127.0.0.1', '内网IP', '{\"admin\":false,\"params\":{},\"updateBy\":\"admin\",\"userId\":100}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 14:59:30', 83);
INSERT INTO `sys_oper_log` VALUES (198, '用户管理', 2, 'com.ruoyi.web.controller.system.SysUserController.resetPwd()', 'PUT', 1, 'admin', '研发部门', '/system/user/resetPwd', '127.0.0.1', '内网IP', '{\"admin\":false,\"params\":{},\"updateBy\":\"admin\",\"userId\":101}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 14:59:38', 111);
INSERT INTO `sys_oper_log` VALUES (199, '预约参观  审核', 2, 'com.ruoyi.web.controller.system.CrReservationController.reservationAudit()', 'POST', 1, '123', NULL, '/system/reservation/reservationAudit', '127.0.0.1', '内网IP', '{\"auditOpinion\":\"手动阀手动阀\",\"auditStatus\":\"2\",\"reservationId\":43}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 15:02:41', 12);
INSERT INTO `sys_oper_log` VALUES (200, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"system/campus/index\",\"createTime\":\"2024-03-17 15:27:22\",\"icon\":\"drag\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2000,\"menuName\":\"校区管理\",\"menuType\":\"C\",\"orderNum\":0,\"params\":{},\"parentId\":1,\"path\":\"campus\",\"perms\":\"system:campus:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 15:05:15', 20);
INSERT INTO `sys_oper_log` VALUES (201, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"system/companion/index\",\"createTime\":\"2024-03-17 15:27:22\",\"icon\":\"documentation\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2006,\"menuName\":\"参观陪同人员表\",\"menuType\":\"C\",\"orderNum\":0,\"params\":{},\"parentId\":1,\"path\":\"companion\",\"perms\":\"system:companion:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 15:05:29', 5);
INSERT INTO `sys_oper_log` VALUES (202, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"system/reservation/index\",\"createTime\":\"2024-03-17 15:27:22\",\"icon\":\"excel\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2012,\"menuName\":\"校园预约表\",\"menuType\":\"C\",\"orderNum\":0,\"params\":{},\"parentId\":1,\"path\":\"reservation\",\"perms\":\"system:reservation:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 15:05:51', 5);
INSERT INTO `sys_oper_log` VALUES (203, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"system/reservation/auditRole\",\"createTime\":\"2024-04-04 11:57:29\",\"icon\":\"edit\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2024,\"menuName\":\"审核预约列表\",\"menuType\":\"C\",\"orderNum\":0,\"params\":{},\"parentId\":1,\"path\":\"auditRole\",\"perms\":\"\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 15:06:02', 9);
INSERT INTO `sys_oper_log` VALUES (204, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', '研发部门', '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"system/reservation/schoolRole\",\"createTime\":\"2024-04-04 12:01:16\",\"icon\":\"example\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2026,\"menuName\":\"确认预约列表\",\"menuType\":\"C\",\"orderNum\":0,\"params\":{},\"parentId\":1,\"path\":\"schoolRole\",\"perms\":\"\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-04-04 15:06:12', 5);

-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_post`;
CREATE TABLE `sys_post`  (
  `post_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
  `post_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位编码',
  `post_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位名称',
  `post_sort` int(4) NOT NULL COMMENT '显示顺序',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`post_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '岗位信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_post
-- ----------------------------
INSERT INTO `sys_post` VALUES (1, 'ceo', '董事长', 1, '0', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_post` VALUES (2, 'se', '项目经理', 2, '0', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_post` VALUES (3, 'hr', '人力资源', 3, '0', 'admin', '2024-03-17 11:44:17', '', NULL, '');
INSERT INTO `sys_post` VALUES (4, 'user', '普通员工', 4, '0', 'admin', '2024-03-17 11:44:17', '', NULL, '');

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名称',
  `role_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色权限字符串',
  `role_sort` int(4) NOT NULL COMMENT '显示顺序',
  `data_scope` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
  `menu_check_strictly` tinyint(1) NULL DEFAULT 1 COMMENT '菜单树选择项是否关联显示',
  `dept_check_strictly` tinyint(1) NULL DEFAULT 1 COMMENT '部门树选择项是否关联显示',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色状态（0正常 1停用）',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 103 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (1, '超级管理员', 'admin', 1, '1', 1, 1, '0', '0', 'admin', '2024-03-17 11:44:17', '', NULL, '超级管理员');
INSERT INTO `sys_role` VALUES (2, '管理员', 'common', 2, '2', 1, 1, '0', '0', 'admin', '2024-03-17 11:44:17', 'admin', '2024-04-04 11:44:46', '管理员');
INSERT INTO `sys_role` VALUES (100, '审核员', '*', 2, '1', 1, 1, '0', '0', 'admin', '2024-04-04 11:45:28', 'admin', '2024-04-04 12:09:46', NULL);
INSERT INTO `sys_role` VALUES (101, '学校方', '/', 2, '1', 1, 1, '0', '0', 'admin', '2024-04-04 11:46:11', 'admin', '2024-04-04 12:10:08', NULL);
INSERT INTO `sys_role` VALUES (102, '普通用户', '-', 2, '1', 1, 1, '0', '0', 'admin', '2024-04-04 11:47:51', '', NULL, NULL);

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept`  (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `dept_id` bigint(20) NOT NULL COMMENT '部门ID',
  PRIMARY KEY (`role_id`, `dept_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和部门关联表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- 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(20) NOT NULL COMMENT '角色ID',
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`, `menu_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES (2, 1);
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, 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, 2000);
INSERT INTO `sys_role_menu` VALUES (2, 2001);
INSERT INTO `sys_role_menu` VALUES (2, 2002);
INSERT INTO `sys_role_menu` VALUES (2, 2003);
INSERT INTO `sys_role_menu` VALUES (2, 2004);
INSERT INTO `sys_role_menu` VALUES (2, 2005);
INSERT INTO `sys_role_menu` VALUES (2, 2006);
INSERT INTO `sys_role_menu` VALUES (2, 2007);
INSERT INTO `sys_role_menu` VALUES (2, 2008);
INSERT INTO `sys_role_menu` VALUES (2, 2009);
INSERT INTO `sys_role_menu` VALUES (2, 2010);
INSERT INTO `sys_role_menu` VALUES (2, 2011);
INSERT INTO `sys_role_menu` VALUES (2, 2012);
INSERT INTO `sys_role_menu` VALUES (2, 2013);
INSERT INTO `sys_role_menu` VALUES (2, 2014);
INSERT INTO `sys_role_menu` VALUES (2, 2015);
INSERT INTO `sys_role_menu` VALUES (2, 2016);
INSERT INTO `sys_role_menu` VALUES (2, 2017);
INSERT INTO `sys_role_menu` VALUES (100, 1);
INSERT INTO `sys_role_menu` VALUES (100, 2024);
INSERT INTO `sys_role_menu` VALUES (100, 2025);
INSERT INTO `sys_role_menu` VALUES (101, 1);
INSERT INTO `sys_role_menu` VALUES (101, 2000);
INSERT INTO `sys_role_menu` VALUES (101, 2001);
INSERT INTO `sys_role_menu` VALUES (101, 2002);
INSERT INTO `sys_role_menu` VALUES (101, 2003);
INSERT INTO `sys_role_menu` VALUES (101, 2004);
INSERT INTO `sys_role_menu` VALUES (101, 2005);
INSERT INTO `sys_role_menu` VALUES (101, 2026);
INSERT INTO `sys_role_menu` VALUES (101, 2027);

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `dept_id` bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
  `user_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户账号',
  `nick_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户昵称',
  `user_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '00' COMMENT '用户类型（00系统用户）',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户邮箱',
  `phonenumber` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手机号码',
  `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
  `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '头像地址',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '密码',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `login_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '最后登录IP',
  `login_date` datetime(0) NULL DEFAULT NULL COMMENT '最后登录时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 104 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- 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', '2024-04-04 15:07:16', 'admin', '2024-03-17 11:44:17', '', '2024-04-04 15:07:15', '管理员');
INSERT INTO `sys_user` VALUES (2, 105, 'ry', '管理员', '00', 'ry@qq.com', '15666666666', '0', '', '$2a$10$.GZyslJmmwOhnL3E7jhjqeZVf6pvHyispsVqgaEl9iVuSy9AcfdxS', '0', '0', '127.0.0.1', '2024-04-04 15:13:38', 'admin', '2024-03-17 11:44:17', 'admin', '2024-04-04 15:13:37', '测试员');
INSERT INTO `sys_user` VALUES (100, NULL, '123', '审核', '00', '', '', '0', '', '$2a$10$zGEkzl92cm.LY6A1Ns2PZuzcI3ajFtiEk2uxR701svmDT/RIpY3Ke', '0', '0', '127.0.0.1', '2024-04-04 15:02:30', '', '2024-03-23 17:19:43', 'admin', '2024-04-04 15:02:29', NULL);
INSERT INTO `sys_user` VALUES (101, NULL, 'aaa', '学校', '00', '', '', '0', '', '$2a$10$s5MJaFstmdY9IUf/SZzUfe0fkjh30ANxS/.1rpeLgU.YiA3xIgD0.', '0', '0', '127.0.0.1', '2024-04-04 15:04:16', '', '2024-03-24 10:20:44', 'admin', '2024-04-04 15:04:15', NULL);
INSERT INTO `sys_user` VALUES (102, NULL, '123123', '123123', '00', '', '', '0', '', '$2a$10$qJRzX58um0odkrQO2ik7rOfBW41uBY2IiWpp7cASWFfm1Df0SmTxC', '0', '2', '127.0.0.1', '2024-03-24 14:23:46', '', '2024-03-24 14:23:39', '', '2024-03-24 14:23:46', NULL);
INSERT INTO `sys_user` VALUES (103, NULL, 'abc', 'abc', '00', '', '', '0', '', '$2a$10$sDmKashEB8KuV3IrHKtg3usk0l6qJsy8qkAa.uQQWpcyatQi3gF6K', '0', '0', '127.0.0.1', '2024-04-04 16:54:56', '', '2024-04-04 16:54:46', '', '2024-04-04 16:54:55', NULL);

-- ----------------------------
-- Table structure for sys_user_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_post`;
CREATE TABLE `sys_user_post`  (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `post_id` bigint(20) NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (`user_id`, `post_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户与岗位关联表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
INSERT INTO `sys_user_post` VALUES (1, 1);
INSERT INTO `sys_user_post` VALUES (2, 2);

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role`  (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`, `role_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户和角色关联表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- 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, 100);
INSERT INTO `sys_user_role` VALUES (101, 101);

SET FOREIGN_KEY_CHECKS = 1;