Revision 7830
Added by Aaron Marcuse-Kubitza almost 12 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 87 | 87 |
CREATE OR REPLACE VIEW "MatchedTaxon" AS |
| 88 | 88 |
SELECT |
| 89 | 89 |
"Time_submitted" AS "*Name_matched.Time_submitted" |
| 90 |
, "Name_submitted" AS "concatenatedScientificName" |
|
| 90 | 91 |
, "Name_matched" AS "matchedTaxonName" |
| 91 | 92 |
, "Name_matched_rank" AS "matchedTaxonRank" |
| 92 | 93 |
, "Name_score" AS "*Name_matched.Name_score" |
Also available in: Unified diff
inputs/.TNRS/schema.sql: MatchedTaxon: Added missing Name_submitted column