Issue 18938

Phylum Miozoa not a synonym

Reporter: mdoering
Type: Task
Summary: Phylum Miozoa not a synonym
Priority: Blocker
Resolution: Fixed
Status: Closed
Created: 2017-02-22 09:20:54.418
Updated: 2017-02-22 09:22:09.683
Resolved: 2017-02-22 09:22:09.633
Description: Starting with the February 2017 backbone Miozoa should be a synonym for the new phylum Myzozoa as per Gbif algae Classification checklist. CoL still treats it as an accepted phylum why it got created as such in parallel with Myzozoa.

Nub source priority order has been changed to reflect that, but the phylum Miozoa and its sole child class need to me moved manually]]>

Created: 2017-02-22 09:21:23.582
Updated: 2017-02-22 09:21:23.582
Executed SQL to make Miozoa a synonym of Myzozoa:
# rewire all children of Miozoa (7971837) to Myzozoa (8770992)
UPDATE name_usage SET parent_fk=8770992 WHERE parent_fk=7971837;
# update Miozoa (7971837) source and make it a synonym of Myzozoa
UPDATE name_usage SET parent_fk=8770992, source_taxon_key=127602789, constituent_key='7ea21580-4f06-469d-995b-3f713fdcc37c', phylum_fk=8770992, is_synonym=true, status='SYNONYM', num_descendants=0 WHERE id=7971837;
UPDATE name_usage SET num_descendants=num_descendants+1037 WHERE id=7971837;

# update all Miozoa phyla
UPDATE name_usage SET phylum_fk=8770992 WHERE phylum_fk=7971837;
# update usage metrics for miozoa and myzozoa
UPDATE name_usage_metrics SET modified=now(), count_children=count_children+1, count_synonyms=1, count_c=count_c+1, count_o=count_o+7, count_f=count_f+33, count_g=count_g+249, count_s=count_s+747 WHERE usage_fk=8770992;
UPDATE name_usage_metrics SET modified=now(), count_children=0, count_synonyms=0, count_c=0, count_o=0, count_f=0, count_g=0, count_s=0 WHERE usage_fk=7971837;