Revision 13866
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 15277 | 15277 |
|
| 15278 | 15278 |
|
| 15279 | 15279 |
-- |
| 15280 |
-- Name: taxon_match_input__copy_to__insert(); Type: FUNCTION; Schema: TNRS; Owner: - |
|
| 15281 |
-- |
|
| 15282 |
|
|
| 15283 |
|
|
| 15284 |
|
|
| 15285 |
|
|
| 15286 |
-- |
|
| 15280 | 15287 |
-- Name: taxon_name_is_safe(varchar(255)); Type: FUNCTION; Schema: TNRS; Owner: - |
| 15281 | 15288 |
-- |
| 15282 | 15289 |
|
| ... | ... | |
| 15512 | 15519 |
|
| 15513 | 15520 |
|
| 15514 | 15521 |
-- |
| 15522 |
-- Name: taxon_match_input; Type: VIEW; Schema: TNRS; Owner: - |
|
| 15523 |
-- |
|
| 15524 |
|
|
| 15525 |
|
|
| 15526 |
|
|
| 15527 |
|
|
| 15528 |
-- |
|
| 15529 |
-- Name: taxon_match_input__copy_to; Type: TABLE; Schema: TNRS; Owner: -; Tablespace: |
|
| 15530 |
-- |
|
| 15531 |
|
|
| 15532 |
CREATE TABLE taxon_match_input__copy_to ( |
|
| 15533 |
`Name_number` int(11), |
|
| 15534 |
`Name_submitted` varchar(255), |
|
| 15535 |
`Overall_score` double, |
|
| 15536 |
`Name_matched` varchar(255), |
|
| 15537 |
`Name_matched_rank` varchar(255), |
|
| 15538 |
`Name_score` double, |
|
| 15539 |
`Name_matched_author` varchar(255), |
|
| 15540 |
`Name_matched_url` varchar(255), |
|
| 15541 |
`Author_matched` varchar(255), |
|
| 15542 |
`Author_score` double, |
|
| 15543 |
`Family_matched` varchar(255), |
|
| 15544 |
`Family_score` double, |
|
| 15545 |
`Name_matched_accepted_family` varchar(255), |
|
| 15546 |
`Genus_matched` varchar(255), |
|
| 15547 |
`Genus_score` double, |
|
| 15548 |
`Specific_epithet_matched` varchar(255), |
|
| 15549 |
`Specific_epithet_score` double, |
|
| 15550 |
`Infraspecific_rank` varchar(255), |
|
| 15551 |
`Infraspecific_epithet_matched` varchar(255), |
|
| 15552 |
`Infraspecific_epithet_score` double, |
|
| 15553 |
`Infraspecific_rank_2` varchar(255), |
|
| 15554 |
`Infraspecific_epithet_2_matched` varchar(255), |
|
| 15555 |
`Infraspecific_epithet_2_score` double, |
|
| 15556 |
`Annotations` varchar(255), |
|
| 15557 |
`Unmatched_terms` varchar(255), |
|
| 15558 |
`Taxonomic_status` varchar(255), |
|
| 15559 |
`Accepted_name` varchar(255), |
|
| 15560 |
`Accepted_name_author` varchar(255), |
|
| 15561 |
`Accepted_name_rank` varchar(255), |
|
| 15562 |
`Accepted_name_url` varchar(255), |
|
| 15563 |
`Accepted_name_species` varchar(255), |
|
| 15564 |
`Accepted_name_family` varchar(255), |
|
| 15565 |
`Selected` varchar(255), |
|
| 15566 |
`Source` varchar(255), |
|
| 15567 |
`Warnings` varchar(255), |
|
| 15568 |
`Accepted_name_lsid` varchar(255) |
|
| 15569 |
); |
|
| 15570 |
|
|
| 15571 |
|
|
| 15572 |
-- |
|
| 15515 | 15573 |
-- Name: taxon_scrub.scrubbed_unique_taxon_name.*; Type: VIEW; Schema: TNRS; Owner: - |
| 15516 | 15574 |
-- |
| 15517 | 15575 |
|
| ... | ... | |
| 15683 | 15741 |
|
| 15684 | 15742 |
|
| 15685 | 15743 |
-- |
| 15744 |
-- Name: taxon_match_input__copy_to__insert; Type: TRIGGER; Schema: TNRS; Owner: - |
|
| 15745 |
-- |
|
| 15746 |
|
|
| 15747 |
|
|
| 15748 |
|
|
| 15749 |
|
|
| 15750 |
-- |
|
| 15686 | 15751 |
-- Name: tnrs__batch_begin; Type: TRIGGER; Schema: TNRS; Owner: - |
| 15687 | 15752 |
-- |
| 15688 | 15753 |
|
| ... | ... | |
| 15768 | 15833 |
|
| 15769 | 15834 |
|
| 15770 | 15835 |
-- |
| 15836 |
-- Name: taxon_match_input; Type: ACL; Schema: TNRS; Owner: - |
|
| 15837 |
-- |
|
| 15838 |
|
|
| 15839 |
|
|
| 15840 |
|
|
| 15841 |
|
|
| 15842 |
|
|
| 15843 |
|
|
| 15844 |
|
|
| 15845 |
-- |
|
| 15771 | 15846 |
-- Name: taxon_scrub.scrubbed_unique_taxon_name.*; Type: ACL; Schema: TNRS; Owner: - |
| 15772 | 15847 |
-- |
| 15773 | 15848 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match: insert names via taxon_match_input auto-updatable view instead of directly into taxon_match, to allow the taxon_match columns to be renamed while still supporting inserts using the TNRS column names