--
-- Host: localhost    Database: styloo_test
-- ------------------------------------------------------


--
-- Table structure for table `additional_info_details`
--

CREATE TABLE `additional_info_details` (
  `additional_info_details_id` int(11) NOT NULL,
  `heading` varchar(200) DEFAULT NULL,
  `sub_heading` varchar(300) DEFAULT NULL,
  `summary_text` varchar(500) DEFAULT NULL,
  `img_url` varchar(100) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  `page_name` enum('HOME','ABOUT US') DEFAULT NULL,
  `tag_name` enum('INTRO','ABOUT US') DEFAULT NULL,
  `img_url_1` varchar(100) DEFAULT NULL,
  `img_url_2` varchar(100) DEFAULT NULL,
  `img_url_3` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`additional_info_details_id`),
  KEY `additional_info_details_idx` (`core_details_id`),
  CONSTRAINT `additional_info_details_fk1` FOREIGN KEY (`core_details_id`) REFERENCES `core_details` (`core_details_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `additional_info_details`
--

INSERT INTO `additional_info_details` VALUES (1,'Styloo','Styloo Services','Hair Cut @ Testing','D:/opt/styloo/salon/logo.png',1,1,'HOME','INTRO',NULL,NULL,NULL),(2,'Styloo','Styloo Services','Hair Cut','D:/opt/styloo/salon/logo.png',1,1,'HOME','ABOUT US',NULL,NULL,NULL),(3,'Styloo','Styloo Services','Hair Cut @ Testing','D:/opt/styloo/salon/logo.png',1,1,'HOME','INTRO',NULL,NULL,NULL);

--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `banner_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `sub_title1` varchar(100) DEFAULT NULL,
  `sub_title2` varchar(100) DEFAULT NULL,
  `sub_title3` varchar(100) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  `image_url` varchar(1500) DEFAULT NULL,
  PRIMARY KEY (`banner_id`),
  KEY `banner_fk1_idx` (`core_details_id`),
  CONSTRAINT `banner_fk1` FOREIGN KEY (`core_details_id`) REFERENCES `core_details` (`core_details_id`)
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `banner`
--

INSERT INTO `banner` VALUES (1,'title 1',' title 1',' title 1',' title 1',1,1,'/opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload/http://77.68.28.88:32449/http://77.68.28.88:32449/http://77.68.28.88:32449/http://77.68.28.88:32449/url 1'),(2,'title 2','title 2','title 2','title 2',1,1,'url 2'),(3,'title 3','title 3','title 3','title 1',1,2,'/opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload/url 3'),(4,'Styloo1','Sample title 1','Sample title 2','Sample title 3',1,1,'/opt/userimageupload/D:/opt/styloo/salon/logo.png'),(10,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(11,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(12,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(55,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'/opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload//opt/userimageupload/D:/opt/styloo/salon/logo.png'),(56,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(57,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(58,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(59,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(60,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(61,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(62,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(63,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(64,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(65,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(66,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(67,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(72,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(73,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(74,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(75,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(76,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(81,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(91,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(92,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(93,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(95,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'D:/opt/styloo/salon/logo.png'),(122,'Styloo','Sample title 1',NULL,NULL,NULL,NULL,'Julie.png'),(123,'Styloo','Sample title 1',NULL,NULL,NULL,NULL,'Julie.png'),(124,'Styloo','Sample title 1',NULL,NULL,NULL,NULL,'/opt/stylooimageupload/Julie.png'),(125,'Styloo','Sample title 1',NULL,NULL,NULL,NULL,'image/user_image/Julie.png'),(126,'Styloo','Sample title 1',NULL,NULL,NULL,NULL,'Julie.png'),(127,'Styloo','Sample title 1','Sample title 2','Sample title 3',NULL,1,'/opt/userimageupload//puppy.jpg'),(128,'Styloo','Sample title 1','Sample title 2','Sample title 3',NULL,1,'/opt/userimageupload/puppy.jpg'),(129,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'/opt/userimageupload/puppy.jpg'),(130,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'/opt/userimageupload/puppy.jpg'),(131,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'/opt/userimageupload/puppy.jpg');

--
-- Table structure for table `career`
--

CREATE TABLE `career` (
  `career_id` int(11) NOT NULL AUTO_INCREMENT,
  `job_title` varchar(100) DEFAULT NULL,
  `job_category` varchar(100) DEFAULT NULL,
  `job_type` varchar(100) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  `branch_details_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`career_id`),
  KEY `career_fk1_idx` (`core_details_id`),
  CONSTRAINT `career_fk1` FOREIGN KEY (`core_details_id`) REFERENCES `core_details` (`core_details_id`)
) ENGINE=InnoDB AUTO_INCREMENT=264 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `career`
--

INSERT INTO `career` VALUES (1,'Hair Dressser','Hair Stylist','PART_TIME',NULL,1,1),(2,'Hair Stylist','Category2','FULL_TIME',1,1,1),(3,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(4,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(5,'Hair Stylist','Hair','Hair',1,NULL,1),(6,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(9,'Keeka','Keeka','Keeka',1,1,1),(10,'Keeka','Keeka','Keeka',1,1,1),(35,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(36,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(37,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(80,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(81,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(82,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(83,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(84,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(85,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(86,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(87,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(88,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(89,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(90,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(91,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(92,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(97,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(98,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(99,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(100,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(101,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(106,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(116,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(117,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(118,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(120,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(197,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(198,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(199,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(200,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(201,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(202,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(203,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(204,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(205,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(206,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(207,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(208,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(209,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(210,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(211,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(215,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(218,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(219,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(220,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(221,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(222,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(223,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(224,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(225,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(226,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(227,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(228,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(229,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(230,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(231,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(232,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(233,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(234,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(235,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(236,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(237,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(238,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(239,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(240,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(241,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(242,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(243,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(244,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(245,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(246,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(247,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(248,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(249,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(250,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(251,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(252,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(253,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(254,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(255,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(256,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(257,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1),(260,'Hair Dressser','Hair Stylist','PART_TIME',1,1,1);

--
-- Table structure for table `category_service_details`
--

CREATE TABLE `category_service_details` (
  `category_service_details_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_type_id` int(11) DEFAULT NULL,
  `service_details_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`category_service_details_id`),
  KEY `category_service_details_fk1_idx` (`service_details_id`),
  CONSTRAINT `category_service_details_fk1` FOREIGN KEY (`service_details_id`) REFERENCES `service_details` (`service_details_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category_service_details`
--


--
-- Table structure for table `client`
--

CREATE TABLE `client` (
  `client_id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(45) DEFAULT NULL,
  `last_name` varchar(45) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `logo` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`client_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `client`
--

INSERT INTO `client` VALUES (1,'Keerthi','Rangan',1,'Resolved.png');

--
-- Table structure for table `core_details`
--

CREATE TABLE `core_details` (
  `core_details_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `primary_contact_no` int(11) DEFAULT NULL,
  `secondary_contact_no` int(11) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `twitter` varchar(100) DEFAULT NULL,
  `facebook` varchar(100) DEFAULT NULL,
  `logo` varchar(100) DEFAULT NULL,
  `display_name` varchar(100) DEFAULT NULL,
  `registered_date` date DEFAULT NULL,
  `exposable_id` varchar(6) DEFAULT NULL,
  `quote` varchar(500) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `is_platform` int(11) DEFAULT NULL,
  PRIMARY KEY (`core_details_id`),
  UNIQUE KEY `exposable_id_UNIQUE` (`exposable_id`)
) ENGINE=InnoDB AUTO_INCREMENT=377 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `core_details`
--

INSERT INTO `core_details` VALUES (1,'Styloo','Colombo',768909223,767721452,'jenny@gmail.com','@styloo','Styloo','/opt/styloo//opt/styloo//opt/styloo//opt/styloo//opt/styloo//opt/styloo/D:/opt/styloo/salon/logo.png','Styloo',NULL,'','Styloo Salon',1,1),(2,'Mirror Mirror','Colombo',762345765,761264889,'mirror2019@gmail.com','@mirrorMirror','mirrorsalon','mirror','Mirror-Mirror','2021-12-06',NULL,NULL,NULL,1),(5,'Styles','Colombo',762345765,761264889,'styles@gmail.com','@mirrorMirror','styles','mirror','Mirror','2021-12-07',NULL,NULL,NULL,1),(10,'Tresses','Colombo 7',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','/opt/userimageupload/tresses','tresses',NULL,NULL,'tressess',1,0),(12,'Line1','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'bUumCw','tressess',1,0),(13,'Sleek','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'qZFTmQ','tressess',1,0),(14,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'F$p&9j','tressess',1,0),(15,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'IaC#W0','tressess',1,0),(16,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'jQd0U@','tressess',1,0),(17,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'G7SJFm','tressess',1,0),(18,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'nT1j98','tressess',1,0),(19,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'6BYUab','tressess',1,0),(20,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'%6PkJv','tressess',1,0),(21,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'hlZ%EG','tressess',1,0),(22,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'YTNjbE','tressess',1,0),(23,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'4q!BoN','tressess',1,0),(24,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'4Ndwo2','tressess',1,0),(25,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'ioW0Sn','tressess',1,0),(26,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'qvkv##','tressess',1,0),(27,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'J5m4Gu','tressess',1,0),(28,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'!dflQu','tressess',1,0),(29,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'2m9tVq','tressess',1,0),(30,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'EYV!JE','tressess',1,0),(31,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'RWaAaT','tressess',1,0),(32,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'Vi2Y!@','tressess',1,0),(33,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'CBb9C5','tressess',1,0),(34,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'UbVGDL','tressess',1,0),(35,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'omMT#H','tressess',1,0),(36,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'LpxnqE','tressess',1,0),(37,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'kS9i0h','tressess',1,0),(38,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'Rl2qLe','tressess',1,0),(39,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'od@uNZ','tressess',1,0),(40,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'yJG0y#','tressess',1,0),(41,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'7OK&vh','tressess',1,0),(42,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'BTdN&8','tressess',1,0),(43,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'LuoUvn','tressess',1,0),(44,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'6%ArzM','tressess',1,0),(45,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'kg#U!S','tressess',1,0),(46,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'SJvwGK','tressess',1,0),(47,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'7a&R6Q','tressess',1,0),(48,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'gmtyTF','tressess',1,0),(49,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'ZKhJ2l','tressess',1,0),(50,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'uwDBgO','tressess',1,0),(51,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'VAsgh9','tressess',1,0),(52,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'BYG2TL','tressess',1,0),(53,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'ei20Wm','tressess',1,0),(54,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'CAAz&e','tressess',1,0),(55,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'drKprB','tressess',1,0),(56,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'DZSWBE','tressess',1,0),(57,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'5hjq&v','tressess',1,0),(58,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'pzQZhX','tressess',1,0),(59,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'Y7XWSG','tressess',1,0),(60,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'SXHXGf','tressess',1,0),(61,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'IdBqRR','tressess',1,0),(62,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'4Zkrz4','tressess',1,0),(63,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'h#rvHg','tressess',1,0),(64,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'kn4hsI','tressess',1,0),(65,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'mHsc06','tressess',1,0),(66,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'t@xc#3','tressess',1,0),(67,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'sZAMWr','tressess',1,0),(68,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'$VZ7#e','tressess',1,0),(69,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'G2aKrq','tressess',1,0),(70,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'zZrG1U','tressess',1,0),(71,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'yJR@90','tressess',1,0),(72,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'NXsp6Z','tressess',1,0),(73,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'WKxPOd','tressess',1,0),(74,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'OX9lyn','tressess',1,0),(75,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'63QPg!','tressess',1,0),(76,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'dQB1YD','tressess',1,0),(77,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'ZCj5Me','tressess',1,0),(78,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'qtw9Jm','tressess',1,0),(87,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'4hfy2V','tressess',1,0),(88,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'djmqMt','tressess',1,0),(89,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'Uq1PJX','tressess',1,0),(90,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'Qg@Au9','tressess',1,0),(91,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'9qjtt5','tressess',1,0),(92,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'!qz0Xx','tressess',1,0),(94,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'Aoz0M2','tressess',1,0),(95,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'T7@xNK','tressess',1,0),(98,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'CGjAg4','tressess',1,0),(101,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'c8rxcl','tressess',1,0),(102,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'ZCB93q','tressess',1,0),(103,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'0t4%TH','tressess',1,0),(104,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'5D5YpB','tressess',1,0),(106,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'sjj20w','tressess',1,0),(107,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'E5U1Xq','tressess',1,0),(108,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'2H@pbA','tressess',1,0),(109,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'rKjIOo','tressess',1,0),(110,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'!%6kKJ','tressess',1,0),(111,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'ob!sCz','tressess',1,0),(112,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'rXXKxe','tressess',1,0),(113,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'AeOW39','tressess',1,0),(114,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'xFDA8I','tressess',1,0),(115,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'Y#Hqyy','tressess',1,0),(116,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'qyU@MS','tressess',1,0),(117,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'!i6TDO','tressess',1,0),(118,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'ObNteO','tressess',1,0),(119,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'hLZW2l','tressess',1,0),(120,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'BNh4s&','tressess',1,0),(121,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'AB8fil','tressess',1,0),(122,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'i!!MpH','tressess',1,0),(123,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'cfke7v','tressess',1,0),(127,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'SIJJ9E','tressess',1,0),(128,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'Ggh%zM','tressess',1,0),(129,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'T5WWxp','tressess',1,0),(131,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'TRNL3c','tressess',1,0),(132,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'Z42!ee','tressess',1,0),(133,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'BuyU%d','tressess',1,0),(134,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'bHxloK','tressess',1,0),(136,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'u3gugN','tressess',1,0),(137,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'RC2D5A','tressess',1,0),(138,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'6a3H07','tressess',1,0),(144,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'8wSQWq','tressess',1,0),(145,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'fuMEI!','tressess',1,0),(146,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'FKEGMb','tressess',1,0),(189,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'zaM7Rv','tressess',1,0),(190,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'4m!cfx','tressess',1,0),(191,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'Cx52y#','tressess',1,0),(192,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'saLUQW','tressess',1,0),(193,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'fuGUyQ','tressess',1,0),(194,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'G@ofj&','tressess',1,0),(195,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'cR$KdM','tressess',1,0),(196,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'kADEnL','tressess',1,0),(197,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'Bz4x1s','tressess',1,0),(198,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'1h3B8q','tressess',1,0),(199,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'E6QpaZ','tressess',1,0),(200,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'vmqWfS','tressess',1,0),(201,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'M1JnX4','tressess',1,0),(206,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'oKvWDg','tressess',1,0),(207,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'xP59FC','tressess',1,0),(208,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'tNhATj','tressess',1,0),(209,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'lTS8c6','tressess',1,0),(210,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'NCEups','tressess',1,0),(215,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'urlN$y','tressess',1,0),(225,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'he!HJ5','tressess',1,0),(226,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'OTmjLB','tressess',1,0),(227,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'6f4oSF','tressess',1,0),(229,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'f5ALkD','tressess',1,0),(305,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'n@@!6$','tressess',1,0),(306,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'UJ0b@T','tressess',1,0),(307,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'0T3tYC','tressess',1,0),(308,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'Hm7#qX','tressess',1,0),(309,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'1d5kud','tressess',1,0),(310,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'npRFNL','tressess',1,0),(311,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'doklnL','tressess',1,0),(312,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'g0M$C#','tressess',1,0),(313,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'7tv37y','tressess',1,0),(314,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'Q@#u9Y','tressess',1,0),(315,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'wP&$Gr','tressess',1,0),(316,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'v2U0y8','tressess',1,0),(317,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'68kwg1','tressess',1,0),(318,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'6e@Qim','tressess',1,0),(319,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'9KNugT','tressess',1,0),(320,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'V#sdEt','tressess',1,0),(321,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'vc1ndg','tressess',1,0),(322,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'gQqtlI','tressess',1,0),(323,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'axD075','tressess',1,0),(324,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'ZcU$TU','tressess',1,0),(325,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'EDjK07','tressess',1,0),(326,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'!DP!ub','tressess',1,0),(330,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'lqw%xU','tressess',1,0),(333,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'62!M8Y','tressess',1,0),(334,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'pWOLd2','tressess',1,0),(335,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'YcC4Uz','tressess',1,0),(336,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'si5bPU','tressess',1,0),(337,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'T%x&PI','tressess',1,0),(338,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'cD2&IR','tressess',1,0),(339,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'%9fehj','tressess',1,0),(340,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'McKYen','tressess',1,0),(341,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'fFPW!o','tressess',1,0),(342,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'Nad0kN','tressess',1,0),(343,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'GOqqJm','tressess',1,0),(344,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'8JUfh6','tressess',1,0),(345,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'mUuLi2','tressess',1,0),(346,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'$NOZwS','tressess',1,0),(347,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'JVmOoc','tressess',1,0),(348,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'9KeWH0','tressess',1,0),(349,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'RIKS$Q','tressess',1,0),(350,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'TVu$fR','tressess',1,0),(351,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'jn4WI%','tressess',1,0),(352,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'2i7jc@','tressess',1,0),(353,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'GlgbYP','tressess',1,0),(354,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'J93ix6','tressess',1,0),(355,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'VGXjgk','tressess',1,0),(356,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'JY1Dkq','tressess',1,0),(357,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'vRIQzz','tressess',1,0),(358,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'rpR$Vd','tressess',1,0),(359,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'D5jn1y','tressess',1,0),(360,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'$@Lh&v','tressess',1,0),(361,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'vgggje','tressess',1,0),(362,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'eRuPTz','tressess',1,0),(363,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'vq1ZqQ','tressess',1,0),(364,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'55wHYm','tressess',1,0),(365,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'uF$C@0','tressess',1,0),(366,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'@sPdwy','tressess',1,0),(367,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'r0fhCP','tressess',1,0),(368,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'NbI64V','tressess',1,0),(369,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'ku9$Sb','tressess',1,0),(370,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'O@RiXb','tressess',1,0),(371,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'py2eBU','tressess',1,0),(374,'Tresses','Colombo',762345879,761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'9VoAQA','tressess',1,0);

--
-- Table structure for table `employee`
--

CREATE TABLE `employee` (
  `employee_id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `contact_number` int(11) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `specialised_in` varchar(100) DEFAULT NULL,
  `service_desc` varchar(100) DEFAULT NULL,
  `Salary` double DEFAULT NULL,
  `joined_data` date DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `is_probation` int(11) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `gender` varchar(45) DEFAULT NULL,
  `experience` int(11) DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  `img_url` varchar(1000) DEFAULT NULL,
  `branch_details_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`employee_id`),
  KEY `employee_fk1_idx` (`core_details_id`),
  CONSTRAINT `employee_fk1` FOREIGN KEY (`core_details_id`) REFERENCES `core_details` (`core_details_id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `employee`
--

INSERT INTO `employee` VALUES (1,'Jeyapriya','Malathy','Mannar',771111774,'jeyapriya@gmail.com',NULL,'Hair Cutting',NULL,'2022-02-13',1,NULL,NULL,NULL,NULL,1,NULL,1),(2,'Abi','Man','Colombo',12345678,'abi@gmail.com',NULL,'Hair Coloring',NULL,'2022-02-13',1,NULL,NULL,NULL,NULL,1,NULL,1),(3,'Keerthi','Rangan','Jaffna',766438634,'keerthi@gmail.com',NULL,NULL,NULL,'2022-02-13',1,NULL,NULL,NULL,NULL,2,NULL,1),(4,'Pavi','Kapi','Jaffna',779773023,'pavi@gmail.com',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,2,NULL,1),(5,'Shamali','Pathirana','Colombo',775566890,'sha123@gmail.com',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,2,NULL,1),(6,'Isuru','Pathirana',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'Isuru','Pathirana',NULL,715624654,'isurupathirana@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,'/opt/styloo/null',1),(8,'Isuru','Pathirana',NULL,715624654,'isurupathirana@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,'/opt/styloo/null',1),(9,'Isuru','Pathirana',NULL,715624654,'isurupathirana@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,'/opt/styloo/null',1),(10,'Isuru','Pathirana',NULL,715624654,'isurupathirana@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,'/opt/styloo/null',1),(11,'Isuru','Pathirana',NULL,715624654,'isurupathirana@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,'/opt/styloo/null',1),(12,'Isuru','Pathirana',NULL,715624654,'isurupathirana@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,'/opt/styloo/null',1),(13,'Nihal','Silva',NULL,715624654,'nihalperera90@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,NULL,1),(14,'Nihal','Perera',NULL,715624654,'nihalperera90@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,'/opt/styloo/null',1),(15,'Nihal','Perera',NULL,715624654,'nihalperera90@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,'/opt/styloo/null',1),(16,'Nihal','Perera',NULL,715624654,'nihalperera90@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,'/opt/styloo/null',1),(17,'Nihal','Perera',NULL,715624654,'nihalperera90@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,'/opt/styloo/null',1),(18,'Nihal','Perera',NULL,715624654,'nihalperera90@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,NULL,1),(19,'Isuru','Pathirana',NULL,715624654,'isurupathirana@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,'/opt/userimageupload/tin tin.jpg',1),(21,'Isuru','Pathirana',NULL,715624654,'isurupathirana@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,NULL,1),(22,'Isuru','Pathirana',NULL,715624654,'isurupathirana@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,NULL,1),(23,'Kasun','Perera',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,NULL,NULL);

--
-- Table structure for table `employee_h`
--

CREATE TABLE `employee_h` (
  `employee_id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `contact_number` int(11) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `specialised_in` varchar(100) DEFAULT NULL,
  `service_desc` varchar(100) DEFAULT NULL,
  `Salary` double DEFAULT NULL,
  `joined_data` date DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `is_probation` int(11) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `gender` varchar(45) DEFAULT NULL,
  `experience` int(11) DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  `img_url` varchar(1000) DEFAULT NULL,
  `service_details_id` int(11) DEFAULT NULL,
  `updated_date` date DEFAULT NULL,
  `updated_time` time DEFAULT NULL,
  PRIMARY KEY (`employee_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `employee_h`
--

INSERT INTO `employee_h` VALUES (1,'Jeyapriya','Malathy','Mannar',771111774,'jeyapriya@gmail.com',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,1,NULL,1,'2021-12-02','12:00:00'),(2,'Abi','Man','Colombo',12345678,'abi@gmail.com',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,1,NULL,1,'2021-12-20','12:00:00');

--
-- Table structure for table `employee_leave_details`
--

CREATE TABLE `employee_leave_details` (
  `employee_leave_details_id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) DEFAULT NULL,
  `leave_type_id` int(11) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `from_date` date DEFAULT NULL,
  `from_time` time DEFAULT NULL,
  `to_date` date DEFAULT NULL,
  `to_time` time DEFAULT NULL,
  PRIMARY KEY (`employee_leave_details_id`),
  KEY `em_leave_details_fk1_idx` (`employee_id`),
  KEY `em_leave_details_fk2_idx` (`leave_type_id`),
  CONSTRAINT `em_leave_details_fk1` FOREIGN KEY (`employee_id`) REFERENCES `employee` (`employee_id`),
  CONSTRAINT `em_leave_details_fk2` FOREIGN KEY (`leave_type_id`) REFERENCES `leave_type` (`leave_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `employee_leave_details`
--

INSERT INTO `employee_leave_details` VALUES (1,1,1,1,'2022-02-13','09:00:00','2022-02-20','13:00:00'),(2,2,2,1,'2022-02-10','08:00:00','2022-02-13','08:00:00'),(3,3,1,1,'2022-02-15','08:00:00','2022-02-17','08:00:00'),(4,4,1,1,'2022-02-13','09:00:00','2022-02-20','13:00:00'),(5,5,1,0,'2022-02-14','08:00:00','2022-02-20','08:00:00');

--
-- Table structure for table `employee_skills_details`
--

CREATE TABLE `employee_skills_details` (
  `employee_skills_dateils_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_type_id` int(11) DEFAULT NULL,
  `sub_category_details_id` int(11) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`employee_skills_dateils_id`),
  KEY `employee_skills_datails_fk1_idx` (`employee_id`),
  KEY `employee_skills_datails_fk2_idx` (`sub_category_details_id`),
  CONSTRAINT `employee_skills_details_fk1` FOREIGN KEY (`employee_id`) REFERENCES `employee` (`employee_id`),
  CONSTRAINT `employee_skills_details_fk2` FOREIGN KEY (`sub_category_details_id`) REFERENCES `sub_category_details` (`sub_category_details_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `employee_skills_details`
--

INSERT INTO `employee_skills_details` VALUES (1,1,1,1),(2,1,1,1),(3,1,1,2),(4,1,1,18),(5,2,1,18),(6,1,1,13),(7,2,1,13),(8,1,1,13),(9,2,1,13),(10,1,1,13),(11,2,1,13);

--
-- Table structure for table `explore`
--

CREATE TABLE `explore` (
  `explore_id` int(11) NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `content` varchar(200) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `image_url` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`explore_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `explore`
--

INSERT INTO `explore` VALUES (1,'title1','content1',1,'url1');

--
-- Table structure for table `favourite`
--

CREATE TABLE `favourite` (
  `favourite_id` int(11) NOT NULL AUTO_INCREMENT,
  `service_details_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`favourite_id`),
  KEY `favorite_fk1_idx` (`user_id`),
  KEY `favorite_fk2_idx` (`core_details_id`),
  KEY `favorite_fk3_idx` (`service_details_id`),
  CONSTRAINT `favorite_fk1` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`),
  CONSTRAINT `favorite_fk2` FOREIGN KEY (`core_details_id`) REFERENCES `core_details` (`core_details_id`),
  CONSTRAINT `favorite_fk3` FOREIGN KEY (`service_details_id`) REFERENCES `service_details` (`service_details_id`)
) ENGINE=InnoDB AUTO_INCREMENT=494 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `favourite`
--

INSERT INTO `favourite` VALUES (1,1,1,1),(2,1,1,1),(3,1,1,1),(4,1,1,1),(5,1,1,2),(6,1,1,2),(7,1,1,2),(8,1,1,2),(9,1,1,2),(10,1,1,2),(11,1,1,2),(12,1,1,2),(13,1,1,2),(14,1,1,2),(15,1,1,2),(16,1,1,2),(22,1,1,2),(23,1,1,2),(25,1,1,2),(26,1,1,2),(28,1,1,2),(29,1,1,2),(30,1,1,2),(31,1,1,2),(33,1,1,2),(34,1,1,2),(35,1,1,1),(36,1,1,2),(37,1,1,2),(39,1,1,2),(40,1,1,2),(42,1,1,2),(43,1,1,2),(47,1,1,2),(48,1,1,2),(49,1,1,2),(50,1,1,2),(51,1,1,2),(52,1,1,2),(53,1,1,2),(54,1,1,2),(55,1,1,2),(56,1,1,2),(57,1,1,2),(58,1,1,2),(59,1,1,2),(60,1,1,2),(61,1,1,2),(62,1,1,2),(63,1,1,2),(64,1,1,2),(65,1,1,2),(66,1,1,2),(67,1,1,2),(68,1,1,2),(69,1,1,2),(70,1,1,2),(79,1,1,2),(80,1,1,2),(81,1,1,2),(82,1,1,2),(83,1,1,2),(84,1,1,2),(85,1,1,2),(86,1,1,2),(87,1,1,2),(88,1,1,2),(89,1,1,2),(90,1,1,2),(92,1,1,2),(93,1,1,2),(94,1,1,2),(95,1,1,2),(98,1,1,2),(99,1,1,2),(102,1,1,2),(103,1,1,2),(104,1,1,2),(105,1,1,2),(106,1,1,2),(107,1,1,2),(108,1,1,2),(109,1,1,2),(111,1,1,2),(112,1,1,2),(113,1,1,2),(114,1,1,2),(115,1,1,2),(116,1,1,2),(117,1,1,2),(118,1,1,2),(119,1,1,2),(120,1,1,2),(121,1,1,2),(122,1,1,2),(123,1,1,2),(124,1,1,2),(125,1,1,2),(126,1,1,2),(127,1,1,2),(128,1,1,2),(129,1,1,2),(130,1,1,2),(131,1,1,2),(132,1,1,2),(133,1,1,2),(134,1,1,2),(135,1,1,2),(136,1,1,2),(137,1,1,2),(138,1,1,2),(139,1,1,2),(140,1,1,2),(141,1,1,2),(142,1,1,2),(143,1,1,2),(144,1,1,2),(145,1,1,2),(146,1,1,2),(147,1,1,2),(148,1,1,2),(152,1,1,2),(153,1,1,2),(154,1,1,2),(155,1,1,2),(156,1,1,2),(157,1,1,2),(159,1,1,2),(160,1,1,2),(161,1,1,2),(162,1,1,2),(163,1,1,2),(164,1,1,2),(165,1,1,2),(166,1,1,2),(168,1,1,2),(169,1,1,2),(170,1,1,2),(171,1,1,2),(172,1,1,2),(173,1,1,2),(179,1,1,2),(180,1,1,2),(181,1,1,2),(182,1,1,2),(183,1,1,2),(184,1,1,2),(227,1,1,2),(228,1,1,2),(229,1,1,2),(230,1,1,2),(231,1,1,2),(232,1,1,2),(233,1,1,2),(234,1,1,2),(235,1,1,2),(236,1,1,2),(237,1,1,2),(238,1,1,2),(239,1,1,2),(240,1,1,2),(241,1,1,2),(242,1,1,2),(243,1,1,2),(244,1,1,2),(245,1,1,2),(246,1,1,2),(247,1,1,2),(248,1,1,2),(249,1,1,2),(250,1,1,2),(251,1,1,2),(252,1,1,2),(257,1,1,2),(258,1,1,2),(259,1,1,2),(260,1,1,2),(261,1,1,2),(262,1,1,2),(263,1,1,2),(264,1,1,2),(265,1,1,2),(266,1,1,2),(271,1,1,2),(272,1,1,2),(282,1,1,2),(283,1,1,2),(284,1,1,2),(285,1,1,2),(286,1,1,2),(287,1,1,2),(289,1,1,2),(290,1,1,2),(366,1,1,2),(367,1,1,2),(368,1,1,2),(369,1,1,2),(370,1,1,2),(371,1,1,2),(372,1,1,2),(373,1,1,2),(374,1,1,2),(375,1,1,2),(376,1,1,2),(377,1,1,2),(378,1,1,2),(379,1,1,2),(380,1,1,2),(381,1,1,2),(382,1,1,2),(383,1,1,2),(384,1,1,2),(385,1,1,2),(386,1,1,2),(387,1,1,2),(388,1,1,2),(389,1,1,2),(390,1,1,2),(391,1,1,2),(392,1,1,2),(393,1,1,2),(394,1,1,2),(395,1,1,2),(396,1,1,2),(397,1,1,2),(398,1,1,2),(399,1,1,2),(400,1,1,2),(401,1,1,2),(402,1,1,2),(403,1,1,2),(407,1,1,2),(408,1,1,2),(411,1,1,2),(412,1,1,2),(413,1,1,2),(414,1,1,2),(415,1,1,2),(416,1,1,2),(417,1,1,2),(418,1,1,2),(419,1,1,2),(420,1,1,2),(421,1,1,2),(422,1,1,2),(423,1,1,2),(424,1,1,2),(425,1,1,2),(426,1,1,2),(427,1,1,2),(428,1,1,2),(429,1,1,2),(430,1,1,2),(431,1,1,2),(432,1,1,2),(433,1,1,2),(434,1,1,2),(435,1,1,2),(436,1,1,2),(437,1,1,2),(438,1,1,2),(439,1,1,2),(440,1,1,2),(441,1,1,2),(442,1,1,2),(443,1,1,2),(444,1,1,2),(445,1,1,2),(446,1,1,2),(447,1,1,2),(448,1,1,2),(449,1,1,2),(450,1,1,2),(451,1,1,2),(452,1,1,2),(453,1,1,2),(454,1,1,2),(455,1,1,2),(456,1,1,2),(457,1,1,2),(458,1,1,2),(459,1,1,2),(460,1,1,2),(461,1,1,2),(462,1,1,2),(463,1,1,2),(464,1,1,2),(465,1,1,2),(466,1,1,2),(467,1,1,2),(468,1,1,2),(469,1,1,2),(470,1,1,2),(471,1,1,2),(472,1,1,2),(473,1,1,2),(474,1,1,2),(475,1,1,2),(476,1,1,2),(477,1,1,2),(478,1,1,2),(479,1,1,2),(480,1,1,2),(481,1,1,2),(482,1,1,2),(483,1,1,2),(484,1,1,2),(485,1,1,2),(486,1,1,2),(489,1,1,2),(490,1,1,2);

--
-- Table structure for table `gallery_details`
--

CREATE TABLE `gallery_details` (
  `gallery_details_id` int(11) NOT NULL,
  `heading` varchar(200) DEFAULT NULL,
  `sub_heading` varchar(300) DEFAULT NULL,
  `summary_text` varchar(500) DEFAULT NULL,
  `img_url` varchar(100) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `page_name` enum('Gallery') DEFAULT NULL,
  `set_type` int(11) DEFAULT NULL,
  `is_vedio` int(11) DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  `img_url_1` varchar(100) DEFAULT NULL,
  `img_url_2` varchar(100) DEFAULT NULL,
  `img_url_3` varchar(100) DEFAULT NULL,
  `video_url` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`gallery_details_id`),
  KEY `gallery_details_fk1_idx` (`core_details_id`),
  CONSTRAINT `gallery_details_fk1` FOREIGN KEY (`core_details_id`) REFERENCES `core_details` (`core_details_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `gallery_details`
--

INSERT INTO `gallery_details` VALUES (1,'Explore our gallery and know about our trends','gallery','_binary ','',0,'Gallery',1,0,1,NULL,NULL,NULL,NULL);

--
-- Table structure for table `gender_types_service_details`
--

CREATE TABLE `gender_types_service_details` (
  `gender_types_service_details_id` int(11) NOT NULL AUTO_INCREMENT,
  `gender_type_id` int(11) DEFAULT NULL,
  `service_details_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`gender_types_service_details_id`),
  KEY `gender_types_service_details_fk1_idx` (`service_details_id`),
  CONSTRAINT `gender_types_service_details_fk1` FOREIGN KEY (`service_details_id`) REFERENCES `service_details` (`service_details_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gender_types_service_details`
--

INSERT INTO `gender_types_service_details` VALUES (1,1,2),(2,2,1),(3,2,3);

--
-- Table structure for table `leave_type`
--

CREATE TABLE `leave_type` (
  `leave_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `leave_type_desc` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`leave_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `leave_type`
--

INSERT INTO `leave_type` VALUES (1,'Medical'),(2,'Casual'),(3,'Marriage');

--
-- Table structure for table `notification_details`
--

CREATE TABLE `notification_details` (
  `notification_details_id` int(11) NOT NULL AUTO_INCREMENT,
  `message` varchar(300) DEFAULT NULL,
  `notified_on` date DEFAULT NULL,
  `is_dismissed` int(11) DEFAULT NULL,
  `notified_by` int(11) DEFAULT NULL,
  `notified_to` int(11) DEFAULT NULL,
  `notification_type_id` int(11) DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`notification_details_id`),
  KEY `notification_details_fk1_idx` (`notified_by`),
  KEY `notification_details_fk2_idx` (`notified_to`),
  KEY `notification_details_fk2_idx1` (`notification_type_id`),
  KEY `notification_details_fk3_idx` (`core_details_id`),
  CONSTRAINT `notification_details_fk1` FOREIGN KEY (`notified_by`) REFERENCES `user` (`user_id`),
  CONSTRAINT `notification_details_fk2` FOREIGN KEY (`notified_to`) REFERENCES `user` (`user_id`),
  CONSTRAINT `notification_details_fk4` FOREIGN KEY (`notification_type_id`) REFERENCES `notification_type` (`notification_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `notification_details`
--

INSERT INTO `notification_details` VALUES (1,'testing','2021-01-15',0,1,2,1,1),(2,'testing','2021-01-14',0,1,2,1,1);

--
-- Table structure for table `notification_type`
--

CREATE TABLE `notification_type` (
  `notification_type_id` int(11) NOT NULL,
  `notification_type` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`notification_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `notification_type`
--

INSERT INTO `notification_type` VALUES (1,'type1'),(2,'type2');

--
-- Table structure for table `privilege`
--

CREATE TABLE `privilege` (
  `privilege_id` int(11) NOT NULL AUTO_INCREMENT,
  `privilege_code` varchar(250) NOT NULL,
  `privilege_description` varchar(300) DEFAULT NULL,
  `heading` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`privilege_id`)
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `privilege`
--

INSERT INTO `privilege` VALUES (1,'TEST_PRIV_UPD',NULL,NULL),(2,'CORE_SHOW_ADDED_CUSTOMER','CORE_SHOW_ADDED_CUSTOMER','CUSTOMER_MANAGE'),(3,'CORE_SHOW_BOOKINGS','CORE_SHOW_BOOKINGS','BOOKING_MANAGE'),(4,'CORE_SHOW_CANCELLED_BOOKINGS','CORE_SHOW_CANCELLED_BOOKINGS','CANCELLED_BOOKINGS'),(5,'PLATFORM_BOOKING','PLATFORM_BOOKING','BOOKING_MANAGES'),(85,'TEST_PRIV2',NULL,'HEADING1'),(86,'TEST_PRIV1',NULL,'HEADING1'),(87,'TEST_PRIV1',NULL,'HEADING1'),(88,'TEST_PRIV1',NULL,'HEADING1'),(89,'TEST_PRIV1',NULL,'HEADING1'),(90,'TEST_PRIV1',NULL,'HEADING1'),(91,'TEST_PRIV1',NULL,'HEADING1'),(92,'TEST_PRIV1',NULL,'HEADING1'),(93,'TEST_PRIV1',NULL,'HEADING1'),(94,'TEST_PRIV1',NULL,'HEADING1'),(95,'TEST_PRIV1',NULL,'HEADING1'),(96,'TEST_PRIV1',NULL,'HEADING1'),(97,'TEST_PRIV1',NULL,'HEADING1'),(98,'TEST_PRIV1',NULL,'HEADING1'),(99,'TEST_PRIV1',NULL,'HEADING1'),(100,'TEST_PRIV1',NULL,'HEADING1'),(101,'TEST_PRIV1',NULL,'HEADING1'),(102,'TEST_PRIV1',NULL,'HEADING1'),(103,'TEST_PRIV1',NULL,'HEADING1'),(104,'TEST_PRIV1',NULL,'HEADING1'),(105,'TEST_PRIV1',NULL,'HEADING1'),(106,'TEST_PRIV1',NULL,'HEADING1'),(107,'TEST_PRIV1',NULL,'HEADING1'),(110,'TEST_PRIV1',NULL,'HEADING1');

--
-- Table structure for table `role`
--

CREATE TABLE `role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(45) DEFAULT NULL,
  `role_description` varchar(255) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=218 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `role`
--

INSERT INTO `role` VALUES (1,'Test role updated','Test role updated',NULL),(2,'Customer','Customer',1),(3,'Platform Admin','Platform Admin',1),(22,'test role','test role',1),(23,'test role','test role1',1),(170,'Test role','Test role',NULL),(171,'Test role','Test role',NULL),(172,'Test role','Test role',NULL),(173,'Test role','Test role',NULL),(174,'Test role','Test role',NULL),(175,'Test role','Test role',NULL),(176,'Test role','Test role',NULL),(177,'Test role','Test role',NULL),(178,'Test role','Test role',NULL),(179,'Test role','Test role',NULL),(180,'Test role','Test role',NULL),(181,'Test role','Test role',NULL),(182,'Test role','Test role',NULL),(183,'Test role','Test role',NULL),(184,'Test role','Test role',NULL),(185,'Test role','Test role',NULL),(186,'Test role','Test role',NULL),(187,'Test role','Test role',NULL),(188,'Test role','Test role',NULL),(189,'Test role','Test role',NULL),(190,'Test role','Test role',NULL),(191,'Test role','Test role',NULL),(192,'Test role','Test role',NULL),(193,'Test role','Test role',NULL),(194,'Test role','Test role',NULL),(195,'Test role','Test role',NULL),(196,'Test role','Test role',NULL),(197,'Test role','Test role',NULL),(198,'Test role','Test role',NULL),(199,'Test role','Test role',NULL),(200,'Test role','Test role',NULL),(201,'Test role','Test role',NULL),(202,'Test role','Test role',NULL),(203,'Test role','Test role',NULL),(204,'Test role','Test role',NULL),(205,'Test role','Test role',NULL),(206,'Test role','Test role',NULL),(211,'Test role','Test role',NULL);

--
-- Table structure for table `role_privilege`
--

CREATE TABLE `role_privilege` (
  `role_privilege_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `privilege_id` int(11) NOT NULL,
  `is_active` int(11) DEFAULT NULL,
  `heading` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`role_privilege_id`),
  KEY `fk_role_privilege_1_idx` (`privilege_id`),
  KEY `fk_role_privilege_2_idx` (`role_id`),
  CONSTRAINT `fk_role_privilege_privilege` FOREIGN KEY (`privilege_id`) REFERENCES `privilege` (`privilege_id`),
  CONSTRAINT `fk_role_privilege_role` FOREIGN KEY (`role_id`) REFERENCES `role` (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=215 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `role_privilege`
--

INSERT INTO `role_privilege` VALUES (1,1,1,1,'SALOON_MANAGE'),(2,1,2,1,'CUSTOMER_MANAGE'),(3,1,3,1,'BOOKING_MANAGE'),(4,1,4,1,'CANCELLED_BOOKINGS'),(17,1,1,1,'test heading'),(164,1,1,NULL,NULL),(165,1,1,NULL,NULL),(166,1,1,NULL,NULL),(167,1,1,NULL,NULL),(168,1,1,NULL,NULL),(169,1,1,NULL,NULL),(170,1,1,NULL,NULL),(171,1,1,NULL,NULL),(172,1,1,NULL,NULL),(173,1,1,NULL,NULL),(174,1,1,NULL,NULL),(175,1,1,NULL,NULL),(176,1,1,NULL,NULL),(177,1,1,NULL,NULL),(178,1,1,NULL,NULL),(179,1,1,NULL,NULL),(180,1,1,NULL,NULL),(181,1,1,NULL,NULL),(182,1,1,NULL,NULL),(183,1,1,NULL,NULL),(184,1,1,NULL,NULL),(185,1,1,NULL,NULL),(186,1,1,NULL,NULL),(187,1,1,NULL,NULL),(188,1,1,NULL,NULL),(189,1,1,NULL,NULL),(190,1,1,NULL,NULL),(191,1,1,NULL,NULL),(192,1,1,NULL,NULL),(193,1,1,NULL,NULL),(194,1,1,NULL,NULL),(195,1,1,NULL,NULL),(196,1,1,NULL,NULL),(197,1,1,NULL,NULL),(198,1,1,NULL,NULL),(199,1,1,NULL,NULL),(200,1,1,NULL,NULL),(201,1,1,NULL,NULL),(202,1,1,NULL,NULL),(203,1,1,NULL,NULL),(208,1,1,NULL,NULL);

--
-- Table structure for table `salon_visions`
--

CREATE TABLE `salon_visions` (
  `salon_vision_id` int(11) NOT NULL AUTO_INCREMENT,
  `heading` varchar(200) DEFAULT NULL,
  `sub_heading` varchar(300) DEFAULT NULL,
  `summary_text` varchar(500) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`salon_vision_id`),
  KEY `salon_visions_fk1_idx` (`core_details_id`),
  CONSTRAINT `salon_visions_fk1` FOREIGN KEY (`core_details_id`) REFERENCES `core_details` (`core_details_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `salon_visions`
--

INSERT INTO `salon_visions` VALUES (1,'Experienced','specialist','text1',1,1),(2,'Natural','remedies','text2',1,1),(3,'Modern','equipment','text3',1,1);

--
-- Table structure for table `service_details`
--

CREATE TABLE `service_details` (
  `service_details_id` int(11) NOT NULL AUTO_INCREMENT,
  `service_name` varchar(100) DEFAULT NULL,
  `service_content` varchar(200) DEFAULT NULL,
  `service_price` double DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `service_master_details_id` int(11) DEFAULT NULL,
  `category_type_id` int(11) DEFAULT NULL,
  `img_url` varchar(1000) DEFAULT NULL,
  `discount` double DEFAULT NULL,
  `sub_category_details_id` int(11) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`service_details_id`),
  KEY `service_details_fk1_idx` (`service_master_details_id`),
  KEY `service_details_fk2_idx` (`sub_category_details_id`),
  KEY `service_details_fk3_idx` (`employee_id`),
  CONSTRAINT `service_details_fk1` FOREIGN KEY (`service_master_details_id`) REFERENCES `service_master_details` (`service_master_details_id`),
  CONSTRAINT `service_details_fk2` FOREIGN KEY (`sub_category_details_id`) REFERENCES `sub_category_details` (`sub_category_details_id`),
  CONSTRAINT `service_details_fk3` FOREIGN KEY (`employee_id`) REFERENCES `employee` (`employee_id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `service_details`
--

INSERT INTO `service_details` VALUES (1,'Hair','Hair',100,1,1,1,NULL,0.5,1,1),(2,'Hair','Hair',25,1,2,1,NULL,0.15,1,1),(3,'Hair Cut','Test',100,1,3,1,NULL,NULL,1,1),(4,'Hair','Hair',500,1,1,NULL,NULL,0.1,NULL,NULL),(5,'Facial','Test2',25,0,5,2,NULL,NULL,2,NULL),(7,'Hair Cutting','Hair Cutting',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(9,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(10,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(11,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(12,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(13,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(14,'Hair Rebonding','Hair Rebonding',1200,1,1,1,'img_url1234',0.15,1,1),(15,'Hair Rebonding','Hair Rebonding',1200,1,9,1,'img_url1234',0.15,1,1),(16,'Hair Coloring','Hair Coloring',1200,1,9,1,'img_url1234',0.15,1,1),(17,'Hair Rebonding','Hair Rebonding',1200,1,1,1,'img_url1234',0.15,1,1),(18,'Hair Rebonding','Hair Rebonding',1200,1,17,1,'img_url1234',0.15,1,1),(19,'Hair Coloring','Hair Coloring',1200,1,17,1,'img_url1234',0.15,1,1),(20,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(21,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(22,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(23,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(24,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(25,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(26,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(27,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(28,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(29,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(30,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(31,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(32,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(33,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(34,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(35,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(36,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(37,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(38,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(39,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(40,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(41,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(42,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(43,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(44,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(45,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(46,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(47,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(48,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(49,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(50,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(51,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(52,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(53,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(54,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(55,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(56,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(57,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(58,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(59,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(60,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(61,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(62,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(63,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(64,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(65,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(66,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(67,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(68,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(69,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(70,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(71,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(72,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(73,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(74,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(75,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(76,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(77,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1),(78,'Hair Cutting','Hair Cutting',1200,1,1,1,'img_url1234',0.15,1,1);

--
-- Table structure for table `service_master_details`
--

CREATE TABLE `service_master_details` (
  `service_master_details_id` int(11) NOT NULL AUTO_INCREMENT,
  `service_heading` varchar(200) DEFAULT NULL,
  `service_sub_heading` varchar(300) DEFAULT NULL,
  `summary_text` varchar(500) DEFAULT NULL,
  `img_url` varchar(100) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  `branch_details_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`service_master_details_id`),
  KEY `service_master_details_FK1_idx` (`core_details_id`),
  CONSTRAINT `service_master_details_FK1` FOREIGN KEY (`core_details_id`) REFERENCES `core_details` (`core_details_id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `service_master_details`
--

INSERT INTO `service_master_details` VALUES (1,'Head1','sub head1','test','D:/opt/styloo/salon/logo.png',1,1,1),(2,'Head2','sub head2','test2',NULL,1,2,1),(3,'Head3','sub head3','test3',NULL,1,2,1),(4,NULL,NULL,NULL,NULL,NULL,2,1),(5,NULL,NULL,NULL,NULL,NULL,2,1),(6,NULL,NULL,NULL,NULL,NULL,2,1),(7,NULL,NULL,NULL,NULL,1,NULL,1),(8,'Facial Massage','Facial Message','Facial Message','url3',1,NULL,1),(9,'Facial Massage','Facial Message','Facial Message','url3',1,1,1),(17,'Facial Massage','Facial Message','Facial Message','url3',1,5,1);

--
-- Table structure for table `sub_category_details`
--

CREATE TABLE `sub_category_details` (
  `sub_category_details_id` int(11) NOT NULL,
  `category_type_id` int(11) DEFAULT NULL,
  `sub_category_name` varchar(300) DEFAULT NULL,
  `sub_category_desc` varchar(500) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  PRIMARY KEY (`sub_category_details_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `sub_category_details`
--

INSERT INTO `sub_category_details` VALUES (1,1,'Hair Cut','Hair Cutting',1),(2,1,'Hair Colour','Hair Colouring',1),(3,1,'Hair Rebonding','Hair',1);

--
-- Table structure for table `testimonial_details`
--

CREATE TABLE `testimonial_details` (
  `testimonial_details_id` int(11) NOT NULL,
  `heading` varchar(200) DEFAULT NULL,
  `sub_heading` varchar(300) DEFAULT NULL,
  `summary_text` varchar(500) DEFAULT NULL,
  `img_url` varchar(100) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `owner_name` varchar(100) DEFAULT NULL,
  `posted_date` date DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  `img_url_1` varchar(100) DEFAULT NULL,
  `img_url_2` varchar(100) DEFAULT NULL,
  `img_url_3` varchar(100) DEFAULT NULL,
  `img_url_4` varchar(100) DEFAULT NULL,
  `img_url_5` varchar(100) DEFAULT NULL,
  `img_url_6` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`testimonial_details_id`),
  KEY `testimonial_details_fk1_idx` (`core_details_id`),
  CONSTRAINT `testimonial_details_fk1` FOREIGN KEY (`core_details_id`) REFERENCES `core_details` (`core_details_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonial_details`
--

INSERT INTO `testimonial_details` VALUES (1,'testimonial','That is what people says about our awesome services','Lorem ipsum dolor sit',NULL,1,'Jane Cooper','2021-12-01',1,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `user_login_details`
--

CREATE TABLE `user_login_details` (
  `user_login_details_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(250) DEFAULT NULL,
  `user_ip` varchar(100) DEFAULT NULL,
  `login_date` date DEFAULT NULL,
  `login_time` time DEFAULT NULL,
  `is_success` int(11) DEFAULT NULL,
  `invalid_login_count` int(11) DEFAULT NULL,
  PRIMARY KEY (`user_login_details_id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `user_login_details`
--

INSERT INTO `user_login_details` VALUES (4,'styloo@gmail.com','0:0:0:0:0:0:0:1','2021-12-02','06:02:00',1,0),(5,'malathy@gmail.com','127.0.0.1','2022-04-19','08:00:20',1,0),(6,'test@gmail.com','0:0:0:0:0:0:0:1','2022-04-05','15:58:09',1,0),(7,'anon@test.com','127.0.0.1','2022-04-19','06:04:01',0,252),(8,'shamali@test.com','0:0:0:0:0:0:0:1','2022-01-17','09:38:27',0,0);

--
-- Table structure for table `user_login_details_h`
--

CREATE TABLE `user_login_details_h` (
  `user_login_details_h_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(250) DEFAULT NULL,
  `user_ip` varchar(100) DEFAULT NULL,
  `login_date` date DEFAULT NULL,
  `login_time` time DEFAULT NULL,
  `is_success` int(11) DEFAULT NULL,
  `user_login_details_id` int(11) NOT NULL,
  PRIMARY KEY (`user_login_details_h_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `user_login_details_h`
--


--
-- Table structure for table `user_privilege`
--

CREATE TABLE `user_privilege` (
  `user_privilege_id` int(11) NOT NULL,
  `privilege_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  PRIMARY KEY (`user_privilege_id`),
  KEY `user_privilege_fk1_idx` (`privilege_id`),
  KEY `user_privilege_fk2_idx` (`user_id`),
  CONSTRAINT `user_privilege_fk1` FOREIGN KEY (`privilege_id`) REFERENCES `privilege` (`privilege_id`),
  CONSTRAINT `user_privilege_fk2` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_privilege`
--

INSERT INTO `user_privilege` VALUES (1,1,1,1);

--
-- Table structure for table `user_role`
--

CREATE TABLE `user_role` (
  `user_role_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `assigned_user_id` int(11) NOT NULL,
  `start_date` date DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `assign_date` date DEFAULT NULL,
  PRIMARY KEY (`user_role_id`),
  KEY `fk_user_role_1_idx` (`role_id`),
  KEY `fk_user_role_2_idx` (`user_id`),
  KEY `fk_user_role_3_idx` (`assigned_user_id`),
  CONSTRAINT `fk_user_role_1` FOREIGN KEY (`role_id`) REFERENCES `role` (`role_id`),
  CONSTRAINT `fk_user_role_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`),
  CONSTRAINT `fk_user_role_3` FOREIGN KEY (`assigned_user_id`) REFERENCES `user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_role`
--

INSERT INTO `user_role` VALUES (1,1,1,1,'2022-01-02','2023-10-01','2022-01-04'),(2,2,2,2,'2022-01-02','2023-10-01','2022-01-04');

--
-- Table structure for table `user_type`
--

CREATE TABLE `user_type` (
  `user_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_type` varchar(45) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  PRIMARY KEY (`user_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_type`
--

INSERT INTO `user_type` VALUES (1,'Customer','Customer',1),(2,'Platform Admin','Platform Admin',1),(3,'Individual Admin','Individual Admin',1),(4,'Platform Customer','Platform Customer',1);

--
-- Dumping events for database 'styloo_test'
--

--
-- Dumping routines for database 'styloo_test'
--


