soc/project_data/sql/0.0.3/soc/soc.sql

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

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


CREATE TABLE if not exists `core_safety_index_calculate_rule_item` (
   id             bigint default 0 not null ,
   rule_id        bigint           null comment '安全指标主键',
   indicator_note varchar(100)     null comment '细化指数描述',
   calculate_type int              null comment '计算类型 1累计数，2连续数，3 分类,4 固化值',
   indicator_days int              null comment '连续数，连续多少天',
   item_type      int              null comment 'calculate_type为3是用来存具体分类',
   item_value     double(5, 2)     null comment '扣分系数',
   order_num      int              null comment '排序',
   create_time    datetime         null,
   create_by      varchar(125)     null,
   update_time    datetime         null,
   update_by      varchar(125)     null,
   PRIMARY KEY (`id`) USING BTREE,
   KEY `rule_id` (`rule_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全指标指数细化表';


CREATE TABLE if not exists core_safe_level
(
id          int auto_increment primary key,
level_name  varchar(50)  null comment '安全等级名称：L1,L2,L3，l4',
min_value   double(5, 2) null comment '最小值',
max_value   double(5, 2) null comment '最大值',
risk_level  int          null comment '等级风险：0：低，1：中，2：高,3: 极高',
description varchar(50)  null comment '安全等级描述:'
) comment '安全等级配置表';

CREATE TABLE if not exists `core_safe_month_score` (
   `id` bigint NOT NULL COMMENT '主键id',
   `level_id` bigint DEFAULT NULL COMMENT '评分等级id',
   `org_id` bigint DEFAULT NULL COMMENT '机构id',
   `data_year` int DEFAULT NULL COMMENT '数据所在年',
   `data_month` int DEFAULT NULL COMMENT '数据所在月',
   `org_score` double(10,2) NOT NULL COMMENT '机构得分',
   `release_status` int DEFAULT NULL COMMENT '评分状态',
   `org_path` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '机构path',
   PRIMARY KEY (`id`) USING BTREE,
   KEY `idx_year_month` (`data_year`,`data_month`) USING BTREE,
   KEY `idx_orgId` (`org_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全指数机构月度得分表';

CREATE TABLE if not exists `core_safety_exception_data` (
    `id` bigint NOT NULL DEFAULT '0' COMMENT '主键',
    `data_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '异常数据id',
    `org_id` bigint DEFAULT NULL COMMENT '机构id',
    `data_time` date DEFAULT NULL COMMENT '数据产生日期',
    `data_source` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '数据来源表',
    `extra_field1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '扩展预留字段',
    `extra_field2` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '扩展预留字段',
    `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全指标的异常数据';

CREATE TABLE if not exists`core_safety_source_data` (
    `id` bigint NOT NULL COMMENT '主键id',
    `rule_id` bigint DEFAULT NULL COMMENT '评价规则id',
    `item_id` bigint DEFAULT NULL COMMENT '评价规则项id',
    `org_id` bigint DEFAULT NULL COMMENT '机构id',
    `data_year` int DEFAULT NULL COMMENT '数据所在年',
    `data_month` int DEFAULT NULL COMMENT '数据所在月',
    `times` int DEFAULT NULL COMMENT '出现次数',
    `score` double(10,2) DEFAULT NULL COMMENT '扣分值',
    `type_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '配置项',
    PRIMARY KEY (`id`) USING BTREE,
    KEY `idx_year_month` (`data_year`,`data_month`) USING BTREE,
    KEY `idx_orgId` (`org_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全指数机构扣分细项表';

CREATE TABLE if not exists `core_safety_deduct_data` (
     `id` bigint NOT NULL COMMENT '主键id',
     `rule_id` bigint DEFAULT NULL COMMENT '评价规则表',
     `org_id` bigint DEFAULT NULL COMMENT '机构id',
     `data_year` int DEFAULT NULL COMMENT '数据所在年',
     `data_month` int DEFAULT NULL COMMENT '数据所在月',
     `score` double(10,2) DEFAULT NULL COMMENT '合计每个子项后得出安全指标的分数',
     `score_real` double(10,2) DEFAULT NULL COMMENT '真实扣分',
     PRIMARY KEY (`id`) USING BTREE,
     KEY `idx_year_month` (`data_year`,`data_month`) USING BTREE,
     KEY `idx_orgId` (`org_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全指数扣分表';


-- 新增安全指数字典表
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (52, '1004', '-1', '安保履职');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (53, '100402', '1004', '未登');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (54, '10040203', '100402', '网点安全员 (营业中)');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (55, '10040201', '100402', '网点安全员（营业前）');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (56, '10040202', '100402', '网点安全员（营业后）');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (57, '1005', '-1', '问题整改');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (58, '100501', '1005', '问题数量');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (59, '10050101', '100501', '未在规定时间内确认');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (60, '100502', '1005', '整改情况');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (61, '10050201', '100502', '已确认但未在规定时间内完成整改');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (62, '1006', '-1', '监控调阅');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (63, '100601', '1006', '监控调阅-未登');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (64, '10060101', '100601', '未登-网点负责人(每周)');

-- 新增安保综合评价规则初始化数据
INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846713285328896, '1005', '100501', '10050101', 2, 10, '扣分=问题数量*K+风险等级为“重大”的问题数量*K1+风险等级为“关注”的问题数量*K2+风险等级为“一般”的问题数量*K3+风险等级为“轻微”的问题数量*K4；得分大于10，取分值10。K为调节系数，可变更，建议测试期间K=0.05；K1=0.05；K2=0.15；K3=0.2；K4=0.25。', 3, 0, null, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846715519614976, '1005', '100501', '10050101', 2, 10, '扣分=问题数量*K+风险等级为“重大”的问题数量*K1+风险等级为“关注”的问题数量*K2+风险等级为“一般”的问题数量*K3+风险等级为“轻微”的问题数量*K4；得分大于10，取分值10。K为调节系数，可变更，建议测试期间K=0.05；K1=0.05；K2=0.15；K3=0.2；K4=0.25。', 4, 0, null, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846717305962496, '1005', '100501', '10050101', 2, 10, '扣分=问题数量*K+风险等级为“重大”的问题数量*K1+风险等级为“关注”的问题数量*K2+风险等级为“一般”的问题数量*K3+风险等级为“轻微”的问题数量*K4；得分大于10，取分值10。K为调节系数，可变更，建议测试期间K=0.05；K1=0.05；K2=0.15；K3=0.2；K4=0.25。', 5, 0, null, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846720300892160, '1005', '100502', '10050201', 2, 10, '扣分=两次整改问题数*K+三次或三次以上整改问题数*K1+超期整改问题数*K2+超期未整改问题数量*K3;得分大于10，取分值10。K为调节系数，可变更，建议测试期间K=3；K1=5；K2=0.6；K3=1。', 3, 0, null, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846721706754048, '1005', '100502', '10050201', 2, 10, '扣分=两次整改问题数*K+三次或三次以上整改问题数*K1+超期整改问题数*K2+超期未整改问题数量*K3;得分大于10，取分值10。K为调节系数，可变更，建议测试期间K=3；K1=5；K2=0.6；K3=1。', 4, 0, null, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846723149234176, '1005', '100502', '10050201', 2, 10, '扣分=两次整改问题数*K+三次或三次以上整改问题数*K1+超期整改问题数*K2+超期未整改问题数量*K3;得分大于10，取分值10。K为调节系数，可变更，建议测试期间K=3；K1=5；K2=0.6；K3=1。', 5, 0, null, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846745983598592, '1004', '100402', '10040203', 2, 20, '扣分=未登天数*K+未登连续3天*K1+未登连续5天*K2+未登连续10天*K3；得分大于20，取分值20。K为调节系数，可变更，建议测试期间K=0.5；K1=1.5；K2=3；K3=5。', 4, 0, 0, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846747145125888, '1004', '100402', '10040202', 2, 20, '扣分=未登天数*K+未登连续3天*K1+未登连续5天*K2+未登连续10天*K3；得分大于20，取分值20。K为调节系数，可变更，建议测试期间K=0.5；K1=1.5；K2=3；K3=5。', 4, 0, 0, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (1714172822255894529, '1006', '100601', '10060101', 2, 10, '扣分=未登天数*K+未登连续3天*K1+未登连续5天*K2+未登连续10天*K3；得分大于20，取分值20。K为调节系数，可变更，建议测试期间K=0.5；K1=1.5；K2=3；K3=5。', 4, 0, null, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (1714185441062748161, '1004', '100402', '10040201', 2, 20, '扣分=未登天数*K+未登连续3天*K1+未登连续5天*K2+未登连续10天*K3；得分大于20，取分值20。K为调节系数，可变更，建议测试期间K=0.5；K1=1.5；K2=3；K3=5。', 4, 0, 0, null, now(), null, now(), null);
-- 新增安 ignore保综合评价规则项初始化数据
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846702578221056, 3846702577319936, '登记问题数量', 1, null, null, 1, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846703826649089, 3846703826108416, '连续报警三天', 2, 3, null, 1, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846703826649090, 3846703826108416, '连续报警五天', 2, 5, null, 2, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846703826649091, 3846703826108416, '连续报警十天', 2, 10, null, 3, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846704899833858, 3846704899145728, '连续报警五天', 2, 5, null, 2, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846704899833859, 3846704899145728, '连续报警十天', 2, 10, null, 3, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846706034999297, 3846706034688000, '连续报警三天', 2, 3, null, 1, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846706034999298, 3846706034688000, '连续报警五天', 2, 5, null, 2, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846706034999299, 3846706034688000, '连续报警十天', 2, 10, null, 3, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846713285820416, 3846713285328896, '问题数量', 1, null, null, 0.05, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846713285820417, 3846713285328896, '风险等级为轻微的问题数量', 3, null, 2, 0.05, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846713285820418, 3846713285328896, '风险等级为关注的问题数量', 3, null, 1, 0.15, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846713285820419, 3846713285328896, '风险等级为一般的问题数量', 3, null, 3, 0.2, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846713285820420, 3846713285328896, '风险等级为重大的问题数量', 3, null, 5, 0.25, null,now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846715519942656, 3846715519614976, '问题数量', 1, null, null, 0.05, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846715519942657, 3846715519614976, '风险等级为轻微的问题数量', 3, null, 2, 0.05, null,now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846715519942658, 3846715519614976, '风险等级为关注的问题数量', 3, null, 1, 0.15, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846715519942659, 3846715519614976, '风险等级为一般的问题数量', 3, null, 3, 0.2, null,now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846715519942660, 3846715519614976, '风险等级为重大的问题数量', 3, null, 5, 0.25, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846717306454016, 3846717305962496, '问题数量', 1, null, null, 0.05, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846717306454017, 3846717305962496, '风险等级为轻微的问题数量', 3, null, 2, 0.05, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846717306454018, 3846717305962496, '风险等级为关注的问题数量', 3, null, 1, 0.15, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846717306454019, 3846717305962496, '风险等级为一般的问题数量', 3, null, 3, 0.2, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846717306454020, 3846717305962496, '风险等级为重大的问题数量', 3, null, 5, 0.25, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846720301350912, 3846720300892160, ' 超期未整改问题数量', 3, null, 2, 1, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846720301350913, 3846720300892160, '两次整改问题数', 3, null, 3, 3, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846720301350914, 3846720300892160, '三次或三次以上整改问题数', 3, null, 4, 5, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846720301350915, 3846720300892160, '超期整改问题数', 3, null, 1, 0.6, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846721707180032, 3846721706754048, '超期整改问题数', 3, null, 1, 0.6, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846721707180033, 3846721706754048, '三次或三次以上整改问题数', 3, null, 4, 5, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846721707180034, 3846721706754048, '超期未整改问题数量', 3, null, 2, 1, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846721707180035, 3846721706754048, ' 两次整改问题数', 3, null, 3, 3, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846723149578240, 3846723149234176, '超期整改问题数', 3, null, 1, 0.6, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846723149578241, 3846723149234176, '三次或三次以上整改问题数', 3, null, 4, 5, null,now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846723149578242, 3846723149234176, '超期未整改问题数量', 3, null, 2, 1, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846723149578243, 3846723149234176, '两次整改问题数', 3, null, 3, 3, null,now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846747145633792, 3846747145125888, '未登总数', 1, null, null, 0.5, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846747145633793, 3846747145125888, '未登连续三天', 2, 3, null, 1.5, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846747145633794, 3846747145125888, '未登连续五天', 2, 5, null, 3, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846747145633795, 3846747145125888, '未登连续十天', 2, 10, null, 5, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846751521964032, 3846751521619968, '未登天数', 1, null, null, 0.5, null,now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846751521964033, 3846751521619968, '未登连续三天', 2, 3, null, 2, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846751521964034, 3846751521619968, '未登连续五天', 2, 5, null, 3, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846751521964035, 3846751521619968, '未登连续十天', 2, 10, null, 5, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846752731742208, 3846752731185152, '未登天数', 1, null, null, 0.5, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846752731742209, 3846752731185152, '未登连续三天', 2, 3, null, 2, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846752731742210, 3846752731185152, '未登连续五天', 2, 5, null, 3, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846752731742211, 3846752731185152, ' 未登连续十天', 2, 10, null, 5, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1711273894279716865, 1711273894451683330, '风险等级为轻微的问题数量', 3, 3, null, 0.05, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1711273894334242818, 1711273894451683330, '未登连续五天', 2, 5, null, 1.5, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714184891021721602, 3846745983598592, '未登总数', 1, null, null, 1, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714184891030110210, 3846745983598592, '连续三天未登', 2, 3, null, 1, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714184891034304513, 3846745983598592, '连续五天未登', 2, 5, null, 1, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714184891038498818, 3846745983598592, '连续十天未登', 2, 10, null, 1, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714185441075331073, 1714185441062748161, '未登总数', 1, null, null, 1, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714185441083719682, 1714185441062748161, '连续三天未登', 2, 3, null, 1, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714185441092108290, 1714185441062748161, '连续五天未登', 2, 5, null, 1, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714185441096302594, 1714185441062748161, '连续十天未登', 2, 10, null, 1, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1717123345548406785, 1714172822255894529, '未登总数', 1, null, null, 10, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1717123345560989697, 1714172822255894529, '连续三次未登', 2, 3, null, 1, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1717123345565184002, 1714172822255894529, '连续五次未登', 2, 5, null, 1, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1717123345569378306, 1714172822255894529, '连续十次未登', 2, 10, null, 1, 0, now(), null, now(), null);

-- 新增安保综合评价规则目录、菜单、页面及页面权限
delete from sys_menu where id in (1714247486990786561,1712277074707779586,1712278645189414914,1714187591810588674,1714187748136493058,1714187851295399937,1714188002965626881,1714188131026116609);
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (1712277074707779586, '安全综合管理评价', 0, 13, '/safetyindex', null, null, 1, 0, 'M', '0', '0', '', '1', 'clipboard', null, null, now(), null, now(), '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (1712278645189414914, '评价规则配置', 1712277074707779586, 1, 'evaluationRule', 'evaluationRule/index', null, 1, 1, 'C', '0', '0', 'core:safetyIndexRule:list', '1', 'table', null, null, now(), '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (1714187591810588674, '综合评价规则新增', 1712278645189414914, 1, '', null, null, 1, 0, 'F', '0', '0', 'core:safetyIndexRule:add', '1', null, null, null, now(), '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (1714187748136493058, '综合评价规则编辑', 1712278645189414914, 2, '', null, null, 1, 0, 'F', '0', '0', 'core:safetyIndexRule:edit', '1', null, null, null, now(), '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (1714187851295399937, '综合评价规则详情', 1712278645189414914, 3, '', null, null, 1, 0, 'F', '0', '0', 'core:safetyIndexRule:query', '1', null, null, null, now(), '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (1714188002965626881, '综合评价规则列表查询', 1712278645189414914, 4, '', null, null, 1, 0, 'F', '0', '0', 'core:safetyIndexRule:list', '1', null, null, null, now(), '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (1714188131026116609, '综合评价规则删除', 1712278645189414914, 5, '', null, null, 1, 0, 'F', '0', '0', 'core:safetyIndexRule:remove', '1', null, null, null, now(), '', null, '');
-- 新增安保综合评价规则页面权限
delete from sys_role_menu where menu_id in (1712277074707779586,1712278645189414914,1714187591810588674,1714187748136493058,1714187851295399937,1714188002965626881,1714188131026116609);
insert into sys_role_menu select  id,1712277074707779586 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1712278645189414914 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1714187591810588674 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1714187748136493058 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1714187851295399937 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1714188002965626881 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1714188131026116609 from sys_role where role_name like '%省联社安全保卫管理人员%';

-- 新增风险等级字典
delete from sys_dict_type where dict_type='risk_level';
delete from sys_dict_data where dict_type='risk_level';
INSERT INTO sys_dict_type ( dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES ('风险等级', 'risk_level', '0', null, now(), null, now(), null);
INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES ( 0, '低', '0', 'risk_level', null, 'default', 'N', '0', null, now(), null, now(), null);
INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES ( 1, '中', '1', 'risk_level', null, 'default', 'N', '0', null, now(), null, now(), null);
INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES ( 2, '高', '2', 'risk_level', null, 'default', 'N', '0', null, now(), null, now(), null);
INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES ( 3, '极高', '3', 'risk_level', null, 'default', 'N', '0', null, now(), null, now(), null);

-- 安全等级初始化数据
INSERT ignore INTO core_safe_level (id, level_name, min_value, max_value, risk_level, description) VALUES (1, 'L1', 90, 100, 0, '90分(不含)以上');
INSERT ignore INTO core_safe_level (id, level_name, min_value, max_value, risk_level, description) VALUES (2, 'L2', 80, 90, 1, '80分(不含)与90分(含)之间 ');
INSERT ignore INTO core_safe_level (id, level_name, min_value, max_value, risk_level, description) VALUES (3, 'L3', 70, 80, 2, '70分(不含)与80分(含)之间');
INSERT ignore INTO core_safe_level (id, level_name, min_value, max_value, risk_level, description) VALUES (4, 'L4', 0, 70, 3, '70分及以下');

-- 新增安全等级菜单及页面权限
delete from sys_menu where id in (1717479664205783042,1717480807703076866,1717480976800636929,1717481080311865346,1717481175799390210,1717481251359776769);
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 (1717479664205783042, '安全等级配置', 1712277074707779586, 1, '/level', 'core/safeLevel/index', null, 1, 0, 'C', '0', '0', 'core.safeIndex:safeLevel:list', '1', 'button', null, null, now(), 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 (1717480807703076866, '安全等级列表', 1717479664205783042, 1, '', null, null, 1, 0, 'F', '0', '0', 'core.safeIndex:safeLevel:list', '1', null, null, null, now(), 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 (1717480976800636929, '安全等级详情', 1717479664205783042, 2, '', null, null, 1, 0, 'F', '0', '0', 'core.safetyIndex:safeLevel:query', '1', null, null, null, now(), 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 (1717481080311865346, '安全等级新增', 1717479664205783042, 3, '', null, null, 1, 0, 'F', '0', '0', 'core.safetyIndex:safeLevel:add', '1', null, null, null, now(), 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 (1717481175799390210, '安全等级编辑', 1717479664205783042, 4, '', null, null, 1, 0, 'F', '0', '0', 'core.safetyIndex:safeLevel:edit', '1', null, null,  null, now(), 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 (1717481251359776769, '安全等级删除', 1717479664205783042, 5, '', null, null, 1, 0, 'F', '0', '0', 'core.safetyIndex:safeLevel:remove', '1', null, null, null, now(), null, now(), null);
-- 安全等级菜单权限
delete from sys_role_menu where menu_id in (1717479664205783042,1717480807703076866,1717480976800636929,1717481080311865346,1717481175799390210,1717481251359776769);
insert into sys_role_menu select  id,1717479664205783042 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1717480807703076866 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1717480976800636929 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1717481080311865346 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1717481175799390210 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1717481251359776769 from sys_role where role_name like '%省联社安全保卫管理人员%';

-- 新增综合计算得分菜单及菜单权限
delete from sys_menu where id in (1718909968666697730,1719970958288199682,1719986164527636481);
delete from sys_role_menu where menu_id in (1718909968666697730,1719970958288199682,1719986164527636481);
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 (1718909968666697730, '计算综合得分', 1712277074707779586, 3, 'scorestatistics', 'scorestatistics/index', null, 1, 1, 'C', '0', '0', 'core:safeMonthScore:list', '1', 'system', null,  null, now(), 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 (1719970958288199682, '综合得分重新计算', 1718909968666697730, 1, '', null, null, 1, 0, 'F', '0', '0', 'core:safetyExceptionData:reCalculate', '1', null, null,  null, now(), 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 (1719986164527636481, '综合得分指数分布', 1718909968666697730, 2, '', null, null, 1, 0, 'F', '0', '0', 'core:safeMonthScore:list', '1', null, null,  null, now(), null, now(), null);
insert into sys_role_menu select  id,1718909968666697730 from sys_role where org_type in (1,2,3);
insert into sys_role_menu select  id,1719970958288199682 from sys_role where org_type in (1,2,3);
insert into sys_role_menu select  id,1719986164527636481 from sys_role where org_type in (1,2,3);


ALTER TABLE  core_protection MODIFY COLUMN id bigint NOT NULL COMMENT '主键';
ALTER TABLE  core_protection MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_protection MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';

ALTER TABLE  core_protection_log MODIFY COLUMN id bigint NOT NULL COMMENT '主键';
ALTER TABLE  core_protection_log MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_protection_log MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';

ALTER TABLE  core_question MODIFY COLUMN id bigint NOT NULL COMMENT '主键';
ALTER TABLE  core_question MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_question MODIFY COLUMN update_time datetime NULL COMMENT '修改时间';
ALTER TABLE  core_question MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_question MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';

ALTER TABLE  core_question_flow MODIFY COLUMN id bigint NOT NULL COMMENT '主键';

ALTER TABLE  core_resumption MODIFY COLUMN id bigint NOT NULL COMMENT '主键';
ALTER TABLE  core_resumption MODIFY COLUMN org_path varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '机构业务路径';
ALTER TABLE  core_resumption MODIFY COLUMN org_name varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '机构名称';
ALTER TABLE  core_resumption MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_resumption MODIFY COLUMN update_time datetime NULL COMMENT '修改时间';
ALTER TABLE  core_resumption MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';

ALTER TABLE  core_resumption_configuration MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_resumption_configuration MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_resumption_configuration MODIFY COLUMN update_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';
ALTER TABLE  core_resumption_configuration MODIFY COLUMN update_time datetime NULL COMMENT '修改时间';
ALTER TABLE  core_resumption_configuration MODIFY COLUMN del_flag varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' NULL COMMENT '删除标识';

ALTER TABLE  core_resumption_data MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';

ALTER TABLE  core_resumption_data_nfc MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';

ALTER TABLE  core_resumption_data_protection MODIFY COLUMN id bigint NOT NULL COMMENT '主键';

ALTER TABLE  core_resumption_data_remarkimg MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';

ALTER TABLE  core_resumption_rule MODIFY COLUMN id bigint auto_increment NOT NULL COMMENT '主键';
ALTER TABLE  core_resumption_rule MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_resumption_rule MODIFY COLUMN update_time datetime NULL COMMENT '修改时间';
ALTER TABLE  core_resumption_rule MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_resumption_rule MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';


ALTER TABLE  core_resumption_rule_item MODIFY COLUMN id bigint auto_increment NOT NULL COMMENT '主键';
ALTER TABLE  core_resumption_rule_item MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_resumption_rule_item MODIFY COLUMN update_time datetime NULL COMMENT '更新时间';
ALTER TABLE  core_resumption_rule_item MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_resumption_rule_item MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';

ALTER TABLE  core_resumption_rule_point MODIFY COLUMN id bigint auto_increment NOT NULL COMMENT '主键';
ALTER TABLE  core_resumption_rule_point MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_resumption_rule_point MODIFY COLUMN update_time datetime NULL COMMENT '修改时间';
ALTER TABLE  core_resumption_rule_point MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';


ALTER TABLE  core_safe_month_score MODIFY COLUMN release_status int NULL COMMENT '评分状态';


ALTER TABLE  core_safecheck_plan MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_safecheck_plan MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';

ALTER TABLE  core_safecheck_plan_to_check_org MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_safecheck_plan_to_check_org MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';

ALTER TABLE  core_safecheck_plan_to_exec_org MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_safecheck_plan_to_exec_org MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';

ALTER TABLE  core_safecheck_plan_to_point MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_safecheck_plan_to_point MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';
ALTER TABLE  core_safecheck_plan_to_point MODIFY COLUMN required tinyint(1) NULL COMMENT '是否必填';

ALTER TABLE  core_safecheck_plan_to_role MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_safecheck_plan_to_role MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '更新人';


ALTER TABLE  core_safety_book MODIFY COLUMN id bigint auto_increment NOT NULL COMMENT '主键';

ALTER TABLE  core_safety_book_user MODIFY COLUMN id bigint auto_increment NOT NULL COMMENT '主键';

ALTER TABLE  core_safety_book_user_id MODIFY COLUMN id bigint auto_increment NOT NULL COMMENT '主键';


ALTER TABLE  core_safety_dict MODIFY COLUMN id int auto_increment NOT NULL COMMENT '主键';


ALTER TABLE  core_safety_exception_data MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';
ALTER TABLE  core_safety_exception_data MODIFY COLUMN create_time datetime DEFAULT CURRENT_TIMESTAMP  NULL COMMENT '创建时间';


ALTER TABLE  core_safety_index_calculate_rule MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';
ALTER TABLE  core_safety_index_calculate_rule MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_safety_index_calculate_rule MODIFY COLUMN create_by varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_safety_index_calculate_rule MODIFY COLUMN update_time datetime NULL COMMENT '更新时间';
ALTER TABLE  core_safety_index_calculate_rule MODIFY COLUMN update_by varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';


ALTER TABLE  core_safety_index_calculate_rule_item MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';
ALTER TABLE  core_safety_index_calculate_rule_item MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_safety_index_calculate_rule_item MODIFY COLUMN create_by varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_safety_index_calculate_rule_item MODIFY COLUMN update_time datetime NULL COMMENT '更新时间';
ALTER TABLE  core_safety_index_calculate_rule_item MODIFY COLUMN update_by varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '更新人';


ALTER TABLE  core_safety_task MODIFY COLUMN id bigint NOT NULL COMMENT '主键';
ALTER TABLE  core_safety_task MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_safety_task MODIFY COLUMN update_time datetime NULL COMMENT '更新时间';
ALTER TABLE  core_safety_task MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_safety_task MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';

ALTER TABLE  core_safety_task_data MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';
ALTER TABLE  core_safety_task_data_nfc MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';

ALTER TABLE  core_safety_task_data_remark MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';
ALTER TABLE  core_safety_task_data_remarkimg MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';

ALTER TABLE  core_safetycheck_rule MODIFY COLUMN id bigint auto_increment NOT NULL COMMENT '主键';
ALTER TABLE  core_safetycheck_rule MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_safetycheck_rule MODIFY COLUMN update_time datetime NULL COMMENT '更新时间';
ALTER TABLE  core_safetycheck_rule MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4;
-- 修改演练任务表状态字段释义
alter table core_drill_task  modify status int default 0 null comment '任务状态:0:待登记,5:待提交,1:待签名,2待评价,3:已完成,4:已逾期';


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_resumption' AND COLUMN_NAME = 'times' ) THEN
        ALTER TABLE `core_resumption`
			ADD COLUMN `times` smallint NULL COMMENT '第几次' AFTER `role_id`;
    END IF;
		-- 履职表增加提交人
	IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and TABLE_NAME = 'core_resumption' AND COLUMN_NAME = 'submitor_id' ) THEN
		ALTER TABLE `soc`.`core_resumption`
			ADD COLUMN `submitor_id` bigint NULL COMMENT '提交人id' AFTER `submit_time`,
			ADD COLUMN `submitor_name` varchar(32) NULL COMMENT '提交人姓名' AFTER `submitor_id`;
    END IF;
	-- 机构扩展添加字段
    IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and TABLE_NAME = 'sys_org_extend' AND COLUMN_NAME = 'remote_count' ) THEN
        ALTER TABLE `sys_org_extend`
            ADD COLUMN `remote_count` int NULL COMMENT '业务库防控隔离门出入口数量';
    END IF;
    IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and TABLE_NAME = 'sys_org_extend' AND COLUMN_NAME = 'cash_adding_room' ) THEN
        ALTER TABLE `sys_org_extend`
            ADD COLUMN `cash_adding_room` int NULL COMMENT '离行式加钞间出入口数量';
    END IF;
    IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and TABLE_NAME = 'sys_org_extend' AND COLUMN_NAME = 'safe_box' ) THEN
        ALTER TABLE `sys_org_extend`
            ADD COLUMN `safe_box` int NULL COMMENT '是否设立保管箱库';
    END IF;
    IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and TABLE_NAME = 'sys_org_extend' AND COLUMN_NAME = 'inner_count' ) THEN
        ALTER TABLE `sys_org_extend`
            ADD COLUMN `inner_count` int NULL COMMENT '内部保安人数';
    END IF;
    IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and TABLE_NAME = 'sys_org_extend' AND COLUMN_NAME = 'outside_count' ) THEN
        ALTER TABLE `sys_org_extend`
            ADD COLUMN `outside_count` int NULL COMMENT '外聘保安人数';
    END IF;
	IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and TABLE_NAME = 'core_protection' AND COLUMN_NAME = 'status_updator_id' ) THEN
		ALTER TABLE `core_protection`
			ADD COLUMN `status_updator_id` bigint NULL DEFAULT NULL COMMENT '上报人id' AFTER `status_update_time`,
			ADD COLUMN `status_updator_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '上报人姓名' AFTER `status_updator_id`;
	END IF;

    -- 安全指数机构分数表增加机构名称字段
    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_safe_month_score'
                    AND column_name = 'org_name') THEN
        alter table core_safe_month_score
            add org_name varchar(125) null comment '机构名称' after org_id;
    END IF;
    -- 调阅计划加所属机构
    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_monitoring_retrieval_plan'
                    AND column_name = 'organization') THEN
    alter table core_monitoring_retrieval_plan
    add organization varchar(255) DEFAULT NULL COMMENT '所属机构';
    END IF;

    -- 安全指数机构分数表增加机构名称字段
    IF NOT EXISTS(SELECT *
                  FROM information_schema.STATISTICS
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_safe_month_score'
                    AND INDEX_NAME = 'idx_year_month') THEN
        drop index idx_orgId on core_safe_month_score;
        drop index idx_year_month on core_safe_month_score;

        create unique index idx_orgId_year_month on core_safe_month_score (org_id, data_year, data_month) comment '机构id+年+月';
    END IF;


    END ??
DELIMITER;
CALL schema_change ();

UPDATE sys_menu SET menu_name='设备登记管理' WHERE id=2050;

UPDATE sys_menu SET menu_name='监控调阅' WHERE id=2076;
UPDATE sys_menu SET menu_name='调阅任务下发' WHERE id=2052;

update sys_menu set menu_name='调阅情况跟踪' where menu_name='监控调阅任务管理';
-- 教育培训菜单名称变更
update sys_menu set menu_name='教育培训' where menu_name='教育培训管理' limit 1;
update sys_menu set menu_name='培训任务下发' where menu_name='培训计划管理' limit 1;
UPDATE sys_menu t SET t.menu_name = '教育培训任务新增' WHERE t.menu_name = '教育培训计划新增' limit 1;
UPDATE sys_menu t SET t.menu_name = '教育培训任务修改' WHERE t.menu_name = '教育培训计划修改' limit 1;
UPDATE sys_menu t SET t.menu_name = '教育培训任务删除' WHERE t.menu_name = '教育培训计划删除' limit 1;
UPDATE sys_menu t SET t.menu_name = '教育培训任务下发' WHERE t.menu_name = '教育培训计划下发' limit 1;
UPDATE sys_menu t SET t.menu_name = '教育培训任务查询' WHERE t.menu_name = '教育培训计划查询' limit 1;
UPDATE sys_menu t SET t.menu_name = '教育培训任务导出' WHERE t.menu_name = '教育培训计划导出' limit 1;
update sys_menu set menu_name='培训登记跟踪' where menu_name='培训任务管理' limit 1;
 -- 培训计划菜单名称修改
update sys_menu set menu_name ='培训登记查询' where perms='core:eduTask:list' and menu_name='查询' limit 1;
update sys_menu set menu_name ='培训登记新增' where perms='core:eduTask:add' and menu_name='新增' limit 1;
update sys_menu set menu_name ='培训登记编辑' where perms='core:eduTask:edit' and menu_name='编辑' limit 1;
update sys_menu set menu_name ='培训登记删除' where perms='core:eduTask:remove' and menu_name='删除' limit 1;
update sys_menu set menu_name ='培训登记导出' where perms='core:eduTask:export' and menu_name='导出' limit 1;

-- 布撤防菜单名称修改
update sys_menu set `menu_name`='履职情况跟踪' WHERE  `menu_name`='履职情况查询';
update sys_menu set `menu_name`='布撤防情况跟踪',parent_id=2000 WHERE  `menu_name`='布撤防状态监管';
-- 履职/安全检查菜单变更
UPDATE `sys_menu` SET `menu_name` = '履职任务下发' WHERE menu_name='履职计划管理';
UPDATE `sys_menu` SET `menu_name` = '检查任务下发' WHERE menu_name='检查计划管理';
UPDATE `sys_menu` SET `menu_name` = '检查登记跟踪' WHERE menu_name='检查任务管理';
UPDATE `sys_menu` SET `menu_name` = '日常履职' WHERE menu_name='日常安全履职';
UPDATE `sys_menu` SET `menu_name` = '安全检查' WHERE menu_name='安全检查管理';
UPDATE `sys_menu` SET `menu_name` = '基础信息' WHERE menu_name='安保基础信息';

-- 增加整改情况跟踪菜单
DELETE FROM `sys_menu` WHERE id in (1719662219582926849,1719663201104588802,2355);
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 (01719662219582926849, '整改情况跟踪', 2350, 2, 'reform', 'question/reform/index', NULL, 1, 0, 'C', '0', '0', 'question:reform', '1', 'post', NULL, 'jwx', '2023-11-01 18:27:01', '', 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 (01719663201104588802, '查询', 1719662219582926849, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'question:reform:query', '1', NULL, NULL, '超级管理员', '2023-11-01 18:30:55', '', 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, '整改', 1719662219582926849, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'question:reform:reform', '1', '#', NULL, '超级管理员', '2023-09-23 16:30:16', '超级管理员', '2023-11-01 18:31:21', '');
-- 安全检查字典变更
DELETE FROM `sys_dict_data` WHERE `dict_type`='safety_check_status';
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 1, '待检查', '1', 'safety_check_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-21 10:44:18', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 2, '进行中', '2', 'safety_check_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-21 10:44:29', '', NULL, NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 3, '已完成', '3', 'safety_check_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-21 10:44:36', '省联社账号', '2023-11-03 10:53:52', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 4, '已逾期', '4', 'safety_check_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-21 10:44:43', '', NULL, NULL);



-- 机构类型字典变更
DELETE FROM `sys_dict_data` WHERE `dict_type`='sys_org_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 ( 900, '省联社', '1', 'sys_org_type', NULL, 'default', 'N', '0', '何悦', '2023-08-16 17:51:17', '何悦', '2023-08-24 10:35:12', 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 ( 800, '办事处', '2', 'sys_org_type', NULL, 'default', 'N', '0', '何悦', '2023-08-16 17:51:38', '超级管理员', '2023-09-05 14:55:20', 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 ( 200, '行社', '3', 'sys_org_type', NULL, 'default', 'N', '0', '何悦', '2023-08-16 17:52:01', '超级管理员', '2023-09-15 18:10:38', 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 ( 100, '营业网点', '4', 'sys_org_type', NULL, 'default', 'N', '0', '何悦', '2023-08-16 17:52:13', '超级管理员', '2023-09-15 18:15:21', 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 ( 300, '离行式自助银行', '5', 'sys_org_type', NULL, 'default', 'N', '0', '何悦', '2023-08-16 17:52:41', '超级管理员', '2023-09-15 18:15:35', 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 ( 600, '中心业务库', '6', 'sys_org_type', NULL, 'default', 'N', '0', '何悦', '2023-08-16 17:52:59', '省联社账号', '2023-11-01 10:42:56', 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 ( 700, '监控中心', '10', 'sys_org_type', NULL, 'default', 'N', '0', '何悦', '2023-08-16 17:53:46', '省联社账号', '2023-11-01 10:43:10', 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 ( 500, '网点业务库', '8', 'sys_org_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-12 19:57:55', '超级管理员', '2023-09-15 18:18:44', 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 ( 400, '保管箱库', '7', 'sys_org_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-15 17:10: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 ( 1000, '其他', '9', 'sys_org_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-17 00:13:26', '超级管理员', '2023-09-17 00:13:37', NULL);
DELETE FROM `sys_dict_data` WHERE `dict_type`='org_platform_brand';
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_platform_brand', NULL, 'default', 'N', '0', '超级管理员', '2023-09-04 15:25:09', '省联社账号', '2023-11-01 10:44:47', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 2, '恒通', '2', 'org_platform_brand', NULL, 'default', 'N', '0', '超级管理员', '2023-09-04 15:25:18', '省联社账号', '2023-11-01 10:44:53', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 3, '讯美', '3', 'org_platform_brand', NULL, 'default', 'N', '0', '超级管理员', '2023-09-04 15:25:25', '省联社账号', '2023-11-01 10:45:01', 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', 'org_platform_brand', NULL, 'default', 'N', '0', '超级管理员', '2023-09-04 15:25:34', '省联社账号', '2023-11-01 10:45:18', NULL);
INSERT INTO `sys_dict_data`( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 5, '海康威视', '5', 'org_platform_brand', NULL, 'default', 'N', '0', '超级管理员', '2023-09-04 15:25:43', '省联社账号', '2023-11-01 10:45:26', NULL);

-- 预案演练菜单名称变更
UPDATE sys_menu set menu_name ='预案演练' WHERE menu_name ='预案演练管理';
UPDATE sys_menu set menu_name ='演练范本管理' WHERE menu_name ='演练库管理';
UPDATE sys_menu set menu_name ='演练范本新增' WHERE menu_name ='演练库新增';
UPDATE sys_menu set menu_name ='演练范本查询' WHERE menu_name ='演练库查询';
UPDATE sys_menu set menu_name ='演练范本编辑' WHERE menu_name ='演练库编辑';
UPDATE sys_menu set menu_name ='演练范本详情' WHERE menu_name ='演练库详情';
UPDATE sys_menu set menu_name ='演练范本删除' WHERE menu_name ='演练库删除';
-- 演练计划
UPDATE sys_menu set menu_name ='演练任务下发' WHERE menu_name ='演练计划管理';
UPDATE sys_menu set menu_name ='演练任务新增' WHERE menu_name ='演练计划新增';
UPDATE sys_menu set menu_name ='演练任务列表' WHERE menu_name ='演练计划列表';
UPDATE sys_menu set menu_name ='演练任务下发' WHERE menu_name ='演练计划下发';
UPDATE sys_menu set menu_name ='演练任务编辑' WHERE menu_name ='演练计划编辑';
UPDATE sys_menu set menu_name ='演练任务删除' WHERE menu_name ='演练计划删除';
UPDATE sys_menu set menu_name ='演练任务详情' WHERE menu_name ='演练计划详情';

UPDATE sys_menu set menu_name ='演练登记跟踪' WHERE menu_name ='演练任务管理';
UPDATE sys_dict_data set dict_label ='待登记' WHERE dict_label ='待演练' AND dict_type='drill_task_status';

update sys_menu set menu_name='演练登记编辑' where perms ='core:drillTask:edit' and menu_name ='演练任务登记' limit 1;
update sys_menu set menu_name='演练登记详情' where perms ='core:drillTask:query' and menu_name ='演练任务详情' limit 1;
update sys_menu set menu_name='演练登记签名' where perms ='core:drillTask:sign' and menu_name ='演练任务签名' limit 1;
update sys_menu set menu_name='演练登记评价' where perms ='core:drillTask:evaluate' and menu_name ='演练任务评价' limit 1;
update sys_menu set menu_name='演练登记删除' where perms ='core:drillTask:remove' and menu_name ='演练任务删除' limit 1;
-- 演练任务
-- 新增演练任务删除按钮菜单及权限赋予
delete from sys_menu where id=1721426177600598018;
delete from sys_role_menu where menu_id=1721426177600598018;
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 (1721426177600598018, '演练任务删除', 2322, 5, '', null, null, 1, 0, 'F', '0', '0', 'core:drillTask:remove', '1', null, null, null, now(), null, now(), null);
insert into sys_role_menu(role_id, menu_id)
select r.id,m.id
from sys_role r ,sys_menu m
where m.menu_name ='演练任务删除' and  m.perms='core:drillTask:remove';


-- 报警控制器
ALTER TABLE `core_protection_log`
MODIFY COLUMN `status_updator_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '上报人姓名' AFTER `status_updator_id`;
-- 修改安全指数机构分数表机构path字段长度
alter table core_safe_month_score modify org_path varchar(225) null comment '机构path';
DELETE FROM sys_menu WHERE id IN(01719287834364436482,01719288533101928450,01719892877586239490,01720000571298115585);
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 (01719287834364436482, '统计报表', 0, 1, 'reportForms', NULL, NULL, 1, 0, 'M', '0', '0', 'core:send:list', '1', 'chart', 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 (01719288533101928450, '安全检查统计报表', 1719287834364436482, 1, 'core/reportForms', 'core/reportForms/safetyInspectReport', NULL, 1, 1, 'C', '0', '0', 'core:safetyInspectReport:list', '1', 'chart', 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 (01719892877586239490, '外包履职评价统计表', 1719287834364436482, 2, 'evaluateTable', 'evaluateTable/index', NULL, 1, 1, 'C', '0', '0', 'core:safetyInspectReport:list', '1', 'chart', 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 (01720000571298115585, '监控调阅统计报表', 1719287834364436482, 3, 'core', 'core/reportForms/monitorAccessReport', NULL, 1, 1, 'C', '0', '0', 'core:monitorAccessReport:list', '1', 'chart', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');

delete from sys_role_menu where menu_id IN(01719287834364436482,01719288533101928450,01719892877586239490,01720000571298115585);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 01720000571298115585);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 01720000571298115585);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (121, 01720000571298115585);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (122, 01720000571298115585);

INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 01719287834364436482);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 01719287834364436482);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (121, 01719287834364436482);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (122, 01719287834364436482);

INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 01719288533101928450);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 01719288533101928450);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (121, 01719288533101928450);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (122, 01719288533101928450);

INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 01719892877586239490);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 01719892877586239490);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (121, 01719892877586239490);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (122, 01719892877586239490);
-- 新增省联社角色
delete from sys_role where role_name IN('省联社部门管理层');
INSERT INTO `sys_role` VALUES (114, '1', '省联社部门管理层', 'default', 0, 1, 1, 1, '0', 0, '超级管理员', '2023-09-04 09:39:13', '超级管理员', '2023-09-16 23:57:16', NULL);
-- 新增驾驶舱
DELETE from `sys_menu` WHERE `id`=01720394197110317057;
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 (01720394197110317057, '驾驶舱', 0, 1, 'board', 'board/index', NULL, 1, 0, 'C', '0', '0', '', '1', 'chart', NULL, '超级管理员', '2023-11-03 18:55:39', '超级管理员', '2023-11-03 18:56:17', '');

-- 新增临时登记按钮
DELETE from `sys_menu` WHERE `id`=01721420669971296258;
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 (01721420669971296258, '临时登记', 2318, 7, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:safetycheck:tempregister', '1', NULL, NULL, '超级管理员', '2023-11-06 14:54:29', '', NULL, '');

DELETE from `sys_role_menu` WHERE `menu_id`=1720394197110317057;
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 1720394197110317057);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 1720394197110317057);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 1720394197110317057);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 1720394197110317057);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 1720394197110317057);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 1720394197110317057);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 1720394197110317057);


