Server : Apache/2.4.52 (Ubuntu) System : Linux srv913213 5.15.0-179-generic #189-Ubuntu SMP Tue May 5 18:20:56 UTC 2026 x86_64 User : www-data ( 33) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, Directory : /proc/thread-self/root/var/www/yourattentionplease.in/
Upload File :
Current File : //proc/thread-self/root/var/www/yourattentionplease.in/talentgenesis_2026-06-18.sql
-- MySQL dump 10.13 Distrib 8.0.45, for Linux (x86_64)
--
-- Host: localhost Database: talent_genesis2
-- ------------------------------------------------------
-- Server version 8.0.45-0ubuntu0.22.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `account_delete`
--
DROP TABLE IF EXISTS `account_delete`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `account_delete` (
`purpose_id` int NOT NULL AUTO_INCREMENT,
`purpose` longtext,
PRIMARY KEY (`purpose_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `account_delete`
--
LOCK TABLES `account_delete` WRITE;
/*!40000 ALTER TABLE `account_delete` DISABLE KEYS */;
/*!40000 ALTER TABLE `account_delete` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `acl_menu`
--
DROP TABLE IF EXISTS `acl_menu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `acl_menu` (
`acl_menu_id` int NOT NULL AUTO_INCREMENT,
`menu_name` varchar(100) NOT NULL,
`url` varchar(100) NOT NULL,
`active` tinyint NOT NULL DEFAULT '1',
`acl_menu_module_id` int NOT NULL,
PRIMARY KEY (`acl_menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `acl_menu`
--
LOCK TABLES `acl_menu` WRITE;
/*!40000 ALTER TABLE `acl_menu` DISABLE KEYS */;
/*!40000 ALTER TABLE `acl_menu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `acl_menu_module`
--
DROP TABLE IF EXISTS `acl_menu_module`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `acl_menu_module` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`status` tinyint NOT NULL DEFAULT '1',
`view_type` tinyint NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `acl_menu_module`
--
LOCK TABLES `acl_menu_module` WRITE;
/*!40000 ALTER TABLE `acl_menu_module` DISABLE KEYS */;
/*!40000 ALTER TABLE `acl_menu_module` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `acl_permission`
--
DROP TABLE IF EXISTS `acl_permission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `acl_permission` (
`id` int NOT NULL AUTO_INCREMENT,
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
`acl_role_id` int DEFAULT NULL,
`acl_menu_module_id` int DEFAULT NULL,
`acl_menu` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_bd93837deb3f55df9bd560c7506` (`acl_role_id`),
KEY `FK_1b0b318e0447a579dc6e60fb3b9` (`acl_menu_module_id`),
KEY `FK_4d31cbf17fad221a482c19e92a9` (`acl_menu`),
CONSTRAINT `FK_1b0b318e0447a579dc6e60fb3b9` FOREIGN KEY (`acl_menu_module_id`) REFERENCES `acl_menu_module` (`id`),
CONSTRAINT `FK_4d31cbf17fad221a482c19e92a9` FOREIGN KEY (`acl_menu`) REFERENCES `acl_menu` (`acl_menu_id`),
CONSTRAINT `FK_bd93837deb3f55df9bd560c7506` FOREIGN KEY (`acl_role_id`) REFERENCES `role` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `acl_permission`
--
LOCK TABLES `acl_permission` WRITE;
/*!40000 ALTER TABLE `acl_permission` DISABLE KEYS */;
/*!40000 ALTER TABLE `acl_permission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `activity_logs`
--
DROP TABLE IF EXISTS `activity_logs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `activity_logs` (
`id` int NOT NULL AUTO_INCREMENT,
`platform` varchar(500) NOT NULL,
`description` varchar(500) NOT NULL,
`ip_address` varchar(100) DEFAULT NULL,
`os` varchar(100) DEFAULT NULL,
`user_agent` varchar(255) DEFAULT NULL,
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`isDeleted` tinyint NOT NULL DEFAULT '0',
`activity_portal` varchar(255) NOT NULL DEFAULT '0',
`portal_type` int DEFAULT NULL,
`activity_type_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_c8121594c07fa326b689912e403` (`activity_type_id`),
CONSTRAINT `FK_c8121594c07fa326b689912e403` FOREIGN KEY (`activity_type_id`) REFERENCES `activity_type` (`activity_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `activity_logs`
--
LOCK TABLES `activity_logs` WRITE;
/*!40000 ALTER TABLE `activity_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `activity_logs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `activity_type`
--
DROP TABLE IF EXISTS `activity_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `activity_type` (
`activity_type_id` int NOT NULL AUTO_INCREMENT,
`activity_type_name` varchar(100) NOT NULL,
PRIMARY KEY (`activity_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `activity_type`
--
LOCK TABLES `activity_type` WRITE;
/*!40000 ALTER TABLE `activity_type` DISABLE KEYS */;
/*!40000 ALTER TABLE `activity_type` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `applied_jobs`
--
DROP TABLE IF EXISTS `applied_jobs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `applied_jobs` (
`id` int NOT NULL AUTO_INCREMENT,
`full_name` varchar(100) NOT NULL,
`email` varchar(255) NOT NULL,
`mobile_no` varchar(255) DEFAULT NULL,
`resume` varchar(255) NOT NULL DEFAULT '1',
`cover_letter` text NOT NULL,
`status` int NOT NULL DEFAULT '0',
`is_default` tinyint NOT NULL DEFAULT '0',
`is_deleted` tinyint NOT NULL DEFAULT '0',
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
`candidate_source_id` int DEFAULT NULL,
`job_id` int DEFAULT NULL,
`attend_status` varchar(255) DEFAULT NULL,
`reason` text,
`salary_expectation` varchar(255) NOT NULL DEFAULT '1',
`about_yourself` text NOT NULL,
`web_links` json DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_869776d7b69fd9b39c2d1473ca3` (`candidate_source_id`),
KEY `FK_590472bb6050b3e46461b1d6af2` (`job_id`),
CONSTRAINT `FK_590472bb6050b3e46461b1d6af2` FOREIGN KEY (`job_id`) REFERENCES `job` (`id`),
CONSTRAINT `FK_869776d7b69fd9b39c2d1473ca3` FOREIGN KEY (`candidate_source_id`) REFERENCES `candidate_source` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `applied_jobs`
--
LOCK TABLES `applied_jobs` WRITE;
/*!40000 ALTER TABLE `applied_jobs` DISABLE KEYS */;
INSERT INTO `applied_jobs` VALUES (2,'Dinesh R','dineshthiru490@gmail.com','+918825817466','file-1764097444133-5965399418.pdf','Hello \nI hope you\'re doing well. I saw your post about the Software test Engineer position at TECHNOGENSIS\n and wanted to reach out. I\'m very interested in exploring \nthis opportunity further. \nWith my background in [ MCA & I have completed SQL & Automation Testing course From Q- Spider institute], I believe I could \nmake a meaningful contribution to your team. Could we schedule a quick call \nto discuss the role and how my skills align with your needs? \nLooking forward to hearing from you! \n\nBest regards, \nDinesh R\n8825817466\ndineshthiru490@gmail.com',0,0,0,'2025-11-25 19:08:33.940852','2025-11-25 19:08:33.940852',0,0,3,1,NULL,NULL,'2.9','Hello \nI hope you\'re doing well. I saw your post about the Software test Engineer position at TECHNOGENSIS\n and wanted to reach out. I\'m very interested in exploring \nthis opportunity further. \nWith my background in [ MCA & I have completed SQL & Automation Testing course From Q- Spider institute], I believe I could \nmake a meaningful contribution to your team. Could we schedule a quick call \nto discuss the role and how my skills align with your needs? \nLooking forward to hearing from you! \n\nBest regards, \nDinesh R\n8825817466\ndineshthiru490@gmail.com','[\"https://www.linkedin.com/in/dinesh-ravichandran-062a222b2\"]'),(3,'SHAKTHIIVEL VENKAATESHWARAR B','shakthi00111@gmail.com','+919952774889','file-1764145833689-9815915362.pdf','I have over 2 years of experience in both Manual and Automation Testing from Cognizant Technology Solutions. The roles and responsibilities mentioned in the job description align with my skills and experience and I believe I would be a great asset to the team.',0,0,0,'2025-11-26 08:35:50.842951','2025-11-26 08:35:50.842951',0,0,3,1,NULL,NULL,'600000','Over 2.5 years of experience in QEA(Quality Engineering and Assurance) as a Manual and Automation Tester using Tricentis TOSCA in an US based project. Key skills are SDLC and STLC process, Agile methodologies-SCRUM, Selenium with TestNG, MS-Office Tools, Postman, ORACLE SQL Developer, qTest Manager, WinSCP, Confluence, Service now, Openshift, Functional Testing. Believes in Team work, Good problem solving skills. Analysing the concepts by Critical thinking, Good leadership quality, Good Communication and Interpersonal skills, Likely to maintain Time Management. Ready to work in an environment which enhances my working capacities, professional skills, business efficiencies and to serve the organisation in a best possible way to reach greater heights in the future.','[]'),(5,'Manikandan K','manikandankumaravel59539@gmail.com','+919025265628','file-1764160728308-7070808726.pdf','My self having 4.7 years of experience in non-IT and 1 year of experience in testing role . please give me an opportunity to work in your company and now I am interested in testing so that I am switching my career from non-IT to IT.',0,0,0,'2025-11-26 12:41:23.324587','2025-11-26 12:41:23.324587',0,0,3,1,NULL,NULL,'360000','My self having 4.7 years of experience in non-IT and 1 year of experience in testing role . please give me an opportunity to work in your company and now I am interested in testing so that I am switching my career from non-IT to IT.','[]'),(6,'Gokulasri J','gokulasrij26@gmail.com','+8056348490','file-1764310575338-4428252208.pdf','Software Testing Engineer (Fresher) with a strong understanding of Manual and Automation Testing concepts.\n• Good knowledge of Web Application and Web Services testing.\n• Hands-on academic and project experience using Java, Selenium WebDriver, TestNG, Maven, and Jenkins for automation testing.\n• Familiar with different automation frameworks such as Cucumber with BDD, Page Object Model (POM), and Data-Driven Frameworks.\n• Basic understanding of developing BDD scripts using Feature Files and Cucumber.\n• Knowledge of Cross Browser Testing and Parallel Execution using TestNG and Maven.\n• Familiar with API Testing using Postman, including concepts such as HTTP Requests/Responses, Headers, Path Params, and Query Params.\n• Exposure to REST Assured for API automation and data-driven validation.\n• Understanding of Agile Methodologies, SCRUM meetings, and SDLC/STLC processes.\n• Basic knowledge of defect management using JIRA.\n• Familiar with GIT/GitHub for version control and integrating builds using Jenkins.\n• Strong problem-solving, analytical, and communication skills with a keen interest in learning new testing tools and automation frameworks.',0,0,0,'2025-11-28 06:24:47.501125','2025-11-28 06:24:47.501125',0,0,3,1,NULL,NULL,'4','','[\"https://www.linkedin.com/public-profile/settings?lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_self_edit_contact-info%3BdRUGpAy9SHmwGVQwDlFU4w%3D%3D\"]'),(7,'J jayasri','pjmjayasri@gmail.com','+9790389003','file-1764311164447-7160091933.pdf','Strong understanding of software development, testing processes, and defect management\n\nPractical experience in manual testing with basic exposure to automation tools (Selenium, TestNG, Postman, JMeter)\n\nAbility to perform API testing and validate data using SQL\n\nFamiliarity with Agile methods like Scrum and Kanban\n\nGood analytical, problem-solving, and communication skills\n\nComfortable working in a fast-paced, collaborative team environment',0,0,0,'2025-11-28 06:33:05.846091','2025-11-28 06:33:05.846091',0,0,3,1,NULL,NULL,'3.5','','[]');
/*!40000 ALTER TABLE `applied_jobs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `business_need`
--
DROP TABLE IF EXISTS `business_need`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `business_need` (
`id` int NOT NULL AUTO_INCREMENT,
`business_need` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `business_need`
--
LOCK TABLES `business_need` WRITE;
/*!40000 ALTER TABLE `business_need` DISABLE KEYS */;
INSERT INTO `business_need` VALUES (1,'Technological Business Evolution'),(2,'Integrated Stack Development'),(3,'Integrated Stack Development'),(4,'Cloud & DevOps Services'),(5,'SaaS Platform Development'),(6,'Data Science & Analytics'),(7,'Other');
/*!40000 ALTER TABLE `business_need` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `candidate_source`
--
DROP TABLE IF EXISTS `candidate_source`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `candidate_source` (
`id` int NOT NULL AUTO_INCREMENT,
`source_name` varchar(100) NOT 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 `candidate_source`
--
LOCK TABLES `candidate_source` WRITE;
/*!40000 ALTER TABLE `candidate_source` DISABLE KEYS */;
INSERT INTO `candidate_source` VALUES (1,'Linkedin'),(2,'Naukri'),(3,'Company career site'),(4,'Job search platform'),(5,'Othres');
/*!40000 ALTER TABLE `candidate_source` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `career_level`
--
DROP TABLE IF EXISTS `career_level`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `career_level` (
`id` int NOT NULL AUTO_INCREMENT,
`career_name` varchar(100) NOT NULL,
`status` int NOT NULL DEFAULT '1',
`is_default` tinyint NOT NULL DEFAULT '0',
`is_deleted` tinyint NOT NULL DEFAULT '0',
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `career_level`
--
LOCK TABLES `career_level` WRITE;
/*!40000 ALTER TABLE `career_level` DISABLE KEYS */;
INSERT INTO `career_level` VALUES (1,'Advanced',1,0,0,'2024-07-12 09:29:14.514542','2024-07-12 09:29:14.514542',0,0),(2,'Developing',1,0,0,'2024-07-12 09:29:14.516006','2024-07-12 09:29:14.516006',0,0),(3,'Director',1,0,0,'2024-07-12 09:29:14.516457','2024-07-12 09:29:14.516457',0,0),(4,'Entry',1,0,0,'2024-07-12 09:29:14.516861','2024-07-12 09:29:14.516861',0,0),(5,'Expert',1,0,0,'2024-07-12 09:29:14.517267','2024-07-12 09:29:14.517267',0,0),(6,'Highly Skilled',1,0,0,'2024-07-12 09:29:14.517724','2024-07-12 09:29:14.517724',0,0),(7,'Intermediate',1,0,0,'2024-07-12 09:29:14.518082','2024-07-12 09:29:14.518082',0,0),(8,'Manager',1,0,0,'2024-07-12 09:29:14.518606','2024-07-12 09:29:14.518606',0,0),(9,'Principal',1,0,0,'2024-07-12 09:29:14.519058','2024-07-12 09:29:14.519058',0,0),(10,'Senior',1,0,0,'2024-07-12 09:29:14.522099','2024-07-12 09:29:14.522099',0,0);
/*!40000 ALTER TABLE `career_level` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `commission`
--
DROP TABLE IF EXISTS `commission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `commission` (
`id` int NOT NULL AUTO_INCREMENT,
`percentage` double(10,2) DEFAULT NULL,
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`updated_by` int NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `commission`
--
LOCK TABLES `commission` WRITE;
/*!40000 ALTER TABLE `commission` DISABLE KEYS */;
/*!40000 ALTER TABLE `commission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `company_size`
--
DROP TABLE IF EXISTS `company_size`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `company_size` (
`id` int NOT NULL AUTO_INCREMENT,
`size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `company_size`
--
LOCK TABLES `company_size` WRITE;
/*!40000 ALTER TABLE `company_size` DISABLE KEYS */;
INSERT INTO `company_size` VALUES (1,'1-10'),(2,'11-50'),(3,'51-100'),(4,'100-250'),(5,'250+');
/*!40000 ALTER TABLE `company_size` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `country`
--
DROP TABLE IF EXISTS `country`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `country` (
`country_id` int NOT NULL AUTO_INCREMENT,
`name` varchar(150) NOT NULL,
PRIMARY KEY (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=247 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `country`
--
LOCK TABLES `country` WRITE;
/*!40000 ALTER TABLE `country` DISABLE KEYS */;
INSERT INTO `country` VALUES (1,'Afghanistan'),(2,'Albania'),(3,'Algeria'),(4,'American Samoa'),(5,'Andorra'),(6,'Angola'),(7,'Anguilla'),(8,'Antarctica'),(9,'Antigua And Barbuda'),(10,'Argentina'),(11,'Armenia'),(12,'Aruba'),(13,'Australia'),(14,'Austria'),(15,'Azerbaijan'),(16,'Bahamas The'),(17,'Bahrain'),(18,'Bangladesh'),(19,'Barbados'),(20,'Belarus'),(21,'Belgium'),(22,'Belize'),(23,'Benin'),(24,'Bermuda'),(25,'Bhutan'),(26,'Bolivia'),(27,'Bosnia and Herzegovina'),(28,'Botswana'),(29,'Bouvet Island'),(30,'Brazil'),(31,'British Indian Ocean Territory'),(32,'Brunei'),(33,'Bulgaria'),(34,'Burkina Faso'),(35,'Burundi'),(36,'Cambodia'),(37,'Cameroon'),(38,'Canada'),(39,'Cape Verde'),(40,'Cayman Islands'),(41,'Central African Republic'),(42,'Chad'),(43,'Chile'),(44,'China'),(45,'Christmas Island'),(46,'Cocos (Keeling) Islands'),(47,'Colombia'),(48,'Comoros'),(49,'Republic Of The Congo'),(50,'Democratic Republic Of The Congo'),(51,'Cook Islands'),(52,'Costa Rica'),(53,'Cote D\'Ivoire (Ivory Coast)'),(54,'Croatia (Hrvatska)'),(55,'Cuba'),(56,'Cyprus'),(57,'Czech Republic'),(58,'Denmark'),(59,'Djibouti'),(60,'Dominica'),(61,'Dominican Republic'),(62,'East Timor'),(63,'Ecuador'),(64,'Egypt'),(65,'El Salvador'),(66,'Equatorial Guinea'),(67,'Eritrea'),(68,'Estonia'),(69,'Ethiopia'),(70,'External Territories of Australia'),(71,'Falkland Islands'),(72,'Faroe Islands'),(73,'Fiji Islands'),(74,'Finland'),(75,'France'),(76,'French Guiana'),(77,'French Polynesia'),(78,'French Southern Territories'),(79,'Gabon'),(80,'Gambia The'),(81,'Georgia'),(82,'Germany'),(83,'Ghana'),(84,'Gibraltar'),(85,'Greece'),(86,'Greenland'),(87,'Grenada'),(88,'Guadeloupe'),(89,'Guam'),(90,'Guatemala'),(91,'Guernsey and Alderney'),(92,'Guinea'),(93,'Guinea-Bissau'),(94,'Guyana'),(95,'Haiti'),(96,'Heard and McDonald Islands'),(97,'Honduras'),(98,'Hong Kong S.A.R.'),(99,'Hungary'),(100,'Iceland'),(101,'India'),(102,'Indonesia'),(103,'Iran'),(104,'Iraq'),(105,'Ireland'),(106,'Israel'),(107,'Italy'),(108,'Jamaica'),(109,'Japan'),(110,'Jersey'),(111,'Jordan'),(112,'Kazakhstan'),(113,'Kenya'),(114,'Kiribati'),(115,'Korea North'),(116,'Korea South'),(117,'Kuwait'),(118,'Kyrgyzstan'),(119,'Laos'),(120,'Latvia'),(121,'Lebanon'),(122,'Lesotho'),(123,'Liberia'),(124,'Libya'),(125,'Liechtenstein'),(126,'Lithuania'),(127,'Luxembourg'),(128,'Macau S.A.R.'),(129,'Macedonia'),(130,'Madagascar'),(131,'Malawi'),(132,'Malaysia'),(133,'Maldives'),(134,'Mali'),(135,'Malta'),(136,'Man (Isle of)'),(137,'Marshall Islands'),(138,'Martinique'),(139,'Mauritania'),(140,'Mauritius'),(141,'Mayotte'),(142,'Mexico'),(143,'Micronesia'),(144,'Moldova'),(145,'Monaco'),(146,'Mongolia'),(147,'Montserrat'),(148,'Morocco'),(149,'Mozambique'),(150,'Myanmar'),(151,'Namibia'),(152,'Nauru'),(153,'Nepal'),(154,'Netherlands Antilles'),(155,'Netherlands The'),(156,'New Caledonia'),(157,'New Zealand'),(158,'Nicaragua'),(159,'Niger'),(160,'Nigeria'),(161,'Niue'),(162,'Norfolk Island'),(163,'Northern Mariana Islands'),(164,'Norway'),(165,'Oman'),(166,'Pakistan'),(167,'Palau'),(168,'Palestinian Territory Occupied'),(169,'Panama'),(170,'Papua new Guinea'),(171,'Paraguay'),(172,'Peru'),(173,'Philippines'),(174,'Pitcairn Island'),(175,'Poland'),(176,'Portugal'),(177,'Puerto Rico'),(178,'Qatar'),(179,'Reunion'),(180,'Romania'),(181,'Russia'),(182,'Rwanda'),(183,'Saint Helena'),(184,'Saint Kitts And Nevis'),(185,'Saint Lucia'),(186,'Saint Pierre and Miquelon'),(187,'Saint Vincent And The Grenadines'),(188,'Samoa'),(189,'San Marino'),(190,'Sao Tome and Principe'),(191,'Saudi Arabia'),(192,'Senegal'),(193,'Serbia'),(194,'Seychelles'),(195,'Sierra Leone'),(196,'Singapore'),(197,'Slovakia'),(198,'Slovenia'),(199,'Smaller Territories of the UK'),(200,'Solomon Islands'),(201,'Somalia'),(202,'South Africa'),(203,'South Georgia'),(204,'South Sudan'),(205,'Spain'),(206,'Sri Lanka'),(207,'Sudan'),(208,'Suriname'),(209,'Svalbard And Jan Mayen Islands'),(210,'Swaziland'),(211,'Sweden'),(212,'Switzerland'),(213,'Syria'),(214,'Taiwan'),(215,'Tajikistan'),(216,'Tanzania'),(217,'Thailand'),(218,'Togo'),(219,'Tokelau'),(220,'Tonga'),(221,'Trinidad And Tobago'),(222,'Tunisia'),(223,'Turkey'),(224,'Turkmenistan'),(225,'Turks And Caicos Islands'),(226,'Tuvalu'),(227,'Uganda'),(228,'Ukraine'),(229,'United Arab Emirates'),(230,'United Kingdom'),(231,'United States'),(232,'United States Minor Outlying Islands'),(233,'Uruguay'),(234,'Uzbekistan'),(235,'Vanuatu'),(236,'Vatican City State (Holy See)'),(237,'Venezuela'),(238,'Vietnam'),(239,'Virgin Islands (British)'),(240,'Virgin Islands (US)'),(241,'Wallis And Futuna Islands'),(242,'Western Sahara'),(243,'Yemen'),(244,'Yugoslavia'),(245,'Zambia'),(246,'Zimbabwe');
/*!40000 ALTER TABLE `country` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `customers`
--
DROP TABLE IF EXISTS `customers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customers` (
`customer_id` int NOT NULL AUTO_INCREMENT,
`customer_code` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`pin` varchar(255) DEFAULT NULL,
`platform` varchar(255) DEFAULT NULL,
`profile_image` varchar(255) DEFAULT NULL,
`first_name` varchar(255) DEFAULT NULL,
`last_name` varchar(255) DEFAULT NULL,
`pan_no` varchar(255) DEFAULT NULL,
`panno_verify` tinyint NOT NULL DEFAULT '0',
`is_otp_verified` tinyint NOT NULL DEFAULT '0',
`aadhar_no` varchar(255) DEFAULT NULL,
`aadharno_verify` tinyint NOT NULL DEFAULT '0',
`otp` varchar(100) DEFAULT NULL,
`otp_verify_date` varchar(255) DEFAULT NULL,
`mobile_no` varchar(255) NOT NULL,
`is_deleted` tinyint NOT NULL DEFAULT '0',
`email` varchar(255) NOT NULL,
`password` varchar(60) DEFAULT NULL,
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`logout_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
`status` int NOT NULL DEFAULT '1',
`login_status` tinyint NOT NULL DEFAULT '1',
`fcm_token` longtext,
`reason` longtext,
`is_register` tinyint NOT NULL DEFAULT '0',
`access_token` longtext,
`refresh_token` longtext,
`role_id` int DEFAULT NULL,
`purpose_id` int DEFAULT NULL,
PRIMARY KEY (`customer_id`),
KEY `FK_0d54ee87b56b90134f45d2d0019` (`role_id`),
KEY `FK_bd5fc271ab6e459bb780fe29d69` (`purpose_id`),
CONSTRAINT `FK_0d54ee87b56b90134f45d2d0019` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`),
CONSTRAINT `FK_bd5fc271ab6e459bb780fe29d69` FOREIGN KEY (`purpose_id`) REFERENCES `account_delete` (`purpose_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `customers`
--
LOCK TABLES `customers` WRITE;
/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `degree_level`
--
DROP TABLE IF EXISTS `degree_level`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `degree_level` (
`id` int NOT NULL AUTO_INCREMENT,
`degree_name` varchar(100) NOT NULL,
`status` int NOT NULL DEFAULT '1',
`is_default` tinyint NOT NULL DEFAULT '0',
`is_deleted` tinyint NOT NULL DEFAULT '0',
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `degree_level`
--
LOCK TABLES `degree_level` WRITE;
/*!40000 ALTER TABLE `degree_level` DISABLE KEYS */;
INSERT INTO `degree_level` VALUES (1,'Master\'s in Professional Science in Environmental Studies and Sustainability',1,0,0,'2024-08-01 12:00:48.722636','2024-08-01 12:00:48.722636',1,0),(2,'M.B.A',1,0,0,'2024-08-01 12:01:55.501325','2024-08-01 12:01:55.501325',1,0),(3,'B.S. Sustainable Business Management (SBM): Renewable Energy.',1,0,0,'2024-08-01 12:02:31.651867','2024-08-01 12:02:31.651867',1,0),(4,'B.E',1,0,0,'2024-08-01 12:02:49.941713','2024-08-01 12:02:49.941713',1,0),(5,'M.E',1,0,0,'2024-08-01 12:03:03.753534','2024-08-01 12:03:03.753534',1,0),(6,'lgkfgl jkf',1,0,1,'2024-08-01 12:03:12.736066','2024-08-01 12:03:40.000000',1,0),(7,'B.com CA',1,0,0,'2025-08-12 09:41:55.238909','2025-08-12 09:41:55.238909',1,0),(8,'B.Tech (IT)',1,0,0,'2025-08-12 10:56:57.354349','2025-08-12 10:56:57.354349',1,0),(9,'MBA',1,0,0,'2025-08-19 05:39:14.037477','2025-08-19 05:39:14.037477',1,0),(10,'MCA',1,0,0,'2025-11-26 11:28:33.828826','2025-11-26 11:28:33.828826',1,0);
/*!40000 ALTER TABLE `degree_level` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `district`
--
DROP TABLE IF EXISTS `district`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `district` (
`district_id` int NOT NULL AUTO_INCREMENT,
`state_id` int DEFAULT NULL,
`district_name` varchar(1500) NOT NULL,
PRIMARY KEY (`district_id`),
KEY `FK_fd07eccecffa679e6bb64296b5b` (`state_id`),
CONSTRAINT `FK_fd07eccecffa679e6bb64296b5b` FOREIGN KEY (`state_id`) REFERENCES `state` (`state_id`)
) ENGINE=InnoDB AUTO_INCREMENT=775 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `district`
--
LOCK TABLES `district` WRITE;
/*!40000 ALTER TABLE `district` DISABLE KEYS */;
INSERT INTO `district` VALUES (1,1,'Kathuna'),(2,1,'Jammu'),(3,1,'Samba'),(4,1,'Udhampur'),(5,1,'Reasi'),(6,1,'Rajouri'),(7,1,'Poonch'),(8,1,'Doda'),(9,1,'Ramban'),(10,1,'Kishtwar'),(11,1,'Anantnag'),(12,1,'Kulgam'),(13,1,'Pulwama'),(14,1,'Shopian'),(15,1,'Badgam'),(16,1,'Srinagar'),(17,1,'Ganderbal'),(18,1,'Bandipora'),(19,1,'Baramulla'),(20,1,'Kupwara'),(21,1,'Kargil'),(22,1,'Leh'),(23,2,'Chamba'),(24,2,'Kangra'),(25,2,'Lahaul and spiti'),(26,2,'Kullu'),(27,2,'Mandi'),(28,2,'Hamirpur'),(29,2,'Una'),(30,2,'Bilaspur'),(31,2,'Solan'),(32,2,'Sirmaur'),(33,2,'Shimla'),(34,2,'Kinnaur'),(35,3,'Amritsar'),(36,3,'Bathinda'),(37,3,'Faridkot'),(38,3,'Fatehgarh Sahib'),(39,3,'Ferozepur'),(40,3,'Gurdaspur'),(41,3,'Hoshiarpur'),(42,3,'Jalandhar'),(43,3,'Kapurthala'),(44,3,'Ludhiana'),(45,3,'Mansa'),(46,3,'Moga'),(47,3,'Muktsar'),(48,3,'Nawanshehar'),(49,3,'Patiala\r\n'),(50,3,'Rupnagar'),(51,3,'Sangrur'),(52,3,'Barnala'),(53,3,'Mohali'),(54,3,'Tarn Taran'),(55,3,'Pathankot'),(56,3,'Fazilka'),(57,5,'Almora'),(58,5,'Bageshwar'),(59,5,'Chamoli'),(60,5,'Champawat'),(61,5,'Dehradun'),(62,5,'Haridwar'),(63,5,'Nainital'),(64,5,'Pauri Garhwal'),(65,5,'Pithoragarh'),(66,5,'Rudraprayag'),(67,5,'New Tehri'),(68,5,'Udhm Singh Nagar'),(69,5,'Uttarkashi'),(70,6,'Ambala'),(71,6,'Bhiwani'),(72,6,'Faridabad'),(73,6,'Fatehabad'),(74,6,'Gurgaon'),(75,6,'Hissar'),(76,6,'Jhajjar'),(77,6,'Jind'),(78,6,'Karnal'),(79,6,'Kaithal'),(80,6,'Kurukshetra'),(81,6,'Narnaul'),(82,6,'Nuh'),(83,6,'Palwal'),(84,6,'Panchkula'),(85,6,'Panipat'),(86,6,'Rewari'),(87,6,'Rohtak'),(88,6,'Sirsa'),(89,6,'Sonipat'),(90,6,'Yamuna Nagar'),(91,6,'Charkhi Dhari'),(92,7,'New Delhi'),(93,7,'North Delhi'),(94,7,'NorthWest Delhi'),(95,7,'West Delhi'),(96,7,'South West Delhi'),(97,7,'South Delhi'),(98,7,'South East Delhi'),(99,7,'Central Delhi'),(100,7,'North East Delhi'),(101,7,'Shahdara'),(102,7,'East Delhi'),(103,8,'Ajmer'),(104,8,'Alwar'),(105,8,'Banswara'),(106,8,'Baran'),(107,8,'Barmer'),(108,8,'Bharatpur'),(109,8,'Bhilwara'),(110,8,'Bikaner'),(111,8,'Bundi'),(112,8,'Chittorgarh'),(113,8,'Churu'),(114,8,'Dausa'),(115,8,'Dholpur'),(116,8,'Dungarpur'),(117,8,'Hanumangarh'),(118,8,'Jaipur'),(119,8,'Jaisalmer'),(120,8,'Jalore'),(121,8,'Jhalawar'),(122,8,'Jhunjhunu'),(123,8,'Jodhpur'),(124,8,'Karauli'),(125,8,'Kota'),(126,8,'Nagaur'),(127,8,'Pali'),(128,8,'Pratapgarh'),(129,8,'Rajsamand'),(130,8,'Sawai Madhopur'),(131,8,'Sikar'),(132,8,'Sirohi'),(133,8,'Sri Ganganagar'),(134,8,'Tonk'),(135,8,'Udaipur'),(136,9,'Agra'),(137,9,'Aligarh'),(138,9,'Allahabad\r\n'),(139,9,'Ambedkar Nagar'),(140,9,'Auraiya'),(141,9,'Azamgarh'),(142,9,'Baghpat'),(143,9,'Bahraich'),(144,9,'Ballia'),(145,9,'Balrampur'),(146,9,'Banda'),(147,9,'Barabanki'),(148,9,'Bareilly'),(149,9,'Basti'),(150,9,'Bijnor'),(151,9,'Badaun'),(152,9,'Bulandshahr'),(153,9,'Chandauli'),(154,9,'Chitrakoot'),(155,9,'Deoria'),(156,9,'Etah'),(157,9,'Etawah'),(158,9,'Faizabad'),(159,9,'Farrukhabed'),(160,9,'Fatehpur'),(161,9,'Firozabad'),(162,9,'Noida'),(163,9,'Ghaziabad'),(164,9,'Ghazipur'),(165,9,'Gonda'),(166,9,'Gorakhpur'),(167,9,'Hamirpur'),(168,9,'Hardoi'),(169,9,'Hathras'),(170,9,'Orai'),(171,9,'jaunpur'),(172,9,'Jhansi'),(173,9,'jyotiba phule nagar'),(174,9,'Kannauj'),(175,9,'Akbarpur'),(176,9,'Kanpur'),(177,9,'Kaushambi'),(178,9,'Lakhimpur'),(179,9,'Koshi Nagar'),(180,9,'Lalitpur'),(181,9,'Lucknow'),(182,9,'Mahoba\r\n'),(183,9,'Maharajganj'),(184,9,'Mainpuri'),(185,9,'Mathura\r\n'),(186,9,'Mau'),(187,9,'Meerut'),(188,9,'Mirzapur'),(189,9,'Moradabad'),(190,9,'Muzaffarnagar'),(191,9,'Pilibhit'),(192,9,'Pratapgarh'),(193,9,'RaeBareli'),(194,9,'Rampur'),(195,9,'Saharanpur'),(196,9,'Sant Kabir Nagar'),(197,9,'Sant Ravidas Nagar'),(198,9,'Shahjahanpur'),(199,9,'Shravasti'),(200,9,'Siddharthnagar '),(201,9,'Sitapur'),(202,9,'Sonbhadra'),(203,9,'Sultanpur'),(204,9,'Unnao'),(205,9,'Varanasi'),(206,9,'Manyavar Knshiram Nagar (Kasganj)\r\n'),(207,9,'Shamli'),(208,9,'Hapur'),(209,9,'Chandausi '),(210,9,'Gauriganj'),(211,10,'Araria'),(212,10,'Aurangabad'),(213,10,'Banka'),(214,10,'Begusarai'),(215,10,'Bhagalpur'),(216,10,'Bhojpur'),(217,10,'Buxar'),(218,10,'Darbhanga'),(219,10,'East Champaran'),(220,10,'Gaya'),(221,10,'Gopalganj'),(222,10,'Jamui'),(223,10,'Jehanabad'),(224,10,'Kaimur'),(225,10,'Katihar'),(226,10,'Khagaria'),(227,10,'Kishanganj'),(228,10,'Lakhisarai'),(229,10,'Madhepura'),(230,10,'Madhubani'),(231,10,'Munger'),(232,10,'Muzzaffarpur '),(233,10,'Nalanda'),(234,10,'Nawada'),(235,10,'Patna'),(236,10,'Purnia'),(237,10,'Rohtaas'),(238,10,'Saharsa'),(239,10,'Samastipur'),(240,10,'Sheikhpura'),(241,10,'Sheoghar'),(242,10,'Sitamarhi'),(243,10,'Supaul'),(244,10,'Siwan'),(245,10,'Vaishali\r\n'),(246,10,'West Champaran'),(247,11,'East Sikkim'),(248,11,'North Sikkim'),(249,11,'South Sikkim'),(250,11,'West Sikkim'),(251,12,'Hawai'),(252,12,'Changlang'),(253,12,'Seppa '),(254,12,'East Siang'),(255,12,'Tezu'),(256,12,'Ziro'),(257,12,'Yupia'),(258,12,'Tawang'),(259,12,'Khonsa'),(260,12,'Roing'),(261,12,'Yingkiong'),(262,12,'Daporijo'),(263,12,'Bomdila'),(264,12,'Along'),(265,12,'Anini'),(266,12,'Koloriang'),(267,13,'Dimapur'),(268,13,'Kohima'),(269,13,'Mon'),(270,13,'Tuensang'),(271,13,'Mokokchung'),(272,13,'Wokha'),(273,13,'phek'),(274,13,'Zenheboto'),(275,13,'Peren'),(276,13,'Kiphire'),(277,13,'Longleng'),(278,14,'Bishenpur'),(279,14,'Thoubal'),(280,14,'Imphal East'),(281,14,'Imphal West'),(282,14,'Senapati'),(283,14,'Ukhrul'),(284,14,'Chandel'),(285,14,'Churachabdpur'),(286,14,'Tamenglong'),(287,14,'Jiribam'),(288,14,'Kamjong'),(289,14,'Noney'),(290,14,'pherzawl'),(291,15,'Aizwal'),(292,15,'Champhai'),(293,15,'Kolasib'),(294,15,'Lawngtlai'),(295,15,'Lunglei'),(296,15,'Mamit'),(297,15,'Saiha'),(298,15,'Serchhip'),(299,16,'Dhalai'),(300,16,'Gomati'),(301,16,'Khowai'),(302,16,'NorthTripura'),(303,16,'Unakoti'),(304,16,'West Tripura'),(305,17,'East Garo Hils'),(306,17,'East Jaintia Hils'),(307,17,'East Khasi Hils'),(308,17,'North Garo Hils'),(309,17,'Ri Bhoi'),(310,17,'South Gero Hils'),(311,17,'South West Garo Hils'),(312,17,'South West Khasi Hils'),(313,17,'West Jaintia Hils'),(314,17,'West Khasi Hils'),(315,18,'Baksa'),(316,18,'Barpeta'),(317,18,'Biswanath'),(318,18,'Bongaigaon'),(319,18,'Cachar'),(320,18,'Charaideo'),(321,18,'Chirang'),(322,18,'Darrang'),(323,18,'Dhemaji'),(324,18,'Dhubri'),(325,18,'Dibrugarh'),(326,18,'Goalpara'),(327,18,'Golaghat'),(328,18,'Hailakandi'),(329,18,'Hojai'),(330,18,'Jorhat'),(331,18,'Kamrup Metropolitan'),(332,18,'Kamrup Rural'),(333,18,'Karbi Anglong'),(334,18,'Karimganj'),(335,18,'Kokrajhar'),(336,18,'Lakhimpur'),(337,18,'Majuli'),(338,18,'Morigaon'),(339,18,'Nagaon'),(340,18,'Nalbari'),(341,18,'Dima Hasao'),(342,18,'Sivasagar'),(343,18,'Sonitpur'),(344,18,'South Salmara-Mankachar'),(345,18,'Tinsukia'),(346,18,'Udalguri'),(347,18,'West Karbi Anglong'),(348,19,'Alipurduar'),(349,19,'Bankura'),(350,19,'Birbhum'),(351,19,'Cooch Behar'),(352,19,'Dakshin Dinajpur'),(353,19,'Darjeeling'),(354,19,'Hooghly'),(355,19,'Howrah'),(356,19,'Jalpaiguri'),(357,19,'Jhargram'),(358,19,'Kalimpong'),(359,19,'Kolkata'),(360,19,'Malda'),(361,19,'Murshidabad'),(362,19,'Nadia'),(363,19,'North 24 Parganas'),(364,19,'Paschim Medinipur'),(365,19,'Paschim(west)Burdwan'),(366,19,'Purba Burdwan'),(367,19,'Purba Medinipur'),(368,19,'Purulia'),(369,19,'South 24 Paraganas'),(370,19,'Uttar Dinaipur'),(371,20,'Bokaro'),(372,20,'Chatra'),(373,20,'Deoghar'),(374,20,'Dhanbad'),(375,20,'Dumka'),(376,20,'East Singhbhum'),(377,20,'Garhwa'),(378,20,'Giridih'),(379,20,'Godda'),(380,20,'Gumla'),(381,20,'Hazaribagh'),(382,20,'Jamtara'),(383,20,'Khunti'),(384,20,'Koderma'),(385,20,'Latehar'),(386,20,'Lohardaga'),(387,20,'Pakur'),(388,20,'Palamu'),(389,20,'Ramgarh'),(390,20,'Ranchi'),(391,20,'Sahibganj'),(392,20,'Simdega'),(393,20,'West Singhbhum'),(394,20,'Seraikella Kharsawan'),(395,21,'Anugul'),(396,21,'Boudh'),(397,21,'Balangir'),(398,21,'Bargarh'),(399,21,'Balasore'),(400,21,'Bhadrak'),(401,21,'Cuttack'),(402,21,'Debagarh'),(403,21,'Dhenkanal'),(404,21,'Ganjam'),(405,21,'Gajapati'),(406,21,'Jarsuguda'),(407,21,'Jaipur'),(408,21,'Jagatsinghapur'),(409,21,'Khordha'),(410,21,'Kendujhar'),(411,21,'Kalahandi'),(412,21,'Kanshamal'),(413,21,'Koraput'),(414,21,'Kendrapara'),(415,21,'Malkangiri'),(416,21,'Mayurbhanj'),(417,21,'Nabarangpur'),(418,21,'Nuapada'),(419,21,'Nayagarh'),(420,21,'Puri'),(421,21,'Rayagada'),(422,21,'Sambalpur'),(423,21,'Sundergarh'),(424,22,'Balod'),(425,22,'Baloda Bazer'),(426,22,'Balrampur'),(427,22,'Bastar'),(428,22,'Bemetara'),(429,22,'Bijapur'),(430,22,'Dantewada '),(431,22,'Dhamtari'),(432,22,'Durg'),(433,22,'Gariyaband'),(434,22,'Janjgir-Champa'),(435,22,'Jashpur'),(436,22,'Kabirdham'),(437,22,'Kanker'),(438,22,'Kondagaon'),(439,22,'Korba'),(440,22,'Korea'),(441,22,'Mahasamund'),(442,22,'Mungeli'),(443,22,'Nayayanpur'),(444,22,'Raigarh'),(445,22,'Raipur'),(446,22,'Raijandgaon'),(447,22,'Sukma'),(448,22,'Surajpur'),(449,22,'Surguja'),(450,23,'Indore'),(451,23,'Jabalpur'),(452,23,'Sagar'),(453,23,'Bhopal'),(454,23,'Rewa'),(455,23,'Satna'),(456,23,'Dhar'),(457,23,'Chhindwara'),(458,23,'Ujjain'),(459,23,'Morena'),(460,23,'West Nimar'),(461,23,'Chhattarpur'),(462,23,'Shivpuri'),(463,23,'Bhind'),(464,23,'Dewas'),(465,23,'Rajarh'),(466,23,'Shajapur'),(467,23,'Vidisha'),(468,23,'Ratlam'),(469,23,'Tikamgarh'),(470,23,'Barwani'),(471,23,'Seoni'),(472,23,'Mandsaur'),(473,23,'Raisen'),(474,23,'Sehore'),(475,23,'East Nimar'),(476,23,'Katni'),(477,23,'Damoh'),(478,23,'Guna'),(479,23,'Hoshangabad'),(480,23,'Singrauil'),(481,23,'Sidhi'),(482,23,'Narsimhapur'),(483,23,'Shahdol'),(484,23,'Mandla'),(485,23,'Jhabua'),(486,23,'Panna'),(487,23,'Ashoknagar'),(488,23,'Neemuch'),(489,23,'Datia'),(490,23,'Burhanpur'),(491,23,'Anuppur'),(492,23,'Aliraipur'),(493,23,'Dindori'),(494,23,'Sheopur'),(495,23,'Umaria'),(496,23,'Harda'),(497,24,'Ahmedabad'),(498,24,'Amreli'),(499,24,'Aravalli'),(500,24,'Banaskantha'),(501,24,'Bharuch'),(502,24,'Bhavnagar'),(503,24,'Boted'),(504,24,'Chhota Udepur'),(505,24,'Dahod'),(506,24,'Dangs'),(507,24,'Devbhoomi Dwarka'),(508,24,'Gandhinagar'),(509,24,'Gir Somnath'),(510,24,'Jamnagar'),(511,24,'Junagadh'),(512,24,'Kachchh'),(513,24,'Kheda'),(514,24,'Mahisagar'),(515,24,'Mehsana'),(516,24,'Morbi'),(517,24,'Narmada'),(518,24,'Navsari'),(519,24,'Panchmahal'),(520,24,'Patan'),(521,24,'Porbandar'),(522,24,'Rajkat'),(523,24,'Sabarkantha'),(524,24,'Surat'),(525,24,'Surendrangar'),(526,24,'Tapi'),(527,24,'Vadadara'),(528,24,'Valsad'),(529,25,'Daman'),(530,25,'Diu'),(531,26,'Dadra and Nagar Haveli'),(532,27,'Thane'),(533,27,'Pune'),(534,27,'Mumbai Suburban'),(535,27,'Nashik'),(536,27,'Nagpur'),(537,27,'Ahmednagar'),(538,27,'Solpur'),(539,27,'Jalgaon'),(540,27,'Kolhapur'),(541,27,'Aurangabad'),(542,27,'Nanded'),(543,27,'Mumbai City'),(544,27,'Satara'),(545,27,'Amraoti'),(546,27,'Sabngil'),(547,27,'Yavatmal'),(548,27,'Raigarh'),(549,27,'Buldana'),(550,27,'Bid'),(551,27,'Latur'),(552,27,'Chandrapur'),(553,27,'Dhule'),(554,27,'Jalna'),(555,27,'Parbhani'),(556,27,'Akola'),(557,27,'Osmanabad'),(558,27,'Nandurbad'),(559,27,'Ratnagiri'),(560,27,'Gondiya'),(561,27,'Wardha'),(562,27,'Bhandara'),(563,27,'Washim'),(564,27,'Hingoli'),(565,27,'Gadchiroli'),(566,27,'Sindhudurg'),(567,28,'Ragareddy'),(568,28,'East Govdari'),(569,28,'Guntur'),(570,28,'Krishna'),(571,28,'Visakhapatnam'),(572,28,'Chittor'),(573,28,'Anantapur'),(574,28,'Kurnool'),(575,28,'Mahbubnager'),(576,28,'Hyderabad'),(577,28,'West Godavari'),(578,28,'Karimagar'),(579,28,'Warangal'),(580,28,'Nalgonda'),(581,28,'Prakasam'),(582,28,'Medak'),(583,28,'Sri Potti Sriramulu Nellore'),(584,28,'YSR'),(585,28,'Khammam'),(586,28,'Adilbad'),(587,28,'Srikakulam'),(588,28,'Nizamabad'),(589,28,'Vizianangaram'),(590,29,'Bangalore'),(591,29,'Belgaum'),(592,29,'Mysore'),(593,29,'Tumkur'),(594,29,'Gulbarga'),(595,29,'Bellary'),(596,29,'Beijapur'),(597,29,'Dakshina Kannada'),(598,29,'Davanagere'),(599,29,'Raichur'),(600,29,'Bagalkot'),(601,29,'Dharwad'),(602,29,'Mandya'),(603,29,'Hassan'),(604,29,'Shimoga'),(605,29,'Bidar'),(606,29,'Chitradurga'),(607,29,'Haveri'),(608,29,'Kolar'),(609,29,'Uttara Kannada'),(610,29,'Koppal'),(611,29,'Chikkaballapura'),(612,29,'Udupi'),(613,29,'Yadgir'),(614,29,'Chilkmagalur'),(615,29,'Ramanangara'),(616,29,'Gadag'),(617,29,'Chamarajanagar'),(618,29,'Bangalore Rural'),(619,29,'kodagu'),(620,30,'North Goa'),(621,30,'South Goa'),(622,31,'Lakashadweep'),(623,32,'Malappuram'),(624,32,'Thiruvananthapuram'),(625,32,'Ernakulam'),(626,32,'Thrissur'),(627,32,'Kozhikode'),(628,32,'Palakkad'),(629,32,'Kollam'),(630,32,'Kannur'),(631,32,'Alappuzha'),(632,32,'Kottayam'),(633,32,'Kasaragod'),(634,32,'Pathanmthitta'),(635,32,'Idulkki'),(636,32,'Wayanad'),(637,33,'Ariyalur'),(638,33,'Chennai'),(639,33,'Coimbatore'),(640,33,'Cuddalore'),(641,33,'Dharmapuri'),(642,33,'Dindigul'),(643,33,'Erode'),(644,33,'Kancheepuram'),(645,33,'Karur'),(646,33,'Krishnagiri'),(647,33,'Madurai'),(648,33,'Nagapattinam'),(649,33,'Kanyakumari'),(650,33,'Namakkal'),(651,33,'Perambalur'),(652,33,'Puthukkottai'),(653,33,'Ramananthapuram'),(654,33,'Salem'),(655,33,'Sivagangai'),(656,33,'Thanjavur'),(657,33,'Theni'),(658,33,'Thiruvallur'),(659,33,'Thiruvarur'),(660,33,'Tuticorin'),(661,33,'Thiruchirappalli'),(662,33,'Thirunelveli'),(663,33,'Tiruppur'),(664,33,'Tiruvanaamalai'),(665,33,'Udagamandalam'),(666,33,'Vellore'),(667,33,'Vilupuram'),(668,33,'Viruthunagar'),(669,34,'Karaikal'),(670,34,'Mahe'),(671,34,'Puthucherry'),(672,34,'Yanam'),(673,35,'Niconbar'),(674,35,'North And Middle Andaman'),(675,35,'South Andaman'),(676,36,'Adilabad'),(677,36,'Asifabad'),(678,36,'Kothagudem'),(679,36,'Bhupalpalle'),(680,36,'Gadwal'),(681,36,'Hyderabad'),(682,36,'Jagtial'),(683,36,'Jangaon'),(684,36,'Kamareddy'),(685,36,'Karimnagar'),(686,36,'Khammam'),(687,36,'Mahabubabad'),(688,36,'Mahbubnagar'),(689,36,'Mancherial'),(690,36,'Medak'),(691,36,'Malkajgiri'),(692,36,'Nalgonda'),(693,36,'Nagarkurnool'),(694,36,'Nirmal'),(695,36,'Nizamabad'),(696,36,'Shamshabad'),(697,36,'Peddapalle'),(698,36,'Sircilla'),(699,36,'Sangareddy'),(700,36,'Siddipet'),(701,36,'Suryapet'),(702,36,'Vikarabad'),(703,36,'Wanaparthy'),(704,36,'Warangal'),(705,36,'Warangal'),(706,36,'Bhongiri'),(707,6,'Mohindergarh'),(708,4,'Chandigarh'),(709,9,'Gautam budha Nagar'),(710,9,'jalaun'),(711,24,'Anand'),(712,23,'Balaghat'),(713,21,'Baleshwar'),(714,19,'Bardhaman'),(715,21,'Baudh'),(716,27,'Beed'),(717,23,'Betul'),(718,3,'Bhatinda'),(719,33,'Chengalpattu'),(720,33,'Kallakurichi'),(721,33,'Tirupathur'),(722,33,'Ranipet'),(772,33,'north madras'),(773,33,'Vadamadurai');
/*!40000 ALTER TABLE `district` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `enquiry`
--
DROP TABLE IF EXISTS `enquiry`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `enquiry` (
`id` int NOT NULL AUTO_INCREMENT,
`enq_id` varchar(255) DEFAULT NULL,
`name` varchar(255) NOT NULL,
`mobile_no` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`notes` varchar(255) DEFAULT NULL,
`followup_date` varchar(255) DEFAULT NULL,
`message` varchar(255) NOT NULL,
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
`status_id` int DEFAULT NULL,
`last_name` varchar(255) DEFAULT NULL,
`location` varchar(255) NOT NULL,
`company` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK_a3416d92be0c719549d7293224b` (`status_id`),
CONSTRAINT `FK_a3416d92be0c719549d7293224b` FOREIGN KEY (`status_id`) REFERENCES `status` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `enquiry`
--
LOCK TABLES `enquiry` WRITE;
/*!40000 ALTER TABLE `enquiry` DISABLE KEYS */;
INSERT INTO `enquiry` VALUES (1,'ENQ001','Siva','+919790261892','sivait34@gmaail.com',NULL,NULL,'You can find your Udyam registration number by visiting the official Udyam Registration portal and using the \"Print/verify\" option to either regain your forgotten number or print your certificate. You will need to enter your registered mobile number or em','2025-11-24 10:42:03.253882','2025-11-24 10:42:03.000000',0,0,1,'R','MDU','TGSS'),(2,'ENQ002','Rajapandi','+919047910296','technogenesisui@gmail.com',NULL,NULL,'By clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our Privacy PolicyBy clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our P','2025-11-24 15:17:51.623980','2025-11-24 15:17:51.000000',0,0,1,'P','Gujarat, India','asa'),(3,'ENQ003','Siva','+919790261892','sivait34@gmail.com',NULL,NULL,'Overall Feel: Clean, modern SaaS dashboard; minimal colors, a primary accent (e.g., teal/blue) for CTAs and highlights.\n\nGrid: 12-column responsive grid so it works well from 1280px upwards; cards stack on tablet/mobile.\n\nConsistency:','2025-12-08 08:29:06.222956','2025-12-08 08:29:06.000000',0,0,1,'Ramar','Madurai','TGSS'),(4,'ENQ004','Soundarya','+919894169153','otchusound93@gmail.com',NULL,NULL,'Consistency:\n\nCards with header (title + filter icon), content, small footer (e.g., “Updated 2 mins ago”).\n\nStandard icon set for jobs, candidates, interviews, settings.','2025-12-08 08:32:49.985559','2025-12-08 08:32:50.000000',0,0,1,'Siva','ELCOT','Techno Genesis'),(5,'ENQ005','ROOBIKA','+917639591850','roobiroobi085@gmail.com',NULL,NULL,'Hello, I’m Roobika I\'m a recent Computer Science graduate specializing in AI and Machine Learning, with strong hands-on experience in Python, SQL, NLP, and building real-world AI applications. I’ve worked on projects involving document intelligence, chatb','2025-12-17 04:12:21.027543','2025-12-17 04:12:21.000000',0,0,1,'M','Madurai','None'),(6,'ENQ006','Shristi','+919979553686','sales@sinelogixtechnologies.com',NULL,NULL,'Are you Looking for skilled developers on a monthly/hourly contract?\n \nWe provide dedicated developers with 3–10+ years of experience on a monthly contractual basis with no advance payment required. You pay only at the end of each month, giving you full c','2025-12-24 06:43:47.487760','2025-12-24 06:43:47.000000',0,0,1,'Sureka','Vadodara','Sinelogix Web Technologies'),(7,'ENQ007','Vijay vikram','+919363452816','mr.vijayvikram726@gmail.com',NULL,NULL,'Any vaccancy is available in your company plz reply with me in a day','2026-01-13 14:10:53.773031','2026-01-13 14:10:53.000000',0,0,1,'M S','Madurai','Not working'),(8,'ENQ008','Mayankkumar','+917227077979','mrrana2001@yahoo.com',NULL,NULL,'For job opening for project.\nOr any current plant running startup and shutdown. Commissioning and pre Commissioning. As a shift supervisor or DCS operation. \nConsider for above post. \nEducation is B.Sc chemistry Diploma Environment Management BE chemical.','2026-01-24 11:39:44.022207','2026-01-24 11:39:44.000000',0,0,1,'Rana','Nigeria','Dangote Refinery'),(9,'ENQ009','Abinaya','+918825669028','abinayarajavel30@gmail.com',NULL,NULL,'I have been following in linkedin and I am very interested in contributing to your team.As a final year graduate with a degree in B.Tech Information Technology from Kamaraj college of engineering and technology, currently I seeking entry-level opportuniti','2026-02-03 05:23:17.814253','2026-02-03 05:23:17.000000',0,0,1,'Rajavel','Madurai,Tamilnadu','Kamaraj college of engineering and technology'),(10,'ENQ010','Nandhini','+919384291201','nandiyasmi@gmail.com',NULL,NULL,'Hello Sir /Madam\nI\'m Nandhini from Bangalore \nI have 2 years experience in WordPress development and I\'m interested in working with your company.','2026-03-27 08:48:14.806389','2026-03-27 08:48:14.000000',0,0,1,'K V','Bangalore','Techno Genesis'),(11,'ENQ011','Shristi','+919979553686','sales@sinelogixtechnologies.com',NULL,NULL,'Are you Looking for skilled developers on a monthly/hourly contract?\n \nWe provide dedicated developers with 3–10+ years of experience on a monthly contractual basis with no advance payment required. You pay only at the end of each month, giving you full c','2026-04-27 12:19:34.931897','2026-04-27 12:19:34.000000',0,0,1,'Sureka','Vadodara','Sinelogix Web Technologies'),(12,'ENQ012','Dharshini','+919342503614','d32200632@gmail.com',NULL,NULL,'I am BCA fresher I am eager to work with your company','2026-05-11 09:34:52.355869','2026-05-11 09:34:52.000000',0,0,1,'S','Madurai','Techno Genesis'),(13,'ENQ013','Sriniti','+918124869799','sriniti2005@gmail.com',NULL,NULL,'I hope you are doing well. My name is SRINITI K.K, and I recently completed my BE in Electronics and Communication Engineering from Thiagarajar College of Engineering. I am a fresher looking for an opportunity to start my career and improve my skills. I h','2026-05-12 05:01:13.317581','2026-05-12 05:01:13.000000',0,0,1,'KK','Madurai, Tamil Nadu, India','Techno Genesis Software solutions Pvt.Ltd');
/*!40000 ALTER TABLE `enquiry` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `enquiry_tracking`
--
DROP TABLE IF EXISTS `enquiry_tracking`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `enquiry_tracking` (
`id` int NOT NULL AUTO_INCREMENT,
`notes` varchar(255) DEFAULT NULL,
`followup_date` varchar(255) DEFAULT NULL,
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`enquiry_id` int DEFAULT NULL,
`status_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_7a30821cd9e742358d50ed6fd1e` (`enquiry_id`),
KEY `FK_53a0d459c61fed4458b46455b6c` (`status_id`),
CONSTRAINT `FK_53a0d459c61fed4458b46455b6c` FOREIGN KEY (`status_id`) REFERENCES `status` (`id`),
CONSTRAINT `FK_7a30821cd9e742358d50ed6fd1e` FOREIGN KEY (`enquiry_id`) REFERENCES `enquiry` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `enquiry_tracking`
--
LOCK TABLES `enquiry_tracking` WRITE;
/*!40000 ALTER TABLE `enquiry_tracking` DISABLE KEYS */;
INSERT INTO `enquiry_tracking` VALUES (1,NULL,NULL,'2025-11-24 10:42:03.353064',0,1,1),(2,NULL,NULL,'2025-11-24 15:17:51.642860',0,2,1),(3,NULL,NULL,'2025-12-08 08:29:06.279460',0,3,1),(4,NULL,NULL,'2025-12-08 08:32:50.028401',0,4,1),(5,NULL,NULL,'2025-12-17 04:12:21.073839',0,5,1),(6,NULL,NULL,'2025-12-24 06:43:47.832969',0,6,1),(7,NULL,NULL,'2026-01-13 14:10:53.818611',0,7,1),(8,NULL,NULL,'2026-01-24 11:39:44.120007',0,8,1),(9,NULL,NULL,'2026-02-03 05:23:17.875849',0,9,1),(10,NULL,NULL,'2026-03-27 08:48:14.838812',0,10,1),(11,NULL,NULL,'2026-04-27 12:19:34.991083',0,11,1),(12,NULL,NULL,'2026-05-11 09:34:52.404214',0,12,1),(13,NULL,NULL,'2026-05-12 05:01:13.368104',0,13,1);
/*!40000 ALTER TABLE `enquiry_tracking` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `events`
--
DROP TABLE IF EXISTS `events`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `events` (
`id` int NOT NULL AUTO_INCREMENT,
`event_title` varchar(500) NOT NULL,
`event_location` varchar(500) NOT NULL,
`thumbnail_image` varchar(500) NOT NULL,
`event_description` text,
`event_date` varchar(500) NOT NULL,
`status` int NOT NULL DEFAULT '1',
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
`gallery` json DEFAULT NULL,
`banner_image` varchar(500) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `events`
--
LOCK TABLES `events` WRITE;
/*!40000 ALTER TABLE `events` DISABLE KEYS */;
/*!40000 ALTER TABLE `events` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `events_gallery`
--
DROP TABLE IF EXISTS `events_gallery`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `events_gallery` (
`id` int NOT NULL AUTO_INCREMENT,
`type` int DEFAULT NULL,
`images` varchar(500) NOT NULL,
`video_thumbnail_image` varchar(500) NOT NULL,
`reorder_id` int DEFAULT NULL,
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
`events_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_6b83e886ab1194d045aa61c35a4` (`events_id`),
CONSTRAINT `FK_6b83e886ab1194d045aa61c35a4` FOREIGN KEY (`events_id`) REFERENCES `events` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `events_gallery`
--
LOCK TABLES `events_gallery` WRITE;
/*!40000 ALTER TABLE `events_gallery` DISABLE KEYS */;
/*!40000 ALTER TABLE `events_gallery` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `help_support`
--
DROP TABLE IF EXISTS `help_support`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `help_support` (
`help_support_id` int NOT NULL AUTO_INCREMENT,
`full_name` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`message` longtext,
`created_by` int NOT NULL DEFAULT '0',
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
PRIMARY KEY (`help_support_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `help_support`
--
LOCK TABLES `help_support` WRITE;
/*!40000 ALTER TABLE `help_support` DISABLE KEYS */;
/*!40000 ALTER TABLE `help_support` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `in_app_update`
--
DROP TABLE IF EXISTS `in_app_update`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `in_app_update` (
`app_update_id` int NOT NULL AUTO_INCREMENT,
`version` varchar(255) DEFAULT NULL,
`appstore_version` varchar(255) DEFAULT NULL,
`mode` varchar(255) DEFAULT NULL,
`playstore_url` varchar(255) DEFAULT NULL,
`appstore_url` varchar(255) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`appstore_id` varchar(255) DEFAULT NULL,
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
PRIMARY KEY (`app_update_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `in_app_update`
--
LOCK TABLES `in_app_update` WRITE;
/*!40000 ALTER TABLE `in_app_update` DISABLE KEYS */;
/*!40000 ALTER TABLE `in_app_update` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `job`
--
DROP TABLE IF EXISTS `job`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job` (
`id` int NOT NULL AUTO_INCREMENT,
`job_title` varchar(100) NOT NULL,
`gender` varchar(255) NOT NULL,
`salary_from` varchar(255) NOT NULL,
`salary_to` varchar(255) NOT NULL,
`job_expiry_date` timestamp NOT NULL,
`no_of_positions` int NOT NULL DEFAULT '1',
`description` text NOT NULL,
`key_responsibility` text NOT NULL,
`experience` int NOT NULL DEFAULT '1',
`posting_date` varchar(255) NOT NULL,
`hide_salary` tinyint NOT NULL DEFAULT '1',
`is_freelance` tinyint NOT NULL DEFAULT '1',
`job_tag` text,
`status` int NOT NULL DEFAULT '1',
`is_default` tinyint NOT NULL DEFAULT '0',
`is_deleted` tinyint NOT NULL DEFAULT '0',
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
`category_id` int DEFAULT NULL,
`country_id` int NOT NULL DEFAULT '0',
`state_id` int NOT NULL DEFAULT '0',
`carrier_level_id` int DEFAULT NULL,
`job_shift_id` int DEFAULT NULL,
`degree_level_id` int DEFAULT NULL,
`custom_field` varchar(100) NOT NULL,
`custom_field_value` text,
`country_name` varchar(255) NOT NULL,
`state_name` varchar(255) NOT NULL,
`citi_id` int NOT NULL DEFAULT '0',
`citi_name` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK_15f44c4b9fbb84e28a0346e930f` (`category_id`),
KEY `FK_0d860d832768b6064e409ad60cb` (`carrier_level_id`),
KEY `FK_5a954993ab5701d70636f57496c` (`job_shift_id`),
KEY `FK_47bb86a2d34d9a6453fdf173386` (`degree_level_id`),
CONSTRAINT `FK_0d860d832768b6064e409ad60cb` FOREIGN KEY (`carrier_level_id`) REFERENCES `career_level` (`id`),
CONSTRAINT `FK_15f44c4b9fbb84e28a0346e930f` FOREIGN KEY (`category_id`) REFERENCES `job_category` (`id`),
CONSTRAINT `FK_47bb86a2d34d9a6453fdf173386` FOREIGN KEY (`degree_level_id`) REFERENCES `degree_level` (`id`),
CONSTRAINT `FK_5a954993ab5701d70636f57496c` FOREIGN KEY (`job_shift_id`) REFERENCES `job_shift` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `job`
--
LOCK TABLES `job` WRITE;
/*!40000 ALTER TABLE `job` DISABLE KEYS */;
INSERT INTO `job` VALUES (1,'Quality Analyst','FEMALE','300000','350000','2025-11-29 18:30:00',1,'<p><strong>Required Skills:</strong></p><ul><li>Strong knowledge of <strong>SDLC, STLC</strong>, and <strong>defect life cycle</strong>.</li><li>Hands-on experience in <strong>manual testing</strong> and exposure to <strong>automation tools</strong> (e.g., Selenium, TestNG, Postman, JMeter).</li><li>Experience with <strong>API testing</strong> and <strong>database validation</strong> (SQL queries).</li><li>Understanding of Agile methodologies (Scrum/Kanban).</li><li>Good analytical, problem-solving, and communication skills.</li><li>Ability to work in a fast-paced and collaborative environment.</li></ul><p><strong>Educational Qualification:</strong></p><ul><li>Bachelor’s degree in <strong>Computer Science, Information Technology, Engineering</strong>, or a related field.</li><li>Relevant certification (ISTQB, Selenium, etc.) is a plus.</li></ul><p><strong>Perks & Benefits:</strong></p><ul><li>Competitive salary based on experience.</li><li>Opportunity to work on challenging and innovative projects.</li><li>Learning and development support for QA tools and automation frameworks.</li><li>Flexible and collaborative work environment.</li></ul>','<ul><li>Analyze project requirements and develop effective test strategies and test plans.</li><li>Execute <strong>manual and automated test cases</strong> across web and mobile applications.</li><li>Perform <strong>functional, regression, integration, and performance testing</strong>.</li><li>Contribute to improving QA processes, tools, and techniques.</li><li>Prepare detailed test reports and documentation</li></ul>',2,'25/11/2025',0,0,'Manual Testing,Automation Testing,Selenium,API Testing',1,0,0,'2025-11-25 06:22:16.689144','2025-11-25 08:27:49.000000',0,0,12,101,4035,7,3,4,'','','India','Tamil Nadu',132821,'Madurai');
/*!40000 ALTER TABLE `job` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `job_category`
--
DROP TABLE IF EXISTS `job_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_category` (
`id` int NOT NULL AUTO_INCREMENT,
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
`category_name` varchar(100) NOT NULL,
`status` int NOT NULL DEFAULT '1',
`is_default` tinyint NOT NULL DEFAULT '0',
`is_deleted` tinyint NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `job_category`
--
LOCK TABLES `job_category` WRITE;
/*!40000 ALTER TABLE `job_category` DISABLE KEYS */;
INSERT INTO `job_category` VALUES (1,'2024-08-01 11:38:22.147461','2024-08-01 11:40:43.000000',1,0,'Mechanical engineering',1,0,0),(2,'2024-08-01 11:40:58.896535','2024-08-01 11:41:13.000000',1,0,'engineer',1,0,1),(3,'2024-08-01 12:04:48.521421','2024-08-01 12:04:48.521421',1,0,'Wind Designer',1,0,0),(4,'2024-08-06 07:50:10.082000','2024-08-06 07:50:10.082000',1,0,'Electrical Engineer',1,0,0),(5,'2024-10-24 06:59:41.553148','2024-10-24 06:59:41.553148',1,0,'Development',1,0,0),(6,'2025-07-31 05:59:08.803169','2026-01-07 10:12:34.000000',1,0,'Web developer',0,0,1),(7,'2025-07-31 07:18:58.062209','2025-07-31 07:18:58.062209',1,0,'Developer',1,0,0),(8,'2025-08-12 09:38:03.684010','2025-08-12 09:45:42.000000',1,0,'Accountant',1,0,0),(9,'2025-08-12 10:53:03.668756','2025-08-12 10:53:24.000000',1,0,'Python Developer',1,0,0),(10,'2025-08-12 10:53:59.581816','2025-08-12 10:54:28.000000',1,0,'UI/UX',1,0,0),(11,'2025-08-19 05:36:28.814881','2025-08-19 05:36:28.814881',1,0,'Recruitment / Talent Acquisition',1,0,0),(12,'2025-11-25 06:14:48.986854','2026-01-07 10:18:31.000000',1,0,'Quality Analyst',1,0,0);
/*!40000 ALTER TABLE `job_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `job_shift`
--
DROP TABLE IF EXISTS `job_shift`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_shift` (
`id` int NOT NULL AUTO_INCREMENT,
`shift_name` varchar(100) NOT NULL,
`status` int NOT NULL DEFAULT '1',
`is_default` tinyint NOT NULL DEFAULT '0',
`is_deleted` tinyint NOT NULL DEFAULT '0',
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `job_shift`
--
LOCK TABLES `job_shift` WRITE;
/*!40000 ALTER TABLE `job_shift` DISABLE KEYS */;
INSERT INTO `job_shift` VALUES (1,'First Shift',1,0,0,'2024-07-12 09:19:30.277678','2024-07-12 09:19:30.277678',0,0),(2,'Fixed Shift',1,0,0,'2024-07-12 09:19:30.288127','2024-07-12 09:19:30.288127',0,0),(3,'Full time',1,0,0,'2024-07-12 09:19:30.288907','2024-07-26 06:10:59.030212',0,0),(4,'Rotating Shift',1,0,0,'2024-07-12 09:19:30.289407','2024-07-12 09:19:30.289407',0,0),(5,'Second Shift',1,0,0,'2024-07-12 09:19:30.290149','2024-07-12 09:19:30.290149',0,0),(6,'Split Shift',1,0,0,'2024-07-12 09:19:30.290580','2024-07-12 09:19:30.290580',0,0),(7,'Third Shift',1,0,0,'2024-07-12 09:19:30.290892','2024-07-12 09:19:30.290892',0,0);
/*!40000 ALTER TABLE `job_shift` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `job_skill`
--
DROP TABLE IF EXISTS `job_skill`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_skill` (
`id` int NOT NULL AUTO_INCREMENT,
`skill_name` varchar(100) NOT NULL,
`status` int NOT NULL DEFAULT '1',
`is_default` tinyint NOT NULL DEFAULT '0',
`is_deleted` tinyint NOT NULL DEFAULT '0',
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `job_skill`
--
LOCK TABLES `job_skill` WRITE;
/*!40000 ALTER TABLE `job_skill` DISABLE KEYS */;
INSERT INTO `job_skill` VALUES (1,'SCADA systems',1,0,0,'2024-08-01 11:45:46.272758','2024-08-01 11:47:34.000000',1,0),(2,'Gearboxes',1,0,0,'2024-08-01 11:54:00.100814','2024-08-01 11:54:00.100814',1,0),(3,'OEM Equipments',1,0,0,'2024-08-01 11:54:44.973171','2024-08-01 11:54:44.973171',1,0),(4,'Electrical Circuits',1,0,0,'2024-08-01 11:55:31.121144','2024-08-01 11:55:31.121144',1,0),(5,'Safety Procedure',1,0,0,'2024-08-01 11:55:45.330847','2024-08-01 11:55:45.330847',1,0),(6,'Nuclear Power Plant',1,0,0,'2024-08-01 11:56:16.141709','2024-08-01 11:56:16.141709',1,0),(7,'lglg',1,0,1,'2024-08-01 11:56:42.691953','2024-08-01 11:56:50.000000',1,0),(8,'Transmission Line',1,0,0,'2024-08-06 07:51:02.643312','2024-08-06 07:51:02.643312',1,0),(9,'Angular',1,0,0,'2024-10-24 06:59:54.762443','2024-10-24 06:59:54.762443',1,0),(10,'React',1,0,0,'2024-10-24 07:00:08.891794','2024-10-24 07:00:08.891794',1,0),(11,'Tally',1,0,0,'2025-08-12 09:41:07.703016','2025-08-12 09:41:25.000000',1,0),(12,'Python',1,0,0,'2025-08-12 10:55:21.910880','2025-08-12 10:56:11.000000',1,0),(13,'Employee Onboarding & Offboarding',1,0,0,'2025-08-19 05:37:39.486397','2025-08-19 05:37:39.486397',1,0),(14,'Employee Relations',1,0,0,'2025-08-19 05:38:00.697794','2025-08-19 05:38:00.697794',1,0),(15,'Payroll Management',1,0,0,'2025-08-19 05:38:38.940095','2025-08-19 05:38:38.940095',1,0),(16,'Manual & Automation Testing',1,0,0,'2025-11-25 06:15:48.078318','2025-11-25 06:15:48.078318',1,0);
/*!40000 ALTER TABLE `job_skill` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `job_skills`
--
DROP TABLE IF EXISTS `job_skills`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_skills` (
`job_id` int NOT NULL,
`skill_id` int NOT NULL,
PRIMARY KEY (`job_id`,`skill_id`),
KEY `IDX_4f7427e13d249156f37669e712` (`job_id`),
KEY `IDX_7c0a3c52e77f9d9d839fdbb14b` (`skill_id`),
CONSTRAINT `FK_4f7427e13d249156f37669e7127` FOREIGN KEY (`job_id`) REFERENCES `job` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_7c0a3c52e77f9d9d839fdbb14b6` FOREIGN KEY (`skill_id`) REFERENCES `job_skill` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `job_skills`
--
LOCK TABLES `job_skills` WRITE;
/*!40000 ALTER TABLE `job_skills` DISABLE KEYS */;
INSERT INTO `job_skills` VALUES (1,16);
/*!40000 ALTER TABLE `job_skills` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `lets_connect`
--
DROP TABLE IF EXISTS `lets_connect`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lets_connect` (
`id` int NOT NULL AUTO_INCREMENT,
`letsconnect_id` varchar(255) DEFAULT NULL,
`first_name` varchar(255) NOT NULL,
`last_name` varchar(255) DEFAULT NULL,
`mobile_no` varchar(255) NOT NULL,
`work_email` varchar(255) NOT NULL,
`country` text NOT NULL,
`companyname` text NOT NULL,
`companysize` text NOT NULL,
`businessneed` text NOT NULL,
`requirement` text NOT NULL,
`acceptTerms` tinyint NOT NULL DEFAULT '0',
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
`status_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_5fa6dbb5b28d7bce709afb6f58c` (`status_id`),
CONSTRAINT `FK_5fa6dbb5b28d7bce709afb6f58c` FOREIGN KEY (`status_id`) REFERENCES `status` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `lets_connect`
--
LOCK TABLES `lets_connect` WRITE;
/*!40000 ALTER TABLE `lets_connect` DISABLE KEYS */;
/*!40000 ALTER TABLE `lets_connect` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `login_activity`
--
DROP TABLE IF EXISTS `login_activity`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `login_activity` (
`id` int NOT NULL AUTO_INCREMENT,
`platform` varchar(500) NOT NULL,
`login_by` varchar(500) NOT NULL,
`login_email` varchar(500) NOT NULL,
`ip_address` varchar(100) DEFAULT NULL,
`os` varchar(100) DEFAULT NULL,
`user_agent` varchar(255) DEFAULT NULL,
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`userId` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_28aab163e727fb7ddbb9f07c485` (`userId`),
CONSTRAINT `FK_28aab163e727fb7ddbb9f07c485` FOREIGN KEY (`userId`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `login_activity`
--
LOCK TABLES `login_activity` WRITE;
/*!40000 ALTER TABLE `login_activity` DISABLE KEYS */;
/*!40000 ALTER TABLE `login_activity` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mobile_usage_limit`
--
DROP TABLE IF EXISTS `mobile_usage_limit`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mobile_usage_limit` (
`id` int NOT NULL AUTO_INCREMENT,
`duration` bigint NOT NULL,
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`updated_by` int NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mobile_usage_limit`
--
LOCK TABLES `mobile_usage_limit` WRITE;
/*!40000 ALTER TABLE `mobile_usage_limit` DISABLE KEYS */;
/*!40000 ALTER TABLE `mobile_usage_limit` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `notifications`
--
DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `notifications` (
`notification_id` int NOT NULL AUTO_INCREMENT,
`title` varchar(500) DEFAULT NULL,
`body` text,
`user_type` varchar(255) DEFAULT NULL,
`sender` int DEFAULT NULL,
`receiver` int DEFAULT NULL,
`module_name` varchar(255) DEFAULT NULL,
`page` text,
`portal` text,
`data` json DEFAULT NULL,
`msg_read` int NOT NULL DEFAULT '0',
`status` int NOT NULL DEFAULT '0',
`random_id` varchar(255) DEFAULT NULL,
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
`application_id` int NOT NULL,
PRIMARY KEY (`notification_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `notifications`
--
LOCK TABLES `notifications` WRITE;
/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
INSERT INTO `notifications` VALUES (1,'Kumar has just applied for the job position of Quality Analyst','Kumar has just applied for the job position of Quality Analyst','2',4,1,'New Job Application Received','new_commission','admin','{\"data\": {\"body\": \"Kumar has just applied for the job position of Quality Analyst\", \"data\": \"{\\\"application_id\\\":1,\\\"random_id\\\":\\\"778f2c\\\",\\\"portal\\\":\\\"admin\\\"}\", \"title\": \"New Job Application Received\"}}',1,0,'778f2c','2025-11-25 10:27:00.637446','2025-11-26 11:29:24.000000',0,0,1),(2,'Dinesh R has just applied for the job position of Quality Analyst','Dinesh R has just applied for the job position of Quality Analyst','2',4,1,'New Job Application Received','new_commission','admin','{\"data\": {\"body\": \"Dinesh R has just applied for the job position of Quality Analyst\", \"data\": \"{\\\"application_id\\\":2,\\\"random_id\\\":\\\"4feb12\\\",\\\"portal\\\":\\\"admin\\\"}\", \"title\": \"New Job Application Received\"}}',0,0,'4feb12','2025-11-25 19:08:34.171137','2025-11-25 19:08:34.171137',0,0,2),(3,'SHAKTHIIVEL VENKAATESHWARAR B has just applied for the job position of Quality Analyst','SHAKTHIIVEL VENKAATESHWARAR B has just applied for the job position of Quality Analyst','2',4,1,'New Job Application Received','new_commission','admin','{\"data\": {\"body\": \"SHAKTHIIVEL VENKAATESHWARAR B has just applied for the job position of Quality Analyst\", \"data\": \"{\\\"application_id\\\":3,\\\"random_id\\\":\\\"eca9ce\\\",\\\"portal\\\":\\\"admin\\\"}\", \"title\": \"New Job Application Received\"}}',0,0,'eca9ce','2025-11-26 08:35:50.961513','2025-11-26 08:35:50.961513',0,0,3),(4,'Test Name has just applied for the job position of Quality Analyst','Test Name has just applied for the job position of Quality Analyst','2',4,1,'New Job Application Received','new_commission','admin','{\"data\": {\"body\": \"Test Name has just applied for the job position of Quality Analyst\", \"data\": \"{\\\"application_id\\\":4,\\\"random_id\\\":\\\"c8f5a9\\\",\\\"portal\\\":\\\"admin\\\"}\", \"title\": \"New Job Application Received\"}}',0,0,'c8f5a9','2025-11-26 11:32:53.467553','2025-11-26 11:32:53.467553',0,0,4),(5,'Manikandan K has just applied for the job position of Quality Analyst','Manikandan K has just applied for the job position of Quality Analyst','2',4,1,'New Job Application Received','new_commission','admin','{\"data\": {\"body\": \"Manikandan K has just applied for the job position of Quality Analyst\", \"data\": \"{\\\"application_id\\\":5,\\\"random_id\\\":\\\"d4e8d2\\\",\\\"portal\\\":\\\"admin\\\"}\", \"title\": \"New Job Application Received\"}}',0,0,'d4e8d2','2025-11-26 12:41:23.532340','2025-11-26 12:41:23.532340',0,0,5),(6,'Gokulasri J has just applied for the job position of Quality Analyst','Gokulasri J has just applied for the job position of Quality Analyst','2',4,1,'New Job Application Received','new_commission','admin','{\"data\": {\"body\": \"Gokulasri J has just applied for the job position of Quality Analyst\", \"data\": \"{\\\"application_id\\\":6,\\\"random_id\\\":\\\"f151d6\\\",\\\"portal\\\":\\\"admin\\\"}\", \"title\": \"New Job Application Received\"}}',0,0,'f151d6','2025-11-28 06:24:47.734683','2025-11-28 06:24:47.734683',0,0,6),(7,'J jayasri has just applied for the job position of Quality Analyst','J jayasri has just applied for the job position of Quality Analyst','2',4,1,'New Job Application Received','new_commission','admin','{\"data\": {\"body\": \"J jayasri has just applied for the job position of Quality Analyst\", \"data\": \"{\\\"application_id\\\":7,\\\"random_id\\\":\\\"bbcbe0\\\",\\\"portal\\\":\\\"admin\\\"}\", \"title\": \"New Job Application Received\"}}',0,0,'bbcbe0','2025-11-28 06:33:05.861565','2025-11-28 06:33:05.861565',0,0,7);
/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `otp_generate`
--
DROP TABLE IF EXISTS `otp_generate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `otp_generate` (
`otp_generate_id` int NOT NULL AUTO_INCREMENT,
`mobile_no` varchar(255) DEFAULT NULL,
`mobile_no_otp` varchar(255) DEFAULT NULL,
`otp_verify_date` varchar(255) DEFAULT NULL,
PRIMARY KEY (`otp_generate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `otp_generate`
--
LOCK TABLES `otp_generate` WRITE;
/*!40000 ALTER TABLE `otp_generate` DISABLE KEYS */;
/*!40000 ALTER TABLE `otp_generate` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `quote`
--
DROP TABLE IF EXISTS `quote`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `quote` (
`id` int NOT NULL AUTO_INCREMENT,
`quote_id` varchar(255) DEFAULT NULL,
`first_name` varchar(255) NOT NULL,
`last_name` varchar(255) DEFAULT NULL,
`mobile_no` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`country` varchar(255) DEFAULT NULL,
`company_name` varchar(255) NOT NULL,
`company_size` varchar(255) NOT NULL,
`business_need` varchar(255) DEFAULT NULL,
`requirements` varchar(255) NOT NULL,
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
`other_business_need` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `quote`
--
LOCK TABLES `quote` WRITE;
/*!40000 ALTER TABLE `quote` DISABLE KEYS */;
INSERT INTO `quote` VALUES (1,'Quote-1','Siva','Ramar','+919790261892','siva@technogenesis.in','India','TGSS','11-50','Technological Business Evolution','You can find your Udyam registration number by visiting the official Udyam Registration portal and using the \"Print/verify\" option to either regain your forgotten number or print your certificate. You will need to enter your registered mobile number or em','2025-11-24 10:53:09.436079','2025-11-24 10:53:09.000000',0,0,NULL),(2,'Quote-2','admin123','P','+919874512302','technogenesisui@gmail.com','India','asa','11-50','qwertyuiopp','y clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our Privacy Policy y clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our Pr','2025-11-24 11:25:33.408745','2025-11-24 11:25:33.000000',0,0,NULL),(3,'Quote-3','admin123','D','+916374834073','technogenesisui@gmail.com','Angola','asa','250+','Other','\nBy clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our Privacy Policy\nBy clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our','2025-11-24 13:11:12.306205','2025-11-24 13:11:12.000000',0,0,'qwertyuiopasdfghjk'),(4,'Quote-4','Rajapandi','N','+916374834073','technogenesisui@gmail.com','American Samoa','asa','1-10','Other','By clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our Privacy PolicyBy clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our P','2025-11-24 14:52:18.624075','2025-11-24 14:52:18.000000',0,0,'qwertyuiopasdfghjk'),(5,'Quote-5','Test','Ps','+911121212121','technogenesisui@gmail.com','Angola','asa','11-50','Technological Business Evolution','On this World Environment Day, let’s reflect, act, and inspire. Every step we take — no matter how small — contributes to a healthier planet.\nLet’s choose sustainability, celebrate nature, and commit to being responsible global citizens.On this World Envi','2025-11-24 14:57:29.809628','2025-11-24 14:57:29.000000',0,0,''),(6,'Quote-6','admin123','P','+916374834073','technogenesisui@gmail.com','Armenia','Techno','51-100','Integrated Stack Development','We’re glad to have you onboard of with us. We will be sending emails to you keep updated on all the latest things.We’re glad to have you onboard of with us. We will be sending emails to you keep updated on all the latest things.We’re glad to have you onbo','2025-11-24 15:02:32.880434','2025-11-24 15:02:32.000000',0,0,''),(7,'Quote-7','Rajapandi','D','+919874512302','technogenesisui@gmail.com','Antigua And Barbuda','asa','11-50','Data Science & Analytics','We’re glad to have you onboard of with us. We will be sending emails to you keep updated on all the latest things.We’re glad to have you onboard of with us. We will be sending emails to you keep updated on all the latest things.We’re glad to have you onbo','2025-11-24 15:07:40.008757','2025-11-24 15:07:40.000000',0,0,NULL),(8,'Quote-8','admin123','Ps','+919874512302','technogenesisui@gmail.com','Belarus','By clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our Privacy Policy','51-100','Cloud & DevOps Services','By clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our Privacy PolicyBy clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our P','2025-11-24 15:14:41.767604','2025-11-24 15:14:41.000000',0,0,''),(9,'Quote-9','Rajapandi','user','+919874512302','admin@gmail.com','Angola','By clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our Privacy Policy','11-50','Cloud & DevOps Services','By clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our Privacy PolicyBy clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our P','2025-11-24 15:19:10.027914','2025-11-24 15:19:10.000000',0,0,''),(10,'Quote-10','Kumar','D','+916374834073','technogenesisui@gmail.com','Andorra','By clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our Privacy Policy','1-10','Technological Business Evolution','By clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our Privacy PolicyBy clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our P','2025-11-24 15:19:52.757608','2025-11-24 15:19:52.000000',0,0,''),(11,'Quote-11','admin123','D','+9174561230','technogenesisui@gmail.com','Antigua And Barbuda','asa','51-100','Other','By clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our Privacy PolicyBy clicking the submit button, you agree Techno Genesis & utilize the information for contact purposes. Please read our P','2025-11-24 15:31:14.899012','2025-11-24 15:31:14.000000',0,0,'qwertyuiopasdfghjk'),(12,'Quote-12','Kumar','p','+916374834073','technogenesisui@gmail.com','Afghanistan','asa','11-50','Other','Please enter your requirements in minimum of 150 charactersPlease enter your requirements in minimum of 150 charactersPlease enter your requirements in minimum of 150 charactersPlease enter your requirements in minimum of 150 charactersPlease enter your r','2025-11-24 15:43:50.713595','2025-11-24 15:43:50.000000',0,0,'Please enter your requirements in m'),(13,'Quote-13','Siva','Ramar','+919790261892','siva@technogenesis.in','India','Techno Genesis','51-100','Technological Business Evolution','Here are some major IT and Non-IT related events and summits scheduled to take place in India in early 2026.\nIT Related Events & Summits\nInternational Conference on Distributed Computing and Intelligent Technology (ICDCIT 2026)\nDate: January 8, 2026\nLocat','2025-11-28 10:28:55.626602','2025-11-28 10:28:55.000000',0,0,'');
/*!40000 ALTER TABLE `quote` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `rental_transaction_limit`
--
DROP TABLE IF EXISTS `rental_transaction_limit`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rental_transaction_limit` (
`id` int NOT NULL AUTO_INCREMENT,
`minimum` double(10,2) NOT NULL,
`maximum` double(10,2) NOT NULL,
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`updated_by` int NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `rental_transaction_limit`
--
LOCK TABLES `rental_transaction_limit` WRITE;
/*!40000 ALTER TABLE `rental_transaction_limit` DISABLE KEYS */;
/*!40000 ALTER TABLE `rental_transaction_limit` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `role`
--
DROP TABLE IF EXISTS `role`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `role` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`status` int NOT NULL DEFAULT '1',
`is_default` tinyint NOT NULL DEFAULT '0',
`is_deleted` tinyint NOT NULL DEFAULT '0',
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `role`
--
LOCK TABLES `role` WRITE;
/*!40000 ALTER TABLE `role` DISABLE KEYS */;
INSERT INTO `role` VALUES (1,'Admin',1,0,0,'2024-04-24 06:08:46.763775','2024-04-24 06:08:46.763775',0,0);
/*!40000 ALTER TABLE `role` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `state`
--
DROP TABLE IF EXISTS `state`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `state` (
`state_id` int NOT NULL AUTO_INCREMENT,
`country_id` int DEFAULT NULL,
`state_name` varchar(1500) NOT NULL,
PRIMARY KEY (`state_id`),
KEY `FK_dd19065b0813dbffd8170ea6753` (`country_id`),
CONSTRAINT `FK_dd19065b0813dbffd8170ea6753` FOREIGN KEY (`country_id`) REFERENCES `country` (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `state`
--
LOCK TABLES `state` WRITE;
/*!40000 ALTER TABLE `state` DISABLE KEYS */;
INSERT INTO `state` VALUES (1,101,'Jummu and kashmir'),(2,101,'Himachal pradesh'),(3,101,'Punjab'),(4,101,'Chandigarh'),(5,101,'Uttarakhand'),(6,101,'Haryana'),(7,101,'Delhi'),(8,101,'Rajasthan'),(9,101,'Uttar Pradesh'),(10,101,'Bihar'),(11,101,'Sikkim'),(12,101,'Arunachal Pradesh'),(13,101,'Nagaland'),(14,101,'Manipur'),(15,101,'Mizoram'),(16,101,'Tripura'),(17,101,'Meghalaya'),(18,101,'Assam'),(19,101,'West Bengal'),(20,101,'Jharkhand'),(21,101,'Orissa'),(22,101,'Chhattisgarh'),(23,101,'Madhya Pradesh'),(24,101,'Gujarat'),(25,101,'Daman & Diu'),(26,101,'Dadra & Nagar Haveli'),(27,101,'Maharashtra'),(28,101,'Andhra Pradesh'),(29,101,'Karnataka'),(30,101,'Goa'),(31,101,'Lakshadweep'),(32,101,'Kerala'),(33,101,'Tamil Nadu'),(34,101,'Puducherry'),(35,101,'Andaman & Nicobar Islands'),(36,101,'Telengana');
/*!40000 ALTER TABLE `state` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `static_data`
--
DROP TABLE IF EXISTS `static_data`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `static_data` (
`id` int NOT NULL AUTO_INCREMENT,
`template` mediumtext,
`name` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `static_data`
--
LOCK TABLES `static_data` WRITE;
/*!40000 ALTER TABLE `static_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `static_data` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `status`
--
DROP TABLE IF EXISTS `status`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `status` (
`id` int NOT NULL AUTO_INCREMENT,
`status_name` varchar(100) NOT NULL,
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
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 `status`
--
LOCK TABLES `status` WRITE;
/*!40000 ALTER TABLE `status` DISABLE KEYS */;
INSERT INTO `status` VALUES (1,'NEW','2024-04-22 12:02:39.160154','2024-04-22 12:02:39.160154',0,0),(2,'Follow up','2024-04-22 12:02:39.190490','2024-04-24 17:41:56.685497',0,0),(3,'Intrested','2024-04-22 12:02:39.192001','2024-04-22 12:02:39.192001',0,0),(4,'Not Intrested','2024-04-22 12:02:39.192612','2024-04-24 17:41:56.714272',0,0);
/*!40000 ALTER TABLE `status` 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,
`name` varchar(255) NOT NULL,
`mobile_no` varchar(255) NOT NULL,
`is_deleted` tinyint NOT NULL DEFAULT '0',
`email` varchar(255) NOT NULL,
`password` varchar(60) DEFAULT NULL,
`created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
`created_by` int NOT NULL DEFAULT '0',
`updated_by` int NOT NULL DEFAULT '0',
`status` int NOT NULL DEFAULT '1',
`fcm_token` varchar(255) DEFAULT NULL,
`access_token` longtext,
`refresh_token` longtext,
`role_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_a2cecd1a3531c0b041e29ba46e1` (`role_id`),
CONSTRAINT `FK_a2cecd1a3531c0b041e29ba46e1` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_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 (9,'Admin','6374834625',0,'kQ5kGEc5lY8N/GP4IY+b4w==','dCR4bNL7u/vtuR0v1m7zyA==','2025-08-13 07:26:45.814707','2026-03-27 10:28:07.000000',0,0,1,'f1_dIHvM2kopTnzQkCt58v:APA91bFTrY5XXKsz5zMMDWrw4KHwX5nGylBnd3rZ3_gHyk0XN9YTv8_-hYqQFszaIED6voTBedG657bJFiqTce8nYrq2__LHvo9vHa2fLFYCTy7BmtaZ9Is','yGbPI4BnxBS3yQy/TsUFbNpoAM6zsFfDJYBpUHNACfOf9MPD6FBkCjx65UUx9WH8IbKp7YDiQTyQvICaODc67azDVnTzrZPHeyUft3FQsHq64grsfoJ0qpZi66zXxJ9QXNQCzh0aMSSEasDl6spaTpx9CdR/MBe/qBLr29AiGab83UxZW5PUbhyFGv5F+8qEAO5lR+DYlmvYqMZE3zp0UzDSIgCgmoc18FtQnW12gX1VN5L+6MZniG3yvoJMpg9q9P8OqryC+Vpbnd3bQ4OCBzu1od/EWbneVxhwHkjIF8keO/YVxnoCVEVGBNIySlD5FvBTl+zs/lXluf4RPr40qC7KY0xDDY73/vQUF442KRIefjvgdhveJPOv3YP5Xz/pBm3H3rK8Djo73+WK3ng/jAEPtsVt3bfywVsp0J5xxbWRUArmdRsztYzTiO/WqbDi','yGbPI4BnxBS3yQy/TsUFbNpoAM6zsFfDJYBpUHNACfOf9MPD6FBkCjx65UUx9WH8IbKp7YDiQTyQvICaODc67azDVnTzrZPHeyUft3FQsHq64grsfoJ0qpZi66zXxJ9QXNQCzh0aMSSEasDl6spaTpx9CdR/MBe/qBLr29AiGab83UxZW5PUbhyFGv5F+8qEAO5lR+DYlmvYqMZE3zp0UzDSIgCgmoc18FtQnW12gX1VN5L+6MZniG3yvoJMpg9q9P8OqryC+Vpbnd3bQ4OCBzu1od/EWbneVxhwHkjIF8keO/YVxnoCVEVGBNIySlD5FvBTl+zs/lXluf4RPr40qC7KY0xDDY73/vQUF442KRIefjvgdhveJPOv3YP5Xz/pBm3H3rK8Djo73+WK3ng/jAEPtsVt3bfywVsp0J5xxbWRUArmdRsztYzTiO/WqbDi',1);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2026-06-18 8:11:23
