From 639b53a3caae5c338a7735f34485dcfc590d5d24 Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期五, 09 十月 2026 08:58:56 +0800
Subject: [PATCH] docs(汇总大表): 查证既有拍板——同比以母版缓存为准(F8/Q1)、扩列按月按需(F10)，并修正 M0 规格相冲表述

---
 deploy-templates/db/sql_holiday.sql |   13 +++++++++++++
 1 files changed, 13 insertions(+), 0 deletions(-)

diff --git a/deploy-templates/db/sql_holiday.sql b/deploy-templates/db/sql_holiday.sql
index a2b6b59..6d80576 100644
--- a/deploy-templates/db/sql_holiday.sql
+++ b/deploy-templates/db/sql_holiday.sql
@@ -42,6 +42,19 @@
   KEY idx_holiday_vehicle_date (flow_date)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
 
+CREATE TABLE IF NOT EXISTS holiday_vehicle_adjustment (
+  id BIGINT NOT NULL AUTO_INCREMENT,
+  year INT NOT NULL,
+  flow_date DATE NOT NULL,
+  adjusted_value DECIMAL(30,15) NOT NULL,
+  reason VARCHAR(500) NOT NULL,
+  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;
+
 CREATE TABLE IF NOT EXISTS holiday_passenger_coefficient (
   id BIGINT NOT NULL AUTO_INCREMENT,
   year INT NOT NULL,

--
Gitblit v1.9.1