-- https://www.phpmyadmin.net/
--

START TRANSACTION;



-- --------------------------------------------------------

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

CREATE TABLE `b_b_schools` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `country_id` int(11) NOT NULL,
  `state_id` int(11) NOT NULL,
  `district_id` int(11) NOT NULL,
  `district_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `b_b_schools` (`id`, `country_id`, `state_id`, `district_id`, `district_code`, `status`, `created_at`, `updated_at`) VALUES
(1, 101, 4, 676, '222', 1, '2022-05-03 08:53:56', '2022-06-24 07:45:52'),
(3, 101, 2, 571, '234', 1, '2022-05-12 22:49:39', '2022-05-12 22:49:39'),
(5, 101, 2, 678, '2225', 1, '2022-05-21 11:00:03', '2022-05-21 11:00:03'),
(6, 101, 5, 679, '333', 1, '2022-05-21 12:48:40', '2022-05-21 12:48:40');

-- --------------------------------------------------------

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

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

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

INSERT INTO `cart` (`id`, `user_id`, `user_type`, `qty`, `product_id`, `product_attr_id`, `added_on`) VALUES
(3, 0, 'Not-Reg', 1, 1, 2, '2021-08-12 12:03:41'),
(5, 1, 'Not-Reg', 1, 2, 3, '2021-08-18 06:49:37');

-- --------------------------------------------------------

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

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `catproducts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` int(11) NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `brand` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_desc` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `desc` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `keywords` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `technical_specification` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `uses` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `warranty` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `chapters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `chapter` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `chapter_order` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `chapters` (`id`, `chapter`, `chapter_order`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Rational Numbers', 1, 0, '2022-03-09 08:38:31', '2022-05-29 09:29:36'),
(2, 'Synthetic Fibres And Plastics', 0, 1, '2022-03-10 05:49:58', '2022-03-10 05:49:58'),
(3, 'Relations and Functions', 0, 1, '2022-03-10 05:50:14', '2022-03-10 05:50:14'),
(4, 'Knowing your Numbers', 0, 1, '2022-03-10 05:50:25', '2022-04-16 01:50:56'),
(5, 'Sets', 1, 1, '2022-03-10 05:50:33', '2022-04-16 01:51:11'),
(6, 'Real Numbers', 0, 1, '2022-03-10 05:50:41', '2022-03-10 05:50:41'),
(7, 'Chemical Reactions and Equations', 0, 1, '2022-03-10 05:50:49', '2022-03-10 05:50:49'),
(8, 'Light-Reflection and Refraction', 0, 1, '2022-03-10 05:50:57', '2022-03-10 05:50:57'),
(9, 'Matter In Our Surroundings', 0, 1, '2022-03-10 05:51:09', '2022-03-10 05:51:09'),
(10, 'Motion', 0, 1, '2022-03-10 05:51:21', '2022-03-10 05:51:21'),
(11, 'Force And Pressure', 0, 1, '2022-03-10 05:51:29', '2022-03-10 05:51:29'),
(12, 'Number Systems', 0, 1, '2022-03-10 05:51:36', '2022-03-10 05:51:36'),
(13, 'Reproduction In Organisms', 0, 1, '2022-03-10 05:51:46', '2022-03-10 05:51:46'),
(14, 'Crop Production and Management', 0, 1, '2022-03-10 05:51:55', '2022-03-10 05:51:55'),
(15, 'The Fundamental Unit of Life', 0, 1, '2022-03-10 05:52:03', '2022-03-10 05:52:03'),
(16, 'Some Basic Concept of Chemistry', 0, 1, '2022-03-10 05:52:11', '2022-03-10 05:52:11'),
(17, 'Solid State', 0, 1, '2022-03-10 05:52:19', '2022-03-10 05:52:19'),
(18, 'sample test', 33, 1, '2022-04-08 04:41:07', '2022-04-08 04:41:07'),
(20, 'Sample chapter', 33, 1, '2022-05-29 09:33:36', '2022-05-29 09:33:36'),
(21, 'chapter test sample', 222, 1, '2022-05-30 03:23:25', '2022-05-30 03:23:25');

-- --------------------------------------------------------

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

CREATE TABLE `class_names` (
  `id` int(11) NOT NULL,
  `class_name` varchar(150) NOT NULL,
  `class_slug` varchar(150) NOT NULL,
  `class_order` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `class_names` (`id`, `class_name`, `class_slug`, `class_order`, `status`, `created_at`, `updated_at`) VALUES
(2, '6th', '6', 1, 0, '2022-07-26 10:55:49', '2022-03-31 13:51:39'),
(3, '7th', '7', 2, 0, '2022-07-26 10:55:52', '2022-03-30 13:26:29'),
(4, '8th', '8', 3, 1, '2022-03-30 13:26:35', '2022-03-30 13:26:35'),
(5, '9th', '9', 4, 1, '2022-03-30 13:26:43', '2022-03-30 13:26:43'),
(6, '10th', '10', 5, 1, '2022-03-30 13:26:49', '2022-03-30 13:26:49'),
(7, '11th', '11', 6, 1, '2022-03-30 13:26:57', '2022-03-30 13:26:57'),
(8, '12th', '12', 7, 1, '2022-04-16 06:54:45', '2022-04-16 06:54:45');

-- --------------------------------------------------------

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

CREATE TABLE `content_uploads` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `class_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `chapter_order` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `chapter_id` int(11) NOT NULL,
  `syllabus` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lession` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `full_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `level` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_html` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_folder` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alternate_content_html` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `alternate_content_folder` text 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `content_uploads` (`id`, `class_id`, `subject_id`, `chapter_order`, `chapter_id`, `syllabus`, `lession`, `name`, `description`, `full_description`, `level`, `content_html`, `content_folder`, `alternate_content_html`, `alternate_content_folder`, `status`, `created_at`, `updated_at`) VALUES
(9, 4, 3, '1', 3, 'Force', NULL, 'Form', 'dfgdfgdf', 'gdgdgf dgfdf gdf g', '2', 'sample2.html', 'upload/8th/Mathematics/Relations and Functions/Form', '', '', 1, '2022-05-20 12:21:17', '2022-07-27 06:55:06'),
(10, 6, 3, '33', 5, 'Formulas', NULL, 'Form99', 'dfd fgd fgdf', 'd fg dgdgdfg df', '3', 'sample2.html', 'upload/10th/Mathematics/Sets/Form99', '', '', 1, '2022-05-21 09:03:56', '2022-05-21 09:03:56'),
(12, 3, 2, '222', 11, 'Elements', NULL, 'Elements', 'This is a chemistry subject', 'This is a chemistry subject This is a chemistry subject', '3', 'sample1.html', 'upload/7th/Chemistry/Force And Pressure/Elements', 'E:\\xampp\\tmp\\phpF740.tmp', 'upload/7th/Chemistry/Force And Pressure/Elements-alternate', 1, '2022-07-04 01:09:51', '2022-07-04 01:09:51'),
(13, 3, 4, '99', 21, 'Cells', NULL, 'cell', 'This a biology subject Content', 'This a biology subject Content', '4', 'sample1.html', 'upload/7th/Biology/chapter test sample/cell', 'E:\\xampp\\tmp\\php103B.tmp', 'upload/7th/Biology/chapter test sample/cell-alternate', 1, '2022-07-04 01:17:36', '2022-07-04 01:17:36'),
(14, 4, 7, '23', 20, 'vocabulary', NULL, 'vocabulary', 'This is the english vocabulary', 'This is the english vocabulary chapter', '2', 'sample1.html', 'upload/8th/English/Sample chapter/vocabulary', 'E:\\xampp\\tmp\\php4AB9.tmp', 'upload/8th/English/Sample chapter/vocabulary-alternate', 1, '2022-07-04 01:28:46', '2022-07-04 01:28:46'),
(15, 4, 3, '44', 4, 'Knowing', NULL, 'knowing', 'This  is for knowing your numbers', 'This  is for knowing your numbers', '3', 'sample2.html', 'upload/8th/Mathematics/Knowing your Numbers/knowing', 'sample1.html', 'upload/8th/Mathematics/Knowing your Numbers/knowing-alternate', 1, '2022-07-27 06:53:52', '2022-07-27 06:53:52'),
(16, 4, 3, '22', 4, 'Numbers', NULL, 'numbers', 'sdfsdfsdf', 'sdfsdf sdf sdfsdf', '4', 'sample1.html', 'upload/8th/Mathematics/Knowing your Numbers/numbers', 'sample2.html', 'upload/8th/Mathematics/Knowing your Numbers/numbers-alternate', 1, '2022-07-27 07:35:08', '2022-07-27 07:35:08');

-- --------------------------------------------------------

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

CREATE TABLE `countries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sortname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `countries` (`id`, `sortname`, `name`, `status`, `created_at`, `updated_at`) 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(20) UNSIGNED NOT NULL,
  `district_title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `district_description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `district_status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `districts` (`id`, `district_title`, `state_id`, `district_description`, `district_status`, `created_at`, `updated_at`) 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');

-- --------------------------------------------------------

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

CREATE TABLE `duration` (
  `id` int(11) NOT NULL,
  `duration_name` varchar(250) NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_on` datetime NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `duration` (`id`, `duration_name`, `created_on`, `updated_on`, `status`) 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(20) UNSIGNED NOT NULL,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `home_banners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `btn_txt` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `btn_link` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `levels` (
  `id` int(11) NOT NULL,
  `level_name` varchar(250) NOT NULL,
  `level_order` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `levels` (`id`, `level_name`, `level_order`, `status`, `created_at`, `updated_at`) VALUES
(2, 'For Board', 1, 1, '2022-04-18 06:00:25', '2022-04-18 11:30:25'),
(3, 'Revision', 4, 1, '2022-04-18 08:14:26', '2022-04-18 13:44:26'),
(4, 'Foundation', 2, 1, '2022-04-18 08:14:52', '2022-04-18 13:44:52'),
(5, 'Problems', 3, 1, '2022-04-18 08:15:03', '2022-04-18 13:45:03');

-- --------------------------------------------------------

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

CREATE TABLE `login_users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `duration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_range` varchar(100) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `login_users` (`id`, `name`, `description`, `duration`, `date_range`, `status`, `created_at`, `updated_at`) VALUES
(8, 'Teacher P', 'Physics teacher upto 10th class', '5', '06/01/2022 - 07/30/2022', 1, '2022-04-24 08:01:18', '2022-06-15 10:24:30'),
(9, 'Teacher_c', 'Chemistry teacher upto 10th class', '2', '', 1, '2022-04-24 08:04:34', '2022-05-29 06:27:39'),
(10, 'sample Test', 'Chemistry teacher upto 10th class', '2', '', 1, '2022-04-27 02:05:12', '2022-04-27 02:05:12'),
(11, 'Teacher_P', 'This is a sample test', '2', '', 1, '2022-04-30 10:34:35', '2022-04-30 10:34:35'),
(12, 'sfsf', 'Physics teacher upto 10th class', '2', '', 1, '2022-04-30 12:28:26', '2022-04-30 12:28:26'),
(13, 'Tutions', 'Tutions for 6th to 9th PCMB', '1', '', 1, '2022-05-12 22:39:34', '2022-05-12 22:39:34'),
(14, 'vijaya physics', 'This is a sample login test', '5', '06/06/2022 - 06/06/2022', 1, '2022-05-28 11:07:36', '2022-06-06 07:35:44');

