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

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

 -- 处理菜单图标字段
update sys_menu set icon='#' where icon is null or icon ='';
alter table sys_menu modify icon mediumtext null comment '菜单图标';

-- ----------------------------
-- Table structure for core_announcement_notification
-- ----------------------------
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='配置特殊的机构和部门机构，决定是否要移动到机关机构下';
-- ----------------------------
-- Records of core_announcement_notification
-- ----------------------------


SET FOREIGN_KEY_CHECKS = 1;
-- 监控调阅任务按钮菜单
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', '');

-- 修改教育培训菜单名称
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;

-- 机构扩展添加是否业务库
ALTER TABLE sys_org_extend
    MODIFY COLUMN business_library INT COMMENT '是否业务库';

-- 机构扩展字典添加
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);

DROP TABLE IF EXISTS `core_question_flow`;
DROP TABLE IF EXISTS `core_question`;
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='隐患问题审批流程';
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='隐患问题清单';

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%';


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  EXISTS( SELECT *
      FROM INFORMATION_SCHEMA.COLUMNS
      WHERE TABLE_NAME = 'core_protection'
      AND COLUMN_NAME = 'device_id') THEN
ALTER TABLE core_protection MODIFY device_id bigint
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;

END??
DELIMITER ;
CALL schema_change();

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


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

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

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

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

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

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

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;

-- ----------------------------
-- Table structure for core_announcement_notification_to_role
-- ----------------------------
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;

-- 公告通知end


-- 天气预警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接口填写）');
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;
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');


-- 天气预警end

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

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

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

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

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

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

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



-- 检查任务表
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扫描表';

-- 新增系统参数:演练任务行社推荐数量单季度最大值,演练任务地区推荐数量单季度最大值
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);

-- ----------------------------
-- Table structure for core_message_send
-- ----------------------------
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='消息发送配置';
-- 消息发送配置end

-- ----------------------------
-- Table structure for core_message_center
-- ----------------------------
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='安全检查产生图片表';

-- 调整core_safecheck_plan字段
-- 调整安全检查字段
DELIMITER $$
CREATE PROCEDURE add_column_if_not_exists()
BEGIN
  IF NOT EXISTS (
      SELECT *
      FROM INFORMATION_SCHEMA.COLUMNS
      WHERE TABLE_NAME = 'core_safety_task'
      AND COLUMN_NAME = 'des'
  )
  THEN
ALTER TABLE core_safety_task
    ADD COLUMN des VARCHAR(4000) COMMENT '备注';
END IF;
END$$
DELIMITER ;

CALL add_column_if_not_exists();
DROP PROCEDURE add_column_if_not_exists;

DELIMITER
$$
CREATE PROCEDURE add_column_if_not_exists()
BEGIN IF
NOT EXISTS (
 SELECT *
      FROM INFORMATION_SCHEMA.COLUMNS
      WHERE TABLE_NAME = 'sys_nfc_bind'
      AND COLUMN_NAME = 'label_name'
)
THEN
ALTER TABLE sys_nfc_bind
    ADD COLUMN label_name VARCHAR(255) COMMENT '标签名称';
END IF;
END$$
DELIMITER ;

CALL add_column_if_not_exists();
DROP PROCEDURE add_column_if_not_exists;
DELIMITER
$$
CREATE PROCEDURE add_column_if_not_exists()
BEGIN IF
EXISTS (
  SELECT *
      FROM INFORMATION_SCHEMA.COLUMNS
      WHERE TABLE_NAME = 'sys_area_check'
      AND COLUMN_NAME = 'area_id'
)
THEN
ALTER TABLE sys_area_check
DROP
COLUMN area_id ;
END IF;
END$$
DELIMITER ;

CALL add_column_if_not_exists();
DROP PROCEDURE add_column_if_not_exists;

DELIMITER
$$
CREATE PROCEDURE add_column_if_not_exists()
BEGIN
  IF NOT EXISTS (
      SELECT *
      FROM INFORMATION_SCHEMA.COLUMNS
      WHERE TABLE_NAME = 'core_safecheck_plan_to_point'
      AND COLUMN_NAME = 'required'
  )
  THEN
