Project

General

Profile

1 11495 psarando
BEGIN;
2
3 11557 psarando
TRUNCATE geonames, alternateNames, countries, hierarchy,
4
         gadm_country_lookup, gadm_stateprovince_lookup, gadm_county_lookup,
5
         alt_country, alt_stateprovince;
6 11495 psarando
7
DROP INDEX IF EXISTS geonames_countrycode_idx;
8
DROP INDEX IF EXISTS geonames_featurecode_idx;
9
DROP INDEX IF EXISTS geonames_name_idx;
10
DROP INDEX IF EXISTS "alternatenames_alternatename_idx";
11
DROP INDEX IF EXISTS "alternatenames_geonameid_idx";
12
DROP INDEX IF EXISTS hierarchy_parentid_idx;
13
DROP INDEX IF EXISTS hierarchy_childid_idx;
14
15
COMMIT;