soc/project_data/sql/0.0.2/soc/soc.sql

-- -------------------------------------------------------
-- ----------新增表脚本 start ----------------------------
-- -------------------------------------------------------
DROP TABLE
IF
	EXISTS `sync_fjnx_org_move`;
CREATE TABLE `sync_fjnx_org_move` (
	`id` BIGINT NOT NULL AUTO_INCREMENT,
	`org_code` VARCHAR ( 64 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '特殊机构编码',
	`org_type` INT DEFAULT NULL COMMENT '1: 部门（强行将机构类型指定为部门） 2： 机构  （强行将机构类型指定为机构）',
	PRIMARY KEY ( `id` ) USING BTREE 
) ENGINE = INNODB AUTO_INCREMENT = 98 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '配置特殊的机构和部门机构，决定是否要移动到机关机构下';
DROP TABLE
IF
	EXISTS `core_question_flow`;
CREATE TABLE `core_question_flow` (
	`id` BIGINT NOT NULL,
	`question_id` BIGINT DEFAULT NULL COMMENT '隐患问题id',
	`executor_id` BIGINT DEFAULT NULL COMMENT '流程执行人',
	`executor_name` VARCHAR ( 32 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '流程执行人姓名',
	`execute_time` datetime DEFAULT NULL COMMENT '流程操作时间',
	`execute_status` INT DEFAULT NULL COMMENT '流程执行结果。0：通过、1：未通过',
	`execute_step` INT DEFAULT NULL COMMENT '流程执行步骤.1确认，2异议审批,11整改',
	`description` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行描述',
	`reform_date` datetime DEFAULT NULL COMMENT '整改时间',
	`images` VARCHAR ( 1024 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '流程相关图片',
	PRIMARY KEY ( `id` ) 
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '隐患问题审批流程';
DROP TABLE
IF
	EXISTS `core_question`;
CREATE TABLE `core_question` (
	`id` BIGINT NOT NULL,
	`org_id` BIGINT DEFAULT NULL COMMENT '隐患所属机构',
	`org_name` VARCHAR ( 64 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '隐患所属机构名称',
	`org_path` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '隐患所属机构path',
	`src_type` INT DEFAULT NULL COMMENT '来源，1：履职，2：安全检查',
	`src_task_id` BIGINT DEFAULT NULL COMMENT '来源任务id',
	`src_task_name` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '来源任务名称',
	`src_point_id` BIGINT DEFAULT NULL COMMENT '检查、履职内容id',
	`src_data_point_id` BIGINT DEFAULT NULL COMMENT '检查、履职登记内容id',
	`check_item` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '检查、履职项名称',
	`check_content` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '检查内容',
	`question_desc` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '隐患描述',
	`submitor_id` BIGINT DEFAULT NULL COMMENT '提出人id',
	`submitor_name` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '提出人名称',
	`submit_time` datetime DEFAULT NULL COMMENT '发现时间',
	`confirm_status` INT DEFAULT NULL COMMENT '确认状态。0未确认，1提出异议，2已确认，3已关闭',
	`reform_status` INT DEFAULT NULL COMMENT '整改状态。10未整改，11已整改',
	`reform_deadline` datetime DEFAULT NULL COMMENT '整改期限',
	`create_time` datetime DEFAULT NULL,
	`update_time` datetime DEFAULT NULL,
	`create_by` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
	`update_by` VARCHAR ( 32 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
	PRIMARY KEY ( `id` ) 
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '隐患问题清单';
DROP TABLE
IF
	EXISTS `core_announcement_notification`;
CREATE TABLE `core_announcement_notification` (
	`id` BIGINT ( 0 ) NOT NULL,
	`org_id` BIGINT ( 0 ) NULL DEFAULT NULL COMMENT '机构',
	`org_name` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '机构',
	`org_path` VARCHAR ( 500 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '机构',
	`title` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
	`content` text CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容',
	`messag_type` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息类型0公告1通知',
	`tag_org_type` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '机构类型',
	`create_by` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
	`create_time` datetime ( 0 ) NULL DEFAULT NULL COMMENT '创建时间',
	`publish_time` datetime ( 0 ) NULL DEFAULT NULL COMMENT '发布时间',
	`messag_status` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态',
	`update_by` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`update_time` datetime ( 0 ) NULL DEFAULT NULL,
	`file_list` text CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '文件',
	PRIMARY KEY ( `id` ) USING BTREE,
	INDEX `org_id_indx` ( `org_id` ) USING BTREE,
	INDEX `org_path_index` ( `org_path` ) USING BTREE 
) ENGINE = INNODB CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '公告通知' ROW_FORMAT = Dynamic;
DROP TABLE
IF
	EXISTS `core_announcement_notification_to_org`;
CREATE TABLE `core_announcement_notification_to_org` (
	`announcement_notification_id` BIGINT ( 0 ) NOT NULL,
	`org_id` BIGINT ( 0 ) NULL DEFAULT NULL,
	INDEX `notification_id_index` ( `announcement_notification_id` ) USING BTREE,
	INDEX `org_id_index` ( `org_id` ) USING BTREE 
) ENGINE = INNODB CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知公告机构关联表' ROW_FORMAT = Dynamic;
DROP TABLE
IF
	EXISTS `core_announcement_notification_to_role`;
CREATE TABLE `core_announcement_notification_to_role` (
	`announcement_notification_id` BIGINT ( 0 ) NOT NULL,
	`role_id` BIGINT ( 0 ) NULL DEFAULT NULL,
	INDEX `notification_id_index` ( `announcement_notification_id` ) USING BTREE,
	INDEX `role_id_index` ( `role_id` ) USING BTREE 
) ENGINE = INNODB CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '公告通知角色关联表' ROW_FORMAT = Dynamic;
DROP TABLE
IF
	EXISTS `core_announcement_notification_to_user`;
CREATE TABLE `core_announcement_notification_to_user` (
	`id` BIGINT ( 0 ) NOT NULL,
	`announcement_notification_id` BIGINT ( 0 ) NULL DEFAULT NULL COMMENT '公告通知id',
	`org_id` BIGINT ( 0 ) NULL DEFAULT NULL COMMENT '机构id',
	`role_id` BIGINT ( 0 ) NULL DEFAULT NULL COMMENT '角色id',
	`user_id` BIGINT ( 0 ) NULL DEFAULT NULL COMMENT '用户id',
	PRIMARY KEY ( `id` ) USING BTREE,
	INDEX `user_id_index` ( `user_id` ) USING BTREE,
	INDEX `announcement_notification_id_index` ( `announcement_notification_id` ) USING BTREE 
) ENGINE = INNODB CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '公告通知查看记录表' ROW_FORMAT = Dynamic;
DROP TABLE
IF
	EXISTS `core_weather_warning`;
CREATE TABLE `core_weather_warning` (
	`id` BIGINT ( 0 ) NOT NULL AUTO_INCREMENT,
	`alarm_title` VARCHAR ( 100 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预警标题',
	`alarm_content` VARCHAR ( 500 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预警内容',
	`alarm_level` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预警等级',
	`province` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省',
	`city` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市',
	`area` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区、县（没得区县用市）',
	`code` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市区县的编号',
	`alarm_type` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预警类型',
	`alarm_time` datetime ( 0 ) NULL DEFAULT NULL COMMENT '预警发布时间',
	`create_time` datetime ( 0 ) NULL DEFAULT NULL COMMENT '创建时间',
	PRIMARY KEY ( `id` ) USING BTREE,
	INDEX `code` ( `code` ) USING BTREE 
) ENGINE = INNODB AUTO_INCREMENT = 4 CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '天气预警数据' ROW_FORMAT = Dynamic;
DROP TABLE
IF
	EXISTS `core_weather_city`;
CREATE TABLE `core_weather_city` (
	`AREACODE` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`AREAID` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`NAMEEN` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`NAMECN` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`DISTRICTEN` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`DISTRICTCN` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`PROVEN` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`PROVCN` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`NATIONEN` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`NATIONCN` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`GROUPID` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL 
) ENGINE = INNODB AUTO_INCREMENT = 97 CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '预警城市列表' ROW_FORMAT = Dynamic;
DROP TABLE
IF
	EXISTS `core_safety_task`;
CREATE TABLE `core_safety_task` (
	`id` VARCHAR ( 32 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
	`title` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题',
	`create_time` datetime ( 6 ) DEFAULT NULL COMMENT '创建时间',
	`modified_id` BIGINT DEFAULT NULL COMMENT '最后修改人id',
	`modified_name` VARCHAR ( 32 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人名称',
	`update_time` datetime ( 6 ) DEFAULT NULL COMMENT '更新时间',
	`exception_count` INT DEFAULT '0' COMMENT '异常数目',
	`org_id` BIGINT DEFAULT '0' COMMENT '受检机构',
	`org_name` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '受检机构',
	`org_path` VARCHAR ( 200 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '受检机构',
	`check_org_id` BIGINT DEFAULT NULL COMMENT '执行检查机构',
	`check_org_name` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行检查机构',
	`status` INT DEFAULT NULL COMMENT '0待检查,1检查完成',
	`check_type` INT DEFAULT NULL COMMENT '0 常规安全检查 1 专项安全检查',
	`check_cycle` INT DEFAULT '0' COMMENT '检查周期:0 无周期 1每日、2每周、3每月、4每季、5每半年、6每年',
	`ymd_date` date DEFAULT NULL COMMENT '年月日',
	`ymd_day` INT DEFAULT NULL COMMENT '日',
	`ymd_month` INT DEFAULT NULL COMMENT '月',
	`ymd_quarter` INT DEFAULT NULL COMMENT '季',
	`ymd_week` INT DEFAULT NULL COMMENT '周',
	`ymd_year` INT DEFAULT NULL COMMENT '年',
	`ymd_halfyear` INT DEFAULT NULL COMMENT '半年',
	`submit_by` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '提交人',
	`submit_time` datetime DEFAULT NULL COMMENT '提交时间',
	`plan_id` BIGINT DEFAULT NULL COMMENT '计划id',
	`start_time` datetime DEFAULT NULL COMMENT '任务执行开始时间',
	`end_time` datetime DEFAULT NULL COMMENT '任务执行结束时间',
	`plan_start_time` datetime DEFAULT NULL COMMENT '计划开始时间',
	`plan_end_time` datetime DEFAULT NULL COMMENT '计划截止时间',
	`role_id` BIGINT DEFAULT NULL COMMENT '角色id',
	`deleted` INT DEFAULT '0' COMMENT '是否删除0否1是',
	`is_question` INT DEFAULT NULL COMMENT '0:未整改 1:已开始整改',
	`batch_id` VARCHAR ( 64 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '批次id,同一执行机构一个批次id',
	`source_type` INT DEFAULT '0' COMMENT '数据来源 0：检查计划 ，1：登记检查结果',
	`pdf_url` VARCHAR ( 500 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '登记簿pdf 文件地址',
	PRIMARY KEY ( `id` ) USING BTREE,
	KEY `idx_resumption_orgId` ( `org_id` ) USING BTREE,
	KEY `idx_orgpath` (
	`org_path` ( 191 )) USING BTREE 
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;
DROP TABLE
IF
	EXISTS `core_safety_task_data`;
CREATE TABLE `core_safety_task_data` (
	`id` BIGINT NOT NULL DEFAULT '0',
	`plan_id` BIGINT DEFAULT NULL COMMENT '计划id',
	`item_id` BIGINT DEFAULT NULL COMMENT '检查项id',
	`point_id` BIGINT DEFAULT NULL COMMENT '要点id',
	`task_id` VARCHAR ( 100 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '检查任务id',
	`area_id` BIGINT DEFAULT NULL COMMENT '区域id',
	`res_value` INT DEFAULT NULL COMMENT '正常不正常，通过不通过，合格不合格',
	`reform_type` INT DEFAULT NULL COMMENT '整改类型',
	`res_time` datetime DEFAULT NULL COMMENT '时分',
	`submit_time` datetime DEFAULT NULL COMMENT '提交时间',
	`res_status` INT DEFAULT NULL COMMENT '0未提交 1正常提交 2延迟提交',
	`submit_by` BIGINT DEFAULT NULL COMMENT '提交人id',
	`submit_name` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '提交人名',
	PRIMARY KEY ( `id` ) USING BTREE,
	KEY `item_id` ( `point_id` ) USING BTREE,
	KEY `check_task_id` ( `task_id` ) USING BTREE 
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查项表';
DROP TABLE
IF
	EXISTS `core_resumption_configuration`;
CREATE TABLE `core_resumption_configuration` (
	`id` BIGINT NOT NULL COMMENT '主键',
	`resumption_cycle` VARCHAR ( 2 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '履职周期',
	`create_by` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
	`create_time` datetime DEFAULT NULL,
	`update_by` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
	`update_time` datetime DEFAULT NULL,
	`del_flag` VARCHAR ( 2 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
	`all_day` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '全天',
	`front` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '营业前',
	`centre` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '营业中',
	`after` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '营业后',
	`time_unit` VARCHAR ( 2 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '时间单位',
	PRIMARY KEY ( `id` ) USING BTREE 
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '履职任务定时提醒';
DROP TABLE
IF
	EXISTS `core_safety_task_data_nfc`;
CREATE TABLE `core_safety_task_data_nfc` (
	`id` BIGINT NOT NULL DEFAULT '0',
	`task_id` VARCHAR ( 100 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '检查任务id',
	`task_data_id` BIGINT DEFAULT NULL COMMENT '安全检查项id',
	`check_id` BIGINT NOT NULL DEFAULT '0' COMMENT '采集点id',
	`submit_time` datetime DEFAULT NULL COMMENT '提交时间',
	`status` INT DEFAULT '0' COMMENT '状态0未扫1以扫',
	`point_id` BIGINT DEFAULT NULL COMMENT '要点id',
	PRIMARY KEY ( `id` ) USING BTREE,
	KEY `task_id` ( `task_id` ) USING BTREE 
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查nfc扫描表';
DROP TABLE
IF
	EXISTS `core_message_send`;
CREATE TABLE `core_message_send` (
	`id` BIGINT NOT NULL COMMENT '主键',
	`title` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题',
	`type` VARCHAR ( 2 ) COLLATE utf8mb4_general_ci DEFAULT NULL,
	`content` VARCHAR ( 4000 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '内容',
	`send_user` BIGINT DEFAULT NULL COMMENT '按用户选择',
	`send_role` BIGINT DEFAULT NULL COMMENT '按角色选择',
	`send_time_type` VARCHAR ( 2 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '发送时间类型1立即2指定时间',
	`send_time` datetime DEFAULT NULL COMMENT '发送时间',
	`del_flag` VARCHAR ( 2 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '0未2删',
	`send_status` VARCHAR ( 2 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '1已发送2待发送',
	`create_time` datetime DEFAULT NULL COMMENT '创建时间',
	`create_by` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
	`update_time` datetime DEFAULT NULL COMMENT '修改时间',
	`update_by` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
	PRIMARY KEY ( `id` ) 
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '消息发送配置';
DROP TABLE
IF
	EXISTS `core_message_center`;
CREATE TABLE `core_message_center` (
	`id` BIGINT NOT NULL,
	`type` VARCHAR ( 2 ) COLLATE utf8mb4_general_ci NOT NULL COMMENT '1公告2业务提醒3消息',
	`title` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题',
	`is_read` VARCHAR ( 2 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '0未读1已读',
	`content` VARCHAR ( 4000 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '内容',
	`del_flag` VARCHAR ( 2 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '0未2删',
	`user_id` BIGINT DEFAULT NULL COMMENT '用户',
	`create_by` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
	`create_time` datetime DEFAULT NULL COMMENT '创建时间',
	`update_by` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
	`update_time` datetime DEFAULT NULL COMMENT '修改时间',
	PRIMARY KEY ( `id` ) 
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '消息中心';
DROP TABLE
IF
	EXISTS `core_safety_task_data_remark`;
CREATE TABLE `core_safety_task_data_remark` (
	`id` BIGINT NOT NULL DEFAULT '0',
	`task_data_id` BIGINT DEFAULT NULL COMMENT '检查项id',
	`task_id` VARCHAR ( 100 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '检查任务id',
	`remark` VARCHAR ( 500 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '问题描述',
	PRIMARY KEY ( `id` ) USING BTREE,
	KEY `task_item_id` ( `task_data_id` ) USING BTREE 
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查项表问题描述表';
DROP TABLE
IF
	EXISTS `core_safety_task_data_remarkimg`;
CREATE TABLE `core_safety_task_data_remarkimg` (
	`id` BIGINT NOT NULL DEFAULT '0',
	`task_id` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '安全检查任务id',
	`task_data_id` BIGINT DEFAULT NULL COMMENT '安全检查项id',
	`remark_id` BIGINT DEFAULT NULL COMMENT '安全检查项问题描述id',
	`img_path` VARCHAR ( 200 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片存放路径',
	PRIMARY KEY ( `id` ) USING BTREE,
	KEY `data_id` ( `remark_id` ) USING BTREE 
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查产生图片表';
DROP TABLE
IF
	EXISTS `core_safety_task`;
CREATE TABLE `core_safety_task` (
	`id` BIGINT NOT NULL,
	`title` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题',
	`create_time` datetime ( 6 ) DEFAULT NULL COMMENT '创建时间',
	`modified_id` BIGINT DEFAULT NULL COMMENT '最后修改人id',
	`modified_name` VARCHAR ( 32 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人名称',
	`update_time` datetime ( 6 ) DEFAULT NULL COMMENT '更新时间',
	`exception_count` INT DEFAULT '0' COMMENT '异常数目',
	`org_id` BIGINT DEFAULT '0' COMMENT '受检机构',
	`org_name` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '受检机构',
	`org_path` VARCHAR ( 200 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '受检机构',
	`check_org_id` BIGINT DEFAULT NULL COMMENT '执行检查机构',
	`check_org_name` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行检查机构',
	`status` INT DEFAULT NULL COMMENT '0待检查,1检查完成',
	`done_status` INT DEFAULT NULL COMMENT '0:代办,1:逾期,2:按时,3:补登',
	`check_type` INT DEFAULT NULL COMMENT '0 常规安全检查 1 专项安全检查',
	`check_cycle` INT DEFAULT '0' COMMENT '检查周期:0 无周期 1每日、2每周、3每月、4每季、5每半年、6每年',
	`ymd_date` date DEFAULT NULL COMMENT '年月日',
	`ymd_day` INT DEFAULT NULL COMMENT '日',
	`ymd_month` INT DEFAULT NULL COMMENT '月',
	`ymd_quarter` INT DEFAULT NULL COMMENT '季',
	`ymd_week` INT DEFAULT NULL COMMENT '周',
	`ymd_year` INT DEFAULT NULL COMMENT '年',
	`ymd_halfyear` INT DEFAULT NULL COMMENT '半年',
	`submit_by` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '提交人',
	`submit_time` datetime DEFAULT NULL COMMENT '提交时间',
	`plan_id` BIGINT DEFAULT NULL COMMENT '计划id',
	`start_time` datetime DEFAULT NULL COMMENT '任务执行开始时间',
	`end_time` datetime DEFAULT NULL COMMENT '任务执行结束时间',
	`plan_start_time` datetime DEFAULT NULL COMMENT '计划开始时间',
	`plan_end_time` datetime DEFAULT NULL COMMENT '计划截止时间',
	`role_id` BIGINT DEFAULT NULL COMMENT '角色id',
	`deleted` INT DEFAULT '0' COMMENT '是否删除0否1是',
	`is_question` INT DEFAULT NULL COMMENT '0:未整改 1:已开始整改',
	`batch_id` BIGINT DEFAULT NULL COMMENT '批次id,同一执行机构一个批次id',
	`source_type` INT DEFAULT '0' COMMENT '数据来源 0：检查计划 ，1：登记检查结果',
	`pdf_url` VARCHAR ( 500 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '登记簿pdf 文件地址',
	`des` VARCHAR ( 4000 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
	PRIMARY KEY ( `id` ) USING BTREE,
	KEY `idx_resumption_orgId` ( `org_id` ) USING BTREE,
	KEY `idx_orgpath` (
	`org_path` ( 191 )) USING BTREE 
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;
DROP TABLE
IF
	EXISTS `core_safecheck_plan`;
CREATE TABLE `core_safecheck_plan` (
	`id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
	`plan_name` VARCHAR ( 100 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '计划名称',
	`plan_cycle` INT NULL DEFAULT NULL COMMENT '计划周期：每日，每周，每月，每季度，每半年，每年 ,无周期',
	`exec_org_type` INT NULL DEFAULT NULL COMMENT '检查机构类型',
	`check_org_type` INT NULL DEFAULT NULL COMMENT '受检机构类型',
	`plan_status` INT NULL DEFAULT NULL COMMENT '计划状态：0：启用，1禁用',
	`start_date` datetime NULL DEFAULT NULL COMMENT '开始日期',
	`end_date` datetime NULL DEFAULT NULL COMMENT '结束日期',
	`build_task_now` VARCHAR ( 1 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '立即生成任务',
	`description` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
	`is_deleted` VARCHAR ( 1 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '\0' COMMENT '是否删除',
	`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
	`modified_name` VARCHAR ( 30 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人名称',
	`update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
	`modified_by` BIGINT NULL DEFAULT NULL COMMENT '修改人id',
	`source_type` INT NULL DEFAULT 0 COMMENT '数据来源 0：检查计划 ，1：登记检查结果',
	`plan_create_org_id` BIGINT NULL DEFAULT NULL COMMENT '计划创建机构id',
	`plan_of_org_id` BIGINT NULL DEFAULT NULL COMMENT '计划所属机构id',
	`check_type` INT NULL DEFAULT NULL COMMENT '检查类型',
	`count` INT NULL DEFAULT NULL COMMENT '检查次数',
	`modified_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
	`create_by` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`update_by` VARCHAR ( 32 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`exec_org` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '检查机构',
	`check_org` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '受检机构',
	`des` VARCHAR ( 4000 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
	`distribute_status` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '下发状态',
	`distribute_plan_status` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '计划下发默认状态',
	`parent_id` BIGINT NULL DEFAULT - 1 COMMENT '下发父计划id',
	PRIMARY KEY ( `id` ) USING BTREE 
) ENGINE = INNODB AUTO_INCREMENT = 1705420577829208067 CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '常规安全检查计划表' ROW_FORMAT = Dynamic;
DROP TABLE
IF
	EXISTS `core_safecheck_plan_to_check_org`;
CREATE TABLE `core_safecheck_plan_to_check_org` (
	`plan_id` BIGINT NOT NULL COMMENT '计划id',
	`org_id` BIGINT NOT NULL COMMENT '机构id',
	`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
	`update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
	`create_by` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`update_by` VARCHAR ( 32 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL 
) ENGINE = INNODB CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '常规安全检查-受检机构关联表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for core_safecheck_plan_to_exec_org
-- ----------------------------
DROP TABLE
IF
	EXISTS `core_safecheck_plan_to_exec_org`;
CREATE TABLE `core_safecheck_plan_to_exec_org` (
	`plan_id` BIGINT NOT NULL COMMENT '计划id',
	`org_id` BIGINT NOT NULL COMMENT '机构id',
	`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
	`update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
	`create_by` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`update_by` VARCHAR ( 32 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL 
) ENGINE = INNODB CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '常规安全检查-检查机构关系表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for core_safecheck_plan_to_point
-- ----------------------------
DROP TABLE
IF
	EXISTS `core_safecheck_plan_to_point`;
CREATE TABLE `core_safecheck_plan_to_point` (
	`plan_id` BIGINT NOT NULL COMMENT '计划id',
	`point_id` BIGINT NOT NULL COMMENT '检查要点id',
	`point_scan` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否扫描NFC 1扫描，0不扫描',
	`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
	`update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
	`create_by` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`update_by` VARCHAR ( 32 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`required` TINYINT ( 1 ) NULL DEFAULT NULL 
) ENGINE = INNODB CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '常规安全检查计划要点关联表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for core_safecheck_plan_to_role
-- ----------------------------
DROP TABLE
IF
	EXISTS `core_safecheck_plan_to_role`;
CREATE TABLE `core_safecheck_plan_to_role` (
	`plan_id` BIGINT NOT NULL COMMENT '计划id',
	`role_id` BIGINT NOT NULL COMMENT '角色id',
	`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
	`update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
	`create_by` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`update_by` VARCHAR ( 32 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL 
) ENGINE = INNODB CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '常规安全检查计划执行角色关联表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for core_safety_task
-- ----------------------------
DROP TABLE
IF
	EXISTS `core_safety_task`;
CREATE TABLE `core_safety_task` (
	`id` BIGINT NOT NULL,
	`title` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
	`exception_count` INT NULL DEFAULT 0 COMMENT '异常数目',
	`org_id` BIGINT NULL DEFAULT 0 COMMENT '受检机构',
	`org_name` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '受检机构',
	`org_path` VARCHAR ( 200 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '受检机构',
	`check_org_id` BIGINT NULL DEFAULT NULL COMMENT '执行检查机构',
	`check_org_name` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行检查机构',
	`status` INT NULL DEFAULT NULL COMMENT '0待检查,1检查完成',
	`done_status` INT NULL DEFAULT NULL COMMENT '0:代办,1:逾期,2:按时,3:补登',
	`check_type` INT NULL DEFAULT NULL COMMENT '0 常规安全检查 1 专项安全检查',
	`check_cycle` INT NULL DEFAULT 0 COMMENT '检查周期:0 无周期 1每日、2每周、3每月、4每季、5每半年、6每年',
	`ymd_date` date NULL DEFAULT NULL COMMENT '年月日',
	`ymd_day` INT NULL DEFAULT NULL COMMENT '日',
	`ymd_month` INT NULL DEFAULT NULL COMMENT '月',
	`ymd_quarter` INT NULL DEFAULT NULL COMMENT '季',
	`ymd_week` INT NULL DEFAULT NULL COMMENT '周',
	`ymd_year` INT NULL DEFAULT NULL COMMENT '年',
	`ymd_halfyear` INT NULL DEFAULT NULL COMMENT '半年',
	`submitor_id` BIGINT NULL DEFAULT NULL COMMENT '提交人id',
	`submit_by` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '提交人',
	`submit_time` datetime NULL DEFAULT NULL COMMENT '提交时间',
	`plan_id` BIGINT NULL DEFAULT NULL COMMENT '计划id',
	`start_time` datetime NULL DEFAULT NULL COMMENT '任务执行开始时间',
	`end_time` datetime NULL DEFAULT NULL COMMENT '任务执行结束时间',
	`plan_start_time` datetime NULL DEFAULT NULL COMMENT '计划开始时间',
	`plan_end_time` datetime NULL DEFAULT NULL COMMENT '计划截止时间',
	`role_id` BIGINT NULL DEFAULT NULL COMMENT '角色id',
	`deleted` INT NULL DEFAULT 0 COMMENT '是否删除0否1是',
	`is_question` INT NULL DEFAULT NULL COMMENT '0:未整改 1:已开始整改',
	`batch_id` BIGINT NULL DEFAULT NULL COMMENT '批次id,同一执行机构一个批次id',
	`source_type` INT NULL DEFAULT 0 COMMENT '数据来源 0：检查计划 ，1：登记检查结果',
	`pdf_url` VARCHAR ( 500 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登记簿pdf 文件地址',
	`des` VARCHAR ( 4000 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
	`check_team` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '检查组成员',
	`grant_user_id` BIGINT NULL DEFAULT NULL COMMENT '被授权的用户id',
	`create_time` datetime NULL DEFAULT NULL,
	`update_time` datetime NULL DEFAULT NULL,
	`create_by` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`update_by` VARCHAR ( 32 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	PRIMARY KEY ( `id` ) USING BTREE,
	INDEX `idx_resumption_orgId` ( `org_id` ASC ) USING BTREE,
	INDEX `idx_orgpath` ( `org_path` ( 191 ) ASC ) USING BTREE 
) ENGINE = INNODB CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for core_safety_task_data
-- ----------------------------
DROP TABLE
IF
	EXISTS `core_safety_task_data`;
CREATE TABLE `core_safety_task_data` (
	`id` BIGINT NOT NULL DEFAULT 0,
	`plan_id` BIGINT NULL DEFAULT NULL COMMENT '计划id',
	`item_id` BIGINT NULL DEFAULT NULL COMMENT '检查项id',
	`point_id` BIGINT NULL DEFAULT NULL COMMENT '要点id',
	`task_id` BIGINT NULL DEFAULT NULL COMMENT '检查任务id',
	`area_id` BIGINT NULL DEFAULT NULL COMMENT '区域id',
	`value` INT NULL DEFAULT NULL COMMENT '正常不正常，通过不通过，合格不合格',
	`remark` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '问题描述',
	`submit_time` datetime NULL DEFAULT NULL COMMENT '提交时间',
	`submit_by` BIGINT NULL DEFAULT NULL COMMENT '提交人id',
	`submit_name` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '提交人名',
	`is_add` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否为登记界面新增的。0：否，1：是',
	`rectification_deadline` VARCHAR ( 6 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '整改期限字典值',
	PRIMARY KEY ( `id` ) USING BTREE,
	INDEX `item_id` ( `point_id` ASC ) USING BTREE,
	INDEX `check_task_id` ( `task_id` ASC ) USING BTREE 
) ENGINE = INNODB CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查项表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for core_safety_task_data_nfc
-- ----------------------------
DROP TABLE
IF
	EXISTS `core_safety_task_data_nfc`;
CREATE TABLE `core_safety_task_data_nfc` (
	`id` BIGINT NOT NULL DEFAULT 0,
	`task_id` BIGINT NULL DEFAULT NULL COMMENT '检查任务id',
	`task_data_id` BIGINT NULL DEFAULT NULL COMMENT '安全检查项id',
	`nfc_id` BIGINT NOT NULL DEFAULT 0 COMMENT 'NFC id',
	`submit_time` datetime NULL DEFAULT NULL COMMENT '提交时间',
	`status` INT NULL DEFAULT 0 COMMENT '状态0未扫1以扫',
	`point_id` BIGINT NULL DEFAULT NULL COMMENT '要点id',
	`scan_method` INT NULL DEFAULT NULL COMMENT '0:扫描，1：拍照',
	`img` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '拍照路径',
	PRIMARY KEY ( `id` ) USING BTREE,
	INDEX `task_id` ( `task_id` ASC ) USING BTREE 
) ENGINE = INNODB CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查nfc扫描表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for core_safety_task_data_remarkimg
-- ----------------------------
DROP TABLE
IF
	EXISTS `core_safety_task_data_remarkimg`;
CREATE TABLE `core_safety_task_data_remarkimg` (
	`id` BIGINT NOT NULL DEFAULT 0,
	`task_id` BIGINT NULL DEFAULT NULL COMMENT '安全检查任务id',
	`task_data_id` BIGINT NULL DEFAULT NULL COMMENT '安全检查项id',
	`img_path` VARCHAR ( 200 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片存放路径',
	PRIMARY KEY ( `id` ) USING BTREE 
) ENGINE = INNODB CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查产生图片表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for core_safetycheck_rule
-- ----------------------------
DROP TABLE
IF
	EXISTS `core_safetycheck_rule`;
CREATE TABLE `core_safetycheck_rule` (
	`id` BIGINT NOT NULL AUTO_INCREMENT,
	`type` VARCHAR ( 100 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '类型',
	`name` VARCHAR ( 125 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称',
	`status` CHAR ( 1 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '0:禁用 1:启用',
	`org_id` BIGINT NOT NULL COMMENT '发布机构',
	`org_type` VARCHAR ( 100 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '机构类型',
	`remark` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '备注',
	`create_time` datetime NULL DEFAULT NULL,
	`update_time` datetime NULL DEFAULT NULL,
	`create_by` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`update_by` VARCHAR ( 32 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`deleted` INT NULL DEFAULT NULL COMMENT '0:未删除 、1：删除',
	PRIMARY KEY ( `id` ) USING BTREE 
) ENGINE = INNODB AUTO_INCREMENT = 1701795990306471938 CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '安全检查内容库定义\r\n' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for core_safetycheck_rule_item
-- ----------------------------
DROP TABLE
IF
	EXISTS `core_safetycheck_rule_item`;
CREATE TABLE `core_safetycheck_rule_item` (
	`id` BIGINT NOT NULL AUTO_INCREMENT,
	`rule_id` BIGINT NOT NULL COMMENT '安全检查内容库定义id',
	`name` VARCHAR ( 100 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '检查项名称',
	`desc` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
	`create_time` datetime NULL DEFAULT NULL,
	`update_time` datetime NULL DEFAULT NULL,
	`create_by` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`update_by` VARCHAR ( 32 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`deleted` INT NULL DEFAULT NULL COMMENT '删除状态，0未删除，1已删除',
	PRIMARY KEY ( `id` ) USING BTREE 
) ENGINE = INNODB AUTO_INCREMENT = 1705410983891484674 CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查内容库-检查项' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for core_safetycheck_rule_point
-- ----------------------------
DROP TABLE
IF
	EXISTS `core_safetycheck_rule_point`;
CREATE TABLE `core_safetycheck_rule_point` (
	`id` BIGINT NOT NULL AUTO_INCREMENT,
	`rule_id` BIGINT NOT NULL COMMENT '安全检查内容库定义id',
	`item_id` BIGINT NOT NULL COMMENT '检查项id',
	`name` VARCHAR ( 125 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '检查内容',
	`area_id` BIGINT NOT NULL COMMENT '检查区域,区域表id',
	`business_type` VARCHAR ( 50 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '要点关联的业务类型来源,要点业务类型,关联字典表code',
	`remark` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
	`deleted` INT NULL DEFAULT NULL COMMENT '是否删除, 1是0否',
	`create_time` datetime NULL DEFAULT NULL,
	`update_time` datetime NULL DEFAULT NULL,
	`create_by` VARCHAR ( 255 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	`update_by` VARCHAR ( 32 ) CHARACTER 
	SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
	PRIMARY KEY ( `id` ) USING BTREE 
) ENGINE = INNODB AUTO_INCREMENT = 1705410983891484676 CHARACTER 
SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查内容库-检查内容' ROW_FORMAT = Dynamic;
-- -------------------------------------------------------
-- ----------新增表脚本 end ----------------------------
-- -------------------------------------------------------

-- -------------------------------------------------------
-- ----------修改表脚本 start ----------------------------
-- -------------------------------------------------------

DELIMITER ??
DROP PROCEDURE
IF
	EXISTS schema_change ?? CREATE PROCEDURE schema_change () BEGIN-- 预案演练任务增加推荐状态字段
	IF
		NOT EXISTS ( SELECT * FROM information_schema.COLUMNS WHERE table_schema = DATABASE () AND table_name = 'core_drill_task' AND column_name = 'rec_status' ) THEN
			ALTER TABLE core_drill_task ADD rec_status INT NULL COMMENT '推荐状态:0:正常案例、1:行社优秀案例、2:已推荐地区优秀案例、3:地区优秀案例、4:已推荐省级优秀案例、5:省级优秀案例' AFTER STATUS;
		
	END IF;
	IF
		NOT EXISTS ( SELECT * FROM information_schema.COLUMNS WHERE table_schema = DATABASE () AND table_name = 'sync_fjnx_org_business_relation' AND column_name = 'tree_show_parent_code' ) THEN
			ALTER TABLE `sync_fjnx_org_business_relation` ADD COLUMN `tree_show_parent_code` VARCHAR ( 64 ) CHARACTER 
			SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '机构树上显示的父级编码' AFTER `business_parent_code`;
		
	END IF;
	IF
		NOT EXISTS ( SELECT * FROM information_schema.COLUMNS WHERE table_schema = DATABASE () AND table_name = 'sync_fjnx_org_business_relation' AND column_name = 'org_type' ) THEN
			ALTER TABLE `sync_fjnx_org_business_relation` ADD COLUMN `org_type` INT NULL DEFAULT NULL COMMENT '同步配置表自定义机构类型 1：省联社 2：办事处 3: 地区行社' AFTER `tree_show_parent_code`;
		
	END IF;
	IF
		NOT EXISTS ( SELECT * FROM information_schema.COLUMNS WHERE table_schema = DATABASE () AND table_name = 'sync_fjnx_org_business_relation' AND column_name = 'dqhs_org_code' ) THEN
			ALTER TABLE `sync_fjnx_org_business_relation` ADD COLUMN `dqhs_org_code` VARCHAR ( 255 ) CHARACTER 
			SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '办事处对应的地区行社，机构编码是办事处时需要配置' AFTER `org_type`;
		
	END IF;
	ALTER TABLE core_protection MODIFY device_id BIGINT;
	IF
		NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'core_safety_task' AND COLUMN_NAME = 'des' ) THEN
			ALTER TABLE core_safety_task ADD COLUMN des VARCHAR ( 4000 ) COMMENT '备注';
		
	END IF;
	IF
		NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_nfc_bind' AND COLUMN_NAME = 'label_name' ) THEN
			ALTER TABLE sys_nfc_bind ADD COLUMN label_name VARCHAR ( 255 ) COMMENT '标签名称';
		
	END IF;
	IF
		EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'soc.sys_area_check' AND COLUMN_NAME = 'area_id' ) THEN
			ALTER TABLE sys_area_check DROP COLUMN area_id;
		
	END IF;
	IF
		NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'core_safecheck_plan_to_point' AND COLUMN_NAME = 'required' ) THEN
			ALTER TABLE core_safecheck_plan_to_point ADD COLUMN required TINYINT ( 1 ) COMMENT '是否必检';
		
	END IF;
	IF
		NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'core_safecheck_plan' AND COLUMN_NAME = 'distribute_status' ) THEN
			ALTER TABLE core_safecheck_plan ADD COLUMN distribute_status TINYINT ( 1 ) COMMENT '下发状态';
		
	END IF;
	IF
		NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'core_safecheck_plan' AND COLUMN_NAME = 'distribute_plan_status' ) THEN
			ALTER TABLE core_safecheck_plan ADD COLUMN distribute_plan_status TINYINT ( 1 ) COMMENT '计划下发默认状态';
		
	END IF;
	IF
		NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'core_safecheck_plan' AND COLUMN_NAME = 'parent_id' ) THEN
			ALTER TABLE core_safecheck_plan ADD COLUMN parent_id TINYINT ( 1 ) COMMENT '计划下发默认状态';
		
	END IF;
	IF
		NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'core_resumption_data' AND COLUMN_NAME = 'data_status' ) THEN
			ALTER TABLE core_resumption_data ADD COLUMN `data_status` INT NULL DEFAULT NULL COMMENT '数据状态：1保存未处理，2保存已处理';
		
	END IF;
	IF
		NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'sys_user' AND COLUMN_NAME = 'is_manage' ) THEN
			ALTER TABLE sys_user ADD COLUMN `is_manage` VARCHAR ( 2 ) DEFAULT NULL COMMENT '是否管理人员：Y是，N否';
		
	END IF;
	IF
		NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'core_protection' AND COLUMN_NAME = 'alarm_host_id' ) THEN
			ALTER TABLE `core_protection` CHANGE COLUMN `alarm_host_code` `alarm_host_id` BIGINT NULL DEFAULT NULL COMMENT '报警主机id' AFTER `org_name`;
		ALTER TABLE `soc`.`core_protection_log` CHANGE COLUMN `alarm_host_code` `alarm_host_id` BIGINT NULL DEFAULT NULL COMMENT '报警主机id' AFTER `code`;
		
	END IF;
	-- 安全检查是否下发标识
    IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'core_safecheck_plan' AND COLUMN_NAME = 'distribute' ) THEN
        ALTER TABLE `core_safecheck_plan` ADD COLUMN `distribute` VARCHAR ( 2 ) DEFAULT NULL COMMENT '是否已下发';

    END IF;
	-- 履职计划是否下发标识
    IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'core_resumption_plan' AND COLUMN_NAME = 'distribute' ) THEN
        ALTER TABLE `core_resumption_plan` ADD COLUMN `distribute` VARCHAR ( 2 ) DEFAULT NULL COMMENT '是否已下发';

    END IF;
	ALTER TABLE `core_protection` MODIFY COLUMN `device_id` BIGINT NULL DEFAULT NULL COMMENT '设备ID' AFTER `id`;
-- 机构扩展添加是否业务库
	ALTER TABLE sys_org_extend MODIFY COLUMN business_library INT COMMENT '是否业务库';
-- 处理自增id步长问题
	alter table core_drill_dictionary auto_increment = 10000;
-- 修改用户性别类型
	ALTER TABLE sys_user MODIFY gender VARCHAR(50);
	alter table core_drill_dictionary auto_increment = 10000;
-- 修改培训任务表状态字段含义注释
	alter table core_edu_training_task  modify status int null comment '任务状态:0:待培训,1:待签名,2:已完成,3:已逾期,4:待提交';
	alter table sys_menu modify icon mediumtext null comment '菜单图标';

END ?? 
DELIMITER;
CALL schema_change ();
-- -------------------------------------------------------
-- ----------修改表脚本 end ----------------------------
-- -------------------------------------------------------


-- -------------------------------------------------------
-- ----------新增数据 start ----------------------------
-- -------------------------------------------------------
-- 修改履职计划类型
DELETE from sys_dict_data where dict_type='resumption_plan_type';
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 1, '营业前安全检查', '1', 'resumption_plan_type', NULL, 'default', 'N', '0', '何悦', '2023-08-28 18:44:08', '超级管理员', '2023-09-28 15:16:39', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 2, '营业期间安全管理', '2', 'resumption_plan_type', NULL, 'default', 'N', '0', '何悦', '2023-08-28 18:44:19', '超级管理员', '2023-09-28 15:16:51', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 3, '营业终了安全管理', '3', 'resumption_plan_type', NULL, 'default', 'N', '0', '何悦', '2023-08-29 10:56:15', '超级管理员', '2023-09-28 15:17:11', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 4, '“110”入侵报警系统测试', '4', 'resumption_plan_type', NULL, 'default', 'N', '0', '何悦', '2023-08-29 10:56:35', '超级管理员', '2023-09-28 15:17:23', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 5, '备用电源维护', '5', 'resumption_plan_type', NULL, 'default', 'N', '0', '何悦', '2023-08-29 10:56:50', '超级管理员', '2023-09-28 15:17:34', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 6, '离行式自助银行巡检', '6', 'resumption_plan_type', NULL, 'default', 'N', '0', '何悦', '2023-08-29 10:57:08', '超级管理员', '2023-09-28 15:17:42', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 7, '非营业时间安全管理', '7', 'resumption_plan_type', NULL, 'default', 'N', '0', '何悦', '2023-08-29 10:57:26', '超级管理员', '2023-09-28 15:17:51', NULL);
DELETE from sys_role where id=143;
INSERT INTO `sys_role`(`id`, `org_type`, `role_name`, `role_key`, `role_sort`, `data_scope`, `menu_check_strictly`, `dept_check_strictly`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (143, '4', '业务库值班员', 'default', 11, 1, 1, 1, '0', 0, '安全检查', '2023-09-28 15:52:01', '', NULL, NULL);
DELETE from sys_dict_data where dict_label='非营业时间';
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 5, '非营业时间', '5', 'resumption_plan_exec', NULL, 'default', 'N', '0', '安全检查', '2023-09-28 15:54:56', '', NULL, NULL);
-- 新增系统参数：是否强制删除计划及其下属任务数据
delete from sys_config where config_key='FORCE_DELETE_PLAN_DATA' limit 1;
INSERT INTO sys_config (config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) VALUES ('是否强制删除计划', 'FORCE_DELETE_PLAN_DATA', '0', 'Y', 'slsjyc', '2023-09-28 16:38:28', '', null, '0:否,1:是');


delete from sys_dict_data where dict_type='edu_plan_cycle' and dict_value in (1,2) ;
INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (1, '每日', '1', 'edu_plan_cycle', null, 'default', 'N', '0', 'slsjyc', '2023-09-28 15:58:06', '', null, null);
INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (2, '每周', '2', 'edu_plan_cycle', null, 'default', 'N', '0', 'slsjyc', '2023-09-28 15:58:20', '', null, null);

-- 用户导出管理人员
delete from `sys_menu` where `menu_name` ='用户导出管理人员';
INSERT INTO `sys_menu`( `id`,`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '01710492988610752516','用户导出管理人员', 100, 9, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:user:exportManager', '1', NULL, NULL, '演示安全检查', '2023-09-27 16:10:58', '', NULL, '');

-- 演练任务状态字典增加待提交
delete from sys_dict_data where dict_type='edu_training_do_status' and dict_value in (4) ;
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES ( 4, '待提交', '4', 'edu_training_do_status', null, 'default', 'N', '0', 'slsjyc', '2023-09-28 15:18:38', '', null, null);


-- 监控调阅任务按钮菜单
delete from  sys_menu where id in(2197,2198) ;
INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2197, '导出', 2073, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:task:export', '1', '#', NULL, '超级管理员', '2023-09-14 16:10:03', '', NULL, '');
INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2198, '详情', 2073, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:task:query', '1', '#', NULL, '超级管理员', '2023-09-14 16:10:35', '超级管理员', '2023-09-14 19:26:20', '');

-- 机构扩展字典添加
delete from sys_dict_type where dict_type in ('org_extend_standard','org_extend_business_library_standard','org_extend_self_service_bank_standard','org_extend_detached_standard','org_extend_is');
INSERT INTO `sys_dict_type`( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '机构扩展基础标准', 'org_extend_standard', '0', '超级管理员', '2023-09-14 16:53:49', '', NULL, '机构扩展基础标准');
INSERT INTO `sys_dict_type`( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '机构扩展业务库标准', 'org_extend_business_library_standard', '0', '超级管理员', '2023-09-14 16:54:52', '', NULL, '机构扩展业务库标准');
INSERT INTO `sys_dict_type`( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '机构扩展在行式自助银行标准', 'org_extend_self_service_bank_standard', '0', '超级管理员', '2023-09-14 16:55:45', '', NULL, '机构扩展在行式自助银行标准');
INSERT INTO `sys_dict_type`( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '机构扩展离行式自助银行标准', 'org_extend_detached_standard', '0', '超级管理员', '2023-09-14 16:56:30', '', NULL, '机构扩展离行式自助银行标准');
INSERT INTO `sys_dict_type`( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '机构扩展是否选择框', 'org_extend_is', '0', '超级管理员', '2023-09-15 09:48:38', '', NULL, '机构扩展是否选择框');

delete from sys_dict_data where dict_type in ('org_extend_standard','org_extend_business_library_standard','org_extend_self_service_bank_standard','org_extend_detached_standard','org_extend_is');
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 1, '基础标准1', '1', 'org_extend_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:04', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 2, '基础标准2', '2', 'org_extend_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:10', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 3, '基础标准3', '3', 'org_extend_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:28', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 1, '业务库标准1', '1', 'org_extend_business_library_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:45', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 2, '业务库标准2', '2', 'org_extend_business_library_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:50', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 3, '业务库标准3', '3', 'org_extend_business_library_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:55', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 1, '在行式自助银行标准1', '1', 'org_extend_self_service_bank_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:09', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 2, '在行式自助银行标准2', '2', 'org_extend_self_service_bank_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:13', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 3, '在行式自助银行标准3', '3', 'org_extend_self_service_bank_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:20', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 1, '离行式自助银行标准1', '1', 'org_extend_detached_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:33', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 2, '离行式自助银行标准2', '2', 'org_extend_detached_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:37', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 3, '离行式自助银行标准3', '3', 'org_extend_detached_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:41', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 1, '是', '1', 'org_extend_is', NULL, 'default', 'N', '0', '超级管理员', '2023-09-15 09:48:58', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 2, '否', '0', 'org_extend_is', NULL, 'default', 'N', '0', '超级管理员', '2023-09-15 09:49:08', '', NULL, NULL);

-- 新增fjnx机构同步 机构关系配置表数据
delete from sync_fjnx_org_business_relation ;
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (1, 'M39000000', 'M31000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (2, 'M42000000', 'M33000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (3, 'M43000000', 'M34000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (4, 'M39000000', 'M35000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (5, 'M45000000', 'M36000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (6, 'M46000000', 'M37000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (7, 'M47000000', 'M38000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (8, '900000000', 'C900000000', 'C900000000', 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (9, 'M40000000', 'C900000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (10, 'M44000000', 'C900000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (11, 'M31000000', NULL, NULL, 2, 'M39000000', NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (12, 'M32000000', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (13, 'M33000000', NULL, NULL, 2, 'M42000000', NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (14, 'M34000000', NULL, NULL, 2, 'M43000000', NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (15, 'M35000000', NULL, NULL, 2, 'M39000000', NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (16, 'M36000000', NULL, NULL, 2, 'M45000000', NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (17, 'M37000000', NULL, NULL, 2, 'M46000000', NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (18, 'M38000000', NULL, NULL, 2, 'M47000000', NULL, NULL, NULL, NULL);


-- 新增演练任务推荐状态字典
delete from sys_dict_type where dict_type='drill_task_rec_status';
delete from sys_dict_data where dict_type='drill_task_rec_status';
delete from sys_dict_data where dict_type='science_protection';
delete  from sys_dict_data where  dict_label in ('淋浴式灭火器','防毒面具');
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES ( '演练任务推荐状态', 'drill_task_rec_status', '0', '超级管理员', now(), '', null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (0, '正常案例', '0', 'drill_task_rec_status', null, 'default', 'N', '0', '超级管理员', now(), '超级管理员', now(), null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (0, '行社优秀案例', '1', 'drill_task_rec_status', null, 'default', 'N', '0', '超级管理员', now(), '超级管理员', now(), null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (0, '已推荐地区优秀案例', '2', 'drill_task_rec_status', null, 'default', 'N', '0', '超级管理员', now(), '', null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (0, '地区优秀案例', '3', 'drill_task_rec_status', null, 'default', 'N', '0', '超级管理员', now(), '', null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (0, '已推荐省级优秀案例', '4', 'drill_task_rec_status', null, 'default', 'N', '0', '超级管理员', now(), '', null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (0, '省级优秀案例', '5', 'drill_task_rec_status', null, 'default', 'N', '0', '超级管理员', now(), '', null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (5, '淋浴式灭火器', '5', 'fire_fighting', null, 'default', 'N', '0', '超级管理员', now(), '', null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (6, '防毒面具', '6', 'fire_fighting', null, 'default', 'N', '0', '超级管理员', now(), '', null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (1, '硬盘录像机', '0', 'science_protection', null, 'default', 'N', '0', '超级管理员', now(), '', null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (2, '报警主机', '1', 'science_protection', null, 'default', 'N', '0', '超级管理员', now(), '', null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (3, '摄像机', '2', 'science_protection', null, 'default', 'N', '0', '超级管理员', now(), '', null, null);


-- 新增演练任务状态字典
delete from sys_dict_type where dict_type='drill_task_status';
delete from sys_dict_data where dict_type='drill_task_status';
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES ('预案演练任务状态', 'drill_task_status', '0', '超级管理员', '2023-09-20 16:06:14', '', null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (0, '待演练', '0', 'drill_task_status', null, 'default', 'N', '0', '超级管理员', '2023-09-20 16:06:46', '', null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (1, '待签名', '1', 'drill_task_status', null, 'default', 'N', '0', '超级管理员', '2023-09-20 16:06:56', '', null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (2, '待评价', '2', 'drill_task_status', null, 'default', 'N', '0', '超级管理员', '2023-09-20 16:07:05', '超级管理员', '2023-09-20 16:07:30', null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (3, '已完成', '3', 'drill_task_status', null, 'default', 'N', '0', '超级管理员', '2023-09-20 16:07:13', '', null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (4, '已逾期', '4', 'drill_task_status', null, 'default', 'N', '0', '超级管理员', '2023-09-20 16:07:23', '', null, null);


-- 公告通知start
delete from sys_dict_type where dict_type in('messag_type','message_status') and dict_name in('消息类型','消息状态');
INSERT INTO `sys_dict_type`( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '消息类型', 'messag_type', '0', '超级管理员', '2023-09-13 17:03:11', '超级管理员', '2023-09-13 17:07:06', NULL);
INSERT INTO `sys_dict_type`( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '消息状态', 'message_status', '0', '超级管理员', '2023-09-13 17:08:11', '', NULL, NULL);

delete from sys_dict_data where dict_type in('messag_type','message_status');
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 0, '公告', '0', 'messag_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 17:06:33', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 0, '通知', '1', 'messag_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 17:06:43', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 0, '待发布', '0', 'message_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 17:09:11', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 0, '已发布', '1', 'message_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 17:09:19', '', NULL, NULL);

delete from sys_menu where menu_name in('公告通知','公告通知详情','公告通知编辑','新增公告通知','删除公告通知','发布公告通知','取消发布');
delete from sys_menu where id in(2208,2209,2210,2211,2212,2213,2196);
INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2196, '公告通知', 2358, 1, 'core/message', 'core/message/index', NULL, 1, 0, 'C', '0', '0', 'core:notification:list', '1', 'dashboard', NULL, '超级管理员', '2023-09-13 17:50:26', '超级管理员', '2023-09-15 16:47:45', '');
INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2208, '公告通知详情', 2196, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:notification:query', '1', '#', NULL, '超级管理员', '2023-09-19 15:17:27', '', NULL, '');
INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2209, '公告通知编辑', 2196, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:notification:edit', '1', '#', NULL, '超级管理员', '2023-09-19 15:17:56', '', NULL, '');
INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2210, '新增公告通知', 2196, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:notification:add', '1', '#', NULL, '超级管理员', '2023-09-19 15:18:18', '', NULL, '');
INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2211, '删除公告通知', 2196, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:notification:remove', '1', '#', NULL, '超级管理员', '2023-09-19 15:18:42', '', NULL, '');
INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2212, '发布公告通知', 2196, 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:notification:publish', '1', '#', NULL, '超级管理员', '2023-09-19 15:19:03', '', NULL, '');
INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2213, '取消发布', 2196, 6, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:notification:cancelPublish', '1', '#', NULL, '超级管理员', '2023-09-19 15:19:25', '', NULL, '');

delete from sys_role_menu where menu_id in(2208,2209,2210,2211,2212,2213,2196) ;

INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2196);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2208);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2209);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2210);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2211);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2212);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2213);

INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2196);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2208);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2209);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2210);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2211);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2212);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2213);

-- 天气预警start
delete from sys_menu where menu_name='天气预警数据';
INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2166, '天气预警数据', 1, 100, 'core/weather', 'core/weather/index', NULL, 1, 0, 'C', '0', '0', 'core:weather:list', '1', 'color', NULL, '超级管理员', '2023-09-12 11:40:46', '超级管理员', '2023-09-12 11:43:45', '');
delete from sys_config where config_key='WEATHER_APP_CODE';
INSERT INTO `sys_config`(`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('天气接口AppCode', 'WEATHER_APP_CODE', '3ea812b74f67479e9ab0b3d1969a18d2', 'N', '超级管理员', '2023-09-13 14:08:42', '超级管理员', '2023-09-13 14:38:32', '天气接口的appcode（请根据购买的api接口填写）');

INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('101231001', '101231001', 'diaoyudao', '钓鱼岛', 'diaoyudao', '钓鱼岛', 'fujian', '福建', 'china', '中国', '-1');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350100', '101230101', 'fuzhou', '福州', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '-1');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350102', '101230106', 'gulou', '鼓楼', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350103', '101230109', 'taijiang', '台江', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350104', '101230112', 'cangshan', '仓山', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350105', '101230113', 'mawei', '马尾', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350111', '101230114', 'jinan', '晋安', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350112', '101230110', 'changle', '长乐', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350121', '101230103', 'minhou', '闽侯', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350122', '101230105', 'lianjiang', '连江', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350123', '101230104', 'luoyuan', '罗源', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350124', '101230102', 'minqing', '闽清', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350125', '101230107', 'yongtai', '永泰', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350128', '101230108', 'pingtan', '平潭', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350181', '101230111', 'fuqing', '福清', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350200', '101230201', 'xiamen', '厦门', 'xiamen', '厦门', 'fujian', '福建', 'china', '中国', '-1');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350203', '101230203', 'siming', '思明', 'xiamen', '厦门', 'fujian', '福建', 'china', '中国', '101230201');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350205', '101230204', 'haicang', '海沧', 'xiamen', '厦门', 'fujian', '福建', 'china', '中国', '101230201');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350206', '101230205', 'huli', '湖里', 'xiamen', '厦门', 'fujian', '福建', 'china', '中国', '101230201');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350211', '101230206', 'jimei', '集美', 'xiamen', '厦门', 'fujian', '福建', 'china', '中国', '101230201');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350212', '101230202', 'tongan', '同安', 'xiamen', '厦门', 'fujian', '福建', 'china', '中国', '101230201');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350213', '101230207', 'xiangan', '翔安', 'xiamen', '厦门', 'fujian', '福建', 'china', '中国', '101230201');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350300', '101230401', 'putian', '莆田', 'putian', '莆田', 'fujian', '福建', 'china', '中国', '-1');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350302', '101230407', 'chengxiang', '城厢', 'putian', '莆田', 'fujian', '福建', 'china', '中国', '101230401');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350303', '101230404', 'hanjiang', '涵江', 'putian', '莆田', 'fujian', '福建', 'china', '中国', '101230401');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350304', '101230406', 'licheng', '荔城', 'putian', '莆田', 'fujian', '福建', 'china', '中国', '101230401');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350305', '101230405', 'xiuyu', '秀屿', 'putian', '莆田', 'fujian', '福建', 'china', '中国', '101230401');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350322', '101230402', 'xianyou', '仙游', 'putian', '莆田', 'fujian', '福建', 'china', '中国', '101230401');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350400', '101230801', 'sanming', '三明', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '-1');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350402', '101230812', 'meilie', '梅列', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350403', '101230813', 'sanyuan', '三元', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350421', '101230807', 'mingxi', '明溪', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350423', '101230803', 'qingliu', '清流', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350424', '101230802', 'ninghua', '宁化', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350425', '101230811', 'datian', '大田', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350426', '101230809', 'youxi', '尤溪', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350427', '101230808', 'shaxian', '沙县', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350428', '101230805', 'jiangle', '将乐', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350429', '101230804', 'taining', '泰宁', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350430', '101230806', 'jianning', '建宁', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350481', '101230810', 'yongan', '永安', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350500', '101230501', 'quanzhou', '泉州', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '-1');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350502', '101230511', 'licheng', '鲤城', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350503', '101230512', 'fengze', '丰泽', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350504', '101230513', 'luojiang', '洛江', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350505', '101230514', 'quangang', '泉港', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350521', '101230508', 'huian', '惠安', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('3505211070', '101230507', 'chongwu', '崇武', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350524', '101230502', 'anxi', '安溪', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350525', '101230504', 'yongchun', '永春', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350526', '101230505', 'dehua', '德化', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350527', '101230503', 'jinmen', '金门', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350581', '101230510', 'shishi', '石狮', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350582', '101230509', 'jinjiang', '晋江', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350583', '101230506', 'nanan', '南安', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350600', '101230601', 'zhangzhou', '漳州', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '-1');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350602', '101230611', 'xiangcheng', '芗城', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350603', '101230612', 'longwen', '龙文', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350622', '101230609', 'yunxiao', '云霄', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350623', '101230606', 'zhangpu', '漳浦', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350624', '101230607', 'zhaoan', '诏安', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350625', '101230602', 'changtai', '长泰', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350626', '101230608', 'dongshan', '东山', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350627', '101230603', 'nanjing', '南靖', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350628', '101230604', 'pinghe', '平和', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350629', '101230610', 'huaan', '华安', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350681', '101230605', 'longhai', '龙海', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350700', '101230901', 'nanping', '南平', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '-1');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350702', '101230911', 'yanping', '延平', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350703', '101230907', 'jianyang', '建阳', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350721', '101230902', 'shunchang', '顺昌', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350722', '101230906', 'pucheng', '浦城', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350723', '101230903', 'guangze', '光泽', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350724', '101230908', 'songxi', '松溪', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350725', '101230909', 'zhenghe', '政和', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350781', '101230904', 'shaowu', '邵武', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350782', '101230905', 'wuyishan', '武夷山', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350783', '101230910', 'jianou', '建瓯', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350800', '101230701', 'longyan', '龙岩', 'longyan', '龙岩', 'fujian', '福建', 'china', '中国', '-1');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350802', '101230708', 'xinluo', '新罗', 'longyan', '龙岩', 'fujian', '福建', 'china', '中国', '101230701');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350803', '101230706', 'yongding', '永定', 'longyan', '龙岩', 'fujian', '福建', 'china', '中国', '101230701');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350821', '101230702', 'changting', '长汀', 'longyan', '龙岩', 'fujian', '福建', 'china', '中国', '101230701');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350823', '101230705', 'shanghang', '上杭', 'longyan', '龙岩', 'fujian', '福建', 'china', '中国', '101230701');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350824', '101230704', 'wuping', '武平', 'longyan', '龙岩', 'fujian', '福建', 'china', '中国', '101230701');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350825', '101230703', 'liancheng', '连城', 'longyan', '龙岩', 'fujian', '福建', 'china', '中国', '101230701');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350881', '101230707', 'zhangping', '漳平', 'longyan', '龙岩', 'fujian', '福建', 'china', '中国', '101230701');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350900', '101230301', 'ningde', '宁德', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '-1');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350902', '101230310', 'jiaocheng', '蕉城', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350921', '101230303', 'xiapu', '霞浦', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350922', '101230302', 'gutian', '古田', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350923', '101230309', 'pingnan', '屏南', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350924', '101230304', 'shouning', '寿宁', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350925', '101230305', 'zhouning', '周宁', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350926', '101230307', 'zherong', '柘荣', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350981', '101230306', 'fuan', '福安', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350982', '101230308', 'fuding', '福鼎', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
delete from sys_role where id = 128;
INSERT INTO `sys_role` VALUES (128, '4', '运行主管', 'default', 8, 1, 1, 1, '0', 0, '超级管理员', '2023-09-06 15:52:56', '超级管理员', '2023-09-17 11:41:42', NULL);
-- 天气预警end

-- Web演练库按钮及权限
delete from sys_menu where menu_name in ('预案演练管理','演练');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2319, '预案演练管理', 0, 6, '/drill', null, null, 1, 0, 'M', '0', '0', null, '1', 'dashboard', null, '超级管理员', now(), '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2311, '演练', 0, 12, '/', null, null, 1, 0, 'M', '0', '0', null, '0', '#', null, '超级管理员', now(), '', null, '');

delete from sys_menu where menu_name in ('演练库管理','演练库新增','演练库查询','演练库编辑','演练库详情','演练库删除');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2320, '演练库管理', 2319, 1, '/dictionary', 'core/drill/drillDictionary/index', null, 1, 0, 'C', '0', '0', 'core:drillDictionary:list', '1', 'component', null, '超级管理员', now(), '超级管理员', now(), '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2220, '演练库新增', 2320, 1, '', null, null, 1, 0, 'F', '0', '0', 'core:drillDictionary:add', '1', '#', null, '超级管理员', now(), '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2221, '演练库查询', 2320, 2, '', null, null, 1, 0, 'F', '0', '0', 'core:drillDictionary:list', '1', '#', null, '超级管理员', now(), '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2222, '演练库编辑', 2320, 3, '', null, null, 1, 0, 'F', '0', '0', 'core:drillDictionary:edit', '1', '#', null, '超级管理员', now(), '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2223, '演练库详情', 2320, 4, '', null, null, 1, 0, 'F', '0', '0', 'core:drillDictionary:query', '1', '#', null, '超级管理员', now(), '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2224, '演练库删除', 2320, 5, '', null, null, 1, 0, 'F', '0', '0', 'core:drillDictionary:remove', '1', '#', null, '超级管理员', now(), '', null, '');

-- Web演练计划按钮及权限
delete from sys_menu where menu_name in ('演练计划管理','演练计划新增','演练计划列表','演练计划下发','演练计划编辑','演练计划删除','演练计划详情');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2321, '演练计划管理', 2319, 2, '/drillPlan', 'core/drill/plan/index', null, 1, 0, 'C', '0', '0', 'core:drillPlan:list', '1', 'documentation', null, '超级管理员', now(), '超级管理员', now(), '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2225, '演练计划新增', 2321, 1, '', null, null, 1, 0, 'F', '0', '0', 'core:drillPlan:add', '1', null, null, '超级管理员', now(), '超级管理员', now(), '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2226, '演练计划列表', 2321, 2, '', null, null, 1, 0, 'F', '0', '0', 'core:drillPlan:list', '1', null, null, '超级管理员', now(), '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2227, '演练计划下发', 2321, 3, '', null, null, 1, 0, 'F', '0', '0', 'core:drillPlan:publish', '1', null, null, '超级管理员', now(), '超级管理员', now(), '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2228, '演练计划编辑', 2321, 4, '', null, null, 1, 0, 'F', '0', '0', 'core:drillPlan:edit', '1', null, null, '超级管理员', now(), '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2229, '演练计划删除', 2321, 5, '', null, null, 1, 0, 'F', '0', '0', 'core:drillPlan:remove', '1', null, null, '超级管理员', now(), '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2338, '演练计划详情', 2321, 6, '', null, null, 1, 0, 'F', '0', '0', 'core:drillPlan:query', '1', null, null, '超级管理员', now(), '', null, '');

-- Web演练任务按钮及权限
delete from sys_menu where menu_name in ('演练任务管理','演练任务登记','演练任务详情','演练任务签名','演练任务评价');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2322, '演练任务管理', 2319, 3, '/drillTask', 'core/drill/task/index', null, 1, 0, 'C', '0', '0', 'core:drillTask:list', '1', 'druid', null, '超级管理员', now(), '超级管理员', now(), '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2215, '演练任务登记', 2322, 1, '', null, null, 1, 0, 'F', '0', '0', 'core:drillTask:edit', '1', '#', null, '超级管理员', now(), '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2216, '演练任务详情', 2322, 2, '', null, null, 1, 0, 'F', '0', '0', 'core:drillTask:query', '1', '#', null, '超级管理员', now(), '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2217, '演练任务签名', 2322, 3, '', null, null, 1, 0, 'F', '0', '0', 'core:drillTask:sign', '1', '#', null, '超级管理员', now(), '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2218, '演练任务评价', 2322, 4, '', null, null, 1, 0, 'F', '0', '0', 'core:drillTask:evaluate', '1', '#', null, '超级管理员', now(), '', null, '');

-- App端预案演练登记菜单目录
delete from sys_menu where menu_name in ('演练登记','演练统计排名','优秀案例管理','优秀案例学习');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2312, '演练登记', 2311, 1, '/rehearsalTask', null, null, 1, 0, 'C', '0', '0', '', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFYAAABWCAMAAABiiJHFAAAAM1BMVEVHcEzYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXF4gE2CAAAAEHRSTlMA0HAgQLDwgMAQYKCQUDDgVczG7QAAAAlwSFlzAAALEgAACxIB0t1+/AAAAhVJREFUWIXtmNtyhSAMRVFAUVH5/6/tGIkiBjmAnXZa9lsHXIVctvGwqqqqqoBaUyI10NSliGqMorF9Idb8AFb26dJrDCvy6lk+YwNhj2r5Hiyr2H+G5W2vVN/yV7FCYZ8qv23yscPkGoC++mA2dmiuxtJcuNlYZTzJN7DEq2N8AdvdsWs5dqR82zluJlZS2KkY21BYZ3cmlqK6oN+FXSlqU4wlU+Y0RCaWHKTKC2wg2qFzXCETS41SvbOci/UN7JKwAgfjXhheMkbvvM1LNr7tOA7ctd5SCZaxWSullJ5vC2XYoP4StqGXmJDqLnk2b2S+NZpc0pQjOB9NQ2Qa37ZetMBZA1T0sHkvvEfsVVCfpCvugqHJjhAJWB5wLxS8JcdUrGShl7lVB6FNxUKuybfuZceUhoWzPH8Lw33mNOx0HiUoqLE1CbtEEmawVnQYe8/MGkuYwcbkYaxv//YgjwnDK227JI1li9f4MMfzGHXvdz5N9++UB4Xs4NSagkNhZCi8ber7u4KIsEBB5WDCJqpZZrsWpy5n3mC6wA8RQWHFftwu8JuSI+fp0UnYSra2GM+dn2KhcTGiLY21rRIqLQoLEcOQDDQWGztaW+fT82Eh8C9o7IyX+RQL1SiP5wNYe51o6R5PaydhTcCNxWFvSwSL14Zw4QjeBsZxwT6Pwi7oHG7/2OpyIH7LO/fHK7eqqur3izH2BalxfxDJImssAAAAAElFTkSuQmCC', null, '超级管理员', now(), '超级管理员',now(), '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2313, '演练统计排名', 2311, 1, '/drillStatistics', null, null, 1, 0, 'C', '0', '0', '', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFYAAABWCAMAAABiiJHFAAAAM1BMVEVHcEzB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pJW8V+EAAAAEHRSTlMAYLDgEPDQwIBAMKBwIJBQkhN9vAAAAAlwSFlzAAALEgAACxIB0t1+/AAAAoZJREFUWIXtmNmSrCAMhlFZ4oLm/Z92Stkh2kJbp07N+F/1Ih8SsgF79epfS68SEeXCH50X0Ep0D1JnDFofowLG2h6iapFgRdXgCdXJPwumIs2roVdB3lJ8QJxorMqwM/FMlz2zE8eJsR4RRxqbjaBWNebPsIPYzydvcRO7DxeZEewi5Zmri8/YHQHZb9NwST3sE4vwXEWZkMsrarEdxBaQWMYXuAh2PnyywQn2g5J9FpQbNmFjMwgydtuwbHR2UHTINGIZ21alFJzEYTv2Wv8Rls+Jg/WELzZg92BJREROA9amjD2TnAZEPdb57O6vq/1cJPJqLHf5a4yK2vA11pfHGFu8bjXWpxkWB3H+urXYFBRyTpYZarG+PPbHV0y/tmK155iSElw49d1KLGSrDvVn+QYb6oLOppFfYKcQs12GtfM0YaMcc9SaOD0kVqjC8rhDEFOadBJfUIW198wvUVIlKq3kAtJUdvjCiqSkH030gTM9BlVwubztc/LbXaQP1yXlvRIiDH7ABTZ8omygypFglrERjZSV9H/1Bdb83hHYLh9BbdkkyGbFBK4g1gk2pnmCLVu7BYgDl+ntZwprtyO0nhV+a3ATiTXGHZJn72G5G0lhN/SbVok1KXulsWbO4Ou1WE0FxWbnEn5DKmwrbT+vc6qwkw7BeWpSzQTGFe3rCuf6hwOMEEd7Sw8GjmZTze2zw02serEv9sW+2F+KLbotvcCiy2crsHuGHyBo8+3H+RpuYLe8MPlzBtHa3ccWdfSitavBsi2+uTxu7cxMZ1eBN7Gl+N5Sr+cXYY3YT7L3t4vDXjhNjbSjGb58hmrPHas9P5G3dm0a1/mIIQ49PGSCV39UjLEf/p1q4sZjU5oAAAAASUVORK5CYII=', null, '超级管理员', now(), '超级管理员', now(), '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2314, '优秀案例管理', 2311, 2, '/rehearsaloptimal', null, null, 1, 0, 'M', '0', '0', '', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFYAAABWCAMAAABiiJHFAAAAM1BMVEVHcEymgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKV36H0vAAAAEHRSTlMA0KAg8BAwQMCAYOCQULBwyOgprQAAAAlwSFlzAAALEgAACxIB0t1+/AAAAllJREFUWIXtmFuSoCAMRQERiM/sf7VTPASCoNjdX1PcX/EYk0uCsqGhoaE/kgJQH0jzDrBMr8uURJS6G7qhk5jfqYi4dFI5Bq2Pb2ipxq6FLqzBKP5CPRgT9rU6qAtmagcySURus7RJxO1TsIhrc9ms9VVTrV+KYIVE73boFMV22+dbtBSrO9TASoIlWRPYoYYtjvxO4jDdQ0WsY8nNZAep32DZllYc9IpA5OZRHGXT6jGFR+nHV2doNO2Lu+sK672H/A5L9lA3dkE5tbFzZs2ygz1htfVWE6uIbw3N7gNWSVvgFpZSQ5NqYlOmJumWNrDzWrqQ9DyKPVdE4cEzR6naJQPPWufUIPPSEewe8qT9QHFX6tg5pMBkfVc0sJNEqW3AaJYD8WRtLGRvHnvDXMdyxN3aas0fXsde9VqyR4Q4SqyIadcmtaQqNo4xlbecbPAk7FKfn1VsHGMud5g/JGGv/MvaNqxhI8hfil5LHrPY8EqVjtHAbpQTa5ay4JJQ3dYP2Bieb5mxZqlOr6O7gk3Nnyu6jeW2dE7gCtZF5yOW+0WNmZDXw/UOYFrHuQrW9e7zSm+IdY4xGxAmWoU3knHHOh/IcrpeOz9JGgPQSvEd6yaYuGGv3YlcAHwvmTetvmMZUzsAnA0Q1V5ihXdoDRvlyiWeBrosB7rx++AJ+5NTjcOqP8fuvmmWByKyRjZARMVJexIbKw/jxZqp5yBa90roBOGF+z5iOhSwbGAHdmAHdmAHNsmfinkYh1/+ID7K/7PbPf7xc/sj9wSwnwUaoPPv4dDQ0H8jxtg/vgNYlsZOPYcAAAAASUVORK5CYII=', null, '超级管理员', now(), '超级管理员', now(), '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2315, '优秀案例学习', 2311, 4, '/rehearsallearning', null, null, 1, 0, 'M', '0', '0', '', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFcAAABWCAMAAACNSvr7AAAAM1BMVEVHcEx3max3max3max3max3max3max3max3max3max3max3max3max3max3max3max3mayxYUqyAAAAEHRSTlMAMNAgEPBggMBAUOCQoLBwPe7hCQAAAAlwSFlzAAALEgAACxIB0t1+/AAAAjBJREFUWIXtmOtyhCAMhVFBQLzs+z9tRyRIFFwJbKed9fza2tmvkOQksezRo0fFGlRSM6fDh9eFFjpXXnHlt3FnHcpU4/bxmBdzBSo18bV5+5160FpPdbjD6bn5QD0opcyfiW+npVy074B1uFyCR9u+IncRwZeMrsTl8+Fr65H1Fbe/QWWsjX6vkatGeKTkrnvY8YQN61bZn9vuFipU9MLG18WGJQxKFY2gn4w2BgRsF8+Mcb9ebzPlUxlbEinvPJeEZVOC6zInqb0gHl5f+ryhYd9xyfoUN+aKVbqQ2ye4BSujFRdR7FyITRVaaRgSB1bF2OgGLUqja3VKnaCa4QjGoWgrYRnrguQJWSUIQJbWeGLua1IfuXF+0nmRzFOqnZFm5a6LbYky20GJYbypoKWFxxVriNGmRredCShbpsKxNFKxqJNtHTfcAQWVO5+5KMLEYuMI0py5tE0Hr1Du0njs00otzBpMHuyTewv0QQ1CuD0EDyXSmMOD2A1gHPNX/pp+nMPwGAWH8o8nPC3b+C3MNSMmcMBWAd5bhz0728u+5fQ48y6b7gU738tQUIIdzuW4IzEQkLWRxc8L98n0ss9a597Q3IF5C5XrPmR6GVqOgosLe+LOZxP+ct6qtmdtbzUTZ42vaeUdkuVlGBTrafYaHnerKH+lrHEErpqOrTHgQqvI8LJ/124uuFAyGV6GMFj3JrmuhDPGEXfrjS2uIbbvrJfni/1IasKPHv0DMcZ+AB6xa3Jz3P3pAAAAAElFTkSuQmCC', null, '超级管理员', now(), '超级管理员', now(), '');

-- 演练相关菜单权限
delete from sys_role_menu where menu_id in(2216, 2217, 2218, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2311, 2312, 2313, 2314, 2315, 2319, 2320, 2321, 2322, 2338, 2216, 2217, 2218, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2311, 2312, 2313, 2314, 2315, 2319, 2320, 2321, 2322, 2338, 2216, 2218, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2311, 2312, 2313, 2314, 2315, 2319, 2320, 2321, 2322, 2338, 2216, 2218, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2311, 2312, 2313, 2314, 2315, 2319, 2320, 2321, 2322, 2338, 2215, 2216, 2217, 2218, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2311, 2312, 2313, 2314, 2315, 2319, 2320, 2321, 2322, 2338, 2215, 2216, 2217, 2218, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2311, 2312, 2313, 2314, 2315, 2319, 2320, 2321, 2322, 2338, 2216, 2217, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2228, 2229, 2311, 2312, 2315, 2319, 2320, 2321, 2322, 2338, 2215, 2216, 2217, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2311, 2312, 2315, 2319, 2320, 2321, 2322, 2338, 2215, 2216, 2217, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2311, 2312, 2315, 2319, 2320, 2321, 2322, 2338);

INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2216);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2217);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2218);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2220);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2221);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2222);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2223);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2224);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2225);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2226);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2227);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2228);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2229);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2311);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2312);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2313);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2314);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2315);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2319);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2320);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2321);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2322);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2338);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2216);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2217);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2218);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2220);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2221);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2222);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2223);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2224);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2225);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2226);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2227);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2228);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2229);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2311);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2312);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2313);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2314);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2315);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2319);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2320);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2321);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2322);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2338);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2216);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2218);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2220);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2221);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2222);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2223);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2224);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2225);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2226);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2227);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2228);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2229);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2311);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2312);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2313);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2314);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2315);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2319);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2320);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2321);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2322);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2338);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2216);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2218);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2220);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2221);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2222);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2223);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2224);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2225);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2226);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2227);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2228);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2229);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2311);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2312);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2313);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2314);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2315);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2319);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2320);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2321);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2322);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2338);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2215);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2216);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2217);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2218);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2220);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2221);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2222);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2223);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2224);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2225);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2226);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2227);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2228);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2229);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2311);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2312);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2313);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2314);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2315);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2319);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2320);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2321);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2322);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2338);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2215);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2216);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2217);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2218);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2220);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2221);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2222);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2223);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2224);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2225);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2226);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2227);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2228);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2229);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2311);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2312);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2313);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2314);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2315);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2319);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2320);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2321);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2322);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2338);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2216);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2217);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2220);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2221);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2222);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2223);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2224);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2225);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2226);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2228);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2229);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2311);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2312);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2315);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2319);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2320);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2321);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2322);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2338);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2215);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2216);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2217);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2220);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2221);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2222);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2223);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2224);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2225);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2226);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2227);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2228);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2229);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2311);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2312);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2315);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2319);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2320);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2321);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2322);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2338);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2215);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2216);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2217);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2220);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2221);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2222);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2223);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2224);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2225);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2226);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2227);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2228);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2229);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2311);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2312);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2315);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2319);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2320);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2321);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2322);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2338);

