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

START TRANSACTION;



--
-- Database: `db_ocpp`
--

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

--
-- Table structure for table `activities`
--

CREATE TABLE `activities` (
  `id` int(11) NOT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `module` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `unique_id` int(11) DEFAULT NULL,
  `secondary_id` int(11) DEFAULT NULL,
  `activity` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ip` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `activities`
--

INSERT INTO `activities` (`id`, `user_id`, `module`, `unique_id`, `secondary_id`, `activity`, `ip`, `created_at`, `updated_at`) VALUES
(1, 1, 'login', NULL, NULL, 'activity_logged_in', '192.168.100.171', '2019-02-12 05:21:54', '2019-02-12 05:21:54'),
(2, 1, 'vehiclemodel', NULL, NULL, 'activity_updated', '192.168.100.171', '2019-02-12 06:08:58', '2019-02-12 06:08:58'),
(3, 1, 'logout', NULL, NULL, 'activity_logged_out', '192.168.100.171', '2019-02-12 08:13:07', '2019-02-12 08:13:07'),
(4, 1, 'login', NULL, NULL, 'activity_logged_in', '192.168.100.171', '2019-02-12 08:13:20', '2019-02-12 08:13:20'),
(5, 1, 'logout', NULL, NULL, 'activity_logged_out', '192.168.100.171', '2019-02-12 08:27:01', '2019-02-12 08:27:01'),
(6, 1, 'login', NULL, NULL, 'activity_logged_in', '192.168.100.171', '2019-02-12 08:27:06', '2019-02-12 08:27:06'),
(7, 1, 'login', NULL, NULL, 'activity_logged_in', '192.168.100.171', '2019-02-12 09:33:02', '2019-02-12 09:33:02'),
(8, 1, 'logout', NULL, NULL, 'activity_logged_out', '192.168.100.171', '2019-02-12 10:24:11', '2019-02-12 10:24:11'),
(9, 1, 'login', NULL, NULL, 'activity_logged_in', '192.168.100.171', '2019-02-12 10:24:16', '2019-02-12 10:24:16'),
(10, 1, 'logout', NULL, NULL, 'activity_logged_out', '192.168.100.171', '2019-02-12 10:24:51', '2019-02-12 10:24:51'),
(11, 1, 'login', NULL, NULL, 'activity_logged_in', '192.168.100.171', '2019-02-12 10:24:57', '2019-02-12 10:24:57'),
(12, 1, 'logout', NULL, NULL, 'activity_logged_out', '192.168.100.171', '2019-02-12 10:25:16', '2019-02-12 10:25:16'),
(13, 1, 'login', NULL, NULL, 'activity_logged_in', '192.168.100.171', '2019-02-12 10:25:24', '2019-02-12 10:25:24'),
(14, 1, 'logout', NULL, NULL, 'activity_logged_out', '192.168.100.171', '2019-02-12 10:25:54', '2019-02-12 10:25:54'),
(15, 8, 'Stations', NULL, NULL, 'activity_added', '192.168.100.171', '2019-02-12 10:41:43', '2019-02-12 10:41:43'),
(16, 8, 'stations', NULL, NULL, 'activity_updated', '192.168.100.171', '2019-02-12 10:52:18', '2019-02-12 10:52:18'),
(17, 8, 'stations', NULL, NULL, 'activity_updated', '192.168.100.171', '2019-02-12 10:52:39', '2019-02-12 10:52:39'),
(18, 1, 'login', NULL, NULL, 'activity_logged_in', '192.168.100.171', '2019-02-12 13:32:36', '2019-02-12 13:32:36'),
(19, 1, 'logout', NULL, NULL, 'activity_logged_out', '192.168.100.171', '2019-02-12 13:44:43', '2019-02-12 13:44:43'),
(20, 10, 'Stations', NULL, NULL, 'activity_added', '192.168.100.171', '2019-02-12 13:53:39', '2019-02-12 13:53:39'),
(21, 1, 'login', NULL, NULL, 'activity_logged_in', '192.168.100.171', '2019-02-12 13:53:54', '2019-02-12 13:53:54'),
(22, 1, 'stations', NULL, NULL, 'activity_updated', '192.168.100.171', '2019-02-12 13:56:44', '2019-02-12 13:56:44'),
(23, 1, 'stations', NULL, NULL, 'activity_updated', '192.168.100.171', '2019-02-12 13:56:56', '2019-02-12 13:56:56'),
(24, 1, 'stations', NULL, NULL, 'activity_updated', '192.168.100.171', '2019-02-12 13:57:06', '2019-02-12 13:57:06'),
(25, 1, 'stations', NULL, NULL, 'activity_updated', '192.168.100.171', '2019-02-12 13:57:23', '2019-02-12 13:57:23'),
(26, 1, 'logout', NULL, NULL, 'activity_logged_out', '192.168.100.171', '2019-02-12 14:11:40', '2019-02-12 14:11:40'),
(27, 1, 'login', NULL, NULL, 'activity_logged_in', '::1', '2019-02-13 05:32:55', '2019-02-13 05:32:55'),
(28, 1, 'logout', NULL, NULL, 'activity_logged_out', '::1', '2019-02-13 06:07:47', '2019-02-13 06:07:47'),
(29, 1, 'login', NULL, NULL, 'activity_logged_in', '::1', '2019-02-13 06:09:14', '2019-02-13 06:09:14'),
(30, 1, 'login', NULL, NULL, 'activity_logged_in', '192.168.100.171', '2019-02-13 06:10:39', '2019-02-13 06:10:39'),
(31, 1, 'role', 13, NULL, 'activity_updated', '192.168.100.171', '2019-02-13 06:11:15', '2019-02-13 06:11:15'),
(32, 1, 'login', NULL, NULL, 'activity_logged_in', '::1', '2019-02-13 08:23:31', '2019-02-13 08:23:31'),
(33, 1, 'login', NULL, NULL, 'activity_logged_in', '192.168.100.171', '2019-02-14 04:03:40', '2019-02-14 04:03:40'),
(34, 1, 'Stations', NULL, NULL, 'activity_added', '192.168.100.171', '2019-02-14 05:27:41', '2019-02-14 05:27:41'),
(35, 1, 'Stations', NULL, NULL, 'activity_added', '192.168.100.171', '2019-02-14 05:29:53', '2019-02-14 05:29:53'),
(36, 1, 'stations', NULL, NULL, 'activity_updated', '192.168.100.171', '2019-02-14 05:55:28', '2019-02-14 05:55:28'),
(37, 1, 'stations', NULL, NULL, 'activity_updated', '192.168.100.171', '2019-02-14 05:55:49', '2019-02-14 05:55:49'),
(38, 1, 'logout', NULL, NULL, 'activity_logged_out', '192.168.100.171', '2019-02-14 06:43:01', '2019-02-14 06:43:01'),
(39, 1, 'login', NULL, NULL, 'activity_logged_in', '192.168.100.171', '2019-02-14 06:43:21', '2019-02-14 06:43:21');

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

--
-- Table structure for table `app_users`
--

CREATE TABLE `app_users` (
  `id` int(10) UNSIGNED NOT NULL,
  `first_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` date NOT NULL,
  `is_hidden` int(4) NOT NULL DEFAULT '0',
  `designation_id` int(4) DEFAULT NULL,
  `role` int(4) DEFAULT NULL,
  `status` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `email_verified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `token` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otp` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT 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 `app_users`
--

INSERT INTO `app_users` (`id`, `first_name`, `last_name`, `email`, `mobile`, `image`, `dob`, `is_hidden`, `designation_id`, `role`, `status`, `email_verified_at`, `token`, `password`, `remember_token`, `otp`, `created_at`, `updated_at`) VALUES
(1, 'harish', 'reddy', 'eharishwarreddy666@gmail.com', '9533402327', 'app_users/profile_images/harish_profile_1549281709.png', '2019-02-04', 0, NULL, NULL, 'active', '2019-02-04 09:58:41', 'slqpRgedYhMiASlko9tFNl4Q9YtG9zyLZHcjbKy1CROCQX7oTDUbiY9w8t3W', '$2y$10$ycTMwuklA4WeGvEOF1X7yev4Pd04UOtPbkC1D/LeDbMrApN2KDp0W', NULL, '466242', '2019-02-04 09:58:41', '2019-02-08 11:03:01'),
(5, 'gcjgdjfgdjfgd', 'gdjfgdjdjd', 'hfhfhfhf@gmail.com', '4343434343', 'app_users/profile_images/gcjgdjfgdjfgd_profile_1549451868.png', '2019-02-06', 0, NULL, NULL, 'active', '2019-02-06 11:17:48', 'FRHNGLgZsOESEgcfCQGjNuWKlvHqgf4Xy0zZE7zO2Ljk37mhNvEjHGBptUy5', '$2y$10$07FK9k12z.Ad0ZzwmjJ.juG17lgJo6cKLWnrTWD7maps84Cfa9L9a', NULL, NULL, '2019-01-16 11:17:48', '2019-02-06 11:17:48'),
(6, 'dinesh', 'kudupudi', 'dinesh.kudupudi123@gmail.com', '9000981949', 'app_users/profile_images/harish_profile_1549281709.png', '2019-02-04', 0, NULL, NULL, 'active', '2019-02-11 05:39:45', 'nVZiRjWkWSqn8Dd3h78xcv4UwLPpTjRojjSn0HimSjv6ddYcriGD9wb1C64M', '$2y$10$BHVW65ODeyKbqZQx4tbnp.fAnCNHHocmxrt1ESCWxNmhzUqemjbK2', NULL, '452858', '2019-02-11 05:39:45', '2019-02-13 12:07:51'),
(7, 'venkat', 't', 'tvsindian@gmail.com', '9492752693', 'app_users/profile_images/venkat_profile_1549883140.png', '2019-02-11', 0, NULL, NULL, 'active', '2019-02-11 11:05:40', 'vliHMBhMHpCxsWjGH3ieXLUUjjHJZw8yS0K1EAxpEEQ2HqzFxLopnxFiuSs5', '$2y$10$RnZv72TBHefqAT3LeJl.yuSpGXU5YhpI9p27mNQPINa7ypyeqlYK.', NULL, NULL, '2019-01-16 11:05:40', '2019-02-11 11:05:40'),
(8, 'Paramatma Sharan', 'Upadhyay', 'paramatma.sharan9@gmail.com', '7000096270', 'app_users/profile_images/Paramatma_Sharan_profile_1549965848.png', '2019-02-12', 0, NULL, NULL, 'active', '2019-02-12 10:04:08', 'DW7IUIztDdSCCYrl7Xny3rMhl3XJ93uxMJ6NaadGsIq2QSEalH6eXB2PXxYN', '$2y$10$uZUiz2RZKf4QWwjv1JURYOWZBkCpsbfG8sQjzYaVl55MPyI2CxyIW', NULL, '', '2019-02-12 10:04:08', '2019-02-12 11:58:10');

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

--
-- Table structure for table `app_user_profiles`
--

CREATE TABLE `app_user_profiles` (
  `id` int(11) NOT NULL,
  `app_user_id` int(11) NOT NULL,
  `owner_ship` varchar(100) DEFAULT NULL,
  `country_id` int(11) DEFAULT NULL,
  `state_id` int(11) DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  `address1` varchar(200) DEFAULT NULL,
  `address2` varchar(200) DEFAULT NULL,
  `pin_code` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `app_user_profiles`
--

INSERT INTO `app_user_profiles` (`id`, `app_user_id`, `owner_ship`, `country_id`, `state_id`, `city_id`, `address1`, `address2`, `pin_code`, `created_at`, `updated_at`) VALUES
(1, 1, 'OWN', 1, 32, 222, 'rrr', 'tttt', 500023, '2019-02-04 09:55:43', '2019-02-08 10:47:22'),
(5, 4, 'OWN', 1, 1, 93, 'SR Nagar, Ameerpet', 'Hyderabad', 496331, '2019-02-05 09:35:21', '2019-02-07 13:21:22'),
(6, 5, 'own', NULL, NULL, NULL, NULL, NULL, NULL, '2019-02-06 11:17:48', '2019-02-06 11:17:48'),
(7, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-02-11 05:39:45', '2019-02-11 05:39:45'),
(8, 7, 'OWN', 1, 2, 408, NULL, NULL, 523201, '2019-02-11 11:05:40', '2019-02-11 11:07:50'),
(9, 8, 'OWN', 1, 4, 53, 'Sr Nagar Ameerpet', 'Hyderabad', 496331, '2019-02-12 10:04:08', '2019-02-13 09:53:54');

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

--
-- Table structure for table `app_user_vehicles`
--

CREATE TABLE `app_user_vehicles` (
  `id` int(11) NOT NULL,
  `app_user_id` int(11) NOT NULL,
  `ev_manufacture` varchar(150) DEFAULT NULL,
  `model` varchar(150) DEFAULT NULL,
  `model_variant` varchar(150) DEFAULT NULL,
  `manufacture_year` varchar(150) DEFAULT NULL,
  `registration_no` varchar(150) DEFAULT NULL,
  `owner_ship` varchar(150) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `app_user_vehicles`
--

INSERT INTO `app_user_vehicles` (`id`, `app_user_id`, `ev_manufacture`, `model`, `model_variant`, `manufacture_year`, `registration_no`, `owner_ship`, `created_at`, `updated_at`) VALUES
(16, 8, 'Maruti Suzuki', 'Maruti Suzuki 123', 'M1', '2018', 'Suzuki123', 'OWN', '2019-02-12 12:22:15', '2019-02-12 17:52:15'),
(17, 8, 'TATA Motors', 'Tiago Revotron', 'T5', '2017', 'TATA17', 'OWN', '2019-02-12 12:22:53', '2019-02-12 17:52:53'),
(18, 8, 'TATA Motors', 'Tiago Revotron XC', 'T1', '2019', 'test', 'OWN', '2019-02-12 13:22:28', '2019-02-12 18:52:28'),
(19, 8, 'TATA Motors', 'Tiago Revotron XC', 'T1', '2019', 'RE123456', 'OWN', '2019-02-13 13:36:42', '2019-02-13 19:06:42');

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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `city_id` int(3) NOT NULL,
  `city_name` varchar(30) NOT NULL,
  `state_id` int(3) NOT NULL,
  `state_name` varchar(30) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`city_id`, `city_name`, `state_id`, `state_name`, `created_at`, `updated_at`) VALUES
(1, 'Adilabad', 32, 'Telangana', NULL, '2019-02-07 07:50:41'),
(2, 'Agra', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(3, 'Ahmed Nagar', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(4, 'Ahmedabad City', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(5, 'Aizawl', 24, 'Mizoram', NULL, '2019-02-07 07:50:41'),
(6, 'Ajmer', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(7, 'Akola', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(8, 'Aligarh', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(9, 'Allahabad', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(10, 'Alleppey', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(11, 'Almora', 35, 'Uttarakhand', NULL, '2019-02-07 07:50:41'),
(12, 'Alwar', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(13, 'Alwaye', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(14, 'Amalapuram', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(15, 'Ambala', 13, 'Haryana', NULL, '2019-02-07 07:50:41'),
(16, 'Ambedkar Nagar', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(17, 'Amravati', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(18, 'Amreli', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(19, 'Amritsar', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(20, 'Anakapalle', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(21, 'Anand', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(22, 'Anantapur', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(23, 'Ananthnag', 15, 'Jammu & Kashmir', NULL, '2019-02-07 07:50:41'),
(24, 'Anna Road H.O', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(25, 'Arakkonam', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(26, 'Asansol', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(27, 'Aska', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(28, 'Auraiya', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(29, 'Aurangabad', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(30, 'Aurangabad(Bihar)', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(31, 'Azamgarh', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(32, 'Bagalkot', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(33, 'Bageshwar', 35, 'Uttarakhand', NULL, '2019-02-07 07:50:41'),
(34, 'Bagpat', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(35, 'Bahraich', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(36, 'Balaghat', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(37, 'Balangir', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(38, 'Balasore', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(39, 'Ballia', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(40, 'Balrampur', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(41, 'Banasanktha', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(42, 'Banda', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(43, 'Bandipur', 15, 'Jammu & Kashmir', NULL, '2019-02-07 07:50:41'),
(44, 'Bankura', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(45, 'Banswara', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(46, 'Barabanki', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(47, 'Baramulla', 15, 'Jammu & Kashmir', NULL, '2019-02-07 07:50:41'),
(48, 'Baran', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(49, 'Bardoli', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(50, 'Bareilly', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(51, 'Barmer', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(52, 'Barnala', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(53, 'Barpeta', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(54, 'Bastar', 7, 'Chattisgarh', NULL, '2019-02-07 07:50:41'),
(55, 'Basti', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(56, 'Bathinda', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(57, 'Beed', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(58, 'Begusarai', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(59, 'Belgaum', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(60, 'Bellary', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(61, 'Bengaluru East', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(62, 'Bengaluru South', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(63, 'Bengaluru West', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(64, 'Berhampur', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(65, 'Bhadrak', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(66, 'Bhagalpur', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(67, 'Bhandara', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(68, 'Bharatpur', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(69, 'Bharuch', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(70, 'Bhavnagar', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(71, 'Bhilwara', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(72, 'Bhimavaram', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(73, 'Bhiwani', 13, 'Haryana', NULL, '2019-02-07 07:50:41'),
(74, 'Bhojpur', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(75, 'Bhopal', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(76, 'Bhubaneswar', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(77, 'Bidar', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(78, 'Bijapur', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(79, 'Bijnor', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(80, 'Bikaner', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(81, 'Bilaspur', 7, 'Chattisgarh', NULL, '2019-02-07 07:50:41'),
(82, 'Birbhum', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(83, 'Bishnupur', 22, 'Manipur', NULL, '2019-02-07 07:50:41'),
(84, 'Bongaigaon', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(85, 'Budaun', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(86, 'Budgam', 15, 'Jammu & Kashmir', NULL, '2019-02-07 07:50:41'),
(87, 'Bulandshahr', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(88, 'Buldhana', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(89, 'Bundi', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(90, 'Burdwan', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(91, 'Cachar', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(92, 'Calicut', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(93, 'Carnicobar', 1, 'Andaman & Nicobar Islands', NULL, '2019-02-07 07:50:41'),
(94, 'Chamba', 14, 'Himachal Pradesh', NULL, '2019-02-07 07:50:41'),
(95, 'Chamoli', 35, 'Uttarakhand', NULL, '2019-02-07 07:50:41'),
(96, 'Champawat', 35, 'Uttarakhand', NULL, '2019-02-07 07:50:41'),
(97, 'Champhai', 24, 'Mizoram', NULL, '2019-02-07 07:50:41'),
(98, 'Chandauli', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(99, 'Chandel', 22, 'Manipur', NULL, '2019-02-07 07:50:41'),
(100, 'Chandigarh', 6, 'Chandigarh', NULL, '2019-02-07 07:50:41'),
(101, 'Chandrapur', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(102, 'Changanacherry', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(103, 'Changlang', 3, 'Arunachal Pradesh', NULL, '2019-02-07 07:50:41'),
(104, 'Channapatna', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(105, 'Chengalpattu', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(106, 'Chennai City Central', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(107, 'Chennai City North', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(108, 'Chennai City South', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(109, 'Chhatarpur', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(110, 'Chhindwara', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(111, 'Chikmagalur', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(112, 'Chikodi', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(113, 'Chitradurga', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(114, 'Chitrakoot', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(115, 'Chittoor', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(116, 'Chittorgarh', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(117, 'Churachandpur', 22, 'Manipur', NULL, '2019-02-07 07:50:41'),
(118, 'Churu', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(119, 'Coimbatore', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(120, 'Contai', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(121, 'Cooch Behar', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(122, 'Cuddalore', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(123, 'Cuddapah', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(124, 'Cuttack City', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(125, 'Cuttack North', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(126, 'Cuttack South', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(127, 'Dadra & Nagar Haveli', 8, 'Dadra & Nagar Haveli', NULL, '2019-02-07 07:50:41'),
(128, 'Daman', 9, 'Daman & Diu', NULL, '2019-02-07 07:50:41'),
(129, 'Darbhanga', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(130, 'Darjiling', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(131, 'Darrang', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(132, 'Dausa', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(133, 'Dehra Gopipur', 14, 'Himachal Pradesh', NULL, '2019-02-07 07:50:41'),
(134, 'Dehradun', 35, 'Uttarakhand', NULL, '2019-02-07 07:50:41'),
(135, 'Delhi', 10, 'Delhi', NULL, '2019-02-07 07:50:41'),
(136, 'Deoria', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(137, 'Dhalai', 33, 'Tripura', NULL, '2019-02-07 07:50:41'),
(138, 'Dhanbad', 16, 'Jharkhand', NULL, '2019-02-07 07:50:41'),
(139, 'Dharamsala', 14, 'Himachal Pradesh', NULL, '2019-02-07 07:50:41'),
(140, 'Dharmapuri', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(141, 'Dharwad', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(142, 'Dhemaji', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(143, 'Dhenkanal', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(144, 'Dholpur', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(145, 'Dhubri', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(146, 'Dhule', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(147, 'Dibang Valley', 3, 'Arunachal Pradesh', NULL, '2019-02-07 07:50:41'),
(148, 'Dibrugarh', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(149, 'Diglipur', 1, 'Andaman & Nicobar Islands', NULL, '2019-02-07 07:50:41'),
(150, 'Dimapur', 25, 'Nagaland', NULL, '2019-02-07 07:50:41'),
(151, 'Dindigul', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(152, 'Diu', 9, 'Daman & Diu', NULL, '2019-02-07 07:50:41'),
(153, 'Doda', 15, 'Jammu & Kashmir', NULL, '2019-02-07 07:50:41'),
(154, 'Dungarpur', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(155, 'Durg', 7, 'Chattisgarh', NULL, '2019-02-07 07:50:41'),
(156, 'East Champaran', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(157, 'East Garo Hills', 23, 'Meghalaya', NULL, '2019-02-07 07:50:41'),
(158, 'East Kameng', 3, 'Arunachal Pradesh', NULL, '2019-02-07 07:50:41'),
(159, 'East Khasi Hills', 23, 'Meghalaya', NULL, '2019-02-07 07:50:41'),
(160, 'East Siang', 3, 'Arunachal Pradesh', NULL, '2019-02-07 07:50:41'),
(161, 'East Sikkim', 30, 'Sikkim', NULL, '2019-02-07 07:50:41'),
(162, 'Eluru', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(163, 'Ernakulam', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(164, 'Erode', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(165, 'Etah', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(166, 'Etawah', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(167, 'Faizabad', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(168, 'Faridabad', 13, 'Haryana', NULL, '2019-02-07 07:50:41'),
(169, 'Faridkot', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(170, 'Farrukhabad', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(171, 'Fatehgarh Sahib', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(172, 'Fatehpur', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(173, 'Fazilka', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(174, 'Ferrargunj', 1, 'Andaman & Nicobar Islands', NULL, '2019-02-07 07:50:41'),
(175, 'Firozabad', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(176, 'Firozpur', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(177, 'Gadag', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(178, 'Gadchiroli', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(179, 'Gandhinagar', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(180, 'Ganganagar', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(181, 'Gautam Buddha Nagar', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(182, 'Gaya', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(183, 'Ghaziabad', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(184, 'Ghazipur', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(185, 'Giridih', 16, 'Jharkhand', NULL, '2019-02-07 07:50:41'),
(186, 'Goa', 11, 'Goa', NULL, '2019-02-07 07:50:41'),
(187, 'Goalpara', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(188, 'Gokak', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(189, 'Golaghat', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(190, 'Gonda', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(191, 'Gondal', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(192, 'Gondia', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(193, 'Gorakhpur', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(194, 'Gudivada', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(195, 'Gudur', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(196, 'Gulbarga', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(197, 'Guna', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(198, 'Guntur', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(199, 'Gurdaspur', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(200, 'Gurugram', 13, 'Haryana', NULL, '2019-02-07 07:50:41'),
(201, 'Gwalior', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(202, 'Hailakandi', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(203, 'Hamirpur (HP)', 14, 'Himachal Pradesh', NULL, '2019-02-07 07:50:41'),
(204, 'Hamirpur (UP)', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(205, 'Hanamkonda', 32, 'Telangana', NULL, '2019-02-07 07:50:41'),
(206, 'Hanumangarh', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(207, 'Hardoi', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(208, 'Haridwar', 35, 'Uttarakhand', NULL, '2019-02-07 07:50:41'),
(209, 'Hassan', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(210, 'Hathras', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(211, 'Haveri', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(212, 'Hazaribagh', 16, 'Jharkhand', NULL, '2019-02-07 07:50:41'),
(213, 'Hindupur', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(214, 'Hingoli', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(215, 'Hissar', 13, 'Haryana', NULL, '2019-02-07 07:50:41'),
(216, 'Hooghly', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(217, 'Hoshangabad', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(218, 'Hoshiarpur', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(219, 'Howrah', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(220, 'Hut Bay', 1, 'Andaman & Nicobar Islands', NULL, '2019-02-07 07:50:41'),
(221, 'Hyderabad City', 32, 'Telangana', NULL, '2019-02-07 07:50:41'),
(222, 'Hyderabad South East', 32, 'Telangana', NULL, '2019-02-07 07:50:41'),
(223, 'Idukki', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(224, 'Imphal East', 22, 'Manipur', NULL, '2019-02-07 07:50:41'),
(225, 'Imphal West', 22, 'Manipur', NULL, '2019-02-07 07:50:41'),
(226, 'Indore City', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(227, 'Indore Moffusil', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(228, 'Irinjalakuda', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(229, 'Jabalpur', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(230, 'Jaintia Hills', 23, 'Meghalaya', NULL, '2019-02-07 07:50:41'),
(231, 'Jaipur', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(232, 'Jaisalmer', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(233, 'Jalandhar', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(234, 'Jalaun', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(235, 'Jalgaon', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(236, 'Jalna', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(237, 'Jalor', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(238, 'Jalpaiguri', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(239, 'Jammu', 15, 'Jammu & Kashmir', NULL, '2019-02-07 07:50:41'),
(240, 'Jamnagar', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(241, 'Jaunpur', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(242, 'Jhalawar', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(243, 'Jhansi', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(244, 'Jhujhunu', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(245, 'Jodhpur', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(246, 'Jorhat', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(247, 'Junagadh', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(248, 'Jyotiba Phule Nagar', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(249, 'Kakinada', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(250, 'Kalahandi', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(251, 'Kamrup', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(252, 'Kanchipuram', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(253, 'Kannauj', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(254, 'Kanniyakumari', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(255, 'Kannur', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(256, 'Kanpur Dehat', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(257, 'Kanpur Nagar', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(258, 'Kapurthala', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(259, 'Karaikal', 27, 'Poducherry', NULL, '2019-02-07 07:50:41'),
(260, 'Karaikudi', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(261, 'Karauli', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(262, 'Karbi Anglong', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(263, 'Kargil', 15, 'Jammu & Kashmir', NULL, '2019-02-07 07:50:41'),
(264, 'Karimganj', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(265, 'Karimnagar', 32, 'Telangana', NULL, '2019-02-07 07:50:41'),
(266, 'Karnal', 13, 'Haryana', NULL, '2019-02-07 07:50:41'),
(267, 'Karur', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(268, 'Karwar', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(269, 'Kasaragod', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(270, 'Kathua', 15, 'Jammu & Kashmir', NULL, '2019-02-07 07:50:41'),
(271, 'Kaushambi', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(272, 'Keonjhar', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(273, 'Khammam (AP)', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(274, 'Khammam (TL)', 32, 'Telangana', NULL, '2019-02-07 07:50:41'),
(275, 'Khandwa', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(276, 'Kheda', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(277, 'Kheri', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(278, 'Kiphire', 25, 'Nagaland', NULL, '2019-02-07 07:50:41'),
(279, 'Kodagu', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(280, 'Kohima', 25, 'Nagaland', NULL, '2019-02-07 07:50:41'),
(281, 'Kokrajhar', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(282, 'Kolar', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(283, 'Kolasib', 24, 'Mizoram', NULL, '2019-02-07 07:50:41'),
(284, 'Kolhapur', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(285, 'Kolkata', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(286, 'Koraput', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(287, 'Kota', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(288, 'Kottayam', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(289, 'Kovilpatti', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(290, 'Krishnagiri', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(291, 'Kulgam', 15, 'Jammu & Kashmir', NULL, '2019-02-07 07:50:41'),
(292, 'Kumbakonam', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(293, 'Kupwara', 15, 'Jammu & Kashmir', NULL, '2019-02-07 07:50:41'),
(294, 'Kurnool', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(295, 'Kurukshetra', 13, 'Haryana', NULL, '2019-02-07 07:50:41'),
(296, 'Kurung Kumey', 3, 'Arunachal Pradesh', NULL, '2019-02-07 07:50:41'),
(297, 'Kushinagar', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(298, 'Kutch', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(299, 'Lakhimpur', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(300, 'Lakshadweep', 19, 'Lakshadweep', NULL, '2019-02-07 07:50:41'),
(301, 'Lalitpur', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(302, 'Latur', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(303, 'Lawngtlai', 24, 'Mizoram', NULL, '2019-02-07 07:50:41'),
(304, 'Leh', 15, 'Jammu & Kashmir', NULL, '2019-02-07 07:50:41'),
(305, 'Lohit', 3, 'Arunachal Pradesh', NULL, '2019-02-07 07:50:41'),
(306, 'Longleng', 25, 'Nagaland', NULL, '2019-02-07 07:50:41'),
(307, 'Lower Subansiri', 3, 'Arunachal Pradesh', NULL, '2019-02-07 07:50:41'),
(308, 'Lucknow', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(309, 'Ludhiana', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(310, 'Lunglei', 24, 'Mizoram', NULL, '2019-02-07 07:50:41'),
(311, 'Machilipatnam', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(312, 'Madhubani', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(313, 'Madurai', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(314, 'Mahabubnagar', 32, 'Telangana', NULL, '2019-02-07 07:50:41'),
(315, 'Maharajganj', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(316, 'Mahesana', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(317, 'Mahoba', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(318, 'Mainpuri', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(319, 'Malda', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(320, 'Mammit', 24, 'Mizoram', NULL, '2019-02-07 07:50:41'),
(321, 'Mandi', 14, 'Himachal Pradesh', NULL, '2019-02-07 07:50:41'),
(322, 'Mandsaur', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(323, 'Mandya', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(324, 'Mangalore', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(325, 'Manjeri', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(326, 'Mansa', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(327, 'Marigaon', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(328, 'Mathura', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(329, 'Mau', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(330, 'Mavelikara', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(331, 'Mayabander', 1, 'Andaman & Nicobar Islands', NULL, '2019-02-07 07:50:41'),
(332, 'Mayiladuthurai', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(333, 'Mayurbhanj', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(334, 'Medak', 32, 'Telangana', NULL, '2019-02-07 07:50:41'),
(335, 'Meerut', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(336, 'Meghalaya', 23, 'Meghalaya', NULL, '2019-02-07 07:50:41'),
(337, 'Midnapore', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(338, 'Mirzapur', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(339, 'Moga', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(340, 'Mohali', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(341, 'Mokokchung', 25, 'Nagaland', NULL, '2019-02-07 07:50:41'),
(342, 'Mon', 25, 'Nagaland', NULL, '2019-02-07 07:50:41'),
(343, 'Monghyr', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(344, 'Moradabad', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(345, 'Morena', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(346, 'Muktsar', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(347, 'Mumbai', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(348, 'Murshidabad', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(349, 'Muzaffarnagar', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(350, 'Muzaffarpur', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(351, 'Mysore', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(352, 'Nadia', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(353, 'Nagaon', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(354, 'Nagapattinam', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(355, 'Nagaur', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(356, 'Nagpur', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(357, 'Nainital', 35, 'Uttarakhand', NULL, '2019-02-07 07:50:41'),
(358, 'Nalanda', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(359, 'Nalbari', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(360, 'Nalgonda', 32, 'Telangana', NULL, '2019-02-07 07:50:41'),
(361, 'Namakkal', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(362, 'Nancorie', 1, 'Andaman & Nicobar Islands', NULL, '2019-02-07 07:50:41'),
(363, 'Nancowrie', 1, 'Andaman & Nicobar Islands', NULL, '2019-02-07 07:50:41'),
(364, 'Nanded', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(365, 'Nandurbar', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(366, 'Nandyal', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(367, 'Nanjangud', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(368, 'Narasaraopet', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(369, 'Nashik', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(370, 'Navsari', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(371, 'Nawadha', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(372, 'Nawanshahr', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(373, 'Nellore', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(374, 'Nilgiris', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(375, 'Nizamabad', 32, 'Telangana', NULL, '2019-02-07 07:50:41'),
(376, 'North 24 Parganas', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(377, 'North Cachar Hills', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(378, 'North Dinajpur', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(379, 'North Sikkim', 30, 'Sikkim', NULL, '2019-02-07 07:50:41'),
(380, 'North Tripura', 33, 'Tripura', NULL, '2019-02-07 07:50:41'),
(381, 'Osmanabad', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(382, 'Ottapalam', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(383, 'Palamau', 16, 'Jharkhand', NULL, '2019-02-07 07:50:41'),
(384, 'Palghat', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(385, 'Pali', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(386, 'Panchmahals', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(387, 'Papum Pare', 3, 'Arunachal Pradesh', NULL, '2019-02-07 07:50:41'),
(388, 'Parbhani', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(389, 'Parvathipuram', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(390, 'Patan', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(391, 'Pathanamthitta', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(392, 'Patiala', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(393, 'Patna', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(394, 'Pattukottai', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(395, 'Pauri Garhwal', 35, 'Uttarakhand', NULL, '2019-02-07 07:50:41'),
(396, 'Peddapalli', 32, 'Telangana', NULL, '2019-02-07 07:50:41'),
(397, 'Peren', 25, 'Nagaland', NULL, '2019-02-07 07:50:41'),
(398, 'Phek', 25, 'Nagaland', NULL, '2019-02-07 07:50:41'),
(399, 'Phulbani', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(400, 'Pilibhit', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(401, 'Pithoragarh', 35, 'Uttarakhand', NULL, '2019-02-07 07:50:41'),
(402, 'Poducherry (PD)', 27, 'Poducherry', NULL, '2019-02-07 07:50:41'),
(403, 'Poducherry (TN)', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(404, 'Pollachi', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(405, 'Poonch', 15, 'Jammu & Kashmir', NULL, '2019-02-07 07:50:41'),
(406, 'Porbandar', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(407, 'Port Blair', 1, 'Andaman & Nicobar Islands', NULL, '2019-02-07 07:50:41'),
(408, 'Prakasam', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(409, 'Pratapgarh', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(410, 'Proddatur', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(411, 'Pudukkottai', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(412, 'Pulwama', 15, 'Jammu & Kashmir', NULL, '2019-02-07 07:50:41'),
(413, 'Pune', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(414, 'Puri', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(415, 'Purnea', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(416, 'Purulia', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(417, 'Puttur', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(418, 'Quilon', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(419, 'Raebareli', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(420, 'Raichur', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(421, 'Raigarh (CT)', 7, 'Chattisgarh', NULL, '2019-02-07 07:50:41'),
(422, 'Raigarh (MH)', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(423, 'Raipur', 7, 'Chattisgarh', NULL, '2019-02-07 07:50:41'),
(424, 'Rajahmundry', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(425, 'Rajauri', 15, 'Jammu & Kashmir', NULL, '2019-02-07 07:50:41'),
(426, 'Rajkot', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(427, 'Rajsamand', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(428, 'Ramanathapuram', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(429, 'Rampur', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(430, 'Rampur Bushahr', 14, 'Himachal Pradesh', NULL, '2019-02-07 07:50:41'),
(431, 'Ranchi', 16, 'Jharkhand', NULL, '2019-02-07 07:50:41'),
(432, 'Rangat', 1, 'Andaman & Nicobar Islands', NULL, '2019-02-07 07:50:41'),
(433, 'Ratlam', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(434, 'Ratnagiri', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(435, 'Reasi', 15, 'Jammu & Kashmir', NULL, '2019-02-07 07:50:41'),
(436, 'Rewa', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(437, 'Ri Bhoi', 23, 'Meghalaya', NULL, '2019-02-07 07:50:41'),
(438, 'Rohtak', 13, 'Haryana', NULL, '2019-02-07 07:50:41'),
(439, 'Rohtas', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(440, 'Ropar', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(441, 'Rudraprayag', 35, 'Uttarakhand', NULL, '2019-02-07 07:50:41'),
(442, 'Rupnagar', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(443, 'Sabarkantha', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(444, 'Sagar', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(445, 'Saharanpur', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(446, 'Saharsa', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(447, 'Salem East', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(448, 'Salem West', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(449, 'Samastipur', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(450, 'Sambalpur', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(451, 'Sangareddy', 32, 'Telangana', NULL, '2019-02-07 07:50:41'),
(452, 'Sangli', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(453, 'Sangrur', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(454, 'Sant Kabir Nagar', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(455, 'Sant Ravidas Nagar', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(456, 'Santhal Parganas', 16, 'Jharkhand', NULL, '2019-02-07 07:50:41'),
(457, 'Saran', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(458, 'Satara', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(459, 'Sawai Madhopur', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(460, 'Secunderabad', 32, 'Telangana', NULL, '2019-02-07 07:50:41'),
(461, 'Sehore', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(462, 'Senapati', 22, 'Manipur', NULL, '2019-02-07 07:50:41'),
(463, 'Serchhip', 24, 'Mizoram', NULL, '2019-02-07 07:50:41'),
(464, 'Shahdol', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(465, 'Shahjahanpur', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(466, 'Shimla', 14, 'Himachal Pradesh', NULL, '2019-02-07 07:50:41'),
(467, 'Shimoga', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(468, 'Shrawasti', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(469, 'Sibsagar', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(470, 'Siddharthnagar', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(471, 'Sikar', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(472, 'Sindhudurg', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(473, 'Singhbhum', 16, 'Jharkhand', NULL, '2019-02-07 07:50:41'),
(474, 'Sirohi', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(475, 'Sirsi', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(476, 'Sitamarhi', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(477, 'Sitapur', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(478, 'Sivaganga', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(479, 'Siwan', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(480, 'Solan', 14, 'Himachal Pradesh', NULL, '2019-02-07 07:50:41'),
(481, 'Solapur', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(482, 'Sonbhadra', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(483, 'Sonepat', 13, 'Haryana', NULL, '2019-02-07 07:50:41'),
(484, 'Sonitpur', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(485, 'South 24 Parganas', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(486, 'South Dinajpur', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(487, 'South Garo Hills', 23, 'Meghalaya', NULL, '2019-02-07 07:50:41'),
(488, 'South Sikkim', 30, 'Sikkim', NULL, '2019-02-07 07:50:41'),
(489, 'South Tripura', 33, 'Tripura', NULL, '2019-02-07 07:50:41'),
(490, 'Srikakulam', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(491, 'Srinagar', 15, 'Jammu & Kashmir', NULL, '2019-02-07 07:50:41'),
(492, 'Srirangam', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(493, 'Sultanpur', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(494, 'Sundargarh', 26, 'Odisha', NULL, '2019-02-07 07:50:41'),
(495, 'Surat', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(496, 'Surendranagar', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(497, 'Suryapet', 32, 'Telangana', NULL, '2019-02-07 07:50:41'),
(498, 'Tadepalligudem', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(499, 'Tambaram', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(500, 'Tamenglong', 22, 'Manipur', NULL, '2019-02-07 07:50:41'),
(501, 'Tamluk', 36, 'West Bengal', NULL, '2019-02-07 07:50:41'),
(502, 'Tarn Taran', 28, 'Punjab', NULL, '2019-02-07 07:50:41'),
(503, 'Tawang', 3, 'Arunachal Pradesh', NULL, '2019-02-07 07:50:41'),
(504, 'Tehri Garhwal', 35, 'Uttarakhand', NULL, '2019-02-07 07:50:41'),
(505, 'Tenali', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(506, 'Thalassery', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(507, 'Thane', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(508, 'Thanjavur', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(509, 'Theni', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(510, 'Thoubal', 22, 'Manipur', NULL, '2019-02-07 07:50:41'),
(511, 'Tinsukia', 4, 'Assam', NULL, '2019-02-07 07:50:41'),
(512, 'Tirap', 3, 'Arunachal Pradesh', NULL, '2019-02-07 07:50:41'),
(513, 'Tiruchirapalli', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(514, 'Tirunelveli', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(515, 'Tirupati', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(516, 'Tirupattur', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(517, 'Tirupur', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(518, 'Tirur', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(519, 'Tiruvalla', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(520, 'Tiruvannamalai', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(521, 'Tonk', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(522, 'Trichur', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(523, 'Trivandrum North', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(524, 'Trivandrum South', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(525, 'Tuensang', 25, 'Nagaland', NULL, '2019-02-07 07:50:41'),
(526, 'Tumkur', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(527, 'Tuticorin', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(528, 'Udaipur', 29, 'Rajasthan', NULL, '2019-02-07 07:50:41'),
(529, 'Udham Singh Nagar', 35, 'Uttarakhand', NULL, '2019-02-07 07:50:41'),
(530, 'Udhampur', 15, 'Jammu & Kashmir', NULL, '2019-02-07 07:50:41'),
(531, 'Udupi', 17, 'Karnataka', NULL, '2019-02-07 07:50:41'),
(532, 'Ujjain', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(533, 'Ukhrul', 22, 'Manipur', NULL, '2019-02-07 07:50:41'),
(534, 'Una', 14, 'Himachal Pradesh', NULL, '2019-02-07 07:50:41'),
(535, 'Unnao', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(536, 'Upper Siang', 3, 'Arunachal Pradesh', NULL, '2019-02-07 07:50:41'),
(537, 'Upper Subansiri', 3, 'Arunachal Pradesh', NULL, '2019-02-07 07:50:41'),
(538, 'Uttarkashi', 35, 'Uttarakhand', NULL, '2019-02-07 07:50:41'),
(539, 'Vadakara', 18, 'Kerala', NULL, '2019-02-07 07:50:41'),
(540, 'Vadodara East', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(541, 'Vadodara West', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(542, 'Vaishali', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(543, 'Valsad', 12, 'Gujarat', NULL, '2019-02-07 07:50:41'),
(544, 'Varanasi', 34, 'Uttar Pradesh', NULL, '2019-02-07 07:50:41'),
(545, 'Vellore', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(546, 'Vidisha', 20, 'Madhya Pradesh', NULL, '2019-02-07 07:50:41'),
(547, 'Vijayawada', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(548, 'Virudhunagar', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(549, 'Visakhapatnam', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(550, 'Vizianagaram', 2, 'Andhra Pradesh', NULL, '2019-02-07 07:50:41'),
(551, 'Vriddhachalam', 31, 'Tamil Nadu', NULL, '2019-02-07 07:50:41'),
(552, 'Wanaparthy', 32, 'Telangana', NULL, '2019-02-07 07:50:41'),
(553, 'Warangal', 32, 'Telangana', NULL, '2019-02-07 07:50:41'),
(554, 'Wardha', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(555, 'Washim', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(556, 'West Champaran', 5, 'Bihar', NULL, '2019-02-07 07:50:41'),
(557, 'West Garo Hills', 23, 'Meghalaya', NULL, '2019-02-07 07:50:41'),
(558, 'West Kameng', 3, 'Arunachal Pradesh', NULL, '2019-02-07 07:50:41'),
(559, 'West Khasi Hills', 23, 'Meghalaya', NULL, '2019-02-07 07:50:41'),
(560, 'West Siang', 3, 'Arunachal Pradesh', NULL, '2019-02-07 07:50:41'),
(561, 'West Sikkim', 30, 'Sikkim', NULL, '2019-02-07 07:50:41'),
(562, 'West Tripura', 33, 'Tripura', NULL, '2019-02-07 07:50:41'),
(563, 'Wokha', 25, 'Nagaland', NULL, '2019-02-07 07:50:41'),
(564, 'Yavatmal', 21, 'Maharashtra', NULL, '2019-02-07 07:50:41'),
(565, 'Zunhebotto', 25, 'Nagaland', NULL, '2019-02-07 07:50:41');

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

--
-- Table structure for table `config`
--

CREATE TABLE `config` (
  `id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `config`
--

INSERT INTO `config` (`id`, `name`, `value`) VALUES
(1, 'site_name', 'OCPP'),
(2, 'login_with', 'email'),
(3, 'logo', 'assets/img/logo.png'),
(4, 'from_address', 'admin@innoappsindia.com'),
(5, 'from_name', 'admin@innoappsindia.com'),
(6, 'host', 'mail.innoappsindia.com'),
(7, 'port', '26'),
(8, 'username', 'admin@innoappsindia.com'),
(9, 'password', 'Admin@189981'),
(10, 'encryption', 'tls'),
(11, 'driver', 'smtp');

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

--
-- Table structure for table `countrys`
--

CREATE TABLE `countrys` (
  `country_id` int(11) NOT NULL,
  `country_name` varchar(200) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `countrys`
--

INSERT INTO `countrys` (`country_id`, `country_name`, `created_at`, `updated_at`) VALUES
(1, 'India', '2019-02-07 06:04:47', NULL),
(3, 'USA', '2019-02-07 06:12:42', '2019-02-07 06:12:42');

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

--
-- Table structure for table `custom_fields`
--

CREATE TABLE `custom_fields` (
  `id` int(11) NOT NULL,
  `form` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `options` text COLLATE utf8_unicode_ci,
  `is_required` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `custom_field_values`
--

CREATE TABLE `custom_field_values` (
  `id` int(11) NOT NULL,
  `unique_id` int(11) DEFAULT NULL,
  `field_id` int(11) DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `franchises`
--

CREATE TABLE `franchises` (
  `id` int(11) NOT NULL,
  `franchaise_id` varchar(100) NOT NULL,
  `franchise_name` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `status` varchar(10) NOT NULL,
  `latitude` varchar(100) NOT NULL,
  `longitude` varchar(100) NOT NULL,
  `database_name` varchar(100) NOT NULL,
  `city` int(11) NOT NULL,
  `state` int(11) NOT NULL,
  `country` int(11) NOT NULL,
  `remember_token` varchar(200) DEFAULT NULL,
  `password` varchar(150) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `franchises`
--

INSERT INTO `franchises` (`id`, `franchaise_id`, `franchise_name`, `username`, `first_name`, `last_name`, `phone`, `email`, `status`, `latitude`, `longitude`, `database_name`, `city`, `state`, `country`, `remember_token`, `password`, `created_at`, `updated_at`) VALUES
(1, 'FRA_YVTGXWSQ', 'Mehdipatnam', 'admin', 'Admin', 'Admin', '9533402326', 'admin@gmail.com', 'active', '17.418547', '78.434835', 'admin', 221, 32, 1, NULL, '$2y$10$PSTnonXNJPcSnaZTkeHiourwX2CJbkVwN.GG0KooC3VIiC3qb/qpy', '2019-02-14 04:58:28', '2019-02-14 04:59:29');

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

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  `visible` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` (`id`, `name`, `order`, `visible`) VALUES
(18, 'dashboard', 2, 1),
(19, 'admin', 1, 0),
(20, 'appusers', 1, 0);

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(150) 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
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_01_24_045131_entrust_setup_tables', 2),
(4, '2016_06_01_000001_create_oauth_auth_codes_table', 3),
(5, '2016_06_01_000002_create_oauth_access_tokens_table', 3),
(6, '2016_06_01_000003_create_oauth_refresh_tokens_table', 3),
(7, '2016_06_01_000004_create_oauth_clients_table', 3),
(8, '2016_06_01_000005_create_oauth_personal_access_clients_table', 3);

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

--
-- Table structure for table `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) 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 `oauth_clients`
--

INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Laravel Personal Access Client', 'GUZoEArk1UefDa76dx5MVy7sVjZxQFBxeNoMOWPZ', 'http://localhost', 1, 0, 0, '2019-01-24 01:55:22', '2019-01-24 01:55:22'),
(2, NULL, 'Laravel Password Grant Client', 'gwrNAgxbhoiQblWrpZPbb7fk3W6N4bIAtaJwfYgv', 'http://localhost', 0, 1, 0, '2019-01-24 01:55:22', '2019-01-24 01:55:22');

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

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` int(10) UNSIGNED NOT NULL,
  `client_id` int(10) UNSIGNED 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 `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2019-01-24 01:55:22', '2019-01-24 01:55:22');

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

--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `id` int(11) NOT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--

INSERT INTO `password_resets` (`id`, `email`, `token`, `created_at`, `updated_at`) VALUES
(3, 'eharishwarreddy666@gmail.com', '$2y$10$ytYcPLz8Mly4Sxuy5D1f.uPB7oGPnKsUFCJpR7ZTz8HU17aEjEKaO', '2019-01-31 01:42:48', NULL);

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT 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 `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `category`, `display_name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'create-post', 'Post', 'Create Posts', 'create new blog posts', '2019-01-24 00:52:17', '2019-01-24 00:52:17'),
(3, 'update_permission', 'Permissions', 'Permission', 'Permission module can edit permission', NULL, NULL),
(4, 'role-create', 'Roles', 'Roles', 'Role module can edit permission', NULL, NULL),
(5, 'role-edit', 'Roles', 'Roles', 'Role module can edit permission', NULL, NULL),
(6, 'role-delete', 'Roles', 'Roles', 'Role module can edit permission', NULL, NULL),
(7, 'create-user', 'Users', 'Users', NULL, NULL, NULL),
(8, 'manage_template', 'configuration', 'manage_template', 'manage_template', NULL, NULL),
(9, 'delete-user', 'Users', 'Users Manage', NULL, NULL, NULL),
(10, 'manage_users', 'Users', 'Users Manage', NULL, NULL, NULL),
(11, 'edit-user', 'Users', 'Users Manage', NULL, NULL, NULL),
(12, 'change_user_status', 'Users', 'Users Manage', NULL, NULL, NULL),
(13, 'manage_configuration', 'configuration', 'manage configuration', NULL, NULL, NULL),
(14, 'view_app_users', 'app users', NULL, NULL, NULL, NULL),
(15, 'change_app_user_status', 'app users', NULL, NULL, NULL, NULL),
(16, 'manage_app_users', 'app users', NULL, NULL, NULL, NULL),
(17, 'manage_stations', 'Stations', NULL, NULL, NULL, NULL),
(18, 'settings', 'configuration', 'site settings', 'manage site settings', NULL, NULL),
(20, 'create_stations', 'Stations', NULL, NULL, NULL, NULL),
(21, 'change_station_status', 'Stations', NULL, NULL, NULL, NULL),
(22, 'edit-stations', 'Stations', NULL, NULL, NULL, NULL),
(23, 'vehicle_masters', 'configuration', 'site settings', 'manage site settings', NULL, NULL),
(24, 'location_masters', 'configuration', 'site settings', 'manage site settings', NULL, NULL),
(25, 'masters_menu', 'configuration', 'site settings', 'manage site settings', NULL, NULL),
(26, 'role-manage', 'Roles', 'Roles', 'Role module can edit permission', NULL, NULL),
(27, 'manage_franchise', 'franchise', NULL, NULL, NULL, NULL),
(28, 'change_franchise_status', 'franchise', NULL, NULL, NULL, NULL),
(29, 'create_franchise', 'franchise', NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `id` int(11) NOT NULL,
  `permission_id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`) VALUES
(18, 1, 1),
(8, 1, 2),
(19, 3, 1),
(7, 3, 2),
(20, 4, 1),
(9, 4, 2),
(21, 5, 1),
(10, 5, 2),
(22, 6, 1),
(11, 6, 2),
(23, 7, 1),
(13, 7, 2),
(24, 8, 1),
(4, 8, 2),
(25, 9, 1),
(14, 9, 2),
(26, 10, 1),
(15, 10, 2),
(27, 11, 1),
(16, 11, 2),
(28, 12, 1),
(17, 12, 2),
(29, 13, 1),
(5, 13, 2),
(30, 14, 1),
(1, 14, 2),
(31, 15, 1),
(2, 15, 2),
(32, 16, 1),
(3, 16, 2),
(33, 17, 1),
(12, 17, 2),
(34, 18, 1),
(6, 18, 2),
(35, 20, 1),
(36, 21, 1),
(37, 22, 1),
(38, 23, 1),
(39, 24, 1),
(40, 25, 1),
(41, 26, 1),
(42, 27, 1),
(43, 28, 1),
(44, 29, 1);

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

--
-- Table structure for table `profiles`
--

CREATE TABLE `profiles` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `gender` varchar(110) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `profiles`
--

INSERT INTO `profiles` (`id`, `user_id`, `gender`, `created_at`, `updated_at`) VALUES
(1, 12, 'male', '2019-01-31 11:58:17', NULL),
(2, 1, 'male', '2019-01-31 11:58:17', '2019-02-01 08:32:49');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_hidden` tinyint(4) NOT NULL DEFAULT '0',
  `is_default` int(11) NOT NULL DEFAULT '0',
  `description` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT 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 `roles`
--

INSERT INTO `roles` (`id`, `name`, `display_name`, `is_hidden`, `is_default`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'Administrator', 1, 1, 'User is allowed to manage and edit other users', '2019-01-24 00:52:17', '2019-01-30 00:46:58'),
(2, 'user', 'User', 0, 0, 'User is allowed to manage and edit other users', '2019-01-24 00:52:17', '2019-01-29 00:52:27'),
(12, 'Franchise', NULL, 0, 0, NULL, '2019-01-29 07:33:26', '2019-01-29 07:33:26'),
(13, 'sub admin', NULL, 0, 0, NULL, '2019-02-05 08:48:56', '2019-02-13 06:11:15');

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

--
-- Table structure for table `role_user`
--

CREATE TABLE `role_user` (
  `user_id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` (`user_id`, `role_id`) VALUES
(1, 1),
(12, 2);

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

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

CREATE TABLE `states` (
  `state_id` int(3) NOT NULL,
  `country_id` int(3) NOT NULL,
  `state_name` varchar(40) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `states` (`state_id`, `country_id`, `state_name`, `created_at`, `updated_at`) VALUES
(1, 1, 'Andaman & Nicobar Islands', NULL, '2019-02-07 06:34:28'),
(2, 1, 'Andhra Pradesh', NULL, '2019-02-07 06:34:28'),
(3, 1, 'Arunachal Pradesh', NULL, '2019-02-07 06:34:28'),
(4, 1, 'Assam', NULL, '2019-02-07 06:34:28'),
(5, 1, 'Bihar', NULL, '2019-02-07 06:34:28'),
(6, 1, 'Chandigarh', NULL, '2019-02-07 06:34:28'),
(7, 1, 'Chattisgarh', NULL, '2019-02-07 06:34:28'),
(8, 1, 'Dadra & Nagar Haveli', NULL, '2019-02-07 06:34:28'),
(9, 1, 'Daman & Diu', NULL, '2019-02-07 06:34:28'),
(10, 1, 'Delhi', NULL, '2019-02-07 06:34:28'),
(11, 1, 'Goa', NULL, '2019-02-07 06:34:28'),
(12, 1, 'Gujarat', NULL, '2019-02-07 06:34:28'),
(13, 1, 'Haryana', NULL, '2019-02-07 06:34:28'),
(14, 1, 'Himachal Pradesh', NULL, '2019-02-07 06:34:28'),
(15, 1, 'Jammu & Kashmir', NULL, '2019-02-07 06:34:28'),
(16, 1, 'Jharkhand', NULL, '2019-02-07 06:34:28'),
(17, 1, 'Karnataka', NULL, '2019-02-07 06:34:28'),
(18, 1, 'Kerala', NULL, '2019-02-07 06:34:28'),
(19, 1, 'Lakshadweep', NULL, '2019-02-07 06:34:28'),
(20, 1, 'Madhya Pradesh', NULL, '2019-02-07 06:34:28'),
(21, 1, 'Maharashtra', NULL, '2019-02-07 06:34:28'),
(22, 1, 'Manipur', NULL, '2019-02-07 06:34:28'),
(23, 1, 'Meghalaya', NULL, '2019-02-07 06:34:28'),
(24, 1, 'Mizoram', NULL, '2019-02-07 06:34:28'),
(25, 1, 'Nagaland', NULL, '2019-02-07 06:34:28'),
(26, 1, 'Odisha', NULL, '2019-02-07 06:34:28'),
(27, 1, 'Poducherry', NULL, '2019-02-07 06:34:28'),
(28, 1, 'Punjab', NULL, '2019-02-07 06:34:28'),
(29, 1, 'Rajasthan', NULL, '2019-02-07 06:34:28'),
(30, 1, 'Sikkim', NULL, '2019-02-07 06:34:28'),
(31, 1, 'Tamil Nadu', NULL, '2019-02-07 06:34:28'),
(32, 1, 'Telangana', NULL, '2019-02-07 06:34:28'),
(33, 1, 'Tripura', NULL, '2019-02-07 06:34:28'),
(34, 1, 'Uttar Pradesh', NULL, '2019-02-07 06:34:28'),
(35, 1, 'Uttarakhand', NULL, '2019-02-07 06:34:28'),
(36, 1, 'West Bengal', NULL, '2019-02-07 06:34:28'),
(40, 3, 'Minosatta', '2019-02-07 06:49:58', '2019-02-07 06:50:50');

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

--
-- Table structure for table `stations`
--

CREATE TABLE `stations` (
  `id` int(11) NOT NULL,
  `station_id` varchar(100) NOT NULL,
  `created_by` varchar(100) NOT NULL,
  `created_by_id` varchar(110) NOT NULL,
  `station_name` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL DEFAULT 'active',
  `latitude` varchar(20) NOT NULL,
  `longitude` varchar(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `stations`
--

INSERT INTO `stations` (`id`, `station_id`, `created_by`, `created_by_id`, `station_name`, `status`, `latitude`, `longitude`, `created_at`, `updated_at`) VALUES
(1, 'EVM1234589', 'admin', '1', 'Panjagutta', 'banned', '17.426480', '78.450370', '2019-01-28 05:34:57', '2019-02-07 18:47:23'),
(2, 'EVM123457', 'admin', '12', 'Panjagutta circle', 'active', '17.425937', '78.450831', '2019-01-28 05:34:57', NULL),
(3, 'EVM123456', 'admin', '1', 'Panjagutta', 'active', '17.430688', '78.429436', '2019-01-28 05:34:57', NULL),
(4, 'EVM1234', 'admin', '1', 'inno', 'under_maintained', '17.442050', '78.396957', '2019-01-28 05:34:57', '2019-02-07 18:37:27'),
(6, 'EVM_I7PGV51YZC', 'admin', '12', 'hari', 'active', '17.394962', '78.431030', '2019-02-07 14:00:33', '2019-02-12 19:27:06'),
(12, 'EVM_2WFGDSB739', 'franchise', '1', 'mehdipatnam 2', 'banned', '17.429428', '78.441808', '2019-02-14 05:29:52', '2019-02-14 11:25:49');

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

--
-- Table structure for table `station_nozzles`
--

CREATE TABLE `station_nozzles` (
  `id` int(11) NOT NULL,
  `nozzle_id` varchar(100) NOT NULL,
  `station_id` varchar(150) NOT NULL,
  `type` varchar(110) NOT NULL,
  `status` varchar(100) NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `station_nozzles`
--

INSERT INTO `station_nozzles` (`id`, `nozzle_id`, `station_id`, `type`, `status`, `created_at`, `updated_at`) VALUES
(2, 'FRA_YVTGXWSQ_LQBR1', 'EVM_2WFGDSB739', '3 Pin', 'active', '2019-02-14 06:24:21', '2019-02-14 06:42:51'),
(3, 'NOZ_CSED1B25M4', 'EVM1234', '3 Pin', 'banned', '2019-02-14 06:26:52', '2019-02-14 06:30:06');

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

--
-- Table structure for table `s_m_t_p_s`
--

CREATE TABLE `s_m_t_p_s` (
  `id` int(10) UNSIGNED NOT NULL,
  `driver` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `port` int(11) NOT NULL,
  `from_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `from_address` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `encryption` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` smallint(6) 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 `s_m_t_p_s`
--

INSERT INTO `s_m_t_p_s` (`id`, `driver`, `host`, `port`, `from_name`, `from_address`, `username`, `password`, `encryption`, `status`, `created_at`, `updated_at`) VALUES
(10, 'smtp', 'mail.innoappsindia.com', 26, 'admin@innoappsindia.com', 'admin@innoappsindia.com', 'admin@innoappsindia.com', 'Admin@189981', 'tls', 0, '2018-11-13 01:36:34', '2019-02-06 07:19:52');

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

--
-- Table structure for table `templates`
--

CREATE TABLE `templates` (
  `id` int(11) NOT NULL,
  `is_default` int(11) NOT NULL DEFAULT '0',
  `name` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject` text COLLATE utf8_unicode_ci,
  `body` text COLLATE utf8_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `templates`
--

INSERT INTO `templates` (`id`, `is_default`, `name`, `category`, `subject`, `body`, `created_at`, `updated_at`) VALUES
(4, 1, 'Welcome Email', 'welcome_email', 'Welcome Email', 'Dear <br>Name: [NAME]<br>Email :[EMAIL]<br>Password :[PASSWORD] <br>Username:[USERNAME]<br>', '2019-01-30 08:23:59', NULL),
(23, 0, 'password change Email', 'password_reset', 'Successfully Changed Password', '<p style=\"margin-left: 275px;\"><img src=\"http://innoappsindia.com/assets/images/logo3.png\" style=\"text-align: center; width: 25%; float: left;\" class=\"note-float-left\"></p><p style=\"margin-left: 250px;\"><br></p><p style=\"text-align: justify;\">Dear [NAME]</p><p style=\"text-align: justify;\">Your password has successfully changed</p>', '2019-02-01 11:27:05', '2019-02-01 11:39:37'),
(24, 0, 'Otp Mail', 'otp_email', 'Reset  Password', '<p style=\"margin-left: 275px;\"><img src=\"http://innoappsindia.com/assets/images/logo3.png\" style=\"text-align: center; width: 50%; float: left;\" class=\"note-float-left\"></p><p style=\"margin-left: 250px;\"><br></p><p style=\"text-align: justify;\"><br></p><p style=\"text-align: justify;\">Dear [NAME]</p><p style=\"text-align: justify;\">Please Use This otp to reset Your password <b>[OTP]</b></p>', '2019-02-01 11:27:05', '2019-02-05 07:29:47');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(10) UNSIGNED NOT NULL,
  `trans_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `franchise_id` int(11) NOT NULL,
  `app_user_id` int(11) NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double NOT NULL,
  `currency` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fee` double NOT NULL,
  `sender` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `receiver` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` 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 `users`
--

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `username` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `first_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mobile` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `database_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_hidden` int(4) NOT NULL DEFAULT '0',
  `designation_id` int(4) DEFAULT NULL,
  `role` int(4) DEFAULT NULL,
  `status` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `email_verified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `password` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `last_login_ip_now` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_login_now` timestamp NULL DEFAULT NULL,
  `last_login_ip` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_login` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `first_name`, `last_name`, `email`, `mobile`, `database_name`, `is_hidden`, `designation_id`, `role`, `status`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `last_login_ip_now`, `last_login_now`, `last_login_ip`, `last_login`) VALUES
(1, 'Admin', 'Admin', 'Admin', 'admin@gmail.com', '9533402327', 'admin123', 1, NULL, 1, 'active', '2019-01-23 18:30:00', '$2y$10$FKfh.vb0x/f/fScsvmvka.mY3Gx4M.i88q9GUXwFPJeDm0gCIwjjO', 'o7LCy3XlKuNzNmMywK55adMx46kDl2At8ERkYJwwT3esfOhhrwOnpivDa93A', '2019-01-23 22:53:24', '2019-02-14 06:43:20', '192.168.100.171', '2019-02-14 06:43:20', '192.168.100.171', '2019-02-14 04:03:40'),
(12, 'hari', 'harisg', 'reddy', 'user@gmail.com', NULL, 'two', 0, NULL, 2, 'active', '2019-01-30 07:33:57', '$2y$10$IrHwOcaznCPQsuS5aNwKEeL2vUfDgVKW45Evk6tfAYi2ESJ8s6VRK', 'y6Jcx4pZktQMU6XM6z6mD4lZ0gUeVbcOpmjipaaUtAi42nZKnSHtAjxWSPsb', '2019-01-30 02:03:57', '2019-02-11 05:20:19', '192.168.100.171', '2019-02-07 11:55:29', '192.168.100.171', '2019-02-05 13:44:21');

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

--
-- Table structure for table `vehicle_manufacturers`
--

CREATE TABLE `vehicle_manufacturers` (
  `id` int(11) NOT NULL COMMENT 'manufacturer id',
  `name` varchar(110) NOT NULL COMMENT 'manufacturer name',
  `about` varchar(110) DEFAULT NULL COMMENT 'about manufacturer',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `vehicle_manufacturers`
--

INSERT INTO `vehicle_manufacturers` (`id`, `name`, `about`, `created_at`, `updated_at`) VALUES
(1, 'TATA Motors', 'TATA Motors', '2019-02-12 06:15:21', '2019-02-12 06:15:21'),
(2, 'Maruti Suzuki', 'Maruti Suzuki', '2019-02-12 06:15:33', '2019-02-12 06:15:33');

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

--
-- Table structure for table `vehicle_models`
--

CREATE TABLE `vehicle_models` (
  `id` int(11) NOT NULL,
  `v_manufacture_id` int(11) NOT NULL COMMENT 'vehicle manufacturer id',
  `name` varchar(110) NOT NULL,
  `about` varchar(110) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `vehicle_models`
--

INSERT INTO `vehicle_models` (`id`, `v_manufacture_id`, `name`, `about`, `updated_at`, `created_at`) VALUES
(1, 1, 'Tiago Revotron XC', 'acd', '2019-02-12 06:15:57', '2019-02-12 06:15:57'),
(2, 1, 'Tiago Revotron', 'vcvcv', '2019-02-12 06:16:08', '2019-02-12 06:16:08'),
(3, 2, 'Maruti Suzuki 123', NULL, '2019-02-12 06:16:18', '2019-02-12 06:16:18'),
(4, 2, 'Maruti Suzuki 456', NULL, '2019-02-12 06:16:30', '2019-02-12 06:16:30'),
(5, 2, 'Maruti Suzuki 589', NULL, '2019-02-12 06:16:30', '2019-02-12 06:16:30');

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

--
-- Table structure for table `vehicle_model_variants`
--

CREATE TABLE `vehicle_model_variants` (
  `id` int(11) NOT NULL,
  `v_model_id` int(11) NOT NULL COMMENT 'vehicel model id',
  `v_manufacture_id` int(11) NOT NULL COMMENT 'manufacturer id',
  `name` varchar(110) NOT NULL,
  `about` varchar(200) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `vehicle_model_variants`
--

INSERT INTO `vehicle_model_variants` (`id`, `v_model_id`, `v_manufacture_id`, `name`, `about`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'T1', NULL, '2019-02-12 06:17:01', '2019-02-12 06:17:01'),
(2, 1, 1, 'T2', NULL, '2019-02-12 06:17:08', '2019-02-12 06:17:08'),
(4, 2, 1, 'T4', NULL, '2019-02-12 06:17:28', '2019-02-12 06:17:28'),
(5, 2, 1, 'T5', NULL, '2019-02-12 06:17:35', '2019-02-12 06:17:35'),
(7, 3, 2, 'M1', NULL, '2019-02-12 06:17:47', '2019-02-12 06:17:47'),
(8, 3, 2, 'M2', NULL, '2019-02-12 06:17:56', '2019-02-12 06:17:56'),
(10, 4, 2, 'M4', NULL, '2019-02-12 06:18:08', '2019-02-12 06:18:08'),
(11, 4, 2, 'M5', NULL, '2019-02-12 06:18:15', '2019-02-12 06:18:15');

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

--
-- Table structure for table `wallets`
--

CREATE TABLE `wallets` (
  `id` int(10) UNSIGNED NOT NULL,
  `app_user_id` int(10) UNSIGNED DEFAULT NULL,
  `balance` double 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 `wallets`
--

INSERT INTO `wallets` (`id`, `app_user_id`, `balance`, `created_at`, `updated_at`) VALUES
(3, 8, 2940, '2019-02-13 08:41:05', '2019-02-13 11:46:41'),
(4, 1, 20.23, '2019-02-13 10:27:08', '2019-02-13 10:27:08');

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

--
-- Table structure for table `wallet_transactions`
--

CREATE TABLE `wallet_transactions` (
  `id` int(10) UNSIGNED NOT NULL,
  `wallet_id` int(10) UNSIGNED NOT NULL,
  `amount` double NOT NULL,
  `hash` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `accepted` tinyint(1) NOT NULL,
  `meta` text 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 `wallet_transactions`
--

INSERT INTO `wallet_transactions` (`id`, `wallet_id`, `amount`, `hash`, `type`, `accepted`, `meta`, `created_at`, `updated_at`) VALUES
(1, 3, 100, 'lwch_5c63d8216e8c4', 'Credited', 1, '{\"stripe_source\":\"ch_BEV2Iih1yzbf4G3HNsfOQ07h\",\"description\":\"Deposit of 100 credits from Stripe Payment\"}', '2019-02-13 08:41:05', '2019-02-13 08:41:05'),
(2, 3, 100, 'lwch_5c63d8a0bf776', 'Credited', 1, '{\"source_name\":\"paytm\",\"source_id\":\"ch_BEV2Iih1yzbf4G3HNsfOQ07h\",\"description\":\"Deposit of 100 credits from Paytm Payment\"}', '2019-02-13 08:43:12', '2019-02-13 08:43:12'),
(3, 3, 100, 'lwch_5c63d8b49e164', 'Credited', 1, '{\"source_name\":\"tez\",\"source_id\":\"ch_BEV2Iih1yzbf4G3HNsfOQ07h\",\"description\":\"Deposit of 100 credits from TEZ Payment\"}', '2019-02-13 08:43:32', '2019-02-13 08:43:32'),
(4, 3, 100, 'OCPP_5c63e8b5f3928', 'Credited', 1, '{\"source_name\":\"tez\",\"source_id\":\"ch_BEV2Iih1yzbf4G3HNsfOQ07h\",\"description\":\"Deposit of 100 credits from TEZ Payment\"}', '2019-02-13 09:51:49', '2019-02-13 09:51:49'),
(5, 3, 400, 'OCPP_5c63e8cb365a8', 'Credited', 1, '{\"source_name\":\"tez\",\"source_id\":\"ch_BEV2Iih1yzbf4G3HNsfOQ07h\",\"description\":\"Deposit of 100 credits from TEZ Payment\"}', '2019-02-13 09:52:11', '2019-02-13 09:52:11'),
(6, 3, 400, 'lwch_5c63ecda0068e', 'debited', 1, '[]', '2019-02-13 10:09:30', '2019-02-13 10:09:30'),
(7, 3, 20, 'lwch_5c63ece11e1a7', 'debited', 1, '[]', '2019-02-13 10:09:37', '2019-02-13 10:09:37'),
(8, 3, 20, 'OCPP_5c63ed365ee9d', 'debited', 1, '[]', '2019-02-13 10:11:02', '2019-02-13 10:11:02'),
(9, 4, 20, 'OCPP_5c63f0fca495f', 'credited', 1, '[]', '2019-02-13 10:27:08', '2019-02-13 10:27:08'),
(10, 3, 2580, 'OCPP_5c6403a1b7889', 'credited', 1, '[]', '2019-02-13 11:46:41', '2019-02-13 11:46:41');

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

--
-- Table structure for table `years`
--

CREATE TABLE `years` (
  `id` int(11) NOT NULL,
  `year` varchar(200) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `years`
--

INSERT INTO `years` (`id`, `year`, `created_at`, `updated_at`) VALUES
(1, '2016', NULL, '2019-02-07 05:33:14'),
(2, '2017', NULL, '2019-02-07 05:33:14'),
(3, '2018', NULL, '2019-02-07 05:33:24'),
(4, '2019', NULL, '2019-02-07 05:33:24');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activities`
--
ALTER TABLE `activities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `app_users`
--
ALTER TABLE `app_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Indexes for table `app_user_profiles`
--
ALTER TABLE `app_user_profiles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_id` (`app_user_id`);

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

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`city_id`),
  ADD UNIQUE KEY `city_name` (`city_name`);

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

--
-- Indexes for table `countrys`
--
ALTER TABLE `countrys`
  ADD PRIMARY KEY (`country_id`);

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

--
-- Indexes for table `custom_field_values`
--
ALTER TABLE `custom_field_values`
  ADD PRIMARY KEY (`id`),
  ADD KEY `field_id` (`field_id`);

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

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

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

--
-- Indexes for table `oauth_access_tokens`
--
ALTER TABLE `oauth_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);

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

--
-- Indexes for table `oauth_clients`
--
ALTER TABLE `oauth_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_clients_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_personal_access_clients_client_id_index` (`client_id`);

--
-- Indexes for table `oauth_refresh_tokens`
--
ALTER TABLE `oauth_refresh_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_unique` (`name`);

--
-- Indexes for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permission_role_role_id_foreign` (`role_id`),
  ADD KEY `index` (`permission_id`,`role_id`) USING BTREE;

--
-- Indexes for table `profiles`
--
ALTER TABLE `profiles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_id` (`user_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_unique` (`name`);

--
-- Indexes for table `role_user`
--
ALTER TABLE `role_user`
  ADD PRIMARY KEY (`user_id`,`role_id`),
  ADD KEY `role_user_role_id_foreign` (`role_id`);

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

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

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

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

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD UNIQUE KEY `username` (`username`);

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

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

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

--
-- Indexes for table `wallets`
--
ALTER TABLE `wallets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wallets_user_id_foreign` (`app_user_id`);

--
-- Indexes for table `wallet_transactions`
--
ALTER TABLE `wallet_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wallet_transactions_wallet_id_foreign` (`wallet_id`);

--
-- Indexes for table `years`
--
ALTER TABLE `years`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `year` (`year`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for table `cities`
--
ALTER TABLE `cities`
  MODIFY `city_id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=566;

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

--
-- AUTO_INCREMENT for table `countrys`
--
ALTER TABLE `countrys`
  MODIFY `country_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `custom_fields`
--
ALTER TABLE `custom_fields`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `custom_field_values`
--
ALTER TABLE `custom_field_values`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `states`
--
ALTER TABLE `states`
  MODIFY `state_id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

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

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

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

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

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `vehicle_manufacturers`
--
ALTER TABLE `vehicle_manufacturers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'manufacturer id', AUTO_INCREMENT=3;

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `custom_field_values`
--
ALTER TABLE `custom_field_values`
  ADD CONSTRAINT `custom_field_values_field_id_foreign` FOREIGN KEY (`field_id`) REFERENCES `custom_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `role_user`
--
ALTER TABLE `role_user`
  ADD CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `wallets`
--
ALTER TABLE `wallets`
  ADD CONSTRAINT `wallets_user_id_foreign` FOREIGN KEY (`app_user_id`) REFERENCES `app_users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `wallet_transactions`
--
ALTER TABLE `wallet_transactions`
  ADD CONSTRAINT `wallet_transactions_wallet_id_foreign` FOREIGN KEY (`wallet_id`) REFERENCES `wallets` (`id`) ON DELETE CASCADE;
COMMIT;

