soc/project_data/sql/0.0.8/soc/soc.sql

create table if not exists core_reminder_configuration
(
    config_id         bigint                  not null comment '配置ID'
        primary key,
    reminder_type     int                     not null comment '提醒类型（0:逾期提醒、1:临期提醒）',
    send_module       varchar(50)             not null comment '发送模块（五大计划之一）',
    plan_id           bigint       default 1  not null comment '计划id',
    plan_name         varchar(125) default '' not null comment '计划名称',
    compare_time_type int                     null comment '对比时间类型,0:计划开始时间,1:计划结束时间',
    time_unit         varchar(25)             null comment '时间单位',
    reminder_time     int                     null comment '提醒时间',
    enabled           tinyint(1)   default 1  not null comment '是否启用该提醒配置'
)
    comment '短信提醒配置表';
-- auto-generated definition
create table if not exists core_reminder_configuration_role(
    config_id        bigint not null,
    target_role_id   bigint not null,
    target_role_name varchar(125) not null,
    primary key (config_id, target_role_id)
)
    comment '短信提醒配置角色关联表';

create table if not exists core_reminder_configuration_org(
    config_id        bigint not null comment '配置id',
    target_org_id   bigint not null comment '发送目标机构id',
    target_org_name varchar(125) not null comment '发送目标机构名称',
    target_org_type int not null comment '发送目标机构类型',
    target_org_path varchar(125) not null comment '发送目标机构路径',
    primary key (config_id, target_org_id)
)
    comment '短信提醒配置机构关联表';

-- auto-generated definition
create table if not exists core_reminder_log(
    log_id             bigint      not null comment '日志ID'
        primary key,
    schedule_id        bigint      not null comment '关联的提醒任务ID',
    recipient_id       bigint      not null comment '目标接收者id',
    recipient_name     varchar(50) not null comment '目标接收者',
    message_content    text        not null comment '实际发送的短信内容',
    send_time          datetime    not null comment '发送时间',
    result_code        varchar(50) null comment '发送结果代码',
    result_description text        null comment '发送结果描述'
)
    comment '短信提醒事件日志表';

-- auto-generated definition
create table if not exists core_reminder_schedule(
    schedule_id    bigint        not null comment '任务ID'
        primary key,
    config_id      bigint        not null comment '关联的提醒配置ID',
    reminder_type  int           null comment '提醒类型（0:逾期提醒、1:临期提醒）',
    send_module    varchar(36)   null comment '发送模块',
    org_id         bigint(0)     null comment '机构id',
    org_guid       varchar(125)  null comment '机构guid',
    task_id        varchar(125)  null comment '任务id',
    task_name      varchar(225)  null comment '任务名称',
    recipient      varchar(50)  null comment '目标接收者（手机号码或用户ID）',
    recipient_id   varchar(50)   not null comment '目标接收者id',
    recipient_name varchar(125)  not null comment '目标接收者名称',
    scheduled_time datetime      null comment '计划发送时间',
    status         varchar(20)   not null comment '任务状态（未发送、已发送、发送失败等）',
    sent_time      datetime      null comment '实际发送时间（若已发送）',
    retry_count    int default 0 null comment '重试次数（用于处理发送失败情况）'
)
    comment '短信提醒事件(任务)表';

-- auto-generated definition
create table if not exists core_reminder_template(
    template_id      bigint       not null comment '模板ID'
        primary key,
    reminder_type    int          not null comment '提醒类型（与 core_reminder_configuration 关联）',
    template_name    varchar(100) not null comment '模板名称',
    template_content text         not null comment '提醒短信具体内容（支持变量替换）',
    language         varchar(20)  not null comment '模板语言'
)
    comment '短信提醒内容模板表';

drop table  if exists core_compensate_log;
create table core_compensate_log
(
    id            int auto_increment
        primary key,
    business_type varchar(36)  null comment '计划类型',
    plan_id       bigint       null comment '计划id',
    plan_name     varchar(125) null comment '计划名称',
    org_id        bigint       null comment '机构id',
    org_name      varchar(125) null comment '机构名称',
    org_path      varchar(225) null comment '机构路径',
    time          datetime     null,
    res           tinyint      null comment '执行结果',
    error_msg     varchar(225) null comment '错误消息'
)
    comment '业务数据补偿记录表';


