text: /*
   Navicat Premium Data Transfer
  
   Source Server         : LOCALHOST
   Source Server Type    : MySQL
   Source Server Version : 50727
   Source Host           : localhost:3306
   Source Schema         : ry
  
   Target Server Type    : MySQL
   Target Server Version : 50727
   File Encoding         : 65001
  
   Date: 18/10/2021 08:40:50
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for cus_model
  -- ----------------------------
  DROP TABLE IF EXISTS `cus_model`;
  CREATE TABLE `cus_model`  (
    `model_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '模型id',
    `parkinglot_id` bigint(20) NOT NULL COMMENT '停车场id',
    `size_model` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '规模模型位置',
    `reg_model` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '识别模型位置',
    PRIMARY KEY (`model_id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '模型表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cus_model
  -- ----------------------------
  INSERT INTO `cus_model` VALUES (18, 6, '/profile/model/spot_dict.pickle', '/profile/model/net');
  INSERT INTO `cus_model` VALUES (19, 8, '/profile/model/spot_dict.pickle', '/profile/model/net');
  INSERT INTO `cus_model` VALUES (21, 7, '/profile/model/spot_dict.pickle', '/profile/model/net');
  INSERT INTO `cus_model` VALUES (22, 9, '/profile/model/spot_dict.pickle', '/profile/model/net');
  INSERT INTO `cus_model` VALUES (23, 10, '/profile/model/spot_dict.pickle', '/profile/model/net');
  
  -- ----------------------------
  -- Table structure for cus_parkinglot
  -- ----------------------------
  DROP TABLE IF EXISTS `cus_parkinglot`;
  CREATE TABLE `cus_parkinglot`  (
    `parkinglot_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '停车场id',
    `user_id` bigint(20) NOT NULL COMMENT '停车场所属管理员id',
    `parkinglot_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '停车场名称',
    `parkinglot_loc` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '停车场位置',
    `parkinglot_camera` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '摄像头图片文件位置',
    `parkinglot_capacity` bigint(20) NULL DEFAULT 0 COMMENT '停车场总车位',
    `parkinglot_spare` bigint(20) NULL DEFAULT 0 COMMENT '停车场空闲车位',
    `image` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '渲染图位置',
    `image_update` datetime(0) NULL DEFAULT NULL COMMENT '渲染日期',
    `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '停车场描述',
    PRIMARY KEY (`parkinglot_id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '停车场表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cus_parkinglot
  -- ----------------------------
  INSERT INTO `cus_parkinglot` VALUES (4, 1, '天通苑-北P+R停车场', '北京市昌平区天通苑北地铁站南', '/profile/upload/2021/10/16/191b5917-f391-4966-94f3-3920e57059f5.JPG', 10, 0, '/profile/upload/2021/09/26/test1.jpg', NULL, '北京市昌平区天通苑北地铁站南');
  INSERT INTO `cus_parkinglot` VALUES (6, 1, '绿港家园一区-停车场', '北京市顺义区光明绿港家园一区(减河公园西)', '/profile/upload/2021/09/26/scene1380.jpg', 532, 93, '/profile/upload/2021/09/26/scene1380-show.jpg', '2021-10-16 15:29:39', '北京市顺义区光明绿港家园一区(减河公园西)');
  INSERT INTO `cus_parkinglot` VALUES (7, 1, '大山子停车场', '北京市朝阳区酒仙桥北路北京市朝阳区大望京公园南侧约80米', '/profile/upload/2021/10/16/ec35e250-26b5-4000-a909-b36edfc1edf5.jpg', 532, 78, '/profile/upload/2021/10/16/ec35e250-26b5-4000-a909-b36edfc1edf5-show.jpg', '2021-10-16 15:34:49', '北京市朝阳区酒仙桥北路北京市朝阳区大望京公园南侧约80米');
  INSERT INTO `cus_parkinglot` VALUES (8, 1, '北京798艺术中心-停车场', '北京市朝阳区酒仙桥路2号798艺术区', '/profile/upload/2021/10/16/3f258058-10c9-4e13-b38f-56c8d02db265.jpg', 532, 89, '/profile/upload/2021/10/16/3f258058-10c9-4e13-b38f-56c8d02db265-show.jpg', '2021-10-16 15:33:32', '北京市朝阳区酒仙桥路2号798艺术区');
  INSERT INTO `cus_parkinglot` VALUES (9, 1, '停车场(中泰商务楼西北)', '北京市朝阳区朝阳北路中领商务楼', '', 0, 0, '', '2021-10-16 15:47:18', '北京市朝阳区朝阳北路中领商务楼');
  INSERT INTO `cus_parkinglot` VALUES (10, 1, '安泊旺商务楼-停车场', '北京市朝阳区建国路朗廷大厦西(京通苑阳光华苑南)', '', 0, 0, '', '2021-10-18 07:58:31', '北京市顺义区光明绿港家园一区(减河公园西)');
  INSERT INTO `cus_parkinglot` VALUES (11, 1, '超级蜂巢-停车场', '北京市朝阳区高碑店北花园1号', '', 0, 0, '', NULL, '北京市朝阳区高碑店北花园1号');
  INSERT INTO `cus_parkinglot` VALUES (12, 1, '远洋一方林语苑-停车场', '北京市朝阳区双桥东路东1时区西南侧约30米', '', 0, 0, '', NULL, '北京市朝阳区双桥东路东1时区西南侧约30米');
  INSERT INTO `cus_parkinglot` VALUES (13, 5, '新建停车场', '朝阳区', '/profile/upload/2021/09/27/cfe3f55d-d439-468b-92cf-9500cde08187.png', 0, 0, '', NULL, '');
  
  -- ----------------------------
  -- Table structure for cus_test
  -- ----------------------------
  DROP TABLE IF EXISTS `cus_test`;
  CREATE TABLE `cus_test`  (
    `id` int(11) NOT NULL,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- 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树表操作 sub主子表操作）',
    `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 = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成业务表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of gen_table
  -- ----------------------------
  INSERT INTO `gen_table` VALUES (9, 'cus_model', '模型表', NULL, NULL, 'CusModel', 'crud', 'com.ruoyi.custom', 'custom', 'model', '模型', 'kamiu', '0', '/', NULL, 'admin', '2021-10-08 22:25:19', '', NULL, NULL);
  INSERT INTO `gen_table` VALUES (10, 'cus_parkinglot', '停车场表', NULL, NULL, 'CusParkinglot', 'crud', 'com.ruoyi.custom', 'custom', 'parkinglot', '停车场', 'kamiu', '0', '/', NULL, 'admin', '2021-10-08 22:33:36', '', NULL, 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` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 = 61 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成业务表字段' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of gen_table_column
  -- ----------------------------
  INSERT INTO `gen_table_column` VALUES (47, '9', 'model_id', '模型id', 'bigint(20)', 'Long', 'modelId', '1', '1', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2021-10-08 22:25:19', '', NULL);
  INSERT INTO `gen_table_column` VALUES (48, '9', 'parkinglot_id', '停车场id', 'bigint(20)', 'Long', 'parkinglotId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 2, 'admin', '2021-10-08 22:25:19', '', NULL);
  INSERT INTO `gen_table_column` VALUES (49, '9', 'size_model', '规模模型位置', 'varchar(200)', 'String', 'sizeModel', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 3, 'admin', '2021-10-08 22:25:19', '', NULL);
  INSERT INTO `gen_table_column` VALUES (50, '9', 'reg_model', '识别模型位置', 'varchar(200)', 'String', 'regModel', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 4, 'admin', '2021-10-08 22:25:19', '', NULL);
  INSERT INTO `gen_table_column` VALUES (51, '10', 'parkinglot_id', '停车场id', 'bigint(20)', 'Long', 'parkinglotId', '1', '1', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2021-10-08 22:33:36', '', NULL);
  INSERT INTO `gen_table_column` VALUES (52, '10', 'user_id', '停车场所属管理员id', 'bigint(20)', 'Long', 'userId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 2, 'admin', '2021-10-08 22:33:36', '', NULL);
  INSERT INTO `gen_table_column` VALUES (53, '10', 'parkinglot_name', '停车场名称', 'varchar(30)', 'String', 'parkinglotName', '0', '0', NULL, '1', '1', '1', '1', 'LIKE', 'input', '', 3, 'admin', '2021-10-08 22:33:36', '', NULL);
  INSERT INTO `gen_table_column` VALUES (54, '10', 'parkinglot_loc', '停车场位置', 'varchar(200)', 'String', 'parkinglotLoc', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 4, 'admin', '2021-10-08 22:33:36', '', NULL);
  INSERT INTO `gen_table_column` VALUES (55, '10', 'parkinglot_camera', '摄像头图片文件位置', 'varchar(200)', 'String', 'parkinglotCamera', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 5, 'admin', '2021-10-08 22:33:36', '', NULL);
  INSERT INTO `gen_table_column` VALUES (56, '10', 'parkinglot_capacity', '停车场总车位', 'bigint(20)', 'Long', 'parkinglotCapacity', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 6, 'admin', '2021-10-08 22:33:36', '', NULL);
  INSERT INTO `gen_table_column` VALUES (57, '10', 'parkinglot_spare', '停车场空闲车位', 'bigint(20)', 'Long', 'parkinglotSpare', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 7, 'admin', '2021-10-08 22:33:36', '', NULL);
  INSERT INTO `gen_table_column` VALUES (58, '10', 'image', '渲染图位置', 'varchar(200)', 'String', 'image', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 8, 'admin', '2021-10-08 22:33:36', '', NULL);
  INSERT INTO `gen_table_column` VALUES (59, '10', 'image_update', '渲染日期', 'datetime', 'Date', 'imageUpdate', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'datetime', '', 9, 'admin', '2021-10-08 22:33:36', '', NULL);
  INSERT INTO `gen_table_column` VALUES (60, '10', 'remark', '停车场描述', 'varchar(500)', 'String', 'remark', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'textarea', '', 10, 'admin', '2021-10-08 22:33:36', '', 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;
  
  -- ----------------------------
  -- 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;
  
  -- ----------------------------
  -- 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
  -- ----------------------------
  INSERT INTO `qrtz_cron_triggers` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', '0/10 * * * * ?', 'Asia/Shanghai');
  INSERT INTO `qrtz_cron_triggers` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', '0/15 * * * * ?', 'Asia/Shanghai');
  INSERT INTO `qrtz_cron_triggers` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', '0/20 * * * * ?', 'Asia/Shanghai');
  
  -- ----------------------------
  -- Table structure for qrtz_fired_triggers
  -- ----------------------------
  DROP TABLE IF EXISTS `qrtz_fired_triggers`;
  CREATE TABLE `qrtz_fired_triggers`  (
    `sched_name` varchar(120) 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;
  
  -- ----------------------------
  -- 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
  -- ----------------------------
  INSERT INTO `qrtz_job_details` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', NULL, 'com.ruoyi.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001E636F6D2E72756F79692E71756172747A2E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E000978720027636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E42617365456E7469747900000000000000010200074C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0006706172616D7371007E00034C000672656D61726B71007E00094C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000C787074000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000017BECD9F82878707400007070707400013174000E302F3130202A202A202A202A203F74001172795461736B2E72794E6F506172616D7374000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000001740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E697A0E58F82EFBC8974000133740001317800);
  INSERT INTO `qrtz_job_details` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', NULL, 'com.ruoyi.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001E636F6D2E72756F79692E71756172747A2E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E000978720027636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E42617365456E7469747900000000000000010200074C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0006706172616D7371007E00034C000672656D61726B71007E00094C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000C787074000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000017BECD9F82878707400007070707400013174000E302F3135202A202A202A202A203F74001572795461736B2E7279506172616D7328277279272974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000002740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E69C89E58F82EFBC8974000133740001317800);
  INSERT INTO `qrtz_job_details` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', NULL, 'com.ruoyi.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001E636F6D2E72756F79692E71756172747A2E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E000978720027636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E42617365456E7469747900000000000000010200074C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0006706172616D7371007E00034C000672656D61726B71007E00094C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000C787074000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000017BECD9F82878707400007070707400013174000E302F3230202A202A202A202A203F74003872795461736B2E72794D756C7469706C65506172616D7328277279272C20747275652C20323030304C2C203331362E3530442C203130302974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000003740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E5A49AE58F82EFBC8974000133740001317800);
  
  -- ----------------------------
  -- 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
  -- ----------------------------
  INSERT INTO `qrtz_locks` VALUES ('RuoyiScheduler', 'STATE_ACCESS');
  INSERT INTO `qrtz_locks` VALUES ('RuoyiScheduler', 'TRIGGER_ACCESS');
  
  -- ----------------------------
  -- Table structure for qrtz_paused_trigger_grps
  -- ----------------------------
  DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
  CREATE TABLE `qrtz_paused_trigger_grps`  (
    `sched_name` varchar(120) 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;
  
  -- ----------------------------
  -- 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
  -- ----------------------------
  INSERT INTO `qrtz_scheduler_state` VALUES ('RuoyiScheduler', 'LAPTOP-PQH8RU8J1634516232483', 1634517646317, 15000);
  
  -- ----------------------------
  -- 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;
  
  -- ----------------------------
  -- 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;
  
  -- ----------------------------
  -- 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
  -- ----------------------------
  INSERT INTO `qrtz_triggers` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', 'TASK_CLASS_NAME1', 'DEFAULT', NULL, 1634516240000, -1, 5, 'PAUSED', 'CRON', 1634516232000, 0, NULL, 2, '');
  INSERT INTO `qrtz_triggers` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', 'TASK_CLASS_NAME2', 'DEFAULT', NULL, 1634516235000, -1, 5, 'PAUSED', 'CRON', 1634516232000, 0, NULL, 2, '');
  INSERT INTO `qrtz_triggers` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', 'TASK_CLASS_NAME3', 'DEFAULT', NULL, 1634516240000, -1, 5, 'PAUSED', 'CRON', 1634516232000, 0, NULL, 2, '');
  
  -- ----------------------------
  -- 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 = 10 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', '2021-09-16 12:25:13', '', NULL, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
  INSERT INTO `sys_config` VALUES (2, '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2021-09-16 12:25:13', '', NULL, '初始化密码 123456');
  INSERT INTO `sys_config` VALUES (3, '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2021-09-16 12:25:13', '', NULL, '深黑主题theme-dark，浅色主题theme-light，深蓝主题theme-blue');
  INSERT INTO `sys_config` VALUES (4, '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2021-09-16 12:25:13', '', NULL, '是否开启注册用户功能（true开启，false关闭）');
  INSERT INTO `sys_config` VALUES (5, '用户管理-密码字符范围', 'sys.account.chrtype', '0', 'Y', 'admin', '2021-09-16 12:25:13', '', NULL, '默认任意字符范围，0任意（密码可以输入任意字符），1数字（密码只能为0-9数字），2英文字母（密码只能为a-z和A-Z字母），3字母和数字（密码必须包含字母，数字）,4字母数字和特殊字符（目前支持的特殊字符包括：~!@#$%^&*()-=_+）');
  INSERT INTO `sys_config` VALUES (6, '用户管理-初始密码修改策略', 'sys.account.initPasswordModify', '0', 'Y', 'admin', '2021-09-16 12:25:13', '', NULL, '0：初始密码修改策略关闭，没有任何提示，1：提醒用户，如果未修改初始密码，则在登录时就会提醒修改密码对话框');
  INSERT INTO `sys_config` VALUES (7, '用户管理-账号密码更新周期', 'sys.account.passwordValidateDays', '0', 'Y', 'admin', '2021-09-16 12:25:13', '', NULL, '密码更新周期（填写数字，数据初始化值为0不限制，若修改必须为大于0小于365的正整数），如果超过这个周期登录系统时，则在登录时就会提醒修改密码对话框');
  INSERT INTO `sys_config` VALUES (8, '主框架页-菜单导航显示风格', 'sys.index.menuStyle', 'default', 'Y', 'admin', '2021-09-16 12:25:13', '', NULL, '菜单导航显示风格（default为左侧导航菜单，topnav为顶部导航菜单）');
  INSERT INTO `sys_config` VALUES (9, '主框架页-是否开启页脚', 'sys.index.ignoreFooter', 'true', 'Y', 'admin', '2021-09-16 12:25:13', '', NULL, '是否开启底部页脚显示（true显示，false隐藏）');
  
  -- ----------------------------
  -- 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 = 110 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', '2021-09-16 12:25:13', 'admin', '2021-09-26 19:18:01');
  INSERT INTO `sys_dept` VALUES (101, 100, '0,100', '朝阳区分公司', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-09-16 12:25:13', 'admin', '2021-09-26 19:18:40');
  INSERT INTO `sys_dept` VALUES (102, 100, '0,100', '海淀区分公司', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-09-16 12:25:13', 'admin', '2021-09-26 19:18:50');
  INSERT INTO `sys_dept` VALUES (103, 101, '0,100,101', '朝外街道分公司', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-09-16 12:25:13', 'admin', '2021-09-26 19:19:08');
  INSERT INTO `sys_dept` VALUES (104, 101, '0,100,101', '劲松街道分公司', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-09-16 12:25:13', 'admin', '2021-09-26 19:19:17');
  INSERT INTO `sys_dept` VALUES (105, 101, '0,100,101', '建外街道分公司', 3, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-09-16 12:25:13', 'admin', '2021-09-26 19:19:28');
  INSERT INTO `sys_dept` VALUES (106, 101, '0,100,101', '呼家楼街道分公司', 4, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-09-16 12:25:13', 'admin', '2021-09-26 19:19:42');
  INSERT INTO `sys_dept` VALUES (107, 101, '0,100,101', '八里庄街道分公司', 5, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-09-16 12:25:13', 'admin', '2021-09-26 19:19:52');
  INSERT INTO `sys_dept` VALUES (108, 102, '0,100,102', '万寿路街道分公司', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-09-16 12:25:13', 'admin', '2021-09-26 19:20:29');
  INSERT INTO `sys_dept` VALUES (109, 102, '0,100,102', '学院路街道分公司', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-09-16 12:25:13', 'admin', '2021-09-26 19:20:40');
  
  -- ----------------------------
  -- 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 = 30 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', '2021-09-16 12:25:13', '', NULL, '性别男');
  INSERT INTO `sys_dict_data` VALUES (2, 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '性别女');
  INSERT INTO `sys_dict_data` VALUES (3, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '性别未知');
  INSERT INTO `sys_dict_data` VALUES (4, 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '显示菜单');
  INSERT INTO `sys_dict_data` VALUES (5, 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '隐藏菜单');
  INSERT INTO `sys_dict_data` VALUES (6, 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '正常状态');
  INSERT INTO `sys_dict_data` VALUES (7, 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '停用状态');
  INSERT INTO `sys_dict_data` VALUES (8, 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '正常状态');
  INSERT INTO `sys_dict_data` VALUES (9, 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '停用状态');
  INSERT INTO `sys_dict_data` VALUES (10, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '默认分组');
  INSERT INTO `sys_dict_data` VALUES (11, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '系统分组');
  INSERT INTO `sys_dict_data` VALUES (12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '系统默认是');
  INSERT INTO `sys_dict_data` VALUES (13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '系统默认否');
  INSERT INTO `sys_dict_data` VALUES (14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '通知');
  INSERT INTO `sys_dict_data` VALUES (15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '公告');
  INSERT INTO `sys_dict_data` VALUES (16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '正常状态');
  INSERT INTO `sys_dict_data` VALUES (17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '关闭状态');
  INSERT INTO `sys_dict_data` VALUES (18, 99, '其他', '0', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '其他操作');
  INSERT INTO `sys_dict_data` VALUES (19, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '新增操作');
  INSERT INTO `sys_dict_data` VALUES (20, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '修改操作');
  INSERT INTO `sys_dict_data` VALUES (21, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '删除操作');
  INSERT INTO `sys_dict_data` VALUES (22, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '授权操作');
  INSERT INTO `sys_dict_data` VALUES (23, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '导出操作');
  INSERT INTO `sys_dict_data` VALUES (24, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '导入操作');
  INSERT INTO `sys_dict_data` VALUES (25, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '强退操作');
  INSERT INTO `sys_dict_data` VALUES (26, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '生成操作');
  INSERT INTO `sys_dict_data` VALUES (27, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '清空操作');
  INSERT INTO `sys_dict_data` VALUES (28, 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '正常状态');
  INSERT INTO `sys_dict_data` VALUES (29, 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2021-09-16 12:25:13', '', 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 = 11 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', '2021-09-16 12:25:13', '', NULL, '用户性别列表');
  INSERT INTO `sys_dict_type` VALUES (2, '菜单状态', 'sys_show_hide', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '菜单状态列表');
  INSERT INTO `sys_dict_type` VALUES (3, '系统开关', 'sys_normal_disable', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '系统开关列表');
  INSERT INTO `sys_dict_type` VALUES (4, '任务状态', 'sys_job_status', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '任务状态列表');
  INSERT INTO `sys_dict_type` VALUES (5, '任务分组', 'sys_job_group', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '任务分组列表');
  INSERT INTO `sys_dict_type` VALUES (6, '系统是否', 'sys_yes_no', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '系统是否列表');
  INSERT INTO `sys_dict_type` VALUES (7, '通知类型', 'sys_notice_type', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '通知类型列表');
  INSERT INTO `sys_dict_type` VALUES (8, '通知状态', 'sys_notice_status', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '通知状态列表');
  INSERT INTO `sys_dict_type` VALUES (9, '操作类型', 'sys_oper_type', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '操作类型列表');
  INSERT INTO `sys_dict_type` VALUES (10, '系统状态', 'sys_common_status', '0', 'admin', '2021-09-16 12:25:13', '', 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 = 4 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/10 * * * * ?', '3', '1', '1', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_job` VALUES (2, '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(\'ry\')', '0/15 * * * * ?', '3', '1', '1', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_job` VALUES (3, '系统默认（多参）', 'DEFAULT', 'ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', '2021-09-16 12:25:13', '', 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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '定时任务调度日志表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- 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',
    `login_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
  ) ENGINE = InnoDB AUTO_INCREMENT = 255 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 9', 'Windows 10', '0', '登录成功', '2021-09-16 12:26:38');
  INSERT INTO `sys_logininfor` VALUES (101, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-16 13:09:37');
  INSERT INTO `sys_logininfor` VALUES (102, 'lili', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '1', '验证码错误', '2021-09-16 13:09:49');
  INSERT INTO `sys_logininfor` VALUES (103, 'lili', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-16 13:09:54');
  INSERT INTO `sys_logininfor` VALUES (104, 'lili', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-16 13:12:53');
  INSERT INTO `sys_logininfor` VALUES (105, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-16 13:12:57');
  INSERT INTO `sys_logininfor` VALUES (106, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '1', '验证码错误', '2021-09-16 13:31:16');
  INSERT INTO `sys_logininfor` VALUES (107, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-16 13:31:21');
  INSERT INTO `sys_logininfor` VALUES (108, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-16 13:38:58');
  INSERT INTO `sys_logininfor` VALUES (109, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-16 13:43:32');
  INSERT INTO `sys_logininfor` VALUES (110, 'lili', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-16 13:43:40');
  INSERT INTO `sys_logininfor` VALUES (111, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-16 13:50:59');
  INSERT INTO `sys_logininfor` VALUES (112, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-16 13:52:58');
  INSERT INTO `sys_logininfor` VALUES (113, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-16 14:16:41');
  INSERT INTO `sys_logininfor` VALUES (114, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-16 20:12:30');
  INSERT INTO `sys_logininfor` VALUES (115, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-16 20:36:28');
  INSERT INTO `sys_logininfor` VALUES (116, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-17 18:49:14');
  INSERT INTO `sys_logininfor` VALUES (117, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-17 18:56:31');
  INSERT INTO `sys_logininfor` VALUES (118, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-17 18:57:27');
  INSERT INTO `sys_logininfor` VALUES (119, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-17 19:01:28');
  INSERT INTO `sys_logininfor` VALUES (120, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-17 19:15:35');
  INSERT INTO `sys_logininfor` VALUES (121, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-17 19:15:44');
  INSERT INTO `sys_logininfor` VALUES (122, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-17 19:15:57');
  INSERT INTO `sys_logininfor` VALUES (123, 'user', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-17 19:16:04');
  INSERT INTO `sys_logininfor` VALUES (124, 'user', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-17 19:16:10');
  INSERT INTO `sys_logininfor` VALUES (125, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-17 19:16:15');
  INSERT INTO `sys_logininfor` VALUES (126, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-17 19:20:33');
  INSERT INTO `sys_logininfor` VALUES (127, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-17 19:20:36');
  INSERT INTO `sys_logininfor` VALUES (128, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-17 19:20:49');
  INSERT INTO `sys_logininfor` VALUES (129, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-17 19:21:22');
  INSERT INTO `sys_logininfor` VALUES (130, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-17 20:24:39');
  INSERT INTO `sys_logininfor` VALUES (131, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-17 20:52:24');
  INSERT INTO `sys_logininfor` VALUES (132, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '1', '验证码错误', '2021-09-17 20:54:27');
  INSERT INTO `sys_logininfor` VALUES (133, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-17 20:54:30');
  INSERT INTO `sys_logininfor` VALUES (134, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-17 21:04:10');
  INSERT INTO `sys_logininfor` VALUES (135, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-17 21:37:22');
  INSERT INTO `sys_logininfor` VALUES (136, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-17 21:38:38');
  INSERT INTO `sys_logininfor` VALUES (137, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-17 22:01:20');
  INSERT INTO `sys_logininfor` VALUES (138, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-18 07:58:10');
  INSERT INTO `sys_logininfor` VALUES (139, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-18 07:58:21');
  INSERT INTO `sys_logininfor` VALUES (140, 'user', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-18 07:58:28');
  INSERT INTO `sys_logininfor` VALUES (141, 'user', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-18 07:58:43');
  INSERT INTO `sys_logininfor` VALUES (142, 'user', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-18 08:00:00');
  INSERT INTO `sys_logininfor` VALUES (143, 'user', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-18 08:02:00');
  INSERT INTO `sys_logininfor` VALUES (144, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-18 08:02:14');
  INSERT INTO `sys_logininfor` VALUES (145, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-18 08:20:28');
  INSERT INTO `sys_logininfor` VALUES (146, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-18 08:47:53');
  INSERT INTO `sys_logininfor` VALUES (147, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-18 08:47:59');
  INSERT INTO `sys_logininfor` VALUES (148, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-18 09:35:54');
  INSERT INTO `sys_logininfor` VALUES (149, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-18 10:43:34');
  INSERT INTO `sys_logininfor` VALUES (150, 'user', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '1', '验证码错误', '2021-09-18 10:49:42');
  INSERT INTO `sys_logininfor` VALUES (151, 'user', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-18 10:49:46');
  INSERT INTO `sys_logininfor` VALUES (152, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '1', '验证码错误', '2021-09-26 19:13:04');
  INSERT INTO `sys_logininfor` VALUES (153, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 19:13:08');
  INSERT INTO `sys_logininfor` VALUES (154, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-26 19:13:32');
  INSERT INTO `sys_logininfor` VALUES (155, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 19:13:38');
  INSERT INTO `sys_logininfor` VALUES (156, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-26 19:15:36');
  INSERT INTO `sys_logininfor` VALUES (157, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 19:15:40');
  INSERT INTO `sys_logininfor` VALUES (158, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 19:33:52');
  INSERT INTO `sys_logininfor` VALUES (159, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 19:48:36');
  INSERT INTO `sys_logininfor` VALUES (160, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 20:02:30');
  INSERT INTO `sys_logininfor` VALUES (161, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 20:04:11');
  INSERT INTO `sys_logininfor` VALUES (162, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 20:06:33');
  INSERT INTO `sys_logininfor` VALUES (163, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 20:10:25');
  INSERT INTO `sys_logininfor` VALUES (164, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 20:17:01');
  INSERT INTO `sys_logininfor` VALUES (165, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '1', '验证码错误', '2021-09-26 20:28:12');
  INSERT INTO `sys_logininfor` VALUES (166, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 20:28:14');
  INSERT INTO `sys_logininfor` VALUES (167, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 21:07:35');
  INSERT INTO `sys_logininfor` VALUES (168, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 21:09:09');
  INSERT INTO `sys_logininfor` VALUES (169, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 21:12:42');
  INSERT INTO `sys_logininfor` VALUES (170, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 21:13:51');
  INSERT INTO `sys_logininfor` VALUES (171, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 21:16:20');
  INSERT INTO `sys_logininfor` VALUES (172, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 21:18:31');
  INSERT INTO `sys_logininfor` VALUES (173, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 21:30:55');
  INSERT INTO `sys_logininfor` VALUES (174, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 21:32:20');
  INSERT INTO `sys_logininfor` VALUES (175, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 21:39:27');
  INSERT INTO `sys_logininfor` VALUES (176, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 21:50:23');
  INSERT INTO `sys_logininfor` VALUES (177, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 21:52:29');
  INSERT INTO `sys_logininfor` VALUES (178, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 21:54:14');
  INSERT INTO `sys_logininfor` VALUES (179, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-26 21:55:55');
  INSERT INTO `sys_logininfor` VALUES (180, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-27 08:11:59');
  INSERT INTO `sys_logininfor` VALUES (181, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-27 08:16:40');
  INSERT INTO `sys_logininfor` VALUES (182, 'user', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-27 08:16:45');
  INSERT INTO `sys_logininfor` VALUES (183, 'user', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-27 08:22:16');
  INSERT INTO `sys_logininfor` VALUES (184, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-27 08:22:18');
  INSERT INTO `sys_logininfor` VALUES (185, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-27 08:33:50');
  INSERT INTO `sys_logininfor` VALUES (186, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-27 09:02:25');
  INSERT INTO `sys_logininfor` VALUES (187, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-27 09:02:30');
  INSERT INTO `sys_logininfor` VALUES (188, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-27 09:13:08');
  INSERT INTO `sys_logininfor` VALUES (189, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-27 09:13:49');
  INSERT INTO `sys_logininfor` VALUES (190, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-27 09:37:42');
  INSERT INTO `sys_logininfor` VALUES (191, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-27 10:00:25');
  INSERT INTO `sys_logininfor` VALUES (192, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-27 10:00:31');
  INSERT INTO `sys_logininfor` VALUES (193, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-27 10:03:14');
  INSERT INTO `sys_logininfor` VALUES (194, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-27 10:03:17');
  INSERT INTO `sys_logininfor` VALUES (195, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-09-27 10:03:31');
  INSERT INTO `sys_logininfor` VALUES (196, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-27 10:03:38');
  INSERT INTO `sys_logininfor` VALUES (197, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-09-27 21:40:32');
  INSERT INTO `sys_logininfor` VALUES (198, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-08 22:08:01');
  INSERT INTO `sys_logininfor` VALUES (199, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-09 20:25:05');
  INSERT INTO `sys_logininfor` VALUES (200, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-09 21:08:57');
  INSERT INTO `sys_logininfor` VALUES (201, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-10-09 21:09:31');
  INSERT INTO `sys_logininfor` VALUES (202, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-09 21:09:34');
  INSERT INTO `sys_logininfor` VALUES (203, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-10-09 21:09:52');
  INSERT INTO `sys_logininfor` VALUES (204, 'user', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-09 21:09:56');
  INSERT INTO `sys_logininfor` VALUES (205, 'user', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-10-09 21:10:48');
  INSERT INTO `sys_logininfor` VALUES (206, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-09 21:10:53');
  INSERT INTO `sys_logininfor` VALUES (207, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-11 08:05:14');
  INSERT INTO `sys_logininfor` VALUES (208, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-11 10:36:49');
  INSERT INTO `sys_logininfor` VALUES (209, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '1', '验证码错误', '2021-10-11 10:42:27');
  INSERT INTO `sys_logininfor` VALUES (210, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-11 10:42:29');
  INSERT INTO `sys_logininfor` VALUES (211, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-11 11:02:20');
  INSERT INTO `sys_logininfor` VALUES (212, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-11 13:30:27');
  INSERT INTO `sys_logininfor` VALUES (213, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '1', '验证码错误', '2021-10-11 13:32:53');
  INSERT INTO `sys_logininfor` VALUES (214, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-11 13:32:55');
  INSERT INTO `sys_logininfor` VALUES (215, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-11 13:51:04');
  INSERT INTO `sys_logininfor` VALUES (216, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-11 13:59:59');
  INSERT INTO `sys_logininfor` VALUES (217, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-11 14:02:55');
  INSERT INTO `sys_logininfor` VALUES (218, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-11 14:04:38');
  INSERT INTO `sys_logininfor` VALUES (219, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-11 14:05:31');
  INSERT INTO `sys_logininfor` VALUES (220, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-11 14:09:35');
  INSERT INTO `sys_logininfor` VALUES (221, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-11 14:16:03');
  INSERT INTO `sys_logininfor` VALUES (222, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-11 14:21:09');
  INSERT INTO `sys_logininfor` VALUES (223, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 13:27:25');
  INSERT INTO `sys_logininfor` VALUES (224, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 13:52:02');
  INSERT INTO `sys_logininfor` VALUES (225, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 14:01:52');
  INSERT INTO `sys_logininfor` VALUES (226, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 14:23:18');
  INSERT INTO `sys_logininfor` VALUES (227, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 14:28:15');
  INSERT INTO `sys_logininfor` VALUES (228, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 14:31:01');
  INSERT INTO `sys_logininfor` VALUES (229, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 14:32:07');
  INSERT INTO `sys_logininfor` VALUES (230, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 14:33:00');
  INSERT INTO `sys_logininfor` VALUES (231, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 14:51:41');
  INSERT INTO `sys_logininfor` VALUES (232, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 14:56:09');
  INSERT INTO `sys_logininfor` VALUES (233, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 14:56:57');
  INSERT INTO `sys_logininfor` VALUES (234, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 15:16:45');
  INSERT INTO `sys_logininfor` VALUES (235, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 15:17:54');
  INSERT INTO `sys_logininfor` VALUES (236, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 15:27:37');
  INSERT INTO `sys_logininfor` VALUES (237, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-10-16 15:37:30');
  INSERT INTO `sys_logininfor` VALUES (238, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 15:37:35');
  INSERT INTO `sys_logininfor` VALUES (239, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-10-16 15:38:09');
  INSERT INTO `sys_logininfor` VALUES (240, 'user', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 15:38:22');
  INSERT INTO `sys_logininfor` VALUES (241, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 15:38:30');
  INSERT INTO `sys_logininfor` VALUES (242, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-10-16 15:38:35');
  INSERT INTO `sys_logininfor` VALUES (243, 'user', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 15:38:40');
  INSERT INTO `sys_logininfor` VALUES (244, 'user', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-10-16 15:39:46');
  INSERT INTO `sys_logininfor` VALUES (245, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 15:39:52');
  INSERT INTO `sys_logininfor` VALUES (246, 'parking', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-10-16 15:40:33');
  INSERT INTO `sys_logininfor` VALUES (247, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 15:40:37');
  INSERT INTO `sys_logininfor` VALUES (248, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-10-16 15:41:23');
  INSERT INTO `sys_logininfor` VALUES (249, 'user', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 15:41:28');
  INSERT INTO `sys_logininfor` VALUES (250, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 15:45:23');
  INSERT INTO `sys_logininfor` VALUES (251, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '退出成功', '2021-10-16 15:45:32');
  INSERT INTO `sys_logininfor` VALUES (252, 'user', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-16 15:45:38');
  INSERT INTO `sys_logininfor` VALUES (253, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-18 07:57:30');
  INSERT INTO `sys_logininfor` VALUES (254, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2021-10-18 08:17:25');
  
  -- ----------------------------
  -- 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 '显示顺序',
    `url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '#' COMMENT '请求地址',
    `target` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '打开方式（menuItem页签 menuBlank新窗口）',
    `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隐藏）',
    `is_refresh` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' 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 = 2031 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单权限表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of sys_menu
  -- ----------------------------
  INSERT INTO `sys_menu` VALUES (1, '系统管理', 0, 1, '#', '', 'M', '0', '1', '', 'fa fa-gear', 'admin', '2021-09-16 12:25:13', '', NULL, '系统管理目录');
  INSERT INTO `sys_menu` VALUES (2, '系统监控', 0, 2, '#', '', 'M', '0', '1', '', 'fa fa-video-camera', 'admin', '2021-09-16 12:25:13', '', NULL, '系统监控目录');
  INSERT INTO `sys_menu` VALUES (3, '系统工具', 0, 3, '#', '', 'M', '0', '1', '', 'fa fa-bars', 'admin', '2021-09-16 12:25:13', '', NULL, '系统工具目录');
  INSERT INTO `sys_menu` VALUES (4, '若依官网', 0, 4, '/test/returnimage', 'menuBlank', 'C', '0', '1', '', 'fa fa-location-arrow', 'admin', '2021-09-16 12:25:13', 'admin', '2021-10-11 10:37:06', '若依官网地址');
  INSERT INTO `sys_menu` VALUES (100, '用户管理', 2025, 1, '/system/user', 'menuItem', 'C', '0', '1', 'system:user:view', 'fa fa-user-o', 'admin', '2021-09-16 12:25:13', 'admin', '2021-09-17 19:04:55', '用户管理菜单');
  INSERT INTO `sys_menu` VALUES (101, '角色管理', 1, 2, '/system/role', '', 'C', '0', '1', 'system:role:view', 'fa fa-user-secret', 'admin', '2021-09-16 12:25:13', '', NULL, '角色管理菜单');
  INSERT INTO `sys_menu` VALUES (102, '菜单管理', 1, 3, '/system/menu', '', 'C', '0', '1', 'system:menu:view', 'fa fa-th-list', 'admin', '2021-09-16 12:25:13', '', NULL, '菜单管理菜单');
  INSERT INTO `sys_menu` VALUES (103, '部门管理', 2025, 4, '/system/dept', 'menuItem', 'C', '0', '1', 'system:dept:view', 'fa fa-outdent', 'admin', '2021-09-16 12:25:13', 'admin', '2021-09-17 19:05:35', '部门管理菜单');
  INSERT INTO `sys_menu` VALUES (104, '岗位管理', 2025, 5, '/system/post', 'menuItem', 'C', '0', '1', 'system:post:view', 'fa fa-address-card-o', 'admin', '2021-09-16 12:25:13', 'admin', '2021-09-17 19:05:57', '岗位管理菜单');
  INSERT INTO `sys_menu` VALUES (105, '字典管理', 1, 6, '/system/dict', '', 'C', '0', '1', 'system:dict:view', 'fa fa-bookmark-o', 'admin', '2021-09-16 12:25:13', '', NULL, '字典管理菜单');
  INSERT INTO `sys_menu` VALUES (106, '参数设置', 1, 7, '/system/config', '', 'C', '0', '1', 'system:config:view', 'fa fa-sun-o', 'admin', '2021-09-16 12:25:13', '', NULL, '参数设置菜单');
  INSERT INTO `sys_menu` VALUES (107, '通知公告', 1, 8, '/system/notice', '', 'C', '0', '1', 'system:notice:view', 'fa fa-bullhorn', 'admin', '2021-09-16 12:25:13', '', NULL, '通知公告菜单');
  INSERT INTO `sys_menu` VALUES (108, '日志管理', 1, 9, '#', '', 'M', '0', '1', '', 'fa fa-pencil-square-o', 'admin', '2021-09-16 12:25:13', '', NULL, '日志管理菜单');
  INSERT INTO `sys_menu` VALUES (109, '在线用户', 2, 1, '/monitor/online', '', 'C', '0', '1', 'monitor:online:view', 'fa fa-user-circle', 'admin', '2021-09-16 12:25:13', '', NULL, '在线用户菜单');
  INSERT INTO `sys_menu` VALUES (110, '定时任务', 2, 2, '/monitor/job', '', 'C', '0', '1', 'monitor:job:view', 'fa fa-tasks', 'admin', '2021-09-16 12:25:13', '', NULL, '定时任务菜单');
  INSERT INTO `sys_menu` VALUES (111, '数据监控', 2, 3, '/monitor/data', '', 'C', '0', '1', 'monitor:data:view', 'fa fa-bug', 'admin', '2021-09-16 12:25:13', '', NULL, '数据监控菜单');
  INSERT INTO `sys_menu` VALUES (112, '服务监控', 2, 4, '/monitor/server', '', 'C', '0', '1', 'monitor:server:view', 'fa fa-server', 'admin', '2021-09-16 12:25:13', '', NULL, '服务监控菜单');
  INSERT INTO `sys_menu` VALUES (113, '缓存监控', 2, 5, '/monitor/cache', '', 'C', '0', '1', 'monitor:cache:view', 'fa fa-cube', 'admin', '2021-09-16 12:25:13', '', NULL, '缓存监控菜单');
  INSERT INTO `sys_menu` VALUES (114, '表单构建', 3, 1, '/tool/build', '', 'C', '0', '1', 'tool:build:view', 'fa fa-wpforms', 'admin', '2021-09-16 12:25:13', '', NULL, '表单构建菜单');
  INSERT INTO `sys_menu` VALUES (115, '代码生成', 3, 2, '/tool/gen', '', 'C', '0', '1', 'tool:gen:view', 'fa fa-code', 'admin', '2021-09-16 12:25:13', '', NULL, '代码生成菜单');
  INSERT INTO `sys_menu` VALUES (116, '系统接口', 3, 3, '/tool/swagger', '', 'C', '0', '1', 'tool:swagger:view', 'fa fa-gg', 'admin', '2021-09-16 12:25:13', '', NULL, '系统接口菜单');
  INSERT INTO `sys_menu` VALUES (500, '操作日志', 108, 1, '/monitor/operlog', '', 'C', '0', '1', 'monitor:operlog:view', 'fa fa-address-book', 'admin', '2021-09-16 12:25:13', '', NULL, '操作日志菜单');
  INSERT INTO `sys_menu` VALUES (501, '登录日志', 108, 2, '/monitor/logininfor', '', 'C', '0', '1', 'monitor:logininfor:view', 'fa fa-file-image-o', 'admin', '2021-09-16 12:25:13', '', NULL, '登录日志菜单');
  INSERT INTO `sys_menu` VALUES (1000, '用户查询', 100, 1, '#', '', 'F', '0', '1', 'system:user:list', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1001, '用户新增', 100, 2, '#', '', 'F', '0', '1', 'system:user:add', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1002, '用户修改', 100, 3, '#', '', 'F', '0', '1', 'system:user:edit', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1003, '用户删除', 100, 4, '#', '', 'F', '0', '1', 'system:user:remove', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1004, '用户导出', 100, 5, '#', '', 'F', '0', '1', 'system:user:export', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1005, '用户导入', 100, 6, '#', '', 'F', '0', '1', 'system:user:import', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1006, '重置密码', 100, 7, '#', '', 'F', '0', '1', 'system:user:resetPwd', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1007, '角色查询', 101, 1, '#', '', 'F', '0', '1', 'system:role:list', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1008, '角色新增', 101, 2, '#', '', 'F', '0', '1', 'system:role:add', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1009, '角色修改', 101, 3, '#', '', 'F', '0', '1', 'system:role:edit', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1010, '角色删除', 101, 4, '#', '', 'F', '0', '1', 'system:role:remove', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1011, '角色导出', 101, 5, '#', '', 'F', '0', '1', 'system:role:export', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1012, '菜单查询', 102, 1, '#', '', 'F', '0', '1', 'system:menu:list', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1013, '菜单新增', 102, 2, '#', '', 'F', '0', '1', 'system:menu:add', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1014, '菜单修改', 102, 3, '#', '', 'F', '0', '1', 'system:menu:edit', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1015, '菜单删除', 102, 4, '#', '', 'F', '0', '1', 'system:menu:remove', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1016, '部门查询', 103, 1, '#', '', 'F', '0', '1', 'system:dept:list', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1017, '部门新增', 103, 2, '#', '', 'F', '0', '1', 'system:dept:add', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1018, '部门修改', 103, 3, '#', '', 'F', '0', '1', 'system:dept:edit', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1019, '部门删除', 103, 4, '#', '', 'F', '0', '1', 'system:dept:remove', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1020, '岗位查询', 104, 1, '#', '', 'F', '0', '1', 'system:post:list', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1021, '岗位新增', 104, 2, '#', '', 'F', '0', '1', 'system:post:add', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1022, '岗位修改', 104, 3, '#', '', 'F', '0', '1', 'system:post:edit', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1023, '岗位删除', 104, 4, '#', '', 'F', '0', '1', 'system:post:remove', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1024, '岗位导出', 104, 5, '#', '', 'F', '0', '1', 'system:post:export', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1025, '字典查询', 105, 1, '#', '', 'F', '0', '1', 'system:dict:list', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1026, '字典新增', 105, 2, '#', '', 'F', '0', '1', 'system:dict:add', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1027, '字典修改', 105, 3, '#', '', 'F', '0', '1', 'system:dict:edit', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1028, '字典删除', 105, 4, '#', '', 'F', '0', '1', 'system:dict:remove', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1029, '字典导出', 105, 5, '#', '', 'F', '0', '1', 'system:dict:export', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1030, '参数查询', 106, 1, '#', '', 'F', '0', '1', 'system:config:list', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1031, '参数新增', 106, 2, '#', '', 'F', '0', '1', 'system:config:add', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1032, '参数修改', 106, 3, '#', '', 'F', '0', '1', 'system:config:edit', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1033, '参数删除', 106, 4, '#', '', 'F', '0', '1', 'system:config:remove', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1034, '参数导出', 106, 5, '#', '', 'F', '0', '1', 'system:config:export', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1035, '公告查询', 107, 1, '#', '', 'F', '0', '1', 'system:notice:list', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1036, '公告新增', 107, 2, '#', '', 'F', '0', '1', 'system:notice:add', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1037, '公告修改', 107, 3, '#', '', 'F', '0', '1', 'system:notice:edit', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1038, '公告删除', 107, 4, '#', '', 'F', '0', '1', 'system:notice:remove', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1039, '操作查询', 500, 1, '#', '', 'F', '0', '1', 'monitor:operlog:list', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1040, '操作删除', 500, 2, '#', '', 'F', '0', '1', 'monitor:operlog:remove', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1041, '详细信息', 500, 3, '#', '', 'F', '0', '1', 'monitor:operlog:detail', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1042, '日志导出', 500, 4, '#', '', 'F', '0', '1', 'monitor:operlog:export', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1043, '登录查询', 501, 1, '#', '', 'F', '0', '1', 'monitor:logininfor:list', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1044, '登录删除', 501, 2, '#', '', 'F', '0', '1', 'monitor:logininfor:remove', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1045, '日志导出', 501, 3, '#', '', 'F', '0', '1', 'monitor:logininfor:export', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1046, '账户解锁', 501, 4, '#', '', 'F', '0', '1', 'monitor:logininfor:unlock', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1047, '在线查询', 109, 1, '#', '', 'F', '0', '1', 'monitor:online:list', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1048, '批量强退', 109, 2, '#', '', 'F', '0', '1', 'monitor:online:batchForceLogout', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1049, '单条强退', 109, 3, '#', '', 'F', '0', '1', 'monitor:online:forceLogout', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1050, '任务查询', 110, 1, '#', '', 'F', '0', '1', 'monitor:job:list', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1051, '任务新增', 110, 2, '#', '', 'F', '0', '1', 'monitor:job:add', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1052, '任务修改', 110, 3, '#', '', 'F', '0', '1', 'monitor:job:edit', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1053, '任务删除', 110, 4, '#', '', 'F', '0', '1', 'monitor:job:remove', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1054, '状态修改', 110, 5, '#', '', 'F', '0', '1', 'monitor:job:changeStatus', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1055, '任务详细', 110, 6, '#', '', 'F', '0', '1', 'monitor:job:detail', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1056, '任务导出', 110, 7, '#', '', 'F', '0', '1', 'monitor:job:export', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1057, '生成查询', 115, 1, '#', '', 'F', '0', '1', 'tool:gen:list', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1058, '生成修改', 115, 2, '#', '', 'F', '0', '1', 'tool:gen:edit', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1059, '生成删除', 115, 3, '#', '', 'F', '0', '1', 'tool:gen:remove', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1060, '预览代码', 115, 4, '#', '', 'F', '0', '1', 'tool:gen:preview', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (1061, '生成代码', 115, 5, '#', '', 'F', '0', '1', 'tool:gen:code', '#', 'admin', '2021-09-16 12:25:13', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2000, '停车场管理', 0, 6, '#', 'menuItem', 'M', '0', '1', '', 'fa fa-automobile', 'admin', '2021-09-16 12:27:45', 'admin', '2021-09-17 19:04:08', '');
  INSERT INTO `sys_menu` VALUES (2001, '停车场', 3, 1, '/custom/parkinglot', 'menuItem', 'C', '1', '1', 'custom:parkinglot:view', '#', 'admin', '2021-09-16 13:33:30', 'admin', '2021-09-17 20:35:29', '停车场菜单');
  INSERT INTO `sys_menu` VALUES (2002, '停车场查询', 2001, 1, '#', '', 'F', '0', '1', 'custom:parkinglot:list', '#', 'admin', '2021-09-16 13:33:30', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2003, '停车场新增', 2001, 2, '#', '', 'F', '0', '1', 'custom:parkinglot:add', '#', 'admin', '2021-09-16 13:33:30', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2004, '停车场修改', 2001, 3, '#', '', 'F', '0', '1', 'custom:parkinglot:edit', '#', 'admin', '2021-09-16 13:33:30', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2005, '停车场删除', 2001, 4, '#', '', 'F', '0', '1', 'custom:parkinglot:remove', '#', 'admin', '2021-09-16 13:33:30', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2006, '停车场导出', 2001, 5, '#', '', 'F', '0', '1', 'custom:parkinglot:export', '#', 'admin', '2021-09-16 13:33:30', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2013, '模型信息管理', 2000, 2, '/custom/model', 'menuItem', 'C', '0', '1', 'custom:model:view', '#', 'admin', '2021-09-17 18:52:48', 'admin', '2021-09-17 19:02:43', '模型信息管理菜单');
  INSERT INTO `sys_menu` VALUES (2014, '模型信息管理查询', 2013, 1, '#', '', 'F', '0', '1', 'custom:model:list', '#', 'admin', '2021-09-17 18:52:48', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2015, '模型信息管理新增', 2013, 2, '#', '', 'F', '0', '1', 'custom:model:add', '#', 'admin', '2021-09-17 18:52:48', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2016, '模型信息管理修改', 2013, 3, '#', '', 'F', '0', '1', 'custom:model:edit', '#', 'admin', '2021-09-17 18:52:48', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2017, '模型信息管理删除', 2013, 4, '#', '', 'F', '0', '1', 'custom:model:remove', '#', 'admin', '2021-09-17 18:52:48', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2018, '模型信息管理导出', 2013, 5, '#', '', 'F', '0', '1', 'custom:model:export', '#', 'admin', '2021-09-17 18:52:48', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2019, '停车场信息管理', 2000, 1, '/custom/parkinglot', '', 'C', '0', '1', 'custom:parkinglot:view', '#', 'admin', '2021-09-17 18:53:04', '', NULL, '停车场信息管理菜单');
  INSERT INTO `sys_menu` VALUES (2020, '停车场信息管理查询', 2019, 1, '#', '', 'F', '0', '1', 'custom:parkinglot:list', '#', 'admin', '2021-09-17 18:53:04', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2021, '停车场信息管理新增', 2019, 2, '#', '', 'F', '0', '1', 'custom:parkinglot:add', '#', 'admin', '2021-09-17 18:53:04', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2022, '停车场信息管理修改', 2019, 3, '#', '', 'F', '0', '1', 'custom:parkinglot:edit', '#', 'admin', '2021-09-17 18:53:04', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2023, '停车场信息管理删除', 2019, 4, '#', '', 'F', '0', '1', 'custom:parkinglot:remove', '#', 'admin', '2021-09-17 18:53:04', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2024, '停车场信息管理导出', 2019, 5, '#', '', 'F', '0', '1', 'custom:parkinglot:export', '#', 'admin', '2021-09-17 18:53:04', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2025, '用户信息管理', 0, 5, '#', 'menuItem', 'M', '0', '1', '', 'fa fa-users', 'admin', '2021-09-17 19:04:02', 'admin', '2021-09-17 19:04:34', '');
  INSERT INTO `sys_menu` VALUES (2026, '停车场规模初始化', 2000, 3, '/custom/pinit', 'menuItem', 'C', '0', '1', 'custom:parkinglot:view', '#', 'admin', '2021-09-17 19:07:06', 'admin', '2021-10-16 13:54:36', '');
  INSERT INTO `sys_menu` VALUES (2027, '停车场识别模型初始化', 2026, 1, '#', 'menuItem', 'F', '0', '1', NULL, '#', 'admin', '2021-09-17 19:07:52', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2028, '车位识别模型初始化', 2026, 2, '#', 'menuItem', 'F', '0', '1', '', '#', 'admin', '2021-09-17 19:08:13', 'admin', '2021-09-17 19:08:28', '');
  INSERT INTO `sys_menu` VALUES (2029, '车位识别系统', 0, 7, '#', 'menuItem', 'M', '0', '1', NULL, 'fa fa-motorcycle', 'admin', '2021-09-17 19:11:53', '', NULL, '');
  INSERT INTO `sys_menu` VALUES (2030, '车位识别', 2029, 1, 'custom/pinit/predict', 'menuItem', 'C', '0', '1', 'custom:pinit:view', '#', 'admin', '2021-09-17 19:12:06', 'admin', '2021-10-16 14:52:15', '');
  
  -- ----------------------------
  -- 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` varchar(2000) 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关闭）',
    `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 = 11 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', '新版本内容', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '管理员');
  INSERT INTO `sys_notice` VALUES (2, '维护通知：2018-07-01 若依系统凌晨维护', '1', '维护内容', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '管理员');
  INSERT INTO `sys_notice` VALUES (10, 'test公告', '2', '<p><img src=\"http://localhost/profile/upload/2021/09/16/af7ba312-5a15-4d60-bfec-3b77637528c1.png\" style=\"width: 1164.66px;\" data-filename=\"/profile/upload/2021/09/16/af7ba312-5a15-4d60-bfec-3b77637528c1.png\"><br></p>', '0', 'admin', '2021-09-16 13:07:54', '', NULL, 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 '操作时间',
    PRIMARY KEY (`oper_id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 231 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '操作日志记录' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of sys_oper_log
  -- ----------------------------
  INSERT INTO `sys_oper_log` VALUES (100, '菜单管理', 1, 'com.ruoyi.web.controller.system.SysMenuController.addSave()', 'POST', 1, 'admin', '研发部门', '/system/menu/add', '127.0.0.1', '内网IP', '{\"parentId\":[\"0\"],\"menuType\":[\"M\"],\"menuName\":[\"停车场管理\"],\"url\":[\"\"],\"target\":[\"menuItem\"],\"perms\":[\"\"],\"orderNum\":[\"2\"],\"icon\":[\"fa fa-automobile\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 12:27:45');
  INSERT INTO `sys_oper_log` VALUES (101, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2000\"],\"parentId\":[\"0\"],\"menuType\":[\"M\"],\"menuName\":[\"停车场管理\"],\"url\":[\"#\"],\"target\":[\"menuItem\"],\"perms\":[\"\"],\"orderNum\":[\"1\"],\"icon\":[\"fa fa-automobile\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 12:28:04');
  INSERT INTO `sys_oper_log` VALUES (102, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', '研发部门', '/tool/gen/importTable', '127.0.0.1', '内网IP', '{\"tables\":[\"sys_user_role\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 12:55:50');
  INSERT INTO `sys_oper_log` VALUES (103, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.download()', 'GET', 1, 'admin', '研发部门', '/tool/gen/download/sys_user_role', '127.0.0.1', '内网IP', '\"sys_user_role\"', NULL, 0, NULL, '2021-09-16 12:56:52');
  INSERT INTO `sys_oper_log` VALUES (104, '代码生成', 3, 'com.ruoyi.generator.controller.GenController.remove()', 'POST', 1, 'admin', '研发部门', '/tool/gen/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 12:57:29');
  INSERT INTO `sys_oper_log` VALUES (105, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', '研发部门', '/tool/gen/importTable', '127.0.0.1', '内网IP', '{\"tables\":[\"cus_test\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 12:58:37');
  INSERT INTO `sys_oper_log` VALUES (106, '代码生成', 3, 'com.ruoyi.generator.controller.GenController.remove()', 'POST', 1, 'admin', '研发部门', '/tool/gen/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"2\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 12:59:09');
  INSERT INTO `sys_oper_log` VALUES (107, '通知公告', 1, 'com.ruoyi.web.controller.system.SysNoticeController.addSave()', 'POST', 1, 'admin', '研发部门', '/system/notice/add', '127.0.0.1', '内网IP', '{\"noticeTitle\":[\"test公告\"],\"noticeType\":[\"2\"],\"noticeContent\":[\"<p><img src=\\\"http://localhost/profile/upload/2021/09/16/af7ba312-5a15-4d60-bfec-3b77637528c1.png\\\" style=\\\"width: 1164.66px;\\\" data-filename=\\\"/profile/upload/2021/09/16/af7ba312-5a15-4d60-bfec-3b77637528c1.png\\\"><br></p>\"],\"status\":[\"0\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 13:07:54');
  INSERT INTO `sys_oper_log` VALUES (108, '用户管理', 1, 'com.ruoyi.web.controller.system.SysUserController.addSave()', 'POST', 1, 'admin', '研发部门', '/system/user/add', '127.0.0.1', '内网IP', '{\"deptId\":[\"\"],\"userName\":[\"lili\"],\"deptName\":[\"\"],\"phonenumber\":[\"\"],\"email\":[\"\"],\"loginName\":[\"lili\"],\"sex\":[\"0\"],\"role\":[\"2\"],\"remark\":[\"\"],\"status\":[\"0\"],\"roleIds\":[\"2\"],\"postIds\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 13:09:31');
  INSERT INTO `sys_oper_log` VALUES (109, '角色管理', 2, 'com.ruoyi.web.controller.system.SysRoleController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/role/edit', '127.0.0.1', '内网IP', '{\"roleId\":[\"2\"],\"roleName\":[\"普通角色\"],\"roleKey\":[\"common\"],\"roleSort\":[\"2\"],\"status\":[\"0\"],\"remark\":[\"普通角色\"],\"menuIds\":[\"4\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 13:13:22');
  INSERT INTO `sys_oper_log` VALUES (110, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', '研发部门', '/tool/gen/importTable', '127.0.0.1', '内网IP', '{\"tables\":[\"cus_model,cus_parkinglot\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 13:30:35');
  INSERT INTO `sys_oper_log` VALUES (111, '代码生成', 3, 'com.ruoyi.generator.controller.GenController.remove()', 'POST', 1, 'admin', '研发部门', '/tool/gen/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"3,4\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 13:31:46');
  INSERT INTO `sys_oper_log` VALUES (112, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', '研发部门', '/tool/gen/importTable', '127.0.0.1', '内网IP', '{\"tables\":[\"cus_parkinglot,cus_model\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 13:31:53');
  INSERT INTO `sys_oper_log` VALUES (113, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.download()', 'GET', 1, 'admin', '研发部门', '/tool/gen/download/cus_model', '127.0.0.1', '内网IP', '\"cus_model\"', NULL, 0, NULL, '2021-09-16 13:32:09');
  INSERT INTO `sys_oper_log` VALUES (114, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.download()', 'GET', 1, 'admin', '研发部门', '/tool/gen/download/cus_parkinglot', '127.0.0.1', '内网IP', '\"cus_parkinglot\"', NULL, 0, NULL, '2021-09-16 13:32:12');
  INSERT INTO `sys_oper_log` VALUES (115, '角色管理', 2, 'com.ruoyi.web.controller.system.SysRoleController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/role/edit', '127.0.0.1', '内网IP', '{\"roleId\":[\"2\"],\"roleName\":[\"普通角色\"],\"roleKey\":[\"common\"],\"roleSort\":[\"2\"],\"status\":[\"0\"],\"remark\":[\"普通角色\"],\"menuIds\":[\"3,2001,2002,2003,2004,2005,2006,4\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 13:43:24');
  INSERT INTO `sys_oper_log` VALUES (116, '停车场', 1, 'com.ruoyi.custom.controller.CusParkinglotController.addSave()', 'POST', 1, 'admin', '研发部门', '/custom/parkinglot/add', '127.0.0.1', '内网IP', '{\"userId\":[\"1\"],\"parkinglotName\":[\"第一停车场\"],\"parkinglotLoc\":[\"朝阳区\"],\"parkinglotCamera\":[\"\"],\"parkinglotCapacity\":[\"\"],\"parkinglotSpare\":[\"\"],\"image\":[\"\"],\"imageUpdate\":[\"\"],\"remark\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 13:54:05');
  INSERT INTO `sys_oper_log` VALUES (117, '代码生成', 3, 'com.ruoyi.generator.controller.GenController.remove()', 'POST', 1, 'admin', '研发部门', '/tool/gen/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"5,6\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 14:10:20');
  INSERT INTO `sys_oper_log` VALUES (118, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', '研发部门', '/tool/gen/importTable', '127.0.0.1', '内网IP', '{\"tables\":[\"cus_parkinglot,cus_model\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 14:10:30');
  INSERT INTO `sys_oper_log` VALUES (119, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'POST', 1, 'admin', '研发部门', '/tool/gen/edit', '127.0.0.1', '内网IP', '{\"tableId\":[\"8\"],\"tableName\":[\"cus_parkinglot\"],\"tableComment\":[\"停车场表\"],\"className\":[\"CusParkinglot\"],\"functionAuthor\":[\"kamiu\"],\"remark\":[\"\"],\"columns[5].columnId\":[\"42\"],\"columns[5].sort\":[\"1\"],\"columns[5].columnComment\":[\"停车场总车位\"],\"columns[5].javaType\":[\"Long\"],\"columns[5].javaField\":[\"parkinglotCapacity\"],\"columns[5].isInsert\":[\"1\"],\"columns[5].isEdit\":[\"1\"],\"columns[5].isList\":[\"1\"],\"columns[5].isQuery\":[\"1\"],\"columns[5].queryType\":[\"EQ\"],\"columns[5].htmlType\":[\"input\"],\"columns[5].dictType\":[\"\"],\"columns[0].columnId\":[\"37\"],\"columns[0].sort\":[\"2\"],\"columns[0].columnComment\":[\"停车场id\"],\"columns[0].javaType\":[\"Long\"],\"columns[0].javaField\":[\"parkinglotId\"],\"columns[0].isInsert\":[\"1\"],\"columns[0].queryType\":[\"EQ\"],\"columns[0].htmlType\":[\"input\"],\"columns[0].dictType\":[\"\"],\"columns[1].columnId\":[\"38\"],\"columns[1].sort\":[\"3\"],\"columns[1].columnComment\":[\"停车场所属管理员id\"],\"columns[1].javaType\":[\"Long\"],\"columns[1].javaField\":[\"userId\"],\"columns[1].isInsert\":[\"1\"],\"columns[1].isEdit\":[\"1\"],\"columns[1].isList\":[\"1\"],\"columns[1].isQuery\":[\"1\"],\"columns[1].queryType\":[\"EQ\"],\"columns[1].isRequired\":[\"1\"],\"columns[1].htmlType\":[\"input\"],\"columns[1].dictType\":[\"\"],\"columns[2].columnId\":[\"39\"],\"columns[2].sort\":[\"4\"],\"columns[2].columnComment\":[\"停车场名称\"],\"columns[2].javaType\":[\"String\"],\"columns[2].javaField\":[\"parkinglotName\"],\"columns[2].isInsert\":[\"1\"],\"columns[2].isEdit\":[\"1\"],\"columns[2].isList\":[\"1\"],\"columns[2].isQuery\":[\"1\"],\"columns[2].queryType\":[\"LIKE\"],\"columns[2].htmlType\":[\"input\"],\"columns[2].dictType\":[\"\"],\"columns[3].columnId\":[\"40\"],\"columns[3].sort\":[\"5\"],\"columns[3].columnComment\":[\"停车场位置\"],\"columns[3].javaType\":[\"String\"],\"columns[3].javaField\":[\"parkinglotLoc\"],\"columns[3].isInsert\":[\"1\"],\"columns[3].isEdit\":[\"1\"],\"columns[3].isList\":[\"1\"],\"columns[3].isQuery\":[\"1\"],\"columns[3].queryType\":[\"EQ\"],\"columns[3].htmlType\":[\"input\"],\"columns[3].dictType\":[\"\"],\"columns[4].columnId\":[\"41\"],\"columns[4].sort\":[\"6\"],\"columns[4].columnComment\":[\"摄像头图片文件位置\"],\"columns[4].', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 14:13:47');
  INSERT INTO `sys_oper_log` VALUES (120, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'POST', 1, 'admin', '研发部门', '/tool/gen/edit', '127.0.0.1', '内网IP', '{\"tableId\":[\"8\"],\"tableName\":[\"cus_parkinglot\"],\"tableComment\":[\"停车场表\"],\"className\":[\"CusParkinglot\"],\"functionAuthor\":[\"kamiu\"],\"remark\":[\"\"],\"columns[0].columnId\":[\"42\"],\"columns[0].sort\":[\"1\"],\"columns[0].columnComment\":[\"停车场总车位\"],\"columns[0].javaType\":[\"Long\"],\"columns[0].javaField\":[\"parkinglotCapacity\"],\"columns[0].isInsert\":[\"1\"],\"columns[0].isEdit\":[\"1\"],\"columns[0].isList\":[\"1\"],\"columns[0].isQuery\":[\"1\"],\"columns[0].queryType\":[\"EQ\"],\"columns[0].htmlType\":[\"input\"],\"columns[0].dictType\":[\"\"],\"columns[1].columnId\":[\"37\"],\"columns[1].sort\":[\"2\"],\"columns[1].columnComment\":[\"停车场id\"],\"columns[1].javaType\":[\"Long\"],\"columns[1].javaField\":[\"parkinglotId\"],\"columns[1].isInsert\":[\"1\"],\"columns[1].queryType\":[\"EQ\"],\"columns[1].htmlType\":[\"input\"],\"columns[1].dictType\":[\"\"],\"columns[2].columnId\":[\"38\"],\"columns[2].sort\":[\"3\"],\"columns[2].columnComment\":[\"停车场所属管理员id\"],\"columns[2].javaType\":[\"Long\"],\"columns[2].javaField\":[\"userId\"],\"columns[2].isInsert\":[\"1\"],\"columns[2].isEdit\":[\"1\"],\"columns[2].isList\":[\"1\"],\"columns[2].isQuery\":[\"1\"],\"columns[2].queryType\":[\"EQ\"],\"columns[2].isRequired\":[\"1\"],\"columns[2].htmlType\":[\"input\"],\"columns[2].dictType\":[\"\"],\"columns[3].columnId\":[\"39\"],\"columns[3].sort\":[\"4\"],\"columns[3].columnComment\":[\"停车场名称\"],\"columns[3].javaType\":[\"String\"],\"columns[3].javaField\":[\"parkinglotName\"],\"columns[3].isInsert\":[\"1\"],\"columns[3].isEdit\":[\"1\"],\"columns[3].isList\":[\"1\"],\"columns[3].isQuery\":[\"1\"],\"columns[3].queryType\":[\"LIKE\"],\"columns[3].htmlType\":[\"input\"],\"columns[3].dictType\":[\"\"],\"columns[4].columnId\":[\"40\"],\"columns[4].sort\":[\"5\"],\"columns[4].columnComment\":[\"停车场位置\"],\"columns[4].javaType\":[\"String\"],\"columns[4].javaField\":[\"parkinglotLoc\"],\"columns[4].isInsert\":[\"1\"],\"columns[4].isEdit\":[\"1\"],\"columns[4].isList\":[\"1\"],\"columns[4].isQuery\":[\"1\"],\"columns[4].queryType\":[\"EQ\"],\"columns[4].htmlType\":[\"input\"],\"columns[4].dictType\":[\"\"],\"columns[5].columnId\":[\"41\"],\"columns[5].sort\":[\"6\"],\"columns[5].columnComment\":[\"摄像头图片文件位置\"],\"columns[5].', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 14:14:22');
  INSERT INTO `sys_oper_log` VALUES (121, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.download()', 'GET', 1, 'admin', '研发部门', '/tool/gen/download/cus_parkinglot', '127.0.0.1', '内网IP', '\"cus_parkinglot\"', NULL, 0, NULL, '2021-09-16 14:14:28');
  INSERT INTO `sys_oper_log` VALUES (122, '停车场', 1, 'com.ruoyi.custom.controller.CusParkinglotController.addSave()', 'POST', 1, 'admin', '研发部门', '/custom/parkinglot/add', '127.0.0.1', '内网IP', '{\"parkinglotCapacity\":[\"\"],\"userId\":[\"1\"],\"parkinglotName\":[\"\"],\"parkinglotLoc\":[\"\"],\"remark\":[\"\"],\"index\":[\"1\"],\"cusModelList[0].sizeModel\":[\"\"],\"cusModelList[0].regModel\":[\"\"],\"btSelectAll\":[\"\"],\"btSelectItem\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-16 14:19:26');
  INSERT INTO `sys_oper_log` VALUES (123, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'POST', 1, 'admin', '研发部门', '/tool/gen/edit', '127.0.0.1', '内网IP', '{\"tableId\":[\"8\"],\"tableName\":[\"cus_parkinglot\"],\"tableComment\":[\"停车场表\"],\"className\":[\"CusParkinglot\"],\"functionAuthor\":[\"kamiu\"],\"remark\":[\"\"],\"columns[0].columnId\":[\"42\"],\"columns[0].sort\":[\"1\"],\"columns[0].columnComment\":[\"停车场总车位\"],\"columns[0].javaType\":[\"Long\"],\"columns[0].javaField\":[\"parkinglotCapacity\"],\"columns[0].isEdit\":[\"1\"],\"columns[0].isList\":[\"1\"],\"columns[0].isQuery\":[\"1\"],\"columns[0].queryType\":[\"EQ\"],\"columns[0].htmlType\":[\"input\"],\"columns[0].dictType\":[\"\"],\"columns[1].columnId\":[\"37\"],\"columns[1].sort\":[\"2\"],\"columns[1].columnComment\":[\"停车场id\"],\"columns[1].javaType\":[\"Long\"],\"columns[1].javaField\":[\"parkinglotId\"],\"columns[1].queryType\":[\"EQ\"],\"columns[1].htmlType\":[\"input\"],\"columns[1].dictType\":[\"\"],\"columns[2].columnId\":[\"38\"],\"columns[2].sort\":[\"3\"],\"columns[2].columnComment\":[\"停车场所属管理员id\"],\"columns[2].javaType\":[\"Long\"],\"columns[2].javaField\":[\"userId\"],\"columns[2].isInsert\":[\"1\"],\"columns[2].isEdit\":[\"1\"],\"columns[2].isList\":[\"1\"],\"columns[2].isQuery\":[\"1\"],\"columns[2].queryType\":[\"EQ\"],\"columns[2].isRequired\":[\"1\"],\"columns[2].htmlType\":[\"input\"],\"columns[2].dictType\":[\"\"],\"columns[3].columnId\":[\"39\"],\"columns[3].sort\":[\"4\"],\"columns[3].columnComment\":[\"停车场名称\"],\"columns[3].javaType\":[\"String\"],\"columns[3].javaField\":[\"parkinglotName\"],\"columns[3].isInsert\":[\"1\"],\"columns[3].isEdit\":[\"1\"],\"columns[3].isList\":[\"1\"],\"columns[3].isQuery\":[\"1\"],\"columns[3].queryType\":[\"LIKE\"],\"columns[3].isRequired\":[\"1\"],\"columns[3].htmlType\":[\"input\"],\"columns[3].dictType\":[\"\"],\"columns[4].columnId\":[\"40\"],\"columns[4].sort\":[\"5\"],\"columns[4].columnComment\":[\"停车场位置\"],\"columns[4].javaType\":[\"String\"],\"columns[4].javaField\":[\"parkinglotLoc\"],\"columns[4].isInsert\":[\"1\"],\"columns[4].isEdit\":[\"1\"],\"columns[4].isList\":[\"1\"],\"columns[4].isQuery\":[\"1\"],\"columns[4].queryType\":[\"LIKE\"],\"columns[4].isRequired\":[\"1\"],\"columns[4].htmlType\":[\"input\"],\"columns[4].dictType\":[\"\"],\"columns[5].columnId\":[\"41\"],\"columns[5].sort\":[\"6\"],\"columns[5].columnComment\":[\"摄像头图片文件位置\"],\"colum', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 18:51:05');
  INSERT INTO `sys_oper_log` VALUES (124, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'POST', 1, 'admin', '研发部门', '/tool/gen/edit', '127.0.0.1', '内网IP', '{\"tableId\":[\"8\"],\"tableName\":[\"cus_parkinglot\"],\"tableComment\":[\"停车场表\"],\"className\":[\"CusParkinglot\"],\"functionAuthor\":[\"kamiu\"],\"remark\":[\"\"],\"columns[0].columnId\":[\"42\"],\"columns[0].sort\":[\"1\"],\"columns[0].columnComment\":[\"停车场总车位\"],\"columns[0].javaType\":[\"Long\"],\"columns[0].javaField\":[\"parkinglotCapacity\"],\"columns[0].isEdit\":[\"1\"],\"columns[0].isList\":[\"1\"],\"columns[0].isQuery\":[\"1\"],\"columns[0].queryType\":[\"EQ\"],\"columns[0].htmlType\":[\"input\"],\"columns[0].dictType\":[\"\"],\"columns[1].columnId\":[\"37\"],\"columns[1].sort\":[\"2\"],\"columns[1].columnComment\":[\"停车场id\"],\"columns[1].javaType\":[\"Long\"],\"columns[1].javaField\":[\"parkinglotId\"],\"columns[1].queryType\":[\"EQ\"],\"columns[1].htmlType\":[\"input\"],\"columns[1].dictType\":[\"\"],\"columns[2].columnId\":[\"38\"],\"columns[2].sort\":[\"3\"],\"columns[2].columnComment\":[\"停车场所属管理员id\"],\"columns[2].javaType\":[\"Long\"],\"columns[2].javaField\":[\"userId\"],\"columns[2].isInsert\":[\"1\"],\"columns[2].isEdit\":[\"1\"],\"columns[2].isList\":[\"1\"],\"columns[2].isQuery\":[\"1\"],\"columns[2].queryType\":[\"EQ\"],\"columns[2].isRequired\":[\"1\"],\"columns[2].htmlType\":[\"input\"],\"columns[2].dictType\":[\"\"],\"columns[3].columnId\":[\"39\"],\"columns[3].sort\":[\"4\"],\"columns[3].columnComment\":[\"停车场名称\"],\"columns[3].javaType\":[\"String\"],\"columns[3].javaField\":[\"parkinglotName\"],\"columns[3].isInsert\":[\"1\"],\"columns[3].isEdit\":[\"1\"],\"columns[3].isList\":[\"1\"],\"columns[3].isQuery\":[\"1\"],\"columns[3].queryType\":[\"LIKE\"],\"columns[3].isRequired\":[\"1\"],\"columns[3].htmlType\":[\"input\"],\"columns[3].dictType\":[\"\"],\"columns[4].columnId\":[\"40\"],\"columns[4].sort\":[\"5\"],\"columns[4].columnComment\":[\"停车场位置\"],\"columns[4].javaType\":[\"String\"],\"columns[4].javaField\":[\"parkinglotLoc\"],\"columns[4].isInsert\":[\"1\"],\"columns[4].isEdit\":[\"1\"],\"columns[4].isList\":[\"1\"],\"columns[4].isQuery\":[\"1\"],\"columns[4].queryType\":[\"LIKE\"],\"columns[4].isRequired\":[\"1\"],\"columns[4].htmlType\":[\"input\"],\"columns[4].dictType\":[\"\"],\"columns[5].columnId\":[\"41\"],\"columns[5].sort\":[\"6\"],\"columns[5].columnComment\":[\"摄像头图片文件位置\"],\"colum', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 18:51:29');
  INSERT INTO `sys_oper_log` VALUES (125, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'POST', 1, 'admin', '研发部门', '/tool/gen/edit', '127.0.0.1', '内网IP', '{\"tableId\":[\"7\"],\"tableName\":[\"cus_model\"],\"tableComment\":[\"模型表\"],\"className\":[\"CusModel\"],\"functionAuthor\":[\"kamiu\"],\"remark\":[\"\"],\"columns[0].columnId\":[\"33\"],\"columns[0].sort\":[\"1\"],\"columns[0].columnComment\":[\"模型id\"],\"columns[0].javaType\":[\"Long\"],\"columns[0].javaField\":[\"modelId\"],\"columns[0].queryType\":[\"EQ\"],\"columns[0].htmlType\":[\"input\"],\"columns[0].dictType\":[\"\"],\"columns[1].columnId\":[\"34\"],\"columns[1].sort\":[\"2\"],\"columns[1].columnComment\":[\"停车场id\"],\"columns[1].javaType\":[\"Long\"],\"columns[1].javaField\":[\"parkinglotId\"],\"columns[1].isInsert\":[\"1\"],\"columns[1].isEdit\":[\"1\"],\"columns[1].isList\":[\"1\"],\"columns[1].isQuery\":[\"1\"],\"columns[1].queryType\":[\"EQ\"],\"columns[1].isRequired\":[\"1\"],\"columns[1].htmlType\":[\"input\"],\"columns[1].dictType\":[\"\"],\"columns[2].columnId\":[\"35\"],\"columns[2].sort\":[\"3\"],\"columns[2].columnComment\":[\"规模模型位置\"],\"columns[2].javaType\":[\"String\"],\"columns[2].javaField\":[\"sizeModel\"],\"columns[2].isInsert\":[\"1\"],\"columns[2].isEdit\":[\"1\"],\"columns[2].isList\":[\"1\"],\"columns[2].isQuery\":[\"1\"],\"columns[2].queryType\":[\"EQ\"],\"columns[2].htmlType\":[\"input\"],\"columns[2].dictType\":[\"\"],\"columns[3].columnId\":[\"36\"],\"columns[3].sort\":[\"4\"],\"columns[3].columnComment\":[\"识别模型位置\"],\"columns[3].javaType\":[\"String\"],\"columns[3].javaField\":[\"regModel\"],\"columns[3].isInsert\":[\"1\"],\"columns[3].isEdit\":[\"1\"],\"columns[3].isList\":[\"1\"],\"columns[3].isQuery\":[\"1\"],\"columns[3].queryType\":[\"EQ\"],\"columns[3].htmlType\":[\"input\"],\"columns[3].dictType\":[\"\"],\"tplCategory\":[\"crud\"],\"packageName\":[\"com.ruoyi.custom\"],\"moduleName\":[\"custom\"],\"businessName\":[\"model\"],\"functionName\":[\"模型信息管理\"],\"params[parentMenuId]\":[\"2000\"],\"params[parentMenuName]\":[\"停车场管理\"],\"genType\":[\"0\"],\"genPath\":[\"/\"],\"subTableName\":[\"\"],\"params[treeCode]\":[\"\"],\"params[treeParentCode]\":[\"\"],\"params[treeName]\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 18:52:07');
  INSERT INTO `sys_oper_log` VALUES (126, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.download()', 'GET', 1, 'admin', '研发部门', '/tool/gen/download/cus_model', '127.0.0.1', '内网IP', '\"cus_model\"', NULL, 0, NULL, '2021-09-17 18:52:11');
  INSERT INTO `sys_oper_log` VALUES (127, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.download()', 'GET', 1, 'admin', '研发部门', '/tool/gen/download/cus_parkinglot', '127.0.0.1', '内网IP', '\"cus_parkinglot\"', NULL, 0, NULL, '2021-09-17 18:52:13');
  INSERT INTO `sys_oper_log` VALUES (128, '菜单管理', 3, 'com.ruoyi.web.controller.system.SysMenuController.remove()', 'GET', 1, 'admin', '研发部门', '/system/menu/remove/2007', '127.0.0.1', '内网IP', '2007', '{\"msg\":\"存在子菜单,不允许删除\",\"code\":301}', 0, NULL, '2021-09-17 19:01:58');
  INSERT INTO `sys_oper_log` VALUES (129, '菜单管理', 3, 'com.ruoyi.web.controller.system.SysMenuController.remove()', 'GET', 1, 'admin', '研发部门', '/system/menu/remove/2008', '127.0.0.1', '内网IP', '2008', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:02:07');
  INSERT INTO `sys_oper_log` VALUES (130, '菜单管理', 3, 'com.ruoyi.web.controller.system.SysMenuController.remove()', 'GET', 1, 'admin', '研发部门', '/system/menu/remove/2009', '127.0.0.1', '内网IP', '2009', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:02:16');
  INSERT INTO `sys_oper_log` VALUES (131, '菜单管理', 3, 'com.ruoyi.web.controller.system.SysMenuController.remove()', 'GET', 1, 'admin', '研发部门', '/system/menu/remove/2010', '127.0.0.1', '内网IP', '2010', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:02:20');
  INSERT INTO `sys_oper_log` VALUES (132, '菜单管理', 3, 'com.ruoyi.web.controller.system.SysMenuController.remove()', 'GET', 1, 'admin', '研发部门', '/system/menu/remove/2011', '127.0.0.1', '内网IP', '2011', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:02:25');
  INSERT INTO `sys_oper_log` VALUES (133, '菜单管理', 3, 'com.ruoyi.web.controller.system.SysMenuController.remove()', 'GET', 1, 'admin', '研发部门', '/system/menu/remove/2012', '127.0.0.1', '内网IP', '2012', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:02:30');
  INSERT INTO `sys_oper_log` VALUES (134, '菜单管理', 3, 'com.ruoyi.web.controller.system.SysMenuController.remove()', 'GET', 1, 'admin', '研发部门', '/system/menu/remove/2007', '127.0.0.1', '内网IP', '2007', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:02:35');
  INSERT INTO `sys_oper_log` VALUES (135, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2013\"],\"parentId\":[\"2000\"],\"menuType\":[\"C\"],\"menuName\":[\"模型信息管理\"],\"url\":[\"/custom/model\"],\"target\":[\"menuItem\"],\"perms\":[\"custom:model:view\"],\"orderNum\":[\"2\"],\"icon\":[\"#\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:02:43');
  INSERT INTO `sys_oper_log` VALUES (136, '菜单管理', 1, 'com.ruoyi.web.controller.system.SysMenuController.addSave()', 'POST', 1, 'admin', '研发部门', '/system/menu/add', '127.0.0.1', '内网IP', '{\"parentId\":[\"0\"],\"menuType\":[\"M\"],\"menuName\":[\"用户信息管理\"],\"url\":[\"\"],\"target\":[\"menuItem\"],\"perms\":[\"\"],\"orderNum\":[\"5\"],\"icon\":[\"\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:04:02');
  INSERT INTO `sys_oper_log` VALUES (137, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2000\"],\"parentId\":[\"0\"],\"menuType\":[\"M\"],\"menuName\":[\"停车场管理\"],\"url\":[\"#\"],\"target\":[\"menuItem\"],\"perms\":[\"\"],\"orderNum\":[\"6\"],\"icon\":[\"fa fa-automobile\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:04:08');
  INSERT INTO `sys_oper_log` VALUES (138, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2025\"],\"parentId\":[\"0\"],\"menuType\":[\"M\"],\"menuName\":[\"用户信息管理\"],\"url\":[\"#\"],\"target\":[\"menuItem\"],\"perms\":[\"\"],\"orderNum\":[\"5\"],\"icon\":[\"fa fa-users\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:04:34');
  INSERT INTO `sys_oper_log` VALUES (139, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"100\"],\"parentId\":[\"2025\"],\"menuType\":[\"C\"],\"menuName\":[\"用户管理\"],\"url\":[\"/system/user\"],\"target\":[\"menuItem\"],\"perms\":[\"system:user:view\"],\"orderNum\":[\"1\"],\"icon\":[\"fa fa-user-o\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:04:55');
  INSERT INTO `sys_oper_log` VALUES (140, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"103\"],\"parentId\":[\"2025\"],\"menuType\":[\"C\"],\"menuName\":[\"部门管理\"],\"url\":[\"/system/dept\"],\"target\":[\"menuItem\"],\"perms\":[\"system:dept:view\"],\"orderNum\":[\"4\"],\"icon\":[\"fa fa-outdent\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:05:35');
  INSERT INTO `sys_oper_log` VALUES (141, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"104\"],\"parentId\":[\"2025\"],\"menuType\":[\"C\"],\"menuName\":[\"岗位管理\"],\"url\":[\"/system/post\"],\"target\":[\"menuItem\"],\"perms\":[\"system:post:view\"],\"orderNum\":[\"5\"],\"icon\":[\"fa fa-address-card-o\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:05:57');
  INSERT INTO `sys_oper_log` VALUES (142, '菜单管理', 1, 'com.ruoyi.web.controller.system.SysMenuController.addSave()', 'POST', 1, 'admin', '研发部门', '/system/menu/add', '127.0.0.1', '内网IP', '{\"parentId\":[\"2000\"],\"menuType\":[\"C\"],\"menuName\":[\"停车场规模初始化\"],\"url\":[\"\"],\"target\":[\"menuItem\"],\"perms\":[\"\"],\"orderNum\":[\"3\"],\"icon\":[\"\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:07:06');
  INSERT INTO `sys_oper_log` VALUES (143, '菜单管理', 1, 'com.ruoyi.web.controller.system.SysMenuController.addSave()', 'POST', 1, 'admin', '研发部门', '/system/menu/add', '127.0.0.1', '内网IP', '{\"parentId\":[\"2026\"],\"menuType\":[\"F\"],\"menuName\":[\"停车场识别模型初始化\"],\"url\":[\"\"],\"target\":[\"menuItem\"],\"perms\":[\"\"],\"orderNum\":[\"1\"],\"icon\":[\"\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:07:52');
  INSERT INTO `sys_oper_log` VALUES (144, '菜单管理', 1, 'com.ruoyi.web.controller.system.SysMenuController.addSave()', 'POST', 1, 'admin', '研发部门', '/system/menu/add', '127.0.0.1', '内网IP', '{\"parentId\":[\"2027\"],\"menuType\":[\"F\"],\"menuName\":[\"车位识别模型初始化\"],\"url\":[\"\"],\"target\":[\"menuItem\"],\"perms\":[\"\"],\"orderNum\":[\"2\"],\"icon\":[\"\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:08:13');
  INSERT INTO `sys_oper_log` VALUES (145, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2028\"],\"parentId\":[\"2026\"],\"menuType\":[\"F\"],\"menuName\":[\"车位识别模型初始化\"],\"url\":[\"#\"],\"target\":[\"menuItem\"],\"perms\":[\"\"],\"orderNum\":[\"2\"],\"icon\":[\"#\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:08:28');
  INSERT INTO `sys_oper_log` VALUES (146, '停车场信息管理', 3, 'com.ruoyi.custom.controller.CusParkinglotController.remove()', 'POST', 1, 'admin', '研发部门', '/custom/parkinglot/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"0\"]}', '{\"msg\":\"操作失败\",\"code\":500}', 0, NULL, '2021-09-17 19:08:47');
  INSERT INTO `sys_oper_log` VALUES (147, '停车场信息管理', 3, 'com.ruoyi.custom.controller.CusParkinglotController.remove()', 'POST', 1, 'admin', '研发部门', '/custom/parkinglot/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"0\"]}', '{\"msg\":\"操作失败\",\"code\":500}', 0, NULL, '2021-09-17 19:08:51');
  INSERT INTO `sys_oper_log` VALUES (148, '停车场信息管理', 3, 'com.ruoyi.custom.controller.CusParkinglotController.remove()', 'POST', 1, 'admin', '研发部门', '/custom/parkinglot/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:08:55');
  INSERT INTO `sys_oper_log` VALUES (149, '停车场信息管理', 3, 'com.ruoyi.custom.controller.CusParkinglotController.remove()', 'POST', 1, 'admin', '研发部门', '/custom/parkinglot/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"2\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:08:57');
  INSERT INTO `sys_oper_log` VALUES (150, '模型信息管理', 3, 'com.ruoyi.custom.controller.CusModelController.remove()', 'POST', 1, 'admin', '研发部门', '/custom/model/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"1\"]}', '{\"msg\":\"操作失败\",\"code\":500}', 0, NULL, '2021-09-17 19:09:08');
  INSERT INTO `sys_oper_log` VALUES (151, '模型信息管理', 3, 'com.ruoyi.custom.controller.CusModelController.remove()', 'POST', 1, 'admin', '研发部门', '/custom/model/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"1\"]}', '{\"msg\":\"操作失败\",\"code\":500}', 0, NULL, '2021-09-17 19:09:13');
  INSERT INTO `sys_oper_log` VALUES (152, '模型信息管理', 3, 'com.ruoyi.custom.controller.CusModelController.remove()', 'POST', 1, 'admin', '研发部门', '/custom/model/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"1\"]}', '{\"msg\":\"操作失败\",\"code\":500}', 0, NULL, '2021-09-17 19:09:18');
  INSERT INTO `sys_oper_log` VALUES (153, '模型信息管理', 3, 'com.ruoyi.custom.controller.CusModelController.remove()', 'POST', 1, 'admin', '研发部门', '/custom/model/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"1\"]}', '{\"msg\":\"操作失败\",\"code\":500}', 0, NULL, '2021-09-17 19:09:28');
  INSERT INTO `sys_oper_log` VALUES (154, '菜单管理', 1, 'com.ruoyi.web.controller.system.SysMenuController.addSave()', 'POST', 1, 'admin', '研发部门', '/system/menu/add', '127.0.0.1', '内网IP', '{\"parentId\":[\"0\"],\"menuType\":[\"M\"],\"menuName\":[\"车位识别系统\"],\"url\":[\"\"],\"target\":[\"menuItem\"],\"perms\":[\"\"],\"orderNum\":[\"7\"],\"icon\":[\"fa fa-motorcycle\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:11:53');
  INSERT INTO `sys_oper_log` VALUES (155, '菜单管理', 1, 'com.ruoyi.web.controller.system.SysMenuController.addSave()', 'POST', 1, 'admin', '研发部门', '/system/menu/add', '127.0.0.1', '内网IP', '{\"parentId\":[\"2029\"],\"menuType\":[\"C\"],\"menuName\":[\"车位识别\"],\"url\":[\"\"],\"target\":[\"menuItem\"],\"perms\":[\"\"],\"orderNum\":[\"1\"],\"icon\":[\"\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:12:06');
  INSERT INTO `sys_oper_log` VALUES (156, '角色管理', 1, 'com.ruoyi.web.controller.system.SysRoleController.addSave()', 'POST', 1, 'admin', '研发部门', '/system/role/add', '127.0.0.1', '内网IP', '{\"roleName\":[\"停车场管理员\"],\"roleKey\":[\"manger\"],\"roleSort\":[\"3\"],\"status\":[\"0\"],\"remark\":[\"\"],\"menuIds\":[\"2025,100,1000,1001,1002,1003,1004,1005,1006,103,1016,1017,1018,1019,104,1020,1021,1022,1023,1024,2000,2019,2020,2021,2022,2023,2024,2013,2014,2015,2016,2017,2018,2026,2027,2028\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:13:48');
  INSERT INTO `sys_oper_log` VALUES (157, '角色管理', 1, 'com.ruoyi.web.controller.system.SysRoleController.addSave()', 'POST', 1, 'admin', '研发部门', '/system/role/add', '127.0.0.1', '内网IP', '{\"roleName\":[\"用户\"],\"roleKey\":[\"user\"],\"roleSort\":[\"4\"],\"status\":[\"0\"],\"remark\":[\"\"],\"menuIds\":[\"2029,2030\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:14:11');
  INSERT INTO `sys_oper_log` VALUES (158, '用户管理', 1, 'com.ruoyi.web.controller.system.SysUserController.addSave()', 'POST', 1, 'admin', '研发部门', '/system/user/add', '127.0.0.1', '内网IP', '{\"deptId\":[\"\"],\"userName\":[\"停车场管理员\"],\"deptName\":[\"\"],\"phonenumber\":[\"\"],\"email\":[\"\"],\"loginName\":[\"parking\"],\"sex\":[\"0\"],\"role\":[\"3\"],\"remark\":[\"\"],\"status\":[\"0\"],\"roleIds\":[\"3\"],\"postIds\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:15:06');
  INSERT INTO `sys_oper_log` VALUES (159, '用户管理', 1, 'com.ruoyi.web.controller.system.SysUserController.addSave()', 'POST', 1, 'admin', '研发部门', '/system/user/add', '127.0.0.1', '内网IP', '{\"deptId\":[\"\"],\"userName\":[\"用户\"],\"deptName\":[\"\"],\"phonenumber\":[\"\"],\"email\":[\"\"],\"loginName\":[\"user\"],\"sex\":[\"0\"],\"role\":[\"4\"],\"remark\":[\"\"],\"status\":[\"0\"],\"roleIds\":[\"4\"],\"postIds\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 19:15:23');
  INSERT INTO `sys_oper_log` VALUES (160, '菜单管理', 3, 'com.ruoyi.web.controller.system.SysMenuController.remove()', 'GET', 1, 'admin', '研发部门', '/system/menu/remove/2002', '127.0.0.1', '内网IP', '2002', '{\"msg\":\"菜单已分配,不允许删除\",\"code\":301}', 0, NULL, '2021-09-17 20:35:07');
  INSERT INTO `sys_oper_log` VALUES (161, '菜单管理', 3, 'com.ruoyi.web.controller.system.SysMenuController.remove()', 'GET', 1, 'admin', '研发部门', '/system/menu/remove/2001', '127.0.0.1', '内网IP', '2001', '{\"msg\":\"存在子菜单,不允许删除\",\"code\":301}', 0, NULL, '2021-09-17 20:35:13');
  INSERT INTO `sys_oper_log` VALUES (162, '菜单管理', 3, 'com.ruoyi.web.controller.system.SysMenuController.remove()', 'GET', 1, 'admin', '研发部门', '/system/menu/remove/2006', '127.0.0.1', '内网IP', '2006', '{\"msg\":\"菜单已分配,不允许删除\",\"code\":301}', 0, NULL, '2021-09-17 20:35:19');
  INSERT INTO `sys_oper_log` VALUES (163, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2001\"],\"parentId\":[\"3\"],\"menuType\":[\"C\"],\"menuName\":[\"停车场\"],\"url\":[\"/custom/parkinglot\"],\"target\":[\"menuItem\"],\"perms\":[\"custom:parkinglot:view\"],\"orderNum\":[\"1\"],\"icon\":[\"#\"],\"visible\":[\"1\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 20:35:29');
  INSERT INTO `sys_oper_log` VALUES (164, '停车场信息管理', 1, 'com.ruoyi.custom.controller.CusParkinglotController.addSave()', 'POST', 1, 'admin', '研发部门', '/custom/parkinglot/add', '127.0.0.1', '内网IP', '{\"userId\":[\"1\"],\"parkinglotName\":[\"朝阳区停车场\"],\"parkinglotLoc\":[\"北京市朝阳区\"],\"parkinglotCamera\":[\"c:\\\\\\\\test.jpg\"],\"remark\":[\"\"],\"index\":[\"1\"],\"cusModelList[0].sizeModel\":[\"c:\\\\\\\\dasd\"],\"cusModelList[0].regModel\":[\"D:\\\\\\\\dasd\\\\dasda\"],\"btSelectAll\":[\"\"],\"btSelectItem\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 20:39:39');
  INSERT INTO `sys_oper_log` VALUES (165, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2030\"],\"parentId\":[\"2029\"],\"menuType\":[\"C\"],\"menuName\":[\"车位识别\"],\"url\":[\"/test/returnimage\"],\"target\":[\"menuItem\"],\"perms\":[\"\"],\"orderNum\":[\"1\"],\"icon\":[\"#\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 20:46:16');
  INSERT INTO `sys_oper_log` VALUES (166, '停车场信息管理', 2, 'com.ruoyi.custom.controller.CusParkinglotController.editSave()', 'POST', 1, 'admin', '研发部门', '/custom/parkinglot/edit', '127.0.0.1', '内网IP', '{\"parkinglotId\":[\"3\"],\"parkinglotCapacity\":[\"0\"],\"userId\":[\"11\"],\"parkinglotName\":[\"朝阳区停车场\"],\"parkinglotLoc\":[\"北京市朝阳区\"],\"parkinglotCamera\":[\"c:\\\\\\\\test.jpg\"],\"parkinglotSpare\":[\"0\"],\"image\":[\"\"],\"imageUpdate\":[\"\"],\"remark\":[\"\"],\"index\":[\"1\"],\"cusModelList[0].sizeModel\":[\"c:\\\\\\\\dasd\"],\"cusModelList[0].regModel\":[\"D:\\\\\\\\dasd\\\\dasda\"],\"btSelectAll\":[\"\"],\"btSelectItem\":[\"\"]}', NULL, 1, '\r\n### Error updating database.  Cause: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`ry`.`cus_parkinglot`, CONSTRAINT `cus_parkinglot_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`user_id`))\r\n### The error may exist in file [D:\\workspace1\\RuoYi\\ruoyi-admin\\target\\classes\\mapper\\custom\\CusParkinglotMapper.xml]\r\n### The error may involve com.ruoyi.custom.mapper.CusParkinglotMapper.updateCusParkinglot-Inline\r\n### The error occurred while setting parameters\r\n### SQL: update cus_parkinglot          SET parkinglot_capacity = ?,             user_id = ?,             parkinglot_name = ?,             parkinglot_loc = ?,             parkinglot_camera = ?,             parkinglot_spare = ?,             image = ?,                          remark = ?          where parkinglot_id = ?\r\n### Cause: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`ry`.`cus_parkinglot`, CONSTRAINT `cus_parkinglot_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`user_id`))\n; Cannot add or update a child row: a foreign key constraint fails (`ry`.`cus_parkinglot`, CONSTRAINT `cus_parkinglot_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`user_id`)); nested exception is java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`ry`.`cus_parkinglot`, CONSTRAINT `cus_parkinglot_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`user_id`))', '2021-09-17 21:22:46');
  INSERT INTO `sys_oper_log` VALUES (167, '停车场信息管理', 2, 'com.ruoyi.custom.controller.CusParkinglotController.editSave()', 'POST', 1, 'admin', '研发部门', '/custom/parkinglot/edit', '127.0.0.1', '内网IP', '{\"parkinglotId\":[\"3\"],\"parkinglotCapacity\":[\"0\"],\"userId\":[\"11\"],\"parkinglotName\":[\"朝阳区停车场\"],\"parkinglotLoc\":[\"北京市朝阳区\"],\"parkinglotCamera\":[\"c:\\\\\\\\test.jpg\"],\"parkinglotSpare\":[\"0\"],\"image\":[\"\"],\"imageUpdate\":[\"\"],\"remark\":[\"\"],\"index\":[\"1\"],\"cusModelList[0].sizeModel\":[\"c:\\\\\\\\dasd\"],\"cusModelList[0].regModel\":[\"D:\\\\\\\\dasd\\\\dasda\"],\"btSelectAll\":[\"\"],\"btSelectItem\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-17 21:23:27');
  INSERT INTO `sys_oper_log` VALUES (168, '个人信息', 2, 'com.ruoyi.web.controller.system.SysProfileController.updateAvatar()', 'POST', 1, 'parking', NULL, '/system/user/profile/updateAvatar', '127.0.0.1', '内网IP', '', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-18 09:37:20');
  INSERT INTO `sys_oper_log` VALUES (169, '部门管理', 2, 'com.ruoyi.web.controller.system.SysDeptController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/dept/edit', '127.0.0.1', '内网IP', '{\"deptId\":[\"100\"],\"parentId\":[\"0\"],\"parentName\":[\"无\"],\"deptName\":[\"北京市停车场管理公司\"],\"orderNum\":[\"0\"],\"leader\":[\"若依\"],\"phone\":[\"15888888888\"],\"email\":[\"ry@qq.com\"],\"status\":[\"0\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:18:01');
  INSERT INTO `sys_oper_log` VALUES (170, '部门管理', 2, 'com.ruoyi.web.controller.system.SysDeptController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/dept/edit', '127.0.0.1', '内网IP', '{\"deptId\":[\"101\"],\"parentId\":[\"100\"],\"parentName\":[\"北京市停车场管理公司\"],\"deptName\":[\"朝阳区分公司\"],\"orderNum\":[\"1\"],\"leader\":[\"若依\"],\"phone\":[\"15888888888\"],\"email\":[\"ry@qq.com\"],\"status\":[\"0\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:18:40');
  INSERT INTO `sys_oper_log` VALUES (171, '部门管理', 2, 'com.ruoyi.web.controller.system.SysDeptController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/dept/edit', '127.0.0.1', '内网IP', '{\"deptId\":[\"102\"],\"parentId\":[\"100\"],\"parentName\":[\"北京市停车场管理公司\"],\"deptName\":[\"海淀区分公司\"],\"orderNum\":[\"2\"],\"leader\":[\"若依\"],\"phone\":[\"15888888888\"],\"email\":[\"ry@qq.com\"],\"status\":[\"0\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:18:50');
  INSERT INTO `sys_oper_log` VALUES (172, '部门管理', 2, 'com.ruoyi.web.controller.system.SysDeptController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/dept/edit', '127.0.0.1', '内网IP', '{\"deptId\":[\"103\"],\"parentId\":[\"101\"],\"parentName\":[\"朝阳区分公司\"],\"deptName\":[\"朝外街道分公司\"],\"orderNum\":[\"1\"],\"leader\":[\"若依\"],\"phone\":[\"15888888888\"],\"email\":[\"ry@qq.com\"],\"status\":[\"0\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:19:08');
  INSERT INTO `sys_oper_log` VALUES (173, '部门管理', 2, 'com.ruoyi.web.controller.system.SysDeptController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/dept/edit', '127.0.0.1', '内网IP', '{\"deptId\":[\"104\"],\"parentId\":[\"101\"],\"parentName\":[\"朝阳区分公司\"],\"deptName\":[\"劲松街道分公司\"],\"orderNum\":[\"2\"],\"leader\":[\"若依\"],\"phone\":[\"15888888888\"],\"email\":[\"ry@qq.com\"],\"status\":[\"0\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:19:17');
  INSERT INTO `sys_oper_log` VALUES (174, '部门管理', 2, 'com.ruoyi.web.controller.system.SysDeptController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/dept/edit', '127.0.0.1', '内网IP', '{\"deptId\":[\"105\"],\"parentId\":[\"101\"],\"parentName\":[\"朝阳区分公司\"],\"deptName\":[\"建外街道分公司\"],\"orderNum\":[\"3\"],\"leader\":[\"若依\"],\"phone\":[\"15888888888\"],\"email\":[\"ry@qq.com\"],\"status\":[\"0\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:19:28');
  INSERT INTO `sys_oper_log` VALUES (175, '部门管理', 2, 'com.ruoyi.web.controller.system.SysDeptController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/dept/edit', '127.0.0.1', '内网IP', '{\"deptId\":[\"106\"],\"parentId\":[\"101\"],\"parentName\":[\"朝阳区分公司\"],\"deptName\":[\"呼家楼街道分公司\"],\"orderNum\":[\"4\"],\"leader\":[\"若依\"],\"phone\":[\"15888888888\"],\"email\":[\"ry@qq.com\"],\"status\":[\"0\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:19:42');
  INSERT INTO `sys_oper_log` VALUES (176, '部门管理', 2, 'com.ruoyi.web.controller.system.SysDeptController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/dept/edit', '127.0.0.1', '内网IP', '{\"deptId\":[\"107\"],\"parentId\":[\"101\"],\"parentName\":[\"朝阳区分公司\"],\"deptName\":[\"八里庄街道分公司\"],\"orderNum\":[\"5\"],\"leader\":[\"若依\"],\"phone\":[\"15888888888\"],\"email\":[\"ry@qq.com\"],\"status\":[\"0\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:19:52');
  INSERT INTO `sys_oper_log` VALUES (177, '部门管理', 2, 'com.ruoyi.web.controller.system.SysDeptController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/dept/edit', '127.0.0.1', '内网IP', '{\"deptId\":[\"108\"],\"parentId\":[\"102\"],\"parentName\":[\"海淀区分公司\"],\"deptName\":[\"万寿路街道分公司\"],\"orderNum\":[\"1\"],\"leader\":[\"若依\"],\"phone\":[\"15888888888\"],\"email\":[\"ry@qq.com\"],\"status\":[\"0\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:20:29');
  INSERT INTO `sys_oper_log` VALUES (178, '部门管理', 2, 'com.ruoyi.web.controller.system.SysDeptController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/dept/edit', '127.0.0.1', '内网IP', '{\"deptId\":[\"109\"],\"parentId\":[\"102\"],\"parentName\":[\"海淀区分公司\"],\"deptName\":[\"学院路街道分公司\"],\"orderNum\":[\"2\"],\"leader\":[\"若依\"],\"phone\":[\"15888888888\"],\"email\":[\"ry@qq.com\"],\"status\":[\"0\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:20:40');
  INSERT INTO `sys_oper_log` VALUES (179, '岗位管理', 2, 'com.ruoyi.web.controller.system.SysPostController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/post/edit', '127.0.0.1', '内网IP', '{\"postId\":[\"1\"],\"postName\":[\"停车场管理员\"],\"postCode\":[\"PA\"],\"postSort\":[\"1\"],\"status\":[\"0\"],\"remark\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:21:19');
  INSERT INTO `sys_oper_log` VALUES (180, '岗位管理', 2, 'com.ruoyi.web.controller.system.SysPostController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/post/edit', '127.0.0.1', '内网IP', '{\"postId\":[\"2\"],\"postName\":[\"游客\"],\"postCode\":[\"GT\"],\"postSort\":[\"2\"],\"status\":[\"0\"],\"remark\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:21:38');
  INSERT INTO `sys_oper_log` VALUES (181, '岗位管理', 2, 'com.ruoyi.web.controller.system.SysPostController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/post/edit', '127.0.0.1', '内网IP', '{\"postId\":[\"3\"],\"postName\":[\"居民\"],\"postCode\":[\"HP\"],\"postSort\":[\"3\"],\"status\":[\"0\"],\"remark\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:21:54');
  INSERT INTO `sys_oper_log` VALUES (182, '岗位管理', 3, 'com.ruoyi.web.controller.system.SysPostController.remove()', 'POST', 1, 'admin', '研发部门', '/system/post/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"4\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:22:01');
  INSERT INTO `sys_oper_log` VALUES (183, '用户管理', 3, 'com.ruoyi.web.controller.system.SysUserController.remove()', 'POST', 1, 'admin', '研发部门', '/system/user/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"100\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:22:12');
  INSERT INTO `sys_oper_log` VALUES (184, '用户管理', 2, 'com.ruoyi.web.controller.system.SysUserController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/user/edit', '127.0.0.1', '内网IP', '{\"userId\":[\"101\"],\"deptId\":[\"104\"],\"userName\":[\"停车场管理员\"],\"dept.deptName\":[\"劲松街道分公司\"],\"phonenumber\":[\"\"],\"email\":[\"\"],\"loginName\":[\"parking\"],\"sex\":[\"0\"],\"role\":[\"3\"],\"remark\":[\"\"],\"status\":[\"0\"],\"roleIds\":[\"3\"],\"postIds\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:22:28');
  INSERT INTO `sys_oper_log` VALUES (185, '用户管理', 2, 'com.ruoyi.web.controller.system.SysUserController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/user/edit', '127.0.0.1', '内网IP', '{\"userId\":[\"101\"],\"deptId\":[\"104\"],\"userName\":[\"停车场管理员\"],\"dept.deptName\":[\"劲松街道分公司\"],\"phonenumber\":[\"\"],\"email\":[\"\"],\"loginName\":[\"parking\"],\"sex\":[\"0\"],\"role\":[\"3\"],\"remark\":[\"\"],\"status\":[\"0\"],\"roleIds\":[\"3\"],\"postIds\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:22:36');
  INSERT INTO `sys_oper_log` VALUES (186, '用户管理', 2, 'com.ruoyi.web.controller.system.SysUserController.editSave()', 'POST', 1, 'admin', '研发部门', '/system/user/edit', '127.0.0.1', '内网IP', '{\"userId\":[\"102\"],\"deptId\":[\"\"],\"userName\":[\"用户\"],\"dept.deptName\":[\"\"],\"phonenumber\":[\"\"],\"email\":[\"\"],\"loginName\":[\"user\"],\"sex\":[\"0\"],\"role\":[\"4\"],\"remark\":[\"\"],\"status\":[\"0\"],\"roleIds\":[\"4\"],\"postIds\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:23:05');
  INSERT INTO `sys_oper_log` VALUES (187, '停车场信息管理', 1, 'com.ruoyi.custom.controller.CusParkinglotController.addSave()', 'POST', 1, 'admin', '朝外街道分公司', '/custom/parkinglot/add', '127.0.0.1', '内网IP', '{\"userId\":[\"1\"],\"parkinglotName\":[\"天通苑-北P+R停车场\"],\"parkinglotLoc\":[\"北京市昌平区天通苑北地铁站南\"],\"parkinglotCamera\":[\"/profile/upload/2021/09/26/5b97ef00-d776-4204-98ad-85fbda1f5b00.png\"],\"remark\":[\"北京市昌平区天通苑北地铁站南\"],\"btSelectAll\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 19:50:16');
  INSERT INTO `sys_oper_log` VALUES (188, '停车场信息管理', 3, 'com.ruoyi.custom.controller.CusParkinglotController.remove()', 'POST', 1, 'admin', '朝外街道分公司', '/custom/parkinglot/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"5\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 20:47:40');
  INSERT INTO `sys_oper_log` VALUES (189, '停车场信息管理', 2, 'com.ruoyi.custom.controller.CusParkinglotController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/custom/parkinglot/edit', '127.0.0.1', '内网IP', '{\"parkinglotId\":[\"4\"],\"parkinglotCapacity\":[\"0\"],\"userId\":[\"1\"],\"parkinglotName\":[\"天通苑-北P+R停车场\"],\"parkinglotLoc\":[\"北京市昌平区天通苑北地铁站南\"],\"parkinglotCamera\":[\"/profile/upload/2021/09/26/scene1380.jpg\"],\"parkinglotSpare\":[\"0\"],\"image\":[\"/profile/upload/2021/09/26/test1.jpg\"],\"imageUpdate\":[\"\"],\"remark\":[\"北京市昌平区天通苑北地铁站南\"],\"index\":[\"1\"],\"cusModelList[0].sizeModel\":[\"spot_dict.pickle\"],\"cusModelList[0].regModel\":[\"net\"],\"btSelectAll\":[\"\"],\"btSelectItem\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 20:50:46');
  INSERT INTO `sys_oper_log` VALUES (190, '停车场信息管理', 2, 'com.ruoyi.custom.controller.CusParkinglotController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/custom/parkinglot/edit', '127.0.0.1', '内网IP', '{\"parkinglotId\":[\"7\"],\"parkinglotCapacity\":[\"0\"],\"userId\":[\"1\"],\"parkinglotName\":[\"大山子停车场\"],\"parkinglotLoc\":[\"北京市朝阳区酒仙桥北路北京市朝阳区大望京公园南侧约80米\"],\"parkinglotCamera\":[\"/profile/upload/2021/09/26/scene1380.jpg\"],\"parkinglotSpare\":[\"0\"],\"image\":[\"/profile/upload/2021/09/26/test1.jpg\"],\"imageUpdate\":[\"\"],\"remark\":[\"北京市朝阳区酒仙桥北路北京市朝阳区大望京公园南侧约80米\"],\"index\":[\"1\"],\"cusModelList[0].sizeModel\":[\"spot_dict1.pickle\"],\"cusModelList[0].regModel\":[\"net1\"],\"btSelectAll\":[\"\"],\"btSelectItem\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 20:51:12');
  INSERT INTO `sys_oper_log` VALUES (191, '停车场信息管理', 2, 'com.ruoyi.custom.controller.CusParkinglotController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/custom/parkinglot/edit', '127.0.0.1', '内网IP', '{\"parkinglotId\":[\"9\"],\"parkinglotCapacity\":[\"0\"],\"userId\":[\"1\"],\"parkinglotName\":[\"停车场(中泰商务楼西北)\"],\"parkinglotLoc\":[\"北京市朝阳区朝阳北路中领商务楼\"],\"parkinglotCamera\":[\"/profile/upload/2021/09/26/scene1380.jpg\"],\"parkinglotSpare\":[\"0\"],\"image\":[\"/profile/upload/2021/09/26/test1.jpg\"],\"imageUpdate\":[\"\"],\"remark\":[\"北京市朝阳区朝阳北路中领商务楼\"],\"index\":[\"1\"],\"cusModelList[0].sizeModel\":[\"spot_dict1.pickle\"],\"cusModelList[0].regModel\":[\"net2\"],\"btSelectAll\":[\"\"],\"btSelectItem\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 20:51:24');
  INSERT INTO `sys_oper_log` VALUES (192, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2026\"],\"parentId\":[\"2000\"],\"menuType\":[\"C\"],\"menuName\":[\"停车场规模初始化\"],\"url\":[\"/custom/tes\"],\"target\":[\"menuItem\"],\"perms\":[\"\"],\"orderNum\":[\"3\"],\"icon\":[\"#\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 21:04:21');
  INSERT INTO `sys_oper_log` VALUES (193, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2026\"],\"parentId\":[\"2000\"],\"menuType\":[\"C\"],\"menuName\":[\"停车场规模初始化\"],\"url\":[\"custom/parkinglot/init\"],\"target\":[\"menuItem\"],\"perms\":[\"\"],\"orderNum\":[\"3\"],\"icon\":[\"#\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 21:05:39');
  INSERT INTO `sys_oper_log` VALUES (194, '停车场信息管理', 2, 'com.ruoyi.custom.controller.CusParkinglotController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/custom/parkinglot/edit', '127.0.0.1', '内网IP', '{\"parkinglotId\":[\"8\"],\"parkinglotCapacity\":[\"0\"],\"userId\":[\"1\"],\"parkinglotName\":[\"北京798艺术中心-停车场\"],\"parkinglotLoc\":[\"北京市朝阳区酒仙桥路2号798艺术区\"],\"parkinglotCamera\":[\"\"],\"parkinglotSpare\":[\"0\"],\"image\":[\"/profile/upload/2021/09/26/test1.jpg\"],\"imageUpdate\":[\"\"],\"remark\":[\"北京市朝阳区酒仙桥路2号798艺术区\"],\"index\":[\"1\"],\"cusModelList[0].sizeModel\":[\"\"],\"cusModelList[0].regModel\":[\"\"],\"btSelectAll\":[\"\"],\"btSelectItem\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-26 21:57:06');
  INSERT INTO `sys_oper_log` VALUES (195, '停车场信息管理', 2, 'com.ruoyi.custom.controller.CusParkinglotController.editSave()', 'POST', 1, 'parking', '劲松街道分公司', '/custom/parkinglot/edit', '127.0.0.1', '内网IP', '{\"parkinglotId\":[\"8\"],\"parkinglotCapacity\":[\"0\"],\"userId\":[\"1\"],\"parkinglotName\":[\"北京798艺术中心-停车场\"],\"parkinglotLoc\":[\"北京市朝阳区酒仙桥路2号798艺术区\"],\"parkinglotCamera\":[\"/profile/upload/2021/09/27/055230da-d78c-4016-872f-bd608ac1fe72.png\"],\"parkinglotSpare\":[\"0\"],\"image\":[\"/profile/upload/2021/09/26/test1.jpg\"],\"imageUpdate\":[\"\"],\"remark\":[\"北京市朝阳区酒仙桥路2号798艺术区\"],\"index\":[\"1\"],\"cusModelList[0].sizeModel\":[\"\"],\"cusModelList[0].regModel\":[\"\"],\"btSelectAll\":[\"\"],\"btSelectItem\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-27 08:12:36');
  INSERT INTO `sys_oper_log` VALUES (196, '停车场信息管理', 1, 'com.ruoyi.custom.controller.CusParkinglotController.addSave()', 'POST', 1, 'parking', '劲松街道分公司', '/custom/parkinglot/add', '127.0.0.1', '内网IP', '{\"userId\":[\"3\"],\"parkinglotName\":[\"新建停车场\"],\"parkinglotLoc\":[\"朝阳区\"],\"parkinglotCamera\":[\"/profile/upload/2021/09/27/cb8524c5-44d0-4ef0-879c-8c16d5c1ab1f.png\"],\"remark\":[\"\"],\"index\":[\"1\"],\"cusModelList[0].sizeModel\":[\"\"],\"cusModelList[0].regModel\":[\"\"],\"btSelectAll\":[\"\"],\"btSelectItem\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-27 08:14:36');
  INSERT INTO `sys_oper_log` VALUES (197, '停车场信息管理', 2, 'com.ruoyi.custom.controller.CusParkinglotController.editSave()', 'POST', 1, 'parking', '劲松街道分公司', '/custom/parkinglot/edit', '127.0.0.1', '内网IP', '{\"parkinglotId\":[\"13\"],\"parkinglotCapacity\":[\"0\"],\"userId\":[\"5\"],\"parkinglotName\":[\"新建停车场\"],\"parkinglotLoc\":[\"朝阳区\"],\"parkinglotCamera\":[\"\"],\"parkinglotSpare\":[\"0\"],\"image\":[\"\"],\"imageUpdate\":[\"\"],\"remark\":[\"\"],\"index\":[\"1\"],\"cusModelList[0].sizeModel\":[\"\"],\"cusModelList[0].regModel\":[\"\"],\"btSelectAll\":[\"\"],\"btSelectItem\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-27 08:14:51');
  INSERT INTO `sys_oper_log` VALUES (198, '停车场信息管理', 2, 'com.ruoyi.custom.controller.CusParkinglotController.editSave()', 'POST', 1, 'parking', '劲松街道分公司', '/custom/parkinglot/edit', '127.0.0.1', '内网IP', '{\"parkinglotId\":[\"13\"],\"parkinglotCapacity\":[\"0\"],\"userId\":[\"5\"],\"parkinglotName\":[\"新建停车场\"],\"parkinglotLoc\":[\"朝阳区\"],\"parkinglotCamera\":[\"/profile/upload/2021/09/27/cfe3f55d-d439-468b-92cf-9500cde08187.png\"],\"parkinglotSpare\":[\"0\"],\"image\":[\"\"],\"imageUpdate\":[\"\"],\"remark\":[\"\"],\"index\":[\"1\"],\"cusModelList[0].sizeModel\":[\"\"],\"cusModelList[0].regModel\":[\"\"],\"btSelectAll\":[\"\"],\"btSelectItem\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-27 08:15:14');
  INSERT INTO `sys_oper_log` VALUES (199, '模型信息管理', 3, 'com.ruoyi.custom.controller.CusModelController.remove()', 'POST', 1, 'parking', '劲松街道分公司', '/custom/model/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"4\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-27 08:16:29');
  INSERT INTO `sys_oper_log` VALUES (200, '个人信息', 2, 'com.ruoyi.web.controller.system.SysProfileController.updateAvatar()', 'POST', 1, 'user', NULL, '/system/user/profile/updateAvatar', '127.0.0.1', '内网IP', '', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-27 08:17:23');
  INSERT INTO `sys_oper_log` VALUES (201, '岗位管理', 1, 'com.ruoyi.web.controller.system.SysPostController.addSave()', 'POST', 1, 'admin', '朝外街道分公司', '/system/post/add', '127.0.0.1', '内网IP', '{\"postName\":[\"街道经理\"],\"postCode\":[\"4\"],\"postSort\":[\"4\"],\"status\":[\"0\"],\"remark\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-27 08:22:54');
  INSERT INTO `sys_oper_log` VALUES (202, '岗位管理', 2, 'com.ruoyi.web.controller.system.SysPostController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/system/post/edit', '127.0.0.1', '内网IP', '{\"postId\":[\"5\"],\"postName\":[\"街道经理\"],\"postCode\":[\"SA\"],\"postSort\":[\"4\"],\"status\":[\"0\"],\"remark\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-27 08:23:08');
  INSERT INTO `sys_oper_log` VALUES (203, '岗位管理', 1, 'com.ruoyi.web.controller.system.SysPostController.addSave()', 'POST', 1, 'admin', '朝外街道分公司', '/system/post/add', '127.0.0.1', '内网IP', '{\"postName\":[\"区域经理\"],\"postCode\":[\"QA\"],\"postSort\":[\"5\"],\"status\":[\"0\"],\"remark\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-27 08:23:56');
  INSERT INTO `sys_oper_log` VALUES (204, '模型信息管理', 3, 'com.ruoyi.custom.controller.CusModelController.remove()', 'POST', 1, 'parking', '劲松街道分公司', '/custom/model/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"9,12\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-27 10:00:58');
  INSERT INTO `sys_oper_log` VALUES (205, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2026\"],\"parentId\":[\"2000\"],\"menuType\":[\"C\"],\"menuName\":[\"停车场规模初始化\"],\"url\":[\"/custom/parkinglot/init\"],\"target\":[\"menuItem\"],\"perms\":[\"\"],\"orderNum\":[\"3\"],\"icon\":[\"#\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-09-27 21:41:07');
  INSERT INTO `sys_oper_log` VALUES (206, '代码生成', 3, 'com.ruoyi.generator.controller.GenController.remove()', 'POST', 1, 'admin', '朝外街道分公司', '/tool/gen/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"7,8\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-08 22:25:08');
  INSERT INTO `sys_oper_log` VALUES (207, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', '朝外街道分公司', '/tool/gen/importTable', '127.0.0.1', '内网IP', '{\"tables\":[\"cus_model\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-08 22:25:19');
  INSERT INTO `sys_oper_log` VALUES (208, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', '朝外街道分公司', '/tool/gen/importTable', '127.0.0.1', '内网IP', '{\"tables\":[\"cus_parkinglot\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-08 22:33:36');
  INSERT INTO `sys_oper_log` VALUES (209, '个人信息', 2, 'com.ruoyi.web.controller.system.SysProfileController.updateAvatar()', 'POST', 1, 'admin', '朝外街道分公司', '/system/user/profile/updateAvatar', '127.0.0.1', '内网IP', '', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-09 21:09:23');
  INSERT INTO `sys_oper_log` VALUES (210, '个人信息', 2, 'com.ruoyi.web.controller.system.SysProfileController.updateAvatar()', 'POST', 1, 'parking', '劲松街道分公司', '/system/user/profile/updateAvatar', '127.0.0.1', '内网IP', '', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-09 21:09:49');
  INSERT INTO `sys_oper_log` VALUES (211, '个人信息', 2, 'com.ruoyi.web.controller.system.SysProfileController.updateAvatar()', 'POST', 1, 'user', NULL, '/system/user/profile/updateAvatar', '127.0.0.1', '内网IP', '', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-09 21:10:10');
  INSERT INTO `sys_oper_log` VALUES (212, '停车场信息管理', 2, 'com.ruoyi.custom.controller.CusParkinglotController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/custom/parkinglot/edit', '127.0.0.1', '内网IP', '{\"parkinglotId\":[\"8\"],\"parkinglotCapacity\":[\"0\"],\"userId\":[\"1\"],\"parkinglotName\":[\"北京798艺术中心-停车场\"],\"parkinglotLoc\":[\"北京市朝阳区酒仙桥路2号798艺术区\"],\"parkinglotCamera\":[\"/profile/upload/2021/10/11/db7c6b36-80ec-4a81-9523-cf91d24b96e7.jpg\"],\"parkinglotSpare\":[\"0\"],\"image\":[\"/profile/upload/2021/09/26/test1.jpg\"],\"imageUpdate\":[\"\"],\"remark\":[\"北京市朝阳区酒仙桥路2号798艺术区\"],\"btSelectAll\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-11 08:06:27');
  INSERT INTO `sys_oper_log` VALUES (213, '停车场信息管理', 2, 'com.ruoyi.custom.controller.CusParkinglotController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/custom/parkinglot/edit', '127.0.0.1', '内网IP', '{\"parkinglotId\":[\"8\"],\"parkinglotCapacity\":[\"0\"],\"userId\":[\"1\"],\"parkinglotName\":[\"北京798艺术中心-停车场\"],\"parkinglotLoc\":[\"北京市朝阳区酒仙桥路2号798艺术区\"],\"parkinglotCamera\":[\"/profile/upload/2021/10/11/d7d3fcea-a59a-4f10-b7bc-41ee35f3cbe5.png\"],\"parkinglotSpare\":[\"0\"],\"image\":[\"/profile/upload/2021/09/26/test1.jpg\"],\"imageUpdate\":[\"\"],\"remark\":[\"北京市朝阳区酒仙桥路2号798艺术区\"],\"btSelectAll\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-11 09:06:44');
  INSERT INTO `sys_oper_log` VALUES (214, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"4\"],\"parentId\":[\"0\"],\"menuType\":[\"C\"],\"menuName\":[\"若依官网\"],\"url\":[\"/test/returnimage\"],\"target\":[\"menuBlank\"],\"perms\":[\"\"],\"orderNum\":[\"4\"],\"icon\":[\"fa fa-location-arrow\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-11 10:37:06');
  INSERT INTO `sys_oper_log` VALUES (215, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2026\"],\"parentId\":[\"2000\"],\"menuType\":[\"C\"],\"menuName\":[\"停车场规模初始化\"],\"url\":[\"/custom/pinit\"],\"target\":[\"menuItem\"],\"perms\":[\"\"],\"orderNum\":[\"3\"],\"icon\":[\"#\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-16 13:29:26');
  INSERT INTO `sys_oper_log` VALUES (216, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2026\"],\"parentId\":[\"2000\"],\"menuType\":[\"C\"],\"menuName\":[\"停车场规模初始化\"],\"url\":[\"/custom/pinit\"],\"target\":[\"menuItem\"],\"perms\":[\"custom:pinit:view\"],\"orderNum\":[\"3\"],\"icon\":[\"#\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-16 13:29:41');
  INSERT INTO `sys_oper_log` VALUES (217, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2026\"],\"parentId\":[\"2000\"],\"menuType\":[\"C\"],\"menuName\":[\"停车场规模初始化\"],\"url\":[\"/custom/pinit/init\"],\"target\":[\"menuItem\"],\"perms\":[\"custom:pinit:view\"],\"orderNum\":[\"3\"],\"icon\":[\"#\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-16 13:30:41');
  INSERT INTO `sys_oper_log` VALUES (218, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2030\"],\"parentId\":[\"2029\"],\"menuType\":[\"C\"],\"menuName\":[\"车位识别\"],\"url\":[\"custom/pinit\"],\"target\":[\"menuItem\"],\"perms\":[\"custom:pinit:view\"],\"orderNum\":[\"1\"],\"icon\":[\"#\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-16 13:31:00');
  INSERT INTO `sys_oper_log` VALUES (219, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2026\"],\"parentId\":[\"2000\"],\"menuType\":[\"C\"],\"menuName\":[\"停车场规模初始化\"],\"url\":[\"/custom/pinit/init\"],\"target\":[\"menuItem\"],\"perms\":[\"\"],\"orderNum\":[\"3\"],\"icon\":[\"#\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-16 13:36:52');
  INSERT INTO `sys_oper_log` VALUES (220, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2026\"],\"parentId\":[\"2000\"],\"menuType\":[\"C\"],\"menuName\":[\"停车场规模初始化\"],\"url\":[\"/custom/pinit/init\"],\"target\":[\"menuItem\"],\"perms\":[\"custom:parkinglot:view\"],\"orderNum\":[\"3\"],\"icon\":[\"#\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-16 13:53:07');
  INSERT INTO `sys_oper_log` VALUES (221, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2026\"],\"parentId\":[\"2000\"],\"menuType\":[\"C\"],\"menuName\":[\"停车场规模初始化\"],\"url\":[\"/custom/pinit\"],\"target\":[\"menuItem\"],\"perms\":[\"custom:parkinglot:view\"],\"orderNum\":[\"3\"],\"icon\":[\"#\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-16 13:54:36');
  INSERT INTO `sys_oper_log` VALUES (222, '停车场信息管理', 2, 'com.ruoyi.custom.controller.CusParkinglotController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/custom/parkinglot/edit', '127.0.0.1', '内网IP', '{\"parkinglotId\":[\"4\"],\"parkinglotCapacity\":[\"10\"],\"userId\":[\"1\"],\"parkinglotName\":[\"天通苑-北P+R停车场\"],\"parkinglotLoc\":[\"北京市昌平区天通苑北地铁站南\"],\"parkinglotCamera\":[\"\"],\"parkinglotSpare\":[\"0\"],\"image\":[\"/profile/upload/2021/09/26/test1.jpg\"],\"imageUpdate\":[\"\"],\"remark\":[\"北京市昌平区天通苑北地铁站南\"],\"index\":[\"1\"],\"cusModelList[0].sizeModel\":[\"spot_dict.pickle\"],\"cusModelList[0].regModel\":[\"net\"],\"btSelectAll\":[\"\"],\"btSelectItem\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-16 13:56:26');
  INSERT INTO `sys_oper_log` VALUES (223, '模型信息管理', 3, 'com.ruoyi.custom.controller.CusModelController.remove()', 'POST', 1, 'admin', '朝外街道分公司', '/custom/model/remove', '127.0.0.1', '内网IP', '{\"ids\":[\"6,7,8\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-16 14:23:33');
  INSERT INTO `sys_oper_log` VALUES (224, '停车场信息管理', 2, 'com.ruoyi.custom.controller.CusParkinglotController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/custom/parkinglot/edit', '127.0.0.1', '内网IP', '{\"parkinglotId\":[\"4\"],\"parkinglotCapacity\":[\"10\"],\"userId\":[\"1\"],\"parkinglotName\":[\"天通苑-北P+R停车场\"],\"parkinglotLoc\":[\"北京市昌平区天通苑北地铁站南\"],\"parkinglotCamera\":[\"/profile/upload/2021/10/16/191b5917-f391-4966-94f3-3920e57059f5.JPG\"],\"parkinglotSpare\":[\"0\"],\"image\":[\"/profile/upload/2021/09/26/test1.jpg\"],\"imageUpdate\":[\"\"],\"remark\":[\"北京市昌平区天通苑北地铁站南\"],\"btSelectAll\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-16 14:28:59');
  INSERT INTO `sys_oper_log` VALUES (225, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/system/menu/edit', '127.0.0.1', '内网IP', '{\"menuId\":[\"2030\"],\"parentId\":[\"2029\"],\"menuType\":[\"C\"],\"menuName\":[\"车位识别\"],\"url\":[\"custom/pinit/predict\"],\"target\":[\"menuItem\"],\"perms\":[\"custom:pinit:view\"],\"orderNum\":[\"1\"],\"icon\":[\"#\"],\"visible\":[\"0\"],\"isRefresh\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-16 14:52:15');
  INSERT INTO `sys_oper_log` VALUES (226, '停车场信息管理', 2, 'com.ruoyi.custom.controller.CusParkinglotController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/custom/parkinglot/edit', '127.0.0.1', '内网IP', '{\"parkinglotId\":[\"8\"],\"parkinglotCapacity\":[\"0\"],\"userId\":[\"1\"],\"parkinglotName\":[\"北京798艺术中心-停车场\"],\"parkinglotLoc\":[\"北京市朝阳区酒仙桥路2号798艺术区\"],\"parkinglotCamera\":[\"/profile/upload/2021/10/16/3f258058-10c9-4e13-b38f-56c8d02db265.jpg\"],\"parkinglotSpare\":[\"0\"],\"image\":[\"/profile/upload/2021/10/11/d7d3fcea-a59a-4f10-b7bc-41ee35f3cbe5-show.png\"],\"imageUpdate\":[\"2021-10-16\"],\"remark\":[\"北京市朝阳区酒仙桥路2号798艺术区\"],\"btSelectAll\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-16 15:33:02');
  INSERT INTO `sys_oper_log` VALUES (227, '停车场信息管理', 2, 'com.ruoyi.custom.controller.CusParkinglotController.editSave()', 'POST', 1, 'admin', '朝外街道分公司', '/custom/parkinglot/edit', '127.0.0.1', '内网IP', '{\"parkinglotId\":[\"7\"],\"parkinglotCapacity\":[\"532\"],\"userId\":[\"1\"],\"parkinglotName\":[\"大山子停车场\"],\"parkinglotLoc\":[\"北京市朝阳区酒仙桥北路北京市朝阳区大望京公园南侧约80米\"],\"parkinglotCamera\":[\"/profile/upload/2021/10/16/ec35e250-26b5-4000-a909-b36edfc1edf5.jpg\"],\"parkinglotSpare\":[\"0\"],\"image\":[\"/profile/upload/2021/09/26/test1.jpg\"],\"imageUpdate\":[\"\"],\"remark\":[\"北京市朝阳区酒仙桥北路北京市朝阳区大望京公园南侧约80米\"],\"index\":[\"1\"],\"cusModelList[0].sizeModel\":[\"/profile/model/spot_dict.pickle\"],\"cusModelList[0].regModel\":[\"/profile/model/net\"],\"btSelectAll\":[\"\"],\"btSelectItem\":[\"\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-16 15:34:29');
  INSERT INTO `sys_oper_log` VALUES (228, '个人信息', 2, 'com.ruoyi.web.controller.system.SysProfileController.update()', 'POST', 1, 'admin', '朝外街道分公司', '/system/user/profile/update', '127.0.0.1', '内网IP', '{\"id\":[\"\"],\"userName\":[\"阿梓从小就很可爱\"],\"phonenumber\":[\"15888888888\"],\"email\":[\"ry@163.com\"],\"sex\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-16 15:37:18');
  INSERT INTO `sys_oper_log` VALUES (229, '个人信息', 2, 'com.ruoyi.web.controller.system.SysProfileController.update()', 'POST', 1, 'parking', '劲松街道分公司', '/system/user/profile/update', '127.0.0.1', '内网IP', '{\"id\":[\"\"],\"userName\":[\"嘉然今天吃什么\"],\"phonenumber\":[\"13811111111\"],\"email\":[\"824265574@qq.com\"],\"sex\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-16 15:38:02');
  INSERT INTO `sys_oper_log` VALUES (230, '个人信息', 2, 'com.ruoyi.web.controller.system.SysProfileController.update()', 'POST', 1, 'user', NULL, '/system/user/profile/update', '127.0.0.1', '内网IP', '{\"id\":[\"\"],\"userName\":[\"乃琳Queen\"],\"phonenumber\":[\"13811121111\"],\"email\":[\"15574@qq.com\"],\"sex\":[\"1\"]}', '{\"msg\":\"操作成功\",\"code\":0}', 0, NULL, '2021-10-16 15:39:07');
  
  -- ----------------------------
  -- 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 = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '岗位信息表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of sys_post
  -- ----------------------------
  INSERT INTO `sys_post` VALUES (1, 'PA', '停车场管理员', 1, '0', 'admin', '2021-09-16 12:25:13', 'admin', '2021-09-26 19:21:19', '');
  INSERT INTO `sys_post` VALUES (2, 'GT', '游客', 2, '0', 'admin', '2021-09-16 12:25:13', 'admin', '2021-09-26 19:21:38', '');
  INSERT INTO `sys_post` VALUES (3, 'HP', '居民', 3, '0', 'admin', '2021-09-16 12:25:13', 'admin', '2021-09-26 19:21:54', '');
  INSERT INTO `sys_post` VALUES (5, 'SA', '街道经理', 4, '0', 'admin', '2021-09-27 08:22:54', 'admin', '2021-09-27 08:23:08', '');
  INSERT INTO `sys_post` VALUES (6, 'QA', '区域经理', 5, '0', 'admin', '2021-09-27 08:23:56', '', NULL, 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：本部门及以下数据权限）',
    `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 = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色信息表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of sys_role
  -- ----------------------------
  INSERT INTO `sys_role` VALUES (1, '超级管理员', 'admin', 1, '1', '0', '0', 'admin', '2021-09-16 12:25:13', '', NULL, '超级管理员');
  INSERT INTO `sys_role` VALUES (2, '普通角色', 'common', 2, '2', '0', '0', 'admin', '2021-09-16 12:25:13', 'admin', '2021-09-16 13:43:23', '普通角色');
  INSERT INTO `sys_role` VALUES (3, '停车场管理员', 'manger', 3, '1', '0', '0', 'admin', '2021-09-17 19:13:48', '', NULL, NULL);
  INSERT INTO `sys_role` VALUES (4, '用户', 'user', 4, '1', '0', '0', 'admin', '2021-09-17 19:14:11', '', 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, 3);
  INSERT INTO `sys_role_menu` VALUES (2, 4);
  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 (3, 100);
  INSERT INTO `sys_role_menu` VALUES (3, 103);
  INSERT INTO `sys_role_menu` VALUES (3, 104);
  INSERT INTO `sys_role_menu` VALUES (3, 1000);
  INSERT INTO `sys_role_menu` VALUES (3, 1001);
  INSERT INTO `sys_role_menu` VALUES (3, 1002);
  INSERT INTO `sys_role_menu` VALUES (3, 1003);
  INSERT INTO `sys_role_menu` VALUES (3, 1004);
  INSERT INTO `sys_role_menu` VALUES (3, 1005);
  INSERT INTO `sys_role_menu` VALUES (3, 1006);
  INSERT INTO `sys_role_menu` VALUES (3, 1016);
  INSERT INTO `sys_role_menu` VALUES (3, 1017);
  INSERT INTO `sys_role_menu` VALUES (3, 1018);
  INSERT INTO `sys_role_menu` VALUES (3, 1019);
  INSERT INTO `sys_role_menu` VALUES (3, 1020);
  INSERT INTO `sys_role_menu` VALUES (3, 1021);
  INSERT INTO `sys_role_menu` VALUES (3, 1022);
  INSERT INTO `sys_role_menu` VALUES (3, 1023);
  INSERT INTO `sys_role_menu` VALUES (3, 1024);
  INSERT INTO `sys_role_menu` VALUES (3, 2000);
  INSERT INTO `sys_role_menu` VALUES (3, 2013);
  INSERT INTO `sys_role_menu` VALUES (3, 2014);
  INSERT INTO `sys_role_menu` VALUES (3, 2015);
  INSERT INTO `sys_role_menu` VALUES (3, 2016);
  INSERT INTO `sys_role_menu` VALUES (3, 2017);
  INSERT INTO `sys_role_menu` VALUES (3, 2018);
  INSERT INTO `sys_role_menu` VALUES (3, 2019);
  INSERT INTO `sys_role_menu` VALUES (3, 2020);
  INSERT INTO `sys_role_menu` VALUES (3, 2021);
  INSERT INTO `sys_role_menu` VALUES (3, 2022);
  INSERT INTO `sys_role_menu` VALUES (3, 2023);
  INSERT INTO `sys_role_menu` VALUES (3, 2024);
  INSERT INTO `sys_role_menu` VALUES (3, 2025);
  INSERT INTO `sys_role_menu` VALUES (3, 2026);
  INSERT INTO `sys_role_menu` VALUES (3, 2027);
  INSERT INTO `sys_role_menu` VALUES (3, 2028);
  INSERT INTO `sys_role_menu` VALUES (4, 2029);
  INSERT INTO `sys_role_menu` VALUES (4, 2030);
  
  -- ----------------------------
  -- 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',
    `login_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登录账号',
    `user_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户昵称',
    `user_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '00' COMMENT '用户类型（00系统用户 01注册用户）',
    `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(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '密码',
    `salt` varchar(20) 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 '最后登录时间',
    `pwd_update_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 = 103 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', '/profile/avatar/2021/10/09/ce5f3c6d-da92-44e0-811f-7d84a2ffce82.png', '29c67a30398638269fe600f73a054934', '111111', '0', '0', '127.0.0.1', '2021-10-18 08:17:26', '2021-09-16 12:25:13', 'admin', '2021-09-16 12:25:13', '', '2021-10-18 08:17:25', '管理员');
  INSERT INTO `sys_user` VALUES (2, 105, 'ry', '若依', '00', 'ry@qq.com', '15666666666', '1', '', '8e6d98b90472783cc73c17047ddccf36', '222222', '0', '0', '127.0.0.1', '2021-09-16 12:25:13', '2021-09-16 12:25:13', 'admin', '2021-09-16 12:25:13', '', NULL, '测试员');
  INSERT INTO `sys_user` VALUES (100, NULL, 'lili', 'lili', '00', '', '', '0', '', '3fa6fe9ae8b1e7e4cc8bcc895d97f098', '7ed733', '0', '2', '127.0.0.1', '2021-09-16 13:43:41', NULL, 'admin', '2021-09-16 13:09:31', '', '2021-09-16 13:43:40', NULL);
  INSERT INTO `sys_user` VALUES (101, 104, 'parking', '嘉然今天吃什么', '00', '824265574@qq.com', '13811111111', '1', '/profile/avatar/2021/10/09/b123ff63-22c2-4bea-9d26-75ac4ddc6687.png', 'bb03a02242afbcf205c81e9800af5612', 'e8182e', '0', '0', '127.0.0.1', '2021-10-16 15:39:53', NULL, 'admin', '2021-09-17 19:15:06', 'admin', '2021-10-16 15:39:52', '');
  INSERT INTO `sys_user` VALUES (102, NULL, 'user', '乃琳Queen', '00', '15574@qq.com', '13811121111', '1', '/profile/avatar/2021/10/09/3621957e-8498-46d2-87ff-edfcffee0376.png', 'b80df959969a523a348f9d7d850bc093', 'bf8484', '0', '0', '127.0.0.1', '2021-10-16 15:45:38', NULL, 'admin', '2021-09-17 19:15:23', 'admin', '2021-10-16 15:45:38', '');
  
  -- ----------------------------
  -- Table structure for sys_user_online
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_user_online`;
  CREATE TABLE `sys_user_online`  (
    `sessionId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户会话id',
    `login_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 '部门名称',
    `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` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '在线状态on_line在线off_line离线',
    `start_timestamp` datetime(0) NULL DEFAULT NULL COMMENT 'session创建时间',
    `last_access_time` datetime(0) NULL DEFAULT NULL COMMENT 'session最后访问时间',
    `expire_time` int(5) NULL DEFAULT 0 COMMENT '超时时间，单位为分钟',
    PRIMARY KEY (`sessionId`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '在线用户记录' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of sys_user_online
  -- ----------------------------
  INSERT INTO `sys_user_online` VALUES ('89186227-b8c4-48fc-9b1d-6359dd82b725', 'admin', '朝外街道分公司', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', 'on_line', '2021-10-18 07:57:27', '2021-10-18 08:17:26', 1800000);
  
  -- ----------------------------
  -- 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 (101, 3);
  INSERT INTO `sys_user_role` VALUES (102, 4);
  
  SET FOREIGN_KEY_CHECKS = 1;
  