changelogs.txt

21 Sep 2023
Qifeng.bai@csiro.au
* database change:

    Add a new table: matchedSpecies with fields: taxonConceptID, scientificName, scientificNameAuthorship, vernacularName, kingdom, phylum, taxonClass, taxonOrder, taxonRank, family, genus

          CREATE TABLE `matched_species` (
              `id` int NOT NULL AUTO_INCREMENT,
              `taxon_concept_id` varchar(255) DEFAULT NULL,
              `scientific_name` varchar(255) NOT NULL,
              `scientific_name_authorship` varchar(255) DEFAULT NULL,
              `vernacular_name` varchar(255) DEFAULT NULL,
              `kingdom` varchar(255) DEFAULT NULL,
              `phylum` varchar(255) DEFAULT NULL,
              `taxon_class` varchar(255) DEFAULT NULL,
              `taxon_order` varchar(255) DEFAULT NULL,
              `family` varchar(255) DEFAULT NULL,
              `genus` varchar(255) DEFAULT NULL,
              `taxon_rank` varchar(255) DEFAULT NULL,
              `version` BIGINT NOT NULL DEFAULT 0,
              UNIQUE KEY `id_UNIQUE` (`id`)
              )

        Create an index for:
        ALTER TABLE `specieslist`.`matched_species`
          Add index `idx_concept_id` (`taxon_concept_id`);
        ALTER TABLE `specieslist`.`matched_species`
          Add index `idx_scientific_name` (`scientific_name`);
    Link the new created matchedSpecies table to speciesListItem table:
            ALTER TABLE `specieslist`.`species_list_item`
            ADD COLUMN `matched_species_id` INT DEFAULT NULL