| 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;
|
