Revision 5412
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 152 | 152 |
|
| 153 | 153 |
|
| 154 | 154 |
-- |
| 155 |
-- Name: taxonconcept_canon_concept_min_fit(); Type: FUNCTION; Schema: public; Owner: - |
|
| 156 |
-- |
|
| 157 |
|
|
| 158 |
|
|
| 159 |
|
|
| 160 |
|
|
| 161 |
-- |
|
| 155 | 162 |
-- Name: taxonconcept_update_ancestors(); Type: FUNCTION; Schema: public; Owner: - |
| 156 | 163 |
-- |
| 157 | 164 |
|
| ... | ... | |
| 4018 | 4025 |
|
| 4019 | 4026 |
|
| 4020 | 4027 |
-- |
| 4028 |
-- Name: taxonconcept_canon_concept_min_fit; Type: TRIGGER; Schema: public; Owner: - |
|
| 4029 |
-- |
|
| 4030 |
|
|
| 4031 |
|
|
| 4032 |
|
|
| 4033 |
|
|
| 4034 |
-- |
|
| 4021 | 4035 |
-- Name: taxonconcept_update_ancestors; Type: TRIGGER; Schema: public; Owner: - |
| 4022 | 4036 |
-- |
| 4023 | 4037 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: Added taxonconcept_canon_concept_min_fit() trigger to remove the canon_concept_id link from insufficient matches. These occur when e.g. a name in another language is approximated to a latin name or when the input name is not a proper taxon but TNRS provides a best-guess match anyway.