-- MySQL dump 10.13 Distrib 8.0.40, for Win64 (x86_64) -- -- Host: 127.0.0.1 Database: dev_crm -- ------------------------------------------------------ -- Server version 8.0.40 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `assign_enquiries` -- DROP TABLE IF EXISTS `assign_enquiries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `assign_enquiries` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `enquiry_id` int NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '0', `date` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `assign_enquiries` -- LOCK TABLES `assign_enquiries` WRITE; /*!40000 ALTER TABLE `assign_enquiries` DISABLE KEYS */; INSERT INTO `assign_enquiries` VALUES (1,29,1,0,'2024-10-04 06:30:04'),(2,30,1,1,'2024-10-04 06:35:29'),(3,31,2,1,'2024-10-04 06:45:58'),(4,33,3,1,'2024-10-04 08:56:42'),(5,33,4,1,'2024-10-04 09:07:28'),(6,33,5,1,'2024-10-04 12:02:26'),(7,29,6,0,'2024-10-04 13:12:41'),(8,30,7,1,'2024-10-04 13:12:59'),(9,31,8,0,'2024-10-04 13:13:15'),(10,33,9,1,'2024-10-04 13:13:27'),(11,29,10,0,'2024-10-04 14:05:31'),(12,30,11,1,'2024-10-04 14:05:58'),(13,31,12,1,'2024-10-04 14:06:19'),(14,33,13,1,'2024-10-04 14:06:34'),(15,29,14,1,'2024-10-04 14:33:01'),(16,30,15,1,'2024-10-04 14:33:19'),(17,31,16,1,'2024-10-04 14:33:39'),(18,33,17,1,'2024-10-04 14:33:55'),(19,30,8,1,'2024-10-04 15:43:39'),(20,33,18,1,'2024-10-05 11:33:55'),(21,30,6,0,'2024-11-08 12:08:32'),(22,31,10,1,'2024-11-08 13:14:10'),(23,31,6,0,'2024-11-11 18:17:30'),(24,33,6,1,'2024-11-11 18:49:22'),(25,28,23,1,'2024-11-18 05:52:27'),(26,28,24,1,'2024-11-18 05:53:35'),(27,28,25,1,'2024-11-18 05:54:43'),(28,28,26,1,'2024-11-18 06:04:24'),(29,33,27,1,'2024-11-18 08:19:06'),(30,28,28,1,'2024-11-19 05:37:03'),(31,28,29,1,'2024-11-19 06:37:12'),(32,30,30,1,'2024-11-22 07:26:43'); /*!40000 ALTER TABLE `assign_enquiries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `category_level_four` -- DROP TABLE IF EXISTS `category_level_four`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `category_level_four` ( `id` int NOT NULL AUTO_INCREMENT, `category_level_three_id` int DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `category_level_three_id` (`category_level_three_id`), CONSTRAINT `category_level_four_ibfk_1` FOREIGN KEY (`category_level_three_id`) REFERENCES `category_level_three` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `category_level_four` -- LOCK TABLES `category_level_four` WRITE; /*!40000 ALTER TABLE `category_level_four` DISABLE KEYS */; INSERT INTO `category_level_four` VALUES (15,14,'October 2024'),(19,19,'December 2024'),(20,20,'November 2024'),(21,21,'October 2024'),(22,22,'October 2024'),(23,23,'September 2024'),(24,24,'September 2024'),(25,25,'December 2024'); /*!40000 ALTER TABLE `category_level_four` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `category_level_one` -- DROP TABLE IF EXISTS `category_level_one`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `category_level_one` ( `id` int NOT NULL AUTO_INCREMENT, `office_id` int DEFAULT NULL, `organization_id` int DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `organization_id` (`organization_id`), KEY `office_id` (`office_id`), CONSTRAINT `category_level_one_ibfk_1` FOREIGN KEY (`organization_id`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `category_level_one_ibfk_2` FOREIGN KEY (`office_id`) REFERENCES `office` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `category_level_one` -- LOCK TABLES `category_level_one` WRITE; /*!40000 ALTER TABLE `category_level_one` DISABLE KEYS */; INSERT INTO `category_level_one` VALUES (21,18,NULL,'Energy System'),(27,20,NULL,'Audit'); /*!40000 ALTER TABLE `category_level_one` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `category_level_three` -- DROP TABLE IF EXISTS `category_level_three`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `category_level_three` ( `id` int NOT NULL AUTO_INCREMENT, `category_level_two_id` int DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `category_level_two_id` (`category_level_two_id`), CONSTRAINT `category_level_three_ibfk_1` FOREIGN KEY (`category_level_two_id`) REFERENCES `category_level_two` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `category_level_three` -- LOCK TABLES `category_level_three` WRITE; /*!40000 ALTER TABLE `category_level_three` DISABLE KEYS */; INSERT INTO `category_level_three` VALUES (14,17,'Level 3 Diploma in Accounting and Finance'),(19,22,'Level 7 Diploma in Business Management'),(20,23,'Level 5 Diploma in Health and Social Care Management'),(21,24,'Level 7 Diploma in Information Technology'),(22,25,'Level 5 Diploma in Law'),(23,26,'Level 8 Diploma in Strategic Management and Leadership'),(24,28,'Level 7 Diploma in Leadership'),(25,29,'Level 3 Diploma Foundation in Social Care'); /*!40000 ALTER TABLE `category_level_three` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `category_level_two` -- DROP TABLE IF EXISTS `category_level_two`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `category_level_two` ( `id` int NOT NULL AUTO_INCREMENT, `category_level_one_id` int DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `category_level_one_id` (`category_level_one_id`), CONSTRAINT `category_level_two_ibfk_1` FOREIGN KEY (`category_level_one_id`) REFERENCES `category_level_one` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `category_level_two` -- LOCK TABLES `category_level_two` WRITE; /*!40000 ALTER TABLE `category_level_two` DISABLE KEYS */; INSERT INTO `category_level_two` VALUES (17,21,'Accounting and Finance'),(22,27,'Business Management'),(23,27,'Health and Social Care'),(24,21,'Information Systems'),(25,21,'Legal Studies'),(26,21,'Business Studies'),(28,27,'Leadership Studies'),(29,27,'Social Care'); /*!40000 ALTER TABLE `category_level_two` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `complaint_bd` -- DROP TABLE IF EXISTS `complaint_bd`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `complaint_bd` ( `id` int NOT NULL AUTO_INCREMENT, `enquiry_id` int DEFAULT NULL, `to_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `email_subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `email_body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `type_of` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `status_request` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `complaint_bd` -- LOCK TABLES `complaint_bd` WRITE; /*!40000 ALTER TABLE `complaint_bd` DISABLE KEYS */; /*!40000 ALTER TABLE `complaint_bd` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `enquiries` -- DROP TABLE IF EXISTS `enquiries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `enquiries` ( `id` int NOT NULL AUTO_INCREMENT, `enquiry_by` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `enquiry_entered_by` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `income_range` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `enquiry_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `username` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `cnic` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `date_of_birth` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `email` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `father_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `gender` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `city` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `present_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `permanent_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `mobile_no_one` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `mobile_no_two` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `landline` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `project` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `product` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `developer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `price_offered` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `property_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `source_of_information` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `status` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `enquiry_status` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_one` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_two` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_three` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_four` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_five` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_six` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_seven` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_eight` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_nine` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_ten` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_eleven` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_twelve` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_thirteen` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_fourteen` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_fifteen` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_sixteen` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_seventeen` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_eighteen` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_nineteen` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `field_twenty` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `office_id` int DEFAULT NULL, `matured` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `cat_one_id` int DEFAULT NULL, `cat_two_id` int DEFAULT NULL, `cat_three_id` int DEFAULT NULL, `cat_four_id` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `enquiry_status_steps` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `office_id` (`office_id`), KEY `cat_one_id` (`cat_one_id`), KEY `cat_two_id` (`cat_two_id`), KEY `cat_three_id` (`cat_three_id`), KEY `cat_four_id` (`cat_four_id`), CONSTRAINT `enquiries_ibfk_1` FOREIGN KEY (`office_id`) REFERENCES `office` (`id`) ON DELETE CASCADE, CONSTRAINT `enquiries_ibfk_2` FOREIGN KEY (`cat_one_id`) REFERENCES `category_level_one` (`id`) ON DELETE CASCADE, CONSTRAINT `enquiries_ibfk_3` FOREIGN KEY (`cat_two_id`) REFERENCES `category_level_two` (`id`) ON DELETE CASCADE, CONSTRAINT `enquiries_ibfk_4` FOREIGN KEY (`cat_three_id`) REFERENCES `category_level_three` (`id`) ON DELETE CASCADE, CONSTRAINT `enquiries_ibfk_5` FOREIGN KEY (`cat_four_id`) REFERENCES `category_level_four` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `enquiries` -- LOCK TABLES `enquiries` WRITE; /*!40000 ALTER TABLE `enquiries` DISABLE KEYS */; INSERT INTO `enquiries` VALUES (6,'John','John','10,000 - 20,000',NULL,'Nolan',NULL,'2000-10-10','nolan@gmail.com','Cameron','Male','London','51 Boar Lane','51 Boar Lane','02012345678','02087654321','0206598977',NULL,NULL,NULL,'5000',NULL,NULL,'Social Media','Follow-up Required','Follow-up Required','He will inform later',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,'0',21,17,14,15,'2024-10-04 12:05:39','Applicant Interview'),(7,'admin','admin','20,000 - 30,000',NULL,'Isaac',NULL,'2002-12-15','isaac@gmail.com','Dylaan','Male','London','52 Boar Lane','52 Boar Lane','02085214698','02032587001','020069596897',NULL,NULL,NULL,'7000',NULL,NULL,'Friend & Family Members','Lead Matured','Follow-up Required','He will contact soon',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,'0',21,24,21,21,'2024-10-04 12:07:48','Lead Matured'),(8,'zubair','zubair','30,000 - 40,000',NULL,'Anthony',NULL,'2001-10-15','carter@gmail.com','Carter','Male','Manchester','55 Boar Lane','55 Boar Lane','02065478125','02025887168','02021488540',NULL,NULL,NULL,'9000',NULL,NULL,'Social Media',NULL,'Follow-up Required','Call next week',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,20,'0',27,22,19,19,'2024-10-04 12:09:14','Lead Matured'),(9,'Jacob','Jacob','20,000 - 30,000',NULL,'Axel',NULL,'2003-08-10','axel@gmail.com','Walker','Male','Manchester',' 57 Boar Lane','57 Boar Lane','020365657841','02032144478','02022577895',NULL,NULL,NULL,'10000',NULL,NULL,'Friend & Family Members','Lead Matured','Follow-up Required','Not sure now',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,20,'0',27,23,20,20,'2024-10-04 12:11:25','Negotiation'),(10,'admin','admin','10,000 - 20,000',NULL,'Easton',NULL,'1999-06-15','easton@gmail.com','Bennett','Male','London','58 Boar Lane','58 Boar Lane','02055989778','02054778156','02079460000',NULL,NULL,NULL,'11000',NULL,NULL,'Friend & Family Members','Call Disconnected','Follow-up Required','Not sure now',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,'0',21,25,22,22,'2024-10-04 12:50:36','Lead Capturing'),(11,'admin','admin','20,000 - 30,000',NULL,'Jose',NULL,'2003-12-10','jose@gmail.com','Colton','Male','London','59 Boar Lane','59 Boar Lane','02054447820','02065477102','020795654180',NULL,NULL,NULL,'12000',NULL,NULL,'Social Media','Dropped','Follow-up Required','Call next week',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,'0',21,26,23,23,'2024-10-04 12:52:33','Dropped'),(12,'zubair','zubair','30,000 - 40,000',NULL,'River',NULL,'2002-10-10','river@gmail.com','Austin','Male','Manchester','60 Boar Lane','60 Boar Lane','02054790257','02035774109','02098715205',NULL,NULL,NULL,'13000',NULL,NULL,'Friend & Family Members',NULL,'Follow-up Required','He will inform later',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,20,'0',27,28,24,24,'2024-10-04 13:00:16','Lead Qualification'),(13,'Jacob','Jacob','20,000 - 30,000',NULL,'Jasper',NULL,'2004-12-12','Jasper','Bryson','Male','Manchester','61 Boar Lane','61 Boar Lane','02031255781','02032589410','02036485201',NULL,NULL,NULL,'15000',NULL,NULL,'Social Media','Wrong Number','Follow-up Required','He will contact soon',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,20,'0',27,29,25,25,'2024-10-04 13:02:15','Proposal/ Quotation'),(22,'lsbc','lsbc','undefined','undefined','undefined','undefined','undefined','undefined','undefined','undefined','undefined','undefined','undefined','undefined','undefined','undefined','undefined','16','undefined','undefined','undefined',NULL,'undefined',NULL,'undefined','undefined','undefined','undefined','undefined','undefined','undefined','undefined','undefined','undefined','undefined','undefined',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,'1',21,17,14,15,'2024-11-14 08:35:29','Initial Application Review'),(23,NULL,'Data Entry operator 1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,'0',21,17,14,15,'2024-11-18 05:52:27','Lead Capturing'),(24,NULL,'Data Entry operator 1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Follow-up Required',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,'0',21,17,14,15,'2024-11-18 05:53:35','Lead Capturing'),(25,NULL,'Data Entry operator 1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,'0',21,17,14,15,'2024-11-18 05:54:43','Lead Capturing'),(26,NULL,'Data Entry operator 1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Array',NULL,NULL,NULL,NULL,NULL,'Follow-up Required',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,'0',21,17,14,15,'2024-11-18 06:04:24','Lead Capturing'),(27,NULL,'Data Entry operator 1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'16,17',NULL,NULL,NULL,NULL,NULL,'Follow-up Required',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,'0',21,17,14,15,'2024-11-18 08:19:06','Lead Matured'),(28,NULL,'Data Entry operator 1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3144226842',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,'0',21,17,14,15,'2024-11-19 05:37:02','Lead Capturing'),(29,NULL,'Data Entry operator 1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dropped',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3144226842',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,'0',21,17,14,15,'2024-11-19 06:37:11','Dropped'); /*!40000 ALTER TABLE `enquiries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `enquiry_fields` -- DROP TABLE IF EXISTS `enquiry_fields`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `enquiry_fields` ( `id` int NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `field_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `status` tinyint(1) NOT NULL, `type` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `show_field` tinyint(1) NOT NULL DEFAULT '0', `report_show` tinyint NOT NULL DEFAULT '0', `order_no` int DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `enquiry_fields` -- LOCK TABLES `enquiry_fields` WRITE; /*!40000 ALTER TABLE `enquiry_fields` DISABLE KEYS */; INSERT INTO `enquiry_fields` VALUES (1,'Lead Entered By','enquiry_by',0,'Drop Down',1,0,20),(2,'Lead Handled By','enquiry_entered_by',1,'Drop Down',1,0,10),(4,'Income Range (GBP)','income_range',0,'Drop Down',1,0,130),(5,'Visa Status','enquiry_date',0,'Drop Down',1,1,1000),(6,'First Name','username',0,'Text',1,1,30),(7,'Middle Name','cnic',0,'Text',1,0,1100),(8,'Date of Birth','date_of_birth',0,'Date',1,0,140),(9,'Email','email',0,'Text',1,0,90),(10,'Last Name','father_name',0,'Text',1,1,40),(11,'Gender','gender',0,'Drop Down',1,0,50),(12,'City','city',0,'Text',1,0,120),(13,'Present Address','present_address',0,'Text',1,0,110),(14,'Permanent Address','permanent_address',0,'Text',1,0,100),(15,'Mobile No. ','mobile_no_one',0,'Number',1,1,60),(16,'Mobile No. (secondary)','mobile_no_two',0,'Number',1,0,70),(17,'Landline','landline',0,'Number',1,0,80),(18,'Birth Country','project',0,'Drop Down',1,0,1300),(19,'Nationality','product',0,'Drop Down',1,0,1400),(20,'Ethnic Origin','developer',0,'Drop Down',1,0,1500),(21,'Course Fee (GBP)','price_offered',0,'Number',1,0,150),(22,'Religion','property_address',0,'Drop Down',1,0,1600),(23,'Sexual Orientation','image \r\n',0,'Drop Down',1,0,1700),(24,'Hear About us','source_of_information',0,'Drop Down',1,0,160),(25,'Passport Issue','enquiry_status',0,'Date',1,0,2800),(26,'Criminal Conviction','remarks',0,'Drop Down',1,1,170),(27,'Course Title','field_one',0,'Drop Down',1,0,1800),(28,'Intake','field_two',0,'Drop Down',1,0,1900),(29,'Year','field_three',0,'Drop Down',1,0,2000),(30,'Course Start Date','field_four',0,'Date',0,1,2100),(31,'Course End Date','field_five',0,'Date',1,0,2200),(32,'Place of Study/Campus','field_six',0,'Drop Down',1,0,2300),(33,'Visa Required','field_seven',0,'Drop Down',1,0,2400),(34,'Visa Valid From','field_eight',0,'Date',1,0,2500),(35,'Visa Expiry','field_nine',0,'Date',1,0,2600),(36,'Passport No.','field_ten',0,'Text',1,0,2700),(37,'field_eleven','field_eleven',0,'Text',1,0,2800),(38,'Contact','field_twelve',1,'Text',1,0,2900),(39,'field_thirteen','field_thirteen',0,'Text',1,0,3000),(40,'field_fourteen','field_fourteen',0,'Text',1,0,3100),(41,'field_fifteen','field_fifteen',0,'Text',1,0,3200),(42,'field_sixteen','field_sixteen',0,'Text',1,0,3300),(43,'field_seventeen','field_seventeen',0,'Text',1,0,3400),(44,'field_eighteen','field_eighteen',0,'Text',1,0,3500),(45,'field_nineteen','field_nineteen',0,'Text',1,0,3600),(46,'field_twenty','field_twenty',0,'Text',1,0,3700); /*!40000 ALTER TABLE `enquiry_fields` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `enquiry_fields_dropdown` -- DROP TABLE IF EXISTS `enquiry_fields_dropdown`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `enquiry_fields_dropdown` ( `id` int NOT NULL AUTO_INCREMENT, `dropdown` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `field_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `enquiry_fields_dropdown` -- LOCK TABLES `enquiry_fields_dropdown` WRITE; /*!40000 ALTER TABLE `enquiry_fields_dropdown` DISABLE KEYS */; INSERT INTO `enquiry_fields_dropdown` VALUES (12,'Admission Officer','enquiry_by'),(13,'LAP Centre','enquiry_by'),(14,'Data Entry operator 1','enquiry_entered_by'),(15,'Data Entry operator 2','enquiry_entered_by'),(20,'10,000 - 20,000','income_range'),(21,'20,000 - 30,000','income_range'),(22,'30,000 - 40,000','income_range'),(25,'Social Media','source_of_information'),(26,'Friend & Family Members','source_of_information'),(30,'Matured','enquiry_status'),(31,'Dropped','enquiry_status'),(32,'Follow-up Required','enquiry_status'),(35,'Male','gender'),(36,'Female','gender'),(37,'Prefer not to say','gender'),(38,'Pakistan','project'),(39,'Pakistan','product'),(40,'Yes','field_seven'),(41,'No','field_seven'),(42,'Granted','enquiry_date'),(43,'Rejected','enquiry_date'),(44,'Pending','enquiry_date'); /*!40000 ALTER TABLE `enquiry_fields_dropdown` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `enquiry_images` -- DROP TABLE IF EXISTS `enquiry_images`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `enquiry_images` ( `id` int NOT NULL AUTO_INCREMENT, `image_path` text, `title` text, `enquiry_id` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `enquiry_images` -- LOCK TABLES `enquiry_images` WRITE; /*!40000 ALTER TABLE `enquiry_images` DISABLE KEYS */; INSERT INTO `enquiry_images` VALUES (1,'673ad65fb9574_141-536x354.jpg','AA',24),(2,'673ad6a3c9a16_141-536x354.jpg','AAA',25),(3,'673ad8e93a10a_logo.png','AAAA',26),(4,'673af87ab50d7_141-536x354.jpg','AAA',27),(5,'673c32194e8d3_141-536x354.jpg','AA',29),(8,'674036c28918d_WhatsApp Image 2024-11-12 at 20.13.44_9289a816.jpg','asdffdg',31),(9,'67419f39752b1_WhatsApp Image 2024-11-12 at 20.13.44_cbd55f83.jpg','abc',32),(10,'6741a2787fec9_WhatsApp Image 2024-11-12 at 20.13.44_cbd55f83.jpg','file1',33); /*!40000 ALTER TABLE `enquiry_images` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `enquiry_products` -- DROP TABLE IF EXISTS `enquiry_products`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `enquiry_products` ( `id` int NOT NULL AUTO_INCREMENT, `enquiry_id` int DEFAULT NULL, `product_id` int DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `enquiry_products` -- LOCK TABLES `enquiry_products` WRITE; /*!40000 ALTER TABLE `enquiry_products` DISABLE KEYS */; INSERT INTO `enquiry_products` VALUES (3,2,1,'2024-08-08 13:12:03'),(4,2,2,'2024-08-08 13:12:03'),(5,1,1,'2024-08-09 12:17:41'),(6,1,3,'2024-08-09 12:17:41'),(8,7,9,'2024-09-12 09:56:52'),(9,8,10,'2024-09-24 06:56:07'),(10,9,11,'2024-09-24 11:40:20'),(12,10,10,'2024-09-27 13:51:12'),(14,15,13,'2024-10-02 06:45:57'),(15,15,14,'2024-10-02 06:45:57'),(18,3,16,'2024-10-04 07:54:30'),(20,4,16,'2024-10-04 08:06:45'),(21,26,16,'2024-11-18 07:16:30'),(22,26,17,'2024-11-18 07:16:31'); /*!40000 ALTER TABLE `enquiry_products` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `follow_up` -- DROP TABLE IF EXISTS `follow_up`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `follow_up` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int DEFAULT NULL, `enquiry_id` int DEFAULT NULL, `called_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `called_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `called_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `price_offered` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `followup_date` date DEFAULT NULL, `next_followup_date` date DEFAULT NULL, `created_at` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `follow_up_products` int DEFAULT NULL, `next_followup_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `location` json DEFAULT NULL, `dial_start_time` datetime DEFAULT NULL, `dial_end_time` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `follow_up` -- LOCK TABLES `follow_up` WRITE; /*!40000 ALTER TABLE `follow_up` DISABLE KEYS */; INSERT INTO `follow_up` VALUES (1,29,10,'','2','Call Disconnected',NULL,NULL,'2024-10-04','2024-10-06',NULL,NULL,NULL,NULL,NULL,NULL),(2,29,14,'','2','Phone Not Picked',NULL,NULL,'2024-10-04','2024-10-07',NULL,NULL,NULL,NULL,NULL,NULL),(3,33,13,'','1','Wrong Number',NULL,NULL,'2024-10-03','2024-10-06',NULL,NULL,NULL,NULL,NULL,NULL),(4,33,17,'','3','Follow-up Required',NULL,NULL,'2024-10-02','2024-10-08',NULL,NULL,NULL,NULL,NULL,NULL),(5,30,7,'','4','Lead Matured','gggg','900','2024-11-08','2024-11-08',NULL,NULL,NULL,NULL,NULL,NULL),(6,30,6,'','3','Follow-up Required',NULL,'5000','2024-11-08','2024-11-08',NULL,NULL,NULL,NULL,NULL,NULL),(7,30,6,'','3','Lead Matured',NULL,'4500','2024-11-08','2024-11-08',NULL,NULL,NULL,NULL,NULL,NULL),(8,30,6,'','5','Follow-up Required',NULL,'4000','2024-11-07','2024-11-10',NULL,NULL,NULL,NULL,NULL,NULL),(9,28,24,'','3','Follow-up Required','123','123','2024-11-18','2024-11-18',NULL,NULL,'Call',NULL,NULL,NULL),(10,28,26,'','4','Follow-up Required','asd','12333','2024-11-18','2024-11-19',NULL,NULL,'Meeting',NULL,NULL,NULL),(11,28,26,'','3','Follow-up Required','123','123','2024-11-18','2024-11-19',NULL,NULL,'Meeting',NULL,NULL,NULL),(12,28,26,'','3','Follow-up Required','123','123','2024-11-18','2024-11-18',NULL,NULL,'Call',NULL,NULL,NULL),(13,33,27,'','2','Follow-up Required','3','23','2024-11-18','2024-11-18',NULL,NULL,'Call',NULL,NULL,NULL),(14,28,6,'','3','Follow-up Required',NULL,NULL,'2024-11-18','2024-11-06',NULL,NULL,'Call',NULL,NULL,NULL),(15,28,6,'','3','Follow-up Required',NULL,NULL,'2024-11-19','2024-11-19',NULL,NULL,'Call','{\"speed\": null, \"heading\": null, \"accuracy\": 1344.135826565655, \"altitude\": null, \"latitude\": 31.4825593, \"longitude\": 74.3235425, \"altitudeAccuracy\": null}',NULL,NULL),(16,28,6,'','3','Follow-up Required',NULL,NULL,'2024-11-19','2024-11-19',NULL,NULL,'Call','{\"speed\": null, \"heading\": null, \"accuracy\": 1344.135826565655, \"altitude\": null, \"latitude\": 31.4825593, \"longitude\": 74.3235425, \"altitudeAccuracy\": null}',NULL,NULL),(17,28,15,'','3','Follow-up Required',NULL,NULL,'2024-11-19','2024-11-19',NULL,NULL,'Call','null',NULL,NULL),(18,28,6,'','3','Follow-up Required','123','123','2024-11-20','2024-11-20',NULL,NULL,'Call','null',NULL,NULL),(19,28,6,'','3','Follow-up Required','12','123','2024-11-20','2024-11-20',NULL,NULL,'Call','null','2024-11-20 00:00:00','2024-11-20 00:00:00'),(20,28,6,'','3','Follow-up Required',NULL,NULL,'2024-11-25','2024-11-26',NULL,NULL,'Call','null','2024-11-25 00:00:00','2024-11-25 00:00:00'),(21,28,6,'','3','Follow-up Required',NULL,NULL,'2024-11-25','2024-11-25',NULL,NULL,'Call','null','2024-11-25 00:00:00','2024-11-25 00:00:00'),(22,28,6,'','3','Follow-up Required',NULL,NULL,'2024-11-25','2024-11-25',NULL,NULL,'Call','null','2024-11-25 09:56:10','2024-11-25 09:56:14'),(23,28,30,'','3','Follow-up Required',NULL,NULL,'2024-11-27','2024-11-27',NULL,NULL,'Call','null','2024-11-27 12:36:36','2024-11-27 12:36:36'),(24,28,30,'','3','Follow-up Required',NULL,NULL,'2024-11-27','2024-11-29',NULL,NULL,'Call','null','2024-11-27 12:50:52','2024-11-27 12:50:52'),(25,28,30,'','4','Follow-up Required',NULL,NULL,'2024-11-27','2024-11-27',NULL,NULL,'Call','null','2024-11-27 12:52:06','2024-11-27 12:52:06'),(26,28,30,'','3','Follow-up Required',NULL,NULL,'2024-11-27','2024-11-27',NULL,NULL,'Call','null','2024-11-27 12:53:40','2024-11-27 12:53:49'),(27,28,29,'','3','Follow-up Required',NULL,NULL,'2024-11-27','2024-11-27',NULL,NULL,'Call','null','2024-11-27 14:04:36','2024-11-27 14:04:47'),(28,28,29,'','3','Follow-up Required',NULL,'12','2024-11-29','2024-11-29',NULL,NULL,'Call','null','2024-11-29 05:30:55','2024-11-29 05:30:55'),(29,28,29,'','3','Dropped',NULL,NULL,'2024-11-29','2024-11-29',NULL,NULL,'Call','null','2024-11-29 05:31:48','2024-11-29 05:31:48'),(30,28,29,'','3','Dropped',NULL,'1','2024-11-29','2024-11-29',NULL,NULL,'Call','null','2024-11-29 05:33:50','2024-11-29 05:33:53'),(31,28,29,'','3','Follow-up Required',NULL,NULL,'2024-11-29','2024-11-29',NULL,NULL,'Call','null','2024-11-29 05:34:08','2024-11-29 05:34:17'),(32,28,29,'','3','Dropped',NULL,NULL,'2024-11-29','2024-11-29',NULL,NULL,'Meeting','null','2024-11-29 05:34:28','2024-11-29 05:34:28'); /*!40000 ALTER TABLE `follow_up` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `follow_up_products` -- DROP TABLE IF EXISTS `follow_up_products`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `follow_up_products` ( `id` int NOT NULL AUTO_INCREMENT, `product_id` int DEFAULT NULL, `follow_up_id` int DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `follow_up_fk_id` (`follow_up_id`), CONSTRAINT `follow_up_fk_id` FOREIGN KEY (`follow_up_id`) REFERENCES `follow_up` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `follow_up_products` -- LOCK TABLES `follow_up_products` WRITE; /*!40000 ALTER TABLE `follow_up_products` DISABLE KEYS */; INSERT INTO `follow_up_products` VALUES (15,16,6,'2024-10-04 09:13:39'),(16,16,7,'2024-10-04 09:32:36'),(17,16,11,'2024-11-18 07:17:10'),(18,17,11,'2024-11-18 07:17:10'),(19,16,12,'2024-11-18 08:10:36'),(20,17,12,'2024-11-18 08:10:36'); /*!40000 ALTER TABLE `follow_up_products` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `office` -- DROP TABLE IF EXISTS `office`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `office` ( `id` int NOT NULL AUTO_INCREMENT, `organization_id` int DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `sender_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `port` int DEFAULT NULL, `quot_inactive_days` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `organization_id` (`organization_id`), CONSTRAINT `office_ibfk_1` FOREIGN KEY (`organization_id`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `office` -- LOCK TABLES `office` WRITE; /*!40000 ALTER TABLE `office` DISABLE KEYS */; INSERT INTO `office` VALUES (18,21,'Lahore','xyz@gamil.com','123','123',123,30),(20,21,'Karachi','dave@gmail.com','456','admin',456,NULL),(21,21,'Islamabad','xyz@gmail.com','123','123',123,NULL),(22,21,'Lahore','123','123','admin',123,30),(23,21,'A','A','A','admin',1,123),(24,21,'b','v','v','admin',1,1); /*!40000 ALTER TABLE `office` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `organization` -- DROP TABLE IF EXISTS `organization`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `organization` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `currency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'PKR', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `organization` -- LOCK TABLES `organization` WRITE; /*!40000 ALTER TABLE `organization` DISABLE KEYS */; INSERT INTO `organization` VALUES (21,'Enfo','PKR'); /*!40000 ALTER TABLE `organization` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `permissions` ( `id` int NOT NULL AUTO_INCREMENT, `role_id` int DEFAULT NULL, `user_tab` tinyint DEFAULT '0', `user_add` tinyint(1) DEFAULT NULL, `user_view` tinyint(1) DEFAULT NULL, `user_delete` tinyint(1) DEFAULT NULL, `user_edit` tinyint(1) DEFAULT NULL, `role_tab` tinyint(1) DEFAULT NULL, `role_add` tinyint(1) DEFAULT NULL, `role_delete` tinyint(1) DEFAULT NULL, `organization_tab` tinyint(1) DEFAULT NULL, `organization_add` tinyint(1) DEFAULT NULL, `organization_delete` tinyint(1) DEFAULT NULL, `office_tab` tinyint(1) DEFAULT NULL, `office_add` tinyint(1) DEFAULT NULL, `office_delete` tinyint(1) DEFAULT NULL, `cat_level_one_tab` tinyint(1) DEFAULT NULL, `cat_level_one_add` tinyint(1) DEFAULT NULL, `cat_level_one_delete` tinyint(1) DEFAULT NULL, `cat_level_two_tab` tinyint(1) DEFAULT NULL, `cat_level_two_add` tinyint(1) DEFAULT NULL, `cat_level_two_delete` tinyint(1) DEFAULT NULL, `cat_level_three_tab` tinyint(1) DEFAULT NULL, `cat_level_three_add` tinyint(1) DEFAULT NULL, `cat_level_three_delete` tinyint(1) DEFAULT NULL, `cat_level_four_tab` tinyint(1) DEFAULT NULL, `cat_level_four_add` tinyint(1) DEFAULT NULL, `cat_level_four_delete` tinyint(1) DEFAULT NULL, `enquiry_field_tab` tinyint(1) DEFAULT NULL, `enquiries_tab` tinyint(1) DEFAULT NULL, `enquiries_add` tinyint(1) DEFAULT NULL, `enquiries_delete` tinyint(1) DEFAULT NULL, `enquiries_edit` tinyint(1) DEFAULT NULL, `enquiries_view` tinyint(1) DEFAULT NULL, `enquiries_assign` tinyint(1) DEFAULT NULL, `follow_up_tab` tinyint(1) DEFAULT NULL, `follow_up_add` tinyint(1) DEFAULT NULL, `follow_up_view` tinyint(1) DEFAULT NULL, `customer_tab` tinyint(1) DEFAULT '0', `followup_report` tinyint NOT NULL DEFAULT '0', `enquiry_report` tinyint NOT NULL DEFAULT '0', `products_tab` tinyint NOT NULL DEFAULT '0', `products_add` tinyint NOT NULL DEFAULT '0', `products_edit` tinyint NOT NULL DEFAULT '0', `products_delete` tinyint NOT NULL DEFAULT '0', `cat_level_four_update` tinyint NOT NULL DEFAULT '0', `cat_level_three_update` tinyint NOT NULL DEFAULT '0', `cat_level_one_update` tinyint NOT NULL DEFAULT '0', `cat_level_two_update` tinyint NOT NULL DEFAULT '0', `organization_update` tinyint NOT NULL DEFAULT '0', `permissionscol` tinyint NOT NULL DEFAULT '0', `location_report` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permissions` -- LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; INSERT INTO `permissions` VALUES (51,10,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,NULL),(52,12,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,NULL),(53,11,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,NULL),(57,16,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,1,1,1,1,1,1,1,1,1,0,NULL),(58,17,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,NULL),(59,18,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,NULL),(60,19,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,NULL),(61,20,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,1,1,0,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL),(62,22,1,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL),(63,23,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,0,1,1,0,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL); /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_recevings` -- DROP TABLE IF EXISTS `product_recevings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `product_recevings` ( `id` int NOT NULL AUTO_INCREMENT, `quantity` int DEFAULT NULL, `date_recevings` text, `product_id` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_recevings` -- LOCK TABLES `product_recevings` WRITE; /*!40000 ALTER TABLE `product_recevings` DISABLE KEYS */; INSERT INTO `product_recevings` VALUES (1,213,NULL,16),(2,123,'2024-11-25T14:27:24.074Z',16),(3,11,'2024-11-25T14:37:03.443Z',18),(4,35,'2025-11-25T14:37:11.136Z',18),(5,10,'2024-11-27T13:11:25.654Z',22); /*!40000 ALTER TABLE `product_recevings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_service_charges` -- DROP TABLE IF EXISTS `product_service_charges`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `product_service_charges` ( `id` int NOT NULL AUTO_INCREMENT, `range_start` int DEFAULT NULL, `range_end` int DEFAULT NULL, `unit_price` int DEFAULT NULL, `product_id` int DEFAULT NULL, `unit` varchar(50) DEFAULT NULL, `additional_amount` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_service_charges` -- LOCK TABLES `product_service_charges` WRITE; /*!40000 ALTER TABLE `product_service_charges` DISABLE KEYS */; INSERT INTO `product_service_charges` VALUES (1,1,50,0,25,'Kw',0),(2,51,100,4000,25,'Kw',0),(3,101,1000,3000,25,'Kw',20000); /*!40000 ALTER TABLE `product_service_charges` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products` -- DROP TABLE IF EXISTS `products`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `products` ( `id` int NOT NULL AUTO_INCREMENT, `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `type_of_product` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `price` int NOT NULL DEFAULT '0', `quantity` int DEFAULT NULL, `supplier` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `products` -- LOCK TABLES `products` WRITE; /*!40000 ALTER TABLE `products` DISABLE KEYS */; INSERT INTO `products` VALUES (22,'Lvi1','N/A','Product','2024-11-27 09:46:52',20000,110,'Lvi1'),(23,'Lvi3','N/A','Product','2024-11-27 09:47:09',45000,96,'Lvi3'),(24,'Lvi9','N/A','Product','2024-11-27 09:47:28',90000,100,'Lvi9'),(25,'Energy Audit','N/A','Service','2024-11-27 09:47:56',15000,0,'N/A'); /*!40000 ALTER TABLE `products` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `quotations` -- DROP TABLE IF EXISTS `quotations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quotations` ( `id` int NOT NULL AUTO_INCREMENT, `enquiry_id` int DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `contact` varchar(255) DEFAULT NULL, `dated` varchar(255) DEFAULT NULL, `to_person` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `subject_quot` varchar(255) DEFAULT NULL, `analysis_of` varchar(255) DEFAULT NULL, `sincerely_from` varchar(255) DEFAULT NULL, `company_name` varchar(255) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `approval` enum('Pending','Approved') DEFAULT NULL, `is_sales_order` tinyint(1) DEFAULT NULL, `user_id` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `quotations` -- LOCK TABLES `quotations` WRITE; /*!40000 ALTER TABLE `quotations` DISABLE KEYS */; INSERT INTO `quotations` VALUES (1,30,'waseem@enfo.ai','+92-310-162 1444 ','2024-11-26T19:00:00.000Z','Dimotec Engineering Company','Lahore','Quotation for Energy Efficiency analysis',' Dimotec Engineering Company','Waseem Arshad','Industrial Energy Consultant',NULL,NULL,NULL,NULL),(2,29,'xyz@gmail.com','99','2024-11-26T19:00:00.000Z','ABC','Lahore','abc',NULL,'xyz','Energy Consultant',NULL,'Approved',1,NULL),(3,28,'ouremail.com','ourcontact','2025-05-27T19:00:00.000Z','cust name','cust address','subject',NULL,'our resp','design',0,'Approved',1,NULL),(4,27,'zubair@cfe-solutions.co.uk','test','2025-05-27T19:00:00.000Z','junaidaquirus12@gmail.com','asd','sdf',NULL,'asd','CFE',0,'Approved',1,NULL); /*!40000 ALTER TABLE `quotations` ENABLE KEYS */; UNLOCK TABLES; -- -- Temporary view structure for view `quotations_expiry` -- DROP TABLE IF EXISTS `quotations_expiry`; /*!50001 DROP VIEW IF EXISTS `quotations_expiry`*/; SET @saved_cs_client = @@character_set_client; /*!50503 SET character_set_client = utf8mb4 */; /*!50001 CREATE VIEW `quotations_expiry` AS SELECT 1 AS `id`*/; SET character_set_client = @saved_cs_client; -- -- Table structure for table `quotations_items` -- DROP TABLE IF EXISTS `quotations_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quotations_items` ( `id` int NOT NULL AUTO_INCREMENT, `quotations_id` int DEFAULT NULL, `product_id` int DEFAULT NULL, `service_category` int DEFAULT NULL, `quantity` int DEFAULT NULL, `service_units` int DEFAULT NULL, `service_units_price` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `quotations_items` -- LOCK TABLES `quotations_items` WRITE; /*!40000 ALTER TABLE `quotations_items` DISABLE KEYS */; INSERT INTO `quotations_items` VALUES (45,1,23,NULL,96,NULL,NULL),(46,1,25,NULL,NULL,10,NULL),(55,3,24,NULL,100,NULL,NULL),(56,3,25,NULL,NULL,12,NULL),(57,2,24,NULL,100,NULL,NULL),(58,2,25,NULL,NULL,110,NULL),(59,4,24,NULL,9,NULL,NULL),(60,4,25,NULL,NULL,34,NULL); /*!40000 ALTER TABLE `quotations_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `roles` ( `id` int NOT NULL AUTO_INCREMENT, `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `self_inquiries` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; INSERT INTO `roles` VALUES (10,'Admin',0),(12,'Admission Manager',0),(18,'Inquiry Officer',1),(19,'Admission Assistant',1),(20,'Recruitment Agent',1),(22,'Test',1),(23,'Sales Officer',1); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sales_order` -- DROP TABLE IF EXISTS `sales_order`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sales_order` ( `id` int NOT NULL AUTO_INCREMENT, `enquiry_id` int DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `contact` varchar(255) DEFAULT NULL, `dated` varchar(255) DEFAULT NULL, `to_person` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `subject_quot` varchar(255) DEFAULT NULL, `analysis_of` varchar(255) DEFAULT NULL, `sincerely_from` varchar(255) DEFAULT NULL, `company_name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sales_order` -- LOCK TABLES `sales_order` WRITE; /*!40000 ALTER TABLE `sales_order` DISABLE KEYS */; INSERT INTO `sales_order` VALUES (1,30,'waseem@enfo.ai','+92-310-162 1444 ','2024-11-26T19:00:00.000Z','Dimotec Engineering Company','Lahore','Quotation for Energy Efficiency analysis',' Dimotec Engineering Company','Waseem Arshad','Industrial Energy Consultant'),(2,29,'xyz@gmail.com','99999999','2024-11-26T19:00:00.000Z','ABC','Lahore','abc','aa','xyz','Energy Consultant'); /*!40000 ALTER TABLE `sales_order` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sales_order_items` -- DROP TABLE IF EXISTS `sales_order_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sales_order_items` ( `id` int NOT NULL AUTO_INCREMENT, `quotations_id` int DEFAULT NULL, `product_id` int DEFAULT NULL, `service_category` int DEFAULT NULL, `quantity` int DEFAULT NULL, `price` int DEFAULT NULL, `service_units` int DEFAULT NULL, `service_units_price` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sales_order_items` -- LOCK TABLES `sales_order_items` WRITE; /*!40000 ALTER TABLE `sales_order_items` DISABLE KEYS */; INSERT INTO `sales_order_items` VALUES (1,1,23,NULL,96,NULL,NULL,NULL),(2,1,25,NULL,NULL,NULL,10,NULL),(3,2,24,NULL,100,NULL,NULL,NULL),(4,2,25,NULL,NULL,NULL,110,NULL); /*!40000 ALTER TABLE `sales_order_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_location` -- DROP TABLE IF EXISTS `user_location`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_location` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int DEFAULT NULL, `location` json DEFAULT NULL, `at_time` varchar(500) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_location` -- LOCK TABLES `user_location` WRITE; /*!40000 ALTER TABLE `user_location` DISABLE KEYS */; INSERT INTO `user_location` VALUES (2,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-19T08:29:12.424Z'),(3,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-19T08:32:21.201Z'),(4,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-19T08:36:01.251Z'),(5,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-19T08:41:12.930Z'),(6,28,'{}','2024-11-19T08:45:44.238Z'),(7,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-19T08:48:59.328Z'),(8,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-19T08:59:27.000Z'),(9,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-19T09:30:05.615Z'),(10,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-19T09:46:42.868Z'),(11,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-19T10:01:46.540Z'),(12,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-19T10:33:07.396Z'),(13,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-19T12:06:23.448Z'),(14,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-19T12:21:38.480Z'),(15,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-19T12:36:49.611Z'),(16,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-19T12:52:00.010Z'),(17,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-19T13:07:04.445Z'),(18,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-19T13:22:17.780Z'),(19,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-19T13:37:40.275Z'),(20,28,'{\"latitude\": 31.4512336, \"longitude\": 74.3125282}','2024-11-19T14:54:25.405Z'),(21,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-20T06:35:02.583Z'),(22,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-20T06:53:14.547Z'),(23,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-20T07:08:25.228Z'),(24,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-20T08:54:03.388Z'),(25,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-20T09:10:23.311Z'),(26,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-20T09:26:28.455Z'),(27,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-20T09:54:39.824Z'),(28,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-20T10:10:40.176Z'),(29,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-20T10:54:54.041Z'),(30,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-20T12:28:34.892Z'),(31,28,'{\"latitude\": 31.4825593, \"longitude\": 74.3235425}','2024-11-20T14:33:15.831Z'),(32,30,'{\"latitude\": 31.479431666666663, \"longitude\": 74.32581533333332}','2024-11-22T07:25:05.846Z'),(33,30,'{\"latitude\": 31.479431666666663, \"longitude\": 74.32581533333332}','2024-11-22T07:43:29.954Z'),(34,30,'{\"latitude\": 31.479431666666663, \"longitude\": 74.32581533333332}','2024-11-22T08:27:39.314Z'),(35,30,'{\"latitude\": 31.479431666666663, \"longitude\": 74.32581533333332}','2024-11-23T09:05:01.747Z'),(36,30,'{\"latitude\": 31.479431666666663, \"longitude\": 74.32581533333332}','2024-11-23T09:21:19.798Z'),(37,30,'{\"latitude\": 31.479431666666663, \"longitude\": 74.32581533333332}','2024-11-23T09:37:04.372Z'),(38,30,'{\"latitude\": 31.479431666666663, \"longitude\": 74.32581533333332}','2024-11-23T09:53:16.655Z'),(39,30,'{\"latitude\": 31.479431666666663, \"longitude\": 74.32581533333332}','2024-11-23T10:24:25.381Z'),(40,28,NULL,'2024-11-23T12:37:55.652Z'),(41,30,'{\"latitude\": 31.479431666666663, \"longitude\": 74.32581533333332}','2024-11-23T12:51:28.357Z'),(42,28,NULL,'2024-11-25T06:48:47.247Z'),(43,30,'{\"latitude\": 31.4794315, \"longitude\": 74.3258165}','2024-11-25T07:01:05.401Z'),(44,28,NULL,'2024-11-25T07:03:55.904Z'),(45,30,'{\"latitude\": 31.479432, \"longitude\": 74.325813}','2024-11-25T07:16:12.596Z'),(46,30,'{\"latitude\": 31.479432, \"longitude\": 74.325813}','2024-11-25T07:37:46.803Z'),(47,30,'{\"latitude\": 31.479431666666663, \"longitude\": 74.32581533333332}','2024-11-25T07:57:53.843Z'),(48,30,'{\"latitude\": 31.479431666666663, \"longitude\": 74.32581533333332}','2024-11-25T08:13:02.732Z'),(49,28,NULL,'2024-11-25T08:26:15.136Z'),(50,28,'{\"latitude\": 31.5088961, \"longitude\": 74.3272088}','2024-11-25T09:13:55.289Z'),(51,28,'{\"latitude\": 31.5088961, \"longitude\": 74.3272088}','2024-11-25T09:29:07.095Z'),(52,28,'{\"latitude\": 31.5088961, \"longitude\": 74.3272088}','2024-11-25T09:55:58.094Z'),(53,28,'{\"latitude\": 31.5088961, \"longitude\": 74.3272088}','2024-11-25T10:11:04.512Z'),(54,28,'{\"latitude\": 31.5088961, \"longitude\": 74.3272088}','2024-11-25T11:07:05.444Z'),(55,28,'{\"latitude\": 31.5088961, \"longitude\": 74.3272088}','2024-11-25T11:22:12.936Z'),(56,28,'{\"latitude\": 31.5088961, \"longitude\": 74.3272088}','2024-11-25T12:15:25.845Z'),(57,28,'{\"latitude\": 31.5088961, \"longitude\": 74.3272088}','2024-11-25T12:31:10.555Z'),(58,28,'{\"latitude\": 31.5088961, \"longitude\": 74.3272088}','2024-11-25T13:08:49.984Z'),(59,28,'{\"latitude\": 31.5088961, \"longitude\": 74.3272088}','2024-11-25T13:23:49.653Z'),(60,28,'{\"latitude\": 31.5088961, \"longitude\": 74.3272088}','2024-11-25T13:38:53.139Z'),(61,28,'{\"latitude\": 31.5088961, \"longitude\": 74.3272088}','2024-11-25T13:53:56.493Z'),(62,28,'{\"latitude\": 31.5088961, \"longitude\": 74.3272088}','2024-11-25T14:09:05.161Z'),(63,28,'{\"latitude\": 31.5088961, \"longitude\": 74.3272088}','2024-11-25T14:24:39.084Z'),(64,28,'{\"latitude\": 31.5088961, \"longitude\": 74.3272088}','2024-11-25T14:39:41.999Z'),(65,28,'{\"latitude\": 31.4792058, \"longitude\": 74.3259117}','2024-11-26T04:57:58.236Z'),(66,28,'{\"latitude\": 31.4792, \"longitude\": 74.3259096}','2024-11-26T05:12:59.340Z'),(67,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-26T07:07:05.945Z'),(68,28,'{\"latitude\": 31.4792, \"longitude\": 74.3259096}','2024-11-26T08:08:51.096Z'),(69,28,'{\"latitude\": 31.4792, \"longitude\": 74.3259096}','2024-11-26T08:23:54.703Z'),(70,28,'{\"latitude\": 31.4791968, \"longitude\": 74.3259033}','2024-11-26T08:38:58.707Z'),(71,28,'{\"latitude\": 31.4792, \"longitude\": 74.3259096}','2024-11-26T08:54:02.086Z'),(72,28,'{\"latitude\": 31.4792, \"longitude\": 74.3259096}','2024-11-26T09:09:05.810Z'),(73,28,'{\"latitude\": 31.4791968, \"longitude\": 74.3259033}','2024-11-26T09:24:09.324Z'),(74,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-26T09:56:24.405Z'),(75,28,'{\"latitude\": 31.4792, \"longitude\": 74.3259096}','2024-11-26T10:11:28.203Z'),(76,28,'{\"latitude\": 31.4792, \"longitude\": 74.3259096}','2024-11-26T10:26:31.297Z'),(77,28,'{\"latitude\": 31.4792, \"longitude\": 74.3259096}','2024-11-26T10:41:35.291Z'),(78,28,'{\"latitude\": 31.4792, \"longitude\": 74.3259096}','2024-11-26T10:56:36.855Z'),(79,28,'{\"latitude\": 31.4792, \"longitude\": 74.3259096}','2024-11-26T11:11:43.408Z'),(80,28,'{\"latitude\": 31.4792, \"longitude\": 74.3259096}','2024-11-26T11:26:47.961Z'),(81,28,'{\"latitude\": 31.4792, \"longitude\": 74.3259096}','2024-11-26T11:41:50.331Z'),(82,28,'{\"latitude\": 31.4792, \"longitude\": 74.3259096}','2024-11-26T11:56:53.262Z'),(83,28,'{\"latitude\": 31.4792, \"longitude\": 74.3259096}','2024-11-26T12:19:35.586Z'),(84,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-26T12:35:14.746Z'),(85,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-26T12:51:35.396Z'),(86,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-26T13:07:02.898Z'),(87,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-26T13:23:11.872Z'),(88,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-26T13:38:13.282Z'),(89,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-26T13:54:13.122Z'),(90,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-26T14:10:47.345Z'),(91,28,'{\"latitude\": 31.4512585, \"longitude\": 74.3125229}','2024-11-26T14:42:05.670Z'),(92,28,'{\"latitude\": 31.4600641, \"longitude\": 74.3228092}','2024-11-26T14:57:15.799Z'),(93,28,'{\"latitude\": 31.4600641, \"longitude\": 74.3228092}','2024-11-26T15:12:20.391Z'),(94,28,'{\"latitude\": 31.4600641, \"longitude\": 74.3228092}','2024-11-26T15:27:48.189Z'),(95,28,'{\"latitude\": 31.4600641, \"longitude\": 74.3228092}','2024-11-26T16:14:44.676Z'),(96,28,'{\"latitude\": 31.4600641, \"longitude\": 74.3228092}','2024-11-26T16:29:58.680Z'),(97,28,'{\"latitude\": 31.4600641, \"longitude\": 74.3228092}','2024-11-26T16:45:12.632Z'),(98,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T05:08:24.038Z'),(99,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T05:23:25.199Z'),(100,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T07:55:08.147Z'),(101,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T08:10:12.385Z'),(102,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T08:25:16.736Z'),(103,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T08:40:21.121Z'),(104,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T08:56:55.814Z'),(105,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T09:12:17.556Z'),(106,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T09:27:22.755Z'),(107,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T09:42:34.825Z'),(108,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T09:57:41.727Z'),(109,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T10:12:46.969Z'),(110,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T10:27:46.774Z'),(111,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T10:55:35.842Z'),(112,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T11:13:04.472Z'),(113,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T11:28:08.193Z'),(114,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T11:43:27.757Z'),(115,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T11:58:43.223Z'),(116,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T12:14:00.740Z'),(117,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T12:29:02.183Z'),(118,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T12:44:02.392Z'),(119,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T12:59:11.362Z'),(120,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T13:15:45.711Z'),(121,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T13:30:47.610Z'),(122,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T13:45:52.486Z'),(123,28,'{\"latitude\": 31.5075045, \"longitude\": 74.3272088}','2024-11-27T14:00:55.746Z'),(124,28,'{\"latitude\": 31.4965305, \"longitude\": 74.301543}','2024-11-28T05:25:04.555Z'),(125,28,'{\"latitude\": 31.4965305, \"longitude\": 74.301543}','2024-11-28T05:40:16.399Z'),(126,28,'{\"latitude\": 31.4965305, \"longitude\": 74.301543}','2024-11-28T05:58:56.024Z'),(127,28,'{\"latitude\": 31.4965305, \"longitude\": 74.301543}','2024-11-28T08:03:11.862Z'),(128,28,'{\"latitude\": 31.4965305, \"longitude\": 74.301543}','2024-11-28T09:20:59.682Z'),(129,28,'{\"latitude\": 31.4965305, \"longitude\": 74.301543}','2024-11-28T10:35:54.814Z'),(130,28,'{\"latitude\": 31.4965305, \"longitude\": 74.301543}','2024-11-28T10:51:10.588Z'),(131,28,'{\"latitude\": 31.4965305, \"longitude\": 74.301543}','2024-11-28T11:34:48.970Z'),(132,28,'{\"latitude\": 31.4965305, \"longitude\": 74.301543}','2024-11-28T11:49:55.749Z'),(133,28,'{\"latitude\": 31.4965305, \"longitude\": 74.301543}','2024-11-28T12:04:59.617Z'),(134,28,'{\"latitude\": 31.4965305, \"longitude\": 74.301543}','2024-11-28T12:27:38.071Z'),(135,28,'{\"latitude\": 31.4965305, \"longitude\": 74.301543}','2024-11-28T12:42:48.282Z'),(136,28,'{\"latitude\": 31.4965305, \"longitude\": 74.301543}','2024-11-28T12:58:29.839Z'),(137,28,'{\"latitude\": 31.4965305, \"longitude\": 74.301543}','2024-11-28T13:18:12.231Z'),(138,28,'{\"latitude\": 31.479202, \"longitude\": 74.3259129}','2024-11-29T05:29:31.896Z'),(139,28,'{\"latitude\": 31.4965378, \"longitude\": 74.3059431}','2024-11-29T07:58:19.788Z'),(140,28,'{\"latitude\": 31.4965378, \"longitude\": 74.3059431}','2024-11-29T08:18:05.201Z'),(141,28,'{\"latitude\": 31.4965378, \"longitude\": 74.3059431}','2024-11-29T08:45:33.287Z'); /*!40000 ALTER TABLE `user_location` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` int NOT NULL AUTO_INCREMENT, `full_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `role_id` int NOT NULL, `cnic` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `mobile_no` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `landline` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `office_id` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (28,'admin','admin','admin@gmail.com','$2y$10$fRo40oXhp/NfLGwLedhfUO/DPVaIAHYCX0dOsFcn8SsXD50Ci4ycu',10,'1','1','1',17),(29,'John','John','john@gmail.com','$2y$10$NtBSse54rfdAJNjlaXaPpuX2KuNK6vDhS12K9rg3C90zY/hhL8Yh.',18,'92 321 8410724 ','92 321 8410724','92 321 8410724',18),(30,'lsbc','lsbc','info@lsbc.uk','$2y$10$UKhYvbGHEZscauVQC7QzAug3R88lE.NvM99vZ3jGUpbVMG3qiYrOC',10,'1','07939321830','02085548973',18),(31,'zubair','zubair','zubair@gmail.com','$2y$10$ClOGAkWQigSZa5uIrJd6OukczGnkZuZj8BpraRc1UPJxhpWHGY2vW',10,NULL,NULL,NULL,18),(33,'Jacob Grayson','Jacob','jacob@gmail.com','$2y$10$Rmu73vwvRTJkcn4insJZwutgqUkcQOWEZMd6NAIpCgVe4qSBIDMi.',19,'6587410054','079568989441','020854712638',18),(35,'arshad','waseem','Waseem@enfo.ai','$2y$10$S7BgswjeofVToMqN0qb0ZekKx.5XY3Q2ncZO76jXSTMCm8aMTDNz.',10,'1','03004450504',NULL,18),(36,'Muhammad Javed','j4javed','j4javed@hotmail.com','$2y$10$f88RJ0c/THhKIxeGJj.OSOEPumx/3nv.fVbILqYSjmrBlzW3pvR5q',20,'12345678',NULL,NULL,18),(37,'test123','Test 123','test123@gamil.com','$2y$10$D3HyR1nxrAKWM.JQxAGQf.NOKgFHoUaO92vEpczQycK60PwVXqNLW',20,'123','123','123',18),(38,'AA','AA','info@lsbc.ukasd','$2y$10$UH5umyBT.CYVJynIMiZFH.GeB9/7.q096AKz9U7QKo7p87CVBYPrS',10,'122','123','123',18),(39,'Asim','asim','asim@gmail.com','$2y$10$OKrHwo7WiTRquC6Hzw0qTOCNKl8wteYq9jArn6eQ5BvYJK8bfSPm2',18,'123','123','121',18),(40,'xyz','XYZ','zubair@gmail.com','$2y$10$HStTLiOyvNeCls7YZWAmCu9BS4AEFt1KcDlSq64mV4tAS8C8ns/pC',23,'123','123','123',18); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Final view structure for view `quotations_expiry` -- /*!50001 DROP VIEW IF EXISTS `quotations_expiry`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_0900_ai_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `quotations_expiry` AS select distinct `q`.`id` AS `id` from ((`quotations` `q` join `enquiries` `en` on((`q`.`enquiry_id` = `en`.`id`))) join `office` `o` on((`o`.`id` = `en`.`office_id`))) where ((now() + interval `o`.`quot_inactive_days` day) <= cast(`q`.`dated` as date)) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2024-11-29 14:06:25