文件名称：working.sql
文件大小：49KB
文件格式：SQL
更新时间：2022-11-10 09:36:10
sql日历
CREATE TABLE `working` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date` date NOT NULL COMMENT '日期', `week` tinyint(1) DEFAULT NULL COMMENT '星期', `is_work_day` tinyint(1) DEFAULT NULL COMMENT '是否工作日（0：节假日或周六日，1：工作日）', `note` varchar(10) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`), UNIQUE KEY `tDate` (`date`) ) ENGINE=InnoDB AUTO_INCREMENT=724 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of working -- ---------------------------- INSERT INTO `working` VALUES ('1', '2018-01-01', '1', '0', '元旦'); INSERT INTO `working` VALUES ('2', '2018-01-02', '2', '1', ''); INSERT INTO `working` VALUES ('3', '2018-01-03', '3', '1', ''); INSERT INTO `working` VALUES ('4', '2018-01-04', '4', '1', ''); INSERT INTO `working` VALUES ('5', '2018-01-05', '5', '1', ''); INSERT INTO `working` VALUES ('6', '2018-01-06', '6', '0', ''); INSERT INTO `working` VALUES ('7', '2018-01-07', '7', '0', ''); INSERT INTO `working` VALUES ('8', '2018-01-08', '1', '1', ''); INSERT INTO `working` VALUES ('9', '2018-01-09', '2', '1', ''); INSERT INTO `working` VALUES ('10', '2018-01-10', '3', '1', ''); INSERT INTO `working` VALUES ('11', '2018-01-11', '4', '1', ''); INSERT INTO `working` VALUES ('12', '2018-01-12', '5', '1', ''); INSERT INTO `working` VALUES ('13', '2018-01-13', '6', '0', ''); INSERT INTO `working` VALUES ('14', '2018-01-14', '7', '0', ''); INSERT INTO `working` VALUES ('15', '2018-01-15', '1', '1', ''); INSERT INTO `working` VALUES ('16', '2018-01-16', '2', '1', ''); INSERT INTO `working` VALUES ('17', '2018-01-17', '3', '1', ''); INSERT INTO `working` VALUES ('18', '2018-01-18', '4', '1', ''); INSERT INTO `working` VALUES ('19', '2018-01-19', '5', '1', ''); INSERT INTO `working` VALUES ('20', '2018-01-20', '6', '0', ''); INSERT INTO `working` VALUES ('21', '2018-01-21', '7', '0', ''); INSERT INTO `working` VALUES ('22', '2018-01-22', '1', '1', ''); INSERT INTO `working` VALUES ('23', '2018-01-23', '2', '1', ''); INSERT INTO `working` VALUES ('24', '2018-01-24', '3', '1', ''); INSERT INTO `working` VALUES ('25', '2018-01-25', '4', '1', ''); INSERT INTO `working` VALUES ('26', '2018-01-26', '5', '1', ''); INSERT INTO `working` VALUES ('27', '2018-01-27', '6', '0', ''); INSERT INTO `working` VALUES ('28', '2018-01-28', '7', '0', ''); INSERT INTO `working` VALUES ('29', '2018-01-29', '1', '1', ''); INSERT INTO `working` VALUES ('30', '2018-01-30', '2', '1', '');