BEGIN;

TRUNCATE geonames;

TRUNCATE alternateNames;

TRUNCATE countries;

TRUNCATE hierarchy;

DROP INDEX IF EXISTS geonames_countrycode_idx;

DROP INDEX IF EXISTS geonames_featurecode_idx;

DROP INDEX IF EXISTS geonames_name_idx;

DROP INDEX IF EXISTS "alternatenames_alternatename_idx";

DROP INDEX IF EXISTS "alternatenames_geonameid_idx";

DROP INDEX IF EXISTS hierarchy_parentid_idx;

DROP INDEX IF EXISTS hierarchy_childid_idx;

COMMIT;