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

-- -------------------------------------------------------
-- ----------新增表脚本 start ----------------------------
-- -------------------------------------------------------
DROP TABLE
    IF
    EXISTS `core_evaluate_plan`;
CREATE TABLE `core_evaluate_plan` (
                                      `id` BIGINT NOT NULL,
                                      `org_id` BIGINT DEFAULT NULL COMMENT '机构id',

                                      `build_task_now` VARCHAR ( 1 ) CHARACTER
                                          SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 0 COMMENT '是否立即生效',
                                      `status` VARCHAR ( 2 ) CHARACTER
                                          SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 0 COMMENT '状态',
                                      `is_distribute` VARCHAR ( 2 ) CHARACTER
                                          SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 0 COMMENT '是否下发0未1已',
                                      `org_name` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '机构名称',
                                      `org_path` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '机构路径',
                                      `org_type` VARCHAR ( 2 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '机构类型',
                                      `evaluate_name` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '外包评价名称',
                                      `evaluate_cycle` VARCHAR ( 2 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '周期',
                                      `create_time` DATETIME NULL DEFAULT NULL COMMENT '创建时间',
                                      `update_time` DATETIME NULL DEFAULT NULL COMMENT '修改时间',
                                      `is_deleted` VARCHAR ( 1 ) CHARACTER
                                          SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 0 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,
                                      PRIMARY KEY ( `id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '外包评价计划';

DROP TABLE
    IF
        EXISTS `core_safety_book`;
CREATE TABLE `core_safety_book` (
                                    `id` bigint NOT NULL AUTO_INCREMENT,
                                    `year` int NOT NULL COMMENT '所属年份',
                                    `org_id` bigint DEFAULT NULL COMMENT '签署机构id',
                                    `create_org_id` bigint DEFAULT NULL COMMENT '创建机构ID',
                                    `create_by` bigint DEFAULT NULL COMMENT '创建人id',
                                    `create_time` datetime(6) DEFAULT NULL COMMENT '创建时间',
                                    `update_by` bigint DEFAULT NULL COMMENT '修改人id',
                                    `update_time` datetime(6) DEFAULT NULL COMMENT '更新时间',
                                    `deleted` int DEFAULT '0' COMMENT '是否删除',
                                    `type` int DEFAULT NULL COMMENT '签署责任书类型',
                                    PRIMARY KEY (`id`) USING BTREE,
                                    KEY `idx_orgId` (`org_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1712044807163596803 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

DROP TABLE
    IF
        EXISTS `core_safety_book_user`;
CREATE TABLE `core_safety_book_user` (
                                         `id` bigint NOT NULL AUTO_INCREMENT,
                                         `create_by` bigint DEFAULT NULL COMMENT '创建人id',
                                         `create_time` datetime(6) DEFAULT NULL COMMENT '创建时间',
                                         `update_by` bigint DEFAULT NULL COMMENT '修改人id',
                                         `update_time` datetime(6) DEFAULT NULL COMMENT '更新时间',
                                         `book_id` bigint DEFAULT NULL COMMENT '安全责任书id',
                                         `time` datetime DEFAULT NULL COMMENT '签署时间',
                                         `files` varchar(4000) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '签署文件',
                                         PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1712044894224764930 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

DROP TABLE
    IF
        EXISTS `core_safety_book_user_id`;
CREATE TABLE `core_safety_book_user_id` (
                                            `id` bigint NOT NULL AUTO_INCREMENT,
                                            `create_by` bigint DEFAULT NULL COMMENT '创建人id',
                                            `create_time` datetime(6) DEFAULT NULL COMMENT '创建时间',
                                            `update_by` bigint DEFAULT NULL COMMENT '修改人id',
                                            `update_time` datetime(6) DEFAULT NULL COMMENT '更新时间',
                                            `book_user_id` bigint DEFAULT NULL COMMENT '安全责任书id',
                                            `user_id` bigint DEFAULT NULL COMMENT '签署人姓名',
                                            PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1712044894291873797 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


DROP TABLE
    IF
    EXISTS `core_evaluate_role`;
CREATE TABLE `core_evaluate_role` (
                                      `id` BIGINT NOT NULL,
                                      `evaluate_id` BIGINT DEFAULT NULL COMMENT '评价id',
                                      `role_id` BIGINT DEFAULT NULL COMMENT '角色id',
                                      PRIMARY KEY ( `id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '外包评价计划和角色绑定';

DROP TABLE
    IF
    EXISTS `core_evaluate_content`;
CREATE TABLE `core_evaluate_content` (
                                         `id` BIGINT NOT NULL,
                                         `u_id` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '前端需要的',
                                         `code` BIGINT DEFAULT NULL COMMENT '编号',
                                         `content_type` VARCHAR ( 2 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '评价类型',
                                         `content` VARCHAR ( 1000 ) 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_evaluate_plan_content`;
CREATE TABLE `core_evaluate_plan_content` (
                                              `id` BIGINT NOT NULL,
                                              `evaluate_id` BIGINT DEFAULT NULL COMMENT '评价id',
                                              `content_id` BIGINT DEFAULT NULL COMMENT '内容id',
                                              PRIMARY KEY ( `id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '外包评价计划和内容绑定';

DROP TABLE
    IF
    EXISTS `core_evaluate_task`;
CREATE TABLE `core_evaluate_task` (
                                      `id` BIGINT NOT NULL,
                                      `plan_id` BIGINT DEFAULT NULL COMMENT '评价计划id',
                                      `org_id` BIGINT DEFAULT NULL COMMENT '机构id',
                                      `status` VARCHAR ( 2 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '状态0待1中2完成',
                                      `org_name` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '机构名称',
                                      `org_path` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '机构路径',
                                      `evaluate_name` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '外包评价名称',
                                      `role_name` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '角色',
                                      `create_time` DATETIME NULL DEFAULT NULL COMMENT '创建时间',
                                      `update_time` DATETIME NULL DEFAULT NULL COMMENT '修改时间',
                                      `is_deleted` VARCHAR ( 1 ) CHARACTER
                                          SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 0 COMMENT '是否删除',
                                      `start_time` DATETIME NULL DEFAULT NULL COMMENT '开始时间',
                                      `end_time` DATETIME NULL DEFAULT NULL COMMENT '结束时间',
                                      `complete_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,
                                      `evaluate_by` VARCHAR ( 32 ) CHARACTER
                                          SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
                                      `evaluate_cycle` VARCHAR ( 2 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '周期',
                                      `evaluate_org` VARCHAR ( 32 ) CHARACTER
                                          SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
                                      PRIMARY KEY ( `id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '外包评价任务';

DROP TABLE
    IF
    EXISTS `core_evaluate_task_content`;
CREATE TABLE `core_evaluate_task_content` (
                                              `id` BIGINT NOT NULL,
                                              `task_id` BIGINT DEFAULT NULL COMMENT '评价任务id',
                                              `u_id` VARCHAR ( 255 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '前端需要的',
                                              `code` BIGINT DEFAULT NULL COMMENT '编号',
                                              `content_type` VARCHAR ( 2 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '评价类型',
                                              `content` VARCHAR ( 1000 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '内容',
                                              `score` VARCHAR ( 1000 ) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '评价评分',
                                              PRIMARY KEY ( `id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '外包评价任务绑定内容';

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;

DROP TABLE IF EXISTS `core_safety_dict`;
CREATE TABLE `core_safety_dict` (
    `id` int NOT NULL AUTO_INCREMENT,
    `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '指标分类code',
    `parent_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '父级code',
    `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '指标分类name',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `code` (`code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全指标配置字典表';

-- 新增安保综合评价规则表
DROP TABLE IF EXISTS `core_safety_index_calculate_rule`;
CREATE TABLE `core_safety_index_calculate_rule` (
    id             bigint default 0 not null ,
    type_code      varchar(50)      null comment '指标分类code',
    project_code   varchar(50)      null comment '指标项目code',
    point_code     varchar(50)      null comment '指标要点code',
    deduction_type int              null comment '扣分方式 1：直接扣分，2最高扣分',
    score          int              null comment '分值',
    formula        varchar(500)     null comment '扣分规则描述',
    org_type       int              null comment '机构类型',
    deleted        int    default 0 null comment '是否删除 0否1是',
    cycle          int              null comment '周期，只有在指标分类为安保履职时使用',
    remark         varchar(500)     null comment '备注',
    create_time    datetime         null,
    create_by      varchar(125)     null,
    update_time    datetime         null,
    update_by      varchar(125)     null,
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全指标配置表';

-- 新增安保综合评价规则项表
DROP TABLE IF EXISTS `core_safety_index_calculate_rule_item`;
CREATE TABLE `core_safety_index_calculate_rule_item` (
     id             bigint default 0 not null ,
     rule_id        bigint           null comment '安全指标主键',
     indicator_note varchar(100)     null comment '细化指数描述',
     calculate_type int              null comment '计算类型 1累计数，2连续数，3 分类,4 固化值',
     indicator_days int              null comment '连续数，连续多少天',
     item_type      int              null comment 'calculate_type为3是用来存具体分类',
     item_value     double(5, 2)     null comment '扣分系数',
     order_num      int              null comment '排序',
     create_time    datetime         null,
     create_by      varchar(125)     null,
     update_time    datetime         null,
     update_by      varchar(125)     null,
     PRIMARY KEY (`id`) USING BTREE,
     KEY `rule_id` (`rule_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全指标指数细化表';
-- -------------------------------------------------------
-- ----------新增表脚本 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_schema = DATABASE () and 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_schema = DATABASE () and 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_schema = DATABASE () and  TABLE_NAME = '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_schema = DATABASE () and 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_schema = DATABASE () and  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_schema = DATABASE () and  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_schema = DATABASE () and  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_schema = DATABASE () and 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_schema = DATABASE () and 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_schema = DATABASE () and 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 `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_schema = DATABASE () and 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_schema = DATABASE () and TABLE_NAME = 'core_monitoring_retrieval_plan' AND COLUMN_NAME = 'immediately' ) THEN
ALTER TABLE `core_monitoring_retrieval_plan` ADD COLUMN `immediately` bit(1) NULL DEFAULT NULL COMMENT '立即生成任务';

END IF;
-- 调阅任务绑定硬盘录像机
  IF
NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE  table_schema = DATABASE () and TABLE_NAME = 'core_monitoring_task_registration_monitor' AND COLUMN_NAME = 'host_name' ) THEN
ALTER TABLE `core_monitoring_task_registration_monitor` ADD COLUMN `host_name` VARCHAR ( 255 ) DEFAULT NULL COMMENT '硬盘录像机';

END IF;
-- 调阅任务绑定摄像机
  IF
NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and  TABLE_NAME = 'core_monitoring_task_registration_monitor' AND COLUMN_NAME = 'video_channel_name' ) THEN
ALTER TABLE `core_monitoring_task_registration_monitor` ADD COLUMN `video_channel_name` VARCHAR ( 255 ) DEFAULT NULL COMMENT '摄像机';

END IF;
	-- 履职计划是否下发标识
    IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE  table_schema = DATABASE () and 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;

    -- 履职计划立即生效标识
    IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and TABLE_NAME = 'core_resumption_plan' AND COLUMN_NAME = 'build_task_now' ) THEN
        ALTER TABLE `core_resumption_plan` ADD COLUMN `build_task_now` VARCHAR ( 2 ) DEFAULT NULL COMMENT '立即生效';

    END IF;

    -- 履职项所属机构id字段
    IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and  TABLE_NAME = 'core_resumption_plan_to_point' AND COLUMN_NAME = 'of_org_id' ) THEN
        ALTER TABLE `core_resumption_plan_to_point` ADD COLUMN `of_org_id` bigint NULL COMMENT '所属机构id';

    END IF;

    -- 履职计划所属机构类型
    IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and  TABLE_NAME = 'core_resumption_plan' AND COLUMN_NAME = 'plan_of_org_type' ) THEN
        ALTER TABLE `core_resumption_plan` ADD COLUMN `plan_of_org_type` INT NULL DEFAULT NULL COMMENT '所属机构类型';

    END IF;

    -- 安全检查所属机构类型
    IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and  TABLE_NAME = 'core_safecheck_plan' AND COLUMN_NAME = 'plan_of_org_type' ) THEN
        ALTER TABLE `core_safecheck_plan` ADD COLUMN `plan_of_org_type` INT NULL DEFAULT NULL COMMENT '计划所属机构类型';

    END IF;


	-- 履职任务NFC表增加submitby
    IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and TABLE_NAME = 'core_resumption_data_nfc' AND COLUMN_NAME = 'submit_by' ) THEN
        ALTER TABLE `core_resumption_data_nfc` ADD COLUMN `submit_by` bigint NULL COMMENT '提交人id' AFTER `submit_time`;

    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 ();

ALTER TABLE `core_resumption_rule_item`
MODIFY COLUMN `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '履职项名称' AFTER `rule_id`;

ALTER TABLE `core_resumption_rule_point`
MODIFY COLUMN `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '履职要点名称' AFTER `item_id`;

ALTER TABLE `core_safetycheck_rule_item`
MODIFY COLUMN `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '检查项名称' AFTER `rule_id`;
ALTER TABLE `core_safetycheck_rule_point`
MODIFY COLUMN `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '检查内容' AFTER `item_id`;
-- -------------------------------------------------------
-- ----------修改表脚本 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 ('淋浴式灭火器','防毒面具');
delete  from sys_dict_data where dict_type= 'sys_device_type';
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);
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', 'sys_device_type', 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', 'sys_device_type', 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', 'sys_device_type', 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 (4, '灭火器', '3', 'sys_device_type', 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, '消防栓', '4', 'sys_device_type', 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, '淋浴式灭火器', '5', 'sys_device_type', 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 (7, '防毒面具', '6', 'sys_device_type', 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, '公告通知', 2207, 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(1714247486990786561) ;
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 1714247486990786561);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 1714247486990786561);

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, '');

-- 安全责任书菜单
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 (01711912586825461761, '文书档案', 0, 12, 'safetyBook', NULL, NULL, 1, 0, 'M', '0', '0', NULL, '1', 'documentation', NULL, '超级管理员', '2023-10-11 09:12: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 (01711913107380531202, '安全责任书', 1711912586825461761, 1, 'index', 'safetyBook/index', NULL, 1, 0, 'C', '0', '0', NULL, '1', 'clipboard', NULL, '超级管理员', '2023-10-11 09:14:42', '', 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='safety_book_type' ;
INSERT INTO `sys_dict_type`( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '安全责任书类型', 'safety_book_type', '0', '超级管理员', '2023-10-11 14:36:47', '', 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','evaluate_type','evaluate_task_status');
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);
INSERT INTO `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES ( '评价类型', 'evaluate_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 ( '评价任务状态', 'evaluate_task_status', '0', '超级管理员', '2023-09-13 18:14:59', '', NULL, NULL);

-- 安全责任书类型字典
DELETE from `sys_dict_data` WHERE dict_type='safety_book_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', '1', 'safety_book_type', NULL, 'default', 'N', '0', '超级管理员', '2023-10-11 14:37:00', '', 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', 'safety_book_type', NULL, 'default', 'N', '0', '超级管理员', '2023-10-11 14:37:07', '', 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', 'safety_book_type', NULL, 'default', 'N', '0', '超级管理员', '2023-10-11 14:37:13', '', NULL, NULL);

-- 调整机构状态字典
DELETE from `sys_dict_data` WHERE dict_type='sys_normal_disable';
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', 'sys_normal_disable', '', 'default', 'Y', '0', 'admin', '2023-08-11 09:21:09', '省联社账号', '2023-10-16 10:53:33', '正常状态');
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', 'sys_normal_disable', 'status_no_class', 'default', 'N', '0', 'admin', '2023-08-11 09:21:09', '省联社账号', '2023-10-16 10:57:36', '停用状态');
DELETE from `sys_dict_data` WHERE dict_type='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', 'org_extend_is', NULL, 'default', 'N', '0', '超级管理员', '2023-09-15 09:48:58', '省联社账号', '2023-10-16 14:24:52', 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', '省联社账号', '2023-10-16 14:24:59', NULL);
DELETE from `sys_dict_data` WHERE dict_type='sys_org_type' and 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 ( 1000, '其他', '9', 'sys_org_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-17 00:13:26', '超级管理员', '2023-09-17 00:13:37', NULL);
DELETE from `sys_dict_data` WHERE dict_type='resumption_plan_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 ( 1, '使用中', '1', 'resumption_plan_status', NULL, 'default', 'N', '0', '何悦', '2023-08-29 10:25:18', '省联社账号', '2023-10-16 18:19:52', 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', 'resumption_plan_status', NULL, 'default', 'N', '0', '何悦', '2023-08-29 10:25:29', '省联社账号', '2023-10-16 18:19: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 ( 0, '停用', '2', 'resumption_plan_status', NULL, 'default', 'N', '0', '省联社账号', '2023-10-16 18:20:15', '', NULL, NULL);
DELETE FROM `sys_dict_data` WHERE `dict_type`='check_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 ( 1, '使用中', '1', 'check_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-12 09:36:04', '省联社账号', '2023-10-17 10:19: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 ( 2, '停用', '2', 'check_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-12 09:36:12', '省联社账号', '2023-10-17 10:19:47', 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, '草稿', '0', 'check_status', NULL, 'default', 'N', '0', '省联社账号', '2023-10-17 10:20:01', '', 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','evaluate_cycle');
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', 'evaluate_cycle', 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', 'evaluate_cycle', 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 ( 2, '每年', '2', 'evaluate_cycle', 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 ( 0, '待完成', '0', 'evaluate_task_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', 'evaluate_task_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 ( 2, '已完成', '2', 'evaluate_task_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 ( 3, '已超期', '3', 'evaluate_task_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', 'evaluate_type', 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 ( 2, '评价打分', '2', 'evaluate_type', 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 ( 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,01706239529069875202,2214);
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', '');
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 (01706239529069875202, '下发', 2317, 6, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:checkplan:distribute', '1', '#', NULL, '超级管理员', '2023-09-26 09:56: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 (00000000000000002214, '隐患问题清单', 2136, 4, '/problemItem', NULL, NULL, 1, 0, 'M', '0', '0', '', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFcAAABWCAMAAACNSvr7AAAAM1BMVEVHcEzNmKXNmKXNmKXNmKXNmKXNmKXNmKXNmKXNmKXNmKXNmKXNmKXNmKXNmKXNmKXNmKXc/5sSAAAAEHRSTlMA4NAQ8DBgQIDAoHAgUJCwaDv5MQAAAAlwSFlzAAALEgAACxIB0t1+/AAAAltJREFUWIXtmN12qyAQRkf+FUx4/6c9C4QaZQYwC08v6neTNqm7hIHNKDx58uSXwlfzRXRrsEb4b2Ia2OUrapNrv8S2uJP3flJuHszVAcsBRnON917BPVx94moytpv78t7DiVuftT7ufBM3jFfewOWzn+8Yb84d3OCdaTy38M4YbumdIVxVYMdww8QKI0fXDfPOCC7mnVHc/+Wdvlz3zggu5p0RXDeV3hnB/ZyP4Vx99M4grn36HQAQ0TuaDeaGHS8u9TtsZh3c4Afbu86m18rjVU4t4rp3iMyxk47+cYHd5EIPl2mAdflZ5rOpc3u9YwDUae8sNfLS5R2hQJYrRlia6ybPmuMVEjtevfdvXp2MFlcRWO9ZFaxt1TuGxPrty+KxDZcxkJVPX7XKVaMB/cevpEHi/rDpnTmu8SIKpKjNRPSOqnhnRYcbeo4EXtGSbcuIXg8TrAQ2g98Yt3mftWAF2LDAt2+JrbWmdxSUU5SwLn2CVa7pHQ35J5HPwYSV+XfMmE3vcJexMoHOWJTb9E7uIUNxAyq8HrFbY3OKbHkncTecFAgW5X7OBxrH47sJ5xAsfdLJlfZOqttRXAcsxV2r3jFpnTG5X6GPHRJuiIZ33rGV9XvBylsoFEurNYVnS2bw+Qp0H0epsJp37I93NrA+/wE6De3nO9M+QKHOJSNXWcfzHfNhCFVgiap19DvCfZxDBZZYZD39DqsUl9prXf3Ocv2c7+t3KPBCtg9SbN6R9M1rCAdd7spaH9XqN/fw83MVerBXo957vewwaozU1ljdfFb95M/nSQoA/AN/gr7nzB2jDwAAAABJRU5ErkJggg==', NULL, '超级管理员', '2023-09-20 15:14:35', '超级管理员', '2023-09-20 17:47:12', '');


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);

-- 添加安全检查无周期

delete from `sys_dict_data` where dict_label ='无周期' and dict_type='check_cycle';
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', 'check_cycle', NULL, 'default', 'N', '0', '省联社账号', '2023-10-10 10:43:41', '', NULL, NULL);

-- 新增安全指数字典表
INSERT INTO core_safety_dict (id, code, parent_code, name) VALUES (52, '1004', '-1', '安保履职');
INSERT INTO core_safety_dict (id, code, parent_code, name) VALUES (53, '100402', '1004', '未登');
INSERT INTO core_safety_dict (id, code, parent_code, name) VALUES (54, '10040203', '100402', '网点安全员 (营业中)');
INSERT INTO core_safety_dict (id, code, parent_code, name) VALUES (55, '10040201', '100402', '网点安全员（营业前）');
INSERT INTO core_safety_dict (id, code, parent_code, name) VALUES (56, '10040202', '100402', '网点安全员（营业后）');
INSERT INTO core_safety_dict (id, code, parent_code, name) VALUES (57, '1005', '-1', '问题整改');
INSERT INTO core_safety_dict (id, code, parent_code, name) VALUES (58, '100501', '1005', '问题数量');
INSERT INTO core_safety_dict (id, code, parent_code, name) VALUES (59, '10050101', '100501', '未在规定时间内确认');
INSERT INTO core_safety_dict (id, code, parent_code, name) VALUES (60, '100502', '1005', '整改情况');
INSERT INTO core_safety_dict (id, code, parent_code, name) VALUES (61, '10050201', '100502', '已确认但未在规定时间内完成整改');
INSERT INTO core_safety_dict (id, code, parent_code, name) VALUES (62, '1006', '-1', '监控调阅');
INSERT INTO core_safety_dict (id, code, parent_code, name) VALUES (63, '100601', '1006', '监控调阅-异常通道路数');
INSERT INTO core_safety_dict (id, code, parent_code, name) VALUES (64, '10060101', '100601', '异常通道路数-监控调阅时存在异常的通道数量');
INSERT INTO core_safety_dict (id, code, parent_code, name) VALUES (65, '100602', '1006', '监控调阅-任务连续逾期');
INSERT INTO core_safety_dict (id, code, parent_code, name) VALUES (66, '10060201', '100602', '未在规定时间内完成监控调阅任务');


INSERT INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846745983598592, '1004', '100402', '10040203', 2, 20, '扣分=未登天数*K+未登连续3天*K1+未登连续5天*K2+未登连续10天*K3；得分大于20，取分值20。
K为调节系数，可变更，建议测试期间K=0.5；K1=1.5；K2=3；K3=5。', 4, 0, 0, null, null, null, '2023-10-17 15:41:41', null);
INSERT INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (1714185441062748161, '1004', '100402', '10040201', 2, 20, '扣分=未登天数*K+未登连续3天*K1+未登连续5天*K2+未登连续10天*K3；得分大于20，取分值20。
K为调节系数，可变更，建议测试期间K=0.5；K1=1.5；K2=3；K3=5。', 4, 0, null, '', '2023-10-17 15:43:52', null, null, null);
INSERT INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (1714182049401733122, '1006', '100602', '10060201', 2, 10, '', 4, 0, null, '', '2023-10-17 15:30:23', null, null, null);
INSERT INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (1714172822255894529, '1006', '100601', '10060101', 2, 10, '', 4, 0, null, '', '2023-10-17 14:53:43', null, '2023-10-17 14:54:33', null);
INSERT INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846747145125888, '1004', '100402', '10040202', 2, 20, '扣分=未登天数*K+未登连续3天*K1+未登连续5天*K2+未登连续10天*K3；得分大于20，取分值20。
K为调节系数，可变更，建议测试期间K=0.5；K1=1.5；K2=3；K3=5。', 4, 0, 0, null, null, null, '2023-10-17 15:38:59', null);
INSERT INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846713285328896, '1005', '100501', '10050101', 2, 10, '扣分=问题数量*K+风险等级为“重大”的问题数量*K1+风险等级为“关注”的问题数量*K2+风险等级为“一般”的问题数量*K3+风险等级为“轻微”的问题数量*K4；得分大于10，取分值10。
K为调节系数，可变更，建议测试期间K=0.05；K1=0.05；K2=0.15；K3=0.2；K4=0.25。', 3, 0, null, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846723149234176, '1005', '100502', '10050201', 2, 10, '扣分=两次整改问题数*K+三次或三次以上整改问题数*K1+超期整改问题数*K2+超期未整改问题数量*K3;得分大于10，取分值10。
K为调节系数，可变更，建议测试期间K=3；K1=5；K2=0.6；K3=1。', 5, 0, null, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846721706754048, '1005', '100502', '10050201', 2, 10, '扣分=两次整改问题数*K+三次或三次以上整改问题数*K1+超期整改问题数*K2+超期未整改问题数量*K3;得分大于10，取分值10。
K为调节系数，可变更，建议测试期间K=3；K1=5；K2=0.6；K3=1。', 4, 0, null, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846720300892160, '1005', '100502', '10050201', 2, 10, '扣分=两次整改问题数*K+三次或三次以上整改问题数*K1+超期整改问题数*K2+超期未整改问题数量*K3;得分大于10，取分值10。
K为调节系数，可变更，建议测试期间K=3；K1=5；K2=0.6；K3=1。', 3, 0, null, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846717305962496, '1005', '100501', '10050101', 2, 10, '扣分=问题数量*K+风险等级为“重大”的问题数量*K1+风险等级为“关注”的问题数量*K2+风险等级为“一般”的问题数量*K3+风险等级为“轻微”的问题数量*K4；得分大于10，取分值10。
K为调节系数，可变更，建议测试期间K=0.05；K1=0.05；K2=0.15；K3=0.2；K4=0.25。', 5, 0, null, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846715519614976, '1005', '100501', '10050101', 2, 10, '扣分=问题数量*K+风险等级为“重大”的问题数量*K1+风险等级为“关注”的问题数量*K2+风险等级为“一般”的问题数量*K3+风险等级为“轻微”的问题数量*K4；得分大于10，取分值10。
K为调节系数，可变更，建议测试期间K=0.05；K1=0.05；K2=0.15；K3=0.2；K4=0.25。', 4, 0, null, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846742989668352, '1004', '100401', '10040101', 2, 8, '扣分=补登天数*K+补登连续3天*K1+补登连续5天*K2+补登连续10天*K3；得分大于8，取分值8。
K为调节系数，可变更，建议测试期间K=0.1；K1=1；K2=2；K3=3。', 3, 1, 0, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846744220073984, '1004', '100401', '10040102', 2, 8, '扣分=补登天数*K+补登连续3天*K1+补登连续5天*K2+补登连续10天*K3；得分大于8，取分值8。
K为调节系数，可变更，建议测试期间K=0.1；K1=1；K2=2；K3=3。', 3, 1, 0, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846748579233792, '1004', '100401', '10040101', 2, 10, '扣分=补登天数*K+补登连续3天*K1+补登连续5天*K2+补登连续10天*K3；得分大于10，取分值10。
K为调节系数，可变更，建议测试期间K=0.1；K1=1；K2=2；K3=3。', 5, 1, 0, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846749870702592, '1004', '100401', '10040102', 2, 10, '扣分=补登天数*K+补登连续3天*K1+补登连续5天*K2+补登连续10天*K3；得分大于10，取分值10。
K为调节系数，可变更，建议测试期间K=0.1；K1=1；K2=2；K3=3。', 5, 1, 0, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846751521619968, '1004', '100402', '10040201', 2, 20, '扣分=未登天数*K+未登连续3天*K1+未登连续5天*K2+未登连续10天*K3；得分大于20，取分值20。
K为调节系数，可变更，建议测试期间K=0.5；K1=2；K2=3；K3=5。', 5, 1, 0, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846752731185152, '1004', '100402', '10040202', 2, 20, '扣分=未登天数*K+未登连续3天*K1+未登连续5天*K2+未登连续10天*K3；得分大于20，取分值20。
K为调节系数，可变更，建议测试期间K=0.5；K1=2；K2=3；K3=5。', 5, 1, 0, null, null, null, null, null);

INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846721707180035, 3846721706754048, ' 两次整改问题数', 3, null, 3, 3, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846752731742211, 3846752731185152, ' 未登连续十天', 2, 10, null, 5, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846720301350912, 3846720300892160, ' 超期未整改问题数量', 3, null, 2, 1, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846723149578241, 3846723149234176, '三次或三次以上整改问题数', 3, null, 4, 5, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846721707180033, 3846721706754048, '三次或三次以上整改问题数', 3, null, 4, 5, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846720301350914, 3846720300892160, '三次或三次以上整改问题数', 3, null, 4, 5, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846723149578243, 3846723149234176, '两次整改问题数', 3, null, 3, 3, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846720301350913, 3846720300892160, '两次整改问题数', 3, null, 3, 3, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714172822285254657, 1714172822255894529, '异常通道数:1', 1, null, null, 3, 0, null, null, '2023-10-17 14:54:33', '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714173030498893826, 1714172822255894529, '异常通道数:3', 1, null, null, 4, 0, '2023-10-17 14:54:33', '1', '2023-10-17 14:54:33', '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714173030503088129, 1714172822255894529, '异常通道数:5', 1, null, null, 5, 0, '2023-10-17 14:54:33', '1', '2023-10-17 14:54:33', '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846751521964032, 3846751521619968, '未登天数', 1, null, null, 0.5, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846752731742208, 3846752731185152, '未登天数', 1, null, null, 0.5, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714184891021721602, 3846745983598592, '未登总数', 1, null, null, 1, 0, '2023-10-17 15:41:41', '1', '2023-10-17 15:41:41', '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714185441075331073, 1714185441062748161, '未登总数', 1, null, null, 1, 0, '2023-10-17 15:43:52', '1', null, '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846747145633792, 3846747145125888, '未登总数', 1, null, null, 0.5, 0, null, null, '2023-10-17 15:38:59', '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846752731742209, 3846752731185152, '未登连续三天', 2, 3, null, 2, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846747145633793, 3846747145125888, '未登连续三天', 2, 3, null, 1.5, 0, null, null, '2023-10-17 15:38:59', '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846751521964033, 3846751521619968, '未登连续三天', 2, 3, null, 2, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846747145633794, 3846747145125888, '未登连续五天', 2, 5, null, 3, 0, null, null, '2023-10-17 15:38:59', '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846751521964034, 3846751521619968, '未登连续五天', 2, 5, null, 3, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846752731742210, 3846752731185152, '未登连续五天', 2, 5, null, 3, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1711273894334242818, 1711273894451683330, '未登连续五天', 2, 5, null, 1.5, 0, '2023-10-09 14:54:25', '1', '2023-10-09 15:05:25', '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846747145633795, 3846747145125888, '未登连续十天', 2, 10, null, 5, 0, null, null, '2023-10-17 15:38:59', '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846751521964035, 3846751521619968, '未登连续十天', 2, 10, null, 5, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846702578221056, 3846702577319936, '登记问题数量', 1, null, null, 1, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846720301350915, 3846720300892160, '超期整改问题数', 3, null, 1, 0.6, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846721707180032, 3846721706754048, '超期整改问题数', 3, null, 1, 0.6, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846723149578240, 3846723149234176, '超期整改问题数', 3, null, 1, 0.6, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846721707180034, 3846721706754048, '超期未整改问题数量', 3, null, 2, 1, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846723149578242, 3846723149234176, '超期未整改问题数量', 3, null, 2, 1, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714184891030110210, 3846745983598592, '连续三天未登', 2, 3, null, 1, 0, '2023-10-17 15:41:41', '1', '2023-10-17 15:41:41', '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714185441083719682, 1714185441062748161, '连续三天未登', 2, 3, null, 1, 0, '2023-10-17 15:43:52', '1', null, '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714184891034304513, 3846745983598592, '连续五天未登', 2, 5, null, 1, 0, '2023-10-17 15:41:41', '1', '2023-10-17 15:41:41', '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714185441092108290, 1714185441062748161, '连续五天未登', 2, 5, null, 1, 0, '2023-10-17 15:43:52', '1', null, '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714185441096302594, 1714185441062748161, '连续十天未登', 2, 10, null, 1, 0, '2023-10-17 15:43:52', '1', null, '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714184891038498818, 3846745983598592, '连续十天未登', 2, 10, null, 1, 0, '2023-10-17 15:41:41', '1', '2023-10-17 15:41:41', '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846703826649089, 3846703826108416, '连续报警三天', 2, 3, null, 1, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846706034999297, 3846706034688000, '连续报警三天', 2, 3, null, 1, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846703826649090, 3846703826108416, '连续报警五天', 2, 5, null, 2, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846704899833858, 3846704899145728, '连续报警五天', 2, 5, null, 2, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846706034999298, 3846706034688000, '连续报警五天', 2, 5, null, 2, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846703826649091, 3846703826108416, '连续报警十天', 2, 10, null, 3, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846704899833859, 3846704899145728, '连续报警十天', 2, 10, null, 3, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846706034999299, 3846706034688000, '连续报警十天', 2, 10, null, 3, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714182049414316033, 1714182049401733122, '连续逾期一天', 2, 1, null, 1, 0, '2023-10-17 15:30:23', '1', null, '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714182049494007809, 1714182049401733122, '连续逾期三天', 2, 3, null, 3, 0, '2023-10-17 15:30:23', '1', null, '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714182049498202113, 1714182049401733122, '连续逾期五天', 2, 5, null, 5, 0, '2023-10-17 15:30:23', '1', null, '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714182049502396417, 1714182049401733122, '连续逾期十天', 2, 10, null, 10, 0, '2023-10-17 15:30:23', '1', null, '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846717306454016, 3846717305962496, '问题数量', 1, null, null, 0.05, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846715519942656, 3846715519614976, '问题数量', 1, null, null, 0.05, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846713285820416, 3846713285328896, '问题数量', 1, null, null, 0.05, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846717306454019, 3846717305962496, '风险等级为一般的问题数量', 3, null, 3, 0.2, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846713285820419, 3846713285328896, '风险等级为一般的问题数量', 3, null, 3, 0.2, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846715519942659, 3846715519614976, '风险等级为一般的问题数量', 3, null, 3, 0.2, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846713285820418, 3846713285328896, '风险等级为关注的问题数量', 3, null, 1, 0.15, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846715519942658, 3846715519614976, '风险等级为关注的问题数量', 3, null, 1, 0.15, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846717306454018, 3846717305962496, '风险等级为关注的问题数量', 3, null, 1, 0.15, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846713285820417, 3846713285328896, '风险等级为轻微的问题数量', 3, null, 2, 0.05, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1711273894279716865, 1711273894451683330, '风险等级为轻微的问题数量', 3, 3, null, 0.05, 0, '2023-10-09 14:54:25', '1', '2023-10-09 15:05:25', '1');
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846715519942657, 3846715519614976, '风险等级为轻微的问题数量', 3, null, 2, 0.05, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846717306454017, 3846717305962496, '风险等级为轻微的问题数量', 3, null, 2, 0.05, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846713285820420, 3846713285328896, '风险等级为重大的问题数量', 3, null, 5, 0.25, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846715519942660, 3846715519614976, '风险等级为重大的问题数量', 3, null, 5, 0.25, null, null, null, null, null);
INSERT INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846717306454020, 3846717305962496, '风险等级为重大的问题数量', 3, null, 5, 0.25, null, null, null, null, null);

-- 新增教育培训资料类型字典
delete from sys_dict_type where dict_type='edu_materials_type';
delete from sys_dict_data where dict_type='edu_materials_type';
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES ('教育培训资料类型', 'edu_materials_type', '0', 'slsjyc', 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, '资料类型1', '1', 'edu_materials_type', null, 'default', 'N', '0', 'slsjyc', now(), 'slsjyc', 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 (2, '资料类型2', '2', 'edu_materials_type', null, 'default', 'N', '0', 'slsjyc', now(), 'slsjyc', now(), null);

-- 新增教育培训计划状态字典
delete from sys_dict_type where dict_type='edu_plan_status';
delete from sys_dict_data where dict_type='edu_plan_status';
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES ('教育培训计划状态', 'edu_plan_status', '0', null, 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', 'edu_plan_status', null, 'default', 'N', '0', null, 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, '使用中', '1', 'edu_plan_status', null, 'default', 'N', '0', null, now(), null, 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 (2, '停用', '2', 'edu_plan_status', null, 'default', 'N', '0', null, now(), '', null, null);

-- 新增预案演练计划状态字典
delete from sys_dict_type where dict_type='drill_plan_status';
delete from sys_dict_data where dict_type='drill_plan_status';
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES ('预案演练计划状态', 'drill_plan_status', '0', null, 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_plan_status', null, 'default', 'N', '0', null, 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, '使用中', '1', 'drill_plan_status', null, 'default', 'N', '0', null, now(), null, 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 (2, '停用', '2', 'drill_plan_status', null, 'default', 'N', '0', null, now(), '', null, null);

-- 新增安保综合评价规则目录、菜单、页面及页面权限
delete from sys_menu where id in (1714247486990786561,1712277074707779586,1712278645189414914,1714187591810588674,1714187748136493058,1714187851295399937,1714188002965626881,1714188131026116609);
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 (1712277074707779586, '安全综合管理评价', 0, 13, '/safetyindex', null, null, 1, 0, 'M', '0', '0', '', '1', 'clipboard', null, null, now(), null, 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 (1712278645189414914, '评价规则配置', 1712277074707779586, 1, 'evaluationRule', 'evaluationRule/index', null, 1, 1, 'C', '0', '0', null, '1', 'table', 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 (1714187591810588674, '综合评价规则新增', 1712278645189414914, 1, '', null, null, 1, 0, 'F', '0', '0', 'core:safetyIndexRule:add', '1', null, 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 (1714187748136493058, '综合评价规则编辑', 1712278645189414914, 2, '', null, null, 1, 0, 'F', '0', '0', 'core:safetyIndexRule:edit', '1', null, 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 (1714187851295399937, '综合评价规则详情', 1712278645189414914, 3, '', null, null, 1, 0, 'F', '0', '0', 'core:safetyIndexRule:query', '1', null, 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 (1714188002965626881, '综合评价规则列表查询', 1712278645189414914, 4, '', null, null, 1, 0, 'F', '0', '0', 'core:safetyIndexRule:list', '1', null, 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 (1714188131026116609, '综合评价规则删除', 1712278645189414914, 5, '', null, null, 1, 0, 'F', '0', '0', 'core:safetyIndexRule:remove', '1', null, 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 (1714247486990786561, '撤回计划', 2052, 9, '', null, null, 1, 0, 'F', '0', '0', 'core:accessPlan:add', '1', null, null, null, now(), '', null, '');
delete from sys_role_menu where menu_id in (1712277074707779586,1712278645189414914,1714187591810588674,1714187748136493058,1714187851295399937,1714188002965626881,1714188131026116609);
insert into sys_role_menu select  id,1712277074707779586 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1712278645189414914 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1714187591810588674 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1714187748136493058 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1714187851295399937 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1714188002965626881 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1714188131026116609 from sys_role where role_name like '%省联社安全保卫管理人员%';
-- -------------------------------------------------------
-- ----------新增数据 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` SET dict_label='已逾期' WHERE dict_type='retrieval_task_status' AND dict_label='已超期';
-- 演练任务状态字典排序修改
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 sys_dict_data t SET t.dict_sort = 3 WHERE dict_type='edu_plan_cycle' and dict_value=3;
UPDATE sys_dict_data t SET t.dict_sort = 5 WHERE dict_type='edu_plan_cycle' and dict_value=5;
UPDATE sys_dict_data t SET t.dict_sort = 6 WHERE dict_type='edu_plan_cycle' and dict_value=6;
UPDATE sys_dict_data t SET t.dict_sort = 4 WHERE dict_type='edu_plan_cycle' and dict_value=4;

DELETE FROM `sys_dict_type` WHERE  `dict_type`='safety_check_status';
DELETE FROM `sys_dict_data` WHERE  `dict_type`='safety_check_status';
INSERT INTO `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('安全检查状态', 'safety_check_status', '0', '超级管理员', '2023-09-21 10:40:03', '', 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', 'safety_check_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-21 10:44: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 ( 2, '进行中', '2', 'safety_check_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-21 10:44:29', '', 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', 'safety_check_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-21 10:44:36', '', 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', 'safety_check_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-21 10:44:43', '', NULL, NULL);


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_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=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=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_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');

-- 隐藏知识库标签管理菜单
delete  from sys_role_menu rm  where rm.menu_id in ( select id from sys_menu  where menu_name='知识库标签管理' union all select sm.id from sys_menu m inner join sys_menu sm on m.id=sm.parent_id where  m.menu_name='知识库标签管理');

-- 修改表字段释义
alter table core_edu_training_plan
    modify plan_status int null comment '计划状态：0草稿，1使用中,2停用';
alter table core_drill_plan
    modify plan_status int null comment '计划状态：0草稿，1使用中,2停用';

-- -------------------------------------------------------
-- ----------更新数据 end  ----------------------------
-- -------------------------------------------------------