-- --------------------------------------------------------

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

CREATE TABLE `login_user_classes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `login_userid` bigint(20) UNSIGNED NOT NULL,
  `class_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `login_user_classes` (`id`, `login_userid`, `class_id`, `created_at`, `updated_at`) VALUES
(139, 9, '3', '2022-04-24 08:06:15', '2022-04-24 08:06:15'),
(141, 9, '4', '2022-04-24 08:06:15', '2022-04-24 08:06:15'),
(175, 11, '2', '2022-04-30 10:34:35', '2022-04-30 10:34:35'),
(176, 11, '3', '2022-04-30 10:34:35', '2022-04-30 10:34:35'),
(216, 10, '2', '2022-04-30 12:26:27', '2022-04-30 12:26:27'),
(217, 10, '3', '2022-04-30 12:26:27', '2022-04-30 12:26:27'),
(218, 10, '4', '2022-04-30 12:26:27', '2022-04-30 12:26:27'),
(240, 12, '2', '2022-04-30 12:54:28', '2022-04-30 12:54:28'),
(241, 12, '3', '2022-04-30 12:54:28', '2022-04-30 12:54:28'),
(242, 12, '7', '2022-04-30 12:54:28', '2022-04-30 12:54:28'),
(243, 12, '8', '2022-04-30 12:54:28', '2022-04-30 12:54:28'),
(244, 13, '2', '2022-05-12 22:39:34', '2022-05-12 22:39:34'),
(245, 13, '3', '2022-05-12 22:39:34', '2022-05-12 22:39:34'),
(246, 13, '4', '2022-05-12 22:39:34', '2022-05-12 22:39:34'),
(247, 13, '5', '2022-05-12 22:39:34', '2022-05-12 22:39:34'),
(269, 14, '2', '2022-06-06 07:35:45', '2022-06-06 07:35:45'),
(270, 14, '3', '2022-06-06 07:35:45', '2022-06-06 07:35:45'),
(271, 14, '4', '2022-06-06 07:35:45', '2022-06-06 07:35:45'),
(272, 14, '5', '2022-06-06 07:35:45', '2022-06-06 07:35:45'),
(273, 14, '6', '2022-06-06 07:35:45', '2022-06-06 07:35:45'),
(274, 14, '7', '2022-06-06 07:35:45', '2022-06-06 07:35:45'),
(275, 14, '8', '2022-06-06 07:35:45', '2022-06-06 07:35:45'),
(280, 8, '3', '2022-06-15 10:24:30', '2022-06-15 10:24:30'),
(281, 8, '4', '2022-06-15 10:24:30', '2022-06-15 10:24:30');

