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/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