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 关机快照 --- docs/sql_holiday_previous_day_migration.sql | 12 ++++++++++-- 1 files changed, 10 insertions(+), 2 deletions(-) diff --git a/docs/sql_holiday_previous_day_migration.sql b/docs/sql_holiday_previous_day_migration.sql index c2c1de9..3fcb16c 100644 --- a/docs/sql_holiday_previous_day_migration.sql +++ b/docs/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