-- MariaDB dump 10.19  Distrib 10.6.7-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: styloo_booking_test
-- ------------------------------------------------------
-- Server version	10.6.7-MariaDB-2ubuntu1.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `booking_details`
--

DROP TABLE IF EXISTS `booking_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `booking_details` (
  `booking_details_id` int(11) NOT NULL AUTO_INCREMENT,
  `branch_details_id` int(11) DEFAULT NULL,
  `booking_types_id` int(11) DEFAULT NULL,
  `catergory_type_id` int(11) DEFAULT NULL,
  `gender_type_id` int(11) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `service_types_id` int(11) DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `is_active` varchar(45) DEFAULT NULL,
  `completed_date` date DEFAULT NULL,
  PRIMARY KEY (`booking_details_id`),
  KEY `booking_details_fk1_idx` (`branch_details_id`),
  KEY `booking_details_fk2_idx` (`booking_types_id`),
  KEY `booking_details_fk3_idx` (`service_types_id`),
  CONSTRAINT `booking_details_fk1` FOREIGN KEY (`branch_details_id`) REFERENCES `branch_details` (`branch_details_id`),
  CONSTRAINT `booking_details_fk2` FOREIGN KEY (`booking_types_id`) REFERENCES `booking_types` (`booking_types_id`),
  CONSTRAINT `booking_details_fk3` FOREIGN KEY (`service_types_id`) REFERENCES `service_types` (`service_types_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `booking_details`
--

