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;