-- 新增短信提醒配置菜单
delete from sys_menu where id in (1778733750137446402,1780414461203460097,1780414537732730882,1780414574810378241,1780414761414963201,1780414968466780162);
DELETE from sys_role_menu WHERE menu_id in (1778733750137446402,1780414461203460097,1780414537732730882,1780414574810378241,1780414761414963201,1780414968466780162);
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (1778733750137446402,'短信提醒配置', 1, 50, 'reminder', 'core/reminder/index', null, 1, 0, 'C', '0', '0', 'system:reminder:list', '1', 'email', 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 (1780414461203460097, '查询短信提醒配置', 1778733750137446402, 0, '', null, null, 1, 0, 'F', '0', '0', 'core:reminder:list', '1', null, null, '超级管理员', '2024-04-17 09:55:07', '', 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 (1780414537732730882, '新增短信提醒配置', 1778733750137446402, 1, '', null, null, 1, 0, 'F', '0', '0', 'core:reminder:edit', '1', null, null, '超级管理员', '2024-04-17 09:55:26', '', 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 (1780414574810378241, '编辑短信提醒配置', 1778733750137446402, 2, '', null, null, 1, 0, 'F', '0', '0', 'core:reminder:edit', '1', null, null, '超级管理员', '2024-04-17 09:55:35', '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (1780414761414963201, '查看短信提醒配置', 1778733750137446402, 3, '', null, null, 1, 0, 'F', '0', '0', 'core:reminder:detail', '1', null, null, '超级管理员', '2024-04-17 09:56:19', '', null, '');
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (1780414968466780162, '删除短信提醒配置', 1778733750137446402, 4, '', null, null, 1, 0, 'F', '0', '0', 'core:reminder:remove', '1', null, null, '超级管理员', '2024-04-17 09:57:08', '', null, '');
INSERT into sys_role_menu SELECT id ,1778733750137446402 from sys_role WHERE sys_role.org_type in(1,3);
INSERT into sys_role_menu SELECT id ,1780414461203460097 from sys_role WHERE sys_role.org_type in(1,3);
INSERT into sys_role_menu SELECT id ,1780414537732730882 from sys_role WHERE sys_role.org_type in(1,3);
INSERT into sys_role_menu SELECT id ,1780414574810378241 from sys_role WHERE sys_role.org_type in(1,3);
INSERT into sys_role_menu SELECT id ,1780414761414963201 from sys_role WHERE sys_role.org_type in(1,3);
INSERT into sys_role_menu SELECT id ,1780414968466780162 from sys_role WHERE sys_role.org_type in(1,3);



-- 新增提醒类型字典
delete from sys_dict_type where dict_type = 'reminder_type';
delete from sys_dict_data where dict_type = 'reminder_type';
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES ('提醒类型', 'reminder_type', '0', '超级管理员', '2024-04-12 18:02:23', '', null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (0, '逾期提醒', '0', 'reminder_type', null, 'default', 'N', '0', '超级管理员', now(), null, null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (0, '临期提醒', '1', 'reminder_type', null, 'default', 'N', '0', '超级管理员', now(), null, null, null);


-- 新增提醒业务类型字典
delete from sys_dict_type where dict_type = 'reminder_business_type';
delete from sys_dict_data where dict_type = 'reminder_business_type';
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES ('提醒业务类型', 'reminder_business_type', '0', null, now(), null, null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (0, '安保履职', 'resumption', 'reminder_business_type', null, 'default', 'N', '0', '超级管理员', now(), null, null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (1, '安全检查', 'safetyCheck', 'reminder_business_type', null, 'default', 'N', '0', '超级管理员', now(), null, 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, '教育培训', 'eduTraining', 'reminder_business_type', null, 'default', 'N', '0', '超级管理员', now(), null, 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, '预案演练', 'drill', 'reminder_business_type', null, 'default', 'N', '0', '超级管理员', now(), null, null, null);
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (4, '监控调阅', 'monitoringRetrieval', 'reminder_business_type', null, 'default', 'N', '0', '超级管理员', now(), null, null, null);

DROP TABLE IF EXISTS `core_safety_work_summary`;
CREATE TABLE `core_safety_work_summary` (
                                            `id` bigint NOT NULL,
                                            `title` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '工作主题',
                                            `date` datetime DEFAULT NULL COMMENT '记录日期',
                                            `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '内容',
                                            `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                            `update_time` datetime DEFAULT NULL COMMENT '修改时间',
                                            `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
                                            `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
                                            `images` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '照片',
                                            `org_id` bigint DEFAULT NULL COMMENT '机构id',
                                            `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文件种类',
                                            `year` int DEFAULT NULL COMMENT '工作年度',
                                            `files` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '总结文件',
                                            PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全保卫部年度工作总结';

DROP TABLE IF EXISTS `sys_user_account_mapper`;
CREATE TABLE `sys_user_account_mapper` (
                                           `master_user_id` bigint NOT NULL COMMENT '主账号用户Id',
                                           `sub_user_id` bigint NOT NULL COMMENT '可切换子账号用户Id',
                                           `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                           `create_by` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
                                           `update_time` datetime DEFAULT NULL COMMENT '修改时间',
                                           `update_by` bigint DEFAULT NULL COMMENT '修改人',
                                           PRIMARY KEY (`master_user_id`,`sub_user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='主账号与子账号对应关系表';

-- 新增菜单 年度工作总结
DELETE from `sys_menu` where id in(01774689203604049922,01774690857464254465,01774691065061330945,01774691126533050369,01774691223434055681);
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01774689203604049922, '年度工作总结', 1711912586825461761, 4, 'worksummary', 'safetyBook/workSummary/index', NULL, 1, 0, 'C', '0', '0', 'core:worksummary:query', '1', 'documentation', NULL, '超级管理员', '2024-04-01 14:44:12', '超级管理员', '2024-04-01 14:51:17', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01774690857464254465, '查询', 1774689203604049922, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:worksummary:query', '1', NULL, NULL, '超级管理员', '2024-04-01 14:50:47', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01774691065061330945, '新增', 1774689203604049922, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:worksummary:add', '1', NULL, NULL, '超级管理员', '2024-04-01 14:51:36', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01774691126533050369, '编辑', 1774689203604049922, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:worksummary:edit', '1', NULL, NULL, '超级管理员', '2024-04-01 14:51:51', '', 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 (01774691223434055681, '删除', 1774689203604049922, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:worksummary:delete', '1', NULL, NULL, '超级管理员', '2024-04-01 14:52:14', '', NULL, '');

DELETE from `sys_menu` where id in(01780130457928527874);
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01780130457928527874, '关联账号', 100, 124, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:user:mapperUser', '1', NULL, NULL, '超级管理员', '2024-04-16 15:06:56', '', NULL, '');

DROP TABLE IF EXISTS `sys_version`;
CREATE TABLE `sys_version` (
                               `id` bigint NOT NULL AUTO_INCREMENT,
                               `version` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '版本',
                               `note` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '说明',
                               `path` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '下载地址',
                               `is_use` int DEFAULT NULL COMMENT '是否使用【0.否 1.是】',
                               `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人名称',
                               `create_time` datetime(6) DEFAULT NULL COMMENT '创建时间',
                               `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人名称',
                               `update_time` datetime(6) DEFAULT NULL COMMENT '更新时间',
                               `is_force` int DEFAULT '0' COMMENT '是否强制更新',
                               `type` int DEFAULT '0' COMMENT '版本类型',
                               `package_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文件名称',
                               `file_code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文件code',
                               PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1780128836060065795 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS `core_drill_dictionary_branch`;
CREATE TABLE `core_drill_dictionary_branch` (
                                                `id` int NOT NULL AUTO_INCREMENT COMMENT '主键id',
                                                `org_id` bigint DEFAULT NULL COMMENT '机构id',
                                                `org_name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '机构名称',
                                                `org_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '机构路径',
                                                `drill_type` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '演练项目,字典表关联取值',
                                                `drill_type_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '演练项目名称',
                                                `drill_category` int DEFAULT NULL COMMENT '演练类型,字典表取值',
                                                `drill_category_name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '演练类型名称',
                                                `drill_projects` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '解决方案',
                                                `default_cause` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '预设案由',
                                                `deleted` tinyint(1) DEFAULT NULL COMMENT '删除标志 0:未删除,1:已删除',
                                                `create_by` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
                                                `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                                `update_by` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
                                                `update_time` datetime DEFAULT NULL COMMENT '修改时间',
                                                PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=433799229 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='网点预案演练库';

-- 新增 版本升级管理菜单
DELETE from `sys_menu` where id in(01779819587002064898);
INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01779819587002064898, '版本升级管理', 2, 3, '/version', 'system/version/index', NULL, 1, 0, 'C', '0', '0', 'system:version:list', '1', 'upload', NULL, '超级管理员', '2024-04-15 18:32:07', '', NULL, '');

-- 新增 网点预案管理菜单
DELETE from `sys_menu` where id in(01779818750506852354,01779818971940937730,01779819101465239553,01779819175758946305,01779819248928579585,01779819323872403457);
INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01779818750506852354, '网点预案管理', 2319, 4, '/drillDictionaryBranch', 'core/drill/drillDictionaryBranch/index', NULL, 1, 0, 'C', '0', '0', 'core:drillDictionaryBranch:list', '1', 'row', NULL, '超级管理员', '2024-04-15 18:28:48', '超级管理员', '2024-04-15 18:33:09', '');
INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01779818971940937730, '网点预案查询', 1779818750506852354, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:drillDictionaryBranch:list', '1', NULL, NULL, '超级管理员', '2024-04-15 18:29:40', '', 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 (01779819101465239553, '网点预案添加', 1779818750506852354, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:drillDictionaryBranch:add', '1', NULL, NULL, '超级管理员', '2024-04-15 18:30:11', '', 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 (01779819175758946305, '网点预案编辑', 1779818750506852354, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:drillDictionaryBranch:edit', '1', NULL, NULL, '超级管理员', '2024-04-15 18:30:29', '', 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 (01779819248928579585, '网点预案详情', 1779818750506852354, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:drillDictionaryBranch:detail', '1', NULL, NULL, '超级管理员', '2024-04-15 18:30:46', '', NULL, '');
INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01779819323872403457, '网点预案删除', 1779818750506852354, 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:drillDictionaryBranch:remove', '1', NULL, NULL, '超级管理员', '2024-04-15 18:31:04', '', NULL, '');

-- 新增 升级包平台类型字典
DELETE from `sys_dict_type` where dict_type = 'sys_version_type';
INSERT INTO `sys_dict_type`(`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '升级包平台类型', 'sys_version_type', '0', '超级管理员', '2024-04-17 09:26:55', '', NULL, NULL);

DELETE from `sys_dict_data` where dict_type = 'sys_version_type';
INSERT INTO `sys_dict_data`(`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (0, '安卓', '0', 'sys_version_type', NULL, 'default', 'N', '0', '超级管理员', '2024-04-17 09:27:51', '', NULL, NULL);
INSERT INTO `sys_dict_data`(`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, 'PC', '1', 'sys_version_type', NULL, 'default', 'N', '0', '超级管理员', '2024-04-17 09:28:06', '', NULL, NULL);
INSERT INTO `sys_dict_data`(`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, '挂墙终端', '2', 'sys_version_type', NULL, 'default', 'N', '0', '超级管理员', '2024-04-17 09:28:23', '', 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, 'IOS', '3', 'sys_version_type', NULL, 'default', 'N', '0', '超级管理员', '2024-04-17 09:28:33', '', NULL, NULL);

-- 网点作息配置
DELETE from `sys_menu` where id in(01780503915975847938);
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01780503915975847938, '网点作息配置', 1, 11, 'work-time-banking-office', 'system/workTimeBankingOffice', NULL, 1, 0, 'C', '0', '0', 'system:time:list', '1', 'time', NULL, '超级管理员', '2024-04-17 15:50:55', '超级管理员', '2024-04-17 15:52:47', '');
-- 修改系统参数表 参数值字段长度
alter table sys_config modify config_value longtext default null null comment '参数键值';
-- 登记簿类型字典值丢失 补充
delete from sys_dict_data  where dict_type='register_book_type' and dict_label='离行式自助银行巡检登记簿';
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (6, '离行式自助银行巡检登记簿', '6', 'register_book_type', null, 'default', 'N', '0', '超级管理员', '2024-02-23 14:39:09', '超级管理员', '2024-02-23 14:39:18', null);

-- sys_org_extend 添加 cash_adding_room_control_count 和 remote_control_count 字段
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 = 'sys_org_extend'
                    AND column_name = 'cash_adding_room_control_count') THEN
ALTER TABLE `sys_org_extend`
    ADD COLUMN `cash_adding_room_control_count` int DEFAULT NULL COMMENT '可远程控制和实时授权出入口数量(离行式)' AFTER `total_camera_count`;
END IF;

    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'sys_org_extend'
                    AND column_name = 'remote_control_count') THEN
ALTER TABLE `sys_org_extend`
    ADD COLUMN `remote_control_count` int DEFAULT NULL COMMENT '可远程控制和实时授权出入口数量(业务库)' AFTER `cash_adding_room_control_count`;
END IF;


END ??
DELIMITER ;
CALL schema_change ();

update sys_org_extend set remote_count = 0 , cash_adding_room = 0;


-- 温湿度告警规则字段对应表 单位错位 刷新
UPDATE `iot_alarm_system_field`
SET `unit` = '°C'
WHERE
        `sys_field_code` = '4183_1';

UPDATE `iot_alarm_system_field`
SET `unit` = '%RH'
WHERE
        `sys_field_code` = '4183_2';

UPDATE iot_alarm_data
SET alarm_value = REPLACE ( alarm_value, '°C', '%RH' )
WHERE
    alarm_value IS NOT NULL
  AND `field_code` = '4183_2';

UPDATE iot_alarm_data
SET alarm_value = REPLACE ( alarm_value, '%RH', '°C' )
WHERE
    alarm_value IS NOT NULL
  AND `field_code` = '4183_1';

-- 新增计划任务补偿运维界面
DELETE from `sys_menu` where id in(1782245721165127681);
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (1782245721165127681, '任务数据补偿', 2, 5, 'compensate', 'system/compensate/index', null, 1, 0, 'C', '0', '0', null, '1', 'edit', null, '超级管理员', '2024-04-22 11:11:54', '', null, '');