Project

General

Profile

« Previous | Next » 

Revision 11557

Added by Paul Sarando about 11 years ago

Fixed TRUNCATE statement in truncate.geonames.sql.

Fixed the biengeo truncate.geonames.sql script to include all tables in
one TRUNCATE statement that have foreign-key references to geonames and
country tables.

View differences:

truncate.geonames.sql
1 1 
BEGIN;
2 2 

  		




  3
  
  
    
TRUNCATE geonames;


  		




  4
  
  
    
TRUNCATE alternateNames;


  		




  5
  
  
    
TRUNCATE countries;


  		




  6
  
  
    
TRUNCATE hierarchy;


  		




  
  3
  
    
TRUNCATE geonames, alternateNames, countries, hierarchy,


  		




  
  4
  
    
         gadm_country_lookup, gadm_stateprovince_lookup, gadm_county_lookup,


  		




  
  5
  
    
         alt_country, alt_stateprovince;


  		




  7
  6
  
    

  		




  8
  7
  
    
DROP INDEX IF EXISTS geonames_countrycode_idx;


  		




  9
  8
  
    
DROP INDEX IF EXISTS geonames_featurecode_idx;


  		












Also available in:  Unified diff