SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
CREATE TABLE IF NOT EXISTS `cities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
`state_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=47577 ;
INSERT INTO `cities` (`id`, `name`, `state_id`) VALUES
(1, 'Bombuflat', 1),
(2, 'Garacharma', 1),
(3, 'Port Blair', 1),
(4, 'Rangat', 1),
(5, 'Addanki', 2),
(6, 'Adivivaram', 2),
(7, 'Adoni', 2),
(8, 'Aganampudi', 2),
(9, 'Ajjaram', 2),
(10, 'Akividu', 2),
(11, 'Akkarampalle', 2),
(12, 'Akkayapalle', 2),
(13, 'Akkireddipalem', 2),
(14, 'Alampur', 2),
(15, 'Amalapuram', 2),
(16, 'Amudalavalasa', 2),
(17, 'Amur', 2),
(18, 'Anakapalle', 2),
(19, 'Anantapur', 2),
(20, 'Andole', 2),
(21, 'Atmakur', 2),
(22, 'Attili', 2),
(23, 'Avanigadda', 2),
(24, 'Badepalli', 2),
(25, 'Badvel', 2),
(26, 'Balapur', 2),
(27, 'Bandarulanka', 2),
(28, 'Banganapalle', 2),
(29, 'Bapatla', 2),
(30, 'Bapulapadu', 2),
(31, 'Belampalli', 2),
(32, 'Bestavaripeta', 2),
(33, 'Betamcherla', 2),
(34, 'Bhattiprolu', 2),
(35, 'Bhimavaram', 2),
(36, 'Bhimunipatnam', 2),
(37, 'Bobbili', 2),
(38, 'Bombuflat', 2),
(39, 'Bommuru', 2),
(40, 'Bugganipalle', 2),
(41, 'Challapalle', 2),
(42, 'Chandur', 2),
(43, 'Chatakonda', 2),
(44, 'Chemmumiahpet', 2),
(45, 'Chidiga', 2),
(46, 'Chilakaluripet', 2),
(47, 'Chimakurthy', 2),
(48, 'Chinagadila', 2),
(49, 'Chinagantyada', 2),
(50, 'Chinnachawk', 2),
(51, 'Chintalavalasa', 2),
(52, 'Chipurupalle', 2),
(53, 'Chirala', 2),
(54, 'Chittoor', 2),
(55, 'Chodavaram', 2),
(56, 'Choutuppal', 2),
(57, 'Chunchupalle', 2),
(58, 'Cuddapah', 2),
(59, 'Cumbum', 2),
(60, 'Darnakal', 2),
(61, 'Dasnapur', 2),
(62, 'Dauleshwaram', 2),
(63, 'Dharmavaram', 2),
(64, 'Dhone', 2),
(65, 'Dommara Nandyal', 2),
(66, 'Dowlaiswaram', 2),
(67, 'East Godavari Dist.', 2),
(68, 'Eddumailaram', 2),
(69, 'Edulapuram', 2),
(70, 'Ekambara kuppam', 2),
(71, 'Eluru', 2),
(72, 'Enikapadu', 2),
(73, 'Fakirtakya', 2),
(74, 'Farrukhnagar', 2),
(75, 'Gaddiannaram', 2),
(76, 'Gajapathinagaram', 2),
(77, 'Gajularega', 2),
(78, 'Gajuvaka', 2),
(79, 'Gannavaram', 2),
(80, 'Garacharma', 2),
(81, 'Garimellapadu', 2),
(82, 'Giddalur', 2),
(83, 'Godavarikhani', 2),
(84, 'Gopalapatnam', 2),
(85, 'Gopalur', 2),
(86, 'Gorrekunta', 2),
(87, 'Gudivada', 2),
(88, 'Gudur', 2),
(89, 'Guntakal', 2),
(90, 'Guntur', 2),
(91, 'Guti', 2),
(92, 'Hindupur', 2),
(93, 'Hukumpeta', 2),
(94, 'Ichchapuram', 2),
(95, 'Isnapur', 2),
(96, 'Jaggayyapeta', 2),
(97, 'Jallaram Kamanpur', 2),
(98, 'Jammalamadugu', 2),
(99, 'Jangampalli', 2),
(100, 'Jarjapupeta', 2),
(101, 'Kadiri', 2),
(102, 'Kaikalur', 2),
(103, 'Kakinada', 2),
(104, 'Kallur', 2),
(105, 'Kalyandurg', 2),
(106, 'Kamalapuram', 2),
(107, 'Kamareddi', 2),
(108, 'Kanapaka', 2),
(109, 'Kanigiri', 2),
(110, 'Kanithi', 2),
(111, 'Kankipadu', 2),
(112, 'Kantabamsuguda', 2),
(113, 'Kanuru', 2),
(114, 'Karnul', 2),
(115, 'Katheru', 2),
(116, 'Kavali', 2),
(117, 'Kazipet', 2),
(118, 'Khanapuram Haveli', 2),
(119, 'Kodar', 2),
(120, 'Kollapur', 2),
(121, 'Kondapalem', 2),
(122, 'Kondapalle', 2),
(123, 'Kondukur', 2),
(124, 'Kosgi', 2),
(125, 'Kothavalasa', 2),
(126, 'Kottapalli', 2),
(127, 'Kovur', 2),
(128, 'Kovurpalle', 2),
(129, 'Kovvur', 2),
(130, 'Krishna', 2),
(131, 'Kuppam', 2),
(132, 'Kurmannapalem', 2),
(133, 'Kurnool', 2),
(134, 'Lakshettipet', 2),
(135, 'Lalbahadur Nagar', 2),
(136, 'Machavaram', 2),
(137, 'Macherla', 2),
(138, 'Machilipatnam', 2),
(139, 'Madanapalle', 2),
(140, 'Madaram', 2),
(141, 'Madhuravada', 2),
(142, 'Madikonda', 2),
(143, 'Madugule', 2),
(144, 'Mahabubnagar', 2),
(145, 'Mahbubabad', 2),
(146, 'Malkajgiri', 2),
(147, 'Mamilapalle', 2),
(148, 'Mancheral', 2),
(149, 'Mandapeta', 2),
(150, 'Mandasa', 2),
(151, 'Mangalagiri', 2),
(152, 'Manthani', 2),
(153, 'Markapur', 2),
(154, 'Marturu', 2),
(155, 'Metpalli', 2),
(156, 'Mindi', 2),
(157, 'Mirpet', 2),
(158, 'Moragudi', 2),
(159, 'Mothugudam', 2),
(160, 'Nagari', 2),
(161, 'Nagireddipalle', 2),
(162, 'Nandigama', 2),
(163, 'Nandikotkur', 2),
(164, 'Nandyal', 2),
(165, 'Narasannapeta', 2),
(166, 'Narasapur', 2),
(167, 'Narasaraopet', 2),
(168, 'Narayanavanam', 2),
(169, 'Narsapur', 2),
(170, 'Narsingi', 2),
(171, 'Narsipatnam', 2),
(172, 'Naspur', 2),
(173, 'Nathayyapalem', 2),
(174, 'Nayudupeta', 2),
(175, 'Nelimaria', 2),
(176, 'Nellore', 2),
(177, 'Nidadavole', 2),
(178, 'Nuzvid', 2),
(179, 'Omerkhan daira', 2),
(180, 'Ongole', 2),
(181, 'Osmania University', 2),
(182, 'Pakala', 2),
(183, 'Palakole', 2),
(184, 'Palakurthi', 2),
(185, 'Palasa', 2),
(186, 'Palempalle', 2),
(187, 'Palkonda', 2),
(188, 'Palmaner', 2),
(189, 'Pamur', 2),
(190, 'Panjim', 2),
(191, 'Papampeta', 2),
(192, 'Parasamba', 2),
(193, 'Parvatipuram', 2),
(194, 'Patancheru', 2),
(195, 'Payakaraopet', 2),
(196, 'Pedagantyada', 2),
(197, 'Pedana', 2),
(198, 'Peddapuram', 2),
(199, 'Pendurthi', 2),
(200, 'Penugonda', 2),
(201, 'Penukonda', 2),
(202, 'Phirangipuram', 2),
(203, 'Pithapuram', 2),
(204, 'Ponnur', 2),
(205, 'Port Blair', 2),
(206, 'Pothinamallayyapalem', 2),
(207, 'Prakasam', 2),
(208, 'Prasadampadu', 2),
(209, 'Prasantinilayam', 2),
(210, 'Proddatur', 2),
(211, 'Pulivendla', 2),
(212, 'Punganuru', 2),
(213, 'Puttur', 2),
(214, 'Qutubullapur', 2),
(215, 'Rajahmundry', 2),
(216, 'Rajamahendri', 2),
(217, 'Rajampet', 2),
(218, 'Rajendranagar', 2),
(219, 'Rajoli', 2),
(220, 'Ramachandrapuram', 2),
(221, 'Ramanayyapeta', 2),
(222, 'Ramapuram', 2),
(223, 'Ramarajupalli', 2),
(224, 'Ramavarappadu', 2),
(225, 'Rameswaram', 2),
(226, 'Rampachodavaram', 2),
(227, 'Ravulapalam', 2),
(228, 'Rayachoti', 2),
(229, 'Rayadrug', 2),
(230, 'Razam', 2),
(231, 'Razole', 2),
(232, 'Renigunta', 2),
(233, 'Repalle', 2),
(234, 'Rishikonda', 2),
(235, 'Salur', 2),
(236, 'Samalkot', 2),
(237, 'Sattenapalle', 2),
(238, 'Seetharampuram', 2),
(239, 'Serilungampalle', 2),
(240, 'Shankarampet', 2),
(241, 'Shar', 2),
(242, 'Singarayakonda', 2),
(243, 'Sirpur', 2),
(244, 'Sirsilla', 2),
(245, 'Sompeta', 2),
(246, 'Sriharikota', 2),
(247, 'Srikakulam', 2),
(248, 'Srikalahasti', 2),
(249, 'Sriramnagar', 2),
(250, 'Sriramsagar', 2),
(251, 'Srisailam', 2),
(252, 'Srisailamgudem Devasthanam', 2),
(253, 'Sulurpeta', 2),
(254, 'Suriapet', 2),
(255, 'Suryaraopet', 2),
(256, 'Tadepalle', 2),
(257, 'Tadepalligudem', 2),
(258, 'Tadpatri', 2),
(259, 'Tallapalle', 2),
(260, 'Tanuku', 2),
(261, 'Tekkali', 2),
(262, 'Tenali', 2),
(263, 'Tigalapahad', 2),
(264, 'Tiruchanur', 2),
(265, 'Tirumala', 2),
(266, 'Tirupati', 2),
(267, 'Tirvuru', 2),
(268, 'Trimulgherry', 2),
(269, 'Tuni', 2),
(270, 'Turangi', 2),
(271, 'Ukkayapalli', 2),
(272, 'Ukkunagaram', 2),
(273, 'Uppal Kalan', 2),
(274, 'Upper Sileru', 2),
(275, 'Uravakonda', 2),
(276, 'Vadlapudi', 2),
(277, 'Vaparala', 2),
(278, 'Vemalwada', 2),
(279, 'Venkatagiri', 2),
(280, 'Venkatapuram', 2),
(281, 'Vepagunta', 2),
(282, 'Vetapalem', 2),
(283, 'Vijayapuri', 2),
(284, 'Vijayapuri South', 2),
(285, 'Vijayawada', 2),
(286, 'Vinukonda', 2),
(287, 'Visakhapatnam', 2),
(288, 'Vizianagaram', 2),
(289, 'Vuyyuru', 2),
(290, 'Wanparti', 2),
(291, 'West Godavari Dist.', 2),
(292, 'Yadagirigutta', 2),
(293, 'Yarada', 2),
(294, 'Yellamanchili', 2),
(295, 'Yemmiganur', 2),
(296, 'Yenamalakudru', 2),
(297, 'Yendada', 2),
(298, 'Yerraguntla', 2),
(299, 'Along', 3),
(300, 'Basar', 3),
(301, 'Bondila', 3),
(302, 'Changlang', 3),
(303, 'Daporijo', 3),
(304, 'Deomali', 3),
(305, 'Itanagar', 3),
(306, 'Jairampur', 3),
(307, 'Khonsa', 3),
(308, 'Naharlagun', 3),
(309, 'Namsai', 3),
(310, 'Pasighat', 3),
(311, 'Roing', 3),
(312, 'Seppa', 3),
(313, 'Tawang', 3),
(314, 'Tezu', 3),
(315, 'Ziro', 3),
(316, 'Abhayapuri', 4),
(317, 'Ambikapur', 4),
(318, 'Amguri', 4),
(319, 'Anand Nagar', 4),
(320, 'Badarpur', 4),
(321, '