ALTER TABLE core_safecheck_plan_to_point
    ADD COLUMN required tinyint(1) COMMENT '是否必检';
END IF;
END$$
DELIMITER ;

CALL add_column_if_not_exists();
DROP PROCEDURE add_column_if_not_exists;

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;


DELIMITER $$
CREATE PROCEDURE add_column_if_not_exists()
BEGIN
  IF NOT EXISTS (
      SELECT *
      FROM INFORMATION_SCHEMA.COLUMNS
      WHERE TABLE_NAME = 'core_safecheck_plan'
      AND COLUMN_NAME = 'distribute_status'
  )
  THEN
ALTER TABLE core_safecheck_plan
    ADD COLUMN distribute_status tinyint(1) COMMENT '下发状态';
END IF;
END$$
DELIMITER ;

CALL add_column_if_not_exists();
DROP PROCEDURE add_column_if_not_exists;

DELIMITER $$
CREATE PROCEDURE add_column_if_not_exists()
BEGIN
  IF NOT EXISTS (
      SELECT *
      FROM INFORMATION_SCHEMA.COLUMNS
      WHERE TABLE_NAME = 'core_safecheck_plan'
      AND COLUMN_NAME = 'distribute_plan_status'
  )
  THEN
ALTER TABLE core_safecheck_plan
    ADD COLUMN distribute_plan_status tinyint(1) COMMENT '计划下发默认状态';
END IF;
END$$
DELIMITER ;

CALL add_column_if_not_exists();
DROP PROCEDURE add_column_if_not_exists;
DELIMITER $$
CREATE PROCEDURE add_column_if_not_exists()
BEGIN
  IF NOT EXISTS (
      SELECT *
      FROM INFORMATION_SCHEMA.COLUMNS
      WHERE TABLE_NAME = 'core_safecheck_plan'
      AND COLUMN_NAME = 'parent_id'
  )
  THEN
ALTER TABLE core_safecheck_plan
    ADD COLUMN parent_id tinyint(1) COMMENT '计划下发默认状态';
END IF;
END$$
DELIMITER ;


CALL add_column_if_not_exists();
DROP PROCEDURE add_column_if_not_exists;
DELIMITER $$
CREATE PROCEDURE add_column_if_not_exists()
BEGIN
  IF NOT EXISTS (
      SELECT *
      FROM INFORMATION_SCHEMA.COLUMNS
      WHERE TABLE_NAME = 'core_resumption_data'
      AND COLUMN_NAME = 'data_status'
  )
  THEN
ALTER TABLE core_resumption_data
    ADD COLUMN `data_status` int NULL DEFAULT NULL COMMENT '数据状态：1保存未处理，2保存已处理';
END IF;
END$$
DELIMITER ;


CALL add_column_if_not_exists();
DROP PROCEDURE add_column_if_not_exists;

/*
 Navicat Premium Data Transfer

 Source Server         : 10.87.10.54
 Source Server Type    : MySQL
 Source Server Version : 80034
 Source Host           : 10.87.10.54:3306
 Source Schema         : soc

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

 Date: 25/09/2023 09:20:08
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for core_safecheck_plan
-- ----------------------------
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;

-- ----------------------------
-- Table structure for core_safecheck_plan_to_check_org
-- ----------------------------
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;

SET FOREIGN_KEY_CHECKS = 1;

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='send_time_type' or dict_type='message_type' or dict_type ='send_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);

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

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

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

-- 处理自增id步长问题
alter table core_drill_dictionary auto_increment = 10000;


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';
alter table core_drill_dictionary auto_increment = 10000;
-- 用户导出管理人员
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 (00000000000000002358, '用户导出管理人员', 100, 9, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:user:exportManager', '1', NULL, NULL, '演示安全检查', '2023-09-27 16:10:58', '', NULL, '');