-- --------------------------------------------------------

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

CREATE TABLE `login_user_problems` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `login_userid` bigint(20) UNSIGNED NOT NULL,
  `problem_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `login_user_problems` (`id`, `login_userid`, `problem_id`, `created_at`, `updated_at`) VALUES
(1304, 9, '2', '2022-04-24 08:06:16', '2022-04-24 08:06:16'),
(1305, 9, '5', '2022-04-24 08:06:16', '2022-04-24 08:06:16'),
(1316, 11, '3', '2022-04-30 10:34:36', '2022-04-30 10:34:36'),
(1340, 10, '2', '2022-04-30 12:26:27', '2022-04-30 12:26:27'),
(1347, 12, '2', '2022-04-30 12:54:29', '2022-04-30 12:54:29'),
(1348, 13, '2', '2022-05-12 22:39:35', '2022-05-12 22:39:35'),
(1349, 13, '3', '2022-05-12 22:39:35', '2022-05-12 22:39:35'),
(1350, 13, '4', '2022-05-12 22:39:35', '2022-05-12 22:39:35'),
(1363, 14, '2', '2022-06-06 07:35:46', '2022-06-06 07:35:46'),
(1364, 14, '3', '2022-06-06 07:35:46', '2022-06-06 07:35:46'),
(1365, 14, '4', '2022-06-06 07:35:46', '2022-06-06 07:35:46'),
(1366, 14, '5', '2022-06-06 07:35:46', '2022-06-06 07:35:46'),
(1369, 8, '2', '2022-06-15 10:24:30', '2022-06-15 10:24:30'),
(1370, 8, '4', '2022-06-15 10:24:30', '2022-06-15 10:24:30');

-- --------------------------------------------------------

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

CREATE TABLE `login_user_subjects` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `login_userid` bigint(20) UNSIGNED NOT NULL,
  `subject_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `login_user_subjects` (`id`, `login_userid`, `subject_id`, `created_at`, `updated_at`) VALUES