-- 新增系统参数:演练任务行社推荐数量单季度最大值,演练任务地区推荐数量单季度最大值
delete from sys_config where config_key in ('HS_REC_DRILL_TASK_MAX','AREA_REC_DRILL_TASK_MAX');
INSERT INTO sys_config (config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) VALUES ('演练任务行社推荐数量单季度最大值', 'HS_REC_DRILL_TASK_MAX', '3', 'Y', '超级管理员', '2023-09-21 11:20:41', '', null, null);
INSERT INTO sys_config (config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) VALUES ('演练任务地区推荐数量单季度最大值', 'AREA_REC_DRILL_TASK_MAX', '3', 'Y', '超级管理员', '2023-09-21 11:35:30', '', null, null);

DELETE from `sys_dict_type` WHERE dict_type='question_confirm_status' or dict_type='question_reform_status';
INSERT INTO `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '问题确认状态', 'question_confirm_status', '0', '超级管理员', '2023-09-13 18:14:59', '', NULL, NULL);
INSERT INTO `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '问题整改状态', 'question_reform_status', '0', '超级管理员', '2023-09-13 18:15:18', '', NULL, NULL);
delete  from sys_dict_type WHERE dict_type in ('send_time_type' ,'message_type' ,'send_status' ,'evaluate_cycle');
INSERT INTO `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES ( '发送时间类型', 'send_time_type', '0', '超级管理员', '2023-09-13 18:14:59', '', NULL, NULL);
INSERT INTO `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES ( '消息类型', 'message_type', '0', '超级管理员', '2023-09-13 18:14:59', '', NULL, NULL);
INSERT INTO `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES ( '发送状态', 'send_status', '0', '超级管理员', '2023-09-13 18:14:59', '', NULL, NULL);
INSERT INTO `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES ( '评价周期', 'evaluate_cycle', '0', '超级管理员', '2023-09-13 18:14:59', '', NULL, NULL);

