-- MySQL dump 10.13  Distrib 26.7.0, for macos26.6 (arm64)
--
-- Host: localhost    Database: ptuerp
-- ------------------------------------------------------
-- Server version	26.7.0

/*!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 */;
SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
SET @@SESSION.SQL_LOG_BIN= 0;

--
-- GTID state at the beginning of the backup 
--

SET @@GLOBAL.GTID_PURGED=/*!80000 '+'*/ '696df3d2-b4b5-11f1-a4d1-685261f29b31:1-3381';

--
-- Table structure for table `academic_courses`
--

DROP TABLE IF EXISTS `academic_courses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `academic_courses` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `course_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `course_name` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `program_id` smallint DEFAULT NULL,
  `scheme` smallint unsigned DEFAULT NULL,
  `semester` tinyint unsigned DEFAULT NULL,
  `department` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `program_name` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `degree` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `specialization` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `option_type` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_internal` tinyint unsigned DEFAULT NULL,
  `internal_mm` smallint unsigned DEFAULT NULL,
  `is_external` tinyint unsigned DEFAULT NULL,
  `external_mm` smallint unsigned DEFAULT NULL,
  `credits` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `MCode` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `question_paper_id` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `academic_courses`
--

LOCK TABLES `academic_courses` WRITE;
/*!40000 ALTER TABLE `academic_courses` DISABLE KEYS */;
INSERT INTO `academic_courses` VALUES (1,'SBS-101D','Introduction to Shaheed Bhagat Singh & his co-patriots',2,2025,4,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,40,0,0,'0',NULL,NULL),(2,'BTAP-102D','Physics Lab',2,2025,1,'CSE',NULL,'B.Tech.',NULL,'Practical','Compulsory',1,30,1,20,'1',NULL,NULL),(3,'BTME-102D','Computer Graphics Lab',2,2025,1,'CSE',NULL,'B.Tech.',NULL,'Practical','Compulsory',1,30,1,20,'1',NULL,NULL),(4,'BTAC-102D','Chemistry Lab',2,2025,1,'CSE',NULL,'B.Tech.',NULL,'Practical','Compulsory',1,30,1,20,'1',NULL,NULL),(5,'BTEE-102D','Basics of Electrical and Electronics Engineering Lab',2,2025,1,'CSE',NULL,'B.Tech.',NULL,'Practical','Compulsory',1,30,1,20,'1',NULL,NULL),(6,'BTHU-102D','Communication Skills Lab',2,2025,1,'CSE',NULL,'B.Tech.',NULL,'Practical','Compulsory',1,30,1,20,'1',NULL,NULL),(7,'EVSC-101D','Environmental Sciences',2,2025,1,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,40,1,60,'2',NULL,NULL),(8,'HVPE-101D','Human Values and Professional Ethics',2,2025,1,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,40,1,60,'2',NULL,NULL),(9,'BTPS-102D','Programming for Problem Solving Lab',2,2025,1,'CSE',NULL,'B.Tech.',NULL,'Practical','Compulsory',1,30,1,20,'2',NULL,NULL),(10,'EMC-101D','Entrepreneurship-I (Setup and Launch)',2,2025,1,'CSE',NULL,'B.Tech.',NULL,'Practical','Compulsory',1,60,1,40,'2',NULL,NULL),(11,'BTPS-101D','Programming for Problem Solving',2,2025,1,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,40,1,60,'3',NULL,NULL),(12,'BTWP-101D','Workshop Practices-I',2,2025,1,'CSE',NULL,'B.Tech.',NULL,'Practical','Compulsory',1,60,1,40,'3',NULL,NULL),(13,'BTME-101D','Engineering Drawing',2,2025,1,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,60,1,40,'3',NULL,NULL),(14,'BTHU-101D','Communication Skills in English',2,2025,1,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,40,1,60,'3',NULL,NULL),(15,'BTAM-101D','Mathematics-I',2,2025,1,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,40,1,60,'4',NULL,NULL),(16,'BTAP-101D','Physics',2,2025,1,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,40,1,60,'4',NULL,NULL),(17,'BTAC-101D','Chemistry',2,2025,1,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,40,1,60,'4',NULL,NULL),(18,'BTEE-101D','Basics of Electrical and Electronics Engineering',2,2025,1,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,40,1,60,'4',NULL,NULL),(19,'BTAC-101D','Chemistry',2,2025,2,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,40,1,60,'4',NULL,NULL),(20,'BTAC-102D','Chemistry Lab',2,2025,2,'CSE',NULL,'B.Tech.',NULL,'Practical','Compulsory',1,30,1,20,'1',NULL,NULL),(21,'BTAM-201D','Mathematics-II',2,2025,2,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,40,1,60,'4',NULL,NULL),(22,'BTAP-101D','Physics',2,2025,2,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,40,1,60,'4',NULL,NULL),(23,'BTAP-102D','Physics Lab',2,2025,2,'CSE',NULL,'B.Tech.',NULL,'Practical','Compulsory',1,30,1,20,'1',NULL,NULL),(24,'BTEE-101D','Basics of Electrical and Electronics Engineering',2,2025,2,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,40,1,60,'4',NULL,NULL),(25,'BTEE-102D','Basics of Electrical and Electronics Engineering Lab',2,2025,2,'CSE',NULL,'B.Tech.',NULL,'Practical','Compulsory',1,30,1,20,'1',NULL,NULL),(26,'BTHU-101D','Communication Skills in English',2,2025,2,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,40,1,60,'3',NULL,NULL),(27,'BTHU-102D','Communication Skills Lab',2,2025,2,'CSE',NULL,'B.Tech.',NULL,'Practical','Compulsory',1,30,1,20,'1',NULL,NULL),(28,'BTME-101D','Engineering Drawing',2,2025,2,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,60,1,40,'3',NULL,NULL),(29,'BTME-102D','Computer Graphics Lab',2,2025,2,'CSE',NULL,'B.Tech.',NULL,'Practical','Compulsory',1,30,1,20,'1',NULL,NULL),(30,'BTPS-101D','Programming for Problem Solving',2,2025,2,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,40,1,60,'3',NULL,NULL),(31,'BTPS-102D','Programming for Problem Solving Lab',2,2025,2,'CSE',NULL,'B.Tech.',NULL,'Practical','Compulsory',1,30,1,20,'2',NULL,NULL),(32,'BTWP-201D','Workshop Practices-II',2,2025,2,'CSE',NULL,'B.Tech.',NULL,'Practical','Compulsory',1,60,1,40,'3',NULL,NULL),(33,'EMC-101D','Entrepreneurship-I (Setup and Launch)',2,2025,2,'CSE',NULL,'B.Tech.',NULL,'Practical','Compulsory',1,60,1,40,'2',NULL,NULL),(34,'EVSC-101D','Environmental Sciences',2,2025,2,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,40,1,60,'2',NULL,NULL),(35,'HVPE-101D','Human Values and Professional Ethics',2,2025,2,'CSE',NULL,'B.Tech.',NULL,'Theory','Compulsory',1,40,1,60,'2',NULL,NULL);
/*!40000 ALTER TABLE `academic_courses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `academic_students`
--

