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

START TRANSACTION;



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

--
-- Table structure for table `pg_city`
--

CREATE TABLE `pg_city` (
  `id` int(11) NOT NULL,
  `city_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `city_code` varchar(3) COLLATE latin1_general_ci NOT NULL,
  `ref_state` int(11) NOT NULL,
  `ref_country` int(11) NOT NULL,
  `region` int(11) NOT NULL,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL,
  `deleted` int(11) NOT NULL,
  `ip` varchar(20) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `pg_city`
--

INSERT INTO `pg_city` (`id`, `city_name`, `city_code`, `ref_state`, `ref_country`, `region`, `updated_at`, `status`, `deleted`, `ip`) VALUES
(37, 'Gondia', 'GON', 1, 1, 4, '2022-08-08 06:18:00', 0, 1, '0'),
(3, 'JAIPUR', '', 24, 1, 2, '2018-08-21 21:42:13', 0, 0, '0'),
(4, 'DOUSA', '', 24, 1, 2, '2018-08-21 21:42:13', 0, 0, '0'),
(5, 'BHARATPUR', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(6, 'ALWAR', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(7, 'DHOULPUR', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(8, 'KAROLI', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(9, 'SIKAR', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(10, 'JHUNJHUNU', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(11, 'AJMER', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(12, 'NAGORE', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(13, 'TONK', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(14, 'SAWAI MADHOPUR', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(15, 'BHILWADA', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(16, 'BANSWADA', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(17, 'CHITTOD', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(18, 'UDAYPUR', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(19, 'PRATAPGADH', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(20, 'DUNGARPUR', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(21, 'RAJSAMAND', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(22, 'JODHAPUR', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(23, 'BADMER', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(24, 'JAISALMER', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(25, 'JALORE', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(26, 'PALI', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(27, 'SEROHI', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(28, 'KOTA', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(29, 'BUNDI', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(30, 'BARA', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(31, 'JHALAWAD', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(32, 'BIKANER', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(33, 'CHURU', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(34, 'HANUMANGADH', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(35, 'GANGANAGAR', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(36, 'Nagpur', 'NGP', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(38, 'Wardha', 'WAR', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(39, 'Bhandara', 'BHA', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(40, 'Gadchiroli', 'GAD', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(41, 'Chandrapur', 'CHA', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(42, 'Mumbai', 'MUM', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(43, 'Pune', 'PUN', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(44, 'Nasik', 'NAS', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(45, 'Latur', 'LAT', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(46, 'Shirdi', 'SHR', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(47, 'Shegaon', 'SHE', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(48, 'Aurangabad (MAHARASHTRA)', 'AUR', 1, 1, 4, '2018-08-31 05:26:39', 0, 0, '0'),
(49, 'Ahmadnagar', 'AHN', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1052, 'NORTH AND MIDDLE ANDAMAN', '', 193, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(51, 'Sakoli', 'SAK', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(52, 'Amravati', 'AMR', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(53, 'Akola', 'AKL', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(54, 'Badnera', 'BAD', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(55, 'Buldhana', 'BUL', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(56, 'Khamgaon', 'KHA', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(57, 'Jabalpur', 'JAB', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(58, 'Bhopal', 'BHP', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(59, 'Betul', 'BET', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(60, 'Hyderabad', 'HYD', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(61, 'Secunderabad', 'SEC', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(62, 'Guntur', 'GUN', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(63, 'Mohali', 'MOH', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(64, 'Ahmedabad', 'AHM', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(65, 'Porbandar', 'POR', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(66, 'Srinagar', 'SRI', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(67, 'Ranchi', 'RAN', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(68, 'Jamshedpur', 'JAM', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(69, 'Itanagar', 'ITN', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(70, 'Dispur', 'DIS', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(71, 'Patna', 'PAT', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(72, 'Raipur', 'RAI', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(73, 'Gandhinagar', 'GAN', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(74, 'Chandigarh', 'CHA', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(75, 'Shimla', 'SHI', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(76, 'Bangalore', 'BAN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(77, 'Thiruvananthapuram', 'THI', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(78, 'Imphal', 'IMP', 19, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(79, 'Shillong', 'SHI', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(80, 'Aizawi', 'AIZ', 21, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(81, 'Kohima', 'KOH', 22, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(82, 'Bhubaneshwar', 'BHU', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(83, 'Gangtok', 'GAN', 25, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(84, 'Chennai', 'CHE', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(85, 'Agartala', 'AGA', 26, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(86, 'Dehradun', 'DEH', 8, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(87, 'Lucknow', 'LUC', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(88, 'Kolkata', 'KOL', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(89, 'Washim', 'WAS', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(90, 'Yavatmal', 'YAV', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(91, 'Beed', 'BEE', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(92, 'Hingoli', 'HIN', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(93, 'Jalna', 'JAL', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(94, 'Nanded', 'NAN', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(95, 'Osmanabad', 'OSM', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(96, 'Parbhani', 'PAR', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(97, 'Raigad', 'RAI', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(98, 'Ratnagiri', 'RAT', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(99, 'Sindhudurg', 'SIN', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(100, 'Thane', 'THA', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(101, 'Dhule', 'DHU', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(102, 'Jalgaon', 'JAL', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(103, 'Nandurbar', 'NAN', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(104, 'Kolhapur', 'KOL', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(105, 'Sangli', 'SAN', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(106, 'Solapur', 'SOL', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(107, 'Satara', 'SAT', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(267, 'Balaghat', 'BAL', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(268, 'Bhilai', 'BHI', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(269, 'Dindori', 'DIN', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(270, 'Dhar', 'DHA', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(271, 'Datia', 'DAT', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(272, 'Damoh', 'DAM', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(273, 'Chhindwara', 'CHH', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(274, 'Chhatarpur', 'CHH', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(275, 'Burhanpur', 'BUR', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(276, 'Bhind', 'BHI', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(277, 'Barwani', 'BAR', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(278, 'Ashoknagar', 'ASH', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(279, 'Anuppur', 'ANU', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(280, 'Alirajpur', 'ALI', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(281, 'Pachmarhi ', 'PAC', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(282, 'Indore ', 'IND', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(283, 'Ratlam ', 'RAT', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(284, 'Dewas ', 'DEW', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(285, 'Gwalior ', 'GWA', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(286, 'Jagdalpur ', 'JAG', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(287, 'Ujjain ', 'UJJ', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(288, 'Sagar', 'SAG', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(289, 'Gopalpur ', 'GOP', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(290, 'Chandbali ', 'CHA', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(291, 'Paradip Garh  ', 'PAR', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(292, 'Puri', 'PUR', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(293, 'Rourkela', 'ROU', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(294, 'Tarapur', 'TAR', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(295, 'Bairoi', 'BAI', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(296, 'Baghmara', 'BAG', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(297, 'Cherrapunji', 'CHE', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(298, 'Jowai', 'JOW', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(299, 'Madanrting', 'MAD', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(300, 'Mairang', 'MAI', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(301, 'Mawlai', 'MAW', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(302, 'Nongmynsong', 'NON', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(303, 'Nongpoh', 'NON', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(304, 'Nongstoin', 'NON', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(305, 'Nongthymmai', 'NON', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(306, 'Pynthorumkhrah', 'PYN', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(307, 'Resubelpara', 'RES', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(308, 'Tura', 'TUR', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(309, 'Williamnagar', 'WIL', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(321, 'Gurdaspur', 'GUR', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(322, 'Jalandhar', 'JAL', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(323, 'Moga', 'MOG', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(324, 'Ludhiana', 'LUD', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(325, 'Bhatinda', 'BHA', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(326, 'Patiala', 'PAT', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(327, 'Hoshiarpur', 'HOS', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(328, 'Nawanshar', 'NAW', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(329, 'Faridkot', 'FAR', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(330, 'Ropar', 'ROP', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(331, 'Mansa', 'MAN', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(332, 'Fatehgarh Sahib', 'FAT', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(333, 'Amritsar', 'AMR', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(334, 'Ferozepur', 'FER', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(335, 'Kapurthala', 'KAP', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(336, 'Muktsar', 'MUK', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(337, 'Sangrur', 'SAN', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(338, 'Bishnupur', 'BIS', 19, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(339, 'Chandel', 'CHA', 19, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(340, 'Churachandpur', 'CHU', 19, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(341, 'Senapati', 'SEN', 19, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(342, 'Tamenglong', 'TAM', 19, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(343, 'Ukhrul', 'UKH', 19, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(344, 'Kolasib', 'KOL', 21, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(345, 'Vairengte', 'VAI', 21, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(348, 'Champai', 'CHA', 21, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(347, 'Mamit', 'MAM', 21, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(349, 'Lunglei', 'LUN', 21, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(350, 'Vishakhapatnam', 'VIS', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(351, 'Vijayawada', 'VIJ', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(352, 'Warangal', 'WAR', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(353, 'Akashiganga', 'AKA', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(354, 'Bhalukpong', 'BHA', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(355, 'Bhismaknagar', 'BHI', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(356, 'Bomdila', 'BOM', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(357, 'Malinithan', 'MAL', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(358, 'Digboi', 'DIG', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(359, 'Guwahati', 'GUW', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(360, 'Haflong', 'HAF', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(361, 'Hajo', 'HAJ', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(362, 'Majuli', 'MAJ', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(363, 'Sibsagar', 'SIB', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(364, 'Tezpur', 'TEZ', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(365, 'Darbhanga', 'DAR', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(366, 'Gaya', 'GAY', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(367, 'Muzaffarpur', 'MUZ', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(368, 'Vaishali', 'VAI', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(369, 'Bhagalpur', 'BHA', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(370, 'Ara', 'ARA', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(371, 'Purnia', 'PUR', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(372, 'Danapur', 'DAN', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(373, 'Hajipur', 'HAJ', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(374, 'Bettiah', 'BET', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(375, 'Motihari', 'MOT', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(376, 'Begusarai', 'BEG', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(377, 'Nawada', 'NAW', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(378, 'Chhatapur', 'CHH', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(379, 'Kharagpur', 'KHA', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(380, 'Bilaspur', 'BIL', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(381, 'Dantewada', 'DAN', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(382, 'Durg', 'DUR', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(383, 'Raigarh', 'RAI', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(384, 'Panaji', 'PAN', 16, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(385, 'Margao', 'MAR', 16, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(386, 'Mapusa', 'MAP', 16, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(387, 'Ponda', 'PON', 16, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(388, 'Canacona', 'CAN', 16, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(389, 'Vasco da Gama', 'VAS', 16, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(390, 'Pernem', 'PER', 16, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(391, 'Dwarka  ', 'DWA', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(392, 'Mangrol', 'MAN', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(393, 'Baroda ', 'BAR', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(394, 'Kundla ', 'KUN', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(395, 'Kandla ', 'KAN', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(396, 'Jodia ', 'JOD', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(397, 'Bedi', 'BED', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(398, 'Godhra', 'GOD', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(399, 'Veraval ', 'VER', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(400, 'Gandhidham ', 'GAN', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(401, 'Kotda', 'KOT', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(402, 'Rajkot ', 'RAJ', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(403, 'Surat', 'SUR', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(404, 'Bhavnagar ', 'BHA', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(405, 'Ankleshwar  ', 'ANK', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(406, 'Bharoch ', 'BHA', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(407, 'Vadodora ', 'VAD', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(408, 'Panipat', 'PAN', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(409, 'Hissar', 'HIS', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(410, 'Gurgaon', 'GUR', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(411, 'Ambala', 'AMB', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(412, 'Faridabad', 'FAR', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(413, 'Sonipat', 'SON', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(414, 'Karnal', 'KAR', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(415, 'Rohtak', 'ROH', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(416, 'Yamunanagar', 'YAM', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(417, 'Chail', 'CHA', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(418, 'Chamba', 'CHA', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(419, 'Dalhousie', 'DAL', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(420, 'Dharamshala', 'DHA', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(421, 'Manali', 'MAN', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(422, 'Palampur', 'PAL', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(423, 'Pragpur', 'PRA', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(424, 'Leh', 'LEH', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(425, 'Akhnoor', 'AKH', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(426, 'Anantnag', 'ANA', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(427, 'Badgam', 'BAD', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(428, 'Bandipur', 'BAN', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(429, 'Baramulla', 'BAR', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(430, 'Basholi', 'BAS', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(431, 'Bedarwah', 'BED', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(432, 'Doda', 'DOD', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(433, 'Gulmarg', 'GUL', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(434, 'Jammu', 'JAM', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(435, 'Kalakot', 'KAL', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(436, 'Kargil', 'KAR', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(437, 'Karnah', 'KAR', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(438, 'Kathua', 'KAT', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(439, 'Kishtwar', 'KIS', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(440, 'Kulgam', 'KUL', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(441, 'Kupwara', 'KUP', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(442, 'Mahore', 'MAH', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(443, 'Nagrota', 'NAG', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(444, 'Nobra', 'NOB', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(445, 'Nowshera', 'NOW', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(446, 'Nyoma', 'NYO', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(447, 'Padam', 'PAD', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(448, 'Pahalgam', 'PAH', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(449, 'Patnitop', 'PAT', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(450, 'Poonch', 'POO', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(451, 'Pulwama', 'PUL', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(452, 'Rajouri', 'RAJ', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(453, 'Ramban', 'RAM', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(454, 'Ramnagar', 'RAM', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(455, 'Reasi', 'REA', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(456, 'Samba', 'SAM', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(457, 'Udhampur', 'UDH', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(458, 'Vaishno Devi', 'VAI', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(459, 'Bokaro', 'BOK', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(460, 'Gumla', 'GUM', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(461, 'Sindri  ', 'SIN', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(462, 'Deoghar', 'DEO', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(463, 'Hazaribagh ', 'HAZ', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(464, 'Dhanbad', 'DHA', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(465, 'Dumka', 'DUM', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(466, 'Ghatshila', 'GHA', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(467, 'Kodarma', 'KOD', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(468, 'Afzalpur', 'AFZ', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(469, 'Ainapur', 'AIN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(470, 'Aland', 'ALA', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(471, 'Alur', 'ALU', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(472, 'Anekal', 'ANE', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(473, 'Ankola', 'ANK', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(474, 'Arsikere', 'ARS', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(475, 'Athani', 'ATH', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(476, 'Aurad', 'AUR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(477, 'Bableshwar', 'BAB', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(478, 'Badami', 'BAD', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(479, 'Bagalkot', 'BAG', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(480, 'Bagepalli', 'BAG', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(481, 'Bailhongal', 'BAI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(482, 'Bangalore', 'BAN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(483, 'Bangarpet', 'BAN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(484, 'Bantwal', 'BAN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(485, 'Basavakalyan', 'BAS', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(486, 'Basavanabagewadi', 'BAS', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(487, 'Basavapatna', 'BAS', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(488, 'Belgaum', 'BEL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(489, 'Bellary', 'BEL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(490, 'Belthangady', 'BEL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(491, 'Belur', 'BEL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(492, 'Bhadravati', 'BHA', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(493, 'Bhalki', 'BHA', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(494, 'Bhatkal', 'BHA', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(495, 'Bidar', 'BID', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(496, 'Bijapur', 'BIJ', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(497, 'Biligi', 'BIL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(498, 'Chadchan', 'CHA', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(499, 'Challakere', 'CHA', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(500, 'Chamrajnagar', 'CHA', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(501, 'Channagiri', 'CHA', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(502, 'Channapatna', 'CHA', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(503, 'Channarayapatna', 'CHA', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(504, 'Chikkaballapur', 'CHI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(505, 'Chikkanayakanahalli', 'CHI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(506, 'Chikkodi', 'CHI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(507, 'Chikmagalur', 'CHI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(508, 'Chincholi', 'CHI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(509, 'Chintamani', 'CHI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(510, 'Chitradurga', 'CHI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(511, 'Chittapur', 'CHI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(512, 'Cowdahalli', 'COW', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(513, 'Deodurga', 'DEO', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(514, 'Devangere', 'DEV', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(515, 'Devarahippargi', 'DEV', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(516, 'Doddaballapur', 'DOD', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(517, 'Gadag', 'GAD', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(518, 'Gangavathi', 'GAN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(519, 'Gokak', 'GOK', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(520, 'Gowribdanpur', 'GOW', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(521, 'Gubbi', 'GUB', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(522, 'Gulbarga', 'GUL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(523, 'Gundlupet', 'GUN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(524, 'H.B.Halli', 'H.B', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(525, 'H.D. Kote', 'H.D', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(526, 'Haliyal', 'HAL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(527, 'Hangal', 'HAN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(528, 'Harapanahalli', 'HAR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(529, 'Hassan', 'HAS', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(530, 'Haveri', 'HAV', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(531, 'Hebri', 'HEB', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(532, 'Hirekerur', 'HIR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(533, 'Hiriyur', 'HIR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(534, 'Holalkere', 'HOL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(535, 'Holenarsipur', 'HOL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(536, 'Honnali', 'HON', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(537, 'Honnavar', 'HON', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(538, 'Hosadurga', 'HOS', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(539, 'Hosakote', 'HOS', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(540, 'Hosanagara', 'HOS', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(541, 'Hospet', 'HOS', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(542, 'Hubli', 'HUB', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(543, 'Hukkeri', 'HUK', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(544, 'Humnabad', 'HUM', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(545, 'Hungund', 'HUN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(546, 'Hunsagi', 'HUN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(547, 'Hunsur', 'HUN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(548, 'Huvinahadagali', 'HUV', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(549, 'Indi', 'IND', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(550, 'Jagalur', 'JAG', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(551, 'Jamkhandi', 'JAM', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(552, 'Jewargi', 'JEW', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(553, 'Joida', 'JOI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(554, 'K.R. Nagar', 'K.R', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(555, 'Kadur', 'KAD', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(556, 'Kalghatagi', 'KAL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(557, 'Kamalapur', 'KAM', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(558, 'Kanakapura', 'KAN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(559, 'Kargal', 'KAR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(560, 'Karkala', 'KAR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(561, 'Karwar', 'KAR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(562, 'Khanapur', 'KHA', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(563, 'Kolar', 'KOL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(564, 'Kollegal', 'KOL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(565, 'Koppa', 'KOP', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(566, 'Koppal', 'KOP', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(567, 'Koratageri', 'KOR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(568, 'Krishnarajapet', 'KRI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(569, 'Kudligi', 'KUD', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(570, 'Kumta', 'KUM', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(571, 'Kundapur', 'KUN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(572, 'Kundgol', 'KUN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(573, 'Kunigal', 'KUN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(574, 'Kurugodu', 'KUR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(575, 'Kustagi', 'KUS', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(576, 'Lingsugur', 'LIN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(577, 'Madikeri', 'MAD', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(578, 'Madugiri', 'MAD', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(579, 'Malavalli', 'MAL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(580, 'Malur', 'MAL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(581, 'Mandya', 'MAN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(582, 'Mangalore', 'MAN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(583, 'Manvi', 'MAN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(584, 'Mashal', 'MAS', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(585, 'Molkalmuru', 'MOL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(586, 'Mudalgi', 'MUD', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(587, 'Muddebihal', 'MUD', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(588, 'Mudhol', 'MUD', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(589, 'Mudigere', 'MUD', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(590, 'Mulbagal', 'MUL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(591, 'Mundagod', 'MUN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(592, 'Mundargi', 'MUN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(593, 'Murugod', 'MUR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(594, 'Mysore', 'MYS', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(595, 'Nagamangala', 'NAG', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(596, 'Nanjangud', 'NAN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(597, 'Nargund', 'NAR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(598, 'Narsimrajapur', 'NAR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(599, 'Navalgund', 'NAV', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(600, 'Nelamangala', 'NEL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(601, 'Nimburga', 'NIM', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(602, 'Pandavapura', 'PAN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(603, 'Pavagada', 'PAV', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(604, 'Puttur', 'PUT', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(605, 'Raibag', 'RAI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(606, 'Raichur', 'RAI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(607, 'Ramdurg', 'RAM', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(608, 'Ranebennur', 'RAN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(609, 'Ron', 'RON', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(610, 'Sagar', 'SAG', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(611, 'Sakleshpur', 'SAK', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(612, 'Salkani', 'SAL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(613, 'Sandur', 'SAN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(614, 'Saundatti', 'SAU', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(615, 'Savanur', 'SAV', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(616, 'Sedam', 'SED', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(617, 'Shahapur', 'SHA', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(618, 'Shankarnarayana', 'SHA', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(619, 'Shikaripura', 'SHI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(620, 'Shimoga', 'SHI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(621, 'Shirahatti', 'SHI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(622, 'Shorapur', 'SHO', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(623, 'Siddapur', 'SID', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(624, 'Sidlaghatta', 'SID', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(625, 'Sindagi', 'SIN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(626, 'Sindhanur', 'SIN', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(627, 'Sira', 'SIR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(628, 'Sirsi', 'SIR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(629, 'Siruguppa', 'SIR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(630, 'Somwarpet', 'SOM', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(631, 'Sorab', 'SOR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(632, 'Sriniwaspur', 'SRI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(633, 'Sullia', 'SUL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(634, 'T. Narsipur', 'T. ', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(635, 'Tallak', 'TAL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(636, 'Tarikere', 'TAR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(637, 'Telgi', 'TEL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(638, 'Thirthahalli', 'THI', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(639, 'Tiptur', 'TIP', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(640, 'Tumkur', 'TUM', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(641, 'Turuvekere', 'TUR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(642, 'Udupi', 'UDU', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(643, 'Virajpet', 'VIR', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(644, 'Wadi', 'WAD', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(645, 'Yadgiri', 'YAD', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(646, 'Yelburga', 'YEL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(647, 'Yellapur', 'YEL', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(649, 'Cochin', 'COC', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(650, 'Koilthottum  ', 'KOI', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(651, 'Kozhikode', 'KOZ', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(652, 'Azhikkal ', 'AZH', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(653, 'Beypore', 'BEY', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(654, 'Aroor', 'ARO', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(655, 'Anijengo', 'ANI', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(656, 'Leapuram', 'LEA', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(657, 'Kondiapetnam', 'KON', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(658, 'Nindakara  ', 'NIN', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(659, 'Kankudy ', 'KAN', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(660, 'Cannanore ', 'CAN', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(661, 'Ernakulam ', 'ERN', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(662, 'Badagara ', 'BAD', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(663, 'Ponnani ', 'PON', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(664, 'Alleppey ', 'ALL', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(665, 'Palghat  ', 'PAL', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(666, 'Tellicherry', 'TEL', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(667, 'Rajakkamangalam ', 'RAJ', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(668, 'Mallipuram ', 'MAL', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(669, 'Kasargod', 'KAS', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(670, 'Dimapur', 'DIM', 22, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(671, 'Dzukou Valley', 'DZU', 22, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(672, 'Mon', 'MON', 22, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(673, 'Mokokchung', 'MOK', 22, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(674, 'Wokha', 'WOK', 22, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(675, 'Tuensang', 'TUE', 22, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(676, 'Phek', 'PHE', 22, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(751, 'DELHI', 'DL', 192, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1299, 'PANNA', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(753, 'NEW DELHI', 'DL', 192, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1284, 'WAYANAD', '', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1283, 'THRISSUR', '', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1282, 'PATHANAMTHITTA', '', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1281, 'PALAKKAD', '', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1280, 'MALAPPURAM', '', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1279, 'KOTTAYAM', '', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1278, 'KOLLAM', '', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1277, 'KASARAGOD', '', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1276, 'KANNUR', '', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1275, 'IDUKKI', '', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1274, 'ALAPPUZHA', '', 10, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1273, 'YADGIR', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1272, 'VIJAYAPURA', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1271, 'UTTAR KANNAD', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1270, 'TUMAKURU', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1269, 'SHIVAMOGGA', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1268, 'RAMANAGARA', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1267, 'MYSURU', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1266, 'KODAGU', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1265, 'KALABURAGI', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1264, 'DHARWAD', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1263, 'DAVANGERE', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1262, 'DAKSHIN KANNAD', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1261, 'CHIKKAMAGALURU', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1260, 'CHIKBALLAPUR', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1259, 'CHAMARAJANAGAR', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1258, 'BENGALURU URBAN', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1257, 'BENGALURU RURAL', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1256, 'BELAGAVI', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1255, 'BALLARI', '', 18, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1254, 'WEST SINGHBHUM', '', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1253, 'SIMDEGA', '', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1252, 'SARAIKELA KHARSAWAN', '', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1251, 'SAHEBGANJ', '', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1250, 'RAMGARH', '', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1249, 'PALAMU', '', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1248, 'PAKUR', '', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1247, 'LOHARDAGA', '', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1246, 'LATEHAR', '', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1245, 'KODERMA', '', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1244, 'KHUNTI', '', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1243, 'JAMTARA', '', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1242, 'GODDA', '', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1241, 'GIRIDIH', '', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1240, 'GARHWA', '', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1239, 'EAST SINGHBUM', '', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1238, 'CHATRA', '', 7, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1237, 'SHOPIAN', '', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1236, 'RAJAURI', '', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1235, 'LEH LADAKH', '', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1234, 'GANDERBAL', '', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1233, 'BANDIPORA', '', 17, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1232, 'UNA', '', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1231, 'SOLAN', '', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1230, 'SIRMAUR', '', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1229, 'MANDI', '', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1228, 'LAHUL AND SPITI', '', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1227, 'KULLU', '', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1226, 'KINNAUR', '', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1225, 'KANGRA', '', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1224, 'HAMIRPUR', '', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1223, 'BILASPUR', '', 28, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1222, 'SIRSA', '', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1221, 'REWARI', '', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1220, 'PANCHKULA', '', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(825, 'DELHI EAST', 'DL', 192, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1219, 'PALWAL', '', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1218, 'MEWAT', '', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1217, 'MAHENDRAGARH', '', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1216, 'KURUKSHETRA', '', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1215, 'KAITHAL', '', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1214, 'JIND', '', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1213, 'JHAJJAR', '', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1212, 'HISAR', '', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1211, 'GURUGRAM', '', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1210, 'FATEHABAD', '', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1209, 'CHARKI DADRI', '', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1208, 'BHIWANI', '', 5, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1207, 'VALSAD', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1206, 'VADODARA', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1205, 'TAPI', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1204, 'SURENDRANAGAR', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1203, 'SABAR KANTHA', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(843, 'DELHI NORTH EAST', 'DL', 192, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1202, 'PATAN', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1201, 'PANCH MAHALS', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1200, 'NAVSARI', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1199, 'NARMADA', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1198, 'MORBI', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1197, 'Mahisagar', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1196, 'MAHESANA', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1195, 'KHEDA', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1194, 'KACHCHH', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1193, 'JUNAGADH', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1192, 'JAMNAGAR', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1191, 'GIR SOMNATH', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1190, 'DOHAD', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1189, 'DEVBHUMI DWARKA', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1188, 'DANG', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1187, 'CHHOTAUDEPUR', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1186, 'BOTAD', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1185, 'BHARUCH', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1184, 'BANAS KANTHA', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1183, 'ARVALLI', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1182, 'ANAND', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1181, 'AMRELI', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1180, 'AHMADABAD', '', 6, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1179, 'SOUTH GOA', '', 16, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1178, 'NORTH GOA', '', 16, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1177, 'WEST', '', 192, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1176, 'SOUTH WEST', '', 192, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1175, 'South East', '', 192, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1174, 'SOUTH', '', 192, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1173, 'SHAHDARA', '', 192, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1172, 'NORTH WEST', '', 192, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1171, 'NORTH EAST', '', 192, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1170, 'NORTH', '', 192, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1169, 'EAST', '', 192, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1168, 'CENTRAL', '', 192, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1167, 'DIU', '', 189, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1166, 'DAMAN', '', 189, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1298, 'NEEMUCH', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1297, 'NARSINGHPUR', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1296, 'MORENA', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1295, 'MANDSAUR', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1294, 'MANDLA', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1293, 'KHARGONE', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1292, 'KATNI', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1291, 'JHABUA', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1290, 'HOSHANGABAD', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1289, 'HARDA', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1288, 'GUNA', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1287, 'EAST NIMAR  (KHANDWA)', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1286, 'AGAR MALWA', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1285, 'LAKSHADWEEP DISTRICT', '', 194, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1165, 'DADRA AND NAGAR HAVELI', '', 188, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1164, 'SURGUJA', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1163, 'SURAJPUR', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1162, 'SUKMA', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1161, 'RAJNANDGAON', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1160, 'NARAYANPUR', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1159, 'MUNGELI', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1158, 'MAHASAMUND', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1157, 'KOREA', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1156, 'KORBA', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1155, 'KONDAGAON', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1154, 'KANKER', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1153, 'KABIRDHAM', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1152, 'JASHPUR', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1151, 'JANJGIR-CHAMPA', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1150, 'GARIYABAND', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1149, 'DHAMTARI', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1148, 'BIJAPUR', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1147, 'BEMETARA', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1146, 'BASTAR', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1145, 'BALRAMPUR', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1144, 'BALODA BAZAR', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1143, 'BALOD', '', 15, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1142, 'CHANDIGARH', '', 187, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1141, 'SUPAUL', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1140, 'SIWAN', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1139, 'SITAMARHI', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1138, 'SHEOHAR', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1137, 'SHEIKHPURA', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1136, 'SARAN', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1135, 'SAMASTIPUR', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1134, 'SAHARSA', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1133, 'ROHTAS', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1132, 'PURBI CHAMPARAN', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1131, 'PASHCHIM CHAMPARAN', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1130, 'NALANDA', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1129, 'MUNGER', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1128, 'MADHUBANI', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1127, 'MADHEPURA', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1126, 'LAKHISARAI', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1125, 'AURANGABAD (BIHAR)', '', 14, 1, 6, '2018-08-31 05:26:21', 0, 0, '0'),
(1124, 'UDALGURI', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1123, 'TINSUKIA', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1122, 'SONITPUR', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1121, 'SIVASAGAR', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1120, 'NALBARI', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1119, 'NAGAON', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1118, 'MARIGAON', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1117, 'LAKHIMPUR', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1116, 'KOKRAJHAR', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1115, 'KARIMGANJ', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1114, 'KARBI ANGLONG', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1113, 'KAMRUP METRO', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1112, 'KAMRUP', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1111, 'JORHAT', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1110, 'HAILAKANDI', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1109, 'GOLAGHAT', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1108, 'GOALPARA', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1107, 'DIMA HASAO', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1106, 'DIBRUGARH', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1105, 'DHUBRI', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1104, 'DHEMAJI', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1103, 'DARRANG', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1102, 'CHIRANG', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1101, 'CACHAR', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1100, 'BONGAIGAON', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1099, 'BARPETA', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1098, 'BAKSA', '', 13, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1097, 'WEST SIANG', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1096, 'WEST KAMENG', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1095, 'UPPER SUBANSIRI', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1094, 'UPPER SIANG', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1093, 'TIRAP', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1092, 'TAWANG', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1091, 'SIANG', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1090, 'PAPUM PARE', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1089, 'NAMSAI', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1088, 'LOWER SUBANSIRI', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1087, 'LOWER DIBANG VALLEY', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1086, 'LONGDING', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1085, 'LOHIT', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1084, 'KURUNG KUMEY', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1083, 'Kra Daadi', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1082, 'EAST SIANG', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1081, 'EAST KAMENG', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1080, 'DIBANG VALLEY', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1079, 'CHANGLANG', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1078, 'ANJAW', '', 12, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1077, 'Y.S.R.', '', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1076, 'WEST GODAVARI', '', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1075, 'VIZIANAGARAM', '', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1074, 'VISAKHAPATANAM', '', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1073, 'SRIKAKULAM', '', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1072, 'SPSR NELLORE', '', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1071, 'PRAKASAM', '', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1070, 'KURNOOL', '', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1069, 'KRISHNA', '', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1068, 'EAST GODAVARI', '', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1067, 'CHITTOOR', '', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1066, 'ANANTAPUR', '', 4, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1065, 'KISHANGANJ', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1064, 'KHAGARIA', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1063, 'KATIHAR', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1062, 'KAIMUR (BHABUA)', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1061, 'JEHANABAD', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0');
INSERT INTO `pg_city` (`id`, `city_name`, `city_code`, `ref_state`, `ref_country`, `region`, `updated_at`, `status`, `deleted`, `ip`) VALUES
(1060, 'JAMUI', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1059, 'GOPALGANJ', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1058, 'BUXAR', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1057, 'BHOJPUR', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1056, 'BANKA', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1055, 'ARWAL', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1054, 'ARARIA', '', 14, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1053, 'SOUTH ANDAMANS', '', 193, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1051, 'NICOBARS', '', 193, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1300, 'RAISEN', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1301, 'RAJGARH', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1302, 'REWA', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1303, 'SATNA', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1304, 'SEHORE', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1305, 'SEONI', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1306, 'SHAHDOL', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1307, 'SHAJAPUR', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1308, 'SHEOPUR', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1309, 'SHIVPURI', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1310, 'SIDHI', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1311, 'SINGRAULI', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1312, 'TIKAMGARH', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1313, 'UMARIA', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1314, 'VIDISHA', '', 3, 1, 5, '2018-08-25 01:19:14', 0, 0, '0'),
(1315, 'AHMEDNAGAR', '', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1316, 'MUMBAI SUBURBAN', '', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1317, 'NASHIK', '', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1318, 'PALGHAR', '', 1, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1319, 'IMPHAL EAST', '', 19, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1320, 'IMPHAL WEST', '', 19, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1321, 'THOUBAL', '', 19, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1322, 'EAST GARO HILLS', '', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1323, 'EAST JAINTIA HILLS', '', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1324, 'EAST KHASI HILLS', '', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1325, 'NORTH GARO HILLS', '', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1326, 'RI BHOI', '', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1327, 'SOUTH GARO HILLS', '', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1328, 'SOUTH WEST GARO HILLS', '', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1329, 'SOUTH WEST KHASI HILLS', '', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1330, 'WEST GARO HILLS', '', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1331, 'WEST JAINTIA HILLS', '', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1332, 'WEST KHASI HILLS', '', 20, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1333, 'AIZAWL', '', 21, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1334, 'CHAMPHAI', '', 21, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1335, 'LAWNGTLAI', '', 21, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1336, 'SAIHA', '', 21, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1337, 'SERCHHIP', '', 21, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1338, 'KIPHIRE', '', 22, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1339, 'LONGLENG', '', 22, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1340, 'PEREN', '', 22, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1341, 'ZUNHEBOTO', '', 22, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1342, 'ANUGUL', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1343, 'BALANGIR', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1344, 'BALESHWAR', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1345, 'BARGARH', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1346, 'BHADRAK', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1347, 'BOUDH', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1348, 'CUTTACK', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1349, 'DEOGARH', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1350, 'DHENKANAL', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1351, 'GAJAPATI', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1352, 'GANJAM', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1353, 'JAGATSINGHAPUR', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1354, 'JAJAPUR', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1355, 'JHARSUGUDA', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1356, 'KALAHANDI', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1357, 'KANDHAMAL', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1358, 'KENDRAPARA', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1359, 'KENDUJHAR', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1360, 'KHORDHA', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1361, 'KORAPUT', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1362, 'MALKANGIRI', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1363, 'MAYURBHANJ', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1364, 'NABARANGPUR', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1365, 'NAYAGARH', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1366, 'NUAPADA', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1367, 'RAYAGADA', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1368, 'SAMBALPUR', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1369, 'SONEPUR', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1370, 'SUNDARGARH', '', 23, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1371, 'KARAIKAL', '', 190, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1372, 'MAHE', '', 190, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1373, 'PONDICHERRY', '', 190, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1374, 'YANAM', '', 190, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1375, 'BARNALA', '', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1376, 'BATHINDA', '', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1377, 'FAZILKA', '', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1378, 'FIROZEPUR', '', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1379, 'NAWANSHAHR', '', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1380, 'PATHANKOT', '', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1381, 'RUPNAGAR', '', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1382, 'S.A.S NAGAR', '', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1383, 'SRI MUKTSAR SAHIB', '', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1384, 'TARN TARAN', '', 9, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1385, 'BANSWARA', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(1386, 'BARAN', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(1387, 'BARMER', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(1388, 'BHILWARA', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(1389, 'CHITTORGARH', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(1390, 'DAUSA', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(1391, 'DHOLPUR', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(1392, 'SHRIDUNGARGARH', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(1393, 'HANUMANGARH', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(1394, 'JHALAWAR', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(1395, 'JODHPUR', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(1396, 'KARAULI', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(1397, 'NAGAUR', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(1398, 'PRATAPGARH', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(1399, 'SIROHI', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(1400, 'UDAIPUR', '', 24, 1, 2, '2018-08-25 01:19:14', 0, 0, '0'),
(1401, 'EAST DISTRICT', '', 25, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1402, 'NORTH DISTRICT', '', 25, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1403, 'SOUTH DISTRICT', '', 25, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1404, 'WEST DISTRICT', '', 25, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1405, 'ARIYALUR', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1406, 'COIMBATORE', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1407, 'CUDDALORE', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1408, 'DHARMAPURI', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1409, 'DINDIGUL', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1410, 'ERODE', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1411, 'KANCHIPURAM', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1412, 'KANNIYAKUMARI', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1413, 'KARUR', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1414, 'KRISHNAGIRI', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1415, 'MADURAI', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1416, 'NAGAPATTINAM', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1417, 'NAMAKKAL', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1418, 'PERAMBALUR', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1419, 'PUDUKKOTTAI', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1420, 'RAMANATHAPURAM', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1421, 'SALEM', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1422, 'SIVAGANGA', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1423, 'THANJAVUR', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1424, 'THENI', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1425, 'THE NILGIRIS', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1426, 'THIRUVALLUR', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1427, 'THIRUVARUR', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1428, 'TIRUCHIRAPPALLI', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1429, 'TIRUNELVELI', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1430, 'TIRUPPUR', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1431, 'TIRUVANNAMALAI', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1432, 'TUTICORIN', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1433, 'VELLORE', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1434, 'VILLUPURAM', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1435, 'VIRUDHUNAGAR', '', 11, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1436, 'ADILABAD', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1437, 'BHADRADRI', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1438, 'HYDERABAD', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1439, 'JAGITIAL', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1440, 'JANGOAN', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1441, 'JAYASHANKAR', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1442, 'JOGULAMBA', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1443, 'KAMAREDDY', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1444, 'KARIMNAGAR', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1445, 'KHAMMAM', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1446, 'KOMARAM BHEEM ASIFABAD', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1447, 'MAHABUBABAD', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1448, 'MAHBUBNAGAR', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1449, 'MANCHERIAL', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1450, 'MEDAK', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1451, 'MEDCHAL', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1452, 'NAGARKURNOOL', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1453, 'NALGONDA', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1454, 'NIRMAL', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1455, 'NIZAMABAD', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1456, 'PEDDAPALLI', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1457, 'RAJANNA', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1458, 'RANGAREDDI', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1459, 'SANGAREDDY', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1460, 'SIDDIPET', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1461, 'SURYAPET', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1462, 'VIKARABAD', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1463, 'WANAPARTHY', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1464, 'WARANGAL', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1465, 'WARANGAL URBAN', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1466, 'YADADRI', '', 186, 1, 4, '2018-08-25 01:19:14', 0, 0, '0'),
(1467, 'DHALAI', '', 26, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1468, 'GOMATI', '', 26, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1469, 'KHOWAI', '', 26, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1470, 'NORTH TRIPURA', '', 26, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1471, 'SEPAHIJALA', '', 26, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1472, 'SOUTH TRIPURA', '', 26, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1473, 'UNAKOTI', '', 26, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1474, 'WEST TRIPURA', '', 26, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1475, 'ALMORA', '', 8, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1476, 'BAGESHWAR', '', 8, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1477, 'CHAMOLI', '', 8, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1478, 'CHAMPAWAT', '', 8, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1479, 'HARIDWAR', '', 8, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1480, 'NAINITAL', '', 8, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1481, 'PAURI GARHWAL', '', 8, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1482, 'PITHORAGARH', '', 8, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1483, 'RUDRA PRAYAG', '', 8, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1484, 'TEHRI GARHWAL', '', 8, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1485, 'UDAM SINGH NAGAR', '', 8, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1486, 'UTTAR KASHI', '', 8, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1487, 'AGRA', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1488, 'ALIGARH', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1489, 'ALLAHABAD', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1490, 'AMBEDKAR NAGAR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1491, 'AMETHI', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1492, 'AMROHA', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1493, 'AURAIYA', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1494, 'AZAMGARH', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1495, 'BAGHPAT', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1496, 'BAHRAICH', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1497, 'BALLIA', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1498, 'BALRAMPUR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1499, 'BANDA', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1500, 'BARABANKI', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1501, 'BAREILLY', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1502, 'BASTI', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1503, 'BHADOHI', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1504, 'BIJNOR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1505, 'BUDAUN', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1506, 'BULANDSHAHR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1507, 'CHANDAULI', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1508, 'CHITRAKOOT', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1509, 'DEORIA', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1510, 'ETAH', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1511, 'ETAWAH', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1512, 'FAIZABAD', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1513, 'FARRUKHABAD', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1514, 'FATEHPUR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1515, 'FIROZABAD', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1516, 'GAUTAM BUDDHA NAGAR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1517, 'GHAZIABAD', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1518, 'GHAZIPUR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1519, 'GONDA', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1520, 'GORAKHPUR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1521, 'HAMIRPUR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1522, 'HAPUR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1523, 'HARDOI', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1524, 'HATHRAS', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1525, 'JALAUN', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1526, 'JAUNPUR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1527, 'JHANSI', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1528, 'KANNAUJ', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1529, 'KANPUR DEHAT', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1530, 'KANPUR NAGAR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1531, 'KASGANJ', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1532, 'KAUSHAMBI', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1533, 'KHERI', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1534, 'KUSHI NAGAR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1535, 'LALITPUR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1536, 'MAHARAJGANJ', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1537, 'MAHOBA', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1538, 'MAINPURI', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1539, 'MATHURA', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1540, 'MAU', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1541, 'MEERUT', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1542, 'MIRZAPUR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1543, 'MORADABAD', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1544, 'MUZAFFARNAGAR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1545, 'PILIBHIT', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1546, 'PRATAPGARH', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1547, 'RAE BARELI', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1548, 'RAMPUR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1549, 'SAHARANPUR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1550, 'SAMBHAL', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1551, 'SANT KABEER NAGAR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1552, 'SHAHJAHANPUR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1553, 'SHAMLI', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1554, 'SHRAVASTI', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1555, 'SIDDHARTH NAGAR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1556, 'SITAPUR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1557, 'SONBHADRA', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1558, 'SULTANPUR', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1559, 'UNNAO', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1560, 'VARANASI', '', 2, 1, 7, '2018-08-25 01:19:14', 0, 0, '0'),
(1561, '24 PARAGANAS NORTH', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1562, '24 PARAGANAS SOUTH', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1563, 'ALIPURDUAR', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1564, 'BANKURA', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1565, 'BARDHAMAN', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1566, 'BIRBHUM', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1567, 'COOCHBEHAR', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1568, 'DARJEELING', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1569, 'DINAJPUR DAKSHIN', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1570, 'DINAJPUR UTTAR', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1571, 'HOOGHLY', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1572, 'HOWRAH', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1573, 'JALPAIGURI', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1574, 'MALDAH', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1575, 'MEDINIPUR EAST', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1576, 'MEDINIPUR WEST', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1577, 'MURSHIDABAD', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1578, 'NADIA', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1579, 'PURULIA', '', 27, 1, 6, '2018-08-25 01:19:14', 0, 0, '0'),
(1581, 'city_nagpur', '', 200, 1, 0, '2021-06-25 04:00:16', 0, 0, '0'),
(1582, 'city_mumbai', '', 200, 1, 0, '2021-06-25 04:00:16', 0, 0, '0'),
(1583, 'city_Ratnagiri', '', 200, 1, 0, '2021-06-25 04:00:16', 0, 0, '0');

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

--
-- Table structure for table `pg_company_master`
--

CREATE TABLE `pg_company_master` (
  `id` int(11) NOT NULL,
  `company_name` varchar(222) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `company_logo` varchar(222) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `company_address` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `company_country` int(11) NOT NULL,
  `company_city` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `company_state` int(11) NOT NULL,
  `company_pincode` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_contact` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `company_email` varchar(100) CHARACTER SET utf16 COLLATE utf16_unicode_ci NOT NULL,
  `company_organizer` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `company_currency` int(11) NOT NULL,
  `fav_icon` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `letter_head` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `footer_banner` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `added_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted` int(11) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `batch_size` int(11) NOT NULL,
  `android_link` varchar(500) NOT NULL,
  `ios_link` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pg_company_master`
--

INSERT INTO `pg_company_master` (`id`, `company_name`, `company_logo`, `company_address`, `company_country`, `company_city`, `company_state`, `company_pincode`, `company_contact`, `company_email`, `company_organizer`, `company_currency`, `fav_icon`, `letter_head`, `footer_banner`, `added_date`, `deleted`, `ip`, `batch_size`, `android_link`, `ios_link`) VALUES
(1, 'ULIS Fintech', 'a88f620f2a8af1cfe4455dc4da3f26fb.png', 'Wardhman Nagar                                                                              ', 1, '0', 1, '440013', '9657373737', 'c慲敀畬楳瑥捨湯汯杹⹣潭', '', 124, '3e03f235827cc6394b3edeeefc2b7fc4.png', '02b51f3322bdecae5b319087178e7717.png', '42eb6a267e43158756c69ecd6037d6bb.png', '2016-10-08 00:00:00', 0, '', 0, 'https://www.play.com/in/app-store/', 'https://www.apple.com/in/app-store/');

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

--
-- Table structure for table `pg_country`
--

CREATE TABLE `pg_country` (
  `id` int(11) NOT NULL,
  `country_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `country_code` varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `dial` varchar(3) COLLATE latin1_general_ci NOT NULL,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL,
  `deleted` int(11) NOT NULL,
  `is_high_risk` int(10) NOT NULL,
  `ip` varchar(20) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='added by jyoti on 14 June 10 for listing countries';

--
-- Dumping data for table `pg_country`
--

INSERT INTO `pg_country` (`id`, `country_name`, `country_code`, `dial`, `updated_at`, `status`, `deleted`, `is_high_risk`, `ip`) VALUES
(1, 'India', '', '', '2022-09-13 06:57:12', 0, 0, 0, ''),
(2, 'Bangladesh', '', '', '2021-10-27 22:05:57', 0, 0, 0, ''),
(3, 'Nepal', '', '', '2018-08-08 22:54:13', 0, 0, 0, ''),
(4, 'Bhutan', '', '', '2018-08-08 22:54:24', 0, 0, 0, ''),
(5, 'United States', '', '', '2021-05-08 02:16:47', 0, 0, 0, ''),
(7, 'United Arab Emirate', '', '', '2021-06-25 03:30:31', 0, 0, 0, ''),
(8, 'Japan ', '', '', '2021-06-25 03:39:27', 0, 0, 0, ''),
(9, 'China', '', '', '2022-02-11 23:32:04', 0, 0, 1, ''),
(10, 'Indonesia', '', '', '2022-02-13 22:47:03', 0, 0, 0, ''),
(11, 'Iran ', '', '', '2021-06-25 03:39:27', 0, 0, 0, ''),
(12, 'Pakistan', '', '', '2021-06-25 03:39:27', 0, 0, 0, ''),
(13, 'Israel ', '', '', '2021-06-25 03:39:27', 0, 0, 0, ''),
(14, 'Taiwan', '', '', '2021-06-25 03:39:27', 0, 0, 0, ''),
(15, 'Saudi Arabia', '', '', '2021-06-25 03:39:27', 0, 0, 0, ''),
(16, 'Sri Lanka ', '', '', '2021-06-25 03:39:27', 0, 0, 0, ''),
(17, 'Iraq', '', '', '2021-06-25 03:39:27', 0, 0, 0, ''),
(21, 'USA', '', '', '2021-06-27 23:24:24', 0, 0, 0, ''),
(22, 'netherland', '', '', '2021-07-05 02:12:04', 0, 0, 0, ''),
(23, 'south africa', '', '', '2021-07-05 02:12:04', 0, 0, 0, '');

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

--
-- Table structure for table `pg_master_currency`
--

CREATE TABLE `pg_master_currency` (
  `id` int(11) NOT NULL,
  `currency` varchar(100) DEFAULT NULL,
  `code` varchar(25) DEFAULT NULL,
  `symbol` varchar(25) DEFAULT NULL,
  `thousand_separator` varchar(10) DEFAULT NULL,
  `decimal_separator` varchar(10) DEFAULT NULL,
  `image` varchar(200) NOT NULL,
  `status` int(11) NOT NULL,
  `deleted` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pg_master_currency`
--

INSERT INTO `pg_master_currency` (`id`, `currency`, `code`, `symbol`, `thousand_separator`, `decimal_separator`, `image`, `status`, `deleted`) VALUES
(1, 'Leke', 'ALL', 'Lek', ',', '.', '', 0, 1),
(3, 'Afghanis', 'AFN', '؋', ',', '.', '', 0, 1),
(4, 'Pesos', 'ARS', '$', ',', '.', '', 0, 1),
(5, 'Guilders', 'AWG', 'ƒ', ',', '.', '', 0, 1),
(6, 'Dollars', 'AUD', '$', ',', '.', '', 0, 1),
(7, 'New Manats', 'AZ', 'ман', ',', '.', '', 0, 1),
(8, 'Dollars', 'BSD', '$', ',', '.', '', 0, 1),
(9, 'Dollars', 'BBD', '$', ',', '.', '', 0, 1),
(10, 'Rubles', 'BYR', 'p.', ',', '.', '', 0, 1),
(11, 'Euro', 'EUR', '€', ',', '.', '', 0, 1),
(12, 'Dollars', 'BZD', 'BZ$', ',', '.', '', 0, 1),
(13, 'Dollars', 'BMD', '$', ',', '.', '', 0, 1),
(14, 'Bolivianos', 'BOB', '$b', ',', '.', '', 0, 1),
(15, 'Convertible Marka', 'BAM', 'KM', ',', '.', '', 0, 1),
(16, 'Pula\'s', 'BWP', 'P', ',', '.', '', 0, 1),
(17, 'Leva', 'BG', 'лв', ',', '.', '', 0, 1),
(18, 'Reais', 'BRL', 'R$', ',', '.', '', 0, 1),
(19, 'Pounds', 'GBP', '£', ',', '.', '', 0, 1),
(20, 'Dollars', 'BND', '$', ',', '.', '', 0, 1),
(21, 'Riels', 'KHR', '៛', ',', '.', '', 0, 1),
(22, 'Dollars', 'CAD', '$', ',', '.', '', 0, 1),
(23, 'Dollars', 'KYD', '$', ',', '.', '', 0, 1),
(24, 'Pesos', 'CLP', '$', ',', '.', '', 0, 1),
(25, 'Yuan Renminbi', 'CNY', '¥', ',', '.', '', 0, 1),
(26, 'Pesos', 'COP', '$', ',', '.', '', 0, 1),
(27, 'Colón', 'CRC', '₡', ',', '.', '', 0, 1),
(28, 'Kuna', 'HRK', 'kn', ',', '.', '', 0, 1),
(29, 'Pesos', 'CUP', '₱', ',', '.', '', 0, 1),
(30, 'Euro', 'EUR', '€', ',', '.', '', 0, 1),
(31, 'Koruny', 'CZK', 'Kč', ',', '.', '', 0, 1),
(32, 'Kroner', 'DKK', 'kr', ',', '.', '', 0, 1),
(33, 'Pesos', 'DOP ', 'RD$', ',', '.', '', 0, 1),
(34, 'Dollars', 'XCD', '$', ',', '.', '', 0, 1),
(35, 'Pounds', 'EGP', '£', ',', '.', '', 0, 1),
(36, 'Colones', 'SVC', '$', ',', '.', '', 0, 1),
(37, 'Pounds', 'GBP', '£', ',', '.', '', 0, 1),
(38, 'Euro', 'EUR', '€', ',', '.', '', 0, 1),
(39, 'Pounds', 'FKP', '£', ',', '.', '', 0, 1),
(40, 'Dollars', 'FJD', '$', ',', '.', '', 0, 1),
(41, 'Euro', 'EUR', '€', ',', '.', '', 0, 1),
(42, 'Cedis', 'GHC', '¢', ',', '.', '', 0, 1),
(43, 'Pounds', 'GIP', '£', ',', '.', '', 0, 1),
(44, 'Euro', 'EUR', '€', ',', '.', '', 0, 1),
(45, 'Quetzales', 'GTQ', 'Q', ',', '.', '', 0, 1),
(46, 'Pounds', 'GGP', '£', ',', '.', '', 0, 1),
(47, 'Dollars', 'GYD', '$', ',', '.', '', 0, 1),
(48, 'Euro', 'EUR', '€', ',', '.', '', 0, 1),
(49, 'Lempiras', 'HNL', 'L', ',', '.', '', 0, 1),
(50, 'Dollars', 'HKD', '$', ',', '.', '', 0, 1),
(51, 'Forint', 'HUF', 'Ft', ',', '.', '', 0, 1),
(52, 'Kronur', 'ISK', 'kr', ',', '.', '', 0, 1),
(53, 'Rupees', 'INR', 'रू', ',', '.', '', 0, 1),
(54, 'Rupiahs', 'IDR', 'Rp', ',', '.', '', 0, 1),
(55, 'Rials', 'IRR', '﷼', ',', '.', '', 0, 1),
(56, 'Euro', 'EUR', '€', ',', '.', '', 0, 1),
(57, 'Pounds', 'IMP', '£', ',', '.', '', 0, 1),
(58, 'New Shekels', 'ILS', '₪', ',', '.', '', 0, 1),
(59, 'Euro', 'EUR', '€', ',', '.', '', 0, 1),
(60, 'Dollars', 'JMD', 'J$', ',', '.', '', 0, 1),
(61, 'Yen', 'JPY', '¥', ',', '.', '', 0, 1),
(62, 'Pounds', 'JEP', '£', ',', '.', '', 0, 1),
(63, 'Tenge', 'KZT', 'лв', ',', '.', '', 0, 1),
(64, 'Won', 'KPW', '₩', ',', '.', '', 0, 1),
(65, 'Won', 'KRW', '₩', ',', '.', '', 0, 1),
(66, 'Soms', 'KGS', 'лв', ',', '.', '', 0, 1),
(67, 'Kips', 'LAK', '₭', ',', '.', '', 0, 1),
(68, 'Lati', 'LVL', 'Ls', ',', '.', '', 0, 1),
(69, 'Pounds', 'LBP', '£', ',', '.', '', 0, 1),
(70, 'Dollars', 'LRD', '$', ',', '.', '', 0, 1),
(71, 'Switzerland Francs', 'CHF', 'CHF', ',', '.', '', 0, 1),
(72, 'Litai', 'LTL', 'Lt', ',', '.', '', 0, 1),
(73, 'Euro', 'EUR', '€', ',', '.', '', 0, 1),
(74, 'Denars', 'MKD', 'ден', ',', '.', '', 0, 1),
(75, 'Ringgits', 'MYR', 'RM', ',', '.', '', 0, 1),
(76, 'Euro', 'EUR', '€', ',', '.', '', 0, 1),
(77, 'Rupees', 'MUR', '₨', ',', '.', '', 0, 1),
(78, 'Pesos', 'MX', '$', ',', '.', '', 0, 1),
(79, 'Tugriks', 'MNT', '₮', ',', '.', '', 0, 1),
(80, 'Meticais', 'MZ', 'MT', ',', '.', '', 0, 1),
(81, 'Dollars', 'NAD', '$', ',', '.', '', 0, 1),
(82, 'Rupees', 'NPR', '₨', ',', '.', '', 0, 1),
(83, 'Guilders', 'ANG', 'ƒ', ',', '.', '', 0, 1),
(84, 'Euro', 'EUR', '€', ',', '.', '', 0, 1),
(85, 'Dollars', 'NZD', '$', ',', '.', '', 0, 1),
(86, 'Cordobas', 'NIO', 'C$', ',', '.', '', 0, 1),
(87, 'Nairas', 'NG', '₦', ',', '.', '', 0, 1),
(88, 'Won', 'KPW', '₩', ',', '.', '', 0, 1),
(89, 'Krone', 'NOK', 'kr', ',', '.', '', 0, 1),
(90, 'Rials', 'OMR', '﷼', ',', '.', '', 0, 1),
(91, 'Rupees', 'PKR', '₨', ',', '.', '', 0, 1),
(92, 'Balboa', 'PAB', 'B/.', ',', '.', '', 0, 1),
(93, 'Guarani', 'PYG', 'Gs', ',', '.', '', 0, 1),
(94, 'Nuevos Soles', 'PE', 'S/.', ',', '.', '', 0, 1),
(95, 'Pesos', 'PHP', 'Php', ',', '.', '', 0, 1),
(96, 'Zlotych', 'PL', 'zł', ',', '.', '', 0, 1),
(97, 'Rials', 'QAR', '﷼', ',', '.', '', 0, 1),
(98, 'New Lei', 'RO', 'lei', ',', '.', '', 0, 1),
(99, 'Rubles', 'RUB', 'руб', ',', '.', '', 0, 1),
(100, 'Pounds', 'SHP', '£', ',', '.', '', 0, 1),
(101, 'Riyals', 'SAR', '﷼', ',', '.', '', 0, 1),
(102, 'Dinars', 'RSD', 'Дин.', ',', '.', '', 0, 1),
(103, 'Rupees', 'SCR', '₨', ',', '.', '', 0, 1),
(104, 'Dollars', 'SGD', '$', ',', '.', '', 0, 1),
(105, 'Euro', 'EUR', '€', ',', '.', '', 0, 1),
(106, 'Dollars', 'SBD', '$', ',', '.', '', 0, 1),
(107, 'Shillings', 'SOS', 'S', ',', '.', '', 0, 1),
(108, 'Rand', 'ZAR', 'R', ',', '.', '', 0, 1),
(109, 'Won', 'KRW', '₩', ',', '.', '', 0, 1),
(110, 'Euro', 'EUR', '€', ',', '.', '', 0, 1),
(111, 'Rupees', 'LKR', '₨', ',', '.', '', 0, 1),
(112, 'Kronor', 'SEK', 'kr', ',', '.', '', 0, 1),
(113, 'Francs', 'CHF', 'CHF', ',', '.', '', 0, 1),
(114, 'Dollars', 'SRD', '$', ',', '.', '', 0, 1),
(115, 'Pounds', 'SYP', '£', ',', '.', '', 0, 1),
(116, 'New Dollars', 'TWD', 'NT$', ',', '.', '', 0, 1),
(117, 'Baht', 'THB', '฿', ',', '.', '', 0, 1),
(118, 'Dollars', 'TTD', 'TT$', ',', '.', '', 0, 1),
(119, 'Lira', 'TRY', 'TL', ',', '.', '', 0, 1),
(120, 'Liras', 'TRL', '£', ',', '.', '', 0, 1),
(121, 'Dollars', 'TVD', '$', ',', '.', '', 0, 1),
(122, 'Hryvnia', 'UAH', '₴', ',', '.', '', 0, 1),
(123, 'Pounds', 'GBP', '£', ',', '.', '', 0, 1),
(124, 'Dollars', 'USD', '$', ',', '.', 'uae.png', 0, 0),
(125, 'Pesos', 'UYU', '$U', ',', '.', '', 0, 1),
(126, 'Sums', 'UZS', 'лв', ',', '.', '', 0, 1),
(127, 'Euro', 'EUR', '€', ',', '.', '', 0, 1),
(128, 'Bolivares Fuertes', 'VEF', 'Bs', ',', '.', '', 0, 1),
(129, 'Dong', 'VND', '₫', ',', '.', '', 0, 1),
(130, 'Rials', 'YER', '﷼', ',', '.', '', 0, 1),
(131, 'Zimbabwe Dollars', 'ZWD', 'Z$', ',', '.', '', 0, 1);

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

--
-- Table structure for table `pg_master_department`
--

CREATE TABLE `pg_master_department` (
  `id` int(11) NOT NULL,
  `department` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `deleted` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `added_date` date NOT NULL,
  `added_time` time NOT NULL,
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pg_master_department`
--

INSERT INTO `pg_master_department` (`id`, `department`, `deleted`, `user_id`, `status`, `added_date`, `added_time`, `ip`) VALUES
(1, 'Administration', 0, 1, 0, '2018-12-18', '11:44:56', '::1'),
(2, 'Settlment', 0, 1, 0, '2018-12-18', '11:45:11', '::1'),
(3, 'Account', 1, 1, 0, '2018-12-18', '11:45:17', '::1'),
(4, 'Finance', 0, 1, 1, '2019-04-01', '10:46:57', '45.116.150.190'),
(5, 'Head', 0, 1, 1, '2021-05-22', '10:52:34', '152.57.77.104'),
(6, 'staff', 0, 1, 1, '2021-06-25', '15:13:08', '103.73.214.217'),
(7, 'technical', 0, 1, 0, '2021-07-07', '14:50:27', '152.57.114.224'),
(8, 'Administration', 1, 1, 1, '2021-07-13', '15:43:41', '103.73.214.164'),
(9, 'administrations', 1, 1, 0, '2021-10-25', '12:17:45', '103.56.199.101'),
(10, 'Testing', 0, 41, 1, '2022-05-11', '12:48:18', '183.177.126.44'),
(11, 'Insurance', 0, 41, 0, '2022-05-23', '12:58:24', '183.177.126.44'),
(12, 'department12', 0, 0, 1, '2022-09-15', '00:00:00', '49.36.34.206'),
(13, 'sss', 0, 0, 1, '2022-09-15', '00:00:00', '49.36.34.206'),
(14, 'mmm', 0, 0, 0, '2022-09-15', '00:00:00', '49.36.34.206'),
(15, 'ss', 0, 0, 0, '2022-09-15', '00:00:00', '49.36.34.206'),
(16, 'department1232', 0, 0, 0, '2022-09-15', '00:00:00', '49.36.34.206'),
(17, 'department2', 0, 0, 0, '2022-09-15', '00:00:00', '49.36.34.206'),
(18, 'department3', 0, 0, 1, '2022-09-15', '00:00:00', '49.36.34.206'),
(19, 'department4', 0, 0, 1, '2022-09-15', '00:00:00', '49.36.34.206'),
(20, 'department5', 0, 0, 1, '2022-09-15', '00:00:00', '49.36.34.206'),
(21, 'department64', 0, 0, 1, '2022-09-15', '00:00:00', '49.36.34.206'),
(22, 'department7', 0, 0, 1, '2022-09-15', '00:00:00', '49.36.34.206'),
(23, 'department9', 0, 0, 1, '2022-09-15', '00:00:00', '49.36.34.206'),
(24, 'department10', 0, 0, 0, '2022-09-15', '00:00:00', '49.36.34.206'),
(25, 'ss', 0, 0, 0, '2022-09-16', '00:00:00', '49.36.34.206'),
(26, 'msks', 0, 0, 0, '2022-09-16', '00:00:00', '49.36.34.206'),
(27, 'sssxss', 0, 0, 0, '2022-09-16', '00:00:00', '49.36.34.206'),
(29, 'Dpart', 0, 0, 0, '2022-09-19', '00:00:00', '216.194.165.222'),
(30, 'विभाग', 0, 0, 1, '2022-09-19', '00:00:00', '216.194.165.222'),
(31, 'bgggg', 0, 0, 0, '2022-09-19', '00:00:00', '216.194.165.222');

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

--
-- Table structure for table `pg_master_designation`
--

CREATE TABLE `pg_master_designation` (
  `id` int(11) NOT NULL,
  `designation` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `role` longtext NOT NULL,
  `status` int(11) NOT NULL,
  `deleted` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `added_date` date NOT NULL,
  `added_time` time NOT NULL,
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pg_master_designation`
--

INSERT INTO `pg_master_designation` (`id`, `designation`, `role`, `status`, `deleted`, `user_id`, `added_date`, `added_time`, `ip`) VALUES
(1, 'Admin', 'master,merchant,business_fillling_status,business_type,company_proof,service_category,Add_Merchant,customer,Add_POI,Add_POA,Add_Customer,user,Department,Designation,Add_User,bank,setting,Organization_Setup,Language,Locations,Bank_holidays,Exchange_Rate,Transactions_Limit,settlements,pending_settlements,closed_settlements,report,rt_commission,rt_transactions,All_Transactions,Transactions_Debit_Card,Transactions_Net_Banking,rt_settlements,transactions,refund,balance,ticket,', 0, 0, 1, '2018-12-18', '11:51:10', '::1'),
(2, 'Accountant', '', 0, 0, 1, '2018-12-18', '11:51:20', '::1'),
(3, 'Manager', '', 0, 0, 1, '2019-04-01', '10:47:58', '45.116.150.190'),
(4, 'Head', 'master,merchant,business_fillling_status,business_type,company_proof,service_category,service_subcategory,Add_Merchant,Blocked_merchant,customer,Add_POI,Add_POA,Add_Customer,user,Department,Designation,Add_User,Blocked_User,bank,setting,Organization_Setup,Language,Locations,Bank_holidays,Exchange_Rate,Transactions_Limit,charge_setup,card_type,card_brand,card_variant,wallet,buy_now_pay_later,AcquirerRates,RealtimeRates,settlements,pending_settlements,closed_settlements,report,rt_commission,rt_transactions,All_Transactions,Transactions_Debit_Card,Transactions_Net_Banking,rt_settlements,profit_loss,tax_collection,charge_collection,logs,Blocked_Merchant_Report,transactions,refund,balance,ticket,downloads,mcc_code,bank_error_code,gateway_response_code,', 0, 0, 1, '2021-06-25', '15:31:28', '103.73.214.217'),
(5, 'Assistant', 'master,merchant,business_fillling_status,business_type,company_proof,service_category,service_subcategory,Add_Merchant,Blocked_merchant,customer,Add_POI,Add_POA,Add_Customer,user,Department,Designation,Add_User,Blocked_User,bank,setting,Organization_Setup,Language,Locations,Bank_holidays,Exchange_Rate,Transactions_Limit,charge_setup,card_brand,card_variant,wallet,buy_now_pay_later,AcquirerRates,RealtimeRates,settlements,pending_settlements,closed_settlements,report,rt_commission,rt_transactions,All_Transactions,Transactions_Debit_Card,Transactions_Net_Banking,rt_settlements,profit_loss,tax_collection,charge_collection,logs,Blocked_Merchant_Report,transactions,refund,balance,ticket,downloads,mcc_code,bank_error_code,gateway_response_code,', 0, 0, 1, '2021-07-05', '11:26:05', '157.33.124.65'),
(6, 'HR', 'master,merchant,business_fillling_status,business_type,company_proof,service_category,service_subcategory,Add_Merchant,Blocked_merchant,customer,Add_POI,Add_POA,Add_Customer,user,Department,Designation,Add_User,Blocked_User,bank,setting,Organization_Setup,Language,Locations,Bank_holidays,Exchange_Rate,Transactions_Limit,charge_setup,card_brand,card_variant,wallet,buy_now_pay_later,AcquirerRates,RealtimeRates,settlements,pending_settlements,closed_settlements,report,rt_commission,rt_transactions,All_Transactions,Transactions_Debit_Card,Transactions_Net_Banking,rt_settlements,profit_loss,tax_collection,charge_collection,logs,Blocked_Merchant_Report,transactions,refund,balance,ticket,downloads,mcc_code,bank_error_code,gateway_response_code,', 0, 0, 1, '2021-07-07', '07:31:55', '106.195.12.3'),
(7, 'Admin', 'master,merchant,business_fillling_status,business_type,company_proof,service_category,service_subcategory,Add_Merchant,Blocked_merchant,customer,Add_POI,Add_POA,Add_Customer,user,Department,Designation,Add_User,Blocked_User,bank,setting,Organization_Setup,Language,Locations,Bank_holidays,Exchange_Rate,Transactions_Limit,charge_setup,card_brand,card_variant,wallet,buy_now_pay_later,AcquirerRates,RealtimeRates,settlements,pending_settlements,closed_settlements,report,rt_commission,rt_transactions,All_Transactions,Transactions_Debit_Card,Transactions_Net_Banking,rt_settlements,profit_loss,tax_collection,charge_collection,logs,Blocked_Merchant_Report,transactions,refund,balance,ticket,downloads,mcc_code,bank_error_code,gateway_response_code,', 0, 0, 1, '2021-07-13', '17:20:20', '103.73.214.164'),
(8, 'Tester', 'master,merchant,business_fillling_status,business_type,company_proof,service_category,service_subcategory,Add_Merchant,Blocked_merchant,customer,Add_POI,Add_POA,Add_Customer,user,Department,Designation,Add_User,Blocked_User,bank,setting,Organization_Setup,Language,Locations,Bank_holidays,Exchange_Rate,Transactions_Limit,charge_setup,card_brand,card_variant,wallet,buy_now_pay_later,AcquirerRates,RealtimeRates,settlements,pending_settlements,closed_settlements,report,rt_commission,rt_transactions,All_Transactions,Transactions_Debit_Card,Transactions_Net_Banking,rt_settlements,profit_loss,tax_collection,charge_collection,logs,Blocked_Merchant_Report,fraud_prevention_engine,transactions,refund,balance,ticket,downloads,mcc_code,bank_error_code,gateway_response_code,', 1, 0, 41, '2022-05-11', '12:51:00', '183.177.126.44'),
(9, 'designation12', 'master,merchant', 0, 0, 0, '2022-09-14', '00:00:00', '183.177.126.44');

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

--
-- Table structure for table `pg_master_language`
--

CREATE TABLE `pg_master_language` (
  `id` int(11) NOT NULL,
  `name` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `file` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `flag` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `direction` enum('ltr','rtl') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `added_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ip` varchar(250) NOT NULL,
  `added_by` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `deleted` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pg_master_language`
--

INSERT INTO `pg_master_language` (`id`, `name`, `file`, `flag`, `direction`, `added_date`, `ip`, `added_by`, `status`, `deleted`) VALUES
(1, 'English', 'label_eng.json', 'english.png', 'ltr', '2017-02-02 00:00:00', '49.202.52.254', 59, 0, 0),
(12, 'हिन्दी', 'file-1663301889466-271233622.json', 'flag-1663301889790-133249957.png', 'rtl', '2022-09-16 04:18:09', '183.177.126.44', 1, 0, 0);

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

--
-- Table structure for table `pg_master_partners`
--

CREATE TABLE `pg_master_partners` (
  `id` int(11) NOT NULL,
  `partner_id` varchar(100) NOT NULL,
  `name` varchar(222) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `company_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `country` int(11) NOT NULL,
  `state` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `pincode` int(6) NOT NULL,
  `code` varchar(3) NOT NULL,
  `mobile` varchar(12) NOT NULL,
  `email` varchar(100) NOT NULL,
  `type_of_business` int(10) NOT NULL,
  `status` int(11) NOT NULL,
  `added_by` int(11) NOT NULL,
  `added_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ip` varchar(20) NOT NULL,
  `is_blocked` int(10) NOT NULL,
  `deleted` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pg_master_partners`
--

INSERT INTO `pg_master_partners` (`id`, `partner_id`, `name`, `company_name`, `address`, `country`, `state`, `city`, `pincode`, `code`, `mobile`, `email`, `type_of_business`, `status`, `added_by`, `added_date`, `ip`, `is_blocked`, `deleted`) VALUES
(2, 'PAR_yRbV2022UR4Q86y4X202EFm', 'rahul', 'Company name', 'Wardhaman nagar Nagpur', 1, 'Maharashtra', 'Nagpur', 234567, '3', '1345155322', 'rahul124532611@ulistech.com', 1, 0, 1, '2022-09-20 10:15:39', '127.0.0.1', 0, 1),
(3, 'PAR_I9vF2022XFev8sWa820hdhB', 'rahul', 'Company name', 'Wardhaman nagar Nagpur', 1, 'Maharashtra', 'Nagpur', 234567, '3', '134515322', 'rahul12432611@ulistech.com', 1, 0, 1, '2022-09-20 11:15:42', '127.0.0.1', 0, 0);

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

--
-- Table structure for table `pg_master_type_of_business`
--

CREATE TABLE `pg_master_type_of_business` (
  `id` int(11) NOT NULL,
  `type_of_business` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status` int(11) NOT NULL,
  `deleted` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `added_date` date NOT NULL,
  `added_time` time NOT NULL,
  `ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pg_master_type_of_business`
--

INSERT INTO `pg_master_type_of_business` (`id`, `type_of_business`, `status`, `deleted`, `user_id`, `added_date`, `added_time`, `ip`) VALUES
(1, 'Administration', 0, 0, 1, '2018-12-18', '11:44:56', '::1'),
(2, 'Settlment', 0, 0, 1, '2018-12-18', '11:45:11', '::1'),
(3, 'Account', 0, 0, 1, '2018-12-18', '11:45:17', '::1'),
(4, 'Finance', 0, 0, 1, '2019-04-01', '10:46:57', '45.116.150.190'),
(5, 'Head', 0, 0, 1, '2021-05-22', '10:52:34', '152.57.77.104'),
(6, 'staff', 0, 0, 1, '2021-06-25', '15:13:08', '103.73.214.217'),
(7, 'technical', 0, 0, 1, '2021-07-07', '14:50:27', '152.57.114.224'),
(10, 'Testing1', 0, 1, 41, '2022-05-11', '12:48:18', '183.177.126.44'),
(11, 'Insurance', 0, 0, 41, '2022-05-23', '12:58:24', '183.177.126.44'),
(12, 'department12', 0, 0, 0, '2022-09-14', '00:00:00', '127.0.0.1'),
(13, 'aaaa', 0, 1, 0, '2022-09-15', '00:00:00', '127.0.0.1'),
(14, 'department123', 0, 0, 0, '2022-09-15', '00:00:00', '127.0.0.1'),
(15, 'विभाग', 0, 0, 0, '2022-09-19', '00:00:00', '127.0.0.1'),
(16, 'Testing1', 0, 1, 0, '2022-09-20', '00:00:00', '127.0.0.1');

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

--
-- Table structure for table `pg_states`
--

CREATE TABLE `pg_states` (
  `id` int(11) NOT NULL,
  `state_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `state_code` varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ref_country` int(11) NOT NULL,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL,
  `deleted` int(11) NOT NULL,
  `ip` varchar(20) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `pg_states`
--

INSERT INTO `pg_states` (`id`, `state_name`, `state_code`, `ref_country`, `updated_at`, `status`, `deleted`, `ip`) VALUES
(1, 'MAHARASHTRA', 'MAH', 1, '2021-06-28 12:24:14', 0, 0, ''),
(2, 'UTTAR PRADESH', 'UP', 1, '2018-08-25 13:44:08', 0, 0, ''),
(3, 'MADHYA PRADESH', 'MP', 1, '2018-08-25 13:41:56', 0, 0, ''),
(4, 'ANDHRA PRADESH', 'AP', 1, '2018-08-25 13:38:19', 0, 0, ''),
(5, 'HARYANA', 'HAR', 1, '2018-08-25 13:40:40', 0, 0, ''),
(6, 'GUJARAT', 'GUJ', 1, '2018-08-25 13:40:27', 0, 0, ''),
(7, 'JHARKHAND', 'JH', 1, '2018-08-25 13:41:11', 0, 0, ''),
(8, 'UTTARAKHAND', 'UTT', 1, '2018-08-25 13:44:18', 0, 0, ''),
(9, 'PUNJAB', 'PUN', 1, '2018-08-25 13:43:24', 0, 0, ''),
(10, 'KERALA', 'KER', 1, '2018-08-25 13:41:35', 0, 0, ''),
(11, 'TAMIL NADU', 'TAM', 1, '2018-08-25 13:43:41', 0, 0, ''),
(12, 'ARUNACHAL PRADESH', 'ARP', 1, '2018-08-25 13:38:36', 0, 0, ''),
(13, 'ASSAM', 'ASM', 1, '2018-08-25 13:38:49', 0, 0, ''),
(14, 'BIHAR', 'BIH', 1, '2018-08-25 13:38:52', 0, 0, ''),
(15, 'CHHATTISGARH', 'CHH', 1, '2018-08-25 13:39:23', 0, 0, ''),
(16, 'GOA', 'GOA', 1, '2018-08-25 13:40:16', 0, 0, ''),
(17, 'JAMMU AND KASHMIR', 'J&K', 1, '2018-08-25 13:41:00', 0, 0, ''),
(18, 'KARNATAKA', 'KAR', 1, '2018-08-25 13:41:28', 0, 0, ''),
(19, 'MANIPUR', 'MAN', 1, '2018-08-25 13:42:31', 0, 0, ''),
(20, 'MEGHALAYA', 'MEG', 1, '2018-08-25 13:42:40', 0, 0, ''),
(21, 'MIZORAM', 'MIZ', 1, '2018-08-25 13:42:43', 0, 0, ''),
(22, 'NAGALAND', 'NAG', 1, '2018-08-25 13:42:51', 0, 0, ''),
(23, 'ODISHA', 'ORI', 1, '2018-08-25 13:43:05', 0, 0, ''),
(24, 'RAJASTHAN', 'RAJ', 1, '2018-08-22 10:18:07', 0, 0, ''),
(25, 'SIKKIM', 'SIK', 1, '2018-08-25 13:43:37', 0, 0, ''),
(26, 'TRIPURA', 'TRI', 1, '2018-08-25 13:44:00', 0, 0, ''),
(27, 'WEST BENGAL', 'WES', 1, '2018-08-25 13:44:35', 0, 0, ''),
(28, 'HIMACHAL PRADESH', 'HIP', 1, '2018-08-25 13:40:51', 0, 0, ''),
(194, 'LAKSHADWEEP', '', 1, '2018-08-25 13:41:42', 0, 0, ''),
(186, 'TELANGANA', '', 1, '2018-08-25 13:43:52', 0, 0, ''),
(187, 'CHANDIGARH', '', 1, '2018-08-25 13:39:10', 0, 0, ''),
(188, 'DADRA AND NAGAR HAVELI', '', 1, '2018-08-25 13:39:33', 0, 0, ''),
(189, 'DAMAN AND DIU', '', 1, '2018-08-25 13:39:37', 0, 0, ''),
(190, 'PONDICHERRY', '', 1, '2018-08-25 13:43:16', 0, 0, ''),
(192, 'DELHI', '', 1, '2018-08-25 13:39:57', 0, 0, ''),
(193, 'ANDAMAN AND NICOBAR ISLANDS', '', 1, '2018-08-25 13:38:16', 0, 0, ''),
(195, 'New york', '', 5, '2021-05-08 19:25:44', 0, 0, ''),
(198, 'Los Angeles', '', 5, '2021-06-24 18:18:43', 0, 0, ''),
(204, 'nagpur', '', 1, '2021-06-25 16:18:32', 0, 0, '');

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

--
-- Table structure for table `pg_title`
--

CREATE TABLE `pg_title` (
  `id` int(11) NOT NULL,
  `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pg_title`
--

INSERT INTO `pg_title` (`id`, `title`) VALUES
(1, 'Payments Gateway');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

