root/inputs/GBIF/_MySQL/GBIFPortalDB-2013-02-20.schema.z.clean_up.sql @ 9826
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; |