From 37f52097847f9025589c79034be2454432c55433 Mon Sep 17 00:00:00 2001
From: xyc <jc_xiong@hotmail.com>
Date: 星期五, 02 十月 2026 10:12:27 +0800
Subject: [PATCH] docs(交接): 记录关机前开发服务已停止

---
 docs/sql_holiday_decimal_migration.sql |   16 ++++++++++++++++
 1 files changed, 16 insertions(+), 0 deletions(-)

diff --git a/docs/sql_holiday_decimal_migration.sql b/docs/sql_holiday_decimal_migration.sql
new file mode 100644
index 0000000..6235c17
--- /dev/null
+++ b/docs/sql_holiday_decimal_migration.sql
@@ -0,0 +1,16 @@
+-- Convert holiday statistics numeric columns from binary floating point to exact decimal storage.
+-- Run once against the traffic_audit database.
+ALTER TABLE holiday_passenger_flow
+  MODIFY COLUMN passenger_count DECIMAL(30,15) NOT NULL COMMENT '鍙戦�佹梾瀹㈡暟锛堜竾浜烘锛�';
+
+ALTER TABLE holiday_vehicle_flow
+  MODIFY COLUMN vehicle_count DECIMAL(30,15) NOT NULL COMMENT '杞︽祦閲忥紙涓囪締娆★級';
+
+ALTER TABLE holiday_passenger_coefficient
+  MODIFY COLUMN coefficient DECIMAL(30,15) NOT NULL COMMENT '瀹㈣繍绯绘暟';
+
+-- The seeded coefficient was averaged from repeated 2.4 cells through a Java double.
+-- Normalize the migrated value to the exact Excel decimal.
+UPDATE holiday_passenger_coefficient
+SET coefficient = 2.4
+WHERE year IN (2024, 2025, 2026);

--
Gitblit v1.9.1