0wbhM2dA

1DROP TABLE IF EXISTS `district`;
2
3CREATE TABLE `district` (
4  `id` bigint(20) NOT NULL AUTO_INCREMENT,
5  `name` varchar(255) NOT NULL,
6  `state_id` bigint(20) DEFAULT NULL,
7  PRIMARY KEY (`id`),
8  KEY `FK9q0dmy9dgad2d0ewohftj87cn` (`state_id`)
9) ENGINE=MyISAM DEFAULT CHARSET=utf8;
10
11LOCK TABLES `district` WRITE;
12
13INSERT INTO `district` (`id`, `name`, `state_id`)
14VALUES
15	(1,'Nicobar',1),
16	(2,'North Middle Andaman',1),
17	(3,'South Andaman',1),
18	(4,'Anantapur',2),
19	(5,'Chittoor',2),
20	(6,'East Godavari',2),
21	(7,'Guntur',2),
22	(8,'Kadapa',2),
23	(9,'Krishna',2),
24	(10,'Kurnool',2),
25	(11,'Nellore',2),
26	(12,'Prakasam',2),
27	(13,'Srikakulam',2),
28	(14,'Visakhapatnam',2),
29	(15,'Vizianagaram',2),
30	(16,'West Godavari',2),
31	(17,'Anjaw',3),
32	(18,'Central Siang',3),
33	(19,'Changlang',3),
34	(20,'Dibang Valley',3),
35	(21,'East Kameng',3),
36	(22,'East Siang',3),
37	(23,'Kra Daadi',3),
38	(24,'Kurung Kumey',3),
39	(25,'Lohit',3),
40	(26,'Longding',3),
41	(27,'Lower Dibang Valley',3),
42	(28,'Lower Siang',3),
43	(29,'Lower Subansiri',3),
44	(30,'Namsai',3),
45	(31,'Papum Pare',3),
46	(32,'Tawang',3),
47	(33,'Tirap',3),
48	(34,'Upper Siang',3),
49	(35,'Upper Subansiri',3),
50	(36,'West Kameng',3),
51	(37,'West Siang',3),
52	(38,'Baksa',4),
53	(39,'Barpeta',4),
54	(40,'Biswanath',4),
55	(41,'Bongaigaon',4),
56	(42,'Cachar',4),
57	(43,'Charaideo',4),
58	(44,'Chirang',4),
59	(45,'Darrang',4),
60	(46,'Dhemaji',4),
61	(47,'Dhubri',4),
62	(48,'Dibrugarh',4),
63	(49,'Dima Hasao',4),
64	(50,'Goalpara',4),
65	(51,'Golaghat',4),
66	(52,'Hailakandi',4),
67	(53,'Hojai',4),
68	(54,'Jorhat',4),
69	(55,'Kamrup',4),
70	(56,'Kamrup Metropolitan',4),
71	(57,'Karbi Anglong',4),
72	(58,'Karimganj',4),
73	(59,'Kokrajhar',4),
74	(60,'Lakhimpur',4),
75	(61,'Majuli',4),
76	(62,'Morigaon',4),
77	(63,'Nagaon',4),
78	(64,'Nalbari',4),
79	(65,'Sivasagar',4),
80	(66,'Sonitpur',4),
81	(67,'South Salmara-Mankachar',4),
82	(68,'Tinsukia',4),
83	(69,'Udalguri',4),
84	(70,'West Karbi Anglong',4),
85	(71,'Araria',5),
86	(72,'Arwal',5),
87	(73,'Aurangabad',5),
88	(74,'Banka',5),
89	(75,'Begusarai',5),
90	(76,'Bhagalpur',5),
91	(77,'Bhojpur',5),
92	(78,'Buxar',5),
93	(79,'Darbhanga',5),
94	(80,'East Champaran',5),
95	(81,'Gaya',5),
96	(82,'Gopalganj',5),
97	(83,'Jamui',5),
98	(84,'Jehanabad',5),
99	(85,'Kaimur',5),
100	(86,'Katihar',5),
101	(87,'Khagaria',5),
102	(88,'Kishanganj',5),
103	(89,'Lakhisarai',5),
104	(90,'Madhepura',5),
105	(91,'Madhubani',5),
106	(92,'Munger',5),
107	(93,'Muzaffarpur',5),
108	(94,'Nalanda',5),
109	(95,'Nawada',5),
110	(96,'Patna',5),
111	(97,'Purnia',5),
112	(98,'Rohtas',5),
113	(99,'Saharsa',5),
114	(100,'Samastipur',5),
115	(101,'Saran',5),
116	(102,'Sheikhpura',5),
117	(103,'Sheohar',5),
118	(104,'Sitamarhi',5),
119	(105,'Siwan',5),
120	(106,'Supaul',5),
121	(107,'Vaishali',5),
122	(108,'West Champaran',5),
123	(109,'Chandigarh',6),
124	(110,'Balod',7),
125	(111,'Baloda Bazar',7),
126	(112,'Balrampur',7),
127	(113,'Bastar',7),
128	(114,'Bemetara',7),
129	(115,'Bijapur',7),
130	(116,'Bilaspur',7),
131	(117,'Dantewada',7),
132	(118,'Dhamtari',7),
133	(119,'Durg',7),
134	(120,'Gariaband',7),
135	(121,'Janjgir Champa',7),
136	(122,'Jashpur',7),
137	(123,'Kabirdham',7),
138	(124,'Kanker',7),
139	(125,'Kondagaon',7),
140	(126,'Korba',7),
141	(127,'Koriya',7),
142	(128,'Mahasamund',7),
143	(129,'Mungeli',7),
144	(130,'Narayanpur',7),
145	(131,'Raigarh',7),
146	(132,'Raipur',7),
147	(133,'Rajnandgaon',7),
148	(134,'Sukma',7),
149	(135,'Surajpur',7),
150	(136,'Surguja',7),
151	(137,'Dadra Nagar Haveli',8),
152	(138,'Daman',9),
153	(139,'Diu',9),
154	(140,'Central Delhi',10),
155	(141,'East Delhi',10),
156	(142,'New Delhi',10),
157	(143,'North Delhi',10),
158	(144,'North East Delhi',10),
159	(145,'North West Delhi',10),
160	(146,'Shahdara',10),
161	(147,'South Delhi',10),
162	(148,'South East Delhi',10),
163	(149,'South West Delhi',10),
164	(150,'West Delhi',10),
165	(151,'North Goa',11),
166	(152,'South Goa',11),
167	(153,'Ahmedabad',12),
168	(154,'Amreli',12),
169	(155,'Anand',12),
170	(156,'Aravalli',12),
171	(157,'Banaskantha',12),
172	(158,'Bharuch',12),
173	(159,'Bhavnagar',12),
174	(160,'Botad',12),
175	(161,'Chhota Udaipur',12),
176	(162,'Dahod',12),
177	(163,'Dang',12),
178	(164,'Devbhoomi Dwarka',12),
179	(165,'Gandhinagar',12),
180	(166,'Gir Somnath',12),
181	(167,'Jamnagar',12),
182	(168,'Junagadh',12),
183	(169,'Kheda',12),
184	(170,'Kutch',12),
185	(171,'Mahisagar',12),
186	(172,'Mehsana',12),
187	(173,'Morbi',12),
188	(174,'Narmada',12),
189	(175,'Navsari',12),
190	(176,'Panchmahal',12),
191	(177,'Patan',12),
192	(178,'Porbandar',12),
193	(179,'Rajkot',12),
194	(180,'Sabarkantha',12),
195	(181,'Surat',12),
196	(182,'Surendranagar',12),
197	(183,'Tapi',12),
198	(184,'Vadodara',12),
199	(185,'Valsad',12),
200	(186,'Ambala',13),
201	(187,'Bhiwani',13),
202	(188,'Charkhi Dadri',13),
203	(189,'Faridabad',13),
204	(190,'Fatehabad',13),
205	(191,'Gurugram',13),
206	(192,'Hisar',13),
207	(193,'Jhajjar',13),
208	(194,'Jind',13),
209	(195,'Kaithal',13),
210	(196,'Karnal',13),
211	(197,'Kurukshetra',13),
212	(198,'Mahendragarh',13),
213	(199,'Mewat',13),
214	(200,'Palwal',13),
215	(201,'Panchkula',13),
216	(202,'Panipat',13),
217	(203,'Rewari',13),
218	(204,'Rohtak',13),
219	(205,'Sirsa',13),
220	(206,'Sonipat',13),
221	(207,'Yamunanagar',13),
222	(208,'Bilaspur',14),
223	(209,'Chamba',14),
224	(210,'Hamirpur',14),
225	(211,'Kangra',14),
226	(212,'Kinnaur',14),
227	(213,'Kullu',14),
228	(214,'Lahaul Spiti',14),
229	(215,'Mandi',14),
230	(216,'Shimla',14),
231	(217,'Sirmaur',14),
232	(218,'Solan',14),
233	(219,'Una',14),
234	(220,'Anantnag',15),
235	(221,'Bandipora',15),
236	(222,'Baramulla',15),
237	(223,'Budgam',15),
238	(224,'Doda',15),
239	(225,'Ganderbal',15),
240	(226,'Jammu',15),
241	(227,'Kargil',15),
242	(228,'Kathua',15),
243	(229,'Kishtwar',15),
244	(230,'Kulgam',15),
245	(231,'Kupwara',15),
246	(232,'Leh',15),
247	(233,'Poonch',15),
248	(234,'Pulwama',15),
249	(235,'Rajouri',15),
250	(236,'Ramban',15),
251	(237,'Reasi',15),
252	(238,'Samba',15),
253	(239,'Shopian',15),
254	(240,'Srinagar',15),
255	(241,'Udhampur',15),
256	(242,'Bokaro',16),
257	(243,'Chatra',16),
258	(244,'Deoghar',16),
259	(245,'Dhanbad',16),
260	(246,'Dumka',16),
261	(247,'East Singhbhum',16),
262	(248,'Garhwa',16),
263	(249,'Giridih',16),
264	(250,'Godda',16),
265	(251,'Gumla',16),
266	(252,'Hazaribagh',16),
267	(253,'Jamtara',16),
268	(254,'Khunti',16),
269	(255,'Koderma',16),
270	(256,'Latehar',16),
271	(257,'Lohardaga',16),
272	(258,'Pakur',16),
273	(259,'Palamu',16),
274	(260,'Ramgarh',16),
275	(261,'Ranchi',16),
276	(262,'Sahebganj',16),
277	(263,'Seraikela Kharsawan',16),
278	(264,'Simdega',16),
279	(265,'West Singhbhum',16),
280	(266,'Bagalkot',17),
281	(267,'Bangalore Rural',17),
282	(268,'Bangalore Urban',17),
283	(269,'Belgaum',17),
284	(270,'Bellary',17),
285	(271,'Bidar',17),
286	(272,'Vijayapura ',17),
287	(273,'Chamarajanagar',17),
288	(274,'Chikkaballapur',17),
289	(275,'Chikkamagaluru',17),
290	(276,'Chitradurga',17),
291	(277,'Dakshina Kannada',17),
292	(278,'Davanagere',17),
293	(279,'Dharwad',17),
294	(280,'Gadag',17),
295	(281,'Gulbarga',17),
296	(282,'Hassan',17),
297	(283,'Haveri',17),
298	(284,'Kodagu',17),
299	(285,'Kolar',17),
300	(286,'Koppal',17),
301	(287,'Mandya',17),
302	(288,'Mysore',17),
303	(289,'Raichur',17),
304	(290,'Ramanagara',17),
305	(291,'Shimoga',17),
306	(292,'Tumkur',17),
307	(293,'Udupi',17),
308	(294,'Uttara Kannada',17),
309	(295,'Yadgir',17),
310	(296,'Alappuzha',18),
311	(297,'Ernakulam',18),
312	(298,'Idukki',18),
313	(299,'Kannur',18),
314	(300,'Kasaragod',18),
315	(301,'Kollam',18),
316	(302,'Kottayam',18),
317	(303,'Kozhikode',18),
318	(304,'Malappuram',18),
319	(305,'Palakkad',18),
320	(306,'Pathanamthitta',18),
321	(307,'Thiruvananthapuram',18),
322	(308,'Thrissur',18),
323	(309,'Wayanad',18),
324	(310,'Lakshadweep',19),
325	(311,'Agar Malwa',20),
326	(312,'Alirajpur',20),
327	(313,'Anuppur',20),
328	(314,'Ashoknagar',20),
329	(315,'Balaghat',20),
330	(316,'Barwani',20),
331	(317,'Betul',20),
332	(318,'Bhind',20),
333	(319,'Bhopal',20),
334	(320,'Burhanpur',20),
335	(321,'Chhatarpur',20),
336	(322,'Chhindwara',20),
337	(323,'Damoh',20),
338	(324,'Datia',20),
339	(325,'Dewas',20),
340	(326,'Dhar',20),
341	(327,'Dindori',20),
342	(328,'Guna',20),
343	(329,'Gwalior',20),
344	(330,'Harda',20),
345	(331,'Hoshangabad',20),
346	(332,'Indore',20),
347	(333,'Jabalpur',20),
348	(334,'Jhabua',20),
349	(335,'Katni',20),
350	(336,'Khandwa',20),
351	(337,'Khargone',20),
352	(338,'Mandla',20),
353	(339,'Mandsaur',20),
354	(340,'Morena',20),
355	(341,'Narsinghpur',20),
356	(342,'Neemuch',20),
357	(343,'Panna',20),
358	(344,'Raisen',20),
359	(345,'Rajgarh',20),
360	(346,'Ratlam',20),
361	(347,'Rewa',20),
362	(348,'Sagar',20),
363	(349,'Satna',20),
364	(350,'Sehore',20),
365	(351,'Seoni',20),
366	(352,'Shahdol',20),
367	(353,'Shajapur',20),
368	(354,'Sheopur',20),
369	(355,'Shivpuri',20),
370	(356,'Sidhi',20),
371	(357,'Singrauli',20),
372	(358,'Tikamgarh',20),
373	(359,'Ujjain',20),
374	(360,'Umaria',20),
375	(361,'Vidisha',20),
376	(362,'Ahmednagar',21),
377	(363,'Akola',21),
378	(364,'Amravati',21),
379	(365,'Aurangabad',21),
380	(366,'Beed',21),
381	(367,'Bhandara',21),
382	(368,'Buldhana',21),
383	(369,'Chandrapur',21),
384	(370,'Dhule',21),
385	(371,'Gadchiroli',21),
386	(372,'Gondia',21),
387	(373,'Hingoli',21),
388	(374,'Jalgaon',21),
389	(375,'Jalna',21),
390	(376,'Kolhapur',21),
391	(377,'Latur',21),
392	(378,'Mumbai City',21),
393	(379,'Mumbai Suburban',21),
394	(380,'Nagpur',21),
395	(381,'Nanded',21),
396	(382,'Nandurbar',21),
397	(383,'Nashik',21),
398	(384,'Osmanabad',21),
399	(385,'Palghar',21),
400	(386,'Parbhani',21),
401	(387,'Pune',21),
402	(388,'Raigad',21),
403	(389,'Ratnagiri',21),
404	(390,'Sangli',21),
405	(391,'Satara',21),
406	(392,'Sindhudurg',21),
407	(393,'Solapur',21),
408	(394,'Thane',21),
409	(395,'Wardha',21),
410	(396,'Washim',21),
411	(397,'Yavatmal',21),
412	(398,'Bishnupur',22),
413	(399,'Chandel',22),
414	(400,'Churachandpur',22),
415	(401,'Imphal East',22),
416	(402,'Imphal West',22),
417	(403,'Jiribam',22),
418	(404,'Kakching',22),
419	(405,'Kamjong',22),
420	(406,'Kangpokpi',22),
421	(407,'Noney',22),
422	(408,'Pherzawl',22),
423	(409,'Senapati',22),
424	(410,'Tamenglong',22),
425	(411,'Tengnoupal',22),
426	(412,'Thoubal',22),
427	(413,'Ukhrul',22),
428	(414,'East Garo Hills',23),
429	(415,'East Jaintia Hills',23),
430	(416,'East Khasi Hills',23),
431	(417,'North Garo Hills',23),
432	(418,'Ri Bhoi',23),
433	(419,'South Garo Hills',23),
434	(420,'South West Garo Hills',23),
435	(421,'South West Khasi Hills',23),
436	(422,'West Garo Hills',23),
437	(423,'West Jaintia Hills',23),
438	(424,'West Khasi Hills',23),
439	(425,'Aizawl',24),
440	(426,'Champhai',24),
441	(427,'Kolasib',24),
442	(428,'Lawngtlai',24),
443	(429,'Lunglei',24),
444	(430,'Mamit',24),
445	(431,'Saiha',24),
446	(432,'Serchhip',24),
447	(433,'Dimapur',25),
448	(434,'Kiphire',25),
449	(435,'Kohima',25),
450	(436,'Longleng',25),
451	(437,'Mokokchung',25),
452	(438,'Mon',25),
453	(439,'Peren',25),
454	(440,'Phek',25),
455	(441,'Tuensang',25),
456	(442,'Wokha',25),
457	(443,'Zunheboto',25),
458	(444,'Angul',26),
459	(445,'Balangir',26),
460	(446,'Balasore',26),
461	(447,'Bargarh',26),
462	(448,'Bhadrak',26),
463	(449,'Boudh',26),
464	(450,'Cuttack',26),
465	(451,'Debagarh',26),
466	(452,'Dhenkanal',26),
467	(453,'Gajapati',26),
468	(454,'Ganjam',26),
469	(455,'Jagatsinghpur',26),
470	(456,'Jajpur',26),
471	(457,'Jharsuguda',26),
472	(458,'Kalahandi',26),
473	(459,'Kandhamal',26),
474	(460,'Kendrapara',26),
475	(461,'Kendujhar',26),
476	(462,'Khordha',26),
477	(463,'Koraput',26),
478	(464,'Malkangiri',26),
479	(465,'Mayurbhanj',26),
480	(466,'Nabarangpur',26),
481	(467,'Nayagarh',26),
482	(468,'Nuapada',26),
483	(469,'Puri',26),
484	(470,'Rayagada',26),
485	(471,'Sambalpur',26),
486	(472,'Subarnapur',26),
487	(473,'Sundergarh',26),
488	(474,'Karaikal',27),
489	(475,'Mahe',27),
490	(476,'Puducherry',27),
491	(477,'Yanam',27),
492	(478,'Amritsar',28),
493	(479,'Barnala',28),
494	(480,'Bathinda',28),
495	(481,'Faridkot',28),
496	(482,'Fatehgarh Sahib',28),
497	(483,'Fazilka',28),
498	(484,'Firozpur',28),
499	(485,'Gurdaspur',28),
500	(486,'Hoshiarpur',28),
501	(487,'Jalandhar',28),
502	(488,'Kapurthala',28),
503	(489,'Ludhiana',28),
504	(490,'Mansa',28),
505	(491,'Moga',28),
506	(492,'Mohali',28),
507	(493,'Muktsar',28),
508	(494,'Pathankot',28),
509	(495,'Patiala',28),
510	(496,'Rupnagar',28),
511	(497,'Sangrur',28),
512	(498,'Shaheed Bhagat Singh Nagar',28),
513	(499,'Tarn Taran',28),
514	(500,'Ajmer',29),
515	(501,'Alwar',29),
516	(502,'Banswara',29),
517	(503,'Baran',29),
518	(504,'Barmer',29),
519	(505,'Bharatpur',29),
520	(506,'Bhilwara',29),
521	(507,'Bikaner',29),
522	(508,'Bundi',29),
523	(509,'Chittorgarh',29),
524	(510,'Churu',29),
525	(511,'Dausa',29),
526	(512,'Dholpur',29),
527	(513,'Dungarpur',29),
528	(514,'Ganganagar',29),
529	(515,'Hanumangarh',29),
530	(516,'Jaipur',29),
531	(517,'Jaisalmer',29),
532	(518,'Jalore',29),
533	(519,'Jhalawar',29),
534	(520,'Jhunjhunu',29),
535	(521,'Jodhpur',29),
536	(522,'Karauli',29),
537	(523,'Kota',29),
538	(524,'Nagaur',29),
539	(525,'Pali',29),
540	(526,'Pratapgarh',29),
541	(527,'Rajsamand',29),
542	(528,'Sawai Madhopur',29),
543	(529,'Sikar',29),
544	(530,'Sirohi',29),
545	(531,'Tonk',29),
546	(532,'Udaipur',29),
547	(533,'East Sikkim',30),
548	(534,'North Sikkim',30),
549	(535,'South Sikkim',30),
550	(536,'West Sikkim',30),
551	(537,'Ariyalur',31),
552	(538,'Chennai',31),
553	(539,'Coimbatore',31),
554	(540,'Cuddalore',31),
555	(541,'Dharmapuri',31),
556	(542,'Dindigul',31),
557	(543,'Erode',31),
558	(544,'Kanchipuram',31),
559	(545,'Kanyakumari',31),
560	(546,'Karur',31),
561	(547,'Krishnagiri',31),
562	(548,'Madurai',31),
563	(549,'Nagapattinam',31),
564	(550,'Namakkal',31),
565	(551,'Nilgiris',31),
566	(552,'Perambalur',31),
567	(553,'Pudukkottai',31),
568	(554,'Ramanathapuram',31),
569	(555,'Salem',31),
570	(556,'Sivaganga',31),
571	(557,'Thanjavur',31),
572	(558,'Theni',31),
573	(559,'Thoothukudi',31),
574	(560,'Tiruchirappalli',31),
575	(561,'Tirunelveli',31),
576	(562,'Tiruppur',31),
577	(563,'Tiruvallur',31),
578	(564,'Tiruvannamalai',31),
579	(565,'Tiruvarur',31),
580	(566,'Vellore',31),
581	(567,'Viluppuram',31),
582	(568,'Virudhunagar',31),
583	(569,'Adilabad',32),
584	(570,'Bhadradri Kothagudem',32),
585	(571,'Hyderabad',32),
586	(572,'Jagtial',32),
587	(573,'Jangaon',32),
588	(574,'Jayashankar',32),
589	(575,'Jogulamba',32),
590	(576,'Kamareddy',32),
591	(577,'Karimnagar',32),
592	(578,'Khammam',32),
593	(579,'Komaram Bheem',32),
594	(580,'Mahabubabad',32),
595	(581,'Mahbubnagar',32),
596	(582,'Mancherial',32),
597	(583,'Medak',32),
598	(584,'Medchal',32),
599	(585,'Nagarkurnool',32),
600	(586,'Nalgonda',32),
601	(587,'Nirmal',32),
602	(588,'Nizamabad',32),
603	(589,'Peddapalli',32),
604	(590,'Rajanna Sircilla',32),
605	(591,'Ranga Reddy',32),
606	(592,'Sangareddy',32),
607	(593,'Siddipet',32),
608	(594,'Suryapet',32),
609	(595,'Vikarabad',32),
610	(596,'Wanaparthy',32),
611	(597,'Warangal Rural',32),
612	(598,'Warangal Urban',32),
613	(599,'Yadadri Bhuvanagiri',32),
614	(600,'Dhalai',33),
615	(601,'Gomati',33),
616	(602,'Khowai',33),
617	(603,'North Tripura',33),
618	(604,'Sepahijala',33),
619	(605,'South Tripura',33),
620	(606,'Unakoti',33),
621	(607,'West Tripura',33),
622	(608,'Agra',34),
623	(609,'Aligarh',34),
624	(610,'Allahabad',34),
625	(611,'Ambedkar Nagar',34),
626	(612,'Amethi',34),
627	(613,'Amroha',34),
628	(614,'Auraiya',34),
629	(615,'Azamgarh',34),
630	(616,'Baghpat',34),
631	(617,'Bahraich',34),
632	(618,'Ballia',34),
633	(619,'Balrampur',34),
634	(620,'Banda',34),
635	(621,'Barabanki',34),
636	(622,'Bareilly',34),
637	(623,'Basti',34),
638	(624,'Bhadohi',34),
639	(625,'Bijnor',34),
640	(626,'Budaun',34),
641	(627,'Bulandshahr',34),
642	(628,'Chandauli',34),
643	(629,'Chitrakoot',34),
644	(630,'Deoria',34),
645	(631,'Etah',34),
646	(632,'Etawah',34),
647	(633,'Faizabad',34),
648	(634,'Farrukhabad',34),
649	(635,'Fatehpur',34),
650	(636,'Firozabad',34),
651	(637,'Gautam Buddha Nagar',34),
652	(638,'Ghaziabad',34),
653	(639,'Ghazipur',34),
654	(640,'Gonda',34),
655	(641,'Gorakhpur',34),
656	(642,'Hamirpur',34),
657	(643,'Hapur',34),
658	(644,'Hardoi',34),
659	(645,'Hathras',34),
660	(646,'Jalaun',34),
661	(647,'Jaunpur',34),
662	(648,'Jhansi',34),
663	(649,'Kannauj',34),
664	(650,'Kanpur Dehat',34),
665	(651,'Kanpur Nagar',34),
666	(652,'Kasganj',34),
667	(653,'Kaushambi',34),
668	(654,'Kheri',34),
669	(655,'Kushinagar',34),
670	(656,'Lalitpur',34),
671	(657,'Lucknow',34),
672	(658,'Maharajganj',34),
673	(659,'Mahoba',34),
674	(660,'Mainpuri',34),
675	(661,'Mathura',34),
676	(662,'Mau',34),
677	(663,'Meerut',34),
678	(664,'Mirzapur',34),
679	(665,'Moradabad',34),
680	(666,'Muzaffarnagar',34),
681	(667,'Pilibhit',34),
682	(668,'Pratapgarh',34),
683	(669,'Raebareli',34),
684	(670,'Rampur',34),
685	(671,'Saharanpur',34),
686	(672,'Sambhal',34),
687	(673,'Sant Kabir Nagar',34),
688	(674,'Shahjahanpur',34),
689	(675,'Shamli',34),
690	(676,'Shravasti',34),
691	(677,'Siddharthnagar',34),
692	(678,'Sitapur',34),
693	(679,'Sonbhadra',34),
694	(680,'Sultanpur',34),
695	(681,'Unnao',34),
696	(682,'Varanasi',34),
697	(683,'Almora',35),
698	(684,'Bageshwar',35),
699	(685,'Chamoli',35),
700	(686,'Champawat',35),
701	(687,'Dehradun',35),
702	(688,'Haridwar',35),
703	(689,'Nainital',35),
704	(690,'Pauri',35),
705	(691,'Pithoragarh',35),
706	(692,'Rudraprayag',35),
707	(693,'Tehri',35),
708	(694,'Udham Singh Nagar',35),
709	(695,'Uttarkashi',35),
710	(696,'Alipurduar',36),
711	(697,'Bankura',36),
712	(698,'Birbhum',36),
713	(699,'Cooch Behar',36),
714	(700,'Dakshin Dinajpur',36),
715	(701,'Darjeeling',36),
716	(702,'Hooghly',36),
717	(703,'Howrah',36),
718	(704,'Jalpaiguri',36),
719	(705,'Jhargram',36),
720	(706,'Kalimpong',36),
721	(707,'Kolkata',36),
722	(708,'Malda',36),
723	(709,'Murshidabad',36),
724	(710,'Nadia',36),
725	(711,'North 24 Parganas',36),
726	(712,'Paschim Bardhaman',36),
727	(713,'Paschim Medinipur',36),
728	(714,'Purba Bardhaman',36),
729	(715,'Purba Medinipur',36),
730	(716,'Purulia',36),
731	(717,'South 24 Parganas',36),
732	(718,'Uttar Dinajpur',36);
733
734UNLOCK TABLES;
735
736DROP TABLE IF EXISTS `state`;
737
738CREATE TABLE `state` (
739  `id` bigint(20) NOT NULL AUTO_INCREMENT,
740  `name` varchar(255) DEFAULT NULL,
741  PRIMARY KEY (`id`)
742) ENGINE=MyISAM DEFAULT CHARSET=utf8;
743
744LOCK TABLES `state` WRITE;
745
746INSERT INTO `state` (`id`, `name`)
747VALUES
748	(1,'Andaman Nicobar'),
749	(2,'Andhra Pradesh'),
750	(3,'Arunachal Pradesh'),
751	(4,'Assam'),
752	(5,'Bihar'),
753	(6,'Chandigarh'),
754	(7,'Chhattisgarh'),
755	(8,'Dadra Nagar Haveli'),
756	(9,'Daman Diu'),
757	(10,'Delhi'),
758	(11,'Goa'),
759	(12,'Gujarat'),
760	(13,'Haryana'),
761	(14,'Himachal Pradesh'),
762	(15,'Jammu Kashmir'),
763	(16,'Jharkhand'),
764	(17,'Karnataka'),
765	(18,'Kerala'),
766	(19,'Lakshadweep'),
767	(20,'Madhya Pradesh'),
768	(21,'Maharashtra'),
769	(22,'Manipur'),
770	(23,'Meghalaya'),
771	(24,'Mizoram'),
772	(25,'Nagaland'),
773	(26,'Odisha'),
774	(27,'Puducherry'),
775	(28,'Punjab'),
776	(29,'Rajasthan'),
777	(30,'Sikkim'),
778	(31,'Tamil Nadu'),
779	(32,'Telangana'),
780	(33,'Tripura'),
781	(34,'Uttar Pradesh'),
782	(35,'Uttarakhand'),
783	(36,'West Bengal');
784
785UNLOCK TABLES;