DELETE from `sys_dict_data` WHERE dict_type in ('post_no_pass','question_confirm_status','question_reform_status','send_status','message_type','send_time_type');
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 0, '待确认', '0', 'question_confirm_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:15:44', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, '提出异议', '1', 'question_confirm_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:16:01', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 2, '已确认', '2', 'question_confirm_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:16:18', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 3, '已关闭', '3', 'question_confirm_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:16:30', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 0, '未整改', '10', 'question_reform_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:17:38', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 1, '已整改', '11', 'question_reform_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:17:47', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
 VALUES ( 1, '已发送', '1', 'send_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:17:47', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES ( 2, '待发送', '2', 'send_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:17:47', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES ( 0, '公告', '0', 'message_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:17:47', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES ( 1, '通知', '1', 'message_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:17:47', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES ( 1, '立即发送', '1', 'send_time_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:17:47', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES ( 2, '指定时间发送', '2', 'send_time_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:17:47', '', NULL, NULL);

INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES ( 1, '无', '1', 'post_no_pass', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:17:47', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES ( 2, '考试不合格', '2', 'post_no_pass', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:17:47', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES ( 3, '不符合参考条件为参考', '3', 'post_no_pass', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:17:47', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES ( 4, '新任职保卫人员未参考', '4', 'post_no_pass', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:17:47', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES ( 5, '非必考对象', '5', 'post_no_pass', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:17:47', '', NULL, NULL);

delete from `sys_menu` WHERE id in (01706851077007085569,01706851219965743105,01706854057534033922,01706854338376241153,2325,2326,2327,2328,2329,2330,2331,2332,2333,2334,2335,2336,2338,2339,2340,2341,2342,2344,2345,2346,2347,2348,2349,2350,2351,2352,2353,2354,2355,2356,2357,2317,2318,00000000000000002324,01706850786660585473,01706850961911189505);
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002325, '安全检查登记', 2136, 4, '/securityCheckRegister', NULL, NULL, 1, 0, 'C', '0', '0', 'core:safetycheck:appregister', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFYAAABWCAMAAABiiJHFAAAAM1BMVEVHcEzYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXF4gE2CAAAAEHRSTlMAV5zcH/72wO9wPIf7z+evrVcrhwAAAAlwSFlzAAALEgAACxIB0t1+/AAAAuBJREFUWIXtmddu7CAQhode3Ob9nzYyNjaYYpZFOidS/qtkhb/FUxkW/tSmSVE73FRkRkRcRmMdFXEaSzWIzBqB61jshAgAC+qx2BVRgZ0RySgiWTGWWPj3VCswEetDKe1FYUmpiBz8Akabqex+XoHOYQ3cf8tGkxgMsSyH5Tz4pzE6QhfJ6Eu85j3gbrVFR+Qjm9muILFptiZshJAciIq1WaDRGvU5FmWmbG34NRZRrtFmF/2M5D7sq/6w/wW2bekna381li+VNt6PlbXK14O1xrqaTgG4eYp0YxXOfHOdi8s0rGgvdkOcj6aicuHai3XtUexvS0rtt89l9HxXmFQi3o8dufZXY4mqHFy6sXx4ljlpd7S3SZaZbizVjLPjqDAybpXLsnl0llnts2zLUEUvFoCKY7bhq07UXWr2Db9MeH9Z9g3WVkfHLiyZ9twV5NF0VG5tO1Yh0tUV8kc63Gvloqhpuw+4sNOVpNEEciTCx7pfzAg/dkVNp2/uDexF5FxnWPd9m/kMC/UJkV6eFOzVwK3enebI4uxlSE2weTskY6Co2+uBpSLXdHLHJ1Gd1mMsyWdZdsKu7vfCGjUBFyhsFGDOhLm6jkcnecXuWSbdJVWYDrJwJeLUcsI2IviCWwUTaHdhUI6z27b7VZ3zV+ig/RCdoTJ3EKxsN3AZP035UMay8nyyXC8CbEHPK6zTV+4lisHwjk0cdkSWe4niVcg7NtmsKzW0/uArlngveWPQ4NPi1dsr1lwwepP8Ma14vDx8kB5jTvn4cr7fQ3ANqeUIywRlKL/CYYFr1z74VSSLr1lKzFN2n1eDffE4XYr30dnihOFz5wrtUyVMwmL2FuvIZTxfeYRJNiJLVICpypX3BfxpyfD1apWcb+nQeOuK/MMQPKTOFWqDbmOKqFF++QMCway+/v2A5qitF8+fcQdQfUsKI28EdW8dIVi3nMMawdt5mT2zcdBD+zQ8GPkvBAA/0zOEJ7oqo7UAAAAASUVORK5CYII=', NULL, '超级管理员', '2023-09-21 11:27:50', '超级管理员', '2023-09-22 16:44:12', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002326, '安全检查', 0, 7, 'safetycheck', NULL, NULL, 1, 0, 'M', '0', '0', '', '1', 'nested', NULL, '超级管理员', '2023-09-21 15:33:41', 'jwx', '2023-09-23 11:09:29', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002327, '安全检查内容库定义', 2326, 1, 'rule', 'safetycheck/rule/index', NULL, 1, 0, 'C', '0', '0', 'safetycheck:rule', '1', 'excel', NULL, '超级管理员', '2023-09-21 15:35:12', 'jwx', '2023-09-23 12:23:07', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002328, '安全检查内容库定义查询', 2327, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'safetycheck:rule:query', '1', NULL, NULL, '超级管理员', '2023-09-21 15:35:48', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002329, '安全检查内容库定义新增', 2327, 2, 'safetycheck:rule:add', NULL, NULL, 1, 0, 'F', '0', '0', 'safetycheck:rule:add', '1', NULL, NULL, '超级管理员', '2023-09-21 15:36:30', 'jwx', '2023-09-21 15:46:48', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002330, '安全检查内容库定义编辑', 2327, 3, 'safetycheck:rule:edit', NULL, NULL, 1, 0, 'F', '0', '0', 'safetycheck:rule:edit', '1', NULL, NULL, '超级管理员', '2023-09-21 15:36:58', 'jwx', '2023-09-21 15:46:55', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002331, '安全检查内容库定义删除', 2327, 4, 'safetycheck:rule:remove', NULL, NULL, 1, 0, 'F', '0', '0', 'safetycheck:rule:remove', '1', NULL, NULL, '超级管理员', '2023-09-21 15:37:21', 'jwx', '2023-09-21 15:47:02', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002332, '安全检查内容库管理', 2326, 2, 'rulemanager', 'safetycheck/ruleManager/index', NULL, 1, 0, 'C', '0', '0', 'safetycheck:ruleManager', '1', 'edit', NULL, '超级管理员', '2023-09-21 15:38:40', 'jwx', '2023-09-23 12:21:30', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002333, '安全检查内容库管理查询', 2332, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'safetycheck:ruleManager:query', '1', NULL, NULL, '超级管理员', '2023-09-21 15:40:17', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002334, '安全检查内容库管理新增', 2332, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'safetycheck:ruleManager:add', '1', NULL, NULL, '超级管理员', '2023-09-21 15:41:47', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002335, '安全检查内容库管理编辑', 2332, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'safetycheck:ruleManager:edit', '1', NULL, NULL, '超级管理员', '2023-09-21 15:42:13', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002336, '安全检查内容库管理删除', 2332, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'safetycheck:ruleManager:remove', '1', NULL, NULL, '超级管理员', '2023-09-21 15:43:04', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002338, '演练计划详情', 2321, 6, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:drillPlan:query', '1', NULL, NULL, '超级管理员', '2023-09-22 10:21:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002339, '列表', 2317, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:checkplan:list', '1', NULL, NULL, '超级管理员', '2023-09-22 10:22:19', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002340, '获取详情', 2317, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:checkplan:query', '1', NULL, NULL, '超级管理员', '2023-09-22 10:23:03', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002341, '新增', 2317, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:checkplan:add', '1', NULL, NULL, '超级管理员', '2023-09-22 10:23:24', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002342, '修改', 2317, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:checkplan:edit', '1', NULL, NULL, '超级管理员', '2023-09-22 10:23:46', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002344, '列表', 2318, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:task:list', '1', NULL, NULL, '超级管理员', '2023-09-22 11:20:36', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002345, '详细信息', 2318, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:task:query', '1', NULL, NULL, '超级管理员', '2023-09-22 11:20:54', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002346, '新增', 2318, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:task:add', '1', NULL, NULL, '超级管理员', '2023-09-22 11:21:12', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002347, '修改', 2318, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:task:edit', '1', NULL, NULL, '超级管理员', '2023-09-22 11:21:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002348, '登记', 2318, 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:safetycheck:register', '1', NULL, NULL, '超级管理员', '2023-09-22 16:40:45', '超级管理员', '2023-09-22 16:41:19', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002349, '授权', 2318, 6, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:safetycheck:grant', '1', NULL, NULL, '超级管理员', '2023-09-22 16:41:49', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002350, '问题处理管理', 0, 10, 'question', NULL, NULL, 1, 0, 'M', '0', '0', NULL, '1', 'bug', NULL, '超级管理员', '2023-09-23 16:27:13', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002351, '隐患问题清单', 2350, 1, 'list', 'question/list/index', NULL, 1, 0, 'C', '0', '0', 'question:list', '1', 'list', NULL, '超级管理员', '2023-09-23 16:28:54', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002352, '查询', 2351, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'question:list:query', '1', NULL, NULL, '超级管理员', '2023-09-23 16:29:14', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002353, '隐患确认', 2351, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'question:list:confirm', '1', NULL, NULL, '超级管理员', '2023-09-23 16:29:38', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002354, '异议审批', 2351, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'question:list:confirmDissent', '1', NULL, NULL, '超级管理员', '2023-09-23 16:29:56', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002355, '整改', 2351, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'question:list:reform', '1', NULL, NULL, '超级管理员', '2023-09-23 16:30:16', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002356, '消息中心', 2065, 3, '/message', NULL, NULL, 1, 0, 'M', '0', '0', NULL, '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFYAAABWCAMAAABiiJHFAAAAMFBMVEVHcExsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHQnA1lLAAAAD3RSTlMAQIDA0PAQMKDgcGAgUJBBLOu8AAAACXBIWXMAAAsSAAALEgHS3X78AAABJ0lEQVRYhe3Y2Y6DMAwF0Js9gbT5/7+tspg+jMqwxA+d8X2yUDgCAwIDieTbow7n1ImWwxFWWGGFFfY265469SJqW0aVBhftRdZ6AJGKpW5aADwa6oHcYJifZ6D32FwL70oJbZOh5bqU1IpwhbUY2ihW8v22n73D9kOrXehsvsV2pDZBfWiCutRbmwFfD8gFwEe6ZCtdsuAusaUY43phqUiG7jQzuAvskQgrrLDC/hO2TmXLtszuDGmn2JbNNXurTrPtI+HNqsON+YUldzYLy8O2N+98trvz2fY1wMBWl4OF4mGx8rAIPCw1Q9gvY7P+nDf51Fqf++e2k01dZ4ktpMapKnhUGmEmq51ts/F0Nk1XMYbC+SyHilIeDComPwYUHlUi+UsB8AJnTJyCMJLPUQAAAABJRU5ErkJggg==', NULL, '超级管理员', '2023-09-25 08:43:50', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002357, '删除', 2317, 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:checkplan:remove', '1', NULL, NULL, '超级管理员', '2023-09-25 11:35:35', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002317, '检查计划', 2326, 3, 'check/plan', 'check/index', NULL, 1, 0, 'C', '0', '0', '', '1', 'documentation', NULL, '超级管理员', '2023-09-21 10:35:38', '超级管理员', '2023-09-22 09:42:15', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (00000000000000002318, '检查任务', 2326, 4, 'check/task/index', 'check/task/index', NULL, 1, 0, 'C', '0', '0', '', '1', 'documentation', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
DELETE FROM sys_menu WHERE id IN(2359,2360,2361,2362,2363,2364,2365,2207);
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2207, '信息中心', 0, 8, 'infoCore', NULL, NULL, 1, 0, 'M', '0', '0', 'core:send:list', '1', 'documentation', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2359, '信息发送管理', 2207, 3, 'send', 'core/send/index', NULL, 1, 1, 'C', '0', '0', 'core:send:list', '1', 'email', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2360, '新增', 2359, 1, NULL, NULL, NULL, 1, 0, 'F', '0', '0', 'core:send:add', '1', NULL, NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2361, '删除', 2359, 2, NULL, NULL, NULL, 1, 0, 'F', '0', '0', 'core:send:remove', '1', NULL, NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2362, '修改', 2359, 3, NULL, NULL, NULL, 1, 0, 'F', '0', '0', 'core:send:edit', '1', NULL, NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2363, '详情', 2359, 4, NULL, NULL, NULL, 1, 0, 'F', '0', '0', 'core:send:query', '1', NULL, NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2364, '履职临期提醒', 2207, 3, 'configuration', 'core/configuration/index', NULL, 1, 1, 'C', '0', '0', 'core:configuration:query', '1', 'dashboard', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2365, '提交', 2364, 1, NULL, NULL, NULL, 1, 0, 'F', '0', '0', 'core:configuration:add', '1', NULL, NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
delete from sys_role_menu where menu_id in(2359,2360,2361,2362,2363,2364,2365) ;
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2359);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2360);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2361);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2362);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2363);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2364);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2365);

INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2359);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2360);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2361);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2362);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2363);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2364);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2365);
-- 维护机构扩展字典
DELETE from sys_dict_data where dict_type in ('org_extend_standard','org_extend_business_library_standard','org_extend_self_service_bank_standard','org_extend_detached_standard');

INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 1, 'GA38-2021', '1', 'org_extend_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:04', '超级管理员', '2023-10-07 15:24:27', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 2, 'GA38-2015', '2', 'org_extend_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:10', '超级管理员', '2023-10-07 15:24:36', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 3, '未达标', '3', 'org_extend_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:28', '超级管理员', '2023-10-07 15:24:43', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 1, 'GA38-2021', '1', 'org_extend_business_library_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:45', '超级管理员', '2023-10-07 15:23:55', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 2, 'GA38-2015', '2', 'org_extend_business_library_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:50', '超级管理员', '2023-10-07 15:24:04', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 3, '未达标', '3', 'org_extend_business_library_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:55', '超级管理员', '2023-10-07 15:24:13', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 1, 'GA38-2021', '1', 'org_extend_self_service_bank_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:09', '超级管理员', '2023-10-07 15:22:59', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 2, 'GA38-2015', '2', 'org_extend_self_service_bank_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:13', '超级管理员', '2023-10-07 15:23:09', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 3, '未达标', '3', 'org_extend_self_service_bank_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:20', '超级管理员', '2023-10-07 15:23:28', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 1, 'GA38-2021', '1', 'org_extend_detached_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:33', '超级管理员', '2023-10-07 15:18:18', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 2, 'GA38-2015', '2', 'org_extend_detached_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:37', '超级管理员', '2023-10-07 15:18:27', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 3, '未达标', '3', 'org_extend_detached_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:41', '超级管理员', '2023-10-07 15:18:35', NULL);

