From d5f66b510961aa71057e6d72715d98aaee78cbc4 Mon Sep 17 00:00:00 2001 From: cl <1442464845@qq.com> Date: 星期三, 29 四月 2026 20:50:01 +0800 Subject: [PATCH] 日志表 --- version/db/sys_http_audit_log.sql | 54 ++++++++++++++++++++++++++++-------------------------- 1 files changed, 28 insertions(+), 26 deletions(-) diff --git a/version/db/sys_http_audit_log.sql b/version/db/sys_http_audit_log.sql index 85bf657..07fd237 100644 --- a/version/db/sys_http_audit_log.sql +++ b/version/db/sys_http_audit_log.sql @@ -1,28 +1,30 @@ --- HTTP 鎺ュ彛瀹¤锛坮sf-http-audit 鎻掍欢鍐欏叆锛� SET NAMES utf8mb4; +SET FOREIGN_KEY_CHECKS = 0; -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 '璺緞鎴栧嚭绔欏畬鏁碪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', - `request_body` longtext COMMENT '璇锋眰浣擄紙鍏ㄩ噺锛�', - `response_body` longtext COMMENT '鍝嶅簲浣擄紙鏌ヨ绫绘垨瓒呴暱浼氭埅鏂級', - `response_truncated` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1 鍝嶅簲宸叉埅鏂�', - `http_status` int(11) DEFAULT NULL COMMENT 'HTTP 鐘舵�佺爜', - `ok_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1 姝ｅ父 0 寮傚父', - `spend_ms` int(11) DEFAULT NULL COMMENT '鑰楁椂姣', - `client_ip` varchar(64) DEFAULT NULL COMMENT '瀹㈡埛绔� IP', - `error_message` text COMMENT '寮傚父鎽樿', - `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', - `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '閫昏緫鍒犻櫎', - 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鎺ュ彛瀹¤'; +--D--ROP 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '搴旂敤 spring.application.name', +`scope_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'EXTERNAL 澶栭儴 / INTERNAL 鍐呴儴', +`uri` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '璇锋眰璺緞', +`io_direction` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'IN' COMMENT 'IN鍏ョ珯 OUT鍑虹珯', +`method` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'HTTP 鏂规硶', +`function_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '鍔熻兘鎻忚堪', +`query_string` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'QueryString', +`request_body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '璇锋眰浣擄紙鍏ㄩ噺锛�', +`response_body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '鍝嶅簲浣擄紙鏌ヨ绫绘垨瓒呴暱浼氭埅鏂級', +`response_truncated` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1 鍝嶅簲宸叉埅鏂�', +`http_status` int(11) NULL DEFAULT NULL COMMENT 'HTTP 鐘舵�佺爜', +`ok_flag` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1 姝ｅ父 0 寮傚父', +`spend_ms` int(11) NULL DEFAULT NULL COMMENT '鑰楁椂姣', +`client_ip` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '瀹㈡埛绔� IP', +`error_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '寮傚父鎽樿', +`create_time` datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', +`deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎', +PRIMARY KEY (`id`) USING BTREE, +INDEX `idx_create_time`(`create_time`) USING BTREE, +INDEX `idx_uri`(`uri`(191)) USING BTREE, +INDEX `idx_ok_client`(`ok_flag`, `client_ip`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 3808156 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'HTTP鎺ュ彛瀹¤' ROW_FORMAT = Dynamic; + +SET FOREIGN_KEY_CHECKS = 1; -- Gitblit v1.9.1