Revision 5655
Added by Aaron Marcuse-Kubitza about 12 years ago
| test.xml.ref | ||
|---|---|---|
| 12 | 12 |
<_taxonlabel_set_matched_label_id> |
| 13 | 13 |
<matched_label_id> |
| 14 | 14 |
<taxonlabel> |
| 15 |
<author>$Accepted_name_author</author> |
|
| 16 |
<binomial>$Accepted_name</binomial> |
|
| 17 |
<family>$Accepted_name_family</family> |
|
| 18 | 15 |
<identifyingtaxonomicname> |
| 19 | 16 |
<_join_words> |
| 20 | 17 |
<1> |
| ... | ... | |
| 77 | 74 |
</taxonlabel> |
| 78 | 75 |
</parent_id> |
| 79 | 76 |
<rank>$Accepted_name_rank</rank> |
| 80 |
<verbatimrank>$Accepted_name_rank</verbatimrank>
|
|
| 77 |
<taxonverbatim><verbatimrank>$Accepted_name_rank</verbatimrank></taxonverbatim>
|
|
| 81 | 78 |
</taxonlabel> |
| 82 | 79 |
</parent_id> |
| 83 | 80 |
<rank>$Accepted_name_rank</rank> |
| 84 |
<verbatimrank>$Accepted_name_rank</verbatimrank> |
|
| 81 |
<taxonverbatim> |
|
| 82 |
<author>$Accepted_name_author</author> |
|
| 83 |
<binomial>$Accepted_name</binomial> |
|
| 84 |
<family>$Accepted_name_family</family> |
|
| 85 |
<verbatimrank>$Accepted_name_rank</verbatimrank> |
|
| 86 |
</taxonverbatim> |
|
| 85 | 87 |
</taxonlabel> |
| 86 | 88 |
</matched_label_id> |
| 87 | 89 |
</_taxonlabel_set_matched_label_id> |
| 88 |
<author>$Name_matched_author</author> |
|
| 89 |
<binomial>$Name_matched</binomial> |
|
| 90 |
<family>$Name_matched_accepted_family</family> |
|
| 91 |
<genus>$Genus_matched</genus> |
|
| 92 | 90 |
<identifyingtaxonomicname> |
| 93 | 91 |
<_join_words> |
| 94 | 92 |
<1> |
| ... | ... | |
| 120 | 118 |
<parent_id> |
| 121 | 119 |
<taxonlabel> |
| 122 | 120 |
<rank>$Name_matched_rank</rank> |
| 123 |
<verbatimrank>$Name_matched_rank</verbatimrank>
|
|
| 121 |
<taxonverbatim><verbatimrank>$Name_matched_rank</verbatimrank></taxonverbatim>
|
|
| 124 | 122 |
<parent_id> |
| 125 | 123 |
<taxonlabel> |
| 126 | 124 |
<rank>cultivar</rank> |
| ... | ... | |
| 164 | 162 |
</parent_id> |
| 165 | 163 |
<rank>$Name_matched_rank</rank> |
| 166 | 164 |
<sourceaccessioncode>$Name_matched_url</sourceaccessioncode> |
| 167 |
<species>$Specific_epithet_matched</species> |
|
| 168 | 165 |
<taxonlabel fkey="matched_label_id"> |
| 169 |
<author>$Author_matched</author> |
|
| 170 |
<binomial>$Name_matched</binomial> |
|
| 171 |
<family>$Family_matched</family> |
|
| 172 |
<genus>$Genus_matched</genus> |
|
| 173 | 166 |
<identifyingtaxonomicname>$Name_submitted</identifyingtaxonomicname> |
| 174 | 167 |
<matched_label_fit_fraction> |
| 175 | 168 |
<_max> |
| ... | ... | |
| 179 | 172 |
<4>$Overall_score</4> |
| 180 | 173 |
</_max> |
| 181 | 174 |
</matched_label_fit_fraction> |
| 182 |
<morphospecies>$Unmatched_terms</morphospecies> |
|
| 183 |
<species>$Specific_epithet_matched</species> |
|
| 184 |
<verbatimrank>$Infraspecific_rank</verbatimrank> |
|
| 175 |
<taxonverbatim> |
|
| 176 |
<author>$Author_matched</author> |
|
| 177 |
<binomial>$Name_matched</binomial> |
|
| 178 |
<family>$Family_matched</family> |
|
| 179 |
<genus>$Genus_matched</genus> |
|
| 180 |
<morphospecies>$Unmatched_terms</morphospecies> |
|
| 181 |
<species>$Specific_epithet_matched</species> |
|
| 182 |
<verbatimrank>$Infraspecific_rank</verbatimrank> |
|
| 183 |
</taxonverbatim> |
|
| 185 | 184 |
</taxonlabel> |
| 186 | 185 |
<taxonstatus>$Taxonomic_status</taxonstatus> |
| 187 |
<verbatimrank>$Name_matched_rank</verbatimrank> |
|
| 186 |
<taxonverbatim> |
|
| 187 |
<author>$Name_matched_author</author> |
|
| 188 |
<binomial>$Name_matched</binomial> |
|
| 189 |
<family>$Name_matched_accepted_family</family> |
|
| 190 |
<genus>$Genus_matched</genus> |
|
| 191 |
<species>$Specific_epithet_matched</species> |
|
| 192 |
<verbatimrank>$Name_matched_rank</verbatimrank> |
|
| 193 |
</taxonverbatim> |
|
| 188 | 194 |
</taxonlabel> |
| 189 | 195 |
</taxonlabel_id> |
| 190 | 196 |
</taxondetermination> |
| ... | ... | |
| 194 | 200 |
</path> |
| 195 | 201 |
</_simplifyPath> |
| 196 | 202 |
</VegBIEN> |
| 197 |
Inserted 11 new rows into database |
|
| 203 |
Inserted 16 new rows into database |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonlabel: Moved non-scoping fields to new taxonverbatim subclass table, which contains the component parts of the taxonlabel