From 8ad75d5872872b79abada58589adad0df4614db6 Mon Sep 17 00:00:00 2001
From: xyc <jc_xiong@hotmail.com>
Date: 星期三, 07 十月 2026 11:59:44 +0800
Subject: [PATCH] fix(holiday): 走势图按年度配置截取假期天数

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

diff --git a/docs/init.sql b/docs/init.sql
index 70df0b6..7d79383 100644
--- a/docs/init.sql
+++ b/docs/init.sql
@@ -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