(700, 9, '2', '2022-04-24 08:06:15', '2022-04-24 08:06:15'),
(712, 11, '1', '2022-04-30 10:34:35', '2022-04-30 10:34:35'),
(713, 11, '2', '2022-04-30 10:34:35', '2022-04-30 10:34:35'),
(751, 10, '1', '2022-04-30 12:26:27', '2022-04-30 12:26:27'),
(752, 10, '2', '2022-04-30 12:26:27', '2022-04-30 12:26:27'),
(753, 10, '2', '2022-04-30 12:26:27', '2022-04-30 12:26:27'),
(772, 12, '1', '2022-04-30 12:54:29', '2022-04-30 12:54:29'),
(773, 12, '2', '2022-04-30 12:54:29', '2022-04-30 12:54:29'),
(774, 12, '3', '2022-04-30 12:54:29', '2022-04-30 12:54:29'),
(775, 13, '1', '2022-05-12 22:39:34', '2022-05-12 22:39:34'),
(776, 13, '2', '2022-05-12 22:39:34', '2022-05-12 22:39:34'),
(777, 13, '3', '2022-05-12 22:39:34', '2022-05-12 22:39:34'),
(778, 13, '4', '2022-05-12 22:39:34', '2022-05-12 22:39:34'),
(795, 14, '1', '2022-06-06 07:35:45', '2022-06-06 07:35:45'),
(796, 14, '2', '2022-06-06 07:35:45', '2022-06-06 07:35:45'),
(797, 14, '3', '2022-06-06 07:35:45', '2022-06-06 07:35:45'),
(798, 14, '4', '2022-06-06 07:35:45', '2022-06-06 07:35:45'),
(799, 14, '5', '2022-06-06 07:35:45', '2022-06-06 07:35:45'),
(800, 14, '6', '2022-06-06 07:35:45', '2022-06-06 07:35:45'),
(801, 14, '7', '2022-06-06 07:35:45', '2022-06-06 07:35:45'),
(803, 8, '1', '2022-06-15 10:24:30', '2022-06-15 10:24:30');

