Details

    • Type: Task Task
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Checklistbank
    • Labels:

      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

        Gliffy Diagrams

          Activity

          Hide
          Markus Döring added a comment -

          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;
          
          Show
          Markus Döring added a comment - 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;

            People

            • Assignee:
              Unassigned
              Reporter:
              Markus Döring
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: