From 7032f3fb2ff26256e776e04a9bc62c8fab14379a Mon Sep 17 00:00:00 2001 From: xyc <jc_xiong@hotmail.com> Date: 星期二, 06 十月 2026 02:27:35 +0800 Subject: [PATCH] fix(holiday): 调整弹窗补充车流量万辆次单位 --- docs/init.sql | 17 ++++++++++++++++- 1 files changed, 16 insertions(+), 1 deletions(-) diff --git a/docs/init.sql b/docs/init.sql index dcc9932..7d79383 100644 --- a/docs/init.sql +++ b/docs/init.sql @@ -632,7 +632,7 @@ year INT NOT NULL COMMENT '骞翠唤', holiday_type VARCHAR(32) NOT NULL COMMENT '鑺傚亣鏃ュ垎绫伙細SPRING_FESTIVAL/LABOR_DAY/NATIONAL_DAY', holiday_date DATE NOT NULL COMMENT '鑺傚亣鏃ュ叿浣撴棩鏈�', - day_index INT NOT NULL COMMENT '绗嚑鏃ワ紝浠� 1 寮�濮�', + day_index INT NOT NULL COMMENT '0=鍓嶄竴鏃ワ紝1..N=鍋囨湡绗琋鏃�', created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), @@ -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