From b3fb3db3341ea98dac914f62dc94e59fe37e6b3f Mon Sep 17 00:00:00 2001 From: cl <1442464845@qq.com> Date: 星期一, 13 四月 2026 09:00:30 +0800 Subject: [PATCH] 推送报警预写 --- version/db/sys_http_audit_log.sql | 5 +++-- 1 files changed, 3 insertions(+), 2 deletions(-) diff --git a/version/db/sys_http_audit_log.sql b/version/db/sys_http_audit_log.sql index afa0d8b..85bf657 100644 --- a/version/db/sys_http_audit_log.sql +++ b/version/db/sys_http_audit_log.sql @@ -1,12 +1,12 @@ -- HTTP 鎺ュ彛瀹¤锛坮sf-http-audit 鎻掍欢鍐欏叆锛� SET NAMES utf8mb4; -DROP TABLE IF EXISTS `sys_http_audit_log`; CREATE TABLE `sys_http_audit_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', `service_name` varchar(64) DEFAULT NULL COMMENT '搴旂敤 spring.application.name', `scope_type` varchar(16) NOT NULL COMMENT 'EXTERNAL 澶栭儴 / INTERNAL 鍐呴儴', - `uri` varchar(512) NOT NULL COMMENT '璇锋眰璺緞', + `uri` varchar(512) NOT NULL COMMENT '璺緞鎴栧嚭绔欏畬鏁碪RL', + `io_direction` varchar(8) DEFAULT 'IN' COMMENT 'IN鍏ョ珯 OUT鍑虹珯', `method` varchar(16) DEFAULT NULL COMMENT 'HTTP 鏂规硶', `function_desc` varchar(255) DEFAULT NULL COMMENT '鍔熻兘鎻忚堪', `query_string` varchar(2048) DEFAULT NULL COMMENT 'QueryString', @@ -23,5 +23,6 @@ PRIMARY KEY (`id`), KEY `idx_create_time` (`create_time`), KEY `idx_uri` (`uri`(191)), + KEY `idx_io_direction` (`io_direction`), KEY `idx_ok_client` (`ok_flag`,`client_ip`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='HTTP鎺ュ彛瀹¤'; -- Gitblit v1.9.1