LOCK TABLES `booking_details` WRITE;
/*!40000 ALTER TABLE `booking_details` DISABLE KEYS */;
INSERT INTO `booking_details` VALUES (1,1,1,3,2,'2021-12-29','11:22:24',3,1,1,'COMPLETED','1',NULL),(2,1,1,1,1,'2021-12-30','11:22:24',3,1,1,'COMPLETED','1',NULL),(3,1,1,2,1,'2021-12-31','09:27:53',1,1,1,'COMPLETED','1',NULL),(4,1,2,2,1,'2021-12-29',NULL,NULL,1,1,'DONE','1',NULL),(5,1,1,NULL,NULL,'2021-12-29',NULL,NULL,1,NULL,'DONE',NULL,NULL),(6,1,1,1,1,'2021-12-31','15:48:20',NULL,1,1,'COMPLETED','1',NULL),(7,1,2,2,1,'2021-12-30','09:27:53',1,1,1,'DONE','1',NULL),(11,1,1,NULL,NULL,'2022-07-03','18:49:49',1,1,NULL,'COMPLETED',NULL,'2022-07-08'),(13,1,1,NULL,1,'2022-07-10','08:31:53',1,1,1,'COMPLETED','1','2022-07-08'),(14,1,1,NULL,1,'2022-07-10','08:32:45',1,1,1,'COMPLETED','1','2022-07-09'),(15,1,1,NULL,1,'2022-07-11','08:36:31',1,1,1,'COMPLETED','1','2022-07-10'),(16,1,1,NULL,1,'2022-07-12','12:08:20',1,1,1,'COMPLETED','1','2022-07-13'),(17,1,1,1,1,'2022-07-13','12:09:42',1,1,1,'COMPLETED','1','2022-07-13');
/*!40000 ALTER TABLE `booking_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `booking_details_h`
--

DROP TABLE IF EXISTS `booking_details_h`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `booking_details_h` (
  `booking_details_id` int(11) NOT NULL AUTO_INCREMENT,
  `branch_details_id` int(11) DEFAULT NULL,
  `booking_types_id` int(11) DEFAULT NULL,
  `catergory_type_id` int(11) DEFAULT NULL,
  `gender_type_id` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `service_type` varchar(100) DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `updated_date` date DEFAULT NULL,
  `updated_time` time DEFAULT NULL,
  PRIMARY KEY (`booking_details_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `booking_details_h`
--

LOCK TABLES `booking_details_h` WRITE;
/*!40000 ALTER TABLE `booking_details_h` DISABLE KEYS */;
INSERT INTO `booking_details_h` VALUES (1,1,2,2,1,'2021-12-30','11:22:24','TODO',2,1,'COMPLETED',NULL,NULL),(2,1,1,1,1,'2021-12-30','11:22:24','TODO',1,1,'COMPLETED',NULL,NULL),(3,1,1,2,1,'2021-12-31','09:27:53','DONE',1,1,'COMPLETED',NULL,NULL),(4,1,1,2,1,'2021-12-31','09:27:53','DONE',1,1,'COMPLETED',NULL,NULL),(5,1,1,1,1,'2021-12-31','15:47:33','TODO',1,1,'COMPLETED',NULL,NULL),(6,1,1,1,1,'2021-12-31','15:48:20','TODO',1,1,'COMPLETED',NULL,NULL),(7,1,1,1,1,'2021-12-31','15:48:33','TODO',1,1,'COMPLETED',NULL,NULL);
/*!40000 ALTER TABLE `booking_details_h` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `booking_rule`
--

DROP TABLE IF EXISTS `booking_rule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `booking_rule` (
  `booking_rule_id` int(11) NOT NULL AUTO_INCREMENT,
  `rule` varchar(100) DEFAULT NULL,
  `tc_text` varchar(200) DEFAULT NULL,
  `tc_link` varchar(200) DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`booking_rule_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `booking_rule`
--

LOCK TABLES `booking_rule` WRITE;
/*!40000 ALTER TABLE `booking_rule` DISABLE KEYS */;
INSERT INTO `booking_rule` VALUES (1,'almalqmaqiojaqknakq','shkshkshkala','dfjefkjej',1);
/*!40000 ALTER TABLE `booking_rule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `booking_service_details`
--

DROP TABLE IF EXISTS `booking_service_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `booking_service_details` (
  `booking_service_details_id` int(11) NOT NULL AUTO_INCREMENT,
  `booking_details_id` int(11) DEFAULT NULL,
  `service_details_id` int(11) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`booking_service_details_id`),
  KEY `booking_service_details_fk1_idx` (`booking_details_id`),
  CONSTRAINT `booking_service_details_fk1` FOREIGN KEY (`booking_details_id`) REFERENCES `booking_details` (`booking_details_id`)
) ENGINE=InnoDB AUTO_INCREMENT=315 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `booking_service_details`
--

LOCK TABLES `booking_service_details` WRITE;
/*!40000 ALTER TABLE `booking_service_details` DISABLE KEYS */;
INSERT INTO `booking_service_details` VALUES (1,1,NULL,NULL),(2,2,NULL,NULL),(3,8,1,1),(4,8,1,1),(5,9,1,1),(6,9,2,NULL),(7,10,1,NULL),(8,10,2,NULL),(9,11,1,NULL),(10,11,2,NULL),(11,12,1,NULL),(12,12,2,NULL),(13,12,1,NULL),(14,12,2,NULL),(15,13,1,NULL),(16,13,2,NULL),(17,12,1,NULL),(18,12,2,NULL),(19,16,1,NULL),(20,16,2,NULL),(21,24,1,NULL),(22,24,2,NULL),(23,25,1,NULL),(24,25,2,NULL),(25,26,1,NULL),(26,26,2,NULL),(27,27,1,NULL),(28,27,2,NULL),(29,28,1,NULL),(30,28,2,NULL),(31,29,1,NULL),(32,29,2,NULL),(33,30,1,NULL),(34,30,2,NULL),(35,31,1,NULL),(36,31,2,NULL),(37,32,1,NULL),(38,32,2,NULL),(39,33,1,NULL),(40,33,2,NULL),(41,34,1,NULL),(42,34,2,NULL),(43,35,1,NULL),(44,35,2,NULL),(45,36,1,NULL),(46,36,2,NULL),(47,37,1,NULL),(48,37,2,NULL),(49,38,1,NULL),(50,38,2,NULL),(51,39,1,NULL),(52,39,2,NULL),(53,40,1,NULL),(54,40,2,NULL),(55,43,1,NULL),(56,43,2,NULL),(57,44,1,NULL),(58,44,2,NULL),(59,45,1,NULL),(60,45,2,NULL),(61,46,1,NULL),(62,46,2,NULL),(63,47,1,NULL),(64,47,2,NULL),(65,48,1,NULL),(66,48,2,NULL),(67,49,1,NULL),(68,49,2,NULL),(69,50,1,NULL),(70,50,2,NULL),(71,51,1,NULL),(72,51,2,NULL),(73,52,1,NULL),(74,52,2,NULL),(75,53,1,NULL),(76,53,2,NULL),(77,54,1,NULL),(78,54,2,NULL),(79,55,1,NULL),(80,55,2,NULL),(81,56,1,NULL),(82,56,2,NULL),(83,57,1,NULL),(84,57,2,NULL),(85,58,1,NULL),(86,58,2,NULL),(87,59,1,NULL),(88,59,2,NULL),(89,60,1,NULL),(90,60,2,NULL),(91,62,1,NULL),(92,62,2,NULL),(93,63,1,NULL),(94,63,2,NULL),(95,64,1,NULL),(96,64,2,NULL),(97,65,1,NULL),(98,65,2,NULL),(99,66,1,NULL),(100,66,2,NULL),(101,67,1,NULL),(102,67,2,NULL),(103,68,1,NULL),(104,68,2,NULL),(105,69,1,NULL),(106,69,2,NULL),(107,70,1,NULL),(108,70,2,NULL),(109,71,1,NULL),(110,71,2,NULL),(111,72,1,NULL),(112,72,2,NULL),(113,73,1,NULL),(114,73,2,NULL),(115,74,1,NULL),(116,74,2,NULL),(117,75,1,NULL),(118,75,2,NULL),(119,76,1,NULL),(120,76,2,NULL),(121,77,1,NULL),(122,77,2,NULL),(123,78,1,NULL),(124,78,2,NULL),(125,79,1,NULL),(126,79,2,NULL),(127,80,1,NULL),(128,80,2,NULL),(129,81,1,NULL),(130,81,2,NULL),(131,84,1,NULL),(132,84,2,NULL),(133,86,1,NULL),(134,86,2,NULL),(135,89,1,NULL),(136,89,2,NULL),(137,90,1,NULL),(138,90,2,NULL),(139,91,1,NULL),(140,91,2,NULL),(141,92,1,NULL),(142,92,2,NULL),(143,93,1,NULL),(144,93,2,NULL),(145,94,1,NULL),(146,94,2,NULL),(147,95,1,NULL),(148,95,2,NULL),(149,96,1,NULL),(150,96,2,NULL),(151,97,1,NULL),(152,97,2,NULL),(153,100,1,NULL),(154,100,2,NULL),(155,101,1,NULL),(156,101,2,NULL),(157,102,1,NULL),(158,102,2,NULL),(159,103,1,NULL),(160,103,2,NULL),(161,104,1,NULL),(162,104,2,NULL),(163,105,1,NULL),(164,105,2,NULL),(165,106,1,NULL),(166,106,2,NULL),(167,107,1,NULL),(168,107,2,NULL),(169,108,1,NULL),(170,108,2,NULL),(171,109,1,NULL),(172,109,2,NULL),(173,110,1,NULL),(174,110,2,NULL),(175,111,1,NULL),(176,111,2,NULL),(177,112,1,NULL),(178,112,2,NULL),(179,113,1,NULL),(180,113,2,NULL),(183,115,1,NULL),(184,115,2,NULL),(185,117,1,NULL),(186,117,2,NULL),(187,118,1,NULL),(188,118,2,NULL),(189,119,1,NULL),(190,119,2,NULL),(191,120,1,NULL),(192,120,2,NULL),(193,121,1,NULL),(194,121,2,NULL),(195,122,1,NULL),(196,122,2,NULL),(197,123,1,NULL),(198,123,2,NULL),(199,124,1,NULL),(200,124,2,NULL),(201,125,1,NULL),(202,125,2,NULL),(203,126,1,NULL),(204,126,2,NULL),(205,131,1,NULL),(206,131,2,NULL),(207,132,1,NULL),(208,132,2,NULL),(209,133,1,NULL),(210,133,2,NULL),(211,134,1,NULL),(212,134,2,NULL),(213,135,1,NULL),(214,135,2,NULL),(215,136,1,NULL),(216,136,2,NULL),(217,137,1,NULL),(218,137,2,NULL),(219,138,1,NULL),(220,138,2,NULL),(221,139,1,NULL),(222,139,2,NULL),(225,141,1,NULL),(226,141,2,NULL),(227,142,1,NULL),(228,142,2,NULL),(229,143,1,NULL),(230,143,2,NULL),(231,145,1,NULL),(232,145,2,NULL),(233,146,1,NULL),(234,146,2,NULL),(235,147,1,NULL),(236,147,2,NULL),(237,148,1,NULL),(238,148,2,NULL),(239,149,1,NULL),(240,149,2,NULL),(241,150,1,NULL),(242,150,2,NULL),(243,152,1,NULL),(244,152,2,NULL),(245,153,1,NULL),(246,153,2,NULL),(247,154,1,NULL),(248,154,2,NULL),(249,155,1,NULL),(250,155,2,NULL),(251,156,1,NULL),(252,156,2,NULL),(253,157,1,NULL),(254,157,2,NULL),(255,158,1,NULL),(256,158,2,NULL),(259,161,1,NULL),(260,161,2,NULL),(261,162,1,NULL),(262,162,2,NULL),(263,163,1,NULL),(264,163,2,NULL),(265,164,1,NULL),(266,164,2,NULL),(267,165,1,NULL),(268,165,2,NULL),(269,166,1,NULL),(270,166,2,NULL),(271,171,1,NULL),(272,171,2,NULL),(273,172,1,NULL),(274,172,2,NULL),(275,173,1,NULL),(276,173,2,NULL),(277,174,1,NULL),(278,174,2,NULL),(279,175,1,NULL),(280,175,2,NULL),(281,176,1,NULL),(282,176,2,NULL),(283,177,1,NULL),(284,177,2,NULL),(285,178,1,NULL),(286,178,2,NULL),(287,179,1,NULL),(288,179,2,NULL),(289,180,1,NULL),(290,180,2,NULL),(291,181,1,NULL),(292,181,2,NULL),(293,182,1,NULL),(294,182,2,NULL),(295,183,1,NULL),(296,183,2,NULL),(297,184,1,NULL),(298,184,2,NULL),(299,185,1,NULL),(300,185,2,NULL),(301,186,1,NULL),(302,186,2,NULL),(303,187,1,NULL),(304,187,2,NULL),(305,188,1,NULL),(306,188,2,NULL),(307,189,1,NULL),(308,189,2,NULL),(309,190,1,NULL),(310,190,2,NULL),(311,191,1,NULL),(312,191,2,NULL),(313,192,1,NULL),(314,192,2,NULL);
/*!40000 ALTER TABLE `booking_service_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `booking_types`
--

DROP TABLE IF EXISTS `booking_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `booking_types` (
  `booking_types_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  PRIMARY KEY (`booking_types_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `booking_types`
--

LOCK TABLES `booking_types` WRITE;
/*!40000 ALTER TABLE `booking_types` DISABLE KEYS */;
INSERT INTO `booking_types` VALUES (1,'Up Coming Bookings',1),(2,'Previous Bookings',1),(3,'Cancelled Bookings',1);
/*!40000 ALTER TABLE `booking_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `branch_details`
--

DROP TABLE IF EXISTS `branch_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `branch_details` (
  `branch_details_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `location` varchar(200) DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `open_from` time DEFAULT NULL,
  `open_to` time DEFAULT NULL,
  `joining_date` date DEFAULT NULL,
  `contact_number` int(11) DEFAULT NULL,
  PRIMARY KEY (`branch_details_id`)
) ENGINE=InnoDB AUTO_INCREMENT=193 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `branch_details`
--

LOCK TABLES `branch_details` WRITE;
/*!40000 ALTER TABLE `branch_details` DISABLE KEYS */;
INSERT INTO `branch_details` VALUES (1,'StylooBranch','Kelaniya',1,0,'08:00:00','21:00:00','2021-01-23',212228897),(2,'StylooBranch1','Kelaniya',2,1,'08:00:00','21:00:00','2021-01-23',764534221),(3,'StylooBranch2','Jaffna',1,1,'09:00:00','22:00:00','2021-01-24',226789876),(4,'Branch4','Kirulapone',1,1,NULL,NULL,NULL,NULL),(5,'Branch5','Nugegoda',1,1,NULL,NULL,NULL,NULL),(6,'Branch6','Kottawa',1,1,NULL,NULL,NULL,NULL),(7,'Branch7','Makubura',2,1,NULL,NULL,NULL,NULL),(9,'Salon Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(10,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(11,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(12,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(13,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(14,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(15,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(16,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(17,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(18,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(19,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(20,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(21,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(22,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(24,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(25,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(26,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(27,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(28,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(29,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(31,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(32,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(33,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(34,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(35,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(36,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(37,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(38,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(40,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(41,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(42,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(43,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(44,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(45,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(46,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(47,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(48,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(49,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(70,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(71,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(72,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(73,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(74,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(75,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(76,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(77,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(78,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(79,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(80,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(81,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(82,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(85,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(86,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(87,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(88,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(89,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(90,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(91,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(92,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(93,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(94,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(95,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(106,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(107,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(108,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(109,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(110,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(111,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(112,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(113,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(114,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(115,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(116,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(117,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(118,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(119,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(120,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(121,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(122,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(123,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(124,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(125,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(126,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(127,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(128,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(129,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(130,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(131,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(132,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(133,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(134,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(135,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(136,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(137,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(138,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(139,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(140,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(141,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(142,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(144,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(145,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(146,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(147,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(148,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(149,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(150,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(151,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(152,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(153,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(154,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(155,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(156,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(157,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(158,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(159,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(160,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(161,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(162,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(163,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(164,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(165,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(166,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(167,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(168,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(169,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(170,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(171,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(172,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(173,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(174,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(175,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(176,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(177,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(178,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(179,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(180,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(181,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876),(183,'Styloo Jaffna','Jaffna',1,1,'08:00:00','20:00:00','2022-03-20',222218876);
/*!40000 ALTER TABLE `branch_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `service_types`
--

DROP TABLE IF EXISTS `service_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `service_types` (
  `service_types_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  PRIMARY KEY (`service_types_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `service_types`
--

LOCK TABLES `service_types` WRITE;
/*!40000 ALTER TABLE `service_types` DISABLE KEYS */;
INSERT INTO `service_types` VALUES (1,'TODO',1),(2,'IN PROGRESS',1),(3,'DONE',1);
/*!40000 ALTER TABLE `service_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'styloo_booking_test'
--

--
-- Dumping routines for database 'styloo_booking_test'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-08-02  6:50:24