-- -------------------------------------------------------
-- ----------新增数据 end  ----------------------------
-- -------------------------------------------------------


-- -------------------------------------------------------
-- ----------更新数据 start  ----------------------------
-- -------------------------------------------------------

UPDATE `sys_dict_data` SET  `dict_label` = '未上报' WHERE `dict_type` = 'protection_status' and `dict_value` = '2';
UPDATE `sys_dict_data` SET `dict_sort` = 900 WHERE `dict_value` = '1' and `dict_type` = 'sys_org_type';
UPDATE `sys_dict_data` SET `dict_sort` = 800 WHERE `dict_value` = '2' and `dict_type` = 'sys_org_type';
UPDATE `sys_dict_data` SET `dict_sort` = 200 WHERE `dict_value` = '3' and `dict_type` = 'sys_org_type';
UPDATE `sys_dict_data` SET `dict_sort` = 100 WHERE `dict_value` = '4' and `dict_type` = 'sys_org_type';
UPDATE `sys_dict_data` SET `dict_sort` = 300 WHERE `dict_value` = '5' and `dict_type` = 'sys_org_type';
UPDATE `sys_dict_data` SET `dict_sort` = 600 WHERE `dict_value` = '6' and `dict_type` = 'sys_org_type';
UPDATE `sys_dict_data` SET `dict_sort` = 700 WHERE `dict_value` = '10' and `dict_type` = 'sys_org_type';
UPDATE `sys_dict_data` SET `dict_sort` = 500 WHERE `dict_value` = '8' and `dict_type` = 'sys_org_type';
UPDATE `sys_dict_data` SET `dict_sort` = 400 WHERE `dict_value` = '7' and `dict_type` = 'sys_org_type';
UPDATE `sys_dict_data` SET `dict_sort` = 1000 WHERE `dict_value` = '9' and `dict_type` = 'sys_org_type';

