-- All 36 states + FCT. Idempotent via INSERT IGNORE.

INSERT IGNORE INTO states (name, geo_zone) VALUES
('Benue','North Central'),('Federal Capital Territory','North Central'),('Kogi','North Central'),
('Kwara','North Central'),('Nasarawa','North Central'),('Niger','North Central'),('Plateau','North Central'),
('Adamawa','North East'),('Bauchi','North East'),('Borno','North East'),('Gombe','North East'),
('Taraba','North East'),('Yobe','North East'),
('Jigawa','North West'),('Kaduna','North West'),('Kano','North West'),('Katsina','North West'),
('Kebbi','North West'),('Sokoto','North West'),('Zamfara','North West'),
('Abia','South East'),('Anambra','South East'),('Ebonyi','South East'),('Enugu','South East'),('Imo','South East'),
('Akwa Ibom','South South'),('Bayelsa','South South'),('Cross River','South South'),('Delta','South South'),
('Edo','South South'),('Rivers','South South'),
('Ekiti','South West'),('Lagos','South West'),('Ogun','South West'),('Ondo','South West'),
('Osun','South West'),('Oyo','South West');

-- NOTE ON LGAs:
-- Nigeria has 774 LGAs total. Rather than hand-seeding all of them here
-- (high risk of transcription error in a hand-typed list this long),
-- import a verified LGA dataset (e.g. from NBS or INEC's published list)
-- as a CSV keyed by state name, then run a one-off import script that
-- resolves state_id by name and bulk-inserts into `lgas`. Flag if you'd
-- like that CSV-import script built next.