States if India not displaying in dropdown list during checkout process in magento 1.7.0.2

States if India not displaying in dropdown list during checkout process in magento 1.7.0.2

INSERT INTO `directory_country_region` VALUES (NULL , "IN", "Andaman Nicobar","Andaman Nicobar"), (NULL , "IN", "Andhra Pradesh","Andhra Pradesh"), (NULL , "IN", "Arunachal Pradesh","Arunachal Pradesh"), (NULL , "IN", "Assam","Assam"), (NULL , "IN", "Bihar","Bihar"), (NULL , "IN", "Chandigarh","Chandigarh"), (NULL , "IN", "Chhattisgarh","Chhattisgarh"), (NULL , "IN", "Dadra Nagar Haveli","Dadra Nagar Haveli"), (NULL , "IN", "Daman Diu","Daman Diu"), (NULL , "IN", "Delhi","Delhi"), (NULL , "IN", "Goa","Goa"), (NULL , "IN", "Gujarat","Gujarat"), (NULL , "IN", "Haryana","Haryana"), (NULL , "IN", "Himachal Pradesh","Himachal Pradesh"), (NULL , "IN", "Jammu Kashmir","Jammu Kashmir"), (NULL , "IN", "Jharkhand","Jharkhand"), (NULL , "IN", "Karnataka","Karnataka"), (NULL , "IN", "Kerala","Kerala"), (NULL , "IN", "Lakshadweep","Lakshadweep"), (NULL , "IN", "Madhya Pradesh","Madhya Pradesh"), (NULL , "IN", "Maharashtra","Maharashtra"), (NULL , "IN", "Manipur","Manipur"), (NULL , "IN", "Meghalaya","Meghalaya"), (NULL , "IN", "Mizoram","Mizoram"), (NULL , "IN", "Nagaland","Nagaland"), (NULL , "IN", "Orissa","Orissa"), (NULL , "IN", "Pondicherry","Pondicherry"), (NULL , "IN", "Punjab","Punjab"), (NULL , "IN", "Rajasthan","Rajasthan"), (NULL , "IN", "Sikkim","Sikkim"), (NULL , "IN", "Tamil Nadu","Tamil Nadu"), (NULL , "IN", "Tripura","Tripura"), (NULL , "IN", "Uttar Pradesh","Uttar Pradesh"), (NULL , "IN", "Uttaranchal","Uttaranchal"), (NULL , "IN", "West Bengal","West Bengal"); INSERT INTO `directory_country_region_name` (`locale` ,`region_id` ,`name` ) SELECT 'en_US', tmp.region_id, tmp.default_name FROM `directory_country_region` AS tmp WHERE tmp.country_id='IN';