BEGIN;

TRUNCATE geonames, alternateNames, countries, hierarchy,
         gadm_country_lookup, gadm_stateprovince_lookup, gadm_county_lookup,
         alt_country, alt_stateprovince;

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;