From 797f03be4fe1bd1f83072f5ca25909f4d2bd4b56 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期一, 12 十月 2026 13:18:53 +0800 Subject: [PATCH] fix(城市客运): 公交/出租导入改按表头名定位列，兼容同事版少列模板 待验收 --- 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