--
-- Host: localhost    Database: styloo
-- ------------------------------------------------------


--
-- 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(1000) 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=utf8mb4;

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

INSERT INTO `additional_info_details` VALUES (3,'About Us','beauty is about being comfortable in your own skin','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ut purus vitae arcu pellentesque lobortis non non sem. Suspendisse dictum mi leo, eget venenatis lacus suscipit tristique. Praesent interdum risus ac pharetra porttitor.','image/styloo-img/1.png',1,1,'HOME','ABOUT US','image/styloo-img/3.png','image/styloo-img/4.png','image/styloo-img/5.png'),(4,'Styloo','Glow your face & vitality with our best service','Facial & skin care teartment, hair cutting. @ Waxing & other forms of hair removal, nail treatments. @ Waxing & other forms of hair removal, nail treatments.','image/styloo-img/1.png',1,1,'HOME','INTRO','image/styloo-img/3.png','image/styloo-img/4.png','image/styloo-img/5.png'),(6,'About Us','award winning beauty salon','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ut purus vitae arcu pellentesque lobortis non non sem. Suspendisse dictum mi leo, eget venenatis lacus suscipit tristique. Praesent interdum risus ac pharetra porttitor. Pellentesque nec mi sit amet velit euismod luctus.','image/styloo-img/15.png',1,1,'ABOUT US','INTRO','image/styloo-img/3.png','image/styloo-img/4.png','image/styloo-img/5.png');

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