-- --------------------------------------------------------

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

CREATE TABLE `login_user_videos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `login_userid` bigint(20) UNSIGNED NOT NULL,
  `video_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `login_user_videos` (`id`, `login_userid`, `video_id`, `created_at`, `updated_at`) VALUES
(1354, 9, '1', '2022-04-24 08:06:16', '2022-04-24 08:06:16'),
(1355, 9, '3', '2022-04-24 08:06:16', '2022-04-24 08:06:16'),
(1366, 11, '1', '2022-04-30 10:34:35', '2022-04-30 10:34:35'),
(1390, 10, '1', '2022-04-30 12:26:27', '2022-04-30 12:26:27'),
(1397, 12, '1', '2022-04-30 12:54:29', '2022-04-30 12:54:29'),
(1398, 13, '1', '2022-05-12 22:39:35', '2022-05-12 22:39:35'),
(1399, 13, '2', '2022-05-12 22:39:35', '2022-05-12 22:39:35'),
(1400, 13, '3', '2022-05-12 22:39:35', '2022-05-12 22:39:35'),
(1411, 14, '1', '2022-06-06 07:35:45', '2022-06-06 07:35:45'),
(1412, 14, '2', '2022-06-06 07:35:45', '2022-06-06 07:35:45'),
(1413, 14, '3', '2022-06-06 07:35:45', '2022-06-06 07:35:45'),
(1416, 8, '1', '2022-06-15 10:24:30', '2022-06-15 10:24:30'),
(1417, 8, '2', '2022-06-15 10:24:30', '2022-06-15 10:24:30');

-- --------------------------------------------------------

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) 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);

-- --------------------------------------------------------

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

