| | |
|---|
| | | -- 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()); |
|---|
