--
-- Host: localhost    Database: adiclasses_new
-- ------------------------------------------------------


--
-- Table structure for table `admin_login_types`
--

CREATE TABLE `admin_login_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `feature_name` varchar(255) DEFAULT NULL,
  `status` enum('1','0') NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin_login_types`
--

INSERT INTO `admin_login_types` VALUES (1,'Dashboard','1','2022-11-23 09:54:09','2022-11-23 09:54:09'),(2,'Video Upload','1','2022-11-23 09:54:09','2022-11-23 09:54:09'),(3,'Add Video Upload','1','2022-11-23 09:54:09','2022-11-23 09:54:09'),(4,'Login types','1','2022-11-23 09:54:09','2022-11-23 09:54:09'),(6,'District code','1','2022-11-23 09:54:09','2022-11-23 09:54:09'),(7,'Add District code','1','2022-11-23 09:54:09','2022-11-23 09:54:09'),(8,'Schools','1','2022-11-23 09:54:09','2022-11-23 09:54:09'),(9,'Add school','1','2022-11-23 09:54:09','2022-11-23 09:54:09'),(10,'School principals','1','2022-11-23 09:54:09','2022-11-23 09:54:09'),(11,'Add School principal','1','2022-11-23 09:54:09','2022-11-23 09:54:09'),(12,'School visit','1','2022-11-23 09:54:09','2022-11-23 09:54:09'),(13,'Add to school visit','1','2022-11-23 09:54:09','2022-11-23 09:54:09'),(14,'Marketing Executive','1','2022-11-23 09:54:09','2022-11-23 09:54:09'),(15,'Monitor','1','2022-11-23 09:54:09','2022-11-23 09:54:09'),(5,'Add Login types','1','2022-11-23 09:54:09','2022-11-23 09:54:09');

--
-- Table structure for table `assign_districts`
--

