-- === INDIA COUNTRIES/STATES TABLE ===
CREATE TABLE IF NOT EXISTS `india_locations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `country` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Sample data
INSERT IGNORE INTO `india_locations` (`country`, `state`) VALUES
('India', 'Andhra Pradesh'),
('India', 'Arunachal Pradesh'),
('India', 'Assam'),
('India', 'Bihar'),
('India', 'Chhattisgarh'),
('India', 'Goa'),
('India', 'Gujarat'),
('India', 'Haryana'),
('India', 'Himachal Pradesh'),
('India', 'Jharkhand'),
('India', 'Karnataka'),
('India', 'Kerala'),
('India', 'Madhya Pradesh'),
('India', 'Maharashtra'),
('India', 'Manipur'),
('India', 'Meghalaya'),
('India', 'Mizoram'),
('India', 'Nagaland'),
('India', 'Odisha'),
('India', 'Punjab'),
('India', 'Rajasthan'),
('India', 'Sikkim'),
('India', 'Tamil Nadu'),
('India', 'Telangana'),
('India', 'Tripura'),
('India', 'Uttar Pradesh'),
('India', 'Uttarakhand'),
('India', 'West Bengal'),
('India', 'Delhi');