CREATE TABLE `problems` (
  `id` int(11) NOT NULL,
  `problem_name` varchar(250) NOT NULL,
  `problem_order` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `problems` (`id`, `problem_name`, `problem_order`, `status`, `created_at`, `updated_at`) VALUES
(2, 'Board PP', 1, 1, '2022-06-06 10:43:36', '2022-06-06 10:43:36'),
(3, 'Advanced PP', 2, 1, '2022-04-18 06:36:35', '2022-04-18 12:06:35'),
(4, 'Chapter-Tests', 3, 1, '2022-04-18 06:36:59', '2022-04-18 12:06:59'),
(5, 'Cumulative-Tests', 4, 1, '2022-04-18 06:37:10', '2022-04-18 12:07:10');

-- --------------------------------------------------------

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

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(500) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

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

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

INSERT INTO `products_attr` (`id`, `products_id`, `sku`, `attr_image`, `mrp`, `price`, `qty`, `size_id`, `color_id`) 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 `product_images`
--

CREATE TABLE `product_images` (
  `id` int(11) NOT NULL,
  `products_id` int(11) NOT NULL,
  `images` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

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

-- --------------------------------------------------------

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

CREATE TABLE `schools` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `school_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `school_district_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `school_amount` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `school_charges` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `school_code` varchar(191) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `schools` (`id`, `school_name`, `school_district_code`, `school_amount`, `school_charges`, `school_code`, `status`, `created_at`, `updated_at`) VALUES
(5, 'Narayana Techno School', '222', NULL, NULL, '551174', 1, '2022-05-12 23:10:02', '2022-06-24 08:14:59'),
(6, 'Brilliant Grammer Schools', '222', NULL, NULL, '122882', 1, '2022-05-21 11:22:10', '2022-05-21 11:22:10'),
(7, 'Chaitanya Techno Schools', '2225', NULL, NULL, '217815', 1, '2022-05-21 11:22:58', '2022-05-21 11:22:58');

-- --------------------------------------------------------

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

CREATE TABLE `school_principals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `school_id` int(11) NOT NULL,
  `principal_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `whatsapp_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `principal_amount` varchar(191) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `school_principals` (`id`, `school_id`, `principal_name`, `phone_number`, `whatsapp_number`, `principal_amount`, `status`, `created_at`, `updated_at`) VALUES
(1, 5, 'Harish Sir', '8978023342', '897802334', '20', 1, '2022-05-08 05:45:46', '2022-05-12 23:05:29'),
(3, 6, 'Harish Sir', '8978023342', '99999999', NULL, 1, '2022-05-12 23:08:16', '2022-05-12 23:08:16');

-- --------------------------------------------------------

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

CREATE TABLE `states` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `states` (`id`, `name`, `country_id`, `created_at`, `updated_at`) 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 `subjects`
--

CREATE TABLE `subjects` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `class_id` int(11) NOT NULL,
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_order` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `subjects` (`id`, `class_id`, `subject`, `subject_order`, `status`, `created_at`, `updated_at`) VALUES
(1, 4, 'Physics', 0, 1, '2022-03-09 08:57:36', '2022-03-31 08:21:55'),
(2, 4, 'Chemistry', 0, 1, '2022-03-09 09:17:07', '2022-03-09 09:17:07'),
(3, 4, 'Mathematics', 0, 1, '2022-03-10 05:00:44', '2022-03-10 05:00:44'),
(4, 4, 'Biology', 0, 1, '2022-03-10 05:00:57', '2022-03-10 05:00:57'),
(5, 5, 'Physics', 0, 1, '2022-03-10 05:01:07', '2022-03-10 05:01:07'),
(6, 5, 'Chemistry', 0, 1, '2022-03-10 05:01:20', '2022-03-10 05:01:20'),
(7, 5, 'Biology', 0, 1, '2022-03-10 05:01:32', '2022-03-10 05:01:32'),
(11, 6, 'Physics', 0, 1, '2022-07-27 08:27:50', '2022-07-27 08:27:50'),
(12, 6, 'Chemistry', 0, 1, '2022-07-27 08:27:50', '2022-07-27 08:27:50'),
(13, 6, 'Biology', 0, 1, '2022-07-27 08:27:50', '2022-07-27 08:27:50');

-- --------------------------------------------------------

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

CREATE TABLE `videos` (
  `id` int(11) NOT NULL,
  `video_name` varchar(250) NOT NULL,
  `video_order` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `videos` (`id`, `video_name`, `video_order`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Board', 1, 1, '2022-04-18 06:54:09', '2022-04-18 12:24:09'),
(2, 'Advanced', 2, 1, '2022-04-19 15:27:07', '0000-00-00 00:00:00'),
(3, 'Prob-Video', 3, 1, '2022-04-19 15:27:07', '0000-00-00 00:00:00');

--
-- Indexes for table `b_b_schools`
--
ALTER TABLE `b_b_schools`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cart`
--
ALTER TABLE `cart`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `catproducts`
--
ALTER TABLE `catproducts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `chapters`
--
ALTER TABLE `chapters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `class_names`
--
ALTER TABLE `class_names`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `content_uploads`
--
ALTER TABLE `content_uploads`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `districts`
--
ALTER TABLE `districts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `duration`
--
ALTER TABLE `duration`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `home_banners`
--
ALTER TABLE `home_banners`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `levels`
--
ALTER TABLE `levels`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `login_users`
--
ALTER TABLE `login_users`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `login_user_classes`
--
ALTER TABLE `login_user_classes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `login_user_classes_login_userid_foreign` (`login_userid`);

--
-- Indexes for table `login_user_problems`
--
ALTER TABLE `login_user_problems`
  ADD PRIMARY KEY (`id`),
  ADD KEY `login_user_problems_login_userid_foreign` (`login_userid`);

--
-- Indexes for table `login_user_subjects`
--
ALTER TABLE `login_user_subjects`
  ADD PRIMARY KEY (`id`),
  ADD KEY `login_user_subjects_login_userid_foreign` (`login_userid`);

--
-- Indexes for table `login_user_videos`
--
ALTER TABLE `login_user_videos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `login_user_videos_login_userid_foreign` (`login_userid`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `problems`
--
ALTER TABLE `problems`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `products_attr`
--
ALTER TABLE `products_attr`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_images`
--
ALTER TABLE `product_images`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `schools`
--
ALTER TABLE `schools`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `school_principals`
--
ALTER TABLE `school_principals`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `states`
--
ALTER TABLE `states`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `subjects`
--
ALTER TABLE `subjects`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `videos`
--
ALTER TABLE `videos`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for table `b_b_schools`
--
ALTER TABLE `b_b_schools`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `cart`
--
ALTER TABLE `cart`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `catproducts`
--
ALTER TABLE `catproducts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `chapters`
--
ALTER TABLE `chapters`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `class_names`
--
ALTER TABLE `class_names`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `content_uploads`
--
ALTER TABLE `content_uploads`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=247;

--
-- AUTO_INCREMENT for table `districts`
--
ALTER TABLE `districts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=680;

--
-- AUTO_INCREMENT for table `duration`
--
ALTER TABLE `duration`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `home_banners`
--
ALTER TABLE `home_banners`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `levels`
--
ALTER TABLE `levels`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `login_users`
--
ALTER TABLE `login_users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `login_user_classes`
--
ALTER TABLE `login_user_classes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=282;

--
-- AUTO_INCREMENT for table `login_user_problems`
--
ALTER TABLE `login_user_problems`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1371;

--
-- AUTO_INCREMENT for table `login_user_subjects`
--
ALTER TABLE `login_user_subjects`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=804;

--
-- AUTO_INCREMENT for table `login_user_videos`
--
ALTER TABLE `login_user_videos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1418;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;

--
-- AUTO_INCREMENT for table `problems`
--
ALTER TABLE `problems`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `products_attr`
--
ALTER TABLE `products_attr`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `product_images`
--
ALTER TABLE `product_images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `schools`
--
ALTER TABLE `schools`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `school_principals`
--
ALTER TABLE `school_principals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `states`
--
ALTER TABLE `states`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `subjects`
--
ALTER TABLE `subjects`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `videos`
--
ALTER TABLE `videos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `login_user_classes`
--
ALTER TABLE `login_user_classes`
  ADD CONSTRAINT `login_user_classes_login_userid_foreign` FOREIGN KEY (`login_userid`) REFERENCES `login_users` (`id`);

--
-- Constraints for table `login_user_problems`
--
ALTER TABLE `login_user_problems`
  ADD CONSTRAINT `login_user_problems_login_userid_foreign` FOREIGN KEY (`login_userid`) REFERENCES `login_users` (`id`);

--
-- Constraints for table `login_user_subjects`
--
ALTER TABLE `login_user_subjects`
  ADD CONSTRAINT `login_user_subjects_login_userid_foreign` FOREIGN KEY (`login_userid`) REFERENCES `login_users` (`id`);

--
-- Constraints for table `login_user_videos`
--
ALTER TABLE `login_user_videos`
  ADD CONSTRAINT `login_user_videos_login_userid_foreign` FOREIGN KEY (`login_userid`) REFERENCES `login_users` (`id`);
COMMIT;

