-- MariaDB dump 10.19  Distrib 10.6.7-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: styloo_booking
-- ------------------------------------------------------
-- 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,
  `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,
  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=212 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,3,1,1,'2021-12-29','11:22:24',2,1,1,'COMPLETED','1'),(2,1,1,1,1,'2021-12-30','11:22:24',2,1,1,'COMPLETED','1'),(3,1,4,1,1,'2021-12-31','09:27:53',2,1,1,'COMPLETED','1'),(4,1,3,2,1,'2021-12-31','09:27:53',1,1,1,'CANCELLED','1'),(5,1,1,1,1,'2021-12-31','15:47:33',1,1,1,'COMPLETED','1'),(6,1,1,1,1,'2021-12-31','15:48:20',1,1,1,'COMPLETED','1'),(7,1,3,2,1,'2021-12-31','09:27:53',1,1,1,'CANCELLED','1'),(16,1,2,1,1,'2022-01-31','16:41:09',1,1,1,'COMPLETED','1'),(24,1,2,1,1,'2022-02-01','22:27:27',2,1,1,'COMPLETED','1'),(25,1,1,1,1,'2022-02-01','22:35:01',2,1,1,'COMPLETED','1'),(26,1,3,1,1,'2022-02-01','22:39:37',1,1,1,'COMPLETED','1'),(27,1,1,1,1,'2022-02-01','22:42:28',1,1,1,'COMPLETED','1'),(28,1,4,1,1,'2022-02-02','08:24:41',1,1,1,'COMPLETED','1'),(29,1,4,1,1,'2022-02-02','08:40:19',1,1,1,'COMPLETED','1'),(30,1,4,1,1,'2022-02-02','08:41:04',2,1,1,'COMPLETED','1'),(31,1,4,1,1,'2022-02-02','08:46:15',2,1,1,'COMPLETED','1'),(32,1,4,1,1,'2022-02-02','08:49:55',2,1,1,'COMPLETED','1'),(33,1,4,1,1,'2022-02-02','08:51:16',1,1,1,'COMPLETED','1'),(34,1,4,1,1,'2022-02-02','08:52:26',1,1,1,'COMPLETED','1'),(35,1,3,1,1,'2022-02-02','11:05:35',1,1,1,'COMPLETED','1'),(36,1,3,1,1,'2022-02-02','11:09:58',1,1,1,'COMPLETED','1'),(37,1,1,1,1,'2022-02-02','12:43:05',1,1,1,'COMPLETED','1'),(38,1,1,1,1,'2022-02-02','13:05:32',1,1,1,'COMPLETED','1'),(39,1,1,1,1,'2022-02-02','13:17:55',1,1,1,'COMPLETED','1'),(40,1,1,1,1,'2022-02-02','13:19:23',2,1,1,'COMPLETED','1'),(43,1,1,1,1,'2022-02-02','14:21:11',2,1,1,'COMPLETED','1'),(44,1,1,1,1,'2022-02-02','14:29:40',2,1,1,'COMPLETED','1'),(45,1,1,1,1,'2022-02-02','14:43:32',2,1,1,'COMPLETED','1'),(46,1,1,1,1,'2022-02-02','14:46:21',2,1,1,'COMPLETED','1'),(47,1,1,1,1,'2022-02-02','15:09:44',2,1,1,'COMPLETED','1'),(48,1,1,1,1,'2022-02-02','15:26:40',2,1,1,'COMPLETED','1'),(49,1,3,1,1,'2022-02-02','15:49:00',2,1,1,'COMPLETED','1'),(50,1,1,1,1,'2022-02-02','16:16:02',2,1,1,'COMPLETED','1'),(51,1,3,1,1,'2022-02-02','16:22:49',2,1,1,'COMPLETED','1'),(52,1,1,1,1,'2022-02-02','16:39:47',2,1,1,'COMPLETED','1'),(53,1,1,1,1,'2022-02-02','17:31:47',2,1,1,'COMPLETED','1'),(54,1,1,1,1,'2022-02-02','23:14:05',2,1,1,'COMPLETED','1'),(55,1,1,1,1,'2022-02-03','07:47:58',2,1,1,'COMPLETED','1'),(56,1,1,1,1,'2022-02-03','08:29:28',1,1,1,'COMPLETED','1'),(57,1,1,1,1,'2022-02-03','09:21:58',1,1,1,'COMPLETED','1'),(58,1,1,1,1,'2022-02-03','17:05:19',1,1,1,'COMPLETED','1'),(59,1,1,1,1,'2022-02-03','17:12:06',1,1,1,'COMPLETED','1'),(60,1,1,1,1,'2022-02-03','17:14:57',1,1,1,'COMPLETED','1'),(61,1,1,1,1,'2022-02-03','17:29:41',1,1,1,'CANCELLED','1'),(62,1,1,1,1,'2022-02-03','17:32:14',1,1,1,'COMPLETED','1'),(63,1,1,1,1,'2022-02-03','17:36:16',1,1,1,'COMPLETED','1'),(64,1,1,1,1,'2022-02-03','18:04:28',1,1,1,'COMPLETED','1'),(65,1,1,1,1,'2022-02-06','08:51:54',1,1,1,'COMPLETED','1'),(66,1,1,1,1,'2022-02-06','08:59:49',1,1,1,'COMPLETED','1'),(67,1,1,1,1,'2022-02-06','09:05:03',1,1,1,'COMPLETED','1'),(68,1,1,1,1,'2022-02-06','09:06:08',1,1,1,'COMPLETED','1'),(69,1,1,1,1,'2022-02-06','15:43:08',1,1,1,'COMPLETED','1'),(70,1,1,1,1,'2022-02-06','20:32:11',1,1,1,'COMPLETED','1'),(71,1,1,1,1,'2022-02-07','10:23:02',1,1,1,'COMPLETED','1'),(72,1,1,1,1,'2022-02-07','10:29:43',1,1,1,'COMPLETED','1'),(73,1,1,1,1,'2022-02-07','17:45:48',1,1,1,'COMPLETED','1'),(74,1,1,1,1,'2022-02-08','08:10:33',2,1,1,'COMPLETED','1'),(75,1,1,1,1,'2022-02-08','10:25:32',2,1,1,'COMPLETED','1'),(76,1,1,1,1,'2022-02-08','11:56:09',2,1,1,'COMPLETED','1'),(77,1,1,1,1,'2022-02-08','12:29:25',2,1,1,'COMPLETED','1'),(78,1,1,1,1,'2022-02-08','12:30:47',2,1,1,'COMPLETED','1'),(79,1,1,1,1,'2022-02-08','13:49:54',2,1,1,'COMPLETED','1'),(80,1,1,1,1,'2022-02-08','14:28:17',1,1,1,'COMPLETED','1'),(81,1,1,1,1,'2022-02-09','16:38:01',1,1,1,'COMPLETED','1'),(84,1,1,1,1,'2022-02-10','10:39:32',1,1,1,'COMPLETED','1'),(86,1,1,1,1,'2022-02-10','11:56:18',1,1,1,'COMPLETED','1'),(89,1,1,1,1,'2022-02-10','17:32:23',2,1,1,'COMPLETED','1'),(90,1,1,1,1,'2022-02-17','15:13:06',2,1,1,'COMPLETED','1'),(91,1,1,1,1,'2022-02-17','15:29:46',2,1,1,'COMPLETED','1'),(92,1,1,1,1,'2022-02-17','15:30:30',2,1,1,'COMPLETED','1'),(93,1,1,1,1,'2022-02-18','09:05:58',2,1,1,'COMPLETED','1'),(94,1,1,1,1,'2022-02-23','09:53:38',1,1,1,'COMPLETED','1'),(95,1,1,1,1,'2022-02-24','09:33:01',1,1,1,'COMPLETED','1'),(96,1,1,1,1,'2022-02-24','18:25:59',2,1,1,'COMPLETED','1'),(97,1,1,1,1,'2022-04-04','15:12:58',2,1,1,'COMPLETED','1'),(100,1,1,1,1,'2022-04-04','18:35:15',2,1,1,'COMPLETED','1'),(101,1,1,1,1,'2022-04-04','18:44:42',2,1,1,'COMPLETED','1'),(102,1,1,1,1,'2022-04-04','18:45:58',2,1,1,'COMPLETED','1'),(103,1,1,1,1,'2022-04-04','18:49:21',2,1,1,'COMPLETED','1'),(104,1,1,1,1,'2022-04-04','18:57:44',2,1,1,'COMPLETED','1'),(105,1,1,1,1,'2022-04-04','19:02:19',1,1,1,'COMPLETED','1'),(106,1,1,1,1,'2022-04-04','19:06:34',1,1,1,'COMPLETED','1'),(107,1,1,1,1,'2022-04-04','19:07:22',1,1,1,'COMPLETED','1'),(108,1,1,1,1,'2022-04-04','19:15:24',1,1,1,'COMPLETED','1'),(109,1,1,1,1,'2022-04-04','19:20:51',1,1,1,'COMPLETED','1'),(110,1,1,1,1,'2022-04-04','19:23:08',1,1,1,'COMPLETED','1'),(111,1,1,1,1,'2022-04-05','07:32:17',1,1,1,'COMPLETED','1'),(112,1,1,1,1,'2022-04-05','07:33:20',1,1,1,'COMPLETED','1'),(113,1,1,1,1,'2022-04-05','07:36:23',1,1,1,'COMPLETED','1'),(115,1,1,1,1,'2022-04-05','07:51:32',1,1,1,'COMPLETED','1'),(117,1,1,1,1,'2022-04-05','08:42:45',1,1,1,'COMPLETED','1'),(118,1,1,1,1,'2022-04-05','13:38:45',1,1,1,'COMPLETED','1'),(119,1,1,1,1,'2022-04-05','13:44:15',1,1,1,'COMPLETED','1'),(120,1,1,1,1,'2022-04-05','13:47:01',1,1,1,'COMPLETED','1'),(121,1,1,1,1,'2022-04-05','13:48:08',1,1,1,'COMPLETED','1'),(122,1,1,1,1,'2022-04-05','15:59:12',2,1,1,'COMPLETED','1'),(123,1,1,1,1,'2022-04-06','10:10:47',2,1,1,'COMPLETED','1'),(124,1,1,1,1,'2022-04-06','10:11:45',2,1,1,'COMPLETED','1'),(125,1,1,1,1,'2022-04-06','12:21:06',2,1,1,'COMPLETED','1'),(126,1,1,1,1,'2022-04-06','12:54:02',2,1,1,'COMPLETED','1'),(131,1,1,1,1,'2022-04-06','15:08:00',2,1,1,'COMPLETED','1'),(132,1,1,1,1,'2022-04-06','15:22:26',2,1,1,'COMPLETED','1'),(133,1,1,1,1,'2022-04-06','15:25:17',2,1,1,'COMPLETED','1'),(134,1,1,1,1,'2022-04-06','15:30:21',2,1,1,'COMPLETED','1'),(135,1,1,1,1,'2022-04-06','15:31:31',1,1,1,'COMPLETED','1'),(136,1,1,1,1,'2022-04-06','15:32:19',1,1,1,'COMPLETED','1'),(137,1,1,1,1,'2022-04-06','15:34:55',1,1,1,'COMPLETED','1'),(138,1,1,1,1,'2022-04-06','15:47:00',1,1,1,'COMPLETED','1'),(139,1,1,1,1,'2022-04-06','15:50:02',1,1,1,'COMPLETED','1'),(141,1,1,1,1,'2022-04-06','17:08:52',1,1,1,'COMPLETED','1'),(142,1,1,1,1,'2022-04-06','17:13:56',1,1,1,'COMPLETED','1'),(143,1,1,1,1,'2022-04-06','17:24:15',2,1,1,'COMPLETED','1'),(145,1,1,1,1,'2022-04-06','19:55:50',2,1,1,'COMPLETED','1'),(146,1,1,1,1,'2022-04-06','21:13:40',2,1,1,'COMPLETED','1'),(147,1,1,1,1,'2022-04-06','21:32:42',2,1,1,'COMPLETED','1'),(148,1,1,1,1,'2022-04-06','21:36:41',2,1,1,'COMPLETED','1'),(149,1,1,1,1,'2022-04-06','21:39:48',2,1,1,'COMPLETED','1'),(150,1,1,1,1,'2022-04-06','21:44:51',2,1,1,'COMPLETED','1'),(152,1,1,1,1,'2022-04-08','09:12:56',1,1,1,'COMPLETED','1'),(153,1,1,1,1,'2022-04-08','13:21:07',1,1,1,'COMPLETED','1'),(154,1,1,1,1,'2022-04-08','13:39:48',1,1,1,'COMPLETED','1'),(155,1,1,1,1,'2022-04-08','13:48:01',1,1,1,'COMPLETED','1'),(156,1,1,1,1,'2022-04-08','13:49:45',1,1,1,'COMPLETED','1'),(157,1,1,1,1,'2022-04-08','13:54:03',1,1,1,'COMPLETED','1'),(158,1,1,1,1,'2022-04-10','21:51:15',1,1,1,'COMPLETED','1'),(161,1,1,1,1,'2022-04-15','14:06:02',1,1,1,'COMPLETED','1'),(162,1,1,1,1,'2022-04-16','09:31:17',1,1,1,'INPROGRESS','1'),(163,1,1,1,1,'2022-04-16','09:33:14',1,1,1,'INPROGRESS','1'),(164,1,1,1,1,'2022-04-19','11:40:42',1,1,1,'INPROGRESS','1'),(165,1,1,1,1,'2022-04-19','12:08:29',1,1,1,'INPROGRESS','1'),(166,1,1,1,1,'2022-04-19','13:30:00',1,1,1,'COMPLETED','1'),(167,1,1,1,1,'2022-05-02','12:45:08',1,1,1,'PENDING','1'),(168,1,1,1,1,'2022-05-02','12:47:19',1,1,1,'ACCEPTED','1'),(170,1,1,1,1,'2022-07-19','12:16:48',1,1,1,'PENDING','1'),(171,1,1,NULL,1,'2022-07-27','09:30:00',1,NULL,NULL,'PENDING','1'),(172,1,1,NULL,1,'2022-07-26','12:30:00',1,NULL,NULL,'PENDING','1'),(173,1,1,NULL,1,'2022-07-29','12:30:00',1,NULL,122,'PENDING','1'),(174,1,1,NULL,1,'2022-07-29','09:30:00',1,NULL,122,'PENDING','1'),(194,1,1,NULL,1,'2022-07-29','08:30:00',1,NULL,NULL,'PENDING','1'),(195,1,1,NULL,1,'2022-07-30','08:30:00',1,NULL,NULL,'PENDING','1'),(196,1,1,NULL,1,'2022-07-29','08:30:00',1,NULL,NULL,'PENDING','1'),(197,1,1,NULL,1,'2022-07-29','08:30:00',1,NULL,NULL,'PENDING','1'),(198,1,1,NULL,1,'2022-07-29','08:30:00',1,NULL,NULL,'PENDING','1'),(199,1,1,NULL,1,'2022-07-28','08:30:00',1,NULL,NULL,'PENDING','1'),(200,1,1,NULL,1,'2022-07-28','08:30:00',1,NULL,NULL,'PENDING','1'),(201,1,1,NULL,1,'2022-08-04','08:30:00',1,NULL,NULL,'PENDING','1'),(202,1,1,NULL,1,'2022-07-29','08:30:00',1,NULL,NULL,'PENDING','1'),(203,1,1,NULL,1,'2022-07-29','08:30:00',1,NULL,127,'PENDING','1'),(204,1,1,NULL,1,'2022-07-29','08:30:00',1,NULL,127,'PENDING','1'),(205,1,1,NULL,2,'2022-07-29','09:30:00',1,NULL,NULL,'PENDING','1'),(206,1,1,NULL,1,'2022-07-29','09:30:00',1,NULL,NULL,'PENDING','1'),(207,1,1,NULL,1,'2022-08-01','08:30:00',1,NULL,NULL,'PENDING','1'),(208,1,1,NULL,1,'2022-08-02','08:30:00',1,NULL,136,'PENDING','1'),(209,1,1,NULL,1,'2022-08-02','08:30:00',1,NULL,136,'PENDING','1'),(210,1,1,NULL,1,'2022-08-02','08:30:00',1,NULL,136,'PENDING','1'),(211,1,1,NULL,1,'2022-08-03','08:30:00',1,NULL,NULL,'PENDING','1');
/*!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=8 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',1,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=338 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,1,1),(2,2,2,1),(3,8,1,1),(4,8,1,1),(5,9,1,1),(6,9,2,1),(7,10,1,2),(8,10,2,1),(9,11,1,1),(10,11,2,2),(11,12,1,2),(12,12,2,2),(13,12,1,2),(14,12,2,2),(15,13,1,2),(16,13,2,2),(17,12,1,2),(18,12,2,1),(19,16,1,1),(20,16,2,1),(21,24,1,1),(22,24,2,1),(23,25,1,1),(24,25,2,2),(25,26,1,2),(26,26,2,2),(27,27,1,2),(28,27,2,1),(29,28,1,1),(30,28,2,1),(31,29,1,2),(32,29,2,1),(33,30,1,2),(34,30,2,2),(35,31,1,2),(36,31,2,2),(37,32,1,2),(38,32,2,2),(39,33,1,1),(40,33,2,1),(41,34,1,2),(42,34,2,2),(43,35,1,2),(44,35,2,1),(45,36,1,1),(46,36,2,1),(47,37,1,1),(48,37,2,1),(49,38,1,1),(50,38,2,2),(51,39,1,1),(52,39,2,2),(53,40,1,1),(54,40,2,2),(55,43,1,1),(56,43,2,2),(57,44,1,1),(58,44,2,2),(59,45,1,1),(60,45,2,1),(61,46,1,1),(62,46,2,1),(63,47,1,2),(64,47,2,1),(65,48,1,2),(66,48,2,1),(67,49,1,2),(68,49,2,1),(69,50,1,1),(70,50,2,1),(71,51,1,1),(72,51,2,1),(73,52,1,1),(74,52,2,1),(75,53,1,1),(76,53,2,1),(77,54,1,1),(78,54,2,2),(79,55,1,2),(80,55,2,2),(81,56,1,2),(82,56,2,2),(83,57,1,2),(84,57,2,2),(85,58,1,2),(86,58,2,2),(87,59,1,1),(88,59,2,1),(89,60,1,1),(90,60,2,1),(91,62,1,1),(92,62,2,1),(93,63,1,1),(94,63,2,1),(95,64,1,1),(96,64,2,1),(97,65,1,1),(98,65,2,1),(99,66,1,1),(100,66,2,2),(101,67,1,2),(102,67,2,2),(103,68,1,2),(104,68,2,2),(105,69,1,1),(106,69,2,1),(107,70,1,1),(108,70,2,1),(109,71,1,1),(110,71,2,2),(111,72,1,2),(112,72,2,2),(113,73,1,2),(114,73,2,2),(115,74,1,2),(116,74,2,2),(117,75,1,2),(118,75,2,1),(119,76,1,1),(120,76,2,1),(121,77,1,1),(122,77,2,1),(123,78,1,1),(124,78,2,2),(125,79,1,2),(126,79,2,2),(127,80,1,2),(128,80,2,2),(129,81,1,2),(130,81,2,2),(131,84,1,2),(132,84,2,2),(133,86,1,2),(134,86,2,1),(135,89,1,1),(136,89,2,1),(137,90,1,1),(138,90,2,1),(139,91,1,1),(140,91,2,1),(141,92,1,1),(142,92,2,1),(143,93,1,2),(144,93,2,2),(145,94,1,2),(146,94,2,2),(147,95,1,2),(148,95,2,2),(149,96,1,2),(150,96,2,2),(151,97,1,2),(152,97,2,2),(153,100,1,1),(154,100,2,1),(155,101,1,1),(156,101,2,1),(157,102,1,1),(158,102,2,1),(159,103,1,1),(160,103,2,2),(161,104,1,2),(162,104,2,2),(163,105,1,2),(164,105,2,2),(165,106,1,2),(166,106,2,2),(167,107,1,2),(168,107,2,1),(169,108,1,1),(170,108,2,1),(171,109,1,1),(172,109,2,1),(173,110,1,1),(174,110,2,2),(175,111,1,2),(176,111,2,2),(177,112,1,2),(178,112,2,2),(179,113,1,1),(180,113,2,1),(183,115,1,1),(184,115,2,2),(185,117,1,2),(186,117,2,2),(187,118,1,2),(188,118,2,2),(189,119,1,2),(190,119,2,2),(191,120,1,1),(192,120,2,1),(193,121,1,1),(194,121,2,1),(195,122,1,1),(196,122,2,1),(197,123,1,2),(198,123,2,2),(199,124,1,2),(200,124,2,1),(201,125,1,1),(202,125,2,1),(203,126,1,2),(204,126,2,2),(205,131,1,2),(206,131,2,2),(207,132,1,2),(208,132,2,1),(209,133,1,1),(210,133,2,1),(211,134,1,1),(212,134,2,2),(213,135,1,2),(214,135,2,2),(215,136,1,2),(216,136,2,1),(217,137,1,1),(218,137,2,1),(219,138,1,1),(220,138,2,2),(221,139,1,2),(222,139,2,2),(225,141,1,2),(226,141,2,1),(227,142,1,1),(228,142,2,1),(229,143,1,1),(230,143,2,2),(231,145,1,2),(232,145,2,2),(233,146,1,1),(234,146,2,1),(235,147,1,1),(236,147,2,1),(237,148,1,2),(238,148,2,2),(239,149,1,2),(240,149,2,1),(241,150,1,1),(242,150,2,1),(243,152,1,1),(244,152,2,1),(245,153,1,1),(246,153,2,1),(247,154,1,2),(248,154,2,2),(249,155,1,2),(250,155,2,2),(251,156,1,2),(252,156,2,2),(253,157,1,2),(254,157,2,1),(255,158,1,1),(256,158,2,1),(259,161,1,2),(260,161,2,2),(261,162,1,1),(262,162,2,1),(263,163,1,2),(264,163,2,2),(265,164,1,1),(266,164,2,1),(267,165,1,2),(268,165,2,2),(269,166,1,1),(270,166,2,1),(271,167,1,1),(272,168,1,2),(274,170,1,2),(275,171,1,4),(276,171,9,4),(277,172,3,1),(278,173,5,4),(279,173,10,10),(280,173,1,2),(281,173,12,3),(282,173,6,14),(283,173,9,1),(284,174,6,14),(285,174,5,1),(305,194,9,1),(306,194,1,1),(307,194,5,3),(308,194,10,1),(309,194,11,1),(310,195,1,1),(311,196,5,4),(312,197,5,1),(313,198,1,1),(314,199,1,1),(315,199,9,1),(316,199,3,1),(317,200,1,1),(318,201,1,1),(319,202,5,1),(320,203,1,1),(321,204,9,1),(322,205,13,4),(323,206,3,1),(324,206,1,1),(325,206,9,1),(326,206,10,1),(327,206,5,2),(328,206,2,1),(329,207,1,14),(330,208,5,1),(331,208,10,1),(332,208,1,1),(333,208,2,1),(334,209,1,1),(335,209,12,1),(336,210,1,1),(337,211,1,4);
/*!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,
  `open_from` time DEFAULT NULL,
  `open_to` time DEFAULT NULL,
  `joining_date` date DEFAULT NULL,
  `contact_number` int(11) DEFAULT NULL,
  PRIMARY KEY (`booking_types_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 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,'00:20:21','00:20:21',NULL,NULL),(2,'Previous Bookings',1,NULL,NULL,NULL,NULL),(3,'Cancelled Bookings',1,NULL,NULL,NULL,NULL),(4,'Ongoing',1,NULL,NULL,NULL,NULL);
/*!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=52 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,1,'08:00:00','21:00:00','2021-01-23',212228897),(2,'StylooBranch1','Kelaniya',1,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',1,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),(51,'Styloo America','America',1,1,'08:00:00','20:00:00','2022-03-20',222218988);
/*!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'
--

--
-- Dumping routines for database 'styloo_booking'
--
/*!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
