2025年节假日sql脚本

```sql
CREATE TABLE `pr_holiday` (
  `holiday_id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `data` date DEFAULT NULL COMMENT '日期',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '状态',
  `msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`holiday_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1098 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='节假日';
```

INSERT INTO `pr_holiday` (`holiday_id`, `data`, `status`, `msg`) VALUES
(null, '2025-01-01', '2', '法定节假日(元旦)'),
(null, '2025-01-02', '0', '工作日'),
(null, '2025-01-03', '0', '工作日'),
(null, '2025-01-04', '1', '周末'),
(null, '2025-01-05', '1', '周末'),
(null, '2025-01-06', '0', '工作日'),
(null, '2025-01-07', '0', '工作日'),
(null, '2025-01-08', '0', '工作日'),
(null, '2025-01-09', '0', '工作日'),
(null, '2025-01-10', '0', '工作日'),
(null, '2025-01-11', '1', '周末'),
(null, '2025-01-12', '1', '周末'),
(null, '2025-01-13', '0', '工作日'),
(null, '2025-01-14', '0', '工作日'),
(null, '2025-01-15', '0', '工作日'),
(null, '2025-01-16', '0', '工作日'),
(null, '2025-01-17', '0', '工作日'),
(null, '2025-01-18', '1', '周末'),
(null, '2025-01-19', '1', '周末'),
(null, '2025-01-20', '0', '工作日'),
(null, '2025-01-21', '0', '工作日'),
(null, '2025-01-22', '0', '工作日'),
(null, '2025-01-23', '0', '工作日'),
(null, '2025-01-24', '0', '工作日'),
(null, '2025-01-25', '1', '周末'),
(null, '2025-01-26', '0', '法定节假日(春节前补班)'),
(null, '2025-01-27', '0', '工作日'),
(null, '2025-01-28', '2', '法定节假日(除夕)'),
(null, '2025-01-29', '2', '法定节假日(春节)'),
(null, '2025-01-30', '2', '法定节假日(初二)'),
(null, '2025-01-31', '2', '法定节假日(初三)');



INSERT INTO `pr_holiday` (`holiday_id`, `data`, `status`, `msg`) VALUES
(null, '2025-02-01', '2', '法定节假日(春节假期)'),
(null, '2025-02-02', '2', '法定节假日(春节假期)'),
(null, '2025-02-03', '2', '法定节假日(春节假期)'),
(null, '2025-02-04', '2', '法定节假日(春节假期)'),
(null, '2025-02-05', '0', '工作日'),
(null, '2025-02-06', '0', '工作日'),
(null, '2025-02-07', '0', '工作日'),
(null, '2025-02-08', '0', '补班日'),
(null, '2025-02-09', '1', '周末'),
(null, '2025-02-10', '0', '工作日'),
(null, '2025-02-11', '0', '工作日'),
(null, '2025-02-12', '0', '工作日'),
(null, '2025-02-13', '0', '工作日'),
(null, '2025-02-14', '0', '工作日'),
(null, '2025-02-15', '1', '周末'),
(null, '2025-02-16', '1', '周末'),
(null, '2025-02-17', '0', '工作日'),
(null, '2025-02-18', '0', '工作日'),
(null, '2025-02-19', '0', '工作日'),
(null, '2025-02-20', '0', '工作日'),
(null, '2025-02-21', '0', '工作日'),
(null, '2025-02-22', '1', '周末'),
(null, '2025-02-23', '1', '周末'),
(null, '2025-02-24', '0', '工作日'),
(null, '2025-02-25', '0', '工作日'),
(null, '2025-02-26', '0', '工作日'),
(null, '2025-02-27', '0', '工作日'),
(null, '2025-02-28', '0', '工作日');


-- 3月
INSERT INTO `pr_holiday` (`holiday_id`, `data`, `status`, `msg`) VALUES
(null, '2025-03-01', '1', '周末'),
(null, '2025-03-02', '1', '周末'),
(null, '2025-03-03', '0', '工作日'),
(null, '2025-03-04', '0', '工作日'),
(null, '2025-03-05', '0', '工作日'),
(null, '2025-03-06', '0', '工作日'),
(null, '2025-03-07', '0', '工作日'),
(null, '2025-03-08', '1', '周末'),
(null, '2025-03-09', '1', '周末'),
(null, '2025-03-10', '0', '工作日'),
(null, '2025-03-11', '0', '工作日'),
(null, '2025-03-12', '0', '工作日'),
(null, '2025-03-13', '0', '工作日'),
(null, '2025-03-14', '0', '工作日'),
(null, '2025-03-15', '1', '周末'),
(null, '2025-03-16', '1', '周末'),
(null, '2025-03-17', '0', '工作日'),
(null, '2025-03-18', '0', '工作日'),
(null, '2025-03-19', '0', '工作日'),
(null, '2025-03-20', '0', '工作日'),
(null, '2025-03-21', '0', '工作日'),
(null, '2025-03-22', '1', '周末'),
(null, '2025-03-23', '1', '周末'),
(null, '2025-03-24', '0', '工作日'),
(null, '2025-03-25', '0', '工作日'),
(null, '2025-03-26', '0', '工作日'),
(null, '2025-03-27', '0', '工作日'),
(null, '2025-03-28', '0', '工作日'),
(null, '2025-03-29', '1', '周末'),
(null, '2025-03-30', '1', '周末'),
(null, '2025-03-31', '0', '工作日');

-- 4月
INSERT INTO `pr_holiday` (`holiday_id`, `data`, `status`, `msg`) VALUES
(null, '2025-04-01', '0', '工作日'),
(null, '2025-04-02', '0', '工作日'),
(null, '2025-04-03', '0', '工作日'),
(null, '2025-04-04', '2', '清明节'),
(null, '2025-04-05', '2', '清明节'),
(null, '2025-04-06', '2', '清明节'),
(null, '2025-04-07', '0', '工作日'),
(null, '2025-04-08', '0', '工作日'),
(null, '2025-04-09', '0', '工作日'),
(null, '2025-04-10', '0', '工作日'),
(null, '2025-04-11', '0', '工作日'),
(null, '2025-04-12', '1', '周末'),
(null, '2025-04-13', '1', '周末'),
(null, '2025-04-14', '0', '工作日'),
(null, '2025-04-15', '0', '工作日'),
(null, '2025-04-16', '0', '工作日'),
(null, '2025-04-17', '0', '工作日'),
(null, '2025-04-18', '0', '工作日'),
(null, '2025-04-19', '1', '周末'),
(null, '2025-04-20', '1', '周末'),
(null, '2025-04-21', '0', '工作日'),
(null, '2025-04-22', '0', '工作日'),
(null, '2025-04-23', '0', '工作日'),
(null, '2025-04-24', '0', '工作日'),
(null, '2025-04-25', '0', '工作日'),
(null, '2025-04-26', '1', '周末'),
(null, '2025-04-27', '0', '补班'),
(null, '2025-04-28', '0', '工作日'),
(null, '2025-04-29', '0', '工作日'),
(null, '2025-04-30', '0', '工作日');

-- 5月
INSERT INTO `pr_holiday` (`holiday_id`, `data`, `status`, `msg`) VALUES
(null, '2025-05-01', '2', '劳动节'),
(null, '2025-05-02', '2', '劳动节'),
(null, '2025-05-03', '2', '劳动节'),
(null, '2025-05-04', '2', '劳动节'),
(null, '2025-05-05', '2', '劳动节'),
(null, '2025-05-06', '0', '工作日'),
(null, '2025-05-07', '0', '工作日'),
(null, '2025-05-08', '0', '工作日'),
(null, '2025-05-09', '0', '工作日'),
(null, '2025-05-10', '1', '周末'),
(null, '2025-05-11', '1', '周末'),
(null, '2025-05-12', '0', '工作日'),
(null, '2025-05-13', '0', '工作日'),
(null, '2025-05-14', '0', '工作日'),
(null, '2025-05-15', '0', '工作日'),
(null, '2025-05-16', '0', '工作日'),
(null, '2025-05-17', '1', '周末'),
(null, '2025-05-18', '1', '周末'),
(null, '2025-05-19', '0', '工作日'),
(null, '2025-05-20', '0', '工作日'),
(null, '2025-05-21', '0', '工作日'),
(null, '2025-05-22', '0', '工作日'),
(null, '2025-05-23', '0', '工作日'),
(null, '2025-05-24', '1', '周末'),
(null, '2025-05-25', '1', '周末'),
(null, '2025-05-26', '0', '工作日'),
(null, '2025-05-27', '0', '工作日'),
(null, '2025-05-28', '0', '工作日'),
(null, '2025-05-29', '0', '工作日'),
(null, '2025-05-30', '0', '工作日'),
(null, '2025-05-31', '1', '端午');

-- 6月
INSERT INTO `pr_holiday` (`holiday_id`, `data`, `status`, `msg`) VALUES
(null, '2025-06-01', '2', '端午'),
(null, '2025-06-02', '2', '端午'),
(null, '2025-06-03', '0', '工作日'),
(null, '2025-06-04', '0', '工作日'),
(null, '2025-06-05', '0', '工作日'),
(null, '2025-06-06', '0', '工作日'),
(null, '2025-06-07', '1', '周末'),
(null, '2025-06-08', '1', '周末'),
(null, '2025-06-09', '0', '工作日'),
(null, '2025-06-10', '0', '工作日'),
(null, '2025-06-11', '0', '工作日'),
(null, '2025-06-12', '0', '工作日'),
(null, '2025-06-13', '0', '工作日'),
(null, '2025-06-14', '1', '周末'),
(null, '2025-06-15', '1', '周末'),
(null, '2025-06-16', '0', '工作日'),
(null, '2025-06-17', '0', '工作日'),
(null, '2025-06-18', '0', '工作日'),
(null, '2025-06-19', '0', '工作日'),
(null, '2025-06-20', '0', '工作日'),
(null, '2025-06-21', '1', '周末'),
(null, '2025-06-22', '1', '周末'),
(null, '2025-06-23', '0', '工作日'),
(null, '2025-06-24', '0', '工作日'),
(null, '2025-06-25', '0', '工作日'),
(null, '2025-06-26', '0', '工作日'),
(null, '2025-06-27', '0', '工作日'),
(null, '2025-06-28', '1', '周末'),
(null, '2025-06-29', '1', '周末'),
(null, '2025-06-30', '0', '工作日');

-- 7月
INSERT INTO `pr_holiday` (`holiday_id`, `data`, `status`, `msg`) VALUES
(null, '2025-07-01', '0', '工作日'),
(null, '2025-07-02', '0', '工作日'),
(null, '2025-07-03', '0', '工作日'),
(null, '2025-07-04', '0', '工作日'),
(null, '2025-07-05', '1', '周末'),
(null, '2025-07-06', '1', '周末'),
(null, '2025-07-07', '0', '工作日'),
(null, '2025-07-08', '0', '工作日'),
(null, '2025-07-09', '0', '工作日'),
(null, '2025-07-10', '0', '工作日'),
(null, '2025-07-11', '0', '工作日'),
(null, '2025-07-12', '1', '周末'),
(null, '2025-07-13', '1', '周末'),
(null, '2025-07-14', '0', '工作日'),
(null, '2025-07-15', '0', '工作日'),
(null, '2025-07-16', '0', '工作日'),
(null, '2025-07-17', '0', '工作日'),
(null, '2025-07-18', '0', '工作日'),
(null, '2025-07-19', '1', '周末'),
(null, '2025-07-20', '1', '周末'),
(null, '2025-07-21', '0', '工作日'),
(null, '2025-07-22', '0', '工作日'),
(null, '2025-07-23', '0', '工作日'),
(null, '2025-07-24', '0', '工作日'),
(null, '2025-07-25', '0', '工作日'),
(null, '2025-07-26', '1', '周末'),
(null, '2025-07-27', '1', '周末'),
(null, '2025-07-28', '0', '工作日'),
(null, '2025-07-29', '0', '工作日'),
(null, '2025-07-30', '0', '工作日'),
(null, '2025-07-31', '0', '工作日');

-- 8月
INSERT INTO `pr_holiday` (`data`, `status`, `msg`) VALUES
('2025-08-01', '0', '工作日'),
('2025-08-02', '1', '周末'),
('2025-08-03', '1', '周末'),
('2025-08-04', '0', '工作日'),
('2025-08-05', '0', '工作日'),
('2025-08-06', '0', '工作日'),
('2025-08-07', '0', '工作日'),
('2025-08-08', '0', '工作日'),
('2025-08-09', '1', '周末'),
('2025-08-10', '1', '周末'),
('2025-08-11', '0', '工作日'),
('2025-08-12', '0', '工作日'),
('2025-08-13', '0', '工作日'),
('2025-08-14', '0', '工作日'),
('2025-08-15', '0', '工作日'),
('2025-08-16', '1', '周末'),
('2025-08-17', '1', '周末'),
('2025-08-18', '0', '工作日'),
('2025-08-19', '0', '工作日'),
('2025-08-20', '0', '工作日'),
('2025-08-21', '0', '工作日'),
('2025-08-22', '0', '工作日'),
('2025-08-23', '1', '周末'),
('2025-08-24', '1', '周末'),
('2025-08-25', '0', '工作日'),
('2025-08-26', '0', '工作日'),
('2025-08-27', '0', '工作日'),
('2025-08-28', '0', '工作日'),
('2025-08-29', '0', '工作日'),
('2025-08-30', '1', '周末'),
('2025-08-31', '1', '周末');

-- 9月
INSERT INTO `pr_holiday` (`data`, `status`, `msg`) VALUES
('2025-09-01', '0', '工作日'),
('2025-09-02', '0', '工作日'),
('2025-09-03', '0', '工作日'),
('2025-09-04', '0', '工作日'),
('2025-09-05', '0', '工作日'),
('2025-09-06', '1', '周末'),
('2025-09-07', '1', '周末'),
('2025-09-08', '0', '工作日'),
('2025-09-09', '0', '工作日'),
('2025-09-10', '0', '工作日'),
('2025-09-11', '0', '工作日'),
('2025-09-12', '0', '工作日'),
('2025-09-13', '1', '周末'),
('2025-09-14', '1', '周末'),
('2025-09-15', '0', '工作日'),
('2025-09-16', '0', '工作日'),
('2025-09-17', '0', '工作日'),
('2025-09-18', '0', '工作日'),
('2025-09-19', '0', '工作日'),
('2025-09-20', '1', '周末'),
('2025-09-21', '1', '周末'),
('2025-09-22', '0', '工作日'),
('2025-09-23', '0', '工作日'),
('2025-09-24', '0', '工作日'),
('2025-09-25', '0', '工作日'),
('2025-09-26', '0', '工作日'),
('2025-09-27', '1', '周末'),
('2025-09-28', '0', '补班'),
('2025-09-29', '0', '工作日'),
('2025-09-30', '0', '工作日');

-- 10月
INSERT INTO `pr_holiday` (`data`, `status`, `msg`) VALUES
('2025-10-01', '2', '法定节假日(国庆节)'),
('2025-10-02', '2', '法定节假日(国庆节)'),
('2025-10-03', '2', '法定节假日(国庆节)'),
('2025-10-04', '2', '法定节假日(国庆节)'),
('2025-10-05', '2', '法定节假日(国庆节)'),
('2025-10-06', '2', '法定节假日(国庆节)'),
('2025-10-07', '2', '法定节假日(国庆节)'),
('2025-10-08', '2', '法定节假日(国庆节)'),
('2025-10-09', '0', '工作日'),
('2025-10-10', '0', '工作日'),
('2025-10-11', '0', '补班'),
('2025-10-12', '1', '周末'),
('2025-10-13', '0', '工作日'),
('2025-10-14', '0', '工作日'),
('2025-10-15', '0', '工作日'),
('2025-10-16', '0', '工作日'),
('2025-10-17', '0', '工作日'),
('2025-10-18', '1', '周末'),
('2025-10-19', '1', '周末'),
('2025-10-20', '0', '工作日'),
('2025-10-21', '0', '工作日'),
('2025-10-22', '0', '工作日'),
('2025-10-23', '0', '工作日'),
('2025-10-24', '0', '工作日'),
('2025-10-25', '1', '周末'),
('2025-10-26', '1', '周末'),
('2025-10-27', '0', '工作日'),
('2025-10-28', '0', '工作日'),
('2025-10-29', '0', '工作日'),
('2025-10-30', '0', '工作日'),
('2025-10-31', '0', '工作日');

-- 11月
INSERT INTO `pr_holiday` (`data`, `status`, `msg`) VALUES
('2025-11-01', '1', '周末'),
('2025-11-02', '1', '周末'),
('2025-11-03', '0', '工作日'),
('2025-11-04', '0', '工作日'),
('2025-11-05', '0', '工作日'),
('2025-11-06', '0', '工作日'),
('2025-11-07', '0', '工作日'),
('2025-11-08', '1', '周末'),
('2025-11-09', '1', '周末'),
('2025-11-10', '0', '工作日'),
('2025-11-11', '0', '工作日'),
('2025-11-12', '0', '工作日'),
('2025-11-13', '0', '工作日'),
('2025-11-14', '0', '工作日'),
('2025-11-15', '1', '周末'),
('2025-11-16', '1', '周末'),
('2025-11-17', '0', '工作日'),
('2025-11-18', '0', '工作日'),
('2025-11-19', '0', '工作日'),
('2025-11-20', '0', '工作日'),
('2025-11-21', '0', '工作日'),
('2025-11-22', '1', '周末'),
('2025-11-23', '1', '周末'),
('2025-11-24', '0', '工作日'),
('2025-11-25', '0', '工作日'),
('2025-11-26', '0', '工作日'),
('2025-11-27', '0', '工作日'),
('2025-11-28', '0', '工作日'),
('2025-11-29', '1', '周末'),
('2025-11-30', '1', '周末');

-- 12月
INSERT INTO `pr_holiday` (`data`, `status`, `msg`) VALUES
('2025-12-01', '0', '工作日'),
('2025-12-02', '0', '工作日'),
('2025-12-03', '0', '工作日'),
('2025-12-04', '0', '工作日'),
('2025-12-05', '0', '工作日'),
('2025-12-06', '1', '周末'),
('2025-12-07', '1', '周末'),
('2025-12-08', '0', '工作日'),
('2025-12-09', '0', '工作日'),
('2025-12-10', '0', '工作日'),
('2025-12-11', '0', '工作日'),
('2025-12-12', '0', '工作日'),
('2025-12-13', '1', '周末'),
('2025-12-14', '1', '周末'),
('2025-12-15', '0', '工作日'),
('2025-12-16', '0', '工作日'),
('2025-12-17', '0', '工作日'),
('2025-12-18', '0', '工作日'),
('2025-12-19', '0', '工作日'),
('2025-12-20', '1', '周末'),
('2025-12-21', '1', '周末'),
('2025-12-22', '0', '工作日'),
('2025-12-23', '0', '工作日'),
('2025-12-24', '0', '工作日'),
('2025-12-25', '0', '工作日'),
('2025-12-26', '0', '工作日'),
('2025-12-27', '1', '周末'),
('2025-12-28', '1', '周末'),
('2025-12-29', '0', '工作日'),
('2025-12-30', '0', '工作日'),
('2025-12-31', '0', '工作日');