From 9b56330d694ef2082fa703c1062cad8ada3332f9 Mon Sep 17 00:00:00 2001 From: xyc <jc_xiong@hotmail.com> Date: 星期三, 07 十月 2026 00:22:29 +0800 Subject: [PATCH] docs(交接): 添加 10-07 关机快照 --- 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