Merge all dwc_archive service_type_id entries in all registry dbs

10654
Reporter: mdoering
Assignee: jcuadra
Type: Improvement
Summary: Merge all dwc_archive service_type_id entries in all registry dbs
Priority: Critical
Resolution: Fixed
Status: Closed
Created: 2012-01-18 15:21:00.582
Updated: 2013-12-16 17:50:53.056
Resolved: 2012-02-29 14:50:45.722
        
Description: id 10 and 15 both represent dwc archives.
Id 15 is not supported in the api enums anymore, therefore update all databases to use #10 only!
]]>
    

Author: jcuadra@gbif.org
Created: 2012-02-08 11:58:40.675
Updated: 2012-02-08 11:58:40.675
        
The old service_type_id=10 and service_type_id=15 are both deprecated.

There is a DWC-ARCHIVE-CHECKLIST and DWC-ARCHIVE-OCCURRENCE now (old ids: 18,19 respectively)

so all services with type_id=10 or 15 should be moved to their corresponding 18 or 19.
    

Author: jcuadra@gbif.org
Created: 2012-02-29 14:50:45.744
Updated: 2012-02-29 14:51:21.151
        
With Kyle's help in checking the archive contents, all deprecated service types have been reassigned to their corresponding new type (DWC-ARCHIVE-OCCURRENCE (type=16170 or type=19 in current live Reg-DB)).

Changes have been included as a liquibase changeset and the Registry-live, Registry-dev and Registry-staging DBs have been updated to point to the new type.

Changes in:
http://code.google.com/p/gbif-registry/source/detail?r=2328