CREATE TABLE `banner` (
  `banner_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) DEFAULT NULL,
  `sub_title1` varchar(250) DEFAULT NULL,
  `sub_title2` varchar(250) DEFAULT NULL,
  `sub_title3` varchar(250) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  `image_url` varchar(250) 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=32 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `banner` VALUES (1,'Styloo','Sample title 1','Sample title 2','Sample title 3',1,1,'http://10.20.100.6/bannerImage/b1.jpg'),(2,'tilte 2','tilte 2','tilte 2','tilte 2',1,1,'http://10.20.100.6/bannerImage/b2.jpg'),(30,'Styloo Banner','Sample title 7','Sample title 7','Sample title 7',1,1,'http://10.20.100.6/bannerImage/b2.jpg'),(31,'At excepteur qui und','Quisquam ad alias au','Commodo doloremque i','Sed minima vitae tot',1,1,'http://10.20.100.6/bannerImage/icons8-expand-arrow-96.png');

--
-- 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=44 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `career` VALUES (1,'aaaa','bbb','ccc',0,1,2),(2,'ddd','eee','fff',1,1,1),(3,'ggg','hhh','iii',0,1,1),(6,'Keeka','Keeka','Keeka',0,1,1),(9,'Pavi','Pavi','Pavi',0,1,1),(11,NULL,'1','Part Time',1,1,1),(17,NULL,'1','Part Time',0,1,1),(34,NULL,'1','Part Time',1,1,1),(35,NULL,'1','Part Time',1,1,1),(36,NULL,'2','Full Time',0,1,1),(38,NULL,'1','Part Time',1,1,1),(39,NULL,'1','Part Time',1,1,1),(40,NULL,'1','Part Time',1,1,1),(41,NULL,'1','Part Time',0,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` varchar(100) 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=76 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `core_details` VALUES (1,'Styloo','Colombo','766543456',767721452,'Info@styloo.com','@styloo','Styloo','image/styloo-img/Logo.png','Styloo','2021-11-30','','we provide beauty and treatment services with best quality, believe us.',1,0),(2,'Mirror Mirror',NULL,'762345765',761264889,'mirror2019@gmail.com','@mirrorMirror','mirrorsalon','mirror','Mirror-Mirror','2021-12-06',NULL,NULL,NULL,0),(5,'Styles','Colombo','762345765',761264889,'styles@gmail.com','@mirrorMirror','styles','mirror','Mirror-Mirror','2021-12-07',NULL,NULL,NULL,0),(10,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses','2021-12-02','A7gbkD','tressess',1,0),(12,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'bUumCw','tressess',1,0),(13,'Mirror Mirror','Dehiwala','762345765',761264889,'mirror2019@gmail.com','@mirrorMirror','mirrorsalon','mirror','Mirror-Mirror',NULL,'cICPiC',NULL,NULL,0),(14,'Mirror Mirror','Dehiwala','762345765',761264889,'mirror2019@gmail.com','@mirrorMirror','mirrorsalon','mirror','Mirror-Mirror',NULL,'&qga5X','Mirror',1,1),(15,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'W&i2Et','tressess',1,0),(16,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'K8$$ez','tressess',1,0),(17,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'Ut1FRR','tressess',1,0),(18,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'YDW$i8','tressess',1,0),(19,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'7GpHtU','tressess',1,0),(20,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'w4wehi','tressess',1,0),(21,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'tZ9iPc','tressess',1,0),(22,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'EZiIw@','tressess',1,0),(23,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'jb@%qX','tressess',1,0),(24,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'CyD2Hu','tressess',1,0),(25,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'k990sh','tressess',1,0),(26,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'o3Dh@j','tressess',1,0),(27,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'j2ybzS','tressess',1,0),(28,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'NuXnc&','tressess',1,0),(29,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'hC8Wfc','tressess',1,0),(30,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'oW!a&H','tressess',1,0),(31,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'8UOhOs','tressess',1,0),(32,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'XTPxQN','tressess',1,0),(33,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'@792Pz','tressess',1,0),(34,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'cL%64p','tressess',1,0),(35,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'#ZOCW7','tressess',1,0),(36,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'NoA36X','tressess',1,0),(37,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'IjEsLV','tressess',1,0),(38,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'hoEQVK','tressess',1,0),(39,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'df&6CG','tressess',1,0),(40,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'G1oZaH','tressess',1,0),(41,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'098CqO','tressess',1,0),(42,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'Q7xS5f','tressess',1,0),(43,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'ukFLb@','tressess',1,0),(44,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'jEDxrs','tressess',1,0),(45,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'LCJp0c','tressess',1,0),(46,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'kCdmuo','tressess',1,0),(47,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'p%zsa@','tressess',1,0),(48,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'ZnH96F','tressess',1,0),(49,'Tresses','Colombo','762345879',761264229,'tresses@gmail.com','@hairwizad','tresses','tresses','tresses',NULL,'1FebWl','tressess',1,0),(71,'Wella','Dehiwala','762345765',761264889,'wella@gmail.com','@Wella','Wella','mirror','Wella-Mirror',NULL,'8G5rVF',NULL,NULL,NULL),(73,'Cuckoo','Dehiwala','762345765',761264889,'cuckoo@gmail.com','@Cuckoo','Cuckoo','mirror','Cuckoo-Mirror',NULL,'3uwZmy',NULL,NULL,NULL),(74,'Cuckoo','Dehiwala','762345765',761264889,'cuckoo@gmail.com','@Cuckoo','Cuckoo','mirror','Cuckoo-Mirror',NULL,'sXpxg2',NULL,NULL,NULL);

--
-- 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(300) 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,'Keerthi','Rangan','Puttur',779773023,'keekiran@icloud.com','Hair Stylist','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ut purus vitae arcu pellentesque lobortis non non sem. Suspendisse dictum mi leo, eget venenatis lacus suscipit tristique. Praesent interdum risus ac pharetra porttitor.',10000,'2021-07-01',1,1,'1997-03-15','Female',7,1,'http://10.20.100.6/employeeImage/1g.png',1),(2,'Ragavan','Siva','Mathugama',77987867,'si@yahoo.com','Makeup Artist','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ut purus vitae arcu pellentesque lobortis non non sem. Suspendisse dictum mi leo, eget venenatis lacus suscipit tristique. Praesent interdum risus ac pharetra porttitor.',30000,'2021-12-10',1,1,'1996-09-21','female',2,1,'http://10.20.100.6/employeeImage/2.jpg',1),(3,'Jathusan','Vive','Mathugama',76543657,'vive@yahoo.com','Manicurist','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ut purus vitae arcu pellentesque lobortis non non sem. Suspendisse dictum mi leo, eget venenatis lacus suscipit tristique. Praesent interdum risus ac pharetra porttitor.',30000,'2021-01-10',1,1,'1996-09-21','female',2,1,'http://10.20.100.6/employeeImage/3.png',1),(4,'Keerthiga','Rangan','Mathugama',77097868,'keeka@yahoo.com','Manicurist','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ut purus vitae arcu pellentesque lobortis non non sem. Suspendisse dictum mi leo, eget venenatis lacus suscipit tristique. Praesent interdum risus ac pharetra porttitor.',30000,'2021-07-19',1,1,'1996-09-21','female',2,1,'http://10.20.100.6/employeeImage/2g.png',1),(7,'Pavithira','Kapilan','Puttur',778500803,'pavikapi@icloud.com','Skin Therapist','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ut purus vitae arcu pellentesque lobortis non non sem. Suspendisse dictum mi leo, eget venenatis lacus suscipit tristique. Praesent interdum risus ac pharetra porttitor.',100000,'2022-07-21',1,1,'1993-03-15','Female',7,1,'http://10.20.100.6/employeeImage/3g.jpg',1),(10,'Suja','Kuga','Puttur',778500804,'suja@icloud.com','Skin Therapist','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ut purus vitae arcu pellentesque lobortis non non sem. Suspendisse dictum mi leo, eget venenatis lacus suscipit tristique. Praesent interdum risus ac pharetra porttitor.',100000,'2022-07-21',1,1,'1993-03-15','Female',7,1,'http://10.20.100.6/employeeImage/4g.jpg',1),(14,'Renu','Kuga','Puttur',778500804,'renu@icloud.com','Skin','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ut purus vitae arcu pellentesque lobortis non non sem. Suspendisse dictum mi leo, eget venenatis lacus suscipit tristique. Praesent interdum risus ac pharetra porttitor.',100000,'2022-07-21',1,1,'1993-03-15','Female',7,1,'http://10.20.100.6/employeeImage/4g.jpg',NULL),(15,'Suja','Kuga','Puttur',778500804,'sujasdsdsdsd@icloud.com','Skin','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ut purus vitae arcu pellentesque lobortis non non sem. Suspendisse dictum mi leo, eget venenatis lacus suscipit tristique. Praesent interdum risus ac pharetra porttitor.',100000,'2022-07-21',1,1,'1993-03-15','Female',7,1,'http://10.20.100.6/employeeImage/icons8-chevron-down-96.png',NULL),(19,'A ut enim sit minim ','Non nostrud fugiat ','Consequatur Rerum v',766931072,'sobynonaj@mailinator.com','Hair Colour','Hair Colour',70,'2022-08-17',1,0,'2022-08-24','1',66,2,'http://10.20.100.6/employeeImage/logo (4).png',NULL),(20,'Nihal','Perera',NULL,715624654,'nihalperera90@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,'http://10.20.100.6/employeeImage/Keerthi.png',1),(21,'Nihale','Perera',NULL,715624654,'nihalee@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,'http://10.20.100.6/employeeImage/7g.png',1),(22,'Nihale','Perera',NULL,715624654,'nihalee@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,'http://10.20.100.6/employeeImage/7g.png',1),(23,'Nihal','Perera',NULL,715624654,'nihalperera90@gmail.com','Hair Cutting','Hair Cutting',45000,'2022-01-15',1,1,'2000-09-12','male',1,1,'http://10.20.100.6/employeeImage/Keerthi.png',1);

--
-- 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=5 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `employee_leave_details` VALUES (1,1,1,1,'2022-07-10','09:00:00','2022-07-22','13:00:00'),(2,2,2,1,'2022-07-10','08:00:00','2022-07-22','08:00:00'),(3,4,1,1,'2022-03-31','08:00:00','2022-04-01','08:00:00'),(4,1,1,1,'2022-02-13','08:00:00','2022-03-31','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=9 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `employee_skills_details` VALUES (1,1,1,1),(2,2,4,2),(3,3,5,3),(4,2,1,4),(5,2,4,1),(6,3,2,1),(7,1,1,23),(8,2,1,23);

--
-- 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 `favourite_fk1` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`),
  CONSTRAINT `favourite_fk2` FOREIGN KEY (`core_details_id`) REFERENCES `core_details` (`core_details_id`),
  CONSTRAINT `favourite_fk3` FOREIGN KEY (`service_details_id`) REFERENCES `service_details` (`service_details_id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `favourite` VALUES (1,1,1,1),(2,2,1,1),(3,3,1,1),(4,4,1,1),(5,5,1,1),(6,6,1,1),(7,1,1,1),(8,1,1,1),(9,1,1,1),(10,1,1,1),(11,1,1,1),(12,1,1,1),(13,1,1,1),(14,1,1,1),(15,1,1,1),(16,1,1,1),(17,1,1,1),(18,1,1,1),(19,1,1,1),(42,1,1,1),(43,1,1,1);

--
-- 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(500) 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,'Gallery','Explore our gallery and know about our trends','gallery','image/styloo-img/29.png',0,'Gallery',1,0,1,'image/styloo-img/6.png','image/styloo-img/7.png','image/styloo-img/8.png',NULL),(2,'Gallery2','Explore our gallery and know about our trends','gallery','image/styloo-img/30.png',0,'Gallery',1,0,1,NULL,NULL,NULL,NULL),(3,'Gallery3','Explore our gallery and know about our trends','gallery','image/styloo-img/31.png',0,'Gallery',1,0,1,NULL,NULL,NULL,NULL),(4,'Gallery4','Explore our gallery and know about our trends','gallery','image/styloo-img/32.png',0,'Gallery',1,0,1,NULL,NULL,NULL,NULL),(5,'Gallery5','Explore our gallery and know about our trends','gallery',NULL,0,'Gallery',1,1,1,NULL,NULL,NULL,'http://commondatastorage.googleapis.com/gtv-videos-bucket/sample/BigBuckBunny.mp4'),(6,'Gallery6','Explore our gallery and know about our trends','gallery','image/styloo-img/33.png',0,'Gallery',2,0,1,NULL,NULL,NULL,NULL),(7,'Gallery7','Explore our gallery and know about our trends','gallery','image/styloo-img/34.png',0,'Gallery',2,0,1,NULL,NULL,NULL,NULL),(8,'Gallery8','Explore our gallery and know about our trends','gallery','image/styloo-img/35.png',0,'Gallery',2,0,1,NULL,NULL,NULL,NULL),(9,'Gallery9','Explore our gallery and know about our trends','gallery','image/styloo-img/36.png',0,'Gallery',2,0,1,NULL,NULL,NULL,NULL),(10,'Gallery10','Explore our gallery and know about our trends','gallery',NULL,0,'Gallery',2,1,1,NULL,NULL,NULL,'http://commondatastorage.googleapis.com/gtv-videos-bucket/sample/ElephantsDream.mp4');

--
-- 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=7 DEFAULT CHARSET=utf8mb4;

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

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

--
-- 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=3 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `leave_type` VALUES (1,'Sick'),(2,'Personal');

--
-- 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_fk3` FOREIGN KEY (`core_details_id`) REFERENCES `core_details` (`core_details_id`),
  CONSTRAINT `notification_details_fk4` FOREIGN KEY (`notification_type_id`) REFERENCES `notification_type` (`notification_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `notification_details` VALUES (1,NULL,NULL,1,NULL,NULL,NULL,NULL),(2,NULL,NULL,1,NULL,NULL,NULL,NULL),(3,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut malesuada in tortor porttitor.',NULL,1,NULL,NULL,1,1),(4,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut malesuada in tortor porttitor.',NULL,1,NULL,NULL,1,1),(5,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut malesuada in tortor porttitor.',NULL,1,NULL,NULL,1,1),(6,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut malesuada in tortor porttitor.',NULL,1,NULL,NULL,1,1),(7,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut malesuada in tortor porttitor.',NULL,1,NULL,NULL,1,1),(8,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut malesuada in tortor porttitor.',NULL,1,NULL,NULL,3,1),(9,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut malesuada in tortor porttitor.',NULL,1,NULL,NULL,3,1),(10,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut malesuada in tortor porttitor.',NULL,1,NULL,NULL,3,1),(11,'New Employee Created',NULL,0,NULL,NULL,3,1),(12,'New Employee Created',NULL,0,NULL,NULL,3,1),(13,'New Employee Created',NULL,0,NULL,NULL,3,1),(14,'New Employee Created',NULL,0,NULL,NULL,3,1),(15,'test',NULL,NULL,NULL,NULL,NULL,NULL),(16,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(17,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(18,'New Employee Created',NULL,0,NULL,NULL,3,1),(19,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(20,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(21,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(22,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(23,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(24,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(25,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(26,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(27,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(28,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(29,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(30,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(31,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(32,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(33,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(34,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(35,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(36,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(37,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(38,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(39,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(40,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(41,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(42,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(43,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(44,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(45,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(46,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(47,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(48,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(49,'New Employee Created',NULL,0,NULL,NULL,3,1),(50,'New Employee Created',NULL,0,NULL,NULL,3,1),(51,'New Employee Created',NULL,0,NULL,NULL,3,1),(52,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(53,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(54,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(55,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(56,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(57,'New Employee Created',NULL,0,NULL,NULL,3,1),(58,'New Employee Created',NULL,0,NULL,NULL,3,2),(59,'New Employee Created',NULL,0,NULL,NULL,3,1),(60,'New Employee Created',NULL,0,NULL,NULL,3,1),(61,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(62,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(63,'New Booking Created',NULL,0,NULL,NULL,1,NULL),(64,'New Booking Created',NULL,0,NULL,NULL,1,NULL);

--
-- 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=utf8mb3;

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

INSERT INTO `notification_type` VALUES (1,'New Booking'),(2,'New Service'),(3,'New Employee');

--
-- 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=29 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `privilege` VALUES (1,'CORE_SHOW_ADDED_SALOON','CORE_SHOW_ADDED_SALOON','SALOON_MANAGE'),(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');

--
-- 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=50 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `role` VALUES (1,'Core_Admin','Core Admin',1);

--
-- 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=53 DEFAULT CHARSET=utf8mb3;

--
-- 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');

--
-- 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','specialists','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus.',1,1),(2,'-Natural','remedies','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus.',1,1),(3,'-Modern','equipment','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus.',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_idx` (`service_master_details_id`),
  KEY `service_details_fk3_idx` (`employee_id`),
  CONSTRAINT `service_details` FOREIGN KEY (`service_master_details_id`) REFERENCES `service_master_details` (`service_master_details_id`),
  CONSTRAINT `service_details_fk3` FOREIGN KEY (`employee_id`) REFERENCES `employee` (`employee_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `service_details` VALUES (1,'Layers','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus.',299,1,1,1,'image/styloo-img/20.png',NULL,1,1),(2,'Skincare & Facial','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus.',399,1,1,2,'image/styloo-img/21.png',NULL,1,1),(3,'Facial Massage','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus.',299,1,1,3,'image/styloo-img/22.png',NULL,1,1),(4,'Ultra & Facial','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus.',399,1,1,1,'image/styloo-img/23.png',NULL,1,1),(5,'Hair Tratments','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus.',299,1,1,2,'image/styloo-img/24.png',NULL,1,1),(6,'Hair Tratments','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus.',299,1,1,3,'image/styloo-img/25.png',NULL,1,1),(7,'Messy Wob','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus.',299,1,1,1,'image/styloo-img/26.png',NULL,1,1),(8,'Multi-layers For Long Hair','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus.',299,1,1,1,'image/styloo-img/27.png',NULL,1,1),(9,'Highlights','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus.',200,1,1,1,'image/styloo-img/27.png',NULL,2,1),(10,'Ombré','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus.',250,1,1,1,'image/styloo-img/27.png',NULL,2,1),(11,'Keratin treatment','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus.',300,1,1,1,'image/styloo-img/27.png',NULL,3,1),(12,'Straightening iron','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus.',400,1,1,1,'image/styloo-img/27.png',NULL,3,1),(13,'Free Deep cleansing','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus.',50,1,1,1,'image/styloo-img/27.png',NULL,4,1),(14,'Eyelash Perm','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus.',100,1,1,1,'image/styloo-img/27.png',NULL,5,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=2 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `service_master_details` VALUES (1,'we are experienced in making you more beautiful','beauty tratments','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin bibendum quis augue in tempus. In vitae facilisis quam, sit amet aliquet ante. Sed interdum fringilla turpis.','image/styloo-img/2.png',1,1,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 Cut',1),(2,1,'Hair Colour','Hair Colour',1),(3,1,'Hair Straightning','Hair Straightning',1),(4,2,'Body Massage','Body Massage',1),(5,2,'Body Whitening','Body Whitening',1),(6,3,'Skin Treatment','Skin Treatment',1),(7,4,'Nail Treatment','Nail Treatment',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=utf8mb4;

--
-- 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 amet, consectetur adipiscing elit. Fusce ut purus vitae arcu pellentesque lobortis non non sem. Suspendisse dictum mi leo, eget venenatis lacus suscipit tristique. Praesent interdum risus ac pharetra porttitor. Pellentesque nec mi sit amet velit euismod luctus.','image/styloo-img/9(1).png',1,'Jane Cooper','2021-12-01',1,'image/styloo-img/9.png','image/styloo-img/10.png','image/styloo-img/11.png','image/styloo-img/12.png','image/styloo-img/13.png','image/styloo-img/14.png'),(2,'Testimonial','That is what people says about our awesome services','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ut purus vitae arcu pellentesque lobortis non non sem. Suspendisse dictum mi leo, eget venenatis lacus suscipit tristique. Praesent interdum risus ac pharetra porttitor. Pellentesque nec mi sit amet velit euismod luctus.','image/styloo-img/9(1).png',1,'Jane Cooper','2021-12-01',1,'image/styloo-img/9.png','image/styloo-img/10.png','image/styloo-img/11.png','image/styloo-img/12.png','image/styloo-img/13.png','image/styloo-img/14.png'),(3,'Testimonial','That is what people says about our awesome services','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ut purus vitae arcu pellentesque lobortis non non sem. Suspendisse dictum mi leo, eget venenatis lacus suscipit tristique. Praesent interdum risus ac pharetra porttitor. Pellentesque nec mi sit amet velit euismod luctus.','image/styloo-img/9(1).png',1,'Jane Cooper','2021-12-01',1,'image/styloo-img/9.png','image/styloo-img/10.png','image/styloo-img/11.png','image/styloo-img/12.png','image/styloo-img/13.png','image/styloo-img/14.png');

--
-- Table structure for table `token`
--

CREATE TABLE `token` (
  `token_id` int(11) NOT NULL AUTO_INCREMENT,
  `token` varchar(45) NOT NULL,
  `token_type` varchar(20) NOT NULL,
  `created_date_time` datetime NOT NULL,
  `expired_date_time` datetime NOT NULL,
  `token_status` varchar(1) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`token_id`),
  KEY `token_fk_1_idx` (`user_id`),
  CONSTRAINT `token_fk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `token`
--

INSERT INTO `token` VALUES (2,'164695','RESET_PASSWORD','2021-12-23 10:37:47','2021-12-23 11:37:47','I',7),(3,'130519','RESET_PASSWORD','2021-12-23 16:55:41','2021-12-23 17:55:41','R',41),(4,'126468','RESET_PASSWORD','2021-12-23 17:12:13','2021-12-23 18:12:13','R',41),(5,'118791','RESET_PASSWORD','2021-12-23 17:21:06','2021-12-23 18:21:06','R',41),(6,'104417','RESET_PASSWORD','2021-12-23 17:30:23','2021-12-23 18:30:23','R',41),(7,'134521','RESET_PASSWORD','2021-12-24 12:45:43','2021-12-24 13:45:43','R',41),(8,'164529','RESET_PASSWORD','2021-12-24 12:56:20','2021-12-24 13:56:20','R',41),(9,'139923','RESET_PASSWORD','2021-12-24 12:59:49','2021-12-24 13:59:49','R',41),(10,'135052','RESET_PASSWORD','2021-12-24 13:07:52','2021-12-24 14:07:52','R',41),(11,'131145','RESET_PASSWORD','2021-12-24 13:12:12','2021-12-24 14:12:12','R',41),(12,'193002','RESET_PASSWORD','2021-12-24 15:02:33','2021-12-24 16:02:33','R',41),(13,'110243','RESET_PASSWORD','2022-01-04 05:18:39','2022-01-04 06:18:39','R',8),(14,'133405','RESET_PASSWORD','2022-01-06 09:23:27','2022-01-06 10:23:27','R',41),(15,'163402','RESET_PASSWORD','2022-01-06 09:23:27','2022-01-06 10:23:27','R',41),(16,'125593','RESET_PASSWORD','2022-01-06 09:23:27','2022-01-06 10:23:27','R',41),(17,'199748','RESET_PASSWORD','2022-01-06 09:23:33','2022-01-06 10:23:33','R',41),(18,'176146','RESET_PASSWORD','2022-01-06 09:24:05','2022-01-06 10:24:05','I',41),(19,'187827','RESET_PASSWORD','2022-01-06 10:51:02','2022-01-06 11:51:02','R',8),(20,'142633','RESET_PASSWORD','2022-01-06 11:08:05','2022-01-06 12:08:05','R',8),(21,'188770','RESET_PASSWORD','2022-01-06 11:08:34','2022-01-06 12:08:34','R',8),(22,'178665','RESET_PASSWORD','2022-01-06 11:08:43','2022-01-06 12:08:43','R',8),(23,'145039','RESET_PASSWORD','2022-01-06 11:58:19','2022-01-06 12:58:19','R',8),(24,'180078','RESET_PASSWORD','2022-01-06 12:21:08','2022-01-06 13:21:08','R',8),(25,'106784','RESET_PASSWORD','2022-01-06 12:44:59','2022-01-06 13:44:59','R',8),(26,'191172','RESET_PASSWORD','2022-01-06 12:45:42','2022-01-06 13:45:42','R',8),(27,'110818','RESET_PASSWORD','2022-01-06 12:46:53','2022-01-06 13:46:53','R',8),(28,'148637','RESET_PASSWORD','2022-01-06 12:48:45','2022-01-06 13:48:45','R',8),(29,'126453','RESET_PASSWORD','2022-01-06 12:49:10','2022-01-06 13:49:10','R',8),(30,'153764','RESET_PASSWORD','2022-01-06 13:11:10','2022-01-06 14:11:10','R',8),(31,'184110','RESET_PASSWORD','2022-01-07 03:29:26','2022-01-07 04:29:26','R',8),(32,'109678','RESET_PASSWORD','2022-01-07 03:30:30','2022-01-07 04:30:30','R',8),(33,'109220','RESET_PASSWORD','2022-01-12 05:11:45','2022-01-12 06:11:45','R',8),(34,'197692','RESET_PASSWORD','2022-01-12 05:34:51','2022-01-12 06:34:51','R',8),(35,'170358','RESET_PASSWORD','2022-01-12 05:49:33','2022-01-12 06:49:33','R',47),(36,'149329','RESET_PASSWORD','2022-01-18 04:08:36','2022-01-18 05:08:36','R',47),(37,'194568','RESET_PASSWORD','2022-01-18 04:10:04','2022-01-18 05:10:04','R',47),(38,'191042','RESET_PASSWORD','2022-01-18 10:14:22','2022-01-18 11:14:22','R',8),(39,'108768','RESET_PASSWORD','2022-01-19 04:10:06','2022-01-19 05:10:06','R',8),(40,'188645','RESET_PASSWORD','2022-01-19 04:35:58','2022-01-19 05:35:58','R',8),(41,'104043','RESET_PASSWORD','2022-01-19 04:36:45','2022-01-19 05:36:45','R',8),(42,'114721','RESET_PASSWORD','2022-01-19 04:38:24','2022-01-19 05:38:24','R',8),(43,'117318','RESET_PASSWORD','2022-01-19 04:39:56','2022-01-19 05:39:56','R',8),(44,'110917','RESET_PASSWORD','2022-01-19 04:58:57','2022-01-19 05:58:57','R',8),(45,'177451','RESET_PASSWORD','2022-01-19 11:32:50','2022-01-19 12:32:50','R',8),(46,'111508','RESET_PASSWORD','2022-01-19 11:35:43','2022-01-19 12:35:43','R',8),(47,'187219','RESET_PASSWORD','2022-01-19 13:41:33','2022-01-19 14:41:33','R',8),(48,'176195','RESET_PASSWORD','2022-01-19 13:46:04','2022-01-19 14:46:04','R',8),(49,'129355','RESET_PASSWORD','2022-01-19 13:50:02','2022-01-19 14:50:02','R',8),(50,'149388','RESET_PASSWORD','2022-01-19 13:51:06','2022-01-19 14:51:06','R',8),(51,'113556','RESET_PASSWORD','2022-01-19 13:57:41','2022-01-19 14:57:41','R',8),(52,'121135','RESET_PASSWORD','2022-01-20 04:06:06','2022-01-20 05:06:06','R',8),(53,'100975','RESET_PASSWORD','2022-01-20 04:18:23','2022-01-20 05:18:23','R',8),(54,'100719','RESET_PASSWORD','2022-01-20 04:22:01','2022-01-20 05:22:01','R',8),(55,'147399','RESET_PASSWORD','2022-01-20 05:35:37','2022-01-20 06:35:37','R',8),(56,'126083','RESET_PASSWORD','2022-01-20 05:41:16','2022-01-20 06:41:16','R',47),(57,'183374','RESET_PASSWORD','2022-01-21 04:44:54','2022-01-21 05:44:54','R',47),(58,'105797','RESET_PASSWORD','2022-01-21 05:49:19','2022-01-21 06:49:19','R',47),(59,'196825','RESET_PASSWORD','2022-01-21 05:58:51','2022-01-21 06:58:51','R',47),(60,'103705','RESET_PASSWORD','2022-01-21 06:15:01','2022-01-21 07:15:01','R',8),(61,'199716','RESET_PASSWORD','2022-01-21 06:42:02','2022-01-21 07:42:02','R',47),(62,'121170','RESET_PASSWORD','2022-01-21 07:40:11','2022-01-21 08:40:11','R',47),(63,'157445','RESET_PASSWORD','2022-01-21 07:42:53','2022-01-21 08:42:53','I',8),(64,'127400','RESET_PASSWORD','2022-01-21 08:12:38','2022-01-21 09:12:38','R',47),(65,'128137','RESET_PASSWORD','2022-01-21 08:21:34','2022-01-21 09:21:34','R',47),(66,'198964','RESET_PASSWORD','2022-01-21 08:22:11','2022-01-21 09:22:11','R',47),(67,'135465','RESET_PASSWORD','2022-01-21 10:14:50','2022-01-21 11:14:50','R',47),(68,'162870','RESET_PASSWORD','2022-01-21 10:41:02','2022-01-21 11:41:02','R',47),(69,'170471','RESET_PASSWORD','2022-01-21 10:41:51','2022-01-21 11:41:51','R',47),(70,'193739','RESET_PASSWORD','2022-01-24 08:18:30','2022-01-24 09:18:30','R',47),(71,'104340','RESET_PASSWORD','2022-01-24 08:20:58','2022-01-24 09:20:58','R',47),(72,'161187','RESET_PASSWORD','2022-01-28 07:06:58','2022-01-28 08:06:58','R',50),(73,'159270','RESET_PASSWORD','2022-01-28 07:08:46','2022-01-28 08:08:46','R',50),(74,'195077','RESET_PASSWORD','2022-01-28 07:09:18','2022-01-28 08:09:18','R',50),(75,'159933','RESET_PASSWORD','2022-01-28 07:09:35','2022-01-28 08:09:35','R',50),(76,'197882','RESET_PASSWORD','2022-01-28 07:09:36','2022-01-28 08:09:36','R',50),(77,'156776','RESET_PASSWORD','2022-01-28 07:09:37','2022-01-28 08:09:37','R',50),(78,'124164','RESET_PASSWORD','2022-01-28 07:20:03','2022-01-28 08:20:03','R',50),(79,'134359','RESET_PASSWORD','2022-01-28 07:20:16','2022-01-28 08:20:16','R',50),(80,'168706','RESET_PASSWORD','2022-01-28 07:21:02','2022-01-28 08:21:02','R',50),(81,'162723','RESET_PASSWORD','2022-01-28 07:28:56','2022-01-28 08:28:56','R',50),(82,'108912','RESET_PASSWORD','2022-01-28 07:28:56','2022-01-28 08:28:56','R',50),(83,'165180','RESET_PASSWORD','2022-01-28 07:29:54','2022-01-28 08:29:54','R',50),(84,'121940','RESET_PASSWORD','2022-01-28 07:29:56','2022-01-28 08:29:56','R',50),(85,'128043','RESET_PASSWORD','2022-01-28 07:29:56','2022-01-28 08:29:56','R',50),(86,'179809','RESET_PASSWORD','2022-01-28 07:29:56','2022-01-28 08:29:56','R',50),(87,'174050','RESET_PASSWORD','2022-01-28 07:30:02','2022-01-28 08:30:02','R',50),(88,'111782','RESET_PASSWORD','2022-01-28 07:30:02','2022-01-28 08:30:02','R',50),(89,'129190','RESET_PASSWORD','2022-01-28 07:30:40','2022-01-28 08:30:40','R',50),(90,'117424','RESET_PASSWORD','2022-01-28 07:30:42','2022-01-28 08:30:42','R',50),(91,'126841','RESET_PASSWORD','2022-01-28 07:30:42','2022-01-28 08:30:42','R',50),(92,'186615','RESET_PASSWORD','2022-01-28 07:30:42','2022-01-28 08:30:42','R',50),(93,'105872','RESET_PASSWORD','2022-01-28 07:30:53','2022-01-28 08:30:53','R',50),(94,'158091','RESET_PASSWORD','2022-01-28 07:30:55','2022-01-28 08:30:55','R',50),(95,'116727','RESET_PASSWORD','2022-01-28 07:30:55','2022-01-28 08:30:55','R',50),(96,'176038','RESET_PASSWORD','2022-01-28 07:30:55','2022-01-28 08:30:55','R',50),(97,'181165','RESET_PASSWORD','2022-05-10 07:08:56','2022-05-10 08:08:56','I',50),(98,'173629','RESET_PASSWORD','2022-05-10 07:34:02','2022-05-10 08:34:02','I',77),(99,'165850','RESET_PASSWORD','2022-05-12 03:04:48','2022-05-12 04:04:48','R',47),(100,'103440','RESET_PASSWORD','2022-05-12 03:15:22','2022-05-12 04:15:22','R',47),(101,'148106','RESET_PASSWORD','2022-05-12 03:15:28','2022-05-12 04:15:28','R',47),(102,'197749','RESET_PASSWORD','2022-05-12 03:15:49','2022-05-12 04:15:49','I',79),(103,'180293','RESET_PASSWORD','2022-05-12 03:16:55','2022-05-12 04:16:55','R',47),(104,'189502','RESET_PASSWORD','2022-05-18 06:47:33','2022-05-18 07:47:33','R',1),(105,'136253','RESET_PASSWORD','2022-05-19 12:31:52','2022-05-19 13:31:52','R',47),(106,'124560','RESET_PASSWORD','2022-05-20 04:05:52','2022-05-20 05:05:52','R',47),(107,'194291','RESET_PASSWORD','2022-05-20 04:12:09','2022-05-20 05:12:09','R',47),(108,'177788','RESET_PASSWORD','2022-05-24 09:52:15','2022-05-24 10:52:15','I',94),(109,'131421','RESET_PASSWORD','2022-05-24 10:19:51','2022-05-24 11:19:51','R',95),(110,'162885','RESET_PASSWORD','2022-05-24 11:43:31','2022-05-24 12:43:31','R',47),(111,'123879','RESET_PASSWORD','2022-05-24 12:34:56','2022-05-24 13:34:56','R',47),(112,'191716','RESET_PASSWORD','2022-05-24 14:45:37','2022-05-24 15:45:37','I',95),(113,'171305','RESET_PASSWORD','2022-05-25 03:49:14','2022-05-25 04:49:14','R',47),(114,'159933','RESET_PASSWORD','2022-05-25 03:49:59','2022-05-25 04:49:59','R',47),(115,'190313','RESET_PASSWORD','2022-05-25 03:51:58','2022-05-25 04:51:58','R',47),(116,'145563','RESET_PASSWORD','2022-05-25 03:54:24','2022-05-25 04:54:24','I',1),(117,'186360','RESET_PASSWORD','2022-05-25 03:57:23','2022-05-25 04:57:23','R',47),(118,'149262','RESET_PASSWORD','2022-05-25 03:58:33','2022-05-25 04:58:33','R',47),(119,'147023','RESET_PASSWORD','2022-05-25 06:59:06','2022-05-25 07:59:06','I',97),(120,'196105','RESET_PASSWORD','2022-07-28 07:00:16','2022-07-28 08:00:16','R',122),(121,'161147','RESET_PASSWORD','2022-07-28 07:00:24','2022-07-28 08:00:24','R',122),(122,'131889','RESET_PASSWORD','2022-07-28 07:00:28','2022-07-28 08:00:28','I',122),(123,'135425','RESET_PASSWORD','2022-07-29 06:39:40','2022-07-29 07:39:40','R',47),(124,'134962','RESET_PASSWORD','2022-07-29 06:39:51','2022-07-29 07:39:51','R',47),(125,'192215','RESET_PASSWORD','2022-07-29 07:23:28','2022-07-29 08:23:28','I',47);

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `full_name` varchar(100) DEFAULT NULL,
  `user_name` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `user_type_id` int(11) DEFAULT NULL,
  `contact_no` varchar(45) DEFAULT NULL,
  `country` varchar(45) DEFAULT NULL,
  `is_approved` int(11) DEFAULT NULL,
  `approved_date` datetime DEFAULT NULL,
  `is_locked` int(11) DEFAULT NULL,
  `is_locked_date` datetime DEFAULT NULL,
  `verify_token` varchar(45) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `client_id` int(11) DEFAULT NULL,
  `is_new_user` int(11) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `telephone` varchar(45) DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  `profile_picture` varchar(500) DEFAULT NULL,
  `branch_details_id` int(11) DEFAULT NULL,
  `gender` enum('M','F','OTHER') DEFAULT NULL,
  `joining_date` date DEFAULT NULL,
  `is_verified` int(11) DEFAULT NULL,
  `verification_code` varchar(45) DEFAULT NULL,
  `verified_on` date DEFAULT NULL,
  `activated_date` date DEFAULT NULL,
  `deactivated_date` date DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  KEY `user_fk1_idx` (`user_type_id`),
  KEY `user_fk_2_idx` (`client_id`),
  KEY `user_fk_3_idx` (`role_id`),
  KEY `user_fk_4_idx` (`core_details_id`),
  CONSTRAINT `user_fk1` FOREIGN KEY (`user_type_id`) REFERENCES `user_type` (`user_type_id`),
  CONSTRAINT `user_fk_2` FOREIGN KEY (`client_id`) REFERENCES `client` (`client_id`),
  CONSTRAINT `user_fk_3` FOREIGN KEY (`role_id`) REFERENCES `role` (`role_id`),
  CONSTRAINT `user_fk_4` FOREIGN KEY (`core_details_id`) REFERENCES `core_details` (`core_details_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (1,'jeyapriya malathi','malathy@gmail.com','$2a$10$co8YvjEjB.biP6SQt4eYT./J2fiv3mk0TLPETnWCDAPpK3WxPkE.q','malathy@gmail.com',1,'776455624',NULL,1,'2021-04-09 00:00:00',NULL,NULL,NULL,1,NULL,NULL,NULL,'Mannar','212227768',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'Sasee Raj',NULL,NULL,'styloo@test.com',NULL,'751673222',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Jaffna','212229909',NULL,'http://10.20.100.6/userImage/Pavi.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'Anon Rogess','anon@test.com','$2a$10$dy.GbDnmixl3naK/yTghUeEUQjnlYkAW8jhkZMErrm1mPmpfLu4gK','anon@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,'image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'Anon Rogess','anon@test2.com','$2a$10$KxOFha1sDPJth8UqEoB99uRd07eiy6iysqyrSNJ2Wy925UWL05WaC','anon@test2.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'Jenny Lorus','styloo@test.com','$10$iwgOLdzaTiIe9wpjJCKrXuBOsx0A25FO8AhQCc3EFBKXIKAB2AEZK','styloo@test.com',3,'776587335',NULL,1,'2021-04-09 00:00:00',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'Shamali Pathirana','shamali@test.com','$2a$10$hBs.NPwfozPlNo9UpsUyluOgdB7SlC.B2ipNHaHyCWVhQuDa1HaAO','shamali@test.com',1,'751673564',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'Shamali Pathirana','shamali@test.com','$2a$10$awzjRVWKfL6TiyZcPrw7AeqR3ToQ038RHhXFtZSn0nAG7SbGr.U1i','shamali@test.com',1,'751673564',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'Shamali Pathirana','shamali@test.com','$2a$10$4t8Z9Zm1iTs7ds8q8Z6qvOa2KYZm6mtBNsesACcljSQfFemvTS00i','shamali@test.com',1,'751673564',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'Shamali Pathirana','shamali@test.com','$2a$10$PQHBbN8pRb4cXQA7E5LmOuQRMoQuoSUqrj9A/884HLmYRhsg34/pm','shamali@test.com',1,'751673564',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'Sasee Raj','styloo3@test.com','$2a$10$ksMRNV8dDarJpLAzwpJ.y.lNz.G5vMj3z8a/ZUOQjVOth3Qrh7neW','styloo3@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'Sasee Raj','styloo3@test.com','$2a$10$w6oTsweW4KPSGf18xptK3u/ndW/Bi53lIEACsIh00HtqLy37MvoMS','styloo3@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'Sasee Raj','styloo3@test.com','$2a$10$JKr2UjSm281CALeMfwzVNOy41ifDztqYEYzkJt1q6hLySmYJ46zky','styloo3@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'Sasee Raj','styloo3@test.com','$2a$10$ba/qNUZePMGMkyiIdcN16umwEv5JojFlMClCpu7WNxDbWLWxFtbV.','styloo3@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'Sasee Raj','styloo3@test.com','$2a$10$iCp7O336Aje8sCe6hid0eeKQYrxpcg3H1cn.t0jiAz4oXYb15yeFi','styloo3@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'Sasee Raj','styloo3@test.com','$2a$10$SJbN8IKnWxu3tXPhYfyKeO7CrWltV4.qUmDQs5ir9s.SzT2xfzs/m','styloo3@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'Sasee Raj','styloo3@test.com','$2a$10$Yzxbet/fc5yo7ZmuNHnISuz2kZlW6XL..ikAoLYpbWF8Ib/kFXHJm','styloo3@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'Sasee Raj','styloo3@test.com','$2a$10$O0FDwm3YmwnxLAnBLP8UPeEpWqlWR8g1NtGvkxO5aIdTKA.tQD0KG','styloo3@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'Sasee Raj','styloo3@test.com','$2a$10$ktbCcGeXmnF3jH2baWLUsueh62vwbo/94j9RXRAhayTgLFj3v81Yy','styloo3@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'Sasee Raj','styloo3@test.com','$2a$10$RLSCEvj8m9iQIjYNEVcnguz4v14WMO2qFZ.Rj2nno.ImJiVS3hzgq','styloo3@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'Sasee Raj','styloo3@test.com','$2a$10$lVfdb9Mfd3hdnnqbsnAElOiFqt.raW360ZL6rJZ9NixJlusVhRnim','styloo3@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'Sasee Raj','styloo2@test.com','$2a$10$62Pg5tzNz2vL.9l7Q9oxmeFhWDLlCKnRcDPztmDc05FggGnPQAM7K','styloo2@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'none','anon@test.com','$2a$10$SvQ1QjvNaJ.xQ0/r/mwCUOlQwYs7pwIuiMVhA13M/tPY3mbDOgKY2','ann@gmail.com',1,NULL,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'none','anon@test.com','$2a$10$sajHnwemcAePIEVqxHam0.jwRzuvD/.Z57dGwHz1nfMKEHqQD58jC','ann@gmail.com',1,'123456789',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'none','anns','$2a$10$nlSNCnfB5KllyfGaOscOR.fx28N4Lh.TbdQz4zXVj/ZBzKGcKUVRO','romert@codelanticdd.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'none','romert','$2a$10$QMO1YEAw8K06oZrssLFFDe1qj5Kod8qBbUXU3FFSx7wB3YUasTh.K','romert1@codelantic.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'Sasee Raj','styloo5@test.com','$2a$10$V.I1dULd9FVZC/tu8dyWP.6lGlIwOI5.BR9KJ9OON6mczoG7PaPDC','styloo5@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'Sasee Raj','styloo5@test.com','$2a$10$bWm8kyIF8sCK43DZbscZfuhs5VNTJVAZw5WsSgrY/pgee/XWOhpgu','styloo5@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'Sasee Raj','styloo5@test.com','$2a$10$GYmvVMtFc8nlJuTJMFK5Te5mrz3Aj3EKC46YWxqCtb9gZ/heqishe','styloo5@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'Sasee Raj','styloo6@test.com','$2a$10$S73MceZ0UUhCB3jqP.udFee59s4EYykEG4tLTAY99ri6L5O3xcOM2','styloo6@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'Sasee Raj','styloo5@test.com','$2a$10$jXsZ6g0Lzc/GvFVyKFjcduiGyD4KiT8Maprbmm8OEzrk459V8r58K','styloo5@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'none','ANnciley','$2a$10$VpzMyhQAmz2KMk5ePSYkC.FGNx5xaLEC7gn/05/sJ0x5c9n4WBS1a','romert@codelantic.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,'image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'Sasee Raj','styloo7@test.com','$2a$10$Efw0Y3PexOLCJr8ukN1ameGcO3kY7YAduEyNBYhrD0p2dzLAZeh2C','styloo7@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'Sasee Raj','styloo9@test.com','$2a$10$O7pmoKWdPiBfSTkxAfTr5eKAPBNF0jSs/h6/Z6p/kCBljE8XqXnvi','styloo9@test.com',1,'751673222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'none','Thanusha','$2a$10$zew6RrlbOeSOD.YJuI1cp.Voa/OFW3UHy5oS.G/BtcGNpll0lHTYq','thanusha@codelantic.com',1,'777969921',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'Kogul Rangan','kogul@gmail.com','$2a$10$s5fASt5vpFDKVl0L9Bl2kOSMmQBpBIWLJzFbFSOPW8vUPzm/cggFK','kogul@gmail.com',1,'776438634','Sri Lanka',1,'2021-04-09 00:00:00',NULL,NULL,NULL,1,NULL,NULL,NULL,'Mannar','212227768',NULL,'image/user_image/Profile-Picture-4.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'Kogul Rangan','kogul1@gmail.com','$2a$10$GsZdX286/iIPQ0qT/wwIoej5MmG.Q8z2YaQssvi3aKvfx22pB4xEu','kogul1@gmail.com',1,'776438634','Sri Lanka',1,'2021-04-09 00:00:00',NULL,NULL,NULL,1,NULL,NULL,NULL,'Mannar','212227768',NULL,'image/user_image/Profile-Picture-4.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'Kogul Rangan','kogul2@gmail.com','$2a$10$kenGQIKfT6/O7e886Rk9ZuGIRgcykd.KntTWKz1fo3XXwOLczrO7W','kogul2@gmail.com',1,'776438634','Sri Lanka',1,'2021-04-09 00:00:00',NULL,NULL,NULL,1,NULL,NULL,NULL,'Mannar','212227768',NULL,'image/user_image/Profile-Picture-4.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'Kogul Rangan','kogul11@gmail.com','$2a$10$AkCPhwnnpV7qCO3tkdVV1.GA5uloHE/6ufq5F0mqRoDgQY92SDkTC','kogul11@gmail.com',1,'776438634','Sri Lanka',1,'2021-04-09 00:00:00',NULL,NULL,NULL,1,NULL,NULL,NULL,'Mannar','212227768',NULL,'image/user_image/Profile-Picture-4.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'Anon Rogess',NULL,'$2a$10$ELHlT1U4hx0eSb4w0gJT9.0Ue7tk6BKWXndTwv2dGOboifVYYdWkG','annnn@gamil.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'anon@test.com',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'Kogul Rangan','kogull1@gmail.com','$2a$10$gdXbzEGxgQJA/CH4McL9WOKYmvi4hSjyjn2Wlyu3sbgFGqzC6FOC2','kogull1@gmail.com',1,'776438634','Sri Lanka',1,'2021-04-09 00:00:00',NULL,NULL,NULL,1,NULL,NULL,NULL,'Mannar','212227768',NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'ann',NULL,'$2a$10$pA0kbwQBua/bi9ukcv1hs.eaQG.Uva4lxrKkU4jZhynhesy6qZbRG','ann2222@gmail.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'ann','ann22222@gmail.com','$2a$10$VLZJwVIwetR77qKqHZOi0ubo0ycXSFH8UqqTZsDqw8ZnzZQWRrx6q','ann22222@gmail.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'Kogul9 Rangan','kogul9@gmail.com','$2a$10$5UxCtFLNYm.XEKI0S.rQLOsAFWMXh1wsQgPtuTngkdAzTSLq/i2SO','kogul9@gmail.com',1,'776438634','Sri Lanka',1,'2021-04-09 00:00:00',NULL,NULL,NULL,1,NULL,NULL,NULL,'Mannar','212227768',1,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'romert',NULL,'$2a$10$sp/Dc1ttFwzXuYjYbhAViu2awMhrQf45aHoFekVhrHP4N07K3dScC','romert2222@gamil.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'Kogul10 Rangan','kogul10@gmail.com','$2a$10$5UxCtFLNYm.XEKI0S.rQLOsAFWMXh1wsQgPtuTngkdAzTSLq/i2SO','kogul10@gmail.com',1,'776438634','Sri Lanka',1,'2021-04-09 00:00:00',NULL,NULL,NULL,1,NULL,NULL,NULL,'Mannar','212227768',1,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,'Kogul12 Rangan',NULL,'$2a$10$Q8JSYb.HI3HIZT1fInRcH.kFGto1sMpnlHDlCSf11ahfT4LJES.ci','kogul12@gmail.com',1,'776438634','Sri Lanka',1,'2021-04-09 00:00:00',NULL,NULL,NULL,1,NULL,NULL,NULL,'Mannar','212227768',1,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'test last','fgh@dfg2367.com','$2a$10$w/52syV2p4TczzWJQjNEcuVuHlsDcEAvBaJTCL7sCxwz5uYuXzpAC','fgh@dfg2367.com',1,'1234567890',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'dfhrgh',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'test last','test@dfg2367.com','$2a$10$yJcK53Ri1Pa4tDnKbytj8.3fFSgxLWxXs2z8twk3v8f0N5RO2pteK','test@dfg2367.com',1,'1234567890',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'dfhrgh',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,'Anon Rogess','qwerty@gmail.com','$2a$10$19OKoQr/CIBiEiivgNMrIuJkPp/yCSgO882.9RFmqMSgFndvP8roW','qwerty@gmail.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,'ann123456','ann123456@gmail.com','$2a$10$aLHSJQT7eGb7dCStKs29NOog6M42DCqCimxXTQ5i.rRlEMmh4cK96','ann123456@gmail.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'romert12345','romert12345@gamil.com','$2a$10$mpCf2EjlPk6U8SFHAbIfYOTMy.trOee2MuA93lyQ7gk1c2DuHmBzG','romert12345@gamil.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'addres',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'romert12345','romert12345@gmail.com','$2a$10$EC8KMSIsy5Q2/5keuiWddeurMXE.ft.ivJmIvgXF.28fNIOhmoFg2','romert12345@gmail.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'addres',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,'new last','test@123gmail.com','$2a$10$qGTKURZD8A3DtFSWyAAaLuMSoFp34tGB7LyrU1s2F.CY7bstunrla','test@123gmail.com',1,'1234567890',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'dfhrgh',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,'new last','test@888gmail.com','$2a$10$CSImAq6VF8TXrK33ICnKEuiHcUg0lsz3B2ek9pL.e00zFKlC2CCEO','test@888gmail.com',1,'1234567890',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'dfhrgh',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'Thanusri','srithanu388@gmail.com','$2a$10$r6GJ2GdiqTBSigOgfxVPxeZj.0kEbFOnOwMRsec6Pepa/m2xA3vNO','srithanu388@gmail.com',1,'777969921',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Thanusha jaffna',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,'thanuu','kelis84707@abincol.com','$2a$10$b1DqSIrVz.dIGOvw3tTIBenHp8.87evuaXAN5NFUnJfhTMbc7mOy6','kelis84707@abincol.com',1,'777969921',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Virtual office rental London,  +44 20 7060 7220',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,'thanuu','kelis84707@abincol.com','$2a$10$S8Usp.e9ODvyjTXvhm0DPuduV9pf2v0uHXoeWkHw4Aw5svuwhsAOC','kelis84707@abincol.com',1,'777969921',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Virtual office rental London,  +44 20 7060 7220',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,'shanu','foneboh784@azteen.com','$2a$10$fQhgQ2T0HCRlQnl.IIdruuL2wsOebVcNbvaZwgHiwSpjSJmns9jvK','foneboh784@azteen.com',1,'777969921',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Virtual office rental London,  +44 20 7060 7220',NULL,NULL,'image/user_image/http://77.68.28.88:32449/image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,'thanusha','jatoyo5090@angeleslid.com','$2a$10$M53utMnb48m2BP0yL9gWmOmhf6fxby0jrWKV9zQw4G6OcR35k1Ala','jatoyo5090@angeleslid.com',1,'777969921',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Virtual office rental London,  +44 20 7060 7220',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,'thanusha','jobafe4157@azteen.com','$2a$10$WZpAFHR7VR4vxDLfAtY8CuqRc4nMKa.o8LF7vj5Ml.N/03kZFI8ha','jobafe4157@azteen.com',1,'777969921',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Virtual office rental London,  +44 20 7060 7220',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,'test','bocox62366@azteen.com','$2a$10$tOyK2RhMdFPS8XlYA.9tC.O.OI.xaQmwuPzA1F0JEYgrV2sLMaCHm','bocox62366@azteen.com',1,'777969921',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Virtual office rental London,  +44 20 7060 7220',NULL,NULL,'image/user_image/http://77.68.28.88:32449/image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,'thanushai','depod96223@abincol.com','$2a$10$UJZiRL23mSBbNbX9GQ4KNuAvBsuAcvmC.ZDz1U7FgsWBQxeQwS6/K','depod96223@abincol.com',1,'777969921',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Virtual office rental London,  +44 20 7060 7220',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(79,'ann','ann8888@gmail.com','$2a$10$1/zGbHbaKqGln9YPrEOKCOBH.6wqS8z/VHsoexfMI2cn2JxhrXBhO','ann8888@gmail.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,'image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,'ann','ann88888@gmail.com','$2a$10$erpuhgX/f36ZBDB0jcULBeMK5DHU4dkrNzVszQwHIFuIa0q1KdtUS','ann88888@gmail.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,'thanusha','vixijit313@cupbest.com','$2a$10$fPXpFv5dLxpt6VApO5.SVuQJvMckovmnk0hSGzCnBxEWvx8Q8UvCK','vixijit313@cupbest.com',1,'777969921',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Virtual office rental London,  +44 20 7060 7220',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,'ann6666','ann6666@gmail.com','$2a$10$FoIw2zr4o4M2/FFrq8DNZezSX1Zs8kKa5DeC88yGkHSO7OGGFkLhi','ann6666@gmail.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,'Anon Rogess','ann8888@gmail','$2a$10$vohVWt.qjQRjBncXdFCArOt9QPgNkJO6x5Ua91cl9dYaPXAaD6gQO','ann8888@gmail',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,'ann','anns88888@gmail.com','$2a$10$9bDQQB8qjw0pcAi3DldtxOlcwgLJTLv7bGDaG58Gx1KTk0oJ8UbOy','anns88888@gmail.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,'image/user_image/http://77.68.28.88:32449/image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(85,'kayangthgan','kajan@gmail.com','$2a$10$uKw1hopjhu4FWw4ohh387OMMMkYOiBWreGNABdJ5QQbZPzTZ/QSb6','kajan@gmail.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,'image/user_image/http://77.68.28.88:32449/image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,'thanushaaa','tatowav330@akapple.com','$2a$10$CNNgIk4kyqOzFHB.MToWoOs5R9ruP5G92wojTC2yPEDxvNFTlngXa','tatowav330@akapple.com',1,'777969782',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(87,'thansu','japef91380@dufeed.com','$2a$10$IFtZOn/1XlIhW/NhMOMZsO4PVExn9Jam5Z3JTLgfeSd4ffAgacLs2','japef91380@dufeed.com',1,'777969921',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'ketpeli, mirusuvil.',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(88,'Thanusri','xijovif736@hbehs.com','$2a$10$61/cJae25GupCbGV8icLmOedUYcgghHLyuHRcK0aiB9Az.m/pb/F.','xijovif736@hbehs.com',1,'777969921',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(89,'Thanusri','wopiye4041@akapple.com','$2a$10$mbt5UY/K7pfwyLyN43WSQu3pfiQfkVVVAdtqlInmPl9JfxhPh0ILi','wopiye4041@akapple.com',1,'777969921',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(90,'Lunea Cooke','sifaxobo@mailinator.com','$2a$10$PJpm.3VzWq2AihlAPBAtN.cwCYRE1rWN6jRe6XiSycj45tCFCUvOe','sifaxobo@mailinator.com',1,'982323233',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Placeat qui velit v',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(91,'thanu','bijice9054@akapple.com','$2a$10$pKp.4SiP.jb3G7qVjkKHm..XDwQunWQnIwBnow.1bIbQ1IkvpnJl.','bijice9054@akapple.com',1,'777969921',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(92,'thanusri','hirigos715@roxoas.com','$2a$10$CvKGvfxgzyuHRVIbKEaTougBvAsooLprFLXcCO7j4VVb4ORTo3Q8C','hirigos715@roxoas.com',1,'777893678',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(93,'thanusri','jigih32584@hbehs.com','$2a$10$JUjpWn88xiEiqLkxfGw5muk4oZj8DMLHIi7mq0/xr3s6LLKvaK02.','jigih32584@hbehs.com',1,'777893678',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(94,'test','pojoti4546@dufeed.com','$2a$10$QpKHIFDzpKauVbhZWvw3oO3JueAkUmyGN9QupEdsWk3e2K81w9eOC','pojoti4546@dufeed.com',1,'776979876',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(95,'janu','rodopoh482@hbehs.com','$2a$10$ZchAwa0/dFhlF1CJd4n3zeN6HbCHrI0wmFVvB/YUGv3GKmZsMI3Ci','rodopoh482@hbehs.com',1,'776979876',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,'image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,'ann','ann12345678@gmail.com','$2a$10$nKxljA0BnJaNztqLqi972O6jVZomCXPnUeK7iB8DarXnhjRWyP1u6','ann12345678@gmail.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(97,'Thanshana','conod62836@dufeed.com','$2a$10$TE9frKg/QF0FaH/4oRG2DubeiuAdQQbopGGccG6JcC.H7zsvO743G','conod62836@dufeed.com',1,'778987654',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,'image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/image/user_image/http://77.68.28.88:32449/image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(98,'Anon Rogess','anns123456@gmail.com','$2a$10$/9pRh2dhEQFpjVhQDBSHHOJPa30PZAScoD6IkK9kL.jXwBU4Lwiri','anns123456@gmail.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(99,'Anon Rogess','ann345345@gmail.com','$2a$10$.VUUqq2YoRU7WEJE..HjaeeQyXeyZnWnsvZHEYWdxRSuyYvG7cSmy','ann345345@gmail.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(100,'Anon Rogess','ann345345f@gmail.com','$2a$10$atK3jJ7pQfYGwaJASjwV6Ot7ulbqWfRbyYdc2m/.LtvVpohkkxNhe','ann345345f@gmail.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(101,'Anon Rogessfff','dfliuhydiuhidlo@gmail.com','$2a$10$T08p49j8Qa4ilnXero3dXOdi3jjNE6s22cndp6Y0mJGAPXpvklJ5O','dfliuhydiuhidlo@gmail.com',1,'766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(102,'thanusha','porigo8210@sinyago.com','$2a$10$m/Dx3cAT3PNeGgD50/NP7.YaFxJt5oiTa0SHA6ChoXyVvWYrcSzvK','porigo8210@sinyago.com',1,'778765432',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,'image/user_image/http://77.68.28.88:32449/image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(103,'ann','aaaaa@gmail.com','$2a$10$q/pYAOogAxTk62HCUD4K1.0FjuMqhCDeOqHIOXUZAujsd8pmFcX9K','aaaaa@gmail.com',1,'1234567890',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,'image/user_image/null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(104,'Kogul13 Rangan','kogul13@gmail.com','$2a$10$iPnVRIiHS/NrQfF56/0KH.VZjqn6GKtrzuRU6PJ.BmheqAtY52.8K','kogul13@gmail.com',1,'776438634','Sri Lanka',1,'2021-04-09 00:00:00',NULL,NULL,NULL,1,NULL,NULL,NULL,'Mannar','212227768',1,'userimageuploadnull',1,'M','2022-02-22',NULL,NULL,NULL,NULL,NULL),(105,'Kogul14 Rangan','kogul14@gmail.com','$2a$10$xBflWhNg40AqR0ShyaGZvul9xh3Vqbkv0q8eYNkQ9mJZEHHEAOefe','kogul14@gmail.com',1,'776438634','Sri Lanka',1,'2021-04-09 00:00:00',NULL,NULL,NULL,1,NULL,NULL,NULL,'Mannar','212227768',1,'userimageuploadnull',1,'M','2022-02-22',NULL,NULL,NULL,NULL,NULL),(106,'Kogul14 Rangan','kogul15@gmail.com','$2a$10$vFi013fGh1uL5RZKDfTDnuS4WGj.W5QYPqvX0xw28UekJOtHSKTKi','kogul15@gmail.com',1,'770000000','Sri Lanka',1,'2021-04-09 00:00:00',NULL,NULL,NULL,1,NULL,NULL,NULL,'Mannar','212227768',1,'userimageuploadnull',1,'M','2022-02-22',NULL,NULL,NULL,NULL,NULL),(107,'Raguram Rangan','ragu@gmail.com','$2a$10$YHI1nxmIJkU0W7JqIXZW/u62gj70JEm7zx8phCnSMTTB/s5wUmyzq','ragu@gmail.com',1,'761111111','Spain',1,'2021-04-09 00:00:00',0,NULL,NULL,1,NULL,NULL,NULL,'Puttur','211111111',2,'http://10.20.100.6/userImage/6.jpg',1,'F','2022-02-22',NULL,NULL,NULL,NULL,NULL),(108,'Shiyam Rangan','shiya@gmail.com','$2a$10$mmFJbhTaKCaR4dVDyzW3QeLe2Q8vWH.AdsOKO/BNuzaf8SBqLaV5u','shiya@gmail.com',1,'766438634','Sri Lanka',1,'2021-04-09 00:00:00',0,NULL,NULL,1,NULL,NULL,NULL,'Puttur','212228856',1,NULL,1,'F','2022-02-22',NULL,NULL,NULL,NULL,NULL),(109,'Raguram Ragavi','ragavi@gmail.com','$2a$10$MV0pblqCMHo1F2OHqxKYPOdzvNsFS3TW3Vt6phnZPS9A/umkGS3Wa','ragavi@gmail.com',1,'766438634','Sri Lanka',1,'2021-04-09 00:00:00',0,NULL,NULL,1,NULL,NULL,NULL,'Puttur','212228856',1,'http://10.20.100.6/userImage/6.jpg',1,'F','2022-02-22',NULL,NULL,NULL,NULL,NULL),(110,'Sathu Rangan','sathu@gmail.com','$2a$10$udG/r4ReE9fuuxLgzJNKhu/b4dJ3jBI7VErlkByUK7.zA1pBlTk.m','sathu@gmail.com',1,'766438634','Sri Lanka',1,'2021-04-09 00:00:00',0,NULL,NULL,1,NULL,NULL,NULL,'Puttur','212228856',1,NULL,1,'F','2022-02-22',NULL,NULL,NULL,NULL,NULL),(111,'dsadasd','dssads@gmail.com','$2a$10$5iAgw1axnoE1xPQKJOi3R.ms6ASaaxcp5ZtoWPJO.IJ5e9wUk.m5u','dssads@gmail.com',1,'1234567890',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'styloo@test.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(112,'dsadasd','dssad99@gmail.com','$2a$10$Qd8p.HjPmbGvClMqAwX/ZOWLO.4.PghBVoO2p8ioE2RxyakcMj3f6','dssad99@gmail.com',1,'1234599890',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'styloo@test.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(113,'Winrar','sdsd@gmail.com','$2a$10$UZIxAhmnQ4oSzLfNJALfvOn8dP0SRCvOaMgrxGOd2bfpqw1Uc/dzq','sdsd@gmail.com',1,'00000234567',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'styloo@test.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(114,'sdsfdsfsfds','sdsddfdfd@gmail.com','$2a$10$lXtNzvQ12em4sa0kTZtaqumk1y6hN9ja0a4PBRgq7HaHSoBA3OZ2K','sdsddfdfd@gmail.com',1,'000545434567',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'styloo@test.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(115,'werwerwer','erwerwrew@gamil.com','$2a$10$KysoOYKcXJVZQY0VV2sPCep8G1VguQA9lNJraPiw.AXY.YN2QJ5HO','erwerwrew@gamil.com',1,'0123456789',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'styloo@test.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(116,'Thanusriii','mitebif267@5k2u.com','$2a$10$/aeSzBs6B1p7zO9TNlrh3OzKnfG7xmME/kW1b6011abxO9A/ubMf.','mitebif267@5k2u.com',1,'0776543234',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(117,'Thanusri','jorohif933@anlubi.com','$2a$10$vbo9uzHi9aQ2X7e3tafbp..8bXDoXXg6GHQLVW5/q5Qn5n.yHF2P.','jorohif933@anlubi.com',1,'0778976554',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'zxcvbhtsx',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(118,'Thanusrii','bekaw80157@5k2u.com','$2a$10$1t0DlQC9paKBBl3W69hECO4ldp15GeJEFKM5rXgqBmcMPaekSsktW','bekaw80157@5k2u.com',1,'0778976543',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffnaa',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(119,'Thanusrii','mapafic936@altpano.com','$2a$10$wAHQaDAqrR35dQl1QWorfu4C2SpA7oDL5KlgmHLEULAnbvZTLW6GS','mapafic936@altpano.com',1,'0778976543',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffnaa',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(120,'Thanusrii','jejaf41539@5k2u.com','$2a$10$QZZB8b677I3/64fO9JYMael0TNZOOjkM6iQc/CpiWGhUPHbeKFXge','jejaf41539@5k2u.com',1,'0778976543',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffnaa',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(121,'Thanusrii','lejafa4136@anlubi.com','$2a$10$VAibb0AQ9tSR2acvBu/NwOsjq7AOb931816VLZkLVgUc5XRtLVF4K','lejafa4136@anlubi.com',1,'0778976543',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffnaa',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(122,'Thanusri','gijedo6441@anlubi.com','$2a$10$Zyts1FXsungUrx/bNDo.PuyAUDCX4xSE7oucqXzsRqHWyprLEOKNG','gijedo6441@anlubi.com',1,'0788998755',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(123,'Thanusri','nepifit852@5k2u.com','$2a$10$TgF3pm/zIipczbkQH9GEQeDLrD8zpfs8YDT3XVXlL17lOlaN.q4Lu','nepifit852@5k2u.com',1,'0987654320',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'y7yfghj',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(124,'Nihal Perera','yepota8286@chimpad.com','$2a$10$9O8xFBLS0s2gGqCqO2JL9.6djjkhK.G58hLNBwEg7DLdJ6n4my9Ga','yepota8286@chimpad.com',1,'0763467223',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Temple Road , Dehiwala',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(125,'thanusha','litafa8719@agrolivana.com','$2a$10$PrDTllLfaL1hkyR.0aFvLu1ujDjtr33yb6hdXfLI8tgoFEGFgWZq2','litafa8719@agrolivana.com',1,'0777969921',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(126,'Thanusri','yopoj11646@anlubi.com','$2a$10$qhBmcQA6ITy0/fa1ak0g9.rO.dfYPIo7xuwFQhgZfns4ChCRjD2aC','yopoj11646@anlubi.com',1,'0887654221',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(127,'thanu','lacovo5660@altpano.com','$2a$10$NOTKaa31.rb36LB/NxgUzeZuLDSOxto6D9dbNaPrJKnJTMeRzQpDu','lacovo5660@altpano.com',1,'0773567899',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(128,'Romert Annciley','romertw@codelantic.com','$2a$10$PI0V3FcfenHa9Elfp0aY2einP/SQBC4F8qQQCTmeEP42kIc2NvVvO','romertw@codelantic.com',1,'1234567890',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(129,'Alfreda Christensen','ksdjfks@gmail.com','$2a$10$BA8b9zbq8d4zG.IOAshsQOAGqRKnHOWqDZtJjyCwWx/LtyKU.qqdC','ksdjfks@gmail.com',1,'2122222222',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'sddasasd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(130,'thanu ','bobaba5608@altpano.com','$2a$10$pKAX84x2mvg277hE4R0sQui.oCUurMpsxpydoiPjOEMYDqNC2VRBW','bobaba5608@altpano.com',1,'0777876549',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(131,'Thanusri','xorohok732@5k2u.com','$2a$10$Vrjjhwii6z20/pDTZycYnu9nCJ5ZlMPiCZoCzEoOgZN6gCTVtSypi','xorohok732@5k2u.com',1,'0778990976',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(132,'Kim Baldwin','ruwu@mailinator.com','$2a$10$gm.YyvMEXd4ATf14owNLrO0L2ADDrcuS0oTh0cW.rw4rfAqCRdgCe','ruwu@mailinator.com',1,'0766931072',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Nulla ut dolorem ut ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(133,'thanusha','xakiw26408@anlubi.com','$2a$10$2PK7RZxd5I0W/KsqTZ1OAeMh1Vr.9FVJJs/GKBIqjq9oOygvVKOsK','xakiw26408@anlubi.com',1,'0778987650',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'colombo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(134,'yadevi Rupasinghe','xafafe9468@logodez.com','$2a$10$hiweSVUvjcVRoYTILbxmSuN/xAHi8lboqYotpa0TNxz21pQtczqTu','xafafe9468@logodez.com',1,'0751673568',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(135,'Thanusri','nowile3657@anlubi.com','$2a$10$o7eklywRStHi.MX060Vv8.b/1SqG4IyCuD6siKv1eMeu1SyqplVyi','nowile3657@anlubi.com',1,'0778987650',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(136,'thanusha','meweta7025@altpano.com','$2a$10$xJjdOsDncPJpgq63n1EIZ.1I17qJPDGwxWlTFZ8iaf5JoAojqyzOS','meweta7025@altpano.com',1,'0778989900',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(137,'thanusha','poyetet714@altpano.com','$2a$10$iCgBxoBG/RZsz7q8Gl7BjeggNq2Irdidbxylt3qJsZm6A1FGxBmi2','poyetet714@altpano.com',1,'0778987654',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'colombo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `user_BEFORE_INSERT` BEFORE INSERT ON `user` FOR EACH ROW BEGIN
INSERT INTO `styloo`.`user_h`(`user_id`,`full_name`,`user_name`,`password`,`email`,`user_type_id`,`contact_no`,`country`,`is_approved`,`approved_date`,`is_locked`,`is_locked_date`,`verify_token`,`is_active`,`client_id`,`is_new_user`,`role_id`,`address`,`telephone`,`profile_picture`,`core_details_id`,`branch_details_id`,`joining_date`,`gender`,`activated_date`,`deactivated_date`)
VALUES (new.user_id,new.full_name,new.user_name,new.password,new.email,new.user_type_id,new.contact_no,new.country,new.is_approved,new.approved_date,new.is_locked,new.is_locked_date,new.verify_token,new.is_active,new.client_id,new.is_new_user,new.role_id,new.address,new.telephone,new.profile_picture,new.core_details_id,new.branch_details_id,new.joining_date,new.gender,new.activated_date,new.deactivated_date);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `user_BEFORE_UPDATE` BEFORE UPDATE ON `user` FOR EACH ROW BEGIN
INSERT INTO `styloo`.`user_h`(`user_id`,`full_name`,`user_name`,`password`,`email`,`user_type_id`,`contact_no`,`country`,`is_approved`,`approved_date`,`is_locked`,`is_locked_date`,`verify_token`,`is_active`,`client_id`,`is_new_user`,`role_id`,`address`,`telephone`,`profile_picture`,`core_details_id`,`branch_details_id`,`joining_date`,`gender`,`activated_date`,`deactivated_date`)
VALUES (new.user_id,new.full_name,new.user_name,new.password,new.email,new.user_type_id,new.contact_no,new.country,new.is_approved,new.approved_date,new.is_locked,new.is_locked_date,new.verify_token,new.is_active,new.client_id,new.is_new_user,new.role_id,new.address,new.telephone,new.profile_picture,new.core_details_id,new.branch_details_id,new.joining_date,new.gender,new.activated_date,new.deactivated_date);
END */;;
DELIMITER ;

--
-- Table structure for table `user_h`
--

CREATE TABLE `user_h` (
  `userh_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `full_name` varchar(100) DEFAULT NULL,
  `user_name` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `user_type_id` int(11) DEFAULT NULL,
  `contact_no` int(11) DEFAULT NULL,
  `country` varchar(45) DEFAULT NULL,
  `is_approved` int(11) DEFAULT NULL,
  `approved_date` datetime DEFAULT NULL,
  `is_locked` int(11) DEFAULT NULL,
  `is_locked_date` datetime DEFAULT NULL,
  `verify_token` varchar(45) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `client_id` int(11) DEFAULT NULL,
  `is_new_user` int(11) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `telephone` int(11) DEFAULT NULL,
  `profile_picture` varchar(200) DEFAULT NULL,
  `core_details_id` int(11) DEFAULT NULL,
  `branch_details_id` int(11) DEFAULT NULL,
  `joining_date` date DEFAULT NULL,
  `gender` enum('M','F','Other') DEFAULT NULL,
  `activated_date` date DEFAULT NULL,
  `deactivated_date` date DEFAULT NULL,
  PRIMARY KEY (`userh_id`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_h`
--

INSERT INTO `user_h` VALUES (44,0,'Shiyam Rangan','shiya@gmail.com','$2a$10$mmFJbhTaKCaR4dVDyzW3QeLe2Q8vWH.AdsOKO/BNuzaf8SBqLaV5u','shiya@gmail.com',1,766438634,'Sri Lanka',1,'2021-04-09 00:00:00',0,NULL,NULL,1,NULL,NULL,NULL,'Puttur',212228856,NULL,1,1,'2022-02-22','F',NULL,NULL),(45,0,'Satha Rangan','satha@gmail.com','$2a$10$YiT3fEH6m4nnHq1k1dSOouQ3DF1pDlko3NpfBxiksty9MHIZAUjBS','satha@gmail.com',1,766438634,'Sri Lanka',1,'2021-04-09 00:00:00',0,NULL,NULL,1,NULL,NULL,NULL,'Puttur',212228856,NULL,1,1,'2022-02-22','F',NULL,NULL),(46,109,'Raguram Ragavi','ragavi@gmail.com','$2a$10$K6mYGgdctTXmQveBJXJGYeLrr5wwItN.Umhocqwmkf1Z1xm64ZNla','ragavi@gmail.com',1,766438634,'Sri Lanka',1,'2021-04-09 00:00:00',0,NULL,NULL,1,NULL,NULL,NULL,'Puttur',212228856,'http://10.20.100.6/userImage/7g.png',1,1,'2022-02-22','F',NULL,NULL),(47,109,'Raguram Ragavi','ragavi@gmail.com','$2a$10$dnV5o/j4eo7ky5VzAlYVZukVXx5dO.dqcTWfUdUUgG/1vrD7jvUfW','ragavi@gmail.com',1,766438634,'Sri Lanka',1,'2021-04-09 00:00:00',0,NULL,NULL,1,NULL,NULL,NULL,'Puttur',212228856,'http://10.20.100.6/userImage/6g.jpg',1,1,'2022-02-22','F',NULL,NULL),(48,109,'Raguram Ragavi','ragavi@gmail.com','$2a$10$dnV5o/j4eo7ky5VzAlYVZukVXx5dO.dqcTWfUdUUgG/1vrD7jvUfW','ragavi@gmail.com',1,766438634,'Sri Lanka',1,'2021-04-09 00:00:00',0,NULL,NULL,1,NULL,NULL,NULL,'Puttur',212228856,NULL,1,1,'2022-02-22','F',NULL,NULL),(49,109,'Raguram Ragavi','ragavi@gmail.com','$2a$10$MV0pblqCMHo1F2OHqxKYPOdzvNsFS3TW3Vt6phnZPS9A/umkGS3Wa','ragavi@gmail.com',1,766438634,'Sri Lanka',1,'2021-04-09 00:00:00',0,NULL,NULL,1,NULL,NULL,NULL,'Puttur',212228856,'http://10.20.100.6/userImage/6.jpg',1,1,'2022-02-22','F',NULL,NULL),(50,1,'jeyapriya malathi','malathy@gmail.com','$2a$10$co8YvjEjB.biP6SQt4eYT./J2fiv3mk0TLPETnWCDAPpK3WxPkE.q','malathy@gmail.com',1,776455624,NULL,1,'2021-04-09 00:00:00',NULL,NULL,NULL,1,NULL,NULL,NULL,'Mannar',212227768,NULL,1,NULL,NULL,NULL,NULL,NULL),(51,1,'jeyapriya malathi','malathy@gmail.com','$2a$10$co8YvjEjB.biP6SQt4eYT./J2fiv3mk0TLPETnWCDAPpK3WxPkE.q','malathy@gmail.com',2,776455624,NULL,1,'2021-04-09 00:00:00',NULL,NULL,NULL,1,NULL,NULL,NULL,'Mannar',212227768,NULL,1,NULL,NULL,NULL,NULL,NULL),(52,1,'jeyapriya malathi','malathy@gmail.com','$2a$10$co8YvjEjB.biP6SQt4eYT./J2fiv3mk0TLPETnWCDAPpK3WxPkE.q','malathy@gmail.com',1,776455624,NULL,1,'2021-04-09 00:00:00',NULL,NULL,NULL,1,NULL,NULL,NULL,'Mannar',212227768,NULL,1,NULL,NULL,NULL,NULL,NULL),(53,0,'Sathu Rangan','sathu@gmail.com','$2a$10$udG/r4ReE9fuuxLgzJNKhu/b4dJ3jBI7VErlkByUK7.zA1pBlTk.m','sathu@gmail.com',1,766438634,'Sri Lanka',1,'2021-04-09 00:00:00',0,NULL,NULL,1,NULL,NULL,NULL,'Puttur',212228856,NULL,1,1,'2022-02-22','F',NULL,NULL),(54,0,'dsadasd','dssads@gmail.com','$2a$10$5iAgw1axnoE1xPQKJOi3R.ms6ASaaxcp5ZtoWPJO.IJ5e9wUk.m5u','dssads@gmail.com',1,1234567890,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'styloo@test.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,0,'dsadasd','dssad99@gmail.com','$2a$10$Qd8p.HjPmbGvClMqAwX/ZOWLO.4.PghBVoO2p8ioE2RxyakcMj3f6','dssad99@gmail.com',1,1234599890,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'styloo@test.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,0,'Winrar','sdsd@gmail.com','$2a$10$UZIxAhmnQ4oSzLfNJALfvOn8dP0SRCvOaMgrxGOd2bfpqw1Uc/dzq','sdsd@gmail.com',1,234567,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'styloo@test.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,0,'sdsfdsfsfds','sdsddfdfd@gmail.com','$2a$10$lXtNzvQ12em4sa0kTZtaqumk1y6hN9ja0a4PBRgq7HaHSoBA3OZ2K','sdsddfdfd@gmail.com',1,545434567,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'styloo@test.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,0,'werwerwer','erwerwrew@gamil.com','$2a$10$KysoOYKcXJVZQY0VV2sPCep8G1VguQA9lNJraPiw.AXY.YN2QJ5HO','erwerwrew@gamil.com',1,123456789,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'styloo@test.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,0,'Thanusriii','mitebif267@5k2u.com','$2a$10$/aeSzBs6B1p7zO9TNlrh3OzKnfG7xmME/kW1b6011abxO9A/ubMf.','mitebif267@5k2u.com',1,776543234,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,0,'Thanusri','jorohif933@anlubi.com','$2a$10$vbo9uzHi9aQ2X7e3tafbp..8bXDoXXg6GHQLVW5/q5Qn5n.yHF2P.','jorohif933@anlubi.com',1,778976554,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'zxcvbhtsx',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,0,'Thanusrii','bekaw80157@5k2u.com','$2a$10$1t0DlQC9paKBBl3W69hECO4ldp15GeJEFKM5rXgqBmcMPaekSsktW','bekaw80157@5k2u.com',1,778976543,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffnaa',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,0,'Thanusrii','mapafic936@altpano.com','$2a$10$wAHQaDAqrR35dQl1QWorfu4C2SpA7oDL5KlgmHLEULAnbvZTLW6GS','mapafic936@altpano.com',1,778976543,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffnaa',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,0,'Thanusrii','jejaf41539@5k2u.com','$2a$10$QZZB8b677I3/64fO9JYMael0TNZOOjkM6iQc/CpiWGhUPHbeKFXge','jejaf41539@5k2u.com',1,778976543,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffnaa',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,0,'Thanusrii','lejafa4136@anlubi.com','$2a$10$VAibb0AQ9tSR2acvBu/NwOsjq7AOb931816VLZkLVgUc5XRtLVF4K','lejafa4136@anlubi.com',1,778976543,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffnaa',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,0,'Thanusri','gijedo6441@anlubi.com','$2a$10$Zyts1FXsungUrx/bNDo.PuyAUDCX4xSE7oucqXzsRqHWyprLEOKNG','gijedo6441@anlubi.com',1,788998755,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,0,'Thanusri','nepifit852@5k2u.com','$2a$10$TgF3pm/zIipczbkQH9GEQeDLrD8zpfs8YDT3XVXlL17lOlaN.q4Lu','nepifit852@5k2u.com',1,987654320,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'y7yfghj',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,0,'Nihal Perera','yepota8286@chimpad.com','$2a$10$9O8xFBLS0s2gGqCqO2JL9.6djjkhK.G58hLNBwEg7DLdJ6n4my9Ga','yepota8286@chimpad.com',1,763467223,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Temple Road , Dehiwala',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,0,'thanusha','litafa8719@agrolivana.com','$2a$10$PrDTllLfaL1hkyR.0aFvLu1ujDjtr33yb6hdXfLI8tgoFEGFgWZq2','litafa8719@agrolivana.com',1,777969921,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,0,'Thanusri','yopoj11646@anlubi.com','$2a$10$qhBmcQA6ITy0/fa1ak0g9.rO.dfYPIo7xuwFQhgZfns4ChCRjD2aC','yopoj11646@anlubi.com',1,887654221,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,0,'thanu','lacovo5660@altpano.com','$2a$10$NOTKaa31.rb36LB/NxgUzeZuLDSOxto6D9dbNaPrJKnJTMeRzQpDu','lacovo5660@altpano.com',1,773567899,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,0,'Romert Annciley','romertw@codelantic.com','$2a$10$PI0V3FcfenHa9Elfp0aY2einP/SQBC4F8qQQCTmeEP42kIc2NvVvO','romertw@codelantic.com',1,1234567890,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'address',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,0,'Alfreda Christensen','ksdjfks@gmail.com','$2a$10$BA8b9zbq8d4zG.IOAshsQOAGqRKnHOWqDZtJjyCwWx/LtyKU.qqdC','ksdjfks@gmail.com',1,2122222222,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'sddasasd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,0,'thanu ','bobaba5608@altpano.com','$2a$10$pKAX84x2mvg277hE4R0sQui.oCUurMpsxpydoiPjOEMYDqNC2VRBW','bobaba5608@altpano.com',1,777876549,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,0,'Thanusri','xorohok732@5k2u.com','$2a$10$Vrjjhwii6z20/pDTZycYnu9nCJ5ZlMPiCZoCzEoOgZN6gCTVtSypi','xorohok732@5k2u.com',1,778990976,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,0,'Kim Baldwin','ruwu@mailinator.com','$2a$10$gm.YyvMEXd4ATf14owNLrO0L2ADDrcuS0oTh0cW.rw4rfAqCRdgCe','ruwu@mailinator.com',1,766931072,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'Nulla ut dolorem ut ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,0,'thanusha','xakiw26408@anlubi.com','$2a$10$2PK7RZxd5I0W/KsqTZ1OAeMh1Vr.9FVJJs/GKBIqjq9oOygvVKOsK','xakiw26408@anlubi.com',1,778987650,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'colombo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,0,'yadevi Rupasinghe','xafafe9468@logodez.com','$2a$10$hiweSVUvjcVRoYTILbxmSuN/xAHi8lboqYotpa0TNxz21pQtczqTu','xafafe9468@logodez.com',1,751673568,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,0,'Thanusri','nowile3657@anlubi.com','$2a$10$o7eklywRStHi.MX060Vv8.b/1SqG4IyCuD6siKv1eMeu1SyqplVyi','nowile3657@anlubi.com',1,778987650,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(79,0,'thanusha','meweta7025@altpano.com','$2a$10$xJjdOsDncPJpgq63n1EIZ.1I17qJPDGwxWlTFZ8iaf5JoAojqyzOS','meweta7025@altpano.com',1,778989900,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'jaffna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,0,'thanusha','poyetet714@altpano.com','$2a$10$iCgBxoBG/RZsz7q8Gl7BjeggNq2Irdidbxylt3qJsZm6A1FGxBmi2','poyetet714@altpano.com',1,778987654,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'colombo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- 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=3 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `user_role` VALUES (1,1,1,1,'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=4 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);

--
-- Dumping events for database 'styloo'
--

--
-- Dumping routines for database 'styloo'
--


