|
1
|
BEGIN;
|
|
2
|
|
|
3
|
TRUNCATE geonames, alternateNames, countries, hierarchy,
|
|
4
|
gadm_country_lookup, gadm_stateprovince_lookup, gadm_county_lookup,
|
|
5
|
alt_country, alt_stateprovince;
|
|
6
|
|
|
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;
|
|
16
|
|
