From 3b3652e3418ccfbbd21d9f7a2d8769d09c4f18f9 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期一, 12 十月 2026 13:08:54 +0800 Subject: [PATCH] fix(汇总大表): 扩列公式克隆修正（值列相对右移、同比列重写）并落盘 9 月母版 待验收 --- deploy-templates/db/init.sql | 15 +++++++++++++++ 1 files changed, 15 insertions(+), 0 deletions(-) diff --git a/deploy-templates/db/init.sql b/deploy-templates/db/init.sql index 70df0b6..7d79383 100644 --- a/deploy-templates/db/init.sql +++ b/deploy-templates/db/init.sql @@ -673,6 +673,21 @@ KEY idx_holiday_vehicle_date (flow_date) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鑺傚亣鏃ョ患鍚堣繍杈撻潪钀ヤ笟鎬ц溅娴佹儏鍐�'; +-- 寰�骞村浗鐪侀亾杞︽祦閲忚皟鏁� +DROP TABLE IF EXISTS holiday_vehicle_adjustment; +CREATE TABLE holiday_vehicle_adjustment ( + id BIGINT NOT NULL AUTO_INCREMENT, + year INT NOT NULL COMMENT '骞翠唤', + flow_date DATE NOT NULL COMMENT '鏃ユ湡', + adjusted_value DECIMAL(30,15) NOT NULL COMMENT '璋冩暣鍚庢櫘閫氬浗鐪侀亾杞︽祦閲忥紙涓囪締娆★級', + reason VARCHAR(500) NOT NULL COMMENT '璋冩暣鍘熷洜', + 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='寰�骞村浗鐪侀亾杞︽祦閲忚皟鏁�'; + -- 瀹㈣繍绯绘暟閰嶇疆 DROP TABLE IF EXISTS holiday_passenger_coefficient; CREATE TABLE holiday_passenger_coefficient ( -- Gitblit v1.9.1