CREATE TABLE `assign_districts` (
  `id` int NOT NULL,
  `me_id` int DEFAULT NULL,
  `district_id` varchar(100) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `assign_districts`
--


--
-- Table structure for table `b_b_schools`
--

CREATE TABLE `b_b_schools` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `country_id` int NOT NULL,
  `state_id` int NOT NULL,
  `district_id` int NOT NULL,
  `district_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `b_b_schools`
--

INSERT INTO `b_b_schools` VALUES (1,101,17,591,'1010',0,'2022-09-19 07:30:11','2022-10-07 04:45:04'),(2,101,36,684,'1011',1,'2022-09-26 04:37:20','2022-10-07 04:46:06'),(3,101,36,575,'1003',1,'2022-10-07 04:40:59','2022-11-04 03:41:02'),(4,101,5,248,'3012',1,'2022-10-09 04:50:24','2022-10-09 04:50:24'),(5,101,18,634,'1101',1,'2022-11-02 06:03:47','2022-11-02 06:03:47'),(6,101,18,628,'1102',1,'2022-11-02 06:04:18','2022-11-02 06:04:18'),(7,101,18,623,'1103',1,'2022-11-02 06:05:04','2022-11-02 06:05:04'),(8,101,18,633,'1104',1,'2022-11-02 06:05:35','2022-11-02 06:05:35');

--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `user_type` enum('Reg','Not-Reg') NOT NULL,
  `qty` int NOT NULL,
  `product_id` int NOT NULL,
  `product_attr_id` int NOT NULL,
  `added_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `cart`
--


--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT 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;

--
-- Dumping data for table `categories`
--


--
-- Table structure for table `catproducts`
--

CREATE TABLE `catproducts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `brand` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_desc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `desc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `keywords` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `technical_specification` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `uses` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `warranty` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT 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;

--
-- Dumping data for table `catproducts`
--


--
-- Table structure for table `chapters`
--

CREATE TABLE `chapters` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `class_id` int NOT NULL,
  `subject_id` int NOT NULL,
  `chapter` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `chapter_order` int NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `chapters`
--

INSERT INTO `chapters` VALUES (9,8,32,'Motion',1,1,'2022-12-06 08:25:18','2022-12-18 05:21:01'),(10,8,32,'Force and Pressure',2,1,'2022-12-06 08:26:42','2022-12-18 05:22:12'),(11,8,32,'Friction',3,1,'2022-12-06 08:27:23','2022-12-13 16:04:15'),(12,8,32,'Sound',4,1,'2022-12-06 08:27:39','2022-12-06 08:27:39'),(13,8,33,'Materials : Metals and Non-Metals',1,1,'2022-12-06 08:29:05','2022-12-06 08:29:05'),(14,8,33,'Synthetic Fibres and Plastics',2,1,'2022-12-06 08:29:50','2022-12-06 08:32:33'),(15,8,33,'Coal and Petroleum',3,1,'2022-12-06 08:33:17','2022-12-06 08:33:17'),(16,8,34,'Rational Numbers',1,1,'2022-12-06 08:33:42','2022-12-06 08:33:42'),(17,8,34,'Linear Equations in One Variable',2,1,'2022-12-06 08:34:28','2022-12-06 08:34:28'),(18,8,35,'Crop Production and Management',1,1,'2022-12-06 08:35:16','2022-12-06 08:35:16'),(19,8,35,'Microoganisms, Friend and Foe',2,1,'2022-12-06 08:36:07','2022-12-06 08:36:07'),(20,9,36,'Basic Trigonometry and Vectors',1,1,'2022-12-06 08:42:33','2022-12-06 08:42:33'),(21,9,37,'Atoms and Molecules',1,1,'2022-12-06 08:43:19','2022-12-06 08:43:19'),(22,9,37,'Is Matter Around Us Pure',2,1,'2022-12-06 08:43:41','2022-12-06 08:43:41'),(23,9,38,'Number Systems',1,1,'2022-12-06 08:44:01','2022-12-06 08:44:01'),(24,9,38,'Polynomials',2,1,'2022-12-06 08:44:21','2022-12-06 08:44:21'),(25,9,39,'The Fundamental Unit of Life',1,1,'2022-12-06 08:44:43','2022-12-06 08:44:43'),(26,9,39,'Tissues',2,1,'2022-12-06 08:45:01','2022-12-06 08:45:01'),(27,10,40,'Light-Reflection',1,1,'2022-12-06 08:45:24','2022-12-06 08:45:24'),(28,10,40,'The Human Eye and the Colourful World',3,1,'2022-12-06 08:45:49','2022-12-06 08:45:49'),(29,10,41,'Chemical Reactions and Equations',1,1,'2022-12-06 08:46:08','2022-12-06 08:46:08'),(30,10,41,'Acids Bases and Salts',2,1,'2022-12-06 08:46:26','2022-12-06 08:46:26'),(31,10,42,'Real Numbers',1,1,'2022-12-06 08:46:45','2022-12-06 08:46:45'),(32,10,44,'Life Processes',1,1,'2022-12-06 08:47:22','2022-12-06 08:47:22'),(33,10,44,'Control and Coordination',2,1,'2022-12-06 08:47:40','2022-12-06 08:47:40'),(34,11,45,'Physical World',1,1,'2022-12-06 08:48:20','2022-12-06 08:48:20'),(35,11,45,'Units And Measurements',2,1,'2022-12-06 08:48:42','2022-12-06 08:48:42'),(36,11,46,'Some Basic Concept of Chemistry',1,1,'2022-12-06 08:49:01','2022-12-06 08:49:01'),(37,11,46,'Structure of Atom',2,1,'2022-12-06 08:49:19','2022-12-06 08:49:19'),(38,11,47,'Sets',1,1,'2022-12-06 08:49:39','2022-12-06 08:49:39'),(39,11,47,'Relations and Functions',2,1,'2022-12-06 08:49:57','2022-12-06 08:49:57'),(40,11,48,'The Living World',1,1,'2022-12-06 08:50:19','2022-12-06 08:50:19'),(41,11,48,'Biological Classification',2,1,'2022-12-06 08:50:37','2022-12-06 08:50:37'),(42,12,49,'Electric Charges and Fields',1,1,'2022-12-06 08:51:14','2022-12-06 08:51:14'),(43,12,50,'Solid State',1,1,'2022-12-06 08:51:33','2022-12-06 08:51:33'),(44,12,52,'Reproduction In Organisms',1,1,'2022-12-06 08:52:30','2022-12-06 08:52:30'),(45,12,51,'Relations and Function',1,1,'2022-12-06 08:54:47','2022-12-06 08:54:47'),(46,9,36,'Motion',2,1,'2022-12-06 14:52:34','2022-12-14 04:49:34'),(47,9,36,'Sound',3,1,'2022-12-14 04:51:52','2022-12-14 04:51:52');

--
-- Table structure for table `class_names`
--

CREATE TABLE `class_names` (
  `id` int NOT NULL AUTO_INCREMENT,
  `class_name` varchar(150) NOT NULL,
  `class_slug` varchar(150) NOT NULL,
  `class_order` int NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `class_names`
--

INSERT INTO `class_names` VALUES (8,'8th','8',8,1,'2022-12-12 06:25:44','2022-12-12 06:25:44'),(9,'9th','9',9,1,'2022-12-12 04:39:15','2022-12-12 04:39:15'),(10,'10th','10',10,1,'2022-12-12 04:39:24','2022-12-12 04:39:24'),(11,'11th','11',11,1,'2022-12-12 04:39:31','2022-12-12 04:39:31'),(12,'12th','12',12,1,'2022-12-12 06:26:05','2022-12-12 06:26:05');

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` int NOT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `contact_email` varchar(150) DEFAULT NULL,
  `contact_phone` varchar(50) DEFAULT NULL,
  `contact_message` varchar(150) DEFAULT NULL,
  `additional_details` varchar(225) DEFAULT NULL,
  `status` enum('1','0') DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `contacts`
--


--
-- Table structure for table `content_uploads`
--

CREATE TABLE `content_uploads` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `class_id` int NOT NULL,
  `subject_id` int NOT NULL,
  `chapter_order` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `chapter_id` int NOT NULL,
  `syllabus` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lession` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `full_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `level` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_html` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_folder` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `alternate_content_html` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `alternate_content_folder` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `content_uploads`
--

INSERT INTO `content_uploads` VALUES (55,8,32,'1',9,'xyz',NULL,'Motion Board','dfksdf sdmflf',NULL,'1','index.html','','upload/8th/Physics/Motion/Motion-Board','index.html','upload/8th/Physics/Motion/Motion-Board-alternate',1,'2022-12-12 04:41:44','2022-12-18 05:20:54'),(56,8,32,'3',10,'xyz',NULL,'Force and Pressure Foundation','fgggr',NULL,'3','index.html','','upload/8th/Physics/Force-and-Pressure/Force-and-Pressure-Foundation','index.html','upload/8th/Physics/Force-and-Pressure/Force-and-Pressure-Foundation-alternate',1,'2022-12-12 05:09:39','2022-12-12 05:09:39'),(57,8,32,'4',10,'xyz',NULL,'Force and Pressure Foundation Problems','Short Description','Long Description Long Description Long Description Long Description Long Description Long Description  Long Description','6','index.html','','upload/8th/Physics/Force-and-Pressure/Force-and-Pressure-Foundation-Problems','index.html','upload/8th/Physics/Force-and-Pressure/Force-and-Pressure-Foundation-Problems-alternate',1,'2022-12-12 05:15:35','2022-12-14 04:08:22'),(58,8,32,'2',10,'xyz',NULL,'Force and Pressure Board Problems','Short Description',NULL,'4','index.html','','upload/8th/Physics/Force-and-Pressure/Force-and-Pressure-Board-Problems','index.html','upload/8th/Physics/Force-and-Pressure/Force-and-Pressure-Board-Problems-alternate',1,'2022-12-12 05:18:51','2022-12-14 04:08:02'),(59,8,32,'1',10,'xyz',NULL,'Force and Pressure Board Theory',NULL,NULL,'1','index.html','','upload/8th/Physics/Force-and-Pressure/Force-and-Pressure-Board-Theory','index.html','upload/8th/Physics/Force-and-Pressure/Force-and-Pressure-Board-Theory-alternate',1,'2022-12-12 05:21:56','2022-12-12 05:35:59'),(60,8,32,'1',11,'xyz',NULL,'Theory','Short Description','Long Description','1','index.html','','upload/8th/Physics/Friction/Theory','index.html','upload/8th/Physics/Friction/Theory-alternate',1,'2022-12-14 04:17:07','2022-12-14 04:17:07'),(61,9,36,'1',20,'xyz',NULL,'Problems','Short Description','Short Description','6','index.html','','upload/9th/Physics/Basic-Trigonometry-and-Vectors/Problems','index.html','upload/9th/Physics/Basic-Trigonometry-and-Vectors/Problems-alternate',1,'2022-12-14 05:11:13','2022-12-14 05:11:13'),(62,9,36,'2',47,'xyz',NULL,'Problems1','Short Description','Short Description','4','index.html','','upload/9th/Physics/Sound/Problems1','index.html','upload/9th/Physics/Sound/Problems1-alternate',1,'2022-12-16 05:50:07','2022-12-16 05:50:07'),(63,9,36,'1',47,'xyz',NULL,'Theory1','Short Description','Short Description','1','index.html','','upload/9th/Physics/Sound/Theory1','index.html','upload/9th/Physics/Sound/Theory1-alternate',1,'2022-12-16 05:51:29','2022-12-16 05:51:29'),(64,9,36,'44',47,'ssss',NULL,'Theory','ssdfsfsdfsf s sd sf sd fs','sdfsdfs dfsdfsfsf','3','index.html','','upload/9th/Physics/Sound/Theory','index.html','upload/9th/Physics/Sound/Theory-alternate',1,'2022-12-19 08:24:40','2022-12-19 08:24:40'),(65,9,36,'22',47,'favico',NULL,'favico','favico favico','favico favico favico favico favico favico favico favico','1','index.html',NULL,'upload/9th/Physics/Sound/favico','index.html','upload/9th/Physics/Sound/favico-alternate',1,'2022-12-19 12:42:51','2022-12-19 12:42:51'),(66,9,36,'11',47,'gsdfsdfsdf',NULL,'sound','dsfssdf','asdasdas','2','index.html',NULL,'upload/9th/Physics/Sound/sound','index.html','upload/9th/Physics/Sound/sound-alternate',1,'2022-12-19 13:09:00','2022-12-19 13:09:00'),(67,9,36,'11',47,'sdff',NULL,'sound1','sfdsdfsdfd','sdfsdfsdf','1','index.html',NULL,'upload/9th/Physics/Sound/sound1','index.html','upload/9th/Physics/Sound/sound1-alternate',1,'2022-12-19 13:13:47','2022-12-19 13:13:47'),(68,10,40,'1',28,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html','5-X-The Human Eye and Colorful World.jpg','upload/10th/Physics/The-Human-Eye-and-the-Colourful-World/Theory','index.html','upload/10th/Physics/The-Human-Eye-and-the-Colourful-World/Theory-alternate',1,'2022-12-20 03:57:02','2022-12-20 03:57:02'),(69,10,40,'1',27,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html','4-Reflection of Light-Part-1-First Page.jpg','upload/10th/Physics/Light-Reflection/Theory','index.html','upload/10th/Physics/Light-Reflection/Theory-alternate',1,'2022-12-20 04:03:20','2022-12-20 04:03:20'),(70,10,42,'1',31,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html','1-X-Maths-REAL NUMBERS-First Page.jpg','upload/10th/Mathematics/Real-Numbers/Theory','index.html','upload/10th/Mathematics/Real-Numbers/Theory-alternate',1,'2022-12-20 04:07:42','2022-12-20 04:07:42'),(71,10,41,'1',29,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html','1-Periodic Classification of Elements-Part-1-First Page.jpg','upload/10th/Chemistry/Chemical-Reactions-and-Equations/Theory','index.html','upload/10th/Chemistry/Chemical-Reactions-and-Equations/Theory-alternate',1,'2022-12-20 04:09:30','2022-12-20 04:09:30'),(72,10,41,'1',30,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html','4-Acids, Bases and Salts-Part-1-First Page.jpg','upload/10th/Chemistry/Acids-Bases-and-Salts/Theory','index.html','upload/10th/Chemistry/Acids-Bases-and-Salts/Theory-alternate',1,'2022-12-20 04:11:09','2022-12-20 04:11:09'),(73,10,44,'1',32,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html','1-X-Biology-LIFE PROCESSES.jpg','upload/10th/Biology/Life-Processes/Theory','index.html','upload/10th/Biology/Life-Processes/Theory-alternate',1,'2022-12-20 04:12:21','2022-12-20 04:12:21'),(74,10,44,'1',33,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html','2-X-Biology-CONTROL AND COORDINATION.jpg','upload/10th/Biology/Control-and-Coordination/Theory','index.html','upload/10th/Biology/Control-and-Coordination/Theory-alternate',1,'2022-12-20 04:13:26','2022-12-20 04:13:26'),(75,10,44,'2',33,'xyz',NULL,'Theory1','Short Description','Short Description','3','index.html','2-X-Biology-CONTROL AND COORDINATION.jpg','upload/10th/Biology/Control-and-Coordination/Theory1','index.html','upload/10th/Biology/Control-and-Coordination/Theory1-alternate',1,'2022-12-20 04:15:19','2022-12-20 04:15:19'),(76,11,46,'1',36,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html',NULL,'upload/11th/Chemistry/Some-Basic-Concept-of-Chemistry/Theory','index.html','upload/11th/Chemistry/Some-Basic-Concept-of-Chemistry/Theory-alternate',1,'2022-12-21 04:06:04','2022-12-21 04:06:04'),(77,9,36,'4',46,'xyz',NULL,'Problems','Short Description','Short Description','6','index.html',NULL,'upload/9th/Physics/Motion/Problems','index.html','upload/9th/Physics/Motion/Problems-alternate',1,'2022-12-21 09:22:03','2022-12-21 09:22:03'),(78,9,36,'2',46,'xyz',NULL,'Problems1','Short Description','Short Description','4','index.html','1-Motion-Part-1-First Page.jpg','upload/9th/Physics/Motion/Problems1','index.html','upload/9th/Physics/Motion/Problems1-alternate',1,'2022-12-21 09:24:02','2022-12-21 09:24:02'),(79,8,33,'1',13,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html',NULL,'upload/8th/Chemistry/Materials-:-Metals-and-Non-Metals/Theory','index.html','upload/8th/Chemistry/Materials-:-Metals-and-Non-Metals/Theory-alternate',1,'2022-12-27 05:58:33','2022-12-27 05:58:33'),(80,8,33,'1',14,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html',NULL,'upload/8th/Chemistry/Synthetic-Fibres-and-Plastics/Theory','index.html','upload/8th/Chemistry/Synthetic-Fibres-and-Plastics/Theory-alternate',1,'2022-12-27 06:02:08','2022-12-27 06:02:08'),(81,8,33,'1',15,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html',NULL,'upload/8th/Chemistry/Coal-and-Petroleum/Theory','index.html','upload/8th/Chemistry/Coal-and-Petroleum/Theory-alternate',1,'2022-12-27 06:03:26','2022-12-27 06:03:26'),(82,8,34,'1',16,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html',NULL,'upload/8th/Mathematics/Rational-Numbers/Theory','index.html','upload/8th/Mathematics/Rational-Numbers/Theory-alternate',1,'2022-12-27 06:04:29','2022-12-27 06:04:29'),(83,8,34,'1',17,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html',NULL,'upload/8th/Mathematics/Linear-Equations-in-One-Variable/Theory','index.html','upload/8th/Mathematics/Linear-Equations-in-One-Variable/Theory-alternate',1,'2022-12-27 06:05:20','2022-12-27 06:05:20'),(84,8,35,'1',18,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html',NULL,'upload/8th/Biology/Crop-Production-and-Management/Theory','index.html','upload/8th/Biology/Crop-Production-and-Management/Theory-alternate',1,'2022-12-27 06:06:14','2022-12-27 06:06:14'),(85,8,35,'1',19,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html',NULL,'upload/8th/Biology/Microoganisms,-Friend-and-Foe/Theory','index.html','upload/8th/Biology/Microoganisms,-Friend-and-Foe/Theory-alternate',1,'2022-12-27 06:07:22','2022-12-27 06:07:22'),(86,11,47,'1',38,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html',NULL,'upload/11th/Mathematics/Sets/Theory','index.html','upload/11th/Mathematics/Sets/Theory-alternate',1,'2022-12-29 05:10:14','2022-12-29 05:10:14'),(87,11,45,'1',34,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html',NULL,'upload/11th/Physics/Physical-World/Theory','index.html','upload/11th/Physics/Physical-World/Theory-alternate',1,'2022-12-29 05:48:56','2022-12-29 05:48:56'),(88,9,39,'1',26,'xyz',NULL,'Theory','Short Description','Short Description','1','index.html',NULL,'upload/9th/Biology/Tissues/Theory','index.html','upload/9th/Biology/Tissues/Theory-alternate',1,'2022-12-29 05:50:54','2022-12-29 05:50:54'),(89,8,34,'1',16,'xyz',NULL,'Theory (Foundation)','Short Description','Short Description','3','index.html',NULL,'upload/8th/Mathematics/Rational-Numbers/Theory-(Foundation)','index.html','upload/8th/Mathematics/Rational-Numbers/Theory-(Foundation)-alternate',1,'2022-12-29 06:13:29','2022-12-29 06:13:29');

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sortname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=247 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1,'AF','Afghanistan',0,NULL,NULL),(2,'AL','Albania',0,NULL,NULL),(3,'DZ','Algeria',0,NULL,NULL),(4,'AS','American Samoa',0,NULL,NULL),(5,'AD','Andorra',0,NULL,NULL),(6,'AO','Angola',0,NULL,NULL),(7,'AI','Anguilla',0,NULL,NULL),(8,'AQ','Antarctica',0,NULL,NULL),(9,'AG','Antigua And Barbuda',0,NULL,NULL),(10,'AR','Argentina',0,NULL,NULL),(11,'AM','Armenia',0,NULL,NULL),(12,'AW','Aruba',0,NULL,NULL),(13,'AU','Australia',0,NULL,NULL),(14,'AT','Austria',0,NULL,NULL),(15,'AZ','Azerbaijan',0,NULL,NULL),(16,'BS','Bahamas The',0,NULL,NULL),(17,'BH','Bahrain',0,NULL,NULL),(18,'BD','Bangladesh',0,NULL,NULL),(19,'BB','Barbados',0,NULL,NULL),(20,'BY','Belarus',0,NULL,NULL),(21,'BE','Belgium',0,NULL,NULL),(22,'BZ','Belize',0,NULL,NULL),(23,'BJ','Benin',0,NULL,NULL),(24,'BM','Bermuda',0,NULL,NULL),(25,'BT','Bhutan',0,NULL,NULL),(26,'BO','Bolivia',0,NULL,NULL),(27,'BA','Bosnia and Herzegovina',0,NULL,NULL),(28,'BW','Botswana',0,NULL,NULL),(29,'BV','Bouvet Island',0,NULL,NULL),(30,'BR','Brazil',0,NULL,NULL),(31,'IO','British Indian Ocean Territory',0,NULL,NULL),(32,'BN','Brunei',0,NULL,NULL),(33,'BG','Bulgaria',0,NULL,NULL),(34,'BF','Burkina Faso',0,NULL,NULL),(35,'BI','Burundi',0,NULL,NULL),(36,'KH','Cambodia',0,NULL,NULL),(37,'CM','Cameroon',0,NULL,NULL),(38,'CA','Canada',0,NULL,NULL),(39,'CV','Cape Verde',0,NULL,NULL),(40,'KY','Cayman Islands',0,NULL,NULL),(41,'CF','Central African Republic',0,NULL,NULL),(42,'TD','Chad',0,NULL,NULL),(43,'CL','Chile',0,NULL,NULL),(44,'CN','China',0,NULL,NULL),(45,'CX','Christmas Island',0,NULL,NULL),(46,'CC','Cocos (Keeling) Islands',0,NULL,NULL),(47,'CO','Colombia',0,NULL,NULL),(48,'KM','Comoros',0,NULL,NULL),(49,'CG','Congo',0,NULL,NULL),(50,'CD','Congo The Democratic Republic Of The',0,NULL,NULL),(51,'CK','Cook Islands',0,NULL,NULL),(52,'CR','Costa Rica',0,NULL,NULL),(53,'CI','Cote D\'Ivoire (Ivory Coast)',0,NULL,NULL),(54,'HR','Croatia (Hrvatska)',0,NULL,NULL),(55,'CU','Cuba',0,NULL,NULL),(56,'CY','Cyprus',0,NULL,NULL),(57,'CZ','Czech Republic',0,NULL,NULL),(58,'DK','Denmark',0,NULL,NULL),(59,'DJ','Djibouti',0,NULL,NULL),(60,'DM','Dominica',0,NULL,NULL),(61,'DO','Dominican Republic',0,NULL,NULL),(62,'TP','East Timor',0,NULL,NULL),(63,'EC','Ecuador',0,NULL,NULL),(64,'EG','Egypt',0,NULL,NULL),(65,'SV','El Salvador',0,NULL,NULL),(66,'GQ','Equatorial Guinea',0,NULL,NULL),(67,'ER','Eritrea',0,NULL,NULL),(68,'EE','Estonia',0,NULL,NULL),(69,'ET','Ethiopia',0,NULL,NULL),(70,'XA','External Territories of Australia',0,NULL,NULL),(71,'FK','Falkland Islands',0,NULL,NULL),(72,'FO','Faroe Islands',0,NULL,NULL),(73,'FJ','Fiji Islands',0,NULL,NULL),(74,'FI','Finland',0,NULL,NULL),(75,'FR','France',0,NULL,NULL),(76,'GF','French Guiana',0,NULL,NULL),(77,'PF','French Polynesia',0,NULL,NULL),(78,'TF','French Southern Territories',0,NULL,NULL),(79,'GA','Gabon',0,NULL,NULL),(80,'GM','Gambia The',0,NULL,NULL),(81,'GE','Georgia',0,NULL,NULL),(82,'DE','Germany',0,NULL,NULL),(83,'GH','Ghana',0,NULL,NULL),(84,'GI','Gibraltar',0,NULL,NULL),(85,'GR','Greece',0,NULL,NULL),(86,'GL','Greenland',0,NULL,NULL),(87,'GD','Grenada',0,NULL,NULL),(88,'GP','Guadeloupe',0,NULL,NULL),(89,'GU','Guam',0,NULL,NULL),(90,'GT','Guatemala',0,NULL,NULL),(91,'XU','Guernsey and Alderney',0,NULL,NULL),(92,'GN','Guinea',0,NULL,NULL),(93,'GW','Guinea-Bissau',0,NULL,NULL),(94,'GY','Guyana',0,NULL,NULL),(95,'HT','Haiti',0,NULL,NULL),(96,'HM','Heard and McDonald Islands',0,NULL,NULL),(97,'HN','Honduras',0,NULL,NULL),(98,'HK','Hong Kong S.A.R.',0,NULL,NULL),(99,'HU','Hungary',0,NULL,NULL),(100,'IS','Iceland',0,NULL,NULL),(101,'IN','India',1,NULL,NULL),(102,'ID','Indonesia',0,NULL,NULL),(103,'IR','Iran',0,NULL,NULL),(104,'IQ','Iraq',0,NULL,NULL),(105,'IE','Ireland',0,NULL,NULL),(106,'IL','Israel',0,NULL,NULL),(107,'IT','Italy',0,NULL,NULL),(108,'JM','Jamaica',0,NULL,NULL),(109,'JP','Japan',0,NULL,NULL),(110,'XJ','Jersey',0,NULL,NULL),(111,'JO','Jordan',0,NULL,NULL),(112,'KZ','Kazakhstan',0,NULL,NULL),(113,'KE','Kenya',0,NULL,NULL),(114,'KI','Kiribati',0,NULL,NULL),(115,'KP','Korea North',0,NULL,NULL),(116,'KR','Korea South',0,NULL,NULL),(117,'KW','Kuwait',0,NULL,NULL),(118,'KG','Kyrgyzstan',0,NULL,NULL),(119,'LA','Laos',0,NULL,NULL),(120,'LV','Latvia',0,NULL,NULL),(121,'LB','Lebanon',0,NULL,NULL),(122,'LS','Lesotho',0,NULL,NULL),(123,'LR','Liberia',0,NULL,NULL),(124,'LY','Libya',0,NULL,NULL),(125,'LI','Liechtenstein',0,NULL,NULL),(126,'LT','Lithuania',0,NULL,NULL),(127,'LU','Luxembourg',0,NULL,NULL),(128,'MO','Macau S.A.R.',0,NULL,NULL),(129,'MK','Macedonia',0,NULL,NULL),(130,'MG','Madagascar',0,NULL,NULL),(131,'MW','Malawi',0,NULL,NULL),(132,'MY','Malaysia',0,NULL,NULL),(133,'MV','Maldives',0,NULL,NULL),(134,'ML','Mali',0,NULL,NULL),(135,'MT','Malta',0,NULL,NULL),(136,'XM','Man (Isle of)',0,NULL,NULL),(137,'MH','Marshall Islands',0,NULL,NULL),(138,'MQ','Martinique',0,NULL,NULL),(139,'MR','Mauritania',0,NULL,NULL),(140,'MU','Mauritius',0,NULL,NULL),(141,'YT','Mayotte',0,NULL,NULL),(142,'MX','Mexico',0,NULL,NULL),(143,'FM','Micronesia',0,NULL,NULL),(144,'MD','Moldova',0,NULL,NULL),(145,'MC','Monaco',0,NULL,NULL),(146,'MN','Mongolia',0,NULL,NULL),(147,'MS','Montserrat',0,NULL,NULL),(148,'MA','Morocco',0,NULL,NULL),(149,'MZ','Mozambique',0,NULL,NULL),(150,'MM','Myanmar',0,NULL,NULL),(151,'NA','Namibia',0,NULL,NULL),(152,'NR','Nauru',0,NULL,NULL),(153,'NP','Nepal',0,NULL,NULL),(154,'AN','Netherlands Antilles',0,NULL,NULL),(155,'NL','Netherlands The',0,NULL,NULL),(156,'NC','New Caledonia',0,NULL,NULL),(157,'NZ','New Zealand',0,NULL,NULL),(158,'NI','Nicaragua',0,NULL,NULL),(159,'NE','Niger',0,NULL,NULL),(160,'NG','Nigeria',0,NULL,NULL),(161,'NU','Niue',0,NULL,NULL),(162,'NF','Norfolk Island',0,NULL,NULL),(163,'MP','Northern Mariana Islands',0,NULL,NULL),(164,'NO','Norway',0,NULL,NULL),(165,'OM','Oman',0,NULL,NULL),(166,'PK','Pakistan',0,NULL,NULL),(167,'PW','Palau',0,NULL,NULL),(168,'PS','Palestinian Territory Occupied',0,NULL,NULL),(169,'PA','Panama',0,NULL,NULL),(170,'PG','Papua new Guinea',0,NULL,NULL),(171,'PY','Paraguay',0,NULL,NULL),(172,'PE','Peru',0,NULL,NULL),(173,'PH','Philippines',0,NULL,NULL),(174,'PN','Pitcairn Island',0,NULL,NULL),(175,'PL','Poland',0,NULL,NULL),(176,'PT','Portugal',0,NULL,NULL),(177,'PR','Puerto Rico',0,NULL,NULL),(178,'QA','Qatar',0,NULL,NULL),(179,'RE','Reunion',0,NULL,NULL),(180,'RO','Romania',0,NULL,NULL),(181,'RU','Russia',0,NULL,NULL),(182,'RW','Rwanda',0,NULL,NULL),(183,'SH','Saint Helena',0,NULL,NULL),(184,'KN','Saint Kitts And Nevis',0,NULL,NULL),(185,'LC','Saint Lucia',0,NULL,NULL),(186,'PM','Saint Pierre and Miquelon',0,NULL,NULL),(187,'VC','Saint Vincent And The Grenadines',0,NULL,NULL),(188,'WS','Samoa',0,NULL,NULL),(189,'SM','San Marino',0,NULL,NULL),(190,'ST','Sao Tome and Principe',0,NULL,NULL),(191,'SA','Saudi Arabia',0,NULL,NULL),(192,'SN','Senegal',0,NULL,NULL),(193,'RS','Serbia',0,NULL,NULL),(194,'SC','Seychelles',0,NULL,NULL),(195,'SL','Sierra Leone',0,NULL,NULL),(196,'SG','Singapore',0,NULL,NULL),(197,'SK','Slovakia',0,NULL,NULL),(198,'SI','Slovenia',0,NULL,NULL),(199,'XG','Smaller Territories of the UK',0,NULL,NULL),(200,'SB','Solomon Islands',0,NULL,NULL),(201,'SO','Somalia',0,NULL,NULL),(202,'ZA','South Africa',0,NULL,NULL),(203,'GS','South Georgia',0,NULL,NULL),(204,'SS','South Sudan',0,NULL,NULL),(205,'ES','Spain',0,NULL,NULL),(206,'LK','Sri Lanka',0,NULL,NULL),(207,'SD','Sudan',0,NULL,NULL),(208,'SR','Suriname',0,NULL,NULL),(209,'SJ','Svalbard And Jan Mayen Islands',0,NULL,NULL),(210,'SZ','Swaziland',0,NULL,NULL),(211,'SE','Sweden',0,NULL,NULL),(212,'CH','Switzerland',0,NULL,NULL),(213,'SY','Syria',0,NULL,NULL),(214,'TW','Taiwan',0,NULL,NULL),(215,'TJ','Tajikistan',0,NULL,NULL),(216,'TZ','Tanzania',0,NULL,NULL),(217,'TH','Thailand',0,NULL,NULL),(218,'TG','Togo',0,NULL,NULL),(219,'TK','Tokelau',0,NULL,NULL),(220,'TO','Tonga',0,NULL,NULL),(221,'TT','Trinidad And Tobago',0,NULL,NULL),(222,'TN','Tunisia',0,NULL,NULL),(223,'TR','Turkey',0,NULL,NULL),(224,'TM','Turkmenistan',0,NULL,NULL),(225,'TC','Turks And Caicos Islands',0,NULL,NULL),(226,'TV','Tuvalu',0,NULL,NULL),(227,'UG','Uganda',0,NULL,NULL),(228,'UA','Ukraine',0,NULL,NULL),(229,'AE','United Arab Emirates',0,NULL,NULL),(230,'GB','United Kingdom',0,NULL,NULL),(231,'US','United States',0,NULL,NULL),(232,'UM','United States Minor Outlying Islands',0,NULL,NULL),(233,'UY','Uruguay',0,NULL,NULL),(234,'UZ','Uzbekistan',0,NULL,NULL),(235,'VU','Vanuatu',0,NULL,NULL),(236,'VA','Vatican City State (Holy See)',0,NULL,NULL),(237,'VE','Venezuela',0,NULL,NULL),(238,'VN','Vietnam',0,NULL,NULL),(239,'VG','Virgin Islands (British)',0,NULL,NULL),(240,'VI','Virgin Islands (US)',0,NULL,NULL),(241,'WF','Wallis And Futuna Islands',0,NULL,NULL),(242,'EH','Western Sahara',0,NULL,NULL),(243,'YE','Yemen',0,NULL,NULL),(244,'YU','Yugoslavia',0,NULL,NULL),(245,'ZM','Zambia',0,NULL,NULL),(246,'ZW','Zimbabwe',0,NULL,NULL);

--
-- Table structure for table `districts`
--

CREATE TABLE `districts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `district_title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `district_description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `district_status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=685 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `districts`
--

INSERT INTO `districts` VALUES (36,'Anantnag','15','','Active',NULL,NULL),(37,'Bandipore','15','','Active',NULL,NULL),(38,'Baramulla','15','','Active',NULL,NULL),(39,'Budgam','15','','Active',NULL,NULL),(40,'Doda','15','','Active',NULL,NULL),(41,'Ganderbal','15','','Active',NULL,NULL),(42,'Jammu','15','','Active',NULL,NULL),(43,'Kargil','15','','Active',NULL,NULL),(44,'Kathua','15','','Active',NULL,NULL),(45,'Kishtwar','15','','Active',NULL,NULL),(46,'Kulgam','15','','Active',NULL,NULL),(47,'Kupwara','15','','Active',NULL,NULL),(48,'Leh (Ladakh)','15','','Active',NULL,NULL),(49,'Poonch','15','','Active',NULL,NULL),(50,'Pulwama','15','','Active',NULL,NULL),(51,'Rajouri','15','','Active',NULL,NULL),(52,'Ramban','15','','Active',NULL,NULL),(53,'Reasi','15','','Active',NULL,NULL),(54,'Samba','15','','Active',NULL,NULL),(55,'Shopian','15','','Active',NULL,NULL),(56,'Srinagar','15','','Active',NULL,NULL),(57,'Udhampur','15','','Active',NULL,NULL),(58,'Bilaspur (Himachal Pradesh)','14','','Active',NULL,NULL),(59,'Chamba','14','','Active',NULL,NULL),(60,'Hamirpur (Himachal Pradesh)','14','','Active',NULL,NULL),(61,'Kangra','14','','Active',NULL,NULL),(62,'Kinnaur','14','','Active',NULL,NULL),(63,'Kullu','14','','Active',NULL,NULL),(64,'Lahul & Spiti','14','','Active',NULL,NULL),(65,'Mandi','14','','Active',NULL,NULL),(66,'Shimla','14','','Active',NULL,NULL),(67,'Sirmaur','14','','Active',NULL,NULL),(68,'Solan','14','','Active',NULL,NULL),(69,'Una','14','','Active',NULL,NULL),(70,'Amritsar','28','','Active',NULL,NULL),(71,'Barnala','28','','Active',NULL,NULL),(72,'Bathinda','28','','Active',NULL,NULL),(73,'Faridkot','28','','Active',NULL,NULL),(74,'Fatehgarh Sahib','28','','Active',NULL,NULL),(75,'Firozpur','28','','Active',NULL,NULL),(76,'Gurdaspur','28','','Active',NULL,NULL),(77,'Hoshiarpur','28','','Active',NULL,NULL),(78,'Jalandhar','28','','Active',NULL,NULL),(79,'Kapurthala','28','','Active',NULL,NULL),(80,'Ludhiana','28','','Active',NULL,NULL),(81,'Mansa','28','','Active',NULL,NULL),(82,'Moga','28','','Active',NULL,NULL),(83,'Muktsar','28','','Active',NULL,NULL),(84,'Patiala','28','','Active',NULL,NULL),(85,'Rupnagar (Ropar)','28','','Active',NULL,NULL),(86,'Sahibzada Ajit Singh Nagar (Mohali)','28','','Active',NULL,NULL),(87,'Sangrur','28','','Active',NULL,NULL),(88,'Shahid Bhagat Singh Nagar (Nawanshahr)','28','','Active',NULL,NULL),(89,'Tarn Taran','28','','Active',NULL,NULL),(90,'Chandigarh','6','','Active',NULL,NULL),(91,'Almora','34','','Active',NULL,NULL),(92,'Bageshwar','34','','Active',NULL,NULL),(93,'Chamoli','34','','Active',NULL,NULL),(94,'Champawat','34','','Active',NULL,NULL),(95,'Dehradun','34','','Active',NULL,NULL),(96,'Haridwar','34','','Active',NULL,NULL),(97,'Nainital','34','','Active',NULL,NULL),(98,'Pauri Garhwal','34','','Active',NULL,NULL),(99,'Pithoragarh','34','','Active',NULL,NULL),(100,'Rudraprayag','34','','Active',NULL,NULL),(101,'Tehri Garhwal','34','','Active',NULL,NULL),(102,'Udham Singh Nagar','34','','Active',NULL,NULL),(103,'Uttarkashi','34','','Active',NULL,NULL),(104,'Ambala','13','','Active',NULL,NULL),(105,'Bhiwani','13','','Active',NULL,NULL),(106,'Faridabad','13','','Active',NULL,NULL),(107,'Fatehabad','13','','Active',NULL,NULL),(108,'Gurgaon','13','','Active',NULL,NULL),(109,'Hisar','13','','Active',NULL,NULL),(110,'Jhajjar','13','','Active',NULL,NULL),(111,'Jind','13','','Active',NULL,NULL),(112,'Kaithal','13','','Active',NULL,NULL),(113,'Karnal','13','','Active',NULL,NULL),(114,'Kurukshetra','13','','Active',NULL,NULL),(115,'Mahendragarh','13','','Active',NULL,NULL),(116,'Mewat','13','','Active',NULL,NULL),(117,'Palwal','13','','Active',NULL,NULL),(118,'Panchkula','13','','Active',NULL,NULL),(119,'Panipat','13','','Active',NULL,NULL),(120,'Rewari','13','','Active',NULL,NULL),(121,'Rohtak','13','','Active',NULL,NULL),(122,'Sirsa','13','','Active',NULL,NULL),(123,'Sonipat','13','','Active',NULL,NULL),(124,'Yamuna Nagar','13','','Active',NULL,NULL),(125,'Central Delhi','10','','Active',NULL,NULL),(126,'East Delhi','10','','Active',NULL,NULL),(127,'New Delhi','10','','Active',NULL,NULL),(128,'North Delhi','10','','Active',NULL,NULL),(129,'North East Delhi','10','','Active',NULL,NULL),(130,'North West Delhi','10','','Active',NULL,NULL),(131,'South Delhi','10','','Active',NULL,NULL),(132,'South West Delhi','10','','Active',NULL,NULL),(133,'West Delhi','10','','Active',NULL,NULL),(134,'Ajmer','29','','Active',NULL,NULL),(135,'Alwar','29','','Active',NULL,NULL),(136,'Banswara','29','','Active',NULL,NULL),(137,'Baran','29','','Active',NULL,NULL),(138,'Barmer','29','','Active',NULL,NULL),(139,'Bharatpur','29','','Active',NULL,NULL),(140,'Bhilwara','29','','Active',NULL,NULL),(141,'Bikaner','29','','Active',NULL,NULL),(142,'Bundi','29','','Active',NULL,NULL),(143,'Chittorgarh','29','','Active',NULL,NULL),(144,'Churu','29','','Active',NULL,NULL),(145,'Dausa','29','','Active',NULL,NULL),(146,'Dholpur','29','','Active',NULL,NULL),(147,'Dungarpur','29','','Active',NULL,NULL),(148,'Ganganagar','29','','Active',NULL,NULL),(149,'Hanumangarh','29','','Active',NULL,NULL),(150,'Jaipur','29','','Active',NULL,NULL),(151,'Jaisalmer','29','','Active',NULL,NULL),(152,'Jalor','29','','Active',NULL,NULL),(153,'Jhalawar','29','','Active',NULL,NULL),(154,'Jhunjhunu','29','','Active',NULL,NULL),(155,'Jodhpur','29','','Active',NULL,NULL),(156,'Karauli','29','','Active',NULL,NULL),(157,'Kota','29','','Active',NULL,NULL),(158,'Nagaur','29','','Active',NULL,NULL),(159,'Pali','29','','Active',NULL,NULL),(160,'Pratapgarh (Rajasthan)','29','','Active',NULL,NULL),(161,'Rajsamand','29','','Active',NULL,NULL),(162,'Sawai Madhopur','29','','Active',NULL,NULL),(163,'Sikar','29','','Active',NULL,NULL),(164,'Sirohi','29','','Active',NULL,NULL),(165,'Tonk','29','','Active',NULL,NULL),(166,'Udaipur','29','','Active',NULL,NULL),(167,'Agra','33','','Active',NULL,NULL),(168,'Aligarh','33','','Active',NULL,NULL),(169,'Allahabad','33','','Active',NULL,NULL),(170,'Ambedkar Nagar','33','','Active',NULL,NULL),(171,'Auraiya','33','','Active',NULL,NULL),(172,'Azamgarh','33','','Active',NULL,NULL),(173,'Bagpat','33','','Active',NULL,NULL),(174,'Bahraich','33','','Active',NULL,NULL),(175,'Ballia','33','','Active',NULL,NULL),(176,'Balrampur','33','','Active',NULL,NULL),(177,'Banda','33','','Active',NULL,NULL),(178,'Barabanki','33','','Active',NULL,NULL),(179,'Bareilly','33','','Active',NULL,NULL),(180,'Basti','33','','Active',NULL,NULL),(181,'Bijnor','33','','Active',NULL,NULL),(182,'Budaun','33','','Active',NULL,NULL),(183,'Bulandshahr','33','','Active',NULL,NULL),(184,'Chandauli','33','','Active',NULL,NULL),(185,'Chitrakoot','33','','Active',NULL,NULL),(186,'Deoria','33','','Active',NULL,NULL),(187,'Etah','33','','Active',NULL,NULL),(188,'Etawah','33','','Active',NULL,NULL),(189,'Faizabad','33','','Active',NULL,NULL),(190,'Farrukhabad','33','','Active',NULL,NULL),(191,'Fatehpur','33','','Active',NULL,NULL),(192,'Firozabad','33','','Active',NULL,NULL),(193,'Gautam Buddha Nagar','33','','Active',NULL,NULL),(194,'Ghaziabad','33','','Active',NULL,NULL),(195,'Ghazipur','33','','Active',NULL,NULL),(196,'Gonda','33','','Active',NULL,NULL),(197,'Gorakhpur','33','','Active',NULL,NULL),(198,'Hamirpur','33','','Active',NULL,NULL),(199,'Hardoi','33','','Active',NULL,NULL),(200,'Hathras','33','','Active',NULL,NULL),(201,'Jalaun','33','','Active',NULL,NULL),(202,'Jaunpur','33','','Active',NULL,NULL),(203,'Jhansi','33','','Active',NULL,NULL),(204,'Jyotiba Phule Nagar','33','','Active',NULL,NULL),(205,'Kannauj','33','','Active',NULL,NULL),(206,'Kanpur Dehat','33','','Active',NULL,NULL),(207,'Kanpur Nagar','33','','Active',NULL,NULL),(208,'Kanshiram Nagar','33','','Active',NULL,NULL),(209,'Kaushambi','33','','Active',NULL,NULL),(210,'Kheri','33','','Active',NULL,NULL),(211,'Kushinagar','33','','Active',NULL,NULL),(212,'Lalitpur','33','','Active',NULL,NULL),(213,'Lucknow','33','','Active',NULL,NULL),(214,'Maharajganj','33','','Active',NULL,NULL),(215,'Mahoba','33','','Active',NULL,NULL),(216,'Mainpuri','33','','Active',NULL,NULL),(217,'Mathura','33','','Active',NULL,NULL),(218,'Mau','33','','Active',NULL,NULL),(219,'Meerut','33','','Active',NULL,NULL),(220,'Mirzapur','33','','Active',NULL,NULL),(221,'Moradabad','33','','Active',NULL,NULL),(222,'Muzaffarnagar','33','','Active',NULL,NULL),(223,'Pilibhit','33','','Active',NULL,NULL),(224,'Pratapgarh','33','','Active',NULL,NULL),(225,'Rae Bareli','33','','Active',NULL,NULL),(226,'Rampur','33','','Active',NULL,NULL),(227,'Saharanpur','33','','Active',NULL,NULL),(228,'Sant Kabir Nagar','33','','Active',NULL,NULL),(229,'Sant Ravidas Nagar (Bhadohi)','33','','Active',NULL,NULL),(230,'Shahjahanpur','33','','Active',NULL,NULL),(231,'Shrawasti','33','','Active',NULL,NULL),(232,'Siddharthnagar','33','','Active',NULL,NULL),(233,'Sitapur','33','','Active',NULL,NULL),(234,'Sonbhadra','33','','Active',NULL,NULL),(235,'Sultanpur','33','','Active',NULL,NULL),(236,'Unnao','33','','Active',NULL,NULL),(237,'Varanasi','33','','Active',NULL,NULL),(238,'Araria','5','','Active',NULL,NULL),(239,'Arwal','5','','Active',NULL,NULL),(240,'Aurangabad (Bihar)','5','','Active',NULL,NULL),(241,'Banka','5','','Active',NULL,NULL),(242,'Begusarai','5','','Active',NULL,NULL),(243,'Bhagalpur','5','','Active',NULL,NULL),(244,'Bhojpur','5','','Active',NULL,NULL),(245,'Buxar','5','','Active',NULL,NULL),(246,'Darbhanga','5','','Active',NULL,NULL),(247,'East Champaran','5','','Active',NULL,NULL),(248,'Gaya','5','','Active',NULL,NULL),(249,'Gopalganj','5','','Active',NULL,NULL),(250,'Jamui','5','','Active',NULL,NULL),(251,'Jehanabad','5','','Active',NULL,NULL),(252,'Kaimur (Bhabua)','5','','Active',NULL,NULL),(253,'Katihar','5','','Active',NULL,NULL),(254,'Khagaria','5','','Active',NULL,NULL),(255,'Kishanganj','5','','Active',NULL,NULL),(256,'Lakhisarai','5','','Active',NULL,NULL),(257,'Madhepura','5','','Active',NULL,NULL),(258,'Madhubani','5','','Active',NULL,NULL),(259,'Munger','5','','Active',NULL,NULL),(260,'Muzaffarpur','5','','Active',NULL,NULL),(261,'Nalanda','5','','Active',NULL,NULL),(262,'Nawada','5','','Active',NULL,NULL),(263,'Patna','5','','Active',NULL,NULL),(264,'Purnia','5','','Active',NULL,NULL),(265,'Rohtas','5','','Active',NULL,NULL),(266,'Saharsa','5','','Active',NULL,NULL),(267,'Samastipur','5','','Active',NULL,NULL),(268,'Saran','5','','Active',NULL,NULL),(269,'Sheikhpura','5','','Active',NULL,NULL),(270,'Sheohar','5','','Active',NULL,NULL),(271,'Sitamarhi','5','','Active',NULL,NULL),(272,'Siwan','5','','Active',NULL,NULL),(273,'Supaul','5','','Active',NULL,NULL),(274,'Vaishali','5','','Active',NULL,NULL),(275,'West Champaran','5','','Active',NULL,NULL),(276,'East Sikkim','30','','Active',NULL,NULL),(277,'North Sikkim','30','','Active',NULL,NULL),(278,'South Sikkim','30','','Active',NULL,NULL),(279,'West Sikkim','30','','Active',NULL,NULL),(280,'Anjaw','3','','Active',NULL,NULL),(281,'Changlang','3','','Active',NULL,NULL),(282,'Dibang Valley','3','','Active',NULL,NULL),(283,'East Kameng','3','','Active',NULL,NULL),(284,'East Siang','3','','Active',NULL,NULL),(285,'Kurung Kumey','3','','Active',NULL,NULL),(286,'Lohit','3','','Active',NULL,NULL),(287,'Lower Dibang Valley','3','','Active',NULL,NULL),(288,'Lower Subansiri','3','','Active',NULL,NULL),(289,'Papum Pare','3','','Active',NULL,NULL),(290,'Tawang','3','','Active',NULL,NULL),(291,'Tirap','3','','Active',NULL,NULL),(292,'Upper Siang','3','','Active',NULL,NULL),(293,'Upper Subansiri','3','','Active',NULL,NULL),(294,'West Kameng','3','','Active',NULL,NULL),(295,'West Siang','3','','Active',NULL,NULL),(296,'Dimapur','25','','Active',NULL,NULL),(297,'Kiphire','25','','Active',NULL,NULL),(298,'Kohima','25','','Active',NULL,NULL),(299,'Longleng','25','','Active',NULL,NULL),(300,'Mokokchung','25','','Active',NULL,NULL),(301,'Mon','25','','Active',NULL,NULL),(302,'Peren','25','','Active',NULL,NULL),(303,'Phek','25','','Active',NULL,NULL),(304,'Tuensang','25','','Active',NULL,NULL),(305,'Wokha','25','','Active',NULL,NULL),(306,'Zunheboto','25','','Active',NULL,NULL),(307,'Bishnupur','22','','Active',NULL,NULL),(308,'Chandel','22','','Active',NULL,NULL),(309,'Churachandpur','22','','Active',NULL,NULL),(310,'Imphal East','22','','Active',NULL,NULL),(311,'Imphal West','22','','Active',NULL,NULL),(312,'Senapati','22','','Active',NULL,NULL),(313,'Tamenglong','22','','Active',NULL,NULL),(314,'Thoubal','22','','Active',NULL,NULL),(315,'Ukhrul','22','','Active',NULL,NULL),(316,'Aizawl','24','','Active',NULL,NULL),(317,'Champhai','24','','Active',NULL,NULL),(318,'Kolasib','24','','Active',NULL,NULL),(319,'Lawngtlai','24','','Active',NULL,NULL),(320,'Lunglei','24','','Active',NULL,NULL),(321,'Mamit','24','','Active',NULL,NULL),(322,'Saiha','24','','Active',NULL,NULL),(323,'Serchhip','24','','Active',NULL,NULL),(324,'Dhalai','32','','Active',NULL,NULL),(325,'North Tripura','32','','Active',NULL,NULL),(326,'South Tripura','32','','Active',NULL,NULL),(327,'West Tripura','32','','Active',NULL,NULL),(328,'East Garo Hills','23','','Active',NULL,NULL),(329,'East Khasi Hills','23','','Active',NULL,NULL),(330,'Jaintia Hills','23','','Active',NULL,NULL),(331,'Ri Bhoi','23','','Active',NULL,NULL),(332,'South Garo Hills','23','','Active',NULL,NULL),(333,'West Garo Hills','23','','Active',NULL,NULL),(334,'West Khasi Hills','23','','Active',NULL,NULL),(335,'Baksa','4','','Active',NULL,NULL),(336,'Barpeta','4','','Active',NULL,NULL),(337,'Bongaigaon','4','','Active',NULL,NULL),(338,'Cachar','4','','Active',NULL,NULL),(339,'Chirang','4','','Active',NULL,NULL),(340,'Darrang','4','','Active',NULL,NULL),(341,'Dhemaji','4','','Active',NULL,NULL),(342,'Dhubri','4','','Active',NULL,NULL),(343,'Dibrugarh','4','','Active',NULL,NULL),(344,'Dima Hasao (North Cachar Hills)','4','','Active',NULL,NULL),(345,'Goalpara','4','','Active',NULL,NULL),(346,'Golaghat','4','','Active',NULL,NULL),(347,'Hailakandi','4','','Active',NULL,NULL),(348,'Jorhat','4','','Active',NULL,NULL),(349,'Kamrup','4','','Active',NULL,NULL),(350,'Kamrup Metropolitan','4','','Active',NULL,NULL),(351,'Karbi Anglong','4','','Active',NULL,NULL),(352,'Karimganj','4','','Active',NULL,NULL),(353,'Kokrajhar','4','','Active',NULL,NULL),(354,'Lakhimpur','4','','Active',NULL,NULL),(355,'Morigaon','4','','Active',NULL,NULL),(356,'Nagaon','4','','Active',NULL,NULL),(357,'Nalbari','4','','Active',NULL,NULL),(358,'Sivasagar','4','','Active',NULL,NULL),(359,'Sonitpur','4','','Active',NULL,NULL),(360,'Tinsukia','4','','Active',NULL,NULL),(361,'Udalguri','4','','Active',NULL,NULL),(362,'Bankura','35','','Active',NULL,NULL),(363,'Bardhaman','35','','Active',NULL,NULL),(364,'Birbhum','35','','Active',NULL,NULL),(365,'Cooch Behar','35','','Active',NULL,NULL),(366,'Dakshin Dinajpur (South Dinajpur)','35','','Active',NULL,NULL),(367,'Darjiling','35','','Active',NULL,NULL),(368,'Hooghly','35','','Active',NULL,NULL),(369,'Howrah','35','','Active',NULL,NULL),(370,'Jalpaiguri','35','','Active',NULL,NULL),(371,'Kolkata','35','','Active',NULL,NULL),(372,'Maldah','35','','Active',NULL,NULL),(373,'Murshidabad','35','','Active',NULL,NULL),(374,'Nadia','35','','Active',NULL,NULL),(375,'North 24 Parganas','35','','Active',NULL,NULL),(376,'Paschim Medinipur (West Midnapore)','35','','Active',NULL,NULL),(377,'Purba Medinipur (East Midnapore)','35','','Active',NULL,NULL),(378,'Puruliya','35','','Active',NULL,NULL),(379,'South 24 Parganas','35','','Active',NULL,NULL),(380,'Uttar Dinajpur (North Dinajpur)','35','','Active',NULL,NULL),(381,'Bokaro','16','','Active',NULL,NULL),(382,'Chatra','16','','Active',NULL,NULL),(383,'Deoghar','16','','Active',NULL,NULL),(384,'Dhanbad','16','','Active',NULL,NULL),(385,'Dumka','16','','Active',NULL,NULL),(386,'East Singhbhum','16','','Active',NULL,NULL),(387,'Garhwa','16','','Active',NULL,NULL),(388,'Giridih','16','','Active',NULL,NULL),(389,'Godda','16','','Active',NULL,NULL),(390,'Gumla','16','','Active',NULL,NULL),(391,'Hazaribagh','16','','Active',NULL,NULL),(392,'Jamtara','16','','Active',NULL,NULL),(393,'Khunti','16','','Active',NULL,NULL),(394,'Koderma','16','','Active',NULL,NULL),(395,'Latehar','16','','Active',NULL,NULL),(396,'Lohardaga','16','','Active',NULL,NULL),(397,'Pakur','16','','Active',NULL,NULL),(398,'Palamu','16','','Active',NULL,NULL),(399,'Ramgarh','16','','Active',NULL,NULL),(400,'Ranchi','16','','Active',NULL,NULL),(401,'Sahibganj','16','','Active',NULL,NULL),(402,'Seraikela-Kharsawan','16','','Active',NULL,NULL),(403,'Simdega','16','','Active',NULL,NULL),(404,'West Singhbhum','16','','Active',NULL,NULL),(405,'Angul','26','','Active',NULL,NULL),(406,'Balangir','26','','Active',NULL,NULL),(407,'Baleswar','26','','Active',NULL,NULL),(408,'Bargarh','26','','Active',NULL,NULL),(409,'Bhadrak','26','','Active',NULL,NULL),(410,'Boudh','26','','Active',NULL,NULL),(411,'Cuttack','26','','Active',NULL,NULL),(412,'Debagarh','26','','Active',NULL,NULL),(413,'Dhenkanal','26','','Active',NULL,NULL),(414,'Gajapati','26','','Active',NULL,NULL),(415,'Ganjam','26','','Active',NULL,NULL),(416,'Jagatsinghapur','26','','Active',NULL,NULL),(417,'Jajapur','26','','Active',NULL,NULL),(418,'Jharsuguda','26','','Active',NULL,NULL),(419,'Kalahandi','26','','Active',NULL,NULL),(420,'Kandhamal','26','','Active',NULL,NULL),(421,'Kendrapara','26','','Active',NULL,NULL),(422,'Kendujhar','26','','Active',NULL,NULL),(423,'Khordha','26','','Active',NULL,NULL),(424,'Koraput','26','','Active',NULL,NULL),(425,'Malkangiri','26','','Active',NULL,NULL),(426,'Mayurbhanj','26','','Active',NULL,NULL),(427,'Nabarangapur','26','','Active',NULL,NULL),(428,'Nayagarh','26','','Active',NULL,NULL),(429,'Nuapada','26','','Active',NULL,NULL),(430,'Puri','26','','Active',NULL,NULL),(431,'Rayagada','26','','Active',NULL,NULL),(432,'Sambalpur','26','','Active',NULL,NULL),(433,'Subarnapur (Sonapur)','26','','Active',NULL,NULL),(434,'Sundergarh','26','','Active',NULL,NULL),(435,'Bastar','7','','Active',NULL,NULL),(436,'Bijapur (Chhattisgarh)','7','','Active',NULL,NULL),(437,'Bilaspur (Chhattisgarh)','7','','Active',NULL,NULL),(438,'Dakshin Bastar Dantewada','7','','Active',NULL,NULL),(439,'Dhamtari','7','','Active',NULL,NULL),(440,'Durg','7','','Active',NULL,NULL),(441,'Janjgir-Champa','7','','Active',NULL,NULL),(442,'Jashpur','7','','Active',NULL,NULL),(443,'Kabirdham (Kawardha)','7','','Active',NULL,NULL),(444,'Korba','7','','Active',NULL,NULL),(445,'Koriya','7','','Active',NULL,NULL),(446,'Mahasamund','7','','Active',NULL,NULL),(447,'Narayanpur','7','','Active',NULL,NULL),(448,'Raigarh (Chhattisgarh)','7','','Active',NULL,NULL),(449,'Raipur','7','','Active',NULL,NULL),(450,'Rajnandgaon','7','','Active',NULL,NULL),(451,'Surguja','7','','Active',NULL,NULL),(452,'Uttar Bastar Kanker','7','','Active',NULL,NULL),(453,'Alirajpur','20','','Active',NULL,NULL),(454,'Anuppur','20','','Active',NULL,NULL),(455,'Ashok Nagar','20','','Active',NULL,NULL),(456,'Balaghat','20','','Active',NULL,NULL),(457,'Barwani','20','','Active',NULL,NULL),(458,'Betul','20','','Active',NULL,NULL),(459,'Bhind','20','','Active',NULL,NULL),(460,'Bhopal','20','','Active',NULL,NULL),(461,'Burhanpur','20','','Active',NULL,NULL),(462,'Chhatarpur','20','','Active',NULL,NULL),(463,'Chhindwara','20','','Active',NULL,NULL),(464,'Damoh','20','','Active',NULL,NULL),(465,'Datia','20','','Active',NULL,NULL),(466,'Dewas','20','','Active',NULL,NULL),(467,'Dhar','20','','Active',NULL,NULL),(468,'Dindori','20','','Active',NULL,NULL),(469,'Guna','20','','Active',NULL,NULL),(470,'Gwalior','20','','Active',NULL,NULL),(471,'Harda','20','','Active',NULL,NULL),(472,'Hoshangabad','20','','Active',NULL,NULL),(473,'Indore','20','','Active',NULL,NULL),(474,'Jabalpur','20','','Active',NULL,NULL),(475,'Jhabua','20','','Active',NULL,NULL),(476,'Katni','20','','Active',NULL,NULL),(477,'Khandwa (East Nimar)','20','','Active',NULL,NULL),(478,'Khargone (West Nimar)','20','','Active',NULL,NULL),(479,'Mandla','20','','Active',NULL,NULL),(480,'Mandsaur','20','','Active',NULL,NULL),(481,'Morena','20','','Active',NULL,NULL),(482,'Narsinghpur','20','','Active',NULL,NULL),(483,'Neemuch','20','','Active',NULL,NULL),(484,'Panna','20','','Active',NULL,NULL),(485,'Raisen','20','','Active',NULL,NULL),(486,'Rajgarh','20','','Active',NULL,NULL),(487,'Ratlam','20','','Active',NULL,NULL),(488,'Rewa','20','','Active',NULL,NULL),(489,'Sagar','20','','Active',NULL,NULL),(490,'Satna','20','','Active',NULL,NULL),(491,'Sehore','20','','Active',NULL,NULL),(492,'Seoni','20','','Active',NULL,NULL),(493,'Shahdol','20','','Active',NULL,NULL),(494,'Shajapur','20','','Active',NULL,NULL),(495,'Sheopur','20','','Active',NULL,NULL),(496,'Shivpuri','20','','Active',NULL,NULL),(497,'Sidhi','20','','Active',NULL,NULL),(498,'Singrauli','20','','Active',NULL,NULL),(499,'Tikamgarh','20','','Active',NULL,NULL),(500,'Ujjain','20','','Active',NULL,NULL),(501,'Umaria','20','','Active',NULL,NULL),(502,'Vidisha','20','','Active',NULL,NULL),(503,'Ahmedabad','12','','Active',NULL,NULL),(504,'Amreli','12','','Active',NULL,NULL),(505,'Anand','12','','Active',NULL,NULL),(506,'Banaskantha','12','','Active',NULL,NULL),(507,'Bharuch','12','','Active',NULL,NULL),(508,'Bhavnagar','12','','Active',NULL,NULL),(509,'Dahod','12','','Active',NULL,NULL),(510,'Gandhi Nagar','12','','Active',NULL,NULL),(511,'Jamnagar','12','','Active',NULL,NULL),(512,'Junagadh','12','','Active',NULL,NULL),(513,'Kachchh','12','','Active',NULL,NULL),(514,'Kheda','12','','Active',NULL,NULL),(515,'Mahesana','12','','Active',NULL,NULL),(516,'Narmada','12','','Active',NULL,NULL),(517,'Navsari','12','','Active',NULL,NULL),(518,'Panch Mahals','12','','Active',NULL,NULL),(519,'Patan','12','','Active',NULL,NULL),(520,'Porbandar','12','','Active',NULL,NULL),(521,'Rajkot','12','','Active',NULL,NULL),(522,'Sabarkantha','12','','Active',NULL,NULL),(523,'Surat','12','','Active',NULL,NULL),(524,'Surendra Nagar','12','','Active',NULL,NULL),(525,'Tapi','12','','Active',NULL,NULL),(526,'The Dangs','12','','Active',NULL,NULL),(527,'Vadodara','12','','Active',NULL,NULL),(528,'Valsad','12','','Active',NULL,NULL),(529,'Daman','9','','Active',NULL,NULL),(530,'Diu','9','','Active',NULL,NULL),(531,'Dadra & Nagar Haveli','8','','Active',NULL,NULL),(532,'Ahmed Nagar','21','','Active',NULL,NULL),(533,'Akola','21','','Active',NULL,NULL),(534,'Amravati','21','','Active',NULL,NULL),(535,'Aurangabad','21','','Active',NULL,NULL),(536,'Beed','21','','Active',NULL,NULL),(537,'Bhandara','21','','Active',NULL,NULL),(538,'Buldhana','21','','Active',NULL,NULL),(539,'Chandrapur','21','','Active',NULL,NULL),(540,'Dhule','21','','Active',NULL,NULL),(541,'Gadchiroli','21','','Active',NULL,NULL),(542,'Gondia','21','','Active',NULL,NULL),(543,'Hingoli','21','','Active',NULL,NULL),(544,'Jalgaon','21','','Active',NULL,NULL),(545,'Jalna','21','','Active',NULL,NULL),(546,'Kolhapur','21','','Active',NULL,NULL),(547,'Latur','21','','Active',NULL,NULL),(548,'Mumbai','21','','Active',NULL,NULL),(549,'Mumbai Suburban','21','','Active',NULL,NULL),(550,'Nagpur','21','','Active',NULL,NULL),(551,'Nanded','21','','Active',NULL,NULL),(552,'Nandurbar','21','','Active',NULL,NULL),(553,'Nashik','21','','Active',NULL,NULL),(554,'Osmanabad','21','','Active',NULL,NULL),(555,'Parbhani','21','','Active',NULL,NULL),(556,'Pune','21','','Active',NULL,NULL),(557,'Raigarh (Maharashtra)','21','','Active',NULL,NULL),(558,'Ratnagiri','21','','Active',NULL,NULL),(559,'Sangli','21','','Active',NULL,NULL),(560,'Satara','21','','Active',NULL,NULL),(561,'Sindhudurg','21','','Active',NULL,NULL),(562,'Solapur','21','','Active',NULL,NULL),(563,'Thane','21','','Active',NULL,NULL),(564,'Wardha','21','','Active',NULL,NULL),(565,'Washim','21','','Active',NULL,NULL),(566,'Yavatmal','21','','Active',NULL,NULL),(567,'Adilabad','2','','Active',NULL,NULL),(568,'Anantapur','2','','Active',NULL,NULL),(569,'Chittoor','2','','Active',NULL,NULL),(570,'East Godavari','2','','Active',NULL,NULL),(571,'Guntur','2','','Active',NULL,NULL),(572,'Hyderabad','2','','Active',NULL,NULL),(573,'Kadapa (Cuddapah)','2','','Active',NULL,NULL),(574,'Karim Nagar','2','','Active',NULL,NULL),(575,'Khammam','2','','Active',NULL,NULL),(576,'Krishna','2','','Active',NULL,NULL),(577,'Kurnool','2','','Active',NULL,NULL),(578,'Mahbubnagar','2','','Active',NULL,NULL),(579,'Medak','2','','Active',NULL,NULL),(580,'Nalgonda','2','','Active',NULL,NULL),(581,'Nellore','2','','Active',NULL,NULL),(582,'Nizamabad','2','','Active',NULL,NULL),(583,'Prakasam','2','','Active',NULL,NULL),(584,'Rangareddy','2','','Active',NULL,NULL),(585,'Srikakulam','2','','Active',NULL,NULL),(586,'Visakhapatnam','2','','Active',NULL,NULL),(587,'Vizianagaram','2','','Active',NULL,NULL),(588,'Warangal','2','','Active',NULL,NULL),(589,'West Godavari','2','','Active',NULL,NULL),(590,'Bagalkot','17','','Active',NULL,NULL),(591,'Bangalore','17','','Active',NULL,NULL),(592,'Bangalore Rural','17','','Active',NULL,NULL),(593,'Belgaum','17','','Active',NULL,NULL),(594,'Bellary','17','','Active',NULL,NULL),(595,'Bidar','17','','Active',NULL,NULL),(596,'Bijapur (Karnataka)','17','','Active',NULL,NULL),(597,'Chamrajnagar','17','','Active',NULL,NULL),(598,'Chickmagalur','17','','Active',NULL,NULL),(599,'Chikkaballapur','17','','Active',NULL,NULL),(600,'Chitradurga','17','','Active',NULL,NULL),(601,'Dakshina Kannada','17','','Active',NULL,NULL),(602,'Davanagere','17','','Active',NULL,NULL),(603,'Dharwad','17','','Active',NULL,NULL),(604,'Gadag','17','','Active',NULL,NULL),(605,'Gulbarga','17','','Active',NULL,NULL),(606,'Hassan','17','','Active',NULL,NULL),(607,'Haveri','17','','Active',NULL,NULL),(608,'Kodagu','17','','Active',NULL,NULL),(609,'Kolar','17','','Active',NULL,NULL),(610,'Koppal','17','','Active',NULL,NULL),(611,'Mandya','17','','Active',NULL,NULL),(612,'Mysore','17','','Active',NULL,NULL),(613,'Raichur','17','','Active',NULL,NULL),(614,'Ramanagara','17','','Active',NULL,NULL),(615,'Shimoga','17','','Active',NULL,NULL),(616,'Tumkur','17','','Active',NULL,NULL),(617,'Udupi','17','','Active',NULL,NULL),(618,'Uttara Kannada','17','','Active',NULL,NULL),(619,'Yadgir','17','','Active',NULL,NULL),(620,'North Goa','11','','Active',NULL,NULL),(621,'South Goa','11','','Active',NULL,NULL),(622,'Lakshadweep','19','','Active',NULL,NULL),(623,'Alappuzha','18','','Active',NULL,NULL),(624,'Ernakulam','18','','Active',NULL,NULL),(625,'Idukki','18','','Active',NULL,NULL),(626,'Kannur','18','','Active',NULL,NULL),(627,'Kasaragod','18','','Active',NULL,NULL),(628,'Kollam','18','','Active',NULL,NULL),(629,'Kottayam','18','','Active',NULL,NULL),(630,'Kozhikode','18','','Active',NULL,NULL),(631,'Malappuram','18','','Active',NULL,NULL),(632,'Palakkad','18','','Active',NULL,NULL),(633,'Pathanamthitta','18','','Active',NULL,NULL),(634,'Thiruvananthapuram','18','','Active',NULL,NULL),(635,'Thrissur','18','','Active',NULL,NULL),(636,'Wayanad','18','','Active',NULL,NULL),(637,'Ariyalur','31','','Active',NULL,NULL),(638,'Chennai','31','','Active',NULL,NULL),(639,'Coimbatore','31','','Active',NULL,NULL),(640,'Cuddalore','31','','Active',NULL,NULL),(641,'Dharmapuri','31','','Active',NULL,NULL),(642,'Dindigul','31','','Active',NULL,NULL),(643,'Erode','31','','Active',NULL,NULL),(644,'Kanchipuram','31','','Active',NULL,NULL),(645,'Kanyakumari','31','','Active',NULL,NULL),(646,'Karur','31','','Active',NULL,NULL),(647,'Krishnagiri','31','','Active',NULL,NULL),(648,'Madurai','31','','Active',NULL,NULL),(649,'Nagapattinam','31','','Active',NULL,NULL),(650,'Namakkal','31','','Active',NULL,NULL),(651,'Nilgiris','31','','Active',NULL,NULL),(652,'Perambalur','31','','Active',NULL,NULL),(653,'Pudukkottai','31','','Active',NULL,NULL),(654,'Ramanathapuram','31','','Active',NULL,NULL),(655,'Salem','31','','Active',NULL,NULL),(656,'Sivaganga','31','','Active',NULL,NULL),(657,'Thanjavur','31','','Active',NULL,NULL),(658,'Theni','31','','Active',NULL,NULL),(659,'Thoothukudi (Tuticorin)','31','','Active',NULL,NULL),(660,'Tiruchirappalli','31','','Active',NULL,NULL),(661,'Tirunelveli','31','','Active',NULL,NULL),(662,'Tiruppur','31','','Active',NULL,NULL),(663,'Tiruvallur','31','','Active',NULL,NULL),(664,'Tiruvannamalai','31','','Active',NULL,NULL),(665,'Tiruvarur','31','','Active',NULL,NULL),(666,'Vellore','31','','Active',NULL,NULL),(667,'Viluppuram','31','','Active',NULL,NULL),(668,'Virudhunagar','31','','Active',NULL,NULL),(669,'Karaikal','27','','Active',NULL,NULL),(670,'Mahe','27','','Active',NULL,NULL),(671,'Puducherry (Pondicherry)','27','','Active',NULL,NULL),(672,'Yanam','27','','Active',NULL,NULL),(673,'Nicobar','1','','Active',NULL,NULL),(674,'North And Middle Andaman','1','','Active',NULL,NULL),(675,'South Andaman','1','','Active',NULL,NULL),(676,'Vijaya','2','Vijaya','1','2022-05-03 08:53:23','2022-05-03 08:53:23'),(677,'xyzzzz','2','xyzzzz','1','2022-05-12 22:53:04','2022-05-12 22:53:04'),(678,'sdfsdfsdf','2','sdfsdfsdf','1','2022-05-21 11:00:03','2022-05-21 11:00:03'),(679,'ggggg','5','ggggg','1','2022-05-21 12:48:40','2022-05-21 12:48:40'),(680,'Nal','36','Nal','1','2022-09-26 04:37:20','2022-09-26 04:37:20'),(681,'Nalgonda  + Khammam','36','Nalgonda  + Khammam','1','2022-09-26 04:38:14','2022-09-26 04:38:14'),(682,'Nalgonda  + Khammam','36','Nalgonda  + Khammam','1','2022-09-26 04:38:25','2022-09-26 04:38:25'),(683,'Nalgonda   Khammam','36','Nalgonda   Khammam','1','2022-09-26 04:39:03','2022-09-26 04:39:03'),(684,'Nalgonda + Khammam','36','Nalgonda + Khammam','1','2022-09-26 04:39:36','2022-09-26 04:39:36');

--
-- Table structure for table `duration`
--

CREATE TABLE `duration` (
  `id` int NOT NULL AUTO_INCREMENT,
  `duration_name` varchar(250) NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_on` datetime NOT NULL,
  `status` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `duration`
--

INSERT INTO `duration` VALUES (1,'7 Days','2022-04-14 21:35:53','0000-00-00 00:00:00',1),(2,'1 Month','2022-04-14 21:35:53','0000-00-00 00:00:00',1),(3,'3 Months','2022-04-14 21:35:53','0000-00-00 00:00:00',1),(4,'6 Months','2022-04-14 21:35:53','0000-00-00 00:00:00',1),(5,'Date Range','2022-05-24 18:27:56','2022-05-24 18:27:56',1);

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `home_banners`
--

CREATE TABLE `home_banners` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `btn_txt` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `btn_link` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT 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;

--
-- Dumping data for table `home_banners`
--


--
-- Table structure for table `levels`
--

CREATE TABLE `levels` (
  `id` int NOT NULL AUTO_INCREMENT,
  `level_name` varchar(250) NOT NULL,
  `level_order` int NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `levels`
--

INSERT INTO `levels` VALUES (1,'Boards',1,1,'2022-10-07 07:08:41','2022-10-07 07:08:41'),(2,'Revision',5,1,'2022-10-07 07:09:44','2022-10-07 07:09:44'),(3,'Foundation',3,1,'2022-10-07 07:10:07','2022-10-07 07:10:07'),(4,'Problems (Boards)',2,1,'2022-10-07 07:11:03','2022-10-07 07:11:03'),(5,'Board Theory',3,0,'2022-09-16 06:32:44','2022-09-16 06:32:44'),(6,'Problems (Foundation)',4,1,'2022-09-16 04:35:45','2022-09-16 06:35:45');

--
-- Table structure for table `login_user_admins`
--

CREATE TABLE `login_user_admins` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `login_userid` bigint NOT NULL,
  `admin_id` varchar(50) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `login_user_admins`
--

INSERT INTO `login_user_admins` VALUES (1,8,'1','2022-11-23 09:14:40','2022-11-23 09:14:40'),(2,8,'7','2022-11-23 09:14:40','2022-11-23 09:14:40'),(3,16,'1','2022-11-23 09:15:35','2022-11-23 09:15:35'),(4,16,'7','2022-11-23 09:15:35','2022-11-23 09:15:35'),(5,16,'12','2022-11-23 09:15:35','2022-11-23 09:15:35'),(6,18,'1','2022-12-21 05:03:00','2022-12-21 05:03:00'),(9,19,'1','2022-12-21 05:05:37','2022-12-21 05:05:37'),(11,20,'1','2022-12-26 07:57:52','2022-12-26 07:57:52');

--
-- Table structure for table `login_user_classes`
--

CREATE TABLE `login_user_classes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `login_userid` bigint unsigned NOT NULL,
  `class_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `login_user_classes_login_userid_foreign` (`login_userid`),
  CONSTRAINT `login_user_classes_login_userid_foreign` FOREIGN KEY (`login_userid`) REFERENCES `login_users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_user_classes`
--

INSERT INTO `login_user_classes` VALUES (11,15,'1','2022-10-22 06:14:01','2022-10-22 06:14:01'),(12,15,'2','2022-10-22 06:14:01','2022-10-22 06:14:01'),(13,15,'3','2022-10-22 06:14:01','2022-10-22 06:14:01'),(14,15,'5','2022-10-22 06:14:01','2022-10-22 06:14:01'),(15,15,'6','2022-10-22 06:14:01','2022-10-22 06:14:01'),(27,16,'1','2022-11-16 09:18:56','2022-11-16 09:18:56'),(28,16,'2','2022-11-16 09:18:56','2022-11-16 09:18:56'),(29,16,'3','2022-11-16 09:18:56','2022-11-16 09:18:56'),(30,17,'5','2022-11-20 06:16:48','2022-11-20 06:16:48'),(31,17,'6','2022-11-20 06:16:48','2022-11-20 06:16:48'),(32,18,'8','2022-12-21 05:03:00','2022-12-21 05:03:00'),(33,18,'9','2022-12-21 05:03:00','2022-12-21 05:03:00'),(34,18,'10','2022-12-21 05:03:00','2022-12-21 05:03:00'),(38,19,'8','2022-12-21 05:05:37','2022-12-21 05:05:37'),(42,20,'8','2022-12-26 07:57:52','2022-12-26 07:57:52'),(43,20,'9','2022-12-26 07:57:52','2022-12-26 07:57:52'),(44,20,'10','2022-12-26 07:57:52','2022-12-26 07:57:52'),(55,21,'8','2022-12-31 07:10:43','2022-12-31 07:10:43');

--
-- Table structure for table `login_user_problems`
--

CREATE TABLE `login_user_problems` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `login_userid` bigint unsigned NOT NULL,
  `problem_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `login_user_problems_login_userid_foreign` (`login_userid`),
  CONSTRAINT `login_user_problems_login_userid_foreign` FOREIGN KEY (`login_userid`) REFERENCES `login_users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_user_problems`
--


--
-- Table structure for table `login_user_subjects`
--

CREATE TABLE `login_user_subjects` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `login_userid` bigint unsigned NOT NULL,
  `subject_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `login_user_subjects_login_userid_foreign` (`login_userid`),
  CONSTRAINT `login_user_subjects_login_userid_foreign` FOREIGN KEY (`login_userid`) REFERENCES `login_users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_user_subjects`
--

INSERT INTO `login_user_subjects` VALUES (15,15,'1','2022-10-22 06:14:01','2022-10-22 06:14:01'),(16,15,'2','2022-10-22 06:14:01','2022-10-22 06:14:01'),(17,15,'3','2022-10-22 06:14:01','2022-10-22 06:14:01'),(18,15,'4','2022-10-22 06:14:01','2022-10-22 06:14:01'),(22,16,'4','2022-11-16 09:18:56','2022-11-16 09:18:56'),(23,17,'4','2022-11-20 06:16:48','2022-11-20 06:16:48'),(24,18,'6','2022-12-21 05:03:00','2022-12-21 05:03:00'),(27,19,'6','2022-12-21 05:05:37','2022-12-21 05:05:37'),(29,20,'6','2022-12-26 07:57:52','2022-12-26 07:57:52'),(64,21,'8','2022-12-31 07:10:44','2022-12-31 07:10:44'),(65,21,'7','2022-12-31 07:10:44','2022-12-31 07:10:44'),(66,21,'9','2022-12-31 07:10:44','2022-12-31 07:10:44');

--
-- Table structure for table `login_user_videos`
--

CREATE TABLE `login_user_videos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `login_userid` bigint unsigned NOT NULL,
  `video_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `login_user_videos_login_userid_foreign` (`login_userid`),
  CONSTRAINT `login_user_videos_login_userid_foreign` FOREIGN KEY (`login_userid`) REFERENCES `login_users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_user_videos`
--

INSERT INTO `login_user_videos` VALUES (1,18,'1','2022-12-21 05:03:00','2022-12-21 05:03:00'),(2,18,'4','2022-12-21 05:03:00','2022-12-21 05:03:00'),(11,19,'1','2022-12-21 05:05:37','2022-12-21 05:05:37'),(12,19,'4','2022-12-21 05:05:37','2022-12-21 05:05:37'),(13,19,'3','2022-12-21 05:05:37','2022-12-21 05:05:37'),(14,19,'6','2022-12-21 05:05:37','2022-12-21 05:05:37'),(18,20,'1','2022-12-26 07:57:52','2022-12-26 07:57:52'),(19,20,'4','2022-12-26 07:57:52','2022-12-26 07:57:52'),(20,20,'2','2022-12-26 07:57:52','2022-12-26 07:57:52'),(41,21,'1','2022-12-31 07:10:44','2022-12-31 07:10:44'),(42,21,'4','2022-12-31 07:10:44','2022-12-31 07:10:44');

--
-- Table structure for table `login_users`
--

CREATE TABLE `login_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `duration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_range` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_users`
--

INSERT INTO `login_users` VALUES (15,'ME','login for Marketing Executive','4','10/22/2022 - 10/22/2022',1,'2022-10-22 03:13:08','2022-12-29 12:37:06'),(16,'Bio-8-9-10','Biology Teacher for 8th, 9th and 10th','4','11/16/2022 - 11/16/2022',1,'2022-11-15 16:02:07','2022-11-16 09:18:56'),(17,'Bio-11-12','Biology Teacher for 11th and 12th','5','11/20/2022 - 11/20/2022',1,'2022-11-20 06:16:47','2022-11-20 06:16:47'),(18,'PhysicsTeacher1','Physics Teacher for 8th, 9th and 10th','4','12/21/2022 - 12/21/2022',1,'2022-12-21 05:03:00','2022-12-21 05:03:00'),(19,'PhysicsTeacher2','Physics Teacher for 8th + Foundation','4','12/21/2022 - 12/21/2022',1,'2022-12-21 05:04:02','2022-12-21 05:04:02'),(20,'PhysicsTeacher3','Physics Teacher for 8th, 9th and 10th + Revision','4','12/26/2022 - 12/26/2022',1,'2022-12-21 05:07:23','2022-12-26 07:57:52'),(21,'B-8','8th  board','5','12/31/2022 - 12/31/2022',1,'2022-12-27 05:52:08','2022-12-31 07:02:43');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (29,'2014_10_12_000000_create_users_table',1),(30,'2014_10_12_100000_create_password_resets_table',1),(31,'2019_08_19_000000_create_failed_jobs_table',1),(32,'2021_04_28_074754_create_products_table',1),(33,'2021_06_24_140557_create_admins_table',1),(34,'2021_06_28_070429_create_categories_table',1),(35,'2021_07_01_114250_create_coupons_table',1),(36,'2021_07_05_053554_create_sizes_table',1),(37,'2021_07_05_061505_create_colors_table',1),(38,'2021_07_05_091639_create_catproducts_table',1),(39,'2021_07_12_171053_create_brands_table',1),(40,'2021_07_14_173827_create_taxes_table',1),(41,'2021_07_16_060633_create_customers_table',1),(42,'2021_08_02_092025_create_home_banners_table',1),(43,'2022_03_09_121124_create_subjects_table',2),(44,'2022_03_09_133951_create_chapters_table',3),(45,'2022_03_09_141256_create_subjects_table',4),(46,'2022_03_10_115905_create_content_upload_table',5),(48,'2022_04_15_154014_create_login_users_table',6),(49,'2022_04_22_165656_create_login_users_table',7),(50,'2022_05_01_155350_create_countries_table',8),(51,'2022_05_01_155950_create_states_table',9),(52,'2022_05_02_122242_create_districts',10),(53,'2022_05_03_110407_create_b2b_schools_table',11),(54,'2022_05_05_114727_create_schools_table',12),(55,'2022_05_05_153556_create_school_principals_table',13),(56,'2019_12_14_000001_create_personal_access_tokens_table',14);

--
-- Table structure for table `problems`
--

CREATE TABLE `problems` (
  `id` int NOT NULL AUTO_INCREMENT,
  `problem_name` varchar(250) NOT NULL,
  `problem_order` int NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `problems`
--


--
-- Table structure for table `product_images`
--

CREATE TABLE `product_images` (
  `id` int NOT NULL AUTO_INCREMENT,
  `products_id` int NOT NULL,
  `images` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `product_images`
--

INSERT INTO `product_images` VALUES (1,1,'334424773.jpg'),(5,1,'546654238.jpg'),(6,1,'476621397.jpg');

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` decimal(22,2) DEFAULT '0.00',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--


--
-- Table structure for table `products_attr`
--

CREATE TABLE `products_attr` (
  `id` int NOT NULL AUTO_INCREMENT,
  `products_id` int NOT NULL,
  `sku` varchar(255) NOT NULL,
  `attr_image` varchar(255) DEFAULT NULL,
  `mrp` int NOT NULL,
  `price` int NOT NULL,
  `qty` int NOT NULL,
  `size_id` int NOT NULL,
  `color_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `products_attr`
--

INSERT INTO `products_attr` VALUES (1,1,'111','705130315.jpg',999,799,5,2,1),(2,1,'112','509937030.jpg',999,749,3,1,7),(3,2,'124','499793402.png',1499,1199,3,1,1),(4,3,'116','608075258.jpg',3495,2411,18,1,1),(5,4,'121','115102277.jpg',1071,899,5,0,0),(6,1,'113','216831743.jpg',999,749,23,3,8),(7,1,'114','436707592.jpg',999,749,31,2,5);

--
-- Table structure for table `school_principals`
--

CREATE TABLE `school_principals` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `school_id` int NOT NULL,
  `principal_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `whatsapp_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `principal_amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `school_principals`
--

INSERT INTO `school_principals` VALUES (1,2,'Ramu','9618878835','9618878835','20',1,'2022-10-07 05:15:33','2022-10-07 05:17:33'),(2,5,'Raju','9618878835','9618878835',NULL,1,'2022-10-07 05:25:02','2022-10-07 05:25:02'),(3,1,'dfdf','9999999999','9999999999','20',1,'2022-10-09 04:53:37','2022-10-09 04:53:37');

--
-- Table structure for table `school_visit_check`
--

CREATE TABLE `school_visit_check` (
  `id` int NOT NULL,
  `check_name` varchar(100) DEFAULT NULL,
  `status` enum('1','0') NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `school_visit_check`
--


--
-- Table structure for table `school_visit_images`
--

CREATE TABLE `school_visit_images` (
  `id` int NOT NULL,
  `sv_id` int NOT NULL,
  `image` varchar(250) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `school_visit_images`
--


--
-- Table structure for table `school_visits`
--

CREATE TABLE `school_visits` (
  `id` int NOT NULL,
  `school_id` int DEFAULT NULL,
  `visit_wise` varchar(50) DEFAULT NULL,
  `remarks` varchar(100) DEFAULT NULL,
  `latitude` varchar(50) DEFAULT NULL,
  `longitude` varchar(50) DEFAULT NULL,
  `name_me` varchar(100) DEFAULT NULL,
  `status` enum('1','0') NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `school_visits`
--


--
-- Table structure for table `schools`
--

CREATE TABLE `schools` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `school_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `school_district_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `school_amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `school_charges` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `school_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `schools`
--

INSERT INTO `schools` VALUES (1,'Nagarjuna','1010',NULL,NULL,'422562',1,'2022-09-19 07:30:59','2022-10-09 03:14:19'),(2,'NPS-1','101',NULL,NULL,'470315',1,'2022-09-19 07:31:28','2022-09-19 07:31:28'),(3,'Nagarjuna','101',NULL,NULL,'365239',1,'2022-09-19 12:45:49','2022-09-19 12:45:49'),(4,'Nagarjuna','101',NULL,NULL,'231370',1,'2022-09-20 07:41:34','2022-09-20 07:41:34'),(5,'DPS-1','101',NULL,NULL,'929025',1,'2022-09-26 04:33:19','2022-09-26 04:33:19'),(6,'NPS-1','1010',NULL,NULL,'874336',1,'2022-10-07 05:12:24','2022-10-07 05:12:24'),(7,'NPS-1','1011',NULL,NULL,'207514',1,'2022-10-07 05:13:05','2022-10-07 05:13:05');

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `payload` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` VALUES ('0hoE93ZTrvYuxwrMqzPuQsooxAlER26qVznqdMtX',NULL,'49.37.155.65','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTGRGV3EyVWJMbWhxNmN3WVU1SVR6bndYRkltdEp6WHNMOFQwM2RGOCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OC9hbmltYXRpb24iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1672579208),('1F8GPEc6pzKLVHoTi3TT5g0TQwyRIBB56PED1WEM',NULL,'87.236.176.89','Mozilla/5.0 (compatible; InternetMeasurement/1.0; +https://internet-measurement.com/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNGZqRXVnRnZ2Y2NjRHhWellLMThmTEVQT3dTRlVFOGJ4SGpIeHdKSyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672614782),('5UjitaSLZV8ugtA4AQMexdkdwrIm79rl76pKEIMj',NULL,'193.35.18.142','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.41 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoieWlhOTFGWHAzcjZSenRSREZrQXF5SGd4MzNxMnBQOVNHSXEwYzhxVCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672611032),('6NVUI4fR4YeJYWQPmcQSBU51vYa3m2FePxzWKK0o',NULL,'45.14.165.26','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:77.0) Gecko/20100101 Firefox/77.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSVJydm40c2U0ak1yR09yZDhYaDFDVjZmVWNBOGJzRkRKQUxVY2M0eCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672640633),('AbQijnlIYF8kcclxpZ34d5ybr7sS7zVtkYux36rg',NULL,'151.235.239.202','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoidVc2OGl5a3ZaMnNsR2E2bHFzVDI1dkxBU3FabGJaV2JjZmUzaDFLZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672598147),('antTrU4ObOgeWeGWOCKGfGlpzvuHoHjgZ2AjrbSN',NULL,'51.159.152.255','Mozilla/5.0 (X11; Linux x86_64; rv:104.0) Gecko/20100101 Firefox/104.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUDRqV2NyQlFsbWg0UHpJaldjM3VUbGNHd2hiQUFENG9GV1hiOVVuSSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672652211),('bdbxjRx9Y4DOPiHGqtDO8ET6wyY0pwHRFzlXmMND',NULL,'167.248.133.47','','YTozOntzOjY6Il90b2tlbiI7czo0MDoieHRRUHUxS3JEdVR1V3hrcDkzcElCaFNsSllqYjNTWkJZWm9kTFBucCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672579761),('CbNPxME4TsQ5rf3wDgdA5LX6LUfxHWHdlIB9HO1F',NULL,'170.64.154.166','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMHhsWmloeW5yeEI2WjZwNHFWWENzRzRsazNGb1NnTFIzbXBGamg0bSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672635992),('D1wamah5fWFJm2PGiAPVZ7iUwCPX2luHviSxtRti',NULL,'68.183.32.234','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiQUd1MlFEeDQwU1VHQng3NTd4T3FqSTdHY0FGMUdJaXFCeFpTSHNxRyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672671121),('eIp2nU0ywhMqbgvt5Q2BHj03sXokijeAndVydFGj',NULL,'167.248.133.47','Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWU9YUWV5bnVGTnM5OHQ0cDRXbDZQcmRzcUxuQ3ZMZmo2Q0RDNThpdyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672579761),('gUfEyogygB0veVWAXY0NsYRw8qQV6dcacbxHBQ38',NULL,'157.35.52.76','Mozilla/5.0 (Linux; Android 12; RMX3392) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Mobile Safari/537.36','YToyOntzOjY6Il90b2tlbiI7czo0MDoiODFSQTVFRzRIeFFLd2RXWUV6RzI2MlZtR09mclY3MXFJRlI0MEtWRSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1672655882),('HR32s4qyKVCQhcUpbghW950doOz6nDnWsiNFoRA1',NULL,'46.236.65.239','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiV3NZbE5CTE1ucUt0ZkhXVVpZUEx4QnhXcXNtc2pZa0RYeGxOVk5mYyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672623438),('IIzvdHtQ4cdk1ygZb80z2gX1svAJBfZDdS5H8MAK',NULL,'223.177.221.167','Mozilla/5.0 (Linux; Android 12; RMX3392) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Mobile Safari/537.36','YToyOntzOjY6Il90b2tlbiI7czo0MDoiZnltdjdOQXlFSmtiOFZvMm01eTBoSDhrTGJ5M0FkZGR1Q01YTEJRTyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1672665080),('IvMFtTZnvdKUyB5undeLnt7FRND3Q5YV1GlmgO7g',NULL,'162.243.132.7','Mozilla/5.0 zgrab/0.x','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZFRLUkNuTldQUFVld1N3cXB1dXdqVkVKZ2hvTGhIcFhHMXdvUUFSZiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672637330),('iVqf6O4xMhkoYXP2Jsyzmdk5idEo6gqGvzxTdQsh',NULL,'146.0.77.38','','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUGN6cHVpTWN2TFM0Nnh4ekpjRkRuSVhqRWdHNml0S3hhd1g0NDNOQSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTY6Imh0dHA6Ly8xMjcuMC4xLjEiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1672625807),('IzPTb6t7zuxeCRuBR5KMvO9eF2qNuFfAi2elN0dh',NULL,'216.218.206.69','Mozilla/5.0 (X11; Linux x86_64; rv:104.0) Gecko/20100101 Firefox/104.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVVRIODZHaUx1TEN4SmpCeGplTkVPQnplU0NpVHlCQU0yTU1Kd3ptbSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672578944),('Kj1ygEp7aGrSRFESrIpNIbweOQKsbdCL7aaebLL6',114,'49.37.155.65','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','YToxMTp7czo2OiJfdG9rZW4iO3M6NDA6Ik5yU3A2bUNYRHdHOXh6YjJoakFrYXZDR29YbkR3TkR6YlVscHJWTk0iO3M6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjUyOiJodHRwOi8vMTg1LjIwNy4xMDQuNTgvYW5pbWF0aW9uLzl0aC9QaHlzaWNzL1NvdW5kLzY3Ijt9czoxMToiQURNSU5fTE9HSU4iO2I6MTtzOjg6IkFETUlOX0lEIjtpOjY7czo5OiJVU0VSX1RZUEUiO3M6NzoiU3R1ZGVudCI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTE0O3M6OToidXNlcmVtYWlsIjtzOjI0OiJtYWxsaWthYmNkMTIzNEBnbWFpbC5jb20iO3M6MTM6InVzZXJMb2dpblR5cGUiO2k6MjE7czoxMDoidXNlcl9sb2dpbiI7YjoxO3M6NzoiVVNFUl9JRCI7aToxMTQ7fQ==',1672579893),('KZWtF3fViUt9GV9TQ7WaYA99GEhsKijm5myAaXXV',NULL,'142.93.98.223','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWGhLTmxyd3ZMUlBnbFdmeUxKb2VKWWljYjBwVmttcElXcks0ekFHVSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672656400),('l63fB2pU7i9O7KRFf0Nc2zGVaJMavp0ZbKktZRVG',NULL,'209.141.40.109','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:76.0) Gecko/20100101 Firefox/76.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiT2VnZDdlV1p1VURhNDNLaVV4THFnQlEyM0laRzdDWGtoU1pvSm5EWCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672585671),('LCpFnbG8VTZnNP21adHPIuDXzJjAaHPwLcmd5Cmo',NULL,'92.118.39.29','','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMnBpUG44eW5QaGpRS2paQ1Z0ZHRBSngyRnhFRW44WG56VlBRR0JmTSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672598963),('LVBtFxe6sWWeTiBFrfJsvuwqFnvbTmZxr20RHsS1',NULL,'20.199.42.22','Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:77.0) Gecko/20100101 Firefox/77.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTUk2NVFUQUhJRFBLVU11RWV4M3FObVpaYU9SWEhUb3F3SkhlYWlHSSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly8xODUuMjA3LjEwNC41OC8/cGhwaW5mbz0xIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1672618853),('lXY8S8OzQCus5LTlNh6yIa5cDCWIbbWB23oOloKp',NULL,'183.136.225.32','Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:47.0) Gecko/20100101 Firefox/47.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoia0xFUnhNOVF0MURhOUlKM3g1cW93N2c2YVZXQ2dKNDcwRXVQeHVpOSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672660367),('miJCr4kLV1qkasRTzzMgSPe4Eq8WYkEWiaL7uiFb',NULL,'139.59.31.154','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNkFRdWZPU1pGOGN0dm0xSXB4QnRkZ1ZkQ0ltVzBDRVM4azN5bm1zbCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672617397),('MPufr6LGHEkcgpONGOvWTi4C77HKiYaYVvwklPhg',NULL,'92.118.39.29','','YTozOntzOjY6Il90b2tlbiI7czo0MDoid2hxbkJaYThPcHp5U2Q5ZTJkVTVlUmdyS0VsSnpQdWVOdmVpbG9DdiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672633522),('ND6WGKeu4v49VTB3KzJhr0ZrnPG5yAK6Nyx4IqoJ',NULL,'146.0.77.38','curl/7.54.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiV1J5RWpDSWhFcE5MOG1CbjVVSUVqNFczQ3hIaVM1U0lxMEJITUp0NyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly92MjIwMjIwODEyMTY1NTE5NzM3MS5nb29kc3J2LmRlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1672625808),('ofDC5bNxPKCIJKaETrb9nbYYwDQtKbd4JLdNNMEt',NULL,'31.220.1.83','Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNjE2QmpXa3NTclBRZ0NqdXJJeEtaMDBCYVYyMUFMU2lPV2Z3akZyMiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672633146),('omiX3JmjNeb4ndjCCyVFXP7F11QaPApL4QZSPWMh',NULL,'124.123.174.95','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiS0d0eUNLVlRKOTZFZkd5amhoNnd4YXppQkMzb0NXV2pKUW9MV1dPayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9uZXcuYWRpY2xhc3Nlcy5jb20vYW5pbWF0aW9uIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1672653720),('ONPXlNTBL0ZDqr0MXXazooGSL7Mj8x5gMkKayHr3',NULL,'183.136.225.32','Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:47.0) Gecko/20100101 Firefox/47.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoieTdCbWIyQUJMYlFLZDByU2FLN0ZQbURKS3VneTh0dENJYTJTUWVGcyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672577301),('p6ziajXYXRscvX0zGAFxNmPjl77BZYXp8YiwUrz7',NULL,'223.177.221.167','Mozilla/5.0 (Linux; Android 12; RMX3392) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Mobile Safari/537.36','YToyOntzOjY6Il90b2tlbiI7czo0MDoiYlZXdVFYaWdsM2s2SHp3bjBQMnp1Y0Y1V2dKTWplMHNQaWpPT2dGSyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1672665080),('pZD18eq4os4otW9vDLZhrhdOLGC2jFH1VXW8jgjW',NULL,'59.91.246.60','Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiaHhTQnZ6NzBzTlc0YVhGemdyVlhnQzk3Q0tVa0hDVFR4QzNpOXNUYiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672603945),('q43Tb7gPBkhOBylZJmiFHpg8UP6Nj8zI2yMdOtmj',NULL,'223.177.221.167','Mozilla/5.0 (Linux; Android 12; RMX3392) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMkIzb2xRRUxDREl1WU5IbkREQVR0Q2g3b2FnT3dMc0ZWVFZEY2t0QiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHA6Ly9uZXcuYWRpY2xhc3Nlcy5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1672632607),('q6x73ncbyZ1T0M2pRiVFIOwD0sCAoxpjWiNU6rg6',NULL,'167.94.138.60','Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUnRuZHV1ZTdic3pzY3VoUldtWVhNeU9CeTdYMU1USzN2eFhSM1pNOCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672614819),('RaQvp2T7fKzPDtvqHPqgzGypTPzyyLT4bXXQOoGg',NULL,'143.255.242.169','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRnV6aVpZa3YxYXk4TE9lR1R6Wm12SVh2UjNUY21GOTFCVzRWang0NCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672586847),('rBf4pQAbe6URhWfhc6gMBZZEFyV7PALJkzq1RAhA',NULL,'185.118.14.200','Mozilla/5.0 (Windows NT 5.1; rv:9.0.1) Gecko/20100101 Firefox/9.0.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiS21qOE1sUmlneGZ4aFdjZ0dNSGR4T0taSnpkbW9wbENNUGpyeUMzciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672629327),('s3S9M46dPf3QxkWT50dhTtGwWdLA6zumkIeAezpC',NULL,'159.65.178.218','','YTozOntzOjY6Il90b2tlbiI7czo0MDoieDB3RjM1bGtzWkExYmJmN0FPY0NneHhRZUZzanpHdWNCdkZjUHdsciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTY6Imh0dHA6Ly8xMjcuMC4xLjEiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1672587498),('sBaWHtFEB3NrrzFmAtPXAJj03JtIFAcVmHUZ3l31',NULL,'92.118.39.29','','YTozOntzOjY6Il90b2tlbiI7czo0MDoiN3gwNmpudTRYM1VLdHVpQkE0NlVFaU16NHk4OHJ2M2U1QWVFeDdBdyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672658446),('sBx3tpfuBPbEOoDRA9D0b28BwNchIuTxjcn2kkzf',NULL,'103.119.165.63','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/601.7.7 (KHTML, like Gecko) Version/9.1.2 Safari/601.7.7','YTozOntzOjY6Il90b2tlbiI7czo0MDoid3FpSmJGTHpQNGlOV0JZWmlqQUhvcVJJUlZjNU9iQ2VHckZ1SUtyZiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672605009),('sJoXKdqS4dWeEL9LY7IzRG7QAU1gzmMjqXsiEeTa',NULL,'167.94.138.60','','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUTR5N29uMjEzdVVpektCTlFHdXZtbk5ic1BwYUthaTFDaG9PZkpjZiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672614819),('sSKpmPemDSp77msYcv3PiBnILSCehNRwFwNQlZbr',NULL,'157.35.52.76','Mozilla/5.0 (Linux; Android 12; RMX3392) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Mobile Safari/537.36','YToyOntzOjY6Il90b2tlbiI7czo0MDoieUhWa2o2bXlxVnowT0hVNU5OVXBwaUx0dFpkbm9abW5VR1pxSEVSQiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1672655882),('T3L4lyWM0ReuUqiQOT5lJ2C6VyjlIGdDuvFxfXEt',NULL,'31.220.1.83','Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoidFp0bWJnOUtpU1ZFdFdSZTF6Y1pKazU4Rk53N3ZqbkFiTXU2NXNpWiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672595389),('t7OPBctkXuAxFTcIxjQhcwIFHLFAU4zG2ArFZ5G1',NULL,'128.14.136.18','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiOEsxcVhCMVJDcFR6R2hWNWhneXZLSVNON2dyTHRYVlhKREgzUFNTTSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672584119),('UKH3EOSWRm9rD1aY905HxStxy5nVQNznhU0qopcO',NULL,'34.76.96.55','python-requests/2.28.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiN2dOZm95M2hZTmtDTzltTmlMem1lcEQ1MURSQ0JkaHVOcng5dDBpMyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672651546),('uoEYUCYVUHwHHigkdEgKg3QibP8E6qsjZICGqOeN',NULL,'44.192.73.245','SuperBot/4.4.0.60 (Windows XP)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSmRaWGFUSEpHUndnTUxqQmlicExoUjJrWTZnUTB6aFhoUnlPNkRtbCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672672397),('UuWsXFdbtsXkL9ZvoMkVQxzk3IZHsn996wHZjCbb',NULL,'152.32.129.53','','YTozOntzOjY6Il90b2tlbiI7czo0MDoidFB1S3Qxd1diWkFaOEh6UXBoQWd3SGhZMzJ0eHFQZEJyNTh5VDF1QyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672628152),('vKEWmILv6SoduwLbvpLY8bdeAdmzGopneaZvBjGc',NULL,'122.172.84.59','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36','YToyOntzOjY6Il90b2tlbiI7czo0MDoiYzNmY2dHTHVvTlA3Sk1zSnU4eDBFdXdVZnZkUlBLWUN0dFpxa25zRyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1672634580),('vV0Rirq1I6Ayb19YFMRQmsIBTC5wtEnBvSqpv7J7',NULL,'176.102.215.61','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRXpYb0Q5QjZ5NGR1c0dXT1BBOFlVU1NkSWoxd2d4R09ISmJUZ3JYcSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672621800),('wWe1Jp2IqZoSlNasACRYU080gSxhvS0cIw9eZHye',NULL,'151.235.239.202','Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSWpRbW15OWx3cjd4YURrM09hVjlzNVhlaW5RRXdIdE9UaWxSV0VkVyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672598147),('x5kGqEkCTiPEvSqCecoBnE607X4SYnhik0wmnFu4',NULL,'223.177.221.167','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','YToyOntzOjY6Il90b2tlbiI7czo0MDoiYmNzM0Z2Yk1XeGRXbmg5RjQwbGJ4YklOcXl5dmZRNGNsQ1ZCTGNkaSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1672653749),('xBUJTaRN286B5JjiYD86AKecTmsB0S3HTGpZ4KY7',NULL,'122.172.84.59','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVXhGTTZoRzdqSmluTmNVUDZBUU1FYXNUcDJIUVFwTWxJMDQxTXV0TiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9uZXcuYWRpY2xhc3Nlcy5jb20vYW5pbWF0aW9uIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1672662484),('xZbndOrHpN5BMNNr4tND06Ezk7eUlUoJv0iyYCdZ',NULL,'2.227.146.124','','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTFd1a3lwTFNBQmphVW9FczVpZVQwd3ZhQmtxT1BFUkpNcUVxSU5IRyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672640377),('Z1F9HTVhotjf8YwbcebnKuhniXT8JImh3vrxG7ku',NULL,'159.65.159.190','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRDBlOHQ3d2NaR2V3YXVzREJvMzUyTVNnNDNiWk1ycGRXSWtuWW5ZaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672595777),('ZfluvJ48BtSyPOpy5iO4wTWnaZKu7Cy5eKZIxmav',NULL,'78.154.46.222','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVksycExEd0RtSVZaVjJNaWZEVVE5b01kNW1EVElBZ2lnRUJINjNacSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672634036),('ZIPMMKy82sFxNS82gVEHM1uGMt6QfTD2l0lKIisN',NULL,'90.151.171.108','Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0 (+https://best-proxies.ru/faq/#from)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiaUs5U1pJMTZOUWF5S1F0cU55RWg5R1hBNnhsTUxCdTVnb2s3VGFFeCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9pcC5iYWJsb3NvZnQuY29tLz9aNzQ5NTc3MzcxMTNRMT0iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1672640841),('ZpIirv5b0pw99y91BfACRJqONRGIXzifpAeatwdy',NULL,'151.235.239.202','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/601.7.7 (KHTML, like Gecko) Version/9.1.2 Safari/601.7.7','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWEpIUnBWdGZ2RFdvNmZsRzl5c1poS3h6T0NHaUJNYkV4bmRsRW9LciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672598193),('ZqhPK76A60ExJVp2Qdia0JMCtesVQ66rZ8zOc7TO',NULL,'43.135.123.64','\'Mozilla/5.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVkFGZE5BcndFVmlwclVGb21hbWJ3ZG5IQVZhbmFHQ0ZESjBieW5kZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672601052),('ZTpTQk4AF5TJxO2rVgeQq7y9QCRBNdIiezpL5xgU',NULL,'113.108.9.38','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoibXlvemg5cHZZeEZ0eVYzaGxiQm1mRXZmdXcxdzlIbTNVNUFyeE5DdSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xODUuMjA3LjEwNC41OCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672655654);

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `states`
--

INSERT INTO `states` VALUES (1,'Andaman and Nicobar Islands','101',NULL,NULL),(2,'Andhra Pradesh','101',NULL,NULL),(3,'Arunachal Pradesh','101',NULL,NULL),(4,'Assam','101',NULL,NULL),(5,'Bihar','101',NULL,NULL),(6,'Chandigarh','101',NULL,NULL),(7,'Chhattisgarh','101',NULL,NULL),(8,'Dadra and Nagar Haveli','101',NULL,NULL),(9,'Daman and Diu','101',NULL,NULL),(10,'Delhi-NCR','101',NULL,NULL),(11,'Goa','101',NULL,NULL),(12,'Gujarat','101',NULL,NULL),(13,'Haryana','101',NULL,NULL),(14,'Himachal Pradesh','101',NULL,NULL),(15,'Jammu and Kashmir','101',NULL,NULL),(16,'Jharkhand','101',NULL,NULL),(17,'Karnataka','101',NULL,NULL),(18,'Kerala','101',NULL,NULL),(19,'Lakshadweep','101',NULL,NULL),(20,'Madhya Pradesh','101',NULL,NULL),(21,'Maharashtra','101',NULL,NULL),(22,'Manipur','101',NULL,NULL),(23,'Meghalaya','101',NULL,NULL),(24,'Mizoram','101',NULL,NULL),(25,'Nagaland','101',NULL,NULL),(26,'Odisha','101',NULL,NULL),(27,'Pondicherry','101',NULL,NULL),(28,'Punjab','101',NULL,NULL),(29,'Rajasthan','101',NULL,NULL),(30,'Sikkim','101',NULL,NULL),(31,'Tamil Nadu','101',NULL,NULL),(32,'Tripura','101',NULL,NULL),(33,'UP','101',NULL,NULL),(34,'Uttarakhand','101',NULL,NULL),(35,'West Bengal','101',NULL,NULL),(36,'Telangana','101',NULL,NULL);

--
-- Table structure for table `subject_names`
--

CREATE TABLE `subject_names` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject_name` varchar(250) NOT NULL,
  `subject_order` int DEFAULT NULL,
  `status` enum('1','0') DEFAULT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subject_names`
--

INSERT INTO `subject_names` VALUES (8,'Mathematics',3,'1','2022-12-06 08:10:53','2022-12-06 08:10:53'),(7,'Chemistry',2,'1','2022-12-06 08:10:41','2022-12-06 08:10:41'),(6,'Physics',1,'1','2022-12-06 08:10:27','2022-12-12 05:28:06'),(9,'Biology',4,'1','2022-12-06 08:11:04','2022-12-06 08:11:04'),(10,'Science',5,'1','2022-12-06 13:54:31','2022-12-12 05:30:45');

--
-- Table structure for table `subjects`
--

CREATE TABLE `subjects` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `class_id` int NOT NULL,
  `subject` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sub_type_id` int NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subjects`
--

INSERT INTO `subjects` VALUES (32,8,'Physics',6,1,'2022-12-06 08:11:26','2022-12-06 08:11:26'),(33,8,'Chemistry',7,1,'2022-12-06 08:11:36','2022-12-06 08:11:36'),(34,8,'Mathematics',8,1,'2022-12-06 08:11:45','2022-12-06 08:11:45'),(35,8,'Biology',9,1,'2022-12-06 08:12:00','2022-12-06 08:12:00'),(36,9,'Physics',6,1,'2022-12-06 08:12:23','2022-12-06 08:12:23'),(37,9,'Chemistry',7,1,'2022-12-06 08:12:34','2022-12-06 08:12:34'),(38,9,'Mathematics',8,1,'2022-12-06 08:12:44','2022-12-06 08:12:44'),(39,9,'Biology',9,1,'2022-12-06 08:12:59','2022-12-06 08:12:59'),(40,10,'Physics',6,1,'2022-12-06 08:13:16','2022-12-06 08:13:16'),(41,10,'Chemistry',7,1,'2022-12-06 08:13:25','2022-12-06 08:13:25'),(42,10,'Mathematics',8,1,'2022-12-06 08:13:36','2022-12-06 08:13:36'),(44,10,'Biology',9,1,'2022-12-06 08:21:54','2022-12-06 08:21:54'),(45,11,'Physics',6,1,'2022-12-06 08:22:30','2022-12-06 08:22:30'),(46,11,'Chemistry',7,1,'2022-12-06 08:22:42','2022-12-06 08:22:42'),(47,11,'Mathematics',8,1,'2022-12-06 08:22:53','2022-12-06 08:22:53'),(48,11,'Biology',9,1,'2022-12-06 08:23:05','2022-12-06 08:23:05'),(49,12,'Physics',6,1,'2022-12-06 08:23:16','2022-12-06 08:23:16'),(50,12,'Chemistry',7,1,'2022-12-06 08:23:27','2022-12-06 08:23:27'),(51,12,'Mathematics',8,1,'2022-12-06 08:23:40','2022-12-06 08:23:40'),(52,12,'Biology',9,0,'2022-12-06 08:23:50','2022-12-12 15:10:15'),(56,8,'Science',10,0,'2022-12-07 09:19:07','2022-12-12 04:34:31'),(57,9,'Science',10,0,'2022-12-10 14:58:55','2022-12-14 04:09:17');

--
-- Table structure for table `videos`
--

CREATE TABLE `videos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `video_name` varchar(250) NOT NULL,
  `video_order` int NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `videos`
--