-- 同步机构 特殊机构移动配置数据
DELETE FROM `sync_fjnx_org_move` WHERE id IN (1,2,3,4);
INSERT INTO `sync_fjnx_org_move` (`id`, `org_code`, `org_type`) VALUES (1, '910020000', 1);
INSERT INTO `sync_fjnx_org_move` (`id`, `org_code`, `org_type`) VALUES (2, '910040000', 1);
INSERT INTO `sync_fjnx_org_move` (`id`, `org_code`, `org_type`) VALUES (3, '910060000', 1);
INSERT INTO `sync_fjnx_org_move` (`id`, `org_code`, `org_type`) VALUES (4, '910030000', 1);

-- 同步机构 业务机构层级配置数据
DELETE FROM `sync_fjnx_org_business_relation` WHERE id <=19;
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 (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', '900000000', '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', '900000000', '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, 'M41000000', 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);
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 (19, 'M41000000', 'M32000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);

DELETE FROM sys_menu WHERE id IN(01720259442805620738,01717076927401005058,01717079254782545922);
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 (01720259442805620738, '外包评价', 0, 1, 'core', NULL, NULL, 1, 0, 'M', '0', '0', 'core:send:list', '1', 'edit', 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 (01717076927401005058, '评价计划管理', 01720259442805620738, 1, 'resumption', 'resumptionEvaluate/evaluate/index', NULL, 1, 1, 'C', '0', '0', 'core:evaluatePlan:list', '1', 'excel', 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 (01717079254782545922, '外包评价', 01720259442805620738, 2, 'wbpj', 'resumptionEvaluate/evaluatePlan/index', NULL, 1, 1, 'C', '0', '0', 'core:evaluateTask:list', '1', 'checkbox', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');

DELETE from `sys_role_menu` WHERE `menu_id` in(01720259442805620738,01717076927401005058,01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (121, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (122, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (128, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (129, 01720259442805620738);


INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (121, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (122, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (128, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (129, 01717076927401005058);

INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (121, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (122, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (128, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (129, 01717079254782545922);
-- 天气接口配置
delete from sys_config where config_key='WEATHER_URL';
INSERT INTO sys_config (config_id, config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) VALUES (191, '天气接口', 'WEATHER_URL', 'https://ali-weather.showapi.com', 'Y', NULL, now(), NULL, now(), NULL);
-- 知识库状态修改
DELETE FROM sys_dict_data WHERE dict_type = 'materials_status' and dict_value=2;
UPDATE sys_dict_data t SET t.dict_label = '已发布' WHERE dict_type = 'materials_status' and dict_value=1;
UPDATE sys_dict_data t SET t.dict_label = '待发布' WHERE dict_type = 'materials_status' and dict_value=0;
DELETE FROM sys_menu WHERE id IN(01714200330384744450,01714195109957963777);
DELETE FROM sys_menu WHERE menu_name IN('导入设备','导出模版');
INSERT INTO `sys_menu` VALUES (01714200330384744450, '导入设备', 2050, 6, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:device:importData', '1', '#', NULL, '超级管理员', '2023-09-04 17:46:17', '超级管理员', '2023-09-04 17:47:06', '');
INSERT INTO `sys_menu` VALUES (01714195109957963777, '导出模版', 2050, 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:device:export', '1', '#', NULL, '超级管理员', '2023-09-04 17:46:17', '超级管理员', '2023-09-04 17:47:06', '');
DELETE from `sys_role_menu` WHERE `menu_id` in (01714200330384744450,01714195109957963777);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 01714200330384744450);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01714200330384744450);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 01714200330384744450);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 01714200330384744450);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 01714200330384744450);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 01714200330384744450);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 01714200330384744450);

INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 01714195109957963777);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01714195109957963777);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 01714195109957963777);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 01714195109957963777);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 01714195109957963777);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 01714195109957963777);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 01714195109957963777);