From 54e10aee11aa4a10926df02782ca07d41eeb9b98 Mon Sep 17 00:00:00 2001
From: xyc <jc_xiong@hotmail.com>
Date: 星期二, 06 十月 2026 16:19:07 +0800
Subject: [PATCH] fix(holiday): 加大折线图纵向间距并同步 Word 尺寸

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

diff --git a/docs/sql_holiday_vehicle_adjustment_migration.sql b/docs/sql_holiday_vehicle_adjustment_migration.sql
new file mode 100644
index 0000000..3c98eb6
--- /dev/null
+++ b/docs/sql_holiday_vehicle_adjustment_migration.sql
@@ -0,0 +1,14 @@
+-- Add the historical national/provincial road adjustment table.
+-- Run against the traffic_audit database on upgrade.
+CREATE TABLE IF NOT EXISTS holiday_vehicle_adjustment (
+  id BIGINT NOT NULL AUTO_INCREMENT,
+  year INT NOT NULL COMMENT 'year',
+  flow_date DATE NOT NULL COMMENT 'holiday date',
+  adjusted_value DECIMAL(30,15) NOT NULL COMMENT 'adjusted national/provincial vehicle flow (10k vehicle trips)',
+  reason VARCHAR(500) NOT NULL COMMENT 'adjustment reason',
+  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='historical national/provincial vehicle flow adjustments';

--
Gitblit v1.9.1