From df37f961e9101ce2bbc22848d7d80d8170b6ffbf Mon Sep 17 00:00:00 2001
From: xyc <jc_xiong@hotmail.com>
Date: 星期二, 06 十月 2026 02:07:26 +0800
Subject: [PATCH] docs(holiday): 明确快报百分比以Excel显示值为准

---
 deploy-templates/db/sql_holiday_previous_day_migration.sql |   12 ++++++++++--
 1 files changed, 10 insertions(+), 2 deletions(-)

diff --git a/deploy-templates/db/sql_holiday_previous_day_migration.sql b/deploy-templates/db/sql_holiday_previous_day_migration.sql
index c2c1de9..3fcb16c 100644
--- a/deploy-templates/db/sql_holiday_previous_day_migration.sql
+++ b/deploy-templates/db/sql_holiday_previous_day_migration.sql
@@ -1,8 +1,16 @@
--- Add the previous-day row used by rail and civil-aviation ring-ratio calculations.
--- day_index = 0 identifies the configured previous day; normal holiday days remain 1..N.
+-- Backfill the 2019 National Day calendar and previous-day rows used by rail and civil-aviation ring-ratio calculations.
+-- day_index = 0 identifies the configured previous day; 2019 uses normal days 1..8.
 INSERT IGNORE INTO holiday_calendar
   (year, holiday_type, holiday_date, day_index, created_at, updated_at)
 VALUES
+  (2019, 'NATIONAL_DAY', '2019-10-01', 1, NOW(), NOW()),
+  (2019, 'NATIONAL_DAY', '2019-10-02', 2, NOW(), NOW()),
+  (2019, 'NATIONAL_DAY', '2019-10-03', 3, NOW(), NOW()),
+  (2019, 'NATIONAL_DAY', '2019-10-04', 4, NOW(), NOW()),
+  (2019, 'NATIONAL_DAY', '2019-10-05', 5, NOW(), NOW()),
+  (2019, 'NATIONAL_DAY', '2019-10-06', 6, NOW(), NOW()),
+  (2019, 'NATIONAL_DAY', '2019-10-07', 7, NOW(), NOW()),
+  (2019, 'NATIONAL_DAY', '2019-10-08', 8, NOW(), NOW()),
   (2024, 'NATIONAL_DAY', '2024-09-30', 0, NOW(), NOW()),
   (2025, 'NATIONAL_DAY', '2025-09-30', 0, NOW(), NOW()),
   (2026, 'NATIONAL_DAY', '2026-09-30', 0, NOW(), NOW());

--
Gitblit v1.9.1