DROP TABLE IF EXISTS `academic_students`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `academic_students` (
  `id` int NOT NULL AUTO_INCREMENT,
  `roll_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `degree_id` smallint unsigned DEFAULT NULL,
  `program_id` smallint DEFAULT NULL,
  `batch` int DEFAULT NULL,
  `section` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sub_section` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scheme` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `abc_id` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_leet` tinyint unsigned DEFAULT NULL,
  `father_mobile` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother_mobile` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parents_email` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `annual_family_income` int DEFAULT NULL,
  `nationality` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state_quota` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `admission_counseling` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `admission_date` date DEFAULT NULL,
  `fee_category` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scholarship` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enrolment_id` int unsigned DEFAULT NULL,
  `percentage_matric` decimal(5,2) DEFAULT NULL,
  `percentage_plus2` decimal(5,2) DEFAULT NULL,
  `percentage_ug` decimal(5,2) DEFAULT NULL,
  `percentage_pg` decimal(5,2) DEFAULT NULL,
  `verified_by` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `verified_at` timestamp NULL DEFAULT NULL,
  `data_lock` tinyint(1) NOT NULL DEFAULT '0',
  `locked_at` timestamp NULL DEFAULT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `xfullname` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `xdegree` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `xDepartment` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `xstate` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `xclsGroup` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `xclassID` int DEFAULT NULL,
  `xWing` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `xdegreeID` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `userName` (`roll_number`),
  KEY `userName_2` (`roll_number`)
) ENGINE=InnoDB AUTO_INCREMENT=8967 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `academic_students`
--

LOCK TABLES `academic_students` WRITE;
/*!40000 ALTER TABLE `academic_students` DISABLE KEYS */;
INSERT INTO `academic_students` VALUES (1,'2516001',4,45,2025,'A','1','2025','663643240498',0,'9781360287','8727060287','arshdeepsinghkuldeepsingh449@gmail.com',100000,'Indian','85% Punjab State','Centralized Counselling (Round-1)','2025-06-12',NULL,'PMSS',NULL,96.46,92.60,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'2515038',2,37,2025,'A','1','2025','154151014921',0,'9463094922','8360139898',NULL,NULL,'Indian','85% Punjab State','Centralized Counselling (Round-1)','2025-06-12',NULL,'None',NULL,81.60,82.00,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `academic_students` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hrm_employees`
--

DROP TABLE IF EXISTS `hrm_employees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hrm_employees` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `qualification` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `highest_degree` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `designation` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `appointment` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `department` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `specialization` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `joing_date` date DEFAULT NULL,
  `past_experience` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `memberships` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marital_status` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `spouse_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pan_number` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_number` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ifsc_code` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upi_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `basic_pay` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hrm_employees`
--

LOCK TABLES `hrm_employees` WRITE;
/*!40000 ALTER TABLE `hrm_employees` DISABLE KEYS */;
INSERT INTO `hrm_employees` VALUES (2,'1002','Ph.D., M.E., B.Tech.','Doctoral','Teaching','Professor','Regular','ECE','Artificial Intelligence','2025-09-30',NULL,'FIETE, FIE','Married','','ANQPM7565H','',NULL,'','',0,NULL,NULL),(3,'1003','Ph.D., M.E., B.Tech.',NULL,'Ministerial','Deputy Registrar','Regular','HRM',NULL,NULL,NULL,NULL,'Married',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'1004','MA',NULL,'Support','Security Officer','Manpower','Security',NULL,NULL,NULL,NULL,'Married',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `hrm_employees` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hrm_leave_entitlements`
--

DROP TABLE IF EXISTS `hrm_leave_entitlements`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hrm_leave_entitlements` (
  `id` int NOT NULL AUTO_INCREMENT,
  `employee_id` int NOT NULL,
  `calendar_year` int DEFAULT NULL,
  `leave_type_id` tinyint unsigned DEFAULT NULL,
  `entry_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hrm_leave_entitlements`
--

LOCK TABLES `hrm_leave_entitlements` WRITE;
/*!40000 ALTER TABLE `hrm_leave_entitlements` DISABLE KEYS */;
INSERT INTO `hrm_leave_entitlements` VALUES (1,1002,2026,1,1002,'2026-09-11 12:41:07',NULL);
/*!40000 ALTER TABLE `hrm_leave_entitlements` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hrm_leave_records`
--

DROP TABLE IF EXISTS `hrm_leave_records`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hrm_leave_records` (
  `id` int NOT NULL AUTO_INCREMENT,
  `calendar_year` int unsigned NOT NULL,
  `employee_id` int unsigned NOT NULL,
  `leave_type_id` int unsigned NOT NULL,
  `leave_duration` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT 'Full-Day',
  `leave_from` timestamp NULL DEFAULT NULL,
  `leave_upto` timestamp NULL DEFAULT NULL,
  `station_leave_from` timestamp NULL DEFAULT NULL,
  `station_leave_upto` timestamp NULL DEFAULT NULL,
  `approved_by` int NOT NULL,
  `balance_leaves` smallint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `update_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hrm_leave_records`
--

LOCK TABLES `hrm_leave_records` WRITE;
/*!40000 ALTER TABLE `hrm_leave_records` DISABLE KEYS */;
INSERT INTO `hrm_leave_records` VALUES (1,2026,1002,1,'Full-Day','2026-09-11 03:30:00','2026-09-11 11:30:00','2026-09-10 11:30:00','2026-09-12 03:30:00',1002,19,'2026-09-11 03:30:00','2026-09-11 12:49:25');
/*!40000 ALTER TABLE `hrm_leave_records` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `master_dropdowns`
--

DROP TABLE IF EXISTS `master_dropdowns`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `master_dropdowns` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dropdown_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dropdown_option` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1486 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `master_dropdowns`
--

LOCK TABLES `master_dropdowns` WRITE;
/*!40000 ALTER TABLE `master_dropdowns` DISABLE KEYS */;
INSERT INTO `master_dropdowns` VALUES (1,'Streams','Non-Medical',NULL,NULL),(2,'Streams','Medical',NULL,NULL),(3,'Streams','Super-Medical',NULL,NULL),(4,'Streams','Vocational',NULL,NULL),(5,'Streams','Commerce',NULL,NULL),(6,'Streams','Arts',NULL,NULL),(7,'Streams','Diploma',NULL,NULL),(18,'States','AN',NULL,NULL),(19,'States','AP',NULL,NULL),(20,'States','AR',NULL,NULL),(21,'States','AS',NULL,NULL),(22,'States','BR',NULL,NULL),(23,'States','CG',NULL,NULL),(24,'States','CH',NULL,NULL),(25,'States','DD',NULL,NULL),(26,'States','DL',NULL,NULL),(27,'States','GA',NULL,NULL),(28,'States','GJ',NULL,NULL),(29,'States','HP',NULL,NULL),(30,'States','HR',NULL,NULL),(31,'States','JH',NULL,NULL),(32,'States','JK',NULL,NULL),(33,'States','KA',NULL,NULL),(34,'States','KL',NULL,NULL),(35,'States','LA',NULL,NULL),(36,'States','LD',NULL,NULL),(37,'States','MH',NULL,NULL),(38,'States','ML',NULL,NULL),(39,'States','MN',NULL,NULL),(40,'States','MP',NULL,NULL),(41,'States','MZ',NULL,NULL),(42,'States','NL',NULL,NULL),(43,'States','OD',NULL,NULL),(44,'States','PB',NULL,NULL),(45,'States','PY',NULL,NULL),(46,'States','RJ',NULL,NULL),(47,'States','SK',NULL,NULL),(48,'States','TN',NULL,NULL),(49,'States','TR',NULL,NULL),(50,'States','TS',NULL,NULL),(51,'States','UK',NULL,NULL),(52,'States','UP',NULL,NULL),(53,'States','WB',NULL,NULL),(54,'Districts','Adilabad',NULL,NULL),(55,'Districts','Agar Malwa',NULL,NULL),(56,'Districts','Agra',NULL,NULL),(57,'Districts','Ahmedabad',NULL,NULL),(58,'Districts','Ahmednagar',NULL,NULL),(59,'Districts','Aizawl',NULL,NULL),(60,'Districts','Ajmer',NULL,NULL),(61,'Districts','Akola',NULL,NULL),(62,'Districts','Alappuzha',NULL,NULL),(63,'Districts','Aligarh',NULL,NULL),(64,'Districts','Alipurduar',NULL,NULL),(65,'Districts','Alirajpur',NULL,NULL),(66,'Districts','Alluri Sitharama Raju',NULL,NULL),(67,'Districts','Almora',NULL,NULL),(68,'Districts','Alwar',NULL,NULL),(69,'Districts','Ambala',NULL,NULL),(70,'Districts','Ambedkar Nagar',NULL,NULL),(71,'Districts','Amethi',NULL,NULL),(72,'Districts','Amravati',NULL,NULL),(73,'Districts','Amreli',NULL,NULL),(74,'Districts','Amritsar',NULL,NULL),(75,'Districts','Amroha',NULL,NULL),(76,'Districts','Anakapalli',NULL,NULL),(77,'Districts','Anand',NULL,NULL),(78,'Districts','Ananthapuramu',NULL,NULL),(79,'Districts','Anantnag',NULL,NULL),(80,'Districts','Angul',NULL,NULL),(81,'Districts','Anjaw',NULL,NULL),(82,'Districts','Annamayya',NULL,NULL),(83,'Districts','Anuppur',NULL,NULL),(84,'Districts','Araria',NULL,NULL),(85,'Districts','Aravalli',NULL,NULL),(86,'Districts','Ariyalur',NULL,NULL),(87,'Districts','Arwal',NULL,NULL),(88,'Districts','Ashoknagar',NULL,NULL),(89,'Districts','Auraiya',NULL,NULL),(90,'Districts','Aurangabad',NULL,NULL),(91,'Districts','Ayodhya',NULL,NULL),(92,'Districts','Azamgarh',NULL,NULL),(93,'Districts','Bagalakote',NULL,NULL),(94,'Districts','Bageshwar',NULL,NULL),(95,'Districts','Bagpat',NULL,NULL),(96,'Districts','Bahraich',NULL,NULL),(97,'Districts','Bajali',NULL,NULL),(98,'Districts','Baksa',NULL,NULL),(99,'Districts','Balaghat',NULL,NULL),(100,'Districts','Balangir',NULL,NULL),(101,'Districts','Balasore',NULL,NULL),(102,'Districts','Ballari',NULL,NULL),(103,'Districts','Ballia',NULL,NULL),(104,'Districts','Balod',NULL,NULL),(105,'Districts','Baloda Bazar',NULL,NULL),(106,'Districts','Balrampur',NULL,NULL),(107,'Districts','Balrampur-Ramanujganj',NULL,NULL),(108,'Districts','Banaskantha',NULL,NULL),(109,'Districts','Banda',NULL,NULL),(110,'Districts','Bandipore',NULL,NULL),(111,'Districts','Banka',NULL,NULL),(112,'Districts','Bankura',NULL,NULL),(113,'Districts','Banswara',NULL,NULL),(114,'Districts','Bapatla',NULL,NULL),(115,'Districts','Barabanki',NULL,NULL),(116,'Districts','Baramulla',NULL,NULL),(117,'Districts','Baran',NULL,NULL),(118,'Districts','Bareilly',NULL,NULL),(119,'Districts','Bargarh (Baragarh)',NULL,NULL),(120,'Districts','Barmer',NULL,NULL),(121,'Districts','Barnala',NULL,NULL),(122,'Districts','Barpeta',NULL,NULL),(123,'Districts','Barwani',NULL,NULL),(124,'Districts','Bastar',NULL,NULL),(125,'Districts','Basti',NULL,NULL),(126,'Districts','Bathinda',NULL,NULL),(127,'Districts','Beed',NULL,NULL),(128,'Districts','Begusarai',NULL,NULL),(129,'Districts','Belagavi',NULL,NULL),(130,'Districts','Bemetara',NULL,NULL),(131,'Districts','Bengaluru Rural',NULL,NULL),(132,'Districts','Bengaluru Urban',NULL,NULL),(133,'Districts','Betul',NULL,NULL),(134,'Districts','Bhadohi',NULL,NULL),(135,'Districts','Bhadradri Kothagudem',NULL,NULL),(136,'Districts','Bhadrak',NULL,NULL),(137,'Districts','Bhagalpur',NULL,NULL),(138,'Districts','Bhandara',NULL,NULL),(139,'Districts','Bharatpur',NULL,NULL),(140,'Districts','Bharuch',NULL,NULL),(141,'Districts','Bhavnagar',NULL,NULL),(142,'Districts','Bhilwara',NULL,NULL),(143,'Districts','Bhind',NULL,NULL),(144,'Districts','Bhiwani',NULL,NULL),(145,'Districts','Bhojpur',NULL,NULL),(146,'Districts','Bhopal',NULL,NULL),(147,'Districts','Bidar',NULL,NULL),(148,'Districts','Bijapur',NULL,NULL),(149,'Districts','Bijnor',NULL,NULL),(150,'Districts','Bikaner',NULL,NULL),(151,'Districts','Bilaspur',NULL,NULL),(152,'Districts','Bilaspur',NULL,NULL),(153,'Districts','Birbhum',NULL,NULL),(154,'Districts','Bishnupur',NULL,NULL),(155,'Districts','Biswanath',NULL,NULL),(156,'Districts','Bokaro',NULL,NULL),(157,'Districts','Bongaigaon',NULL,NULL),(158,'Districts','Botad',NULL,NULL),(159,'Districts','Boudh (Bauda)',NULL,NULL),(160,'Districts','Budaun',NULL,NULL),(161,'Districts','Budgam',NULL,NULL),(162,'Districts','Bulandshahr',NULL,NULL),(163,'Districts','Buldhana',NULL,NULL),(164,'Districts','Bundi',NULL,NULL),(165,'Districts','Burhanpur',NULL,NULL),(166,'Districts','Buxar',NULL,NULL),(167,'Districts','Cachar',NULL,NULL),(168,'Districts','Central Delhi',NULL,NULL),(169,'Districts','Chamarajanagara',NULL,NULL),(170,'Districts','Chamba',NULL,NULL),(171,'Districts','Chamoli',NULL,NULL),(172,'Districts','Champawat',NULL,NULL),(173,'Districts','Champhai',NULL,NULL),(174,'Districts','Chandauli',NULL,NULL),(175,'Districts','Chandel',NULL,NULL),(176,'Districts','Chandigarh',NULL,NULL),(177,'Districts','Chandrapur',NULL,NULL),(178,'Districts','Changlang',NULL,NULL),(179,'Districts','Charaideo',NULL,NULL),(180,'Districts','Charkhi Dadri',NULL,NULL),(181,'Districts','Chatra',NULL,NULL),(182,'Districts','Chengalpattu',NULL,NULL),(183,'Districts','Chennai',NULL,NULL),(184,'Districts','Chhatarpur',NULL,NULL),(185,'Districts','Chhindwara',NULL,NULL),(186,'Districts','Chhota Udaipur',NULL,NULL),(187,'Districts','Chikkaballapura',NULL,NULL),(188,'Districts','Chikkamagaluru',NULL,NULL),(189,'Districts','Chirang',NULL,NULL),(190,'Districts','Chitradurga',NULL,NULL),(191,'Districts','Chitrakoot',NULL,NULL),(192,'Districts','Chittoor',NULL,NULL),(193,'Districts','Chittorgarh',NULL,NULL),(194,'Districts','Chümoukedima',NULL,NULL),(195,'Districts','Churachandpur',NULL,NULL),(196,'Districts','Churu',NULL,NULL),(197,'Districts','Coimbatore',NULL,NULL),(198,'Districts','Cooch Behar',NULL,NULL),(199,'Districts','Cuddalore',NULL,NULL),(200,'Districts','Cuttack',NULL,NULL),(201,'Districts','Dadra and Nagar Haveli',NULL,NULL),(202,'Districts','Dahod',NULL,NULL),(203,'Districts','Dakshin Dinajpur',NULL,NULL),(204,'Districts','Dakshina Kannada',NULL,NULL),(205,'Districts','Daman',NULL,NULL),(206,'Districts','Damoh',NULL,NULL),(207,'Districts','Dang',NULL,NULL),(208,'Districts','Dantewada',NULL,NULL),(209,'Districts','Darbhanga',NULL,NULL),(210,'Districts','Darjeeling',NULL,NULL),(211,'Districts','Darrang',NULL,NULL),(212,'Districts','Datia',NULL,NULL),(213,'Districts','Dausa',NULL,NULL),(214,'Districts','Davanagere',NULL,NULL),(215,'Districts','Debagarh (Deogarh)',NULL,NULL),(216,'Districts','Dehradun',NULL,NULL),(217,'Districts','Deoghar',NULL,NULL),(218,'Districts','Deoria',NULL,NULL),(219,'Districts','Devbhumi Dwarka',NULL,NULL),(220,'Districts','Dewas',NULL,NULL),(221,'Districts','Dhalai',NULL,NULL),(222,'Districts','Dhamtari',NULL,NULL),(223,'Districts','Dhanbad',NULL,NULL),(224,'Districts','Dhar',NULL,NULL),(225,'Districts','Dharashiv',NULL,NULL),(226,'Districts','Dharmapuri',NULL,NULL),(227,'Districts','Dharwada',NULL,NULL),(228,'Districts','Dhemaji',NULL,NULL),(229,'Districts','Dhenkanal',NULL,NULL),(230,'Districts','Dholpur',NULL,NULL),(231,'Districts','Dhubri',NULL,NULL),(232,'Districts','Dhule',NULL,NULL),(233,'Districts','Dibrugarh',NULL,NULL),(234,'Districts','Dima Hasao',NULL,NULL),(235,'Districts','Dimapur',NULL,NULL),(236,'Districts','Dindigul',NULL,NULL),(237,'Districts','Dindori',NULL,NULL),(238,'Districts','Diu',NULL,NULL),(239,'Districts','Doda',NULL,NULL),(240,'Districts','Dr. B.R. Ambedkar Konaseema',NULL,NULL),(241,'Districts','Dumka',NULL,NULL),(242,'Districts','Dungarpur',NULL,NULL),(243,'Districts','Durg',NULL,NULL),(244,'Districts','East Champaran',NULL,NULL),(245,'Districts','East Delhi',NULL,NULL),(246,'Districts','East Garo Hills',NULL,NULL),(247,'Districts','East Godavari',NULL,NULL),(248,'Districts','East Jaintia Hills',NULL,NULL),(249,'Districts','East Kameng',NULL,NULL),(250,'Districts','East Khasi Hills',NULL,NULL),(251,'Districts','East Siang',NULL,NULL),(252,'Districts','East Sikkim',NULL,NULL),(253,'Districts','East Singhbhum',NULL,NULL),(254,'Districts','Eastern West Khasi Hills',NULL,NULL),(255,'Districts','Eluru',NULL,NULL),(256,'Districts','Ernakulam',NULL,NULL),(257,'Districts','Erode',NULL,NULL),(258,'Districts','Etah',NULL,NULL),(259,'Districts','Etawah',NULL,NULL),(260,'Districts','Faridabad',NULL,NULL),(261,'Districts','Faridkot',NULL,NULL),(262,'Districts','Farrukhabad',NULL,NULL),(263,'Districts','Fatehabad',NULL,NULL),(264,'Districts','Fatehgarh Sahib',NULL,NULL),(265,'Districts','Fatehpur',NULL,NULL),(266,'Districts','Fazilka',NULL,NULL),(267,'Districts','Firozabad',NULL,NULL),(268,'Districts','Firozpur',NULL,NULL),(269,'Districts','Gadaga',NULL,NULL),(270,'Districts','Gadchiroli',NULL,NULL),(271,'Districts','Gajapati',NULL,NULL),(272,'Districts','Ganderbal',NULL,NULL),(273,'Districts','Gandhinagar',NULL,NULL),(274,'Districts','Ganjam',NULL,NULL),(275,'Districts','Garhwa',NULL,NULL),(276,'Districts','Gariaband',NULL,NULL),(277,'Districts','Gaurela-Pendra-Marwahi',NULL,NULL),(278,'Districts','Gautam Buddha Nagar',NULL,NULL),(279,'Districts','Gaya',NULL,NULL),(280,'Districts','Ghaziabad',NULL,NULL),(281,'Districts','Ghazipur',NULL,NULL),(282,'Districts','Gir Somnath',NULL,NULL),(283,'Districts','Giridih',NULL,NULL),(284,'Districts','Goalpara',NULL,NULL),(285,'Districts','Godda',NULL,NULL),(286,'Districts','Golaghat',NULL,NULL),(287,'Districts','Gomati',NULL,NULL),(288,'Districts','Gonda',NULL,NULL),(289,'Districts','Gondia',NULL,NULL),(290,'Districts','Gopalganj',NULL,NULL),(291,'Districts','Gorakhpur',NULL,NULL),(292,'Districts','Gumla',NULL,NULL),(293,'Districts','Guna',NULL,NULL),(294,'Districts','Guntur',NULL,NULL),(295,'Districts','Gurdaspur',NULL,NULL),(296,'Districts','Gurugram',NULL,NULL),(297,'Districts','Gwalior',NULL,NULL),(298,'Districts','Hailakandi',NULL,NULL),(299,'Districts','Hamirpur',NULL,NULL),(300,'Districts','Hamirpur',NULL,NULL),(301,'Districts','Hanamkonda',NULL,NULL),(302,'Districts','Hanumangarh',NULL,NULL),(303,'Districts','Hapur',NULL,NULL),(304,'Districts','Harda',NULL,NULL),(305,'Districts','Hardoi',NULL,NULL),(306,'Districts','Haridwar',NULL,NULL),(307,'Districts','Hassan',NULL,NULL),(308,'Districts','Hathras',NULL,NULL),(309,'Districts','Haveri',NULL,NULL),(310,'Districts','Hazaribag',NULL,NULL),(311,'Districts','Hingoli',NULL,NULL),(312,'Districts','Hisar',NULL,NULL),(313,'Districts','Hnahthial',NULL,NULL),(314,'Districts','Hojai',NULL,NULL),(315,'Districts','Hooghly',NULL,NULL),(316,'Districts','Hoshangabad',NULL,NULL),(317,'Districts','Hoshiarpur',NULL,NULL),(318,'Districts','Howrah',NULL,NULL),(319,'Districts','Hyderabad',NULL,NULL),(320,'Districts','Idukki',NULL,NULL),(321,'Districts','Imphal East',NULL,NULL),(322,'Districts','Imphal West',NULL,NULL),(323,'Districts','Indore',NULL,NULL),(324,'Districts','Itanagar capital complex',NULL,NULL),(325,'Districts','Jabalpur',NULL,NULL),(326,'Districts','Jagatsinghpur',NULL,NULL),(327,'Districts','Jagtial',NULL,NULL),(328,'Districts','Jaipur',NULL,NULL),(329,'Districts','Jaisalmer',NULL,NULL),(330,'Districts','Jajpur',NULL,NULL),(331,'Districts','Jalandhar',NULL,NULL),(332,'Districts','Jalaun',NULL,NULL),(333,'Districts','Jalgaon',NULL,NULL),(334,'Districts','Jalna',NULL,NULL),(335,'Districts','Jalore',NULL,NULL),(336,'Districts','Jalpaiguri',NULL,NULL),(337,'Districts','Jammu',NULL,NULL),(338,'Districts','Jamnagar',NULL,NULL),(339,'Districts','Jamtara',NULL,NULL),(340,'Districts','Jamui',NULL,NULL),(341,'Districts','Jangaon',NULL,NULL),(342,'Districts','Janjgir-Champa',NULL,NULL),(343,'Districts','Jashpur',NULL,NULL),(344,'Districts','Jaunpur',NULL,NULL),(345,'Districts','Jayashankar Bhupalpally',NULL,NULL),(346,'Districts','Jehanabad',NULL,NULL),(347,'Districts','Jhabua',NULL,NULL),(348,'Districts','Jhajjar',NULL,NULL),(349,'Districts','Jhalawar',NULL,NULL),(350,'Districts','Jhansi',NULL,NULL),(351,'Districts','Jhargram',NULL,NULL),(352,'Districts','Jharsuguda',NULL,NULL),(353,'Districts','Jhunjhunu',NULL,NULL),(354,'Districts','Jind',NULL,NULL),(355,'Districts','Jiribam',NULL,NULL),(356,'Districts','Jodhpur',NULL,NULL),(357,'Districts','Jogulamba Gadwal',NULL,NULL),(358,'Districts','Jorhat',NULL,NULL),(359,'Districts','Junagadh',NULL,NULL),(360,'Districts','Kabirdham',NULL,NULL),(361,'Districts','Kaimur',NULL,NULL),(362,'Districts','Kaithal',NULL,NULL),(363,'Districts','Kakching',NULL,NULL),(364,'Districts','Kakinada',NULL,NULL),(365,'Districts','Kalaburagi',NULL,NULL),(366,'Districts','Kalahandi',NULL,NULL),(367,'Districts','Kalimpong',NULL,NULL),(368,'Districts','Kallakurichi',NULL,NULL),(369,'Districts','Kamareddy',NULL,NULL),(370,'Districts','Kamjong',NULL,NULL),(371,'Districts','Kamle',NULL,NULL),(372,'Districts','Kamrup',NULL,NULL),(373,'Districts','Kamrup Metropolitan',NULL,NULL),(374,'Districts','Kanchipuram',NULL,NULL),(375,'Districts','Kandhamal',NULL,NULL),(376,'Districts','Kangpokpi',NULL,NULL),(377,'Districts','Kangra',NULL,NULL),(378,'Districts','Kanker',NULL,NULL),(379,'Districts','Kannauj',NULL,NULL),(380,'Districts','Kannur',NULL,NULL),(381,'Districts','Kanpur Dehat',NULL,NULL),(382,'Districts','Kanpur Nagar',NULL,NULL),(383,'Districts','Kanyakumari',NULL,NULL),(384,'Districts','Kapurthala',NULL,NULL),(385,'Districts','Karaikal',NULL,NULL),(386,'Districts','Karauli',NULL,NULL),(387,'Districts','Karbi Anglong',NULL,NULL),(388,'Districts','Kargil',NULL,NULL),(389,'Districts','Karimganj',NULL,NULL),(390,'Districts','Karimnagar',NULL,NULL),(391,'Districts','Karnal',NULL,NULL),(392,'Districts','Karur',NULL,NULL),(393,'Districts','Kasaragod',NULL,NULL),(394,'Districts','Kasganj',NULL,NULL),(395,'Districts','Kathua',NULL,NULL),(396,'Districts','Katihar',NULL,NULL),(397,'Districts','Katni',NULL,NULL),(398,'Districts','Kaushambi',NULL,NULL),(399,'Districts','Kendrapara',NULL,NULL),(400,'Districts','Kendujhar',NULL,NULL),(401,'Districts','Khagaria',NULL,NULL),(402,'Districts','Khairagarh-Chhuikhadan-Gandai',NULL,NULL),(403,'Districts','Khammam',NULL,NULL),(404,'Districts','Khandwa (East Nimar)',NULL,NULL),(405,'Districts','Khargone (West Nimar)',NULL,NULL),(406,'Districts','Khawzawl',NULL,NULL),(407,'Districts','Kheda',NULL,NULL),(408,'Districts','Khordha',NULL,NULL),(409,'Districts','Khowai',NULL,NULL),(410,'Districts','Khunti',NULL,NULL),(411,'Districts','Kinnaur',NULL,NULL),(412,'Districts','Kiphire',NULL,NULL),(413,'Districts','Kishanganj',NULL,NULL),(414,'Districts','Kishtwar',NULL,NULL),(415,'Districts','Kodagu',NULL,NULL),(416,'Districts','Koderma',NULL,NULL),(417,'Districts','Kohima',NULL,NULL),(418,'Districts','Kokrajhar',NULL,NULL),(419,'Districts','Kolar',NULL,NULL),(420,'Districts','Kolasib',NULL,NULL),(421,'Districts','Kolhapur',NULL,NULL),(422,'Districts','Kolkata',NULL,NULL),(423,'Districts','Kollam',NULL,NULL),(424,'Districts','Kondagaon',NULL,NULL),(425,'Districts','Koppala',NULL,NULL),(426,'Districts','Koraput',NULL,NULL),(427,'Districts','Korba',NULL,NULL),(428,'Districts','Korea',NULL,NULL),(429,'Districts','Kota',NULL,NULL),(430,'Districts','Kottayam',NULL,NULL),(431,'Districts','Kozhikode',NULL,NULL),(432,'Districts','Kra Daadi',NULL,NULL),(433,'Districts','Krishna',NULL,NULL),(434,'Districts','Krishnagiri',NULL,NULL),(435,'Districts','Kulgam',NULL,NULL),(436,'Districts','Kullu',NULL,NULL),(437,'Districts','Kumuram Bheem Asifabad',NULL,NULL),(438,'Districts','Kupwara',NULL,NULL),(439,'Districts','Kurnool',NULL,NULL),(440,'Districts','Kurukshetra',NULL,NULL),(441,'Districts','Kurung Kumey',NULL,NULL),(442,'Districts','Kushinagar',NULL,NULL),(443,'Districts','Kutch',NULL,NULL),(444,'Districts','Lahaul and Spiti',NULL,NULL),(445,'Districts','Lakhimpur',NULL,NULL),(446,'Districts','Lakhimpur Kheri',NULL,NULL),(447,'Districts','Lakhisarai',NULL,NULL),(448,'Districts','Lakshadweep',NULL,NULL),(449,'Districts','Lalitpur',NULL,NULL),(450,'Districts','Latehar',NULL,NULL),(451,'Districts','Latur',NULL,NULL),(452,'Districts','Lawngtlai',NULL,NULL),(453,'Districts','Leh',NULL,NULL),(454,'Districts','Lepa Rada',NULL,NULL),(455,'Districts','Lohardaga',NULL,NULL),(456,'Districts','Lohit',NULL,NULL),(457,'Districts','Longding',NULL,NULL),(458,'Districts','Longleng',NULL,NULL),(459,'Districts','Lower Dibang Valley',NULL,NULL),(460,'Districts','Lower Siang',NULL,NULL),(461,'Districts','Lower Subansiri',NULL,NULL),(462,'Districts','Lucknow',NULL,NULL),(463,'Districts','Ludhiana',NULL,NULL),(464,'Districts','Lunglei',NULL,NULL),(465,'Districts','Madhepura',NULL,NULL),(466,'Districts','Madhubani',NULL,NULL),(467,'Districts','Madurai',NULL,NULL),(468,'Districts','Mahabubabad',NULL,NULL),(469,'Districts','Maharajganj',NULL,NULL),(470,'Districts','Mahasamund',NULL,NULL),(471,'Districts','Mahbubnagar',NULL,NULL),(472,'Districts','Mahé',NULL,NULL),(473,'Districts','Mahendragarh',NULL,NULL),(474,'Districts','Mahisagar',NULL,NULL),(475,'Districts','Mahoba',NULL,NULL),(476,'Districts','Mainpuri',NULL,NULL),(477,'Districts','Majuli',NULL,NULL),(478,'Districts','Malappuram',NULL,NULL),(479,'Districts','Maldah',NULL,NULL),(480,'Districts','Malerkotla',NULL,NULL),(481,'Districts','Malkangiri',NULL,NULL),(482,'Districts','Mamit',NULL,NULL),(483,'Districts','Mancherial',NULL,NULL),(484,'Districts','Mandi',NULL,NULL),(485,'Districts','Mandla',NULL,NULL),(486,'Districts','Mandsaur',NULL,NULL),(487,'Districts','Mandya',NULL,NULL),(488,'Districts','Manendragarh-Chirmiri-Bharatpur',NULL,NULL),(489,'Districts','Mansa',NULL,NULL),(490,'Districts','Mathura',NULL,NULL),(491,'Districts','Mau',NULL,NULL),(492,'Districts','Mayiladuthurai',NULL,NULL),(493,'Districts','Mayurbhanj',NULL,NULL),(494,'Districts','Medak',NULL,NULL),(495,'Districts','Medchal–Malkajgiri',NULL,NULL),(496,'Districts','Meerut',NULL,NULL),(497,'Districts','Mehsana',NULL,NULL),(498,'Districts','Mirzapur',NULL,NULL),(499,'Districts','Moga',NULL,NULL),(500,'Districts','Mohla-Manpur-Chowki',NULL,NULL),(501,'Districts','Mokokchung',NULL,NULL),(502,'Districts','Mon',NULL,NULL),(503,'Districts','Moradabad',NULL,NULL),(504,'Districts','Morbi',NULL,NULL),(505,'Districts','Morena',NULL,NULL),(506,'Districts','Morigaon',NULL,NULL),(507,'Districts','Mulugu',NULL,NULL),(508,'Districts','Mumbai City',NULL,NULL),(509,'Districts','Mumbai Suburban',NULL,NULL),(510,'Districts','Mungeli',NULL,NULL),(511,'Districts','Munger',NULL,NULL),(512,'Districts','Murshidabad',NULL,NULL),(513,'Districts','Muzaffarnagar',NULL,NULL),(514,'Districts','Muzaffarpur',NULL,NULL),(515,'Districts','Mysuru',NULL,NULL),(516,'Districts','Nabarangpur',NULL,NULL),(517,'Districts','Nadia',NULL,NULL),(518,'Districts','Nagaon',NULL,NULL),(519,'Districts','Nagapattinam',NULL,NULL),(520,'Districts','Nagarkurnool',NULL,NULL),(521,'Districts','Nagaur',NULL,NULL),(522,'Districts','Nagpur',NULL,NULL),(523,'Districts','Nainital',NULL,NULL),(524,'Districts','Nalanda',NULL,NULL),(525,'Districts','Nalbari',NULL,NULL),(526,'Districts','Nalgonda',NULL,NULL),(527,'Districts','Namakkal',NULL,NULL),(528,'Districts','Namsai',NULL,NULL),(529,'Districts','Nanded',NULL,NULL),(530,'Districts','Nandurbar',NULL,NULL),(531,'Districts','Nandyal',NULL,NULL),(532,'Districts','Narayanpet',NULL,NULL),(533,'Districts','Narayanpur',NULL,NULL),(534,'Districts','Narmada',NULL,NULL),(535,'Districts','Narsinghpur',NULL,NULL),(536,'Districts','Nashik',NULL,NULL),(537,'Districts','Navsari',NULL,NULL),(538,'Districts','Nawada',NULL,NULL),(539,'Districts','Nayagarh',NULL,NULL),(540,'Districts','Neemuch',NULL,NULL),(541,'Districts','New Delhi',NULL,NULL),(542,'Districts','Nicobar',NULL,NULL),(543,'Districts','Nilgiris',NULL,NULL),(544,'Districts','Nirmal',NULL,NULL),(545,'Districts','Niuland',NULL,NULL),(546,'Districts','Niwari',NULL,NULL),(547,'Districts','Nizamabad',NULL,NULL),(548,'Districts','Noklak',NULL,NULL),(549,'Districts','Noney',NULL,NULL),(550,'Districts','North 24 Parganas',NULL,NULL),(551,'Districts','North and Middle Andaman',NULL,NULL),(552,'Districts','North Delhi',NULL,NULL),(553,'Districts','North East Delhi',NULL,NULL),(554,'Districts','North Garo Hills',NULL,NULL),(555,'Districts','North Goa',NULL,NULL),(556,'Districts','North Sikkim',NULL,NULL),(557,'Districts','North Tripura',NULL,NULL),(558,'Districts','North West Delhi',NULL,NULL),(559,'Districts','NTR',NULL,NULL),(560,'Districts','Nuapada',NULL,NULL),(561,'Districts','Nuh',NULL,NULL),(562,'Districts','Pakke-Kessang',NULL,NULL),(563,'Districts','Pakur',NULL,NULL),(564,'Districts','Pakyong',NULL,NULL),(565,'Districts','Palakkad',NULL,NULL),(566,'Districts','Palamu',NULL,NULL),(567,'Districts','Palghar',NULL,NULL),(568,'Districts','Pali',NULL,NULL),(569,'Districts','Palnadu',NULL,NULL),(570,'Districts','Palwal',NULL,NULL),(571,'Districts','Panchkula',NULL,NULL),(572,'Districts','Panchmahal',NULL,NULL),(573,'Districts','Panipat',NULL,NULL),(574,'Districts','Panna',NULL,NULL),(575,'Districts','Papum Pare',NULL,NULL),(576,'Districts','Parbhani',NULL,NULL),(577,'Districts','Parvathipuram Manyam',NULL,NULL),(578,'Districts','Paschim Bardhaman',NULL,NULL),(579,'Districts','Paschim Medinipur',NULL,NULL),(580,'Districts','Patan',NULL,NULL),(581,'Districts','Pathanamthitta',NULL,NULL),(582,'Districts','Pathankot',NULL,NULL),(583,'Districts','Patiala',NULL,NULL),(584,'Districts','Patna',NULL,NULL),(585,'Districts','Pauri Garhwal',NULL,NULL),(586,'Districts','Peddapalli',NULL,NULL),(587,'Districts','Perambalur',NULL,NULL),(588,'Districts','Peren',NULL,NULL),(589,'Districts','Phek',NULL,NULL),(590,'Districts','Pherzawl',NULL,NULL),(591,'Districts','Pilibhit',NULL,NULL),(592,'Districts','Pithoragarh',NULL,NULL),(593,'Districts','Poonch',NULL,NULL),(594,'Districts','Porbandar',NULL,NULL),(595,'Districts','Prakasam',NULL,NULL),(596,'Districts','Pratapgarh',NULL,NULL),(597,'Districts','Pratapgarh',NULL,NULL),(598,'Districts','Prayagraj',NULL,NULL),(599,'Districts','Puducherry',NULL,NULL),(600,'Districts','Pudukkottai',NULL,NULL),(601,'Districts','Pulwama',NULL,NULL),(602,'Districts','Pune',NULL,NULL),(603,'Districts','Purba Bardhaman',NULL,NULL),(604,'Districts','Purba Medinipur',NULL,NULL),(605,'Districts','Puri',NULL,NULL),(606,'Districts','Purnia',NULL,NULL),(607,'Districts','Purulia',NULL,NULL),(608,'Districts','Raebareli',NULL,NULL),(609,'Districts','Raichuru',NULL,NULL),(610,'Districts','Raigad',NULL,NULL),(611,'Districts','Raigarh',NULL,NULL),(612,'Districts','Raipur',NULL,NULL),(613,'Districts','Raisen',NULL,NULL),(614,'Districts','Rajanna Sircilla',NULL,NULL),(615,'Districts','Rajgarh',NULL,NULL),(616,'Districts','Rajkot',NULL,NULL),(617,'Districts','Rajnandgaon',NULL,NULL),(618,'Districts','Rajouri',NULL,NULL),(619,'Districts','Rajsamand',NULL,NULL),(620,'Districts','Ramanagara',NULL,NULL),(621,'Districts','Ramanathapuram',NULL,NULL),(622,'Districts','Ramban',NULL,NULL),(623,'Districts','Ramgarh',NULL,NULL),(624,'Districts','Rampur',NULL,NULL),(625,'Districts','Ranchi',NULL,NULL),(626,'Districts','Ranga Reddy',NULL,NULL),(627,'Districts','Ranipet',NULL,NULL),(628,'Districts','Ratlam',NULL,NULL),(629,'Districts','Ratnagiri',NULL,NULL),(630,'Districts','Rayagada',NULL,NULL),(631,'Districts','Reasi',NULL,NULL),(632,'Districts','Rewa',NULL,NULL),(633,'Districts','Rewari',NULL,NULL),(634,'Districts','Ri Bhoi',NULL,NULL),(635,'Districts','Rohtak',NULL,NULL),(636,'Districts','Rohtas',NULL,NULL),(637,'Districts','Rudraprayag',NULL,NULL),(638,'Districts','Rupnagar',NULL,NULL),(639,'Districts','Sabarkantha',NULL,NULL),(640,'Districts','Sagar',NULL,NULL),(641,'Districts','Saharanpur',NULL,NULL),(642,'Districts','Saharsa',NULL,NULL),(643,'Districts','Sahibganj',NULL,NULL),(644,'Districts','Sahibzada Ajit Singh Nagar',NULL,NULL),(645,'Districts','Saiha',NULL,NULL),(646,'Districts','Saitual',NULL,NULL),(647,'Districts','Salem',NULL,NULL),(648,'Districts','Samastipur',NULL,NULL),(649,'Districts','Samba',NULL,NULL),(650,'Districts','Sambalpur',NULL,NULL),(651,'Districts','Sambhajinagar',NULL,NULL),(652,'Districts','Sambhal',NULL,NULL),(653,'Districts','Sangareddy',NULL,NULL),(654,'Districts','Sangli',NULL,NULL),(655,'Districts','Sangrur',NULL,NULL),(656,'Districts','Sant Kabir Nagar',NULL,NULL),(657,'Districts','Saran',NULL,NULL),(658,'Districts','Sarangarh-Bilaigarh',NULL,NULL),(659,'Districts','Satara',NULL,NULL),(660,'Districts','Satna',NULL,NULL),(661,'Districts','Sawai Madhopur',NULL,NULL),(662,'Districts','Sehore',NULL,NULL),(663,'Districts','Senapati',NULL,NULL),(664,'Districts','Seoni',NULL,NULL),(665,'Districts','Sepahijala',NULL,NULL),(666,'Districts','Seraikela-Kharsawan',NULL,NULL),(667,'Districts','Serchhip',NULL,NULL),(668,'Districts','Shahdara district',NULL,NULL),(669,'Districts','Shahdol',NULL,NULL),(670,'Districts','Shahid Bhagat Singh Nagar',NULL,NULL),(671,'Districts','Shahjahanpur',NULL,NULL),(672,'Districts','Shajapur',NULL,NULL),(673,'Districts','Shakti',NULL,NULL),(674,'Districts','Shamator',NULL,NULL),(675,'Districts','Shamli',NULL,NULL),(676,'Districts','Sheikhpura',NULL,NULL),(677,'Districts','Sheohar',NULL,NULL),(678,'Districts','Sheopur',NULL,NULL),(679,'Districts','Shi Yomi',NULL,NULL),(680,'Districts','Shimla',NULL,NULL),(681,'Districts','Shivamogga',NULL,NULL),(682,'Districts','Shivpuri',NULL,NULL),(683,'Districts','Shopian',NULL,NULL),(684,'Districts','Shravasti',NULL,NULL),(685,'Districts','Siang',NULL,NULL),(686,'Districts','Siddharthnagar',NULL,NULL),(687,'Districts','Siddipet',NULL,NULL),(688,'Districts','Sidhi',NULL,NULL),(689,'Districts','Sikar',NULL,NULL),(690,'Districts','Simdega',NULL,NULL),(691,'Districts','Sindhudurg',NULL,NULL),(692,'Districts','Singrauli',NULL,NULL),(693,'Districts','Sirmaur',NULL,NULL),(694,'Districts','Sirohi',NULL,NULL),(695,'Districts','Sirsa',NULL,NULL),(696,'Districts','Sitamarhi',NULL,NULL),(697,'Districts','Sitapur',NULL,NULL),(698,'Districts','Sivaganga',NULL,NULL),(699,'Districts','Sivasagar',NULL,NULL),(700,'Districts','Siwan',NULL,NULL),(701,'Districts','Solan',NULL,NULL),(702,'Districts','Solapur',NULL,NULL),(703,'Districts','Sonbhadra',NULL,NULL),(704,'Districts','Sonipat',NULL,NULL),(705,'Districts','Sonitpur',NULL,NULL),(706,'Districts','Soreng',NULL,NULL),(707,'Districts','South 24 Parganas',NULL,NULL),(708,'Districts','South Andaman',NULL,NULL),(709,'Districts','South Delhi',NULL,NULL),(710,'Districts','South East Delhi',NULL,NULL),(711,'Districts','South Garo Hills',NULL,NULL),(712,'Districts','South Goa',NULL,NULL),(713,'Districts','South Salmara Mankachar',NULL,NULL),(714,'Districts','South Sikkim',NULL,NULL),(715,'Districts','South Tripura',NULL,NULL),(716,'Districts','South West Delhi',NULL,NULL),(717,'Districts','South West Garo Hills',NULL,NULL),(718,'Districts','South West Khasi Hills',NULL,NULL),(719,'Districts','Sri Ganganagar',NULL,NULL),(720,'Districts','Sri Muktsar Sahib',NULL,NULL),(721,'Districts','Sri Potti Sriramulu Nellore',NULL,NULL),(722,'Districts','Sri Sathya Sai',NULL,NULL),(723,'Districts','Srikakulam',NULL,NULL),(724,'Districts','Srinagar',NULL,NULL),(725,'Districts','Subarnapur (Sonepur)',NULL,NULL),(726,'Districts','Sukma',NULL,NULL),(727,'Districts','Sultanpur',NULL,NULL),(728,'Districts','Sundargarh',NULL,NULL),(729,'Districts','Supaul',NULL,NULL),(730,'Districts','Surajpur',NULL,NULL),(731,'Districts','Surat',NULL,NULL),(732,'Districts','Surendranagar',NULL,NULL),(733,'Districts','Surguja',NULL,NULL),(734,'Districts','Suryapet',NULL,NULL),(735,'Districts','Tamenglong',NULL,NULL),(736,'Districts','Tamulpur',NULL,NULL),(737,'Districts','Tapi',NULL,NULL),(738,'Districts','Tarn Taran',NULL,NULL),(739,'Districts','Tawang',NULL,NULL),(740,'Districts','Tehri Garhwal',NULL,NULL),(741,'Districts','Tengnoupal',NULL,NULL),(742,'Districts','Tenkasi',NULL,NULL),(743,'Districts','Thane',NULL,NULL),(744,'Districts','Thanjavur',NULL,NULL),(745,'Districts','Theni',NULL,NULL),(746,'Districts','Thiruvananthapuram',NULL,NULL),(747,'Districts','Thoothukudi',NULL,NULL),(748,'Districts','Thoubal',NULL,NULL),(749,'Districts','Thrissur',NULL,NULL),(750,'Districts','Tikamgarh',NULL,NULL),(751,'Districts','Tinsukia',NULL,NULL),(752,'Districts','Tirap',NULL,NULL),(753,'Districts','Tiruchirappalli',NULL,NULL),(754,'Districts','Tirunelveli',NULL,NULL),(755,'Districts','Tirupati',NULL,NULL),(756,'Districts','Tirupattur',NULL,NULL),(757,'Districts','Tiruppur',NULL,NULL),(758,'Districts','Tiruvallur',NULL,NULL),(759,'Districts','Tiruvannamalai',NULL,NULL),(760,'Districts','Tiruvarur',NULL,NULL),(761,'Districts','Tonk',NULL,NULL),(762,'Districts','Tseminyü',NULL,NULL),(763,'Districts','Tuensang',NULL,NULL),(764,'Districts','Tumakuru',NULL,NULL),(765,'Districts','Udaipur',NULL,NULL),(766,'Districts','Udalguri',NULL,NULL),(767,'Districts','Udham Singh Nagar',NULL,NULL),(768,'Districts','Udhampur',NULL,NULL),(769,'Districts','Udupi',NULL,NULL),(770,'Districts','Ujjain',NULL,NULL),(771,'Districts','Ukhrul',NULL,NULL),(772,'Districts','Umaria',NULL,NULL),(773,'Districts','Una',NULL,NULL),(774,'Districts','Unakoti',NULL,NULL),(775,'Districts','Unnao',NULL,NULL),(776,'Districts','Upper Dibang Valley',NULL,NULL),(777,'Districts','Upper Siang',NULL,NULL),(778,'Districts','Upper Subansiri',NULL,NULL),(779,'Districts','Uttar Dinajpur',NULL,NULL),(780,'Districts','Uttara Kannada',NULL,NULL),(781,'Districts','Uttarkashi',NULL,NULL),(782,'Districts','Vadodara',NULL,NULL),(783,'Districts','Vaishali',NULL,NULL),(784,'Districts','Valsad',NULL,NULL),(785,'Districts','Varanasi',NULL,NULL),(786,'Districts','Vellore',NULL,NULL),(787,'Districts','Vidisha',NULL,NULL),(788,'Districts','Vijayanagara',NULL,NULL),(789,'Districts','Vijayapura',NULL,NULL),(790,'Districts','Vikarabad',NULL,NULL),(791,'Districts','Viluppuram',NULL,NULL),(792,'Districts','Virudhunagar',NULL,NULL),(793,'Districts','Visakhapatnam',NULL,NULL),(794,'Districts','Vizianagaram',NULL,NULL),(795,'Districts','Wanaparthy',NULL,NULL),(796,'Districts','Warangal',NULL,NULL),(797,'Districts','Wardha',NULL,NULL),(798,'Districts','Washim',NULL,NULL),(799,'Districts','Wayanad',NULL,NULL),(800,'Districts','West Champaran',NULL,NULL),(801,'Districts','West Delhi',NULL,NULL),(802,'Districts','West Garo Hills',NULL,NULL),(803,'Districts','West Godavari',NULL,NULL),(804,'Districts','West Jaintia Hills',NULL,NULL),(805,'Districts','West Kameng',NULL,NULL),(806,'Districts','West Karbi Anglong',NULL,NULL),(807,'Districts','West Khasi Hills',NULL,NULL),(808,'Districts','West Siang',NULL,NULL),(809,'Districts','West Sikkim',NULL,NULL),(810,'Districts','West Singhbhum',NULL,NULL),(811,'Districts','West Tripura',NULL,NULL),(812,'Districts','Wokha',NULL,NULL),(813,'Districts','Yadadri Bhuvanagiri',NULL,NULL),(814,'Districts','Yadgiri',NULL,NULL),(815,'Districts','Yamunanagar',NULL,NULL),(816,'Districts','Yanam',NULL,NULL),(817,'Districts','Yavatmal',NULL,NULL),(818,'Districts','YSR',NULL,NULL),(819,'Districts','Zunheboto',NULL,NULL),(820,'Genders','Female',NULL,NULL),(821,'Genders','Male',NULL,NULL),(822,'Genders','Others',NULL,NULL),(831,'Countries','AD',NULL,NULL),(832,'Countries','AE',NULL,NULL),(833,'Countries','AF',NULL,NULL),(834,'Countries','AG',NULL,NULL),(835,'Countries','AI',NULL,NULL),(836,'Countries','AL',NULL,NULL),(837,'Countries','AM',NULL,NULL),(838,'Countries','AO',NULL,NULL),(839,'Countries','AQ',NULL,NULL),(840,'Countries','AR',NULL,NULL),(841,'Countries','AS',NULL,NULL),(842,'Countries','AT',NULL,NULL),(843,'Countries','AU',NULL,NULL),(844,'Countries','AW',NULL,NULL),(845,'Countries','AX',NULL,NULL),(846,'Countries','AZ',NULL,NULL),(847,'Countries','BA',NULL,NULL),(848,'Countries','BB',NULL,NULL),(849,'Countries','BD',NULL,NULL),(850,'Countries','BE',NULL,NULL),(851,'Countries','BF',NULL,NULL),(852,'Countries','BG',NULL,NULL),(853,'Countries','BH',NULL,NULL),(854,'Countries','BI',NULL,NULL),(855,'Countries','BJ',NULL,NULL),(856,'Countries','BL',NULL,NULL),(857,'Countries','BM',NULL,NULL),(858,'Countries','BN',NULL,NULL),(859,'Countries','BO',NULL,NULL),(860,'Countries','BQ',NULL,NULL),(861,'Countries','BR',NULL,NULL),(862,'Countries','BS',NULL,NULL),(863,'Countries','BT',NULL,NULL),(864,'Countries','BV',NULL,NULL),(865,'Countries','BW',NULL,NULL),(866,'Countries','BY',NULL,NULL),(867,'Countries','BZ',NULL,NULL),(868,'Countries','CA',NULL,NULL),(869,'Countries','CC',NULL,NULL),(870,'Countries','CD',NULL,NULL),(871,'Countries','CF',NULL,NULL),(872,'Countries','CG',NULL,NULL),(873,'Countries','CH',NULL,NULL),(874,'Countries','CI',NULL,NULL),(875,'Countries','CK',NULL,NULL),(876,'Countries','CL',NULL,NULL),(877,'Countries','CM',NULL,NULL),(878,'Countries','CN',NULL,NULL),(879,'Countries','CO',NULL,NULL),(880,'Countries','CR',NULL,NULL),(881,'Countries','CU',NULL,NULL),(882,'Countries','CV',NULL,NULL),(883,'Countries','CW',NULL,NULL),(884,'Countries','CX',NULL,NULL),(885,'Countries','CY',NULL,NULL),(886,'Countries','CZ',NULL,NULL),(887,'Countries','DE',NULL,NULL),(888,'Countries','DJ',NULL,NULL),(889,'Countries','DK',NULL,NULL),(890,'Countries','DM',NULL,NULL),(891,'Countries','DO',NULL,NULL),(892,'Countries','DZ',NULL,NULL),(893,'Countries','EC',NULL,NULL),(894,'Countries','EE',NULL,NULL),(895,'Countries','EG',NULL,NULL),(896,'Countries','EH',NULL,NULL),(897,'Countries','ER',NULL,NULL),(898,'Countries','ES',NULL,NULL),(899,'Countries','ET',NULL,NULL),(900,'Countries','FI',NULL,NULL),(901,'Countries','FJ',NULL,NULL),(902,'Countries','FK',NULL,NULL),(903,'Countries','FM',NULL,NULL),(904,'Countries','FO',NULL,NULL),(905,'Countries','FR',NULL,NULL),(906,'Countries','GA',NULL,NULL),(907,'Countries','GB',NULL,NULL),(908,'Countries','GD',NULL,NULL),(909,'Countries','GE',NULL,NULL),(910,'Countries','GF',NULL,NULL),(911,'Countries','GG',NULL,NULL),(912,'Countries','GH',NULL,NULL),(913,'Countries','GI',NULL,NULL),(914,'Countries','GL',NULL,NULL),(915,'Countries','GM',NULL,NULL),(916,'Countries','GN',NULL,NULL),(917,'Countries','GP',NULL,NULL),(918,'Countries','GQ',NULL,NULL),(919,'Countries','GR',NULL,NULL),(920,'Countries','GS',NULL,NULL),(921,'Countries','GT',NULL,NULL),(922,'Countries','GU',NULL,NULL),(923,'Countries','GW',NULL,NULL),(924,'Countries','GY',NULL,NULL),(925,'Countries','HK',NULL,NULL),(926,'Countries','HM',NULL,NULL),(927,'Countries','HN',NULL,NULL),(928,'Countries','HR',NULL,NULL),(929,'Countries','HT',NULL,NULL),(930,'Countries','HU',NULL,NULL),(931,'Countries','ID',NULL,NULL),(932,'Countries','IE',NULL,NULL),(933,'Countries','IL',NULL,NULL),(934,'Countries','IM',NULL,NULL),(935,'Countries','IN',NULL,NULL),(936,'Countries','IO',NULL,NULL),(937,'Countries','IQ',NULL,NULL),(938,'Countries','IR',NULL,NULL),(939,'Countries','IS',NULL,NULL),(940,'Countries','IT',NULL,NULL),(941,'Countries','JE',NULL,NULL),(942,'Countries','JM',NULL,NULL),(943,'Countries','JO',NULL,NULL),(944,'Countries','JP',NULL,NULL),(945,'Countries','KE',NULL,NULL),(946,'Countries','KG',NULL,NULL),(947,'Countries','KH',NULL,NULL),(948,'Countries','KI',NULL,NULL),(949,'Countries','KM',NULL,NULL),(950,'Countries','KN',NULL,NULL),(951,'Countries','KP',NULL,NULL),(952,'Countries','KR',NULL,NULL),(953,'Countries','KW',NULL,NULL),(954,'Countries','KY',NULL,NULL),(955,'Countries','KZ',NULL,NULL),(956,'Countries','LA',NULL,NULL),(957,'Countries','LB',NULL,NULL),(958,'Countries','LC',NULL,NULL),(959,'Countries','LI',NULL,NULL),(960,'Countries','LK',NULL,NULL),(961,'Countries','LR',NULL,NULL),(962,'Countries','LS',NULL,NULL),(963,'Countries','LT',NULL,NULL),(964,'Countries','LU',NULL,NULL),(965,'Countries','LV',NULL,NULL),(966,'Countries','LY',NULL,NULL),(967,'Countries','MA',NULL,NULL),(968,'Countries','MC',NULL,NULL),(969,'Countries','MD',NULL,NULL),(970,'Countries','ME',NULL,NULL),(971,'Countries','MF',NULL,NULL),(972,'Countries','MG',NULL,NULL),(973,'Countries','MH',NULL,NULL),(974,'Countries','MK',NULL,NULL),(975,'Countries','ML',NULL,NULL),(976,'Countries','MM',NULL,NULL),(977,'Countries','MN',NULL,NULL),(978,'Countries','MO',NULL,NULL),(979,'Countries','MP',NULL,NULL),(980,'Countries','MQ',NULL,NULL),(981,'Countries','MR',NULL,NULL),(982,'Countries','MS',NULL,NULL),(983,'Countries','MT',NULL,NULL),(984,'Countries','MU',NULL,NULL),(985,'Countries','MV',NULL,NULL),(986,'Countries','MW',NULL,NULL),(987,'Countries','MX',NULL,NULL),(988,'Countries','MY',NULL,NULL),(989,'Countries','MZ',NULL,NULL),(990,'Countries','NA',NULL,NULL),(991,'Countries','NC',NULL,NULL),(992,'Countries','NE',NULL,NULL),(993,'Countries','NF',NULL,NULL),(994,'Countries','NG',NULL,NULL),(995,'Countries','NI',NULL,NULL),(996,'Countries','NL',NULL,NULL),(997,'Countries','NO',NULL,NULL),(998,'Countries','NP',NULL,NULL),(999,'Countries','NR',NULL,NULL),(1000,'Countries','NU',NULL,NULL),(1001,'Countries','NZ',NULL,NULL),(1002,'Countries','OM',NULL,NULL),(1003,'Countries','PA',NULL,NULL),(1004,'Countries','PE',NULL,NULL),(1005,'Countries','PF',NULL,NULL),(1006,'Countries','PG',NULL,NULL),(1007,'Countries','PH',NULL,NULL),(1008,'Countries','PK',NULL,NULL),(1009,'Countries','PL',NULL,NULL),(1010,'Countries','PM',NULL,NULL),(1011,'Countries','PN',NULL,NULL),(1012,'Countries','PR',NULL,NULL),(1013,'Countries','PS',NULL,NULL),(1014,'Countries','PT',NULL,NULL),(1015,'Countries','PW',NULL,NULL),(1016,'Countries','PY',NULL,NULL),(1017,'Countries','QA',NULL,NULL),(1018,'Countries','RE',NULL,NULL),(1019,'Countries','RO',NULL,NULL),(1020,'Countries','RS',NULL,NULL),(1021,'Countries','RU',NULL,NULL),(1022,'Countries','RW',NULL,NULL),(1023,'Countries','SA',NULL,NULL),(1024,'Countries','SB',NULL,NULL),(1025,'Countries','SC',NULL,NULL),(1026,'Countries','SD',NULL,NULL),(1027,'Countries','SE',NULL,NULL),(1028,'Countries','SG',NULL,NULL),(1029,'Countries','SH',NULL,NULL),(1030,'Countries','SI',NULL,NULL),(1031,'Countries','SJ',NULL,NULL),(1032,'Countries','SK',NULL,NULL),(1033,'Countries','SL',NULL,NULL),(1034,'Countries','SM',NULL,NULL),(1035,'Countries','SN',NULL,NULL),(1036,'Countries','SO',NULL,NULL),(1037,'Countries','SR',NULL,NULL),(1038,'Countries','SS',NULL,NULL),(1039,'Countries','ST',NULL,NULL),(1040,'Countries','SV',NULL,NULL),(1041,'Countries','SX',NULL,NULL),(1042,'Countries','SY',NULL,NULL),(1043,'Countries','SZ',NULL,NULL),(1044,'Countries','TC',NULL,NULL),(1045,'Countries','TD',NULL,NULL),(1046,'Countries','TF',NULL,NULL),(1047,'Countries','TG',NULL,NULL),(1048,'Countries','TH',NULL,NULL),(1049,'Countries','TJ',NULL,NULL),(1050,'Countries','TK',NULL,NULL),(1051,'Countries','TL',NULL,NULL),(1052,'Countries','TM',NULL,NULL),(1053,'Countries','TN',NULL,NULL),(1054,'Countries','TO',NULL,NULL),(1055,'Countries','TR',NULL,NULL),(1056,'Countries','TT',NULL,NULL),(1057,'Countries','TV',NULL,NULL),(1058,'Countries','TW',NULL,NULL),(1059,'Countries','TZ',NULL,NULL),(1060,'Countries','UA',NULL,NULL),(1061,'Countries','UG',NULL,NULL),(1062,'Countries','UM',NULL,NULL),(1063,'Countries','US',NULL,NULL),(1064,'Countries','UY',NULL,NULL),(1065,'Countries','UZ',NULL,NULL),(1066,'Countries','VA',NULL,NULL),(1067,'Countries','VC',NULL,NULL),(1068,'Countries','VE',NULL,NULL),(1069,'Countries','VG',NULL,NULL),(1070,'Countries','VI',NULL,NULL),(1071,'Countries','VN',NULL,NULL),(1072,'Countries','VU',NULL,NULL),(1073,'Countries','WF',NULL,NULL),(1074,'Countries','WS',NULL,NULL),(1075,'Countries','YE',NULL,NULL),(1076,'Countries','YT',NULL,NULL),(1077,'Countries','ZA',NULL,NULL),(1078,'Countries','ZM',NULL,NULL),(1079,'Countries','ZW',NULL,NULL),(1093,'Program Levels','PG Diploma',NULL,NULL),(1094,'Program Levels','Doctoral',NULL,NULL),(1104,'Program Levels','Ceritificate',NULL,NULL),(1105,'Program Levels','Diploma',NULL,NULL),(1106,'Program Levels','Undergraduate',NULL,NULL),(1107,'Program Levels','Postgraduate',NULL,NULL),(1114,'Nationalities','Indian',NULL,NULL),(1115,'State Quotas','85% Punjab State',NULL,NULL),(1116,'State Quotas','15% Other States',NULL,NULL),(1118,'Designations','Associate Professor',NULL,NULL),(1119,'Designations','Assistant Professor',NULL,NULL),(1120,'Designations','Visiting Professor',NULL,NULL),(1121,'Sections','A',NULL,NULL),(1122,'Sections','B',NULL,NULL),(1123,'Sections','A1',NULL,NULL),(1124,'Sections','A2',NULL,NULL),(1125,'Sections','B1',NULL,NULL),(1126,'Sections','B2',NULL,NULL),(1127,'Schemes','2020',NULL,NULL),(1128,'Schemes','2021',NULL,NULL),(1129,'Nationalities','Foreigner',NULL,NULL),(1134,'Departments','CA: Computer Applications',NULL,'2025-05-09 09:36:40'),(1135,'Departments','ECE: Electronics & Communication Engineering',NULL,'2025-05-09 09:37:14'),(1136,'Departments','CE: Civil Engineering',NULL,'2025-05-09 09:37:36'),(1137,'Departments','EE: Electrical Engineering',NULL,'2025-05-09 09:37:54'),(1138,'Departments','ME: Mechanical Engineering',NULL,'2025-05-09 09:38:11'),(1139,'Departments','CHE: Chemical Engineering',NULL,'2025-05-09 09:38:39'),(1140,'Departments','CHM: Chemistry',NULL,'2025-05-09 10:04:07'),(1141,'Martial Statuses','Single',NULL,NULL),(1142,'Martial Statuses','Married',NULL,NULL),(1143,'Martial Statuses','Divorced',NULL,NULL),(1144,'Martial Statuses','Widowed',NULL,NULL),(1145,'Martial Statuses','Separated',NULL,NULL),(1146,'Banks','State Bank of India',NULL,NULL),(1147,'Banks','Bank of Baroda',NULL,NULL),(1148,'Banks','Punjab National Bank',NULL,NULL),(1149,'Banks','Bank of India',NULL,NULL),(1150,'Banks','Union Bank of India',NULL,NULL),(1151,'Banks','Canara Bank',NULL,NULL),(1152,'Banks','Bank of Maharashtra',NULL,NULL),(1153,'Banks','Central Bank of India',NULL,NULL),(1154,'Banks','Indian Bank',NULL,NULL),(1155,'Banks','Indian Overseas Bank',NULL,NULL),(1156,'Banks','UCO Bank',NULL,NULL),(1157,'Banks','HDFC Bank',NULL,NULL),(1158,'Banks','ICICI Bank',NULL,NULL),(1159,'Banks','Axis Bank',NULL,NULL),(1160,'Banks','Kotak Mahindra Bank',NULL,NULL),(1161,'Banks','IDBI Bank',NULL,NULL),(1162,'Divisions','First',NULL,NULL),(1163,'Divisions','Second',NULL,NULL),(1164,'Divisions','Third',NULL,NULL),(1165,'Current Statuses','Completed',NULL,NULL),(1166,'Current Statuses','In-Progress',NULL,NULL),(1167,'Numbers 12345','0',NULL,NULL),(1168,'Numbers 12345','1',NULL,NULL),(1169,'Numbers 12345','2',NULL,NULL),(1170,'Numbers 12345','3',NULL,NULL),(1171,'Numbers 12345','4',NULL,NULL),(1172,'Numbers 12345','5',NULL,NULL),(1173,'Months','January',NULL,NULL),(1174,'Months','February',NULL,NULL),(1175,'Months','March',NULL,NULL),(1176,'Months','April',NULL,NULL),(1177,'Months','May',NULL,NULL),(1178,'Months','June',NULL,NULL),(1179,'Months','July',NULL,NULL),(1180,'Months','August',NULL,NULL),(1181,'Months','September',NULL,NULL),(1182,'Months','October',NULL,NULL),(1183,'Months','November',NULL,NULL),(1184,'Months','December',NULL,NULL),(1185,'Years 2000-2030','2000',NULL,NULL),(1186,'Years 2000-2030','2001',NULL,NULL),(1187,'Years 2000-2030','2002',NULL,NULL),(1188,'Years 2000-2030','2003',NULL,NULL),(1189,'Years 2000-2030','2004',NULL,NULL),(1190,'Years 2000-2030','2005',NULL,NULL),(1191,'Years 2000-2030','2006',NULL,NULL),(1192,'Years 2000-2030','2007',NULL,NULL),(1193,'Years 2000-2030','2008',NULL,NULL),(1194,'Years 2000-2030','2009',NULL,NULL),(1195,'Years 2000-2030','2010',NULL,NULL),(1196,'Years 2000-2030','2011',NULL,NULL),(1197,'Years 2000-2030','2012',NULL,NULL),(1198,'Years 2000-2030','2013',NULL,NULL),(1199,'Years 2000-2030','2014',NULL,NULL),(1200,'Years 2000-2030','2015',NULL,NULL),(1201,'Years 2000-2030','2016',NULL,NULL),(1202,'Years 2000-2030','2017',NULL,NULL),(1203,'Years 2000-2030','2018',NULL,NULL),(1204,'Years 2000-2030','2019',NULL,NULL),(1205,'Years 2000-2030','2020',NULL,NULL),(1206,'Years 2000-2030','2021',NULL,NULL),(1207,'Years 2000-2030','2022',NULL,NULL),(1208,'Years 2000-2030','2023',NULL,NULL),(1209,'Years 2000-2030','2024',NULL,NULL),(1210,'Years 2000-2030','2025',NULL,NULL),(1211,'Years 2000-2030','2026',NULL,NULL),(1212,'Years 2000-2030','2027',NULL,NULL),(1213,'Years 2000-2030','2028',NULL,NULL),(1214,'Years 2000-2030','2029',NULL,NULL),(1215,'Years 2000-2030','2030',NULL,NULL),(1216,'Event Types','International Conference',NULL,NULL),(1217,'Event Types','National Conference',NULL,NULL),(1218,'Event Types','Workshop',NULL,NULL),(1219,'Event Types','Faculty Development Program',NULL,NULL),(1220,'Event Levels','University Level',NULL,NULL),(1221,'Event Levels','State Level',NULL,NULL),(1222,'Event Levels','National Level',NULL,NULL),(1223,'Event Levels','International Level',NULL,NULL),(1224,'Patent Types','Utility Patent',NULL,NULL),(1225,'Patent Types','Design Patent',NULL,NULL),(1226,'Patent Types','Plant Patent',NULL,NULL),(1233,'Blood Groups','A-',NULL,NULL),(1234,'Blood Groups','A+',NULL,NULL),(1235,'Blood Groups','AB-',NULL,NULL),(1236,'Blood Groups','AB+',NULL,NULL),(1237,'Blood Groups','B-',NULL,NULL),(1238,'Blood Groups','B+',NULL,NULL),(1239,'Blood Groups','O-',NULL,NULL),(1240,'Blood Groups','O+',NULL,NULL),(1241,'Specializations','Agriculture',NULL,'2025-08-02 05:37:26'),(1242,'Specializations','Chemical Engineering',NULL,'2025-05-11 11:48:20'),(1243,'Specializations','Computer Science & Engineering',NULL,NULL),(1244,'Specializations','Electrical Engineering',NULL,NULL),(1245,'Specializations','Electronics & Communication Engineering',NULL,NULL),(1246,'Specializations','Electronics & Computer Science',NULL,NULL),(1247,'Specializations','Management',NULL,'2025-05-09 10:50:13'),(1248,'Specializations','Mechanical Engineering',NULL,NULL),(1249,'Appointments','Adhoc',NULL,NULL),(1250,'Appointments','Contractual',NULL,NULL),(1251,'Appointments','Guest Faculty',NULL,NULL),(1252,'Appointments','Regular',NULL,NULL),(1259,'Batches','2021',NULL,NULL),(1260,'Batches','2022',NULL,NULL),(1261,'Batches','2023',NULL,NULL),(1262,'Batches','2024',NULL,NULL),(1263,'Batches','2025',NULL,NULL),(1264,'Batches','2026',NULL,NULL),(1265,'Batches','2027',NULL,NULL),(1382,'Reservation Categories','Backward Area','2025-04-23 18:44:36','2025-04-23 18:45:20'),(1383,'Reservation Categories','Backward Class','2025-04-23 18:44:36','2025-04-23 18:45:20'),(1384,'Reservation Categories','Border Area','2025-04-23 18:44:36','2025-04-23 18:45:20'),(1385,'Reservation Categories','Defence & Ex-Service Person','2025-04-23 18:44:36','2025-04-23 18:45:20'),(1386,'Reservation Categories','Disabled Person - Blind','2025-04-23 18:44:36','2025-04-23 18:45:20'),(1387,'Reservation Categories','Disabled Person - Deaf & Dumb','2025-04-23 18:44:36','2025-04-23 18:45:21'),(1388,'Reservation Categories','Disabled Person - Handicapped','2025-04-23 18:44:36','2025-04-23 18:45:21'),(1389,'Reservation Categories','Freedom Fighter','2025-04-23 18:44:36','2025-04-23 18:45:21'),(1390,'Reservation Categories','General + Others','2025-04-23 18:44:36','2025-06-18 11:16:30'),(1391,'Reservation Categories','Para Military','2025-04-23 18:44:36','2025-04-23 18:45:21'),(1392,'Reservation Categories','Riots 1984','2025-04-23 18:44:36','2025-04-23 18:45:21'),(1393,'Reservation Categories','Scheduled Class','2025-04-23 18:44:36','2025-04-23 18:45:21'),(1394,'Reservation Categories','Scheduled Tribe','2025-04-23 18:44:36','2025-04-23 18:45:21'),(1395,'Reservation Categories','Single Girl Child','2025-04-23 18:44:36','2025-04-23 18:45:21'),(1396,'Reservation Categories','Sports Person','2025-04-23 18:44:36','2025-04-23 18:45:21'),(1397,'Reservation Categories','TSunami Affected','2025-04-23 18:44:36','2025-04-23 18:45:21'),(1399,'Caste Categories','Backward Class','2025-04-23 18:44:36','2025-04-23 18:45:20'),(1400,'Caste Categories','General','2025-04-23 18:44:36','2025-04-23 18:45:21'),(1401,'Caste Categories','Scheduled Class','2025-04-23 18:44:36','2025-04-23 18:45:21'),(1402,'Caste Categories','Scheduled Tribe','2025-04-23 18:44:36','2025-04-23 18:45:21'),(1403,'Departments','PHY: Physics',NULL,'2025-05-09 10:04:38'),(1404,'Specializations','Applied Physics',NULL,NULL),(1407,'Departments','MATH: Mathematics','2025-05-09 14:35:18','2025-05-09 10:05:11'),(1408,'Departments','ARCH: Architecture','2025-05-09 14:38:03','2025-05-09 10:06:11'),(1409,'Departments','CBS: Commerce & Business Studies','2025-05-09 14:42:35','2025-05-11 10:44:46'),(1410,'Departments','AGR: Agriculture','2025-05-09 15:00:39',NULL),(1411,'Departments','CSE: Computer Science & Engineering','2025-05-09 15:13:40',NULL),(1413,'Specializations','Computer Applications & Electronics','2025-05-09 16:05:25',NULL),(1414,'Specializations','Environmental Sciences','2025-05-09 16:08:36',NULL),(1415,'Specializations','Welding','2025-05-09 16:10:33',NULL),(1416,'Specializations','Transportation Engineering','2025-05-09 16:10:57',NULL),(1417,'Specializations','Refrigeration and Air Conditioning','2025-05-09 16:12:47',NULL),(1418,'Specializations','Physics','2025-05-09 16:16:34',NULL),(1419,'Specializations','Non-Medical','2025-05-09 16:16:54',NULL),(1420,'Specializations','Mathematics','2025-05-09 16:18:52',NULL),(1421,'Specializations','Interior Design','2025-05-09 16:20:32',NULL),(1422,'Specializations','Information Technology','2025-05-09 16:20:55',NULL),(1423,'Specializations','Food & Nutrition','2025-05-09 16:21:15',NULL),(1424,'Specializations','Environment Science  & Engineering','2025-05-09 16:22:29',NULL),(1425,'Specializations','Cyber Security & Forensics','2025-05-09 16:23:10',NULL),(1426,'Specializations','Computer Applications','2025-05-09 16:23:50',NULL),(1427,'Specializations','Civil Engineering','2025-05-09 16:24:12',NULL),(1428,'Specializations','Chemistry','2025-05-09 16:24:32',NULL),(1430,'Departments','ASH: Applied Science & Humanities','2025-05-11 16:28:34',NULL),(1432,'Specializations','in Focus Infrastructure','2025-05-11 17:14:03','2025-05-11 11:49:50'),(1433,'Specializations','Hotel Management & Catering Technology','2025-05-11 17:23:02',NULL),(1434,'Specializations','Web & Data Analytics','2025-05-11 17:23:38',NULL),(1435,'Specializations','Computer Science (AI & ML)','2025-05-11 17:24:05',NULL),(1437,'Specializations','Testing of Building Materials','2025-05-11 17:25:47',NULL),(1438,'Specializations','Business Management','2025-05-11 17:29:16',NULL),(1439,'Designations','Professor','2025-05-13 10:50:41',NULL),(1440,'Lecture Groups','A',NULL,NULL),(1441,'Lab Groups','1',NULL,NULL),(1442,'Lecture Groups','B','2025-05-13 17:10:06',NULL),(1443,'Lecture Groups','C','2025-05-13 17:10:19',NULL),(1444,'Lab Groups','2','2025-05-13 17:10:33',NULL),(1445,'Scholarships','PMSS',NULL,NULL),(1446,'Scholarships','SBSSS 15%',NULL,NULL),(1447,'Scholarships','SBSSS 25%',NULL,NULL),(1448,'Scholarships','CMSS 50%',NULL,NULL),(1449,'Scholarships','CMSS 100%',NULL,NULL),(1450,'Payment Modes','UPI',NULL,NULL),(1451,'Payment Modes','Credit Card',NULL,NULL),(1452,'Payment Modes','Debit Card',NULL,NULL),(1453,'Payment Modes','NetBanking',NULL,NULL),(1454,'Payment Modes','SBI-Collect',NULL,NULL),(1455,'Payment Modes','Cash',NULL,NULL),(1456,'Payment Modes','Bank',NULL,NULL),(1457,'Payment Modes','Loan Credit',NULL,NULL),(1458,'Payment Modes','PMSS Credit',NULL,NULL),(1459,'Designations','Department Clerk','2025-05-23 14:21:18',NULL),(1460,'Designations','Fee Clerk Accounts','2025-05-23 14:21:44',NULL),(1461,'Departments','ACT: Account section','2025-05-23 14:22:31',NULL),(1462,'Counsellings','Centralized Counselling (Round-1)',NULL,NULL),(1463,'Counsellings','Centralized Counselling (Round-2)',NULL,NULL),(1464,'Counsellings','Direct Counselling (Round-1)',NULL,NULL),(1466,'Counsellings','Daily Counsellings',NULL,'2025-07-17 04:37:40'),(1468,'Document Types','Notification',NULL,NULL),(1469,'Document Types','Student Form',NULL,NULL),(1470,'Document Types','Staff Form',NULL,NULL),(1471,'Document Types','Advertisement',NULL,NULL),(1472,'Document Types','Tender',NULL,NULL),(1473,'Hostel Rooms','Single-Seater',NULL,NULL),(1474,'Hostel Rooms','Double-Seater',NULL,NULL),(1475,'Hostel Rooms','Triple-Seater',NULL,NULL),(1476,'Scholarships','JKPMSSS','2025-08-01 04:28:38',NULL),(1477,'Scholarships','TFW',NULL,NULL),(1481,'Designations','Lab Assistant','2025-12-12 13:11:39',NULL),(1482,'Designations','Peon','2025-12-12 13:11:39',NULL),(1483,'Document Types','Important Standing',NULL,NULL),(1484,'Departments','ADMN: Administration','2026-02-26 12:40:24',NULL),(1485,'Specializations','Artificial Intelligence & Machine Learning','2026-06-04 10:11:57','2026-06-04 04:42:18');
/*!40000 ALTER TABLE `master_dropdowns` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `master_forms`
--

DROP TABLE IF EXISTS `master_forms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `master_forms` (
  `id` int NOT NULL AUTO_INCREMENT,
  `module_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `form_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `route` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `controller` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `controller_function` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `route_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint unsigned DEFAULT NULL,
  `working` tinyint(1) DEFAULT NULL,
  `is_visible` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `master_forms`
--

LOCK TABLES `master_forms` WRITE;
/*!40000 ALTER TABLE `master_forms` DISABLE KEYS */;
INSERT INTO `master_forms` VALUES (1,'Masters','Master Students','master-students','LocalAdminController','master_students','master.students','person-badge','danger',1,1,1,NULL,NULL);
/*!40000 ALTER TABLE `master_forms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `master_leave_types`
--

DROP TABLE IF EXISTS `master_leave_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `master_leave_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `leave_type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_name` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  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 `master_leave_types`
--

LOCK TABLES `master_leave_types` WRITE;
/*!40000 ALTER TABLE `master_leave_types` DISABLE KEYS */;
INSERT INTO `master_leave_types` VALUES (1,'Casual Leave','CL','2026-09-11 12:37:49','2026-09-11 12:38:56'),(2,'Earned Leave','EL','2026-09-11 12:37:49','2026-09-11 12:38:59'),(3,'Vacation Leave','VL','2026-09-11 12:37:49','2026-09-11 12:38:59'),(4,'Medical Leave','ML','2026-09-11 12:37:49','2026-09-11 12:38:59'),(5,'Academic Leave','AL','2026-09-11 12:37:49','2026-09-11 12:38:59');
/*!40000 ALTER TABLE `master_leave_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `master_privileges`
--

DROP TABLE IF EXISTS `master_privileges`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `master_privileges` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `role_id` int unsigned DEFAULT NULL,
  `username` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `form_id` int unsigned DEFAULT NULL,
  `sidebar` tinyint unsigned DEFAULT NULL,
  `is_active` tinyint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `master_privileges`
--

LOCK TABLES `master_privileges` WRITE;
/*!40000 ALTER TABLE `master_privileges` DISABLE KEYS */;
/*!40000 ALTER TABLE `master_privileges` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `master_roles`
--

DROP TABLE IF EXISTS `master_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `master_roles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `role_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `role_name` (`role_name`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `master_roles`
--

LOCK TABLES `master_roles` WRITE;
/*!40000 ALTER TABLE `master_roles` DISABLE KEYS */;
INSERT INTO `master_roles` VALUES (1,'Super Admin','Overall Super Admin',NULL,NULL),(2,'Local Admin','Institute Admin',NULL,NULL),(3,'Head','Head of Departments',NULL,NULL),(4,'Controller of Examinations','Controller of Examinations',NULL,NULL),(5,'Dean, Student Welfare','Dean Student Welfare',NULL,NULL),(6,'Vice-Chancellor','Vice-Chancellor',NULL,NULL),(7,'Clerk, Accounts','Fee Clerk will verify Payment Receipts',NULL,NULL),(8,'Coordinator, NAD','NAD Coordinator',NULL,NULL),(9,'Dy Controller (C)','Deputy Controller (Conduct)',NULL,NULL),(10,'Clerk','All Clerk',NULL,NULL),(11,'Student','All students',NULL,NULL),(12,'Guest','Without Login',NULL,NULL),(13,'Teacher','All Teacher',NULL,NULL),(14,'Registrar','Registrar',NULL,NULL),(15,'Dy Controller (R)','Deputy Controller (Results)',NULL,NULL),(16,'Dean, Academics','Dean Academic Affairs',NULL,NULL),(17,'Dy Controller (E)','Deputy Controller (Evaluation)',NULL,NULL),(18,'Clerk, NAD','Clerk, NAD',NULL,NULL),(19,'Coordinator, Printing Cell','Printing Cell Coordinator',NULL,NULL),(20,'Superintendent','Center Superintendent',NULL,NULL),(21,'Clerk, Dy Controller (R)','Clerk Deputy Controller (Results)',NULL,NULL),(22,'AdmissionSeeker','Admission Seeker',NULL,NULL),(23,'Dy Dean, Academics','Deputy Dean Academics','2025-05-30 08:16:29',NULL),(24,'Assistant Dean, Academics','Assistant Dean academics','2025-07-17 01:15:01',NULL),(25,'Finance Officer','Finance Officer','2025-08-07 09:15:00',NULL),(26,'Clerk, Printing Cell','Clerk Printing Cell','2025-12-12 07:39:05',NULL),(27,'Clerk, Dy Controller (E)','Clerk Deputy Controller (Evaluation)',NULL,NULL),(28,'Assistant Controller (R&E)','Assistant Controller (Results & Evaluation)',NULL,NULL);
/*!40000 ALTER TABLE `master_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `master_sessions`
--

DROP TABLE IF EXISTS `master_sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `master_sessions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sem_months` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exam_months` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exam_year` smallint unsigned DEFAULT NULL,
  `is_active` tinyint unsigned DEFAULT NULL,
  `disable_heads` tinyint unsigned DEFAULT NULL,
  `disable_students` tinyint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `master_sessions`
--

LOCK TABLES `master_sessions` WRITE;
/*!40000 ALTER TABLE `master_sessions` DISABLE KEYS */;
INSERT INTO `master_sessions` VALUES (1,'Jul-Dec','Nov-Dec',2026,0,0,0);
/*!40000 ALTER TABLE `master_sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `master_user_roles`
--

DROP TABLE IF EXISTS `master_user_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `master_user_roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role_id` tinyint unsigned DEFAULT NULL,
  `degree_id` tinyint unsigned DEFAULT NULL,
  `program_id` smallint DEFAULT NULL,
  `valid_upto` date DEFAULT NULL,
  `is_active` tinyint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8855 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `master_user_roles`
--

LOCK TABLES `master_user_roles` WRITE;
/*!40000 ALTER TABLE `master_user_roles` DISABLE KEYS */;
INSERT INTO `master_user_roles` VALUES (1,'1002',11,6,5,'2020-12-31',NULL,NULL,NULL);
/*!40000 ALTER TABLE `master_user_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `master_users`
--

DROP TABLE IF EXISTS `master_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `master_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_username` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `true_password` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `oneday_password` mediumint unsigned DEFAULT NULL,
  `oneday_password_at` timestamp NULL DEFAULT NULL,
  `password_changed_at` date DEFAULT NULL,
  `fullname` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `degree` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `father_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `aadhaar` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `blood_group` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `caste_category` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reservation_category` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alternate_mobile` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `face_photo` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signature` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city_village` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pin` int DEFAULT NULL,
  `district` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state_quota` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_role` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_role_id` int DEFAULT NULL,
  `current_program_id` tinyint unsigned DEFAULT NULL,
  `current_degree_id` tinyint DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `two_factor_secret` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `two_factor_recovery_codes` text COLLATE utf8mb4_unicode_ci,
  `two_factor_confirmed_at` timestamp NULL DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_login_at` timestamp NULL DEFAULT NULL,
  `api_token` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data_lock` tinyint(1) DEFAULT NULL,
  `locked_at` timestamp NULL DEFAULT NULL,
  `verified_by` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `custom_username` (`custom_username`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `master_users`
--

LOCK TABLES `master_users` WRITE;
/*!40000 ALTER TABLE `master_users` DISABLE KEYS */;
INSERT INTO `master_users` VALUES (1,'2516001',NULL,'12345',28681,'2026-09-09 18:30:20','2026-09-09','Arshdeep Singh','7973449413','B.Sc.','Male','Harnek Singh','Harjit Kaur','2008-08-07','650230565803','O+','Scheduled Class','Scheduled Class','arshdeepsinghkuldeepsingh449@gmail.com','7973449413','2516001.jpg','2516001_signature.jpg','Behak fattu','Makhu, zira',142044,'Ferozepur','PB',NULL,'85% Punjab State','Student',11,45,4,'$2y$12$JdVE0aEHVMpe1qeaBMrSkuUiDxeuqZc6p9c3bY4cOubA/jUjDuvxC',NULL,NULL,NULL,NULL,'2026-09-10 09:11:49',NULL,1,'2025-07-04 00:11:47','1463','2025-05-20 19:33:05','2026-09-09 18:31:28'),(2,'2515038',NULL,'12345',18160,'2026-06-11 09:12:30',NULL,'Harsh','9855327155','B.Com.(Hons)','Female','Kewal Krishan','Anuradha','2007-05-22','476673624215','B+','Scheduled Class','Scheduled Class','simrangill0802@gmail.com','8360139898','2515038.jpg','2515038_signature.jpg','near shani dev mandir,ward no 5, mamdot , distt ferozpur, near shani dev mandir,ward no 5, mamdot , distt ferozpur','Firozpur',152023,'Firozpur','PB',NULL,'85% Punjab State','Student',11,37,2,'$2y$12$JdVE0aEHVMpe1qeaBMrSkuUiDxeuqZc6p9c3bY4cOubA/jUjDuvxC',NULL,NULL,NULL,NULL,'2026-06-12 02:40:10',NULL,1,'2025-06-10 05:04:32','1366','2025-05-21 00:30:22','2026-05-04 09:17:54'),(3,'1002','satvir','12345',97813,'2026-09-11 11:03:53','2026-09-04','Dr Satvir Singh','8427680001',NULL,'Male','Abc','Xyz','1971-05-07',NULL,'A-','General',NULL,'DrSatvir.in@gmail.com','8427680001','1002_1786542359.jpg','1002_sig_1786320127.jpg','Nakodar Road, Malko','Jalandhar',152004,'','AN',NULL,NULL,'Dean, Academics',16,NULL,NULL,'$2y$12$JdVE0aEHVMpe1qeaBMrSkuUiDxeuqZc6p9c3bY4cOubA/jUjDuvxC',NULL,NULL,NULL,NULL,'2026-09-11 12:41:44',NULL,0,NULL,NULL,NULL,'2025-10-11 01:35:08'),(4,'1003',NULL,'12345',93442,'2026-09-09 15:47:03','2026-09-07','Dr Nitya','9779190066',NULL,'Male',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'coe@sbsstc.ac.in',NULL,NULL,'1003_signature.png',NULL,NULL,NULL,NULL,'PB',NULL,NULL,'Controller of Examinations',4,NULL,NULL,'$2y$12$JdVE0aEHVMpe1qeaBMrSkuUiDxeuqZc6p9c3bY4cOubA/jUjDuvxC',NULL,NULL,NULL,NULL,'2026-09-11 10:56:10','J11o8DZ8KDUtgU7nWPktJHwKs5I9rsb3mf5mqpULP9JTn3rVQ1opY9lnBXQ8',0,NULL,NULL,NULL,'2026-09-07 13:01:02'),(5,'1004',NULL,'12345',83271,'2025-12-03 04:39:19',NULL,'Mr Kashmir Singh','8288012013',NULL,'Male',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sbs.academics@gmail.com',NULL,NULL,'1004.png',NULL,NULL,NULL,NULL,'PB',NULL,NULL,'Teacher',13,NULL,NULL,'$2y$12$JdVE0aEHVMpe1qeaBMrSkuUiDxeuqZc6p9c3bY4cOubA/jUjDuvxC',NULL,NULL,NULL,NULL,'2025-12-03 07:44:13',NULL,0,NULL,NULL,NULL,'2025-11-10 09:48:19');
/*!40000 ALTER TABLE `master_users` ENABLE KEYS */;
UNLOCK TABLES;
SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;
/*!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-09-21 21:02:26