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

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_responsibility_book
    COMMENT='安全责任书签订表';
ALTER TABLE  core_safety_responsibility_book MODIFY COLUMN id bigint auto_increment NOT NULL COMMENT '主键';

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


ALTER TABLE  core_safety_responsibility_type MODIFY COLUMN id bigint auto_increment NOT 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;



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


-- 报警控制器
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`;