From a5487f4ce3594611eaffed5ed14bb2ec6b88adf0 Mon Sep 17 00:00:00 2001
From: yeg <1347747024@qq.com>
Date: 星期六, 05 九月 2026 11:05:24 +0800
Subject: [PATCH] 整理Ticket08验收后注释
---
ruoyi-admin/src/main/resources/db/migration-final/V3__test_data_persistence.sql | 2 ++
1 files changed, 2 insertions(+), 0 deletions(-)
diff --git a/ruoyi-admin/src/main/resources/db/migration-final/V3__test_data_persistence.sql b/ruoyi-admin/src/main/resources/db/migration-final/V3__test_data_persistence.sql
index 9170246..e45ea75 100644
--- a/ruoyi-admin/src/main/resources/db/migration-final/V3__test_data_persistence.sql
+++ b/ruoyi-admin/src/main/resources/db/migration-final/V3__test_data_persistence.sql
@@ -1,3 +1,4 @@
+-- Ticket08：补齐三类测试事实的绑定、接收时间、来源编号和幂等键；原始事实只追加不覆盖。
ALTER TABLE t_test_realtime_record
ADD COLUMN source_identity VARCHAR(256) NULL AFTER adapter_code,
ADD COLUMN source_record_id VARCHAR(128) NULL AFTER source_identity;
@@ -35,6 +36,7 @@
MODIFY COLUMN dedupe_key VARCHAR(512) NOT NULL,
MODIFY COLUMN server_received_at_utc DATETIME(3) NOT NULL,
DROP INDEX uk_step_identity,
+ -- 前缀索引控制 InnoDB 索引长度，同时保留来源身份和幂等键的稳定区分。
ADD UNIQUE KEY uk_step_dedupe (test_battery_id, source_identity(128), dedupe_key(128)),
ADD KEY idx_step_binding_time (binding_id, server_received_at_utc);
--
Gitblit v1.7.1