-- 演练任务状态字典排序修改
UPDATE sys_dict_data t SET t.dict_sort = 2 WHERE  t.dict_type = 'edu_training_do_status' and t.dict_value=1;
UPDATE sys_dict_data t SET t.dict_sort = 1 WHERE  t.dict_type = 'edu_training_do_status' and t.dict_value=4;
UPDATE sys_dict_data t SET t.dict_sort = 4 WHERE t.dict_code = 294 and t.dict_type = 'edu_training_do_status' and t.dict_value=2;
UPDATE sys_dict_data t SET t.dict_label = '待培训' WHERE t.dict_code = 292 and t.dict_type = 'edu_training_do_status' and t.dict_value=0;

-- 教育培训周期字典新增 每日 每周
UPDATE soc.sys_dict_data t SET t.dict_sort = 3 WHERE dict_type='edu_plan_cycle' and dict_value=3;
UPDATE soc.sys_dict_data t SET t.dict_sort = 5 WHERE dict_type='edu_plan_cycle' and dict_value=5;
UPDATE soc.sys_dict_data t SET t.dict_sort = 6 WHERE dict_type='edu_plan_cycle' and dict_value=6;
UPDATE soc.sys_dict_data t SET t.dict_sort = 4 WHERE dict_type='edu_plan_cycle' and dict_value=4;

