

-- 0表示每周工作日的规则，1表示假期，2表示调休导致的当天上班，3表示调休导致的当前放假


INSERT INTO WORKCAL_TYPE(ID,NAME) VALUES(1,'默认');


INSERT INTO WORKCAL_RULE(ID,YEAR,WEEK,NAME,STATUS,TYPE_ID) VALUES(1,2014,2,'周一',0,1);
INSERT INTO WORKCAL_RULE(ID,YEAR,WEEK,NAME,STATUS,TYPE_ID) VALUES(2,2014,3,'周二',0,1);
INSERT INTO WORKCAL_RULE(ID,YEAR,WEEK,NAME,STATUS,TYPE_ID) VALUES(3,2014,4,'周三',0,1);
INSERT INTO WORKCAL_RULE(ID,YEAR,WEEK,NAME,STATUS,TYPE_ID) VALUES(4,2014,5,'周四',0,1);
INSERT INTO WORKCAL_RULE(ID,YEAR,WEEK,NAME,STATUS,TYPE_ID) VALUES(5,2014,6,'周五',0,1);


INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(1,0,'9:00','12:00',1);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(2,1,'13:00','18:00',1);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(3,0,'9:00','12:00',2);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(4,1,'13:00','18:00',2);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(5,0,'9:00','12:00',3);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(6,1,'13:00','18:00',3);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(7,0,'9:00','12:00',4);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(8,1,'13:00','18:00',4);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(9,0,'9:00','12:00',5);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(10,1,'13:00','18:00',5);


INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(11,'元旦',      2014,'2014-01-01 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(12,'春节调休',  2014,'2014-01-26 00:00:00',2,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(13,'春节',      2014,'2014-01-31 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(14,'春节',      2014,'2014-02-01 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(15,'春节',      2014,'2014-02-02 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(16,'春节',      2014,'2014-02-03 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(17,'春节',      2014,'2014-02-04 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(18,'春节',      2014,'2014-02-05 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(19,'春节',      2014,'2014-02-06 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(20,'春节调休',  2014,'2014-02-08 00:00:00',2,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(21,'清明节',    2014,'2014-04-05 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(22,'清明节补休',2014,'2014-04-07 00:00:00',3,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(23,'劳动节',    2014,'2014-05-01 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(24,'劳动节',    2014,'2014-05-02 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(25,'劳动节',    2014,'2014-05-03 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(26,'劳动节调休',2014,'2014-05-04 00:00:00',2,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(27,'端午节',    2014,'2014-06-02 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(28,'中秋节',    2014,'2014-06-02 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(29,'国庆节调休',2014,'2014-09-28 00:00:00',2,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(30,'国庆节',    2014,'2014-10-01 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(31,'国庆节',    2014,'2014-10-02 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(32,'国庆节',    2014,'2014-10-03 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(33,'国庆节',    2014,'2014-10-04 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(34,'国庆节',    2014,'2014-10-05 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(35,'国庆节',    2014,'2014-10-06 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(36,'国庆节',    2014,'2014-10-07 00:00:00',1,1);
INSERT INTO WORKCAL_RULE(ID,NAME,YEAR,WORK_DATE,STATUS,TYPE_ID) VALUES(37,'国庆节调休',2014,'2014-10-11 00:00:00',2,1);


INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(11,0,'9:00','12:00',12);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(12,1,'13:00','18:00',12);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(13,0,'9:00','12:00',20);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(14,1,'13:00','18:00',20);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(15,0,'9:00','12:00',26);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(16,1,'13:00','18:00',26);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(17,0,'9:00','12:00',29);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(18,1,'13:00','18:00',29);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(19,0,'9:00','12:00',37);
INSERT INTO WORKCAL_PART(ID,SHIFT,START_TIME,END_TIME,RULE_ID) VALUES(20,1,'13:00','18:00',37);

