2021年全日期sql（内含工作日，休息日分类）

程序员文章站 2022-05-18 16:55:09
...
话不多说，直接上代码
/*
Navicat MySQL Data Transfer

Source Server         : Rain
Source Server Version : 50644
Source Host           : localhost:3306
Source Database       : lulu

Target Server Type    : MYSQL
Target Server Version : 50644
File Encoding         : 65001

Date: 2021-07-14 16:52:44
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for day
-- ----------------------------
DROP TABLE IF EXISTS `day`;
CREATE TABLE `day` (
  `day` varchar(255) NOT NULL,
  `describe` varchar(255) DEFAULT NULL,
  `code` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`day`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of day
-- ----------------------------
INSERT INTO `day` VALUES ('2021-01-01', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-01-02', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-01-03', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-01-04', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-05', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-06', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-07', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-08', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-09', '休息日', '3');
INSERT INTO `day` VALUES ('2021-01-10', '休息日', '3');
INSERT INTO `day` VALUES ('2021-01-11', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-12', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-13', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-14', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-15', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-16', '休息日', '3');
INSERT INTO `day` VALUES ('2021-01-17', '休息日', '3');
INSERT INTO `day` VALUES ('2021-01-18', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-19', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-20', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-21', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-22', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-23', '休息日', '3');
INSERT INTO `day` VALUES ('2021-01-24', '休息日', '3');
INSERT INTO `day` VALUES ('2021-01-25', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-26', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-27', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-28', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-29', '工作日', '1');
INSERT INTO `day` VALUES ('2021-01-30', '休息日', '3');
INSERT INTO `day` VALUES ('2021-01-31', '休息日', '3');
INSERT INTO `day` VALUES ('2021-02-01', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-02', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-03', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-04', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-05', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-06', '休息日', '3');
INSERT INTO `day` VALUES ('2021-02-07', '休息日加班', '4');
INSERT INTO `day` VALUES ('2021-02-08', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-09', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-10', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-11', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-12', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-13', '休息日', '3');
INSERT INTO `day` VALUES ('2021-02-14', '休息日', '3');
INSERT INTO `day` VALUES ('2021-02-15', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-16', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-17', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-18', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-19', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-20', '休息日加班', '4');
INSERT INTO `day` VALUES ('2021-02-21', '休息日', '3');
INSERT INTO `day` VALUES ('2021-02-22', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-23', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-24', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-25', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-26', '工作日', '1');
INSERT INTO `day` VALUES ('2021-02-27', '休息日', '3');
INSERT INTO `day` VALUES ('2021-02-28', '休息日', '3');
INSERT INTO `day` VALUES ('2021-03-01', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-02', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-03', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-04', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-05', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-06', '休息日', '3');
INSERT INTO `day` VALUES ('2021-03-07', '休息日', '3');
INSERT INTO `day` VALUES ('2021-03-08', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-09', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-10', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-11', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-12', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-13', '休息日', '3');
INSERT INTO `day` VALUES ('2021-03-14', '休息日', '3');
INSERT INTO `day` VALUES ('2021-03-15', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-16', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-17', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-18', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-19', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-20', '休息日', '3');
INSERT INTO `day` VALUES ('2021-03-21', '休息日', '3');
INSERT INTO `day` VALUES ('2021-03-22', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-23', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-24', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-25', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-26', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-27', '休息日', '3');
INSERT INTO `day` VALUES ('2021-03-28', '休息日', '3');
INSERT INTO `day` VALUES ('2021-03-29', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-30', '工作日', '1');
INSERT INTO `day` VALUES ('2021-03-31', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-01', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-02', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-03', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-04-04', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-04-05', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-04-06', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-07', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-08', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-09', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-10', '休息日', '3');
INSERT INTO `day` VALUES ('2021-04-11', '休息日', '3');
INSERT INTO `day` VALUES ('2021-04-12', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-13', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-14', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-15', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-16', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-17', '休息日', '3');
INSERT INTO `day` VALUES ('2021-04-18', '休息日', '3');
INSERT INTO `day` VALUES ('2021-04-19', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-20', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-21', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-22', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-23', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-24', '休息日', '3');
INSERT INTO `day` VALUES ('2021-04-25', '休息日加班', '4');
INSERT INTO `day` VALUES ('2021-04-26', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-27', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-28', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-29', '工作日', '1');
INSERT INTO `day` VALUES ('2021-04-30', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-01', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-05-02', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-05-03', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-05-04', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-05-05', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-05-06', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-07', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-08', '休息日加班', '4');
INSERT INTO `day` VALUES ('2021-05-09', '休息日', '3');
INSERT INTO `day` VALUES ('2021-05-10', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-11', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-12', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-13', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-14', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-15', '休息日', '3');
INSERT INTO `day` VALUES ('2021-05-16', '休息日', '3');
INSERT INTO `day` VALUES ('2021-05-17', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-18', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-19', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-20', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-21', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-22', '休息日', '3');
INSERT INTO `day` VALUES ('2021-05-23', '休息日', '3');
INSERT INTO `day` VALUES ('2021-05-24', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-25', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-26', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-27', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-28', '工作日', '1');
INSERT INTO `day` VALUES ('2021-05-29', '休息日', '3');
INSERT INTO `day` VALUES ('2021-05-30', '休息日', '3');
INSERT INTO `day` VALUES ('2021-05-31', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-01', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-02', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-03', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-04', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-05', '休息日', '3');
INSERT INTO `day` VALUES ('2021-06-06', '休息日', '3');
INSERT INTO `day` VALUES ('2021-06-07', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-08', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-09', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-10', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-11', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-12', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-06-13', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-06-14', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-06-15', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-16', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-17', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-18', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-19', '休息日', '3');
INSERT INTO `day` VALUES ('2021-06-20', '休息日', '3');
INSERT INTO `day` VALUES ('2021-06-21', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-22', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-23', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-24', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-25', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-26', '休息日', '3');
INSERT INTO `day` VALUES ('2021-06-27', '休息日', '3');
INSERT INTO `day` VALUES ('2021-06-28', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-29', '工作日', '1');
INSERT INTO `day` VALUES ('2021-06-30', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-01', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-02', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-03', '休息日', '3');
INSERT INTO `day` VALUES ('2021-07-04', '休息日', '3');
INSERT INTO `day` VALUES ('2021-07-05', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-06', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-07', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-08', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-09', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-10', '休息日', '3');
INSERT INTO `day` VALUES ('2021-07-11', '休息日', '3');
INSERT INTO `day` VALUES ('2021-07-12', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-13', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-14', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-15', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-16', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-17', '休息日', '3');
INSERT INTO `day` VALUES ('2021-07-18', '休息日', '3');
INSERT INTO `day` VALUES ('2021-07-19', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-20', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-21', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-22', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-23', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-24', '休息日', '3');
INSERT INTO `day` VALUES ('2021-07-25', '休息日', '3');
INSERT INTO `day` VALUES ('2021-07-26', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-27', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-28', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-29', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-30', '工作日', '1');
INSERT INTO `day` VALUES ('2021-07-31', '休息日', '3');
INSERT INTO `day` VALUES ('2021-08-01', '休息日', '3');
INSERT INTO `day` VALUES ('2021-08-02', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-03', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-04', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-05', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-06', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-07', '休息日', '3');
INSERT INTO `day` VALUES ('2021-08-08', '休息日', '3');
INSERT INTO `day` VALUES ('2021-08-09', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-10', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-11', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-12', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-13', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-14', '休息日', '3');
INSERT INTO `day` VALUES ('2021-08-15', '休息日', '3');
INSERT INTO `day` VALUES ('2021-08-16', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-17', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-18', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-19', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-20', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-21', '休息日', '3');
INSERT INTO `day` VALUES ('2021-08-22', '休息日', '3');
INSERT INTO `day` VALUES ('2021-08-23', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-24', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-25', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-26', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-27', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-28', '休息日', '3');
INSERT INTO `day` VALUES ('2021-08-29', '休息日', '3');
INSERT INTO `day` VALUES ('2021-08-30', '工作日', '1');
INSERT INTO `day` VALUES ('2021-08-31', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-01', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-02', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-03', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-04', '休息日', '3');
INSERT INTO `day` VALUES ('2021-09-05', '休息日', '3');
INSERT INTO `day` VALUES ('2021-09-06', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-07', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-08', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-09', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-10', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-11', '休息日', '3');
INSERT INTO `day` VALUES ('2021-09-12', '休息日', '3');
INSERT INTO `day` VALUES ('2021-09-13', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-14', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-15', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-16', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-17', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-18', '休息日加班', '4');
INSERT INTO `day` VALUES ('2021-09-19', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-09-20', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-09-21', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-09-22', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-23', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-24', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-25', '休息日', '3');
INSERT INTO `day` VALUES ('2021-09-26', '休息日加班', '4');
INSERT INTO `day` VALUES ('2021-09-27', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-28', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-29', '工作日', '1');
INSERT INTO `day` VALUES ('2021-09-30', '工作日', '1');
INSERT INTO `day` VALUES ('2021-10-01', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-10-02', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-10-03', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-10-04', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-10-05', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-10-06', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-10-07', '法定节假日', '2');
INSERT INTO `day` VALUES ('2021-10-08', '工作日', '1');
INSERT INTO `day` VALUES ('2021-10-09', '休息日加班', '4');
INSERT INTO `day` VALUES ('2021-10-10', '休息日', '3');
INSERT INTO `day` VALUES ('2021-10-11', '工作日', '1');
INSERT INTO `day` VALUES ('2021-10-12', '工作日', '1');
INSERT INTO `day` VALUES ('2021-10-13', '工作日', '1');
INSERT INTO `day` VALUES ('2021-10-14', '工作日', '1');
INSERT INTO `day` VALUES ('2021-10-15', '工作日', '1');
INSERT INTO `day` VALUES ('2021-10-16', '休息日', '3');
INSERT INTO `day` VALUES ('2021-10-17', '休息日', '3');
INSERT INTO `day` VALUES ('2021-10-18', '工作日', '1');
INSERT INTO `day` VALUES ('2021-10-19', '工作日', '1');
INSERT INTO `day` VALUES ('2021-10-20', '工作日', '1');
INSERT INTO `day` VALUES ('2021-10-21', '工作日', '1');
INSERT INTO `day` VALUES ('2021-10-22', '工作日', '1');
INSERT INTO `day` VALUES ('2021-10-23', '休息日', '3');
INSERT INTO `day` VALUES ('2021-10-24', '休息日', '3');
INSERT INTO `day` VALUES ('2021-10-25', '工作日', '1');
INSERT INTO `day` VALUES ('2021-10-26', '工作日', '1');
INSERT INTO `day` VALUES ('2021-10-27', '工作日', '1');
INSERT INTO `day` VALUES ('2021-10-28', '工作日', '1');
INSERT INTO `day` VALUES ('2021-10-29', '工作日', '1');
INSERT INTO `day` VALUES ('2021-10-30', '休息日', '3');
INSERT INTO `day` VALUES ('2021-10-31', '休息日', '3');
INSERT INTO `day` VALUES ('2021-11-01', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-02', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-03', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-04', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-05', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-06', '休息日', '3');
INSERT INTO `day` VALUES ('2021-11-07', '休息日', '3');
INSERT INTO `day` VALUES ('2021-11-08', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-09', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-10', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-11', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-12', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-13', '休息日', '3');
INSERT INTO `day` VALUES ('2021-11-14', '休息日', '3');
INSERT INTO `day` VALUES ('2021-11-15', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-16', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-17', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-18', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-19', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-20', '休息日', '3');
INSERT INTO `day` VALUES ('2021-11-21', '休息日', '3');
INSERT INTO `day` VALUES ('2021-11-22', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-23', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-24', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-25', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-26', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-27', '休息日', '3');
INSERT INTO `day` VALUES ('2021-11-28', '休息日', '3');
INSERT INTO `day` VALUES ('2021-11-29', '工作日', '1');
INSERT INTO `day` VALUES ('2021-11-30', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-01', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-02', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-03', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-04', '休息日', '3');
INSERT INTO `day` VALUES ('2021-12-05', '休息日', '3');
INSERT INTO `day` VALUES ('2021-12-06', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-07', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-08', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-09', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-10', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-11', '休息日', '3');
INSERT INTO `day` VALUES ('2021-12-12', '休息日', '3');
INSERT INTO `day` VALUES ('2021-12-13', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-14', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-15', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-16', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-17', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-18', '休息日', '3');
INSERT INTO `day` VALUES ('2021-12-19', '休息日', '3');
INSERT INTO `day` VALUES ('2021-12-20', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-21', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-22', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-23', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-24', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-25', '休息日', '3');
INSERT INTO `day` VALUES ('2021-12-26', '休息日', '3');
INSERT INTO `day` VALUES ('2021-12-27', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-28', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-29', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-30', '工作日', '1');
INSERT INTO `day` VALUES ('2021-12-31', '工作日', '1');