From 5e492e5d5a2b743e2e99443220d343f72a633f6d Mon Sep 17 00:00:00 2001 From: Junjie <fallin.jie@qq.com> Date: 星期二, 03 三月 2026 16:57:52 +0800 Subject: [PATCH] # --- src/main/resources/sql/20260303_create_sys_llm_call_log.sql | 26 ++++++++++++++++++++++++++ 1 files changed, 26 insertions(+), 0 deletions(-) diff --git a/src/main/resources/sql/20260303_create_sys_llm_call_log.sql b/src/main/resources/sql/20260303_create_sys_llm_call_log.sql new file mode 100644 index 0000000..7291358 --- /dev/null +++ b/src/main/resources/sql/20260303_create_sys_llm_call_log.sql @@ -0,0 +1,26 @@ +CREATE TABLE IF NOT EXISTS `sys_llm_call_log` ( + `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', + `trace_id` VARCHAR(64) NOT NULL COMMENT '涓�娆¤皟鐢ㄩ摼璺疘D', + `scene` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '璋冪敤鍦烘櫙', + `stream` TINYINT NOT NULL DEFAULT 0 COMMENT '鏄惁娴佸紡:1鏄�0鍚�', + `attempt_no` INT NOT NULL DEFAULT 1 COMMENT '绗嚑娆¤矾鐢卞皾璇�', + `route_id` BIGINT DEFAULT NULL COMMENT '璺敱ID', + `route_name` VARCHAR(128) DEFAULT NULL COMMENT '璺敱鍚嶇О', + `base_url` VARCHAR(255) DEFAULT NULL COMMENT '璇锋眰API鍦板潃', + `model` VARCHAR(128) DEFAULT NULL COMMENT '妯″瀷鍚�', + `success` TINYINT NOT NULL DEFAULT 0 COMMENT '鏄惁鎴愬姛:1鏄�0鍚�', + `http_status` INT DEFAULT NULL COMMENT 'HTTP鐘舵�佺爜', + `latency_ms` BIGINT DEFAULT NULL COMMENT '鑰楁椂ms', + `switch_mode` VARCHAR(32) DEFAULT NULL COMMENT '鍒囨崲瑙﹀彂绫诲瀷:none/quota/error', + `request_content` MEDIUMTEXT COMMENT '璇锋眰鍐呭(鎴柇)', + `response_content` MEDIUMTEXT COMMENT '鍝嶅簲鍐呭(鎴柇)', + `error_type` VARCHAR(128) DEFAULT NULL COMMENT '寮傚父绫诲瀷', + `error_message` VARCHAR(1024) DEFAULT NULL COMMENT '寮傚父淇℃伅', + `extra` VARCHAR(512) DEFAULT NULL COMMENT '鎵╁睍淇℃伅', + `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + PRIMARY KEY (`id`), + KEY `idx_sys_llm_call_log_trace` (`trace_id`), + KEY `idx_sys_llm_call_log_scene_time` (`scene`, `create_time`), + KEY `idx_sys_llm_call_log_route_time` (`route_id`, `create_time`), + KEY `idx_sys_llm_call_log_success_time` (`success`, `create_time`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='LLM璋冪敤鏃ュ織'; -- Gitblit v1.9.1