Revision 13846
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 559 | 559 |
-- |
| 560 | 560 |
|
| 561 | 561 |
COMMENT ON VIEW "taxon_scrub.scrubbed_unique_taxon_name.*" IS ' |
| 562 |
to modify: |
|
| 563 |
SELECT util.recreate_view(''"TNRS"."taxon_scrub.scrubbed_unique_taxon_name.*"'', $$
|
|
| 564 |
SELECT __ |
|
| 565 |
$$); |
|
| 566 |
|
|
| 562 | 567 |
scrubbed_family: Name_matched_accepted_family was missing from the TNRS results at one point, so Family_matched is used as a workaround to populate this. the workaround is for *accepted names only*, as no opinion names do not have an Accepted_name_family to prepend to the scrubbed name to parse. |
| 563 | 568 |
'; |
| 564 | 569 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 19550 | 19550 |
-- |
| 19551 | 19551 |
|
| 19552 | 19552 |
COMMENT ON VIEW "taxon_scrub.scrubbed_unique_taxon_name.*" IS ' |
| 19553 |
to modify: |
|
| 19554 |
SELECT util.recreate_view(''"TNRS"."taxon_scrub.scrubbed_unique_taxon_name.*"'', $$
|
|
| 19555 |
SELECT __ |
|
| 19556 |
$$); |
|
| 19557 |
|
|
| 19553 | 19558 |
scrubbed_family: Name_matched_accepted_family was missing from the TNRS results at one point, so Family_matched is used as a workaround to populate this. the workaround is for *accepted names only*, as no opinion names do not have an Accepted_name_family to prepend to the scrubbed name to parse. |
| 19554 | 19559 |
'; |
| 19555 | 19560 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: `taxon_scrub.scrubbed_unique_taxon_name.*`: added to-modify instructions