Project

General

Profile

« Previous | Next » 

Revision 9573

Added by Aaron Marcuse-Kubitza over 11 years ago

added inputs/GBIF/_MySQL/GBIFPortalDB-2013-02-20.schema.z.clean_up.sql, which removes duplicated and unnecessary indexes in raw_occurrence_record

View differences:

inputs/GBIF/_MySQL/GBIFPortalDB-2013-02-20.schema.z.clean_up.sql
1 
-- remove duplicated indexes
2 
ALTER TABLE raw_occurrence_record DROP INDEX primarykey;
3 

  		




  
  4
  
    
-- remove unnecessary indexes


  		




  
  5
  
    
ALTER TABLE raw_occurrence_record DROP INDEX created;


  		




  
  6
  
    
ALTER TABLE raw_occurrence_record DROP INDEX resource_access_point_id;


  		




  
  7
  
    
ALTER TABLE raw_occurrence_record DROP INDEX data_resource_id;


  		












Also available in:  Unified diff