Dromara Orion Visor

Appearance

v2.5.4 ​

sql 脚本 - DDL1 ​

sql
ALTER TABLE tag comment '数据标签';
-- 修改来源字段
ALTER TABLE monitor_alarm_event
    CHANGE COLUMN host_id source_id BIGINT NULL COMMENT '事件来源id',
    ADD COLUMN source_type CHAR(12) NULL COMMENT '事件来源' AFTER agent_key,
    ADD COLUMN source_info JSON NULL COMMENT '事件来源信息' AFTER source_id;
-- 添加类型字段
ALTER TABLE monitor_alarm_policy
    ADD type char(12) DEFAULT  NULL COMMENT '策略类型' AFTER id;
-- 重新创建索引
DROP INDEX idx_host_id ON monitor_alarm_event;
CREATE INDEX idx_source
    ON monitor_alarm_event (source_type, source_id);

sql 脚本 - DML ​

sql
-- 修改策略类型
UPDATE monitor_alarm_policy SET type = 'HOST';
-- 修改来源字段
UPDATE monitor_alarm_event
SET source_info = JSON_OBJECT(
            'name', host_name,
            'address', host_address
    ),
    source_type = 'HOST';
-- 修改系统配置项
UPDATE `system_setting` SET config_key = 'encrypt.public-key' WHERE config_key = 'encrypt_publicKey';
UPDATE `system_setting` SET config_key = 'encrypt.private-key' WHERE config_key = 'encrypt_privateKey';
UPDATE `system_setting` SET config_key = 'auto-clear.exec-log.enabled', type = 'auto-clear' WHERE config_key = 'autoClear_execLogEnabled';
UPDATE `system_setting` SET config_key = 'auto-clear.exec-log.keep-days', type = 'auto-clear' WHERE config_key = 'autoClear_execLogKeepDays';
UPDATE `system_setting` SET config_key = 'auto-clear.terminal-log.enabled', type = 'auto-clear' WHERE config_key = 'autoClear_terminalLogEnabled';
UPDATE `system_setting` SET config_key = 'auto-clear.terminal-log.keep-days', type = 'auto-clear' WHERE config_key = 'autoClear_terminalLogKeepDays';
UPDATE `system_setting` SET config_key = 'sftp.preview-size' WHERE config_key = 'sftp_previewSize';
UPDATE `system_setting` SET config_key = 'sftp.upload-present-backup' WHERE config_key = 'sftp_uploadPresentBackup';
UPDATE `system_setting` SET config_key = 'sftp.upload-backup-file-name' WHERE config_key = 'sftp_uploadBackupFileName';
UPDATE `system_setting` SET config_key = 'login.refresh-interval' WHERE config_key = 'login_refreshInterval';
UPDATE `system_setting` SET config_key = 'login.max-refresh-count' WHERE config_key = 'login_maxRefreshCount';
UPDATE `system_setting` SET config_key = 'login.login-failed-lock-time' WHERE config_key = 'login_loginFailedLockTime';
UPDATE `system_setting` SET config_key = 'login.login-failed-send' WHERE config_key = 'login_loginFailedSend';
UPDATE `system_setting` SET config_key = 'login.login-failed-lock' WHERE config_key = 'login_loginFailedLock';
UPDATE `system_setting` SET config_key = 'login.allow-multi-device' WHERE config_key = 'login_allowMultiDevice';
UPDATE `system_setting` SET config_key = 'login.login-session-time' WHERE config_key = 'login_loginSessionTime';
UPDATE `system_setting` SET config_key = 'login.login-failed-send-threshold' WHERE config_key = 'login_loginFailedSendThreshold';
UPDATE `system_setting` SET config_key = 'login.login-failed-lock-threshold' WHERE config_key = 'login_loginFailedLockThreshold';
UPDATE `system_setting` SET config_key = 'login.allow-refresh' WHERE config_key = 'login_allowRefresh';
UPDATE `system_setting` SET config_key = 'log.web-scroll-lines' WHERE config_key = 'log_webScrollLines';
UPDATE `system_setting` SET config_key = 'log.tracker-load-interval' WHERE config_key = 'log_trackerLoadInterval';
UPDATE `system_setting` SET config_key = 'log.tracker-load-lines' WHERE config_key = 'log_trackerLoadLines';
UPDATE `system_setting` SET config_key = 'log.exec-detail.enabled' WHERE config_key = 'log_execDetailLog';

-- 字典项
DELETE FROM `dict_key` WHERE id IN (99, 101);
INSERT INTO `dict_key` VALUES (99, 'alarmPolicyType', 'STRING', '[]', '告警策略类型', '2025-10-13 21:23:35', '2025-10-13 21:23:35', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (101, 'monitorSourceType', 'STRING', '[]', '监控数据来源', '2025-10-19 22:18:01', '2025-10-19 22:18:01', 'admin', 'admin', 0);

-- 字典值
DELETE FROM `dict_value` WHERE id IN (106, 663, 672, 673);
INSERT INTO `dict_value` VALUES (106, 2, 'operatorLogType', 'system-user:offline', '下线用户会话', '{}', 70, '2023-11-02 11:32:39', '2025-10-08 22:35:35', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (663, 99, 'alarmPolicyType', 'HOST', '主机告警', '{}', 10, '2025-10-13 21:23:58', '2025-10-13 21:23:58', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (672, 101, 'monitorSourceType', 'HOST', '主机数据', '{}', 10, '2025-10-19 22:18:19', '2025-10-19 22:18:19', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (673, 101, 'monitorSourceType', 'UPTIME', '拨测数据', '{}', 20, '2025-10-19 22:18:37', '2025-10-19 22:18:37', 'admin', 'admin', 0);

-- 菜单
DELETE FROM `system_menu` WHERE id IN (295, 300, 307, 308);
INSERT INTO `system_menu` VALUES (295, 12, '通知模板', NULL, 2, 40, 1, 1, 1, 0, 'IconEmail', NULL, 'notifyTemplate', '2025-09-13 13:35:07', '2025-10-08 22:21:18', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (300, 282, '告警策略', NULL, 2, 60, 1, 1, 1, 0, 'IconExperiment', NULL, 'alarmPolicy', '2025-09-13 16:13:36', '2025-10-15 13:14:23', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (307, 282, '告警规则', NULL, 2, 61, 0, 1, 1, 0, 'IconExperiment', NULL, 'alarmRule', '2025-09-15 00:01:55', '2025-10-15 13:14:26', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (308, 282, '主机告警事件', NULL, 2, 70, 1, 1, 1, 0, 'IconNotification', NULL, 'alarmEvent', '2025-09-17 16:06:34', '2025-10-19 23:55:25', 'admin', 'admin', 0);

sql 脚本 - DDL2 (需要再 DDL1 和 DML 执行后执行) ​

sql
-- 删除无用字段
ALTER TABLE monitor_alarm_event
DROP COLUMN host_name,
    DROP COLUMN host_address;

最后更新: