From 2f3c2d2851f7693357feb9e62a56a64670755c6a Mon Sep 17 00:00:00 2001
From: xyc <jc_xiong@hotmail.com>
Date: 星期二, 06 十月 2026 14:25:27 +0800
Subject: [PATCH] fix(holiday): 拥挤度标签恢复两位小数

---
 deploy-templates/db/init.sql |   17 ++++++++++++++++-
 1 files changed, 16 insertions(+), 1 deletions(-)

diff --git a/deploy-templates/db/init.sql b/deploy-templates/db/init.sql
index dcc9932..7d79383 100644
--- a/deploy-templates/db/init.sql
+++ b/deploy-templates/db/init.sql
@@ -632,7 +632,7 @@
   year INT NOT NULL COMMENT '骞翠唤',
   holiday_type VARCHAR(32) NOT NULL COMMENT '鑺傚亣鏃ュ垎绫伙細SPRING_FESTIVAL/LABOR_DAY/NATIONAL_DAY',
   holiday_date DATE NOT NULL COMMENT '鑺傚亣鏃ュ叿浣撴棩鏈�',
-  day_index INT NOT NULL COMMENT '绗嚑鏃ワ紝浠� 1 寮�濮�',
+  day_index INT NOT NULL COMMENT '0=鍓嶄竴鏃ワ紝1..N=鍋囨湡绗琋鏃�',
   created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
   updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   PRIMARY KEY (id),
@@ -673,6 +673,21 @@
   KEY idx_holiday_vehicle_date (flow_date)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鑺傚亣鏃ョ患鍚堣繍杈撻潪钀ヤ笟鎬ц溅娴佹儏鍐�';
 
+-- 寰�骞村浗鐪侀亾杞︽祦閲忚皟鏁�
+DROP TABLE IF EXISTS holiday_vehicle_adjustment;
+CREATE TABLE holiday_vehicle_adjustment (
+  id BIGINT NOT NULL AUTO_INCREMENT,
+  year INT NOT NULL COMMENT '骞翠唤',
+  flow_date DATE NOT NULL COMMENT '鏃ユ湡',
+  adjusted_value DECIMAL(30,15) NOT NULL COMMENT '璋冩暣鍚庢櫘閫氬浗鐪侀亾杞︽祦閲忥紙涓囪締娆★級',
+  reason VARCHAR(500) NOT NULL COMMENT '璋冩暣鍘熷洜',
+  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (id),
+  UNIQUE KEY uk_holiday_vehicle_adjustment (year, flow_date),
+  KEY idx_holiday_vehicle_adjustment_date (flow_date)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='寰�骞村浗鐪侀亾杞︽祦閲忚皟鏁�';
+
 -- 瀹㈣繍绯绘暟閰嶇疆
 DROP TABLE IF EXISTS holiday_passenger_coefficient;
 CREATE TABLE holiday_passenger_coefficient (

--
Gitblit v1.9.1