SET FOREIGN_KEY_CHECKS = 0;

DELETE FROM administrative_division;
DELETE FROM subdivision;
DELETE FROM country;
DELETE FROM continent;

TRUNCATE TABLE administrative_division;
TRUNCATE TABLE subdivision;
TRUNCATE TABLE country;
TRUNCATE TABLE continent;

ALTER TABLE administrative_division AUTO_INCREMENT = 1;
ALTER TABLE subdivision AUTO_INCREMENT = 1;
ALTER TABLE country AUTO_INCREMENT = 1;
ALTER TABLE continent AUTO_INCREMENT = 1;

SET FOREIGN_KEY_CHECKS = 1;