UPDATE `sys_dict_data` SET `dict_label` = '已逾期' WHERE `dict_type` = 'resumption_status' and `dict_value` = '4';
UPDATE `sys_menu` SET `menu_name` = '布撤防状态监管' WHERE `menu_name` = '防区信息管理' and `platform_type` = '1';
UPDATE `sys_menu` SET `menu_name` = '查询' WHERE `menu_name` = '防区信息管理查询' and `platform_type` = '1';
UPDATE `sys_menu` SET `menu_name` = '新增' WHERE `menu_name` = '防区信息管理新增' and `platform_type` = '1';
UPDATE `sys_menu` SET `menu_name` = '编辑' WHERE `menu_name` = '防区信息管理编辑' and `platform_type` = '1';
UPDATE `sys_menu` SET `menu_name` = '删除' WHERE `menu_name` = '防区信息管理删除' and `platform_type` = '1';

UPDATE `sys_menu` SET `menu_name` = '布撤防状态登记' WHERE `menu_name` = '防区状态' and `platform_type` = '0';
UPDATE `sys_menu` SET `menu_name` = '查询' WHERE `menu_name` = '防区状态查询' and `platform_type` = '0';
UPDATE `sys_menu` SET `menu_name` = '布撤防登记',`platform_type` = '0' WHERE `menu_name` = '防区布撤防'  ;

