--
-- Table structure for table `scf_test`.`service_periods`
--

DROP TABLE IF EXISTS `service_periods`;
CREATE TABLE `service_periods` (
  `SERVICE_ID` int(10) default NULL,
  `PERIOD_TYPE` varchar(50) default NULL,
  `START_TIME1` time default NULL,
  `END_TIME1` time default NULL,
  `START_TIME2` time default NULL,
  `END_TIME2` time default NULL,
  `DAY_OF_WEEK` varchar(10) default NULL,
  `PERIOD_ID` int(10) NOT NULL auto_increment,
  PRIMARY KEY  (`PERIOD_ID`),
  KEY `PER_SERVICE_ID_INDEX1` (`SERVICE_ID`),
  CONSTRAINT `service_periods_ibfk_1` FOREIGN KEY (`SERVICE_ID`) REFERENCES `services` (`SERVICE_ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `scf_test`.`service_periods`
--

/*!40000 ALTER TABLE `service_periods` DISABLE KEYS */;
INSERT INTO `service_periods` VALUES   (131,'Critical Period','09:00:00','10:30:00','12:00:00','16:30:00','Mon-Fri',50);
INSERT INTO `service_periods` VALUES   (131,'Maintenance Window','00:00:00','12:00:00','00:00:00','00:00:00','Sunday',52);
INSERT INTO `service_periods` VALUES   (131,'Commitment Period','06:00:00','21:00:00','00:00:00','00:00:00','Mon-Sat',54);
INSERT INTO `service_periods` VALUES   (131,'Commitment Period','12:00:00','21:00:00','00:00:00','00:00:00','Sunday',55);
INSERT INTO `service_periods` VALUES   (131,'Commitment Period','00:00:00','00:00:00','00:00:00','00:00:00','         ',56);
INSERT INTO `service_periods` VALUES   (500,'Commitment Period','07:00:00','22:00:00','00:00:00','00:00:00','Mon-Fri',57);
INSERT INTO `service_periods` VALUES   (130,'Commitment Period','00:00:00','24:00:00','00:00:00','00:00:00','Mon-Sat',58);
INSERT INTO `service_periods` VALUES   (130,'Maintenance Window','16:00:00','16:30:00','00:00:00','00:00:00','Saturday',59);
INSERT INTO `service_periods` VALUES   (130,'Commitment Period','18:00:00','24:00:00','00:00:00','00:00:00','Sunday',60);
INSERT INTO `service_periods` VALUES   (531,'Commitment Period','07:00:00','24:00:00','00:00:00','00:00:00','Mon-Sun',61);
INSERT INTO `service_periods` VALUES   (531,'Critical Period','08:00:00','18:00:00','00:00:00','00:00:00','Mon-Fri',62);
INSERT INTO `service_periods` VALUES   (535,'Maintenance Window','10:00:00','15:00:00','00:00:00','00:00:00','Sunday',63);
INSERT INTO `service_periods` VALUES   (535,'Commitment Period','08:00:00','21:00:00','00:00:00','00:00:00','Mon-Fri',64);
INSERT INTO `service_periods` VALUES   (506,'Maintenance Window','10:00:00','15:00:00','00:00:00','00:00:00','Sunday',65);
INSERT INTO `service_periods` VALUES   (506,'Commitment Period','06:00:00','24:00:00','00:00:00','00:00:00','Monday',66);
INSERT INTO `service_periods` VALUES   (504,'Maintenance Window','02:00:00','16:00:00','00:00:00','00:00:00','Saturday',71);
INSERT INTO `service_periods` VALUES   (504,'Maintenance Window','02:00:00','11:00:00','00:00:00','00:00:00','Sunday',72);
INSERT INTO `service_periods` VALUES   (504,'Critical Period','06:00:00','12:00:00','16:00:00','21:00:00','Mon-Fri',73);
INSERT INTO `service_periods` VALUES   (506,'Commitment Period','00:00:00','24:00:00','00:00:00','00:00:00','Tuesday',74);
INSERT INTO `service_periods` VALUES   (506,'Commitment Period','00:00:00','24:00:00','00:00:00','00:00:00','Wednesday',75);
INSERT INTO `service_periods` VALUES   (506,'Commitment Period','00:00:00','24:00:00','00:00:00','00:00:00','Thursday',76);
INSERT INTO `service_periods` VALUES   (506,'Commitment Period','00:00:00','24:00:00','00:00:00','00:00:00','Friday',77);
INSERT INTO `service_periods` VALUES   (506,'Commitment Period','00:00:00','12:00:00','00:00:00','00:00:00','Saturday',78);
INSERT INTO `service_periods` VALUES   (507,'Commitment Period','08:00:00','23:00:00','00:00:00','00:00:00','Mon-Fri',79);
INSERT INTO `service_periods` VALUES   (507,'Maintenance Window','23:00:00','23:15:00','00:00:00','00:00:00','Mon-Sat',80);
INSERT INTO `service_periods` VALUES   (507,'Maintenance Window','10:00:00','15:00:00','00:00:00','00:00:00','Mon-Sun',81);
INSERT INTO `service_periods` VALUES   (511,'Commitment Period','08:00:00','21:00:00','00:00:00','00:00:00','Mon-Fri',82);
INSERT INTO `service_periods` VALUES   (511,'Maintenance Window','19:00:00','24:00:00','00:00:00','00:00:00','Friday',83);
INSERT INTO `service_periods` VALUES   (511,'Maintenance Window','00:00:00','24:00:00','00:00:00','00:00:00','Sat-Sun',84);
INSERT INTO `service_periods` VALUES   (511,'Maintenance Window','00:00:00','07:00:00','00:00:00','00:00:00','Monday',85);
INSERT INTO `service_periods` VALUES   (511,'Maintenance Window','18:00:00','24:00:00','00:00:00','00:00:00','Mon-Fri',86);
INSERT INTO `service_periods` VALUES   (540,'Commitment Period','06:00:00','24:00:00','00:00:00','00:00:00','Monday',106);
INSERT INTO `service_periods` VALUES   (540,'Commitment Period','00:00:00','06:00:00','00:00:00','00:00:00','Saturday',107);
INSERT INTO `service_periods` VALUES   (515,'Commitment Period','08:00:00','17:00:00','00:00:00','00:00:00','Mon-Fri',108);
INSERT INTO `service_periods` VALUES   (515,'Critical Period','03:00:00','08:00:00','00:00:00','00:00:00','Mon-Sat',109);
INSERT INTO `service_periods` VALUES   (541,'Commitment Period','08:00:00','18:00:00','00:00:00','00:00:00','Mon-Fri',110);
INSERT INTO `service_periods` VALUES   (541,'Maintenance Window','08:00:00','17:00:00','00:00:00','00:00:00','Sunday',111);
INSERT INTO `service_periods` VALUES   (543,'Commitment Period','06:00:00','22:30:00','00:00:00','00:00:00','Mon-Sun',112);
INSERT INTO `service_periods` VALUES   (544,'Commitment Period','08:00:00','17:00:00','00:00:00','00:00:00','Mon-Fri',113);
INSERT INTO `service_periods` VALUES   (546,'Commitment Period','07:00:00','21:00:00','00:00:00','00:00:00','Mon-Fri',114);
INSERT INTO `service_periods` VALUES   (547,'Commitment Period','06:00:00','19:30:00','00:00:00','00:00:00','Mon-Fri',115);
INSERT INTO `service_periods` VALUES   (548,'Commitment Period','08:00:00','18:00:00','00:00:00','00:00:00','Mon-Fri',116);
INSERT INTO `service_periods` VALUES   (551,'Commitment Period','08:00:00','17:30:00','00:00:00','00:00:00','Mon-Fri',119);
INSERT INTO `service_periods` VALUES   (552,'Commitment Period','07:00:00','18:30:00','00:00:00','00:00:00','Mon-Fri',120);
INSERT INTO `service_periods` VALUES   (553,'Commitment Period','08:00:00','20:00:00','00:00:00','00:00:00','Mon-Fri',121);
INSERT INTO `service_periods` VALUES   (554,'Commitment Period','00:01:00','08:00:00','00:00:00','00:00:00','Tuesday',122);
INSERT INTO `service_periods` VALUES   (554,'Commitment Period','00:01:00','08:00:00','00:00:00','00:00:00','Wednesday',123);
INSERT INTO `service_periods` VALUES   (554,'Commitment Period','00:01:00','08:00:00','00:00:00','00:00:00','Thursday',124);
INSERT INTO `service_periods` VALUES   (554,'Commitment Period','00:01:00','08:00:00','00:00:00','00:00:00','Friday',125);
INSERT INTO `service_periods` VALUES   (554,'Commitment Period','00:01:00','08:00:00','00:00:00','00:00:00','Saturday',126);
INSERT INTO `service_periods` VALUES   (555,'Commitment Period','07:00:00','23:00:00','00:00:00','00:00:00','Mon-Fri',127);
INSERT INTO `service_periods` VALUES   (556,'Commitment Period','08:00:00','21:00:00','00:00:00','00:00:00','Mon-Fri',128);
INSERT INTO `service_periods` VALUES   (556,'Commitment Period','09:00:00','17:00:00','00:00:00','00:00:00','Saturday',129);
INSERT INTO `service_periods` VALUES   (557,'Commitment Period','07:00:00','20:00:00','00:00:00','00:00:00','Mon-Fri',130);
INSERT INTO `service_periods` VALUES   (558,'Commitment Period','07:00:00','21:00:00','00:00:00','00:00:00','Mon-Fri',131);
INSERT INTO `service_periods` VALUES   (559,'Commitment Period','07:30:00','20:00:00','00:00:00','00:00:00','Mon-Fri',132);
INSERT INTO `service_periods` VALUES   (560,'Commitment Period','08:00:00','18:00:00','00:00:00','00:00:00','Mon-Fri',133);
INSERT INTO `service_periods` VALUES   (561,'Commitment Period','00:00:00','24:00:00','00:00:00','00:00:00','Mon-Fri',134);
INSERT INTO `service_periods` VALUES   (561,'Commitment Period','00:00:00','17:00:00','00:00:00','00:00:00','Saturday',135);
INSERT INTO `service_periods` VALUES   (561,'Maintenance Window','00:00:00','24:00:00','00:00:00','00:00:00','Sunday',136);
INSERT INTO `service_periods` VALUES   (513,'Commitment Period','08:00:00','21:00:00','00:00:00','00:00:00','Mon-Fri',137);
INSERT INTO `service_periods` VALUES   (562,'Commitment Period','07:00:00','21:00:00','00:00:00','00:00:00','Mon-Fri',138);
INSERT INTO `service_periods` VALUES   (564,'Commitment Period','08:00:00','18:00:00','00:00:00','00:00:00','Mon-Fri',139);
INSERT INTO `service_periods` VALUES   (563,'Commitment Period','06:00:00','20:00:00','00:00:00','00:00:00','Mon-Fri',140);
INSERT INTO `service_periods` VALUES   (564,'Maintenance Window','10:00:00','15:00:00','00:00:00','00:00:00','Sunday',141);
INSERT INTO `service_periods` VALUES   (565,'Commitment Period','08:00:00','18:00:00','00:00:00','00:00:00','Mon-Fri',142);
INSERT INTO `service_periods` VALUES   (566,'Commitment Period','07:00:00','22:00:00','00:00:00','00:00:00','Mon-Fri',143);
INSERT INTO `service_periods` VALUES   (567,'Commitment Period','00:00:00','00:00:00','00:00:00','00:00:00','24 x 7',144);
INSERT INTO `service_periods` VALUES   (517,'Commitment Period','12:00:00','24:00:00','00:00:00','00:00:00','Monday',145);
INSERT INTO `service_periods` VALUES   (570,'Commitment Period','06:30:00','19:30:00','00:00:00','00:00:00','Mon-Fri',146);
INSERT INTO `service_periods` VALUES   (572,'Commitment Period','08:00:00','18:00:00','00:00:00','00:00:00','Mon-Sat',148);
INSERT INTO `service_periods` VALUES   (573,'Commitment Period','06:00:00','20:00:00','00:00:00','00:00:00','Mon-Fri',149);
INSERT INTO `service_periods` VALUES   (574,'Commitment Period','06:00:00','18:00:00','00:00:00','00:00:00','Mon-Fri',150);
INSERT INTO `service_periods` VALUES   (575,'Commitment Period','00:00:00','00:00:00','00:00:00','00:00:00','24 x 7',152);
INSERT INTO `service_periods` VALUES   (576,'Commitment Period','06:00:00','22:00:00','00:00:00','00:00:00','Mon-Fri',153);
INSERT INTO `service_periods` VALUES   (577,'Commitment Period','08:00:00','20:00:00','00:00:00','00:00:00','Mon-Fri',154);
INSERT INTO `service_periods` VALUES   (579,'Commitment Period','08:00:00','18:00:00','00:00:00','00:00:00','Mon-Fri',155);
INSERT INTO `service_periods` VALUES   (578,'Commitment Period','08:30:00','18:00:00','00:00:00','00:00:00','Mon-Fri',156);
INSERT INTO `service_periods` VALUES   (580,'Commitment Period','08:00:00','21:00:00','00:00:00','00:00:00','Mon-Fri',157);
INSERT INTO `service_periods` VALUES   (581,'Commitment Period','06:00:00','19:30:00','00:00:00','00:00:00','Mon-Fri',158);
INSERT INTO `service_periods` VALUES   (582,'Commitment Period','07:00:00','19:00:00','00:00:00','00:00:00','Mon-Fri',159);
INSERT INTO `service_periods` VALUES   (584,'Commitment Period','06:00:00','20:00:00','00:00:00','00:00:00','Mon-Fri',160);
INSERT INTO `service_periods` VALUES   (519,'Commitment Period','08:00:00','18:00:00','00:00:00','00:00:00','Mon-Fri',161);
INSERT INTO `service_periods` VALUES   (586,'Commitment Period','06:00:00','19:30:00','00:00:00','00:00:00','Mon-Fri',162);
INSERT INTO `service_periods` VALUES   (587,'Commitment Period','06:00:00','20:00:00','00:00:00','00:00:00','Mon-Fri',165);
INSERT INTO `service_periods` VALUES   (587,'Commitment Period','08:00:00','12:00:00','00:00:00','00:00:00','Saturday',166);
INSERT INTO `service_periods` VALUES   (588,'Commitment Period','08:00:00','24:00:00','00:00:00','00:00:00','Mon-Fri',167);
INSERT INTO `service_periods` VALUES   (588,'Commitment Period','08:00:00','20:00:00','00:00:00','00:00:00','Saturday',168);
INSERT INTO `service_periods` VALUES   (589,'Commitment Period','08:00:00','17:00:00','00:00:00','00:00:00','Mon-Fri',169);
INSERT INTO `service_periods` VALUES   (590,'Commitment Period','08:00:00','17:30:00','00:00:00','00:00:00','Mon-Fri',170);
INSERT INTO `service_periods` VALUES   (591,'Commitment Period','07:00:00','21:00:00','00:00:00','00:00:00','Mon-Fri',171);
INSERT INTO `service_periods` VALUES   (591,'Commitment Period','08:00:00','21:00:00','00:00:00','00:00:00','Sat-Sun',172);
INSERT INTO `service_periods` VALUES   (594,'Commitment Period','06:00:00','21:00:00','00:00:00','00:00:00','Mon-Fri',173);
INSERT INTO `service_periods` VALUES   (593,'Commitment Period','07:00:00','22:00:00','00:00:00','00:00:00','Mon-Fri',174);
INSERT INTO `service_periods` VALUES   (595,'Commitment Period','08:00:00','18:00:00','00:00:00','00:00:00','Mon-Fri',175);
INSERT INTO `service_periods` VALUES   (530,'Commitment Period','07:00:00','24:00:00','00:00:00','00:00:00','Mon-Fri',176);
INSERT INTO `service_periods` VALUES   (530,'Commitment Period','00:00:00','01:00:00','09:00:00','17:00:00','Saturday',177);
INSERT INTO `service_periods` VALUES   (597,'Commitment Period','07:00:00','20:00:00','00:00:00','00:00:00','Mon-Fri',178);
INSERT INTO `service_periods` VALUES   (598,'Commitment Period','07:00:00','21:00:00','00:00:00','00:00:00','Mon-Fri',179);
INSERT INTO `service_periods` VALUES   (600,'Commitment Period','06:00:00','18:00:00','00:00:00','00:00:00','Mon-Fri',180);
INSERT INTO `service_periods` VALUES   (602,'Commitment Period','07:30:00','20:15:00','00:00:00','00:00:00','Mon-Sun',181);
INSERT INTO `service_periods` VALUES   (605,'Commitment Period','00:01:00','08:00:00','00:00:00','00:00:00','Mon-Sat',183);
INSERT INTO `service_periods` VALUES   (606,'Commitment Period','06:00:00','22:00:00','00:00:00','00:00:00','Mon-Fri',184);
INSERT INTO `service_periods` VALUES   (609,'Commitment Period','09:00:00','21:00:00','00:00:00','00:00:00','Mon-Fri',185);
INSERT INTO `service_periods` VALUES   (610,'Commitment Period','07:00:00','21:00:00','00:00:00','00:00:00','Mon-Fri',186);
INSERT INTO `service_periods` VALUES   (612,'Commitment Period','06:00:00','19:30:00','00:00:00','00:00:00','Mon-Fri',189);
INSERT INTO `service_periods` VALUES   (546,'Commitment Period','00:00:00','17:00:00','00:00:00','00:00:00','Saturday',190);
INSERT INTO `service_periods` VALUES   (545,'Commitment Period','08:00:00','17:30:00','00:00:00','00:00:00','Mon-Fri',193);
INSERT INTO `service_periods` VALUES   (510,'Commitment Period','07:00:00','19:00:00','00:00:00','00:00:00','Mon-Fri',194);
INSERT INTO `service_periods` VALUES   (517,'Commitment Period','00:00:00','24:00:00','00:00:00','00:00:00','Tuesday',195);
INSERT INTO `service_periods` VALUES   (517,'Commitment Period','00:00:00','24:00:00','00:00:00','00:00:00','Wednesday',196);
INSERT INTO `service_periods` VALUES   (517,'Commitment Period','00:00:00','24:00:00','00:00:00','00:00:00','Thursday',197);
INSERT INTO `service_periods` VALUES   (517,'Commitment Period','00:00:00','24:00:00','00:00:00','00:00:00','Friday',198);
INSERT INTO `service_periods` VALUES   (517,'Commitment Period','00:00:00','01:30:00','00:00:00','00:00:00','Saturday',199);
INSERT INTO `service_periods` VALUES   (524,'Commitment Period','08:00:00','20:00:00','00:00:00','00:00:00','Monday',200);
INSERT INTO `service_periods` VALUES   (524,'Commitment Period','09:00:00','20:00:00','00:00:00','00:00:00','Tuesday',201);
INSERT INTO `service_periods` VALUES   (524,'Commitment Period','08:00:00','20:00:00','00:00:00','00:00:00','Wednesday',202);
INSERT INTO `service_periods` VALUES   (524,'Commitment Period','08:00:00','20:00:00','00:00:00','00:00:00','Thursday',203);
INSERT INTO `service_periods` VALUES   (524,'Commitment Period','08:00:00','20:00:00','00:00:00','00:00:00','Friday',204);
INSERT INTO `service_periods` VALUES   (596,'Commitment Period','07:30:00','19:30:00','00:00:00','00:00:00','Mon-Fri',205);
INSERT INTO `service_periods` VALUES   (525,'Commitment Period','08:00:00','17:30:00','00:00:00','00:00:00','Mon-Fri',206);
INSERT INTO `service_periods` VALUES   (528,'Commitment Period','07:00:00','22:00:00','00:00:00','00:00:00','Mon-Fri',207);
INSERT INTO `service_periods` VALUES   (538,'Commitment Period','08:00:00','20:00:00','00:00:00','00:00:00','Mon-Fri',208);
INSERT INTO `service_periods` VALUES   (607,'Commitment Period','07:30:00','19:30:00','00:00:00','00:00:00','Mon-Fri',209);
INSERT INTO `service_periods` VALUES   (610,'Commitment Period','09:00:00','17:00:00','00:00:00','00:00:00','Saturday',210);
INSERT INTO `service_periods` VALUES   (532,'Commitment Period','08:30:00','20:30:00','00:00:00','00:00:00','Mon-Fri',211);
INSERT INTO `service_periods` VALUES   (540,'Commitment Period','00:00:00','24:00:00','00:00:00','00:00:00','Tuesday',212);
INSERT INTO `service_periods` VALUES   (540,'Commitment Period','00:00:00','24:00:00','00:00:00','00:00:00','Wednesday',213);
INSERT INTO `service_periods` VALUES   (540,'Commitment Period','00:00:00','24:00:00','00:00:00','00:00:00','Thursday',214);
INSERT INTO `service_periods` VALUES   (540,'Commitment Period','00:00:00','24:00:00','00:00:00','00:00:00','Friday',215);
INSERT INTO `service_periods` VALUES   (613,'Commitment Period','08:00:00','17:00:00','00:00:00','00:00:00','Mon-Fri',216);
INSERT INTO `service_periods` VALUES   (532,'Maintenance Window','21:00:00','06:00:00','00:00:00','00:00:00','Mon-Sun',221);
INSERT INTO `service_periods` VALUES   (617,'Commitment Period','06:00:00','16:00:00','00:00:00','00:00:00','Mon-Fri',222);
INSERT INTO `service_periods` VALUES   (617,'Maintenance Window','08:00:00','24:00:00','00:00:00','00:00:00','Saturday',223);
INSERT INTO `service_periods` VALUES   (617,'Maintenance Window','00:00:00','22:00:00','00:00:00','00:00:00','Sunday',224);
INSERT INTO `service_periods` VALUES   (619,'Maintenance Window','10:00:00','14:00:00','00:00:00','00:00:00','Saturday',225);
INSERT INTO `service_periods` VALUES   (618,'Maintenance Window','10:00:00','14:00:00','00:00:00','00:00:00','Saturday',226);
INSERT INTO `service_periods` VALUES   (615,'Maintenance Window','02:00:00','03:00:00','00:00:00','00:00:00','Sunday',230);
INSERT INTO `service_periods` VALUES   (615,'Commitment Period','00:00:00','00:00:00','00:00:00','00:00:00','24 x 5',234);
INSERT INTO `service_periods` VALUES   (504,'Commitment Period','00:00:00','23:59:00','00:00:00','00:00:00','Mon-Fri',235);
INSERT INTO `service_periods` VALUES   (504,'Commitment Period','16:00:00','23:59:00','00:00:00','00:00:00','Saturday',236);
INSERT INTO `service_periods` VALUES   (504,'Commitment Period','11:00:00','24:00:00','00:00:00','00:00:00','Sunday',237);
/*!40000 ALTER TABLE `service_periods` ENABLE KEYS */;