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