UPDATE `sys_menu` SET `menu_name` = '履职情况查询' WHERE  (`menu_name`='履职任务管理 ' or `menu_name`='履职任务管理') and  `platform_type` = '1';
UPDATE `sys_menu` SET `menu_name` = '查询' WHERE `menu_name`='履职任务管理查询' and `platform_type` = '1';
UPDATE `sys_menu` SET `menu_name` = '导出' WHERE `menu_name`='履职任务管理导出' and `platform_type` = '1';

-- 更新app菜单路由
UPDATE `sys_menu` SET `path` = '/resumption'  WHERE `id` = 2137;

-- 修改教育培训菜单名称
update sys_menu set menu_name ='教育培训管理' where id=2127;
update sys_menu set menu_name ='知识库标签管理' where id=2038;
update sys_menu set menu_name ='知识库管理' where id=2045;
update sys_menu set menu_name ='培训计划管理' where id=2059;
update sys_menu set menu_name ='培训任务管理' where id=2079;

UPDATE`sys_dict_data` SET `dict_label` = '待确认' WHERE `dict_code` = 360;
UPDATE `sys_dict_data` SET `dict_label` = '待履职' WHERE `dict_code` = 194;
UPDATE `sys_dict_data` SET `status` = '1' WHERE `dict_code` in( 203,208,209);
update sys_menu set icon=SUBSTR(icon,24) WHERE icon like 'http://10.87.10.55:8080%';
update sys_menu set icon='#' where icon is null or icon ='';

DELETE from sys_menu WHERE perms in ('device:protection:add','device:protection:edit','device:protection:remove');
-- -------------------------------------------------------
-- ----------更新数据 end  ----------------------------
-- -------------------------------------------------------