From b425da0611b39f20fc868645c59e17f72b70d148 Mon Sep 17 00:00:00 2001 From: xyc <jc_xiong@hotmail.com> Date: 星期二, 06 十月 2026 02:38:32 +0800 Subject: [PATCH] feat(holiday): 调整弹窗按日期显示国省道调整前值 --- deploy-templates/db/sql_holiday.sql | 14 ++++++++++++++ 1 files changed, 14 insertions(+), 0 deletions(-) diff --git a/deploy-templates/db/sql_holiday.sql b/deploy-templates/db/sql_holiday.sql index ca39066..6d80576 100644 --- a/deploy-templates/db/sql_holiday.sql +++ b/deploy-templates/db/sql_holiday.sql @@ -4,6 +4,7 @@ year INT NOT NULL, holiday_type VARCHAR(32) NOT NULL, holiday_date DATE NOT NULL, + -- 0 is the configured previous day; normal holiday days are 1..N. day_index INT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, @@ -41,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