Project

General

Profile

Download (305 Bytes) Statistics
| Revision:

root/trunk/inputs/GBIF/_MySQL/GBIFPortalDB-2013-02-20.schema.z.clean_up.sql @ 12004

1 9573 aaronmk 
-- 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;