-- =====================================================================
-- Starter India states/cities seed. Not exhaustive - admin can add more
-- via Settings > Geography. Kept small so multi-city rollout is a data
-- operation, not a code change (spec section 22).
-- =====================================================================

SET NAMES utf8mb4;

INSERT INTO states (name, code) VALUES
('Maharashtra', 'MH'),
('Delhi', 'DL'),
('Karnataka', 'KA'),
('Telangana', 'TG'),
('Tamil Nadu', 'TN'),
('Gujarat', 'GJ'),
('Uttar Pradesh', 'UP'),
('West Bengal', 'WB'),
('Rajasthan', 'RJ'),
('Punjab', 'PB');

INSERT INTO cities (state_id, name) VALUES
((SELECT id FROM states WHERE code='MH'), 'Mumbai'),
((SELECT id FROM states WHERE code='MH'), 'Pune'),
((SELECT id FROM states WHERE code='DL'), 'New Delhi'),
((SELECT id FROM states WHERE code='KA'), 'Bengaluru'),
((SELECT id FROM states WHERE code='TG'), 'Hyderabad'),
((SELECT id FROM states WHERE code='TN'), 'Chennai'),
((SELECT id FROM states WHERE code='GJ'), 'Ahmedabad'),
((SELECT id FROM states WHERE code='UP'), 'Lucknow'),
((SELECT id FROM states WHERE code='WB'), 'Kolkata'),
((SELECT id FROM states WHERE code='RJ'), 'Jaipur');