Revision 5110
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/.TNRS/tnrs/+header.csv | ||
|---|---|---|
| 1 |
Name_number,Name_submitted,Overall_score,Name_matched,Name_matched_rank,Name_score,Name_matched_author,Name_matched_url,Author_matched,Author_score,Family_matched,Family_score,Name_matched_accepted_family,Genus_matched,Genus_score,Specific_epithet_matched,Specific_epithet_score,Infraspecific_rank,Infraspecific_epithet_matched,Infraspecific_epithet_score,Infraspecific_rank_2,Infraspecific_epithet_2_matched,Infraspecific_epithet_2_score,Annotations,Unmatched_terms,Taxonomic_status,Accepted_name,Accepted_name_author,Accepted_name_rank,Accepted_name_url,Accepted_name_species,Accepted_name_family,Selected,Source,Warnings,Accepted_name_lsid |
|
| inputs/.TNRS/tnrs/postprocess.sql | ||
|---|---|---|
| 1 |
ALTER TABLE :table ALTER COLUMN "Name_submitted" SET NOT NULL; |
|
| 2 |
ALTER TABLE :table ADD PRIMARY KEY("Name_submitted");
|
|
| inputs/.TNRS/tnrs/header.csv | ||
|---|---|---|
| 1 |
Name_number,Name_submitted,Overall_score,Name_matched,Name_matched_rank,Name_score,Name_matched_author,Name_matched_url,Author_matched,Author_score,Family_matched,Family_score,Name_matched_accepted_family,Genus_matched,Genus_score,Specific_epithet_matched,Specific_epithet_score,Infraspecific_rank,Infraspecific_epithet_matched,Infraspecific_epithet_score,Infraspecific_rank_2,Infraspecific_epithet_2_matched,Infraspecific_epithet_2_score,Annotations,Unmatched_terms,Taxonomic_status,Accepted_name,Accepted_name_author,Accepted_name_rank,Accepted_name_url,Accepted_name_species,Accepted_name_family,Selected,Source,Warnings,Accepted_name_lsid |
|
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 1 |
CREATE TABLE "TNRS".tnrs |
|
| 2 |
( |
|
| 3 |
"Name_number" text, |
|
| 4 |
"Name_submitted" text NOT NULL, |
|
| 5 |
"Overall_score" text, |
|
| 6 |
"Name_matched" text, |
|
| 7 |
"Name_matched_rank" text, |
|
| 8 |
"Name_score" text, |
|
| 9 |
"Name_matched_author" text, |
|
| 10 |
"Name_matched_url" text, |
|
| 11 |
"Author_matched" text, |
|
| 12 |
"Author_score" text, |
|
| 13 |
"Family_matched" text, |
|
| 14 |
"Family_score" text, |
|
| 15 |
"Name_matched_accepted_family" text, |
|
| 16 |
"Genus_matched" text, |
|
| 17 |
"Genus_score" text, |
|
| 18 |
"Specific_epithet_matched" text, |
|
| 19 |
"Specific_epithet_score" text, |
|
| 20 |
"Infraspecific_rank" text, |
|
| 21 |
"Infraspecific_epithet_matched" text, |
|
| 22 |
"Infraspecific_epithet_score" text, |
|
| 23 |
"Infraspecific_rank_2" text, |
|
| 24 |
"Infraspecific_epithet_2_matched" text, |
|
| 25 |
"Infraspecific_epithet_2_score" text, |
|
| 26 |
"Annotations" text, |
|
| 27 |
"Unmatched_terms" text, |
|
| 28 |
"Taxonomic_status" text, |
|
| 29 |
"Accepted_name" text, |
|
| 30 |
"Accepted_name_author" text, |
|
| 31 |
"Accepted_name_rank" text, |
|
| 32 |
"Accepted_name_url" text, |
|
| 33 |
"Accepted_name_species" text, |
|
| 34 |
"Accepted_name_family" text, |
|
| 35 |
"Selected" text, |
|
| 36 |
"Source" text, |
|
| 37 |
"Warnings" text, |
|
| 38 |
"Accepted_name_lsid" text, |
|
| 39 |
CONSTRAINT tnrs_pkey PRIMARY KEY ("Name_submitted" )
|
|
| 40 |
) |
|
| 41 |
WITH ( |
|
| 42 |
OIDS=FALSE |
|
| 43 |
); |
|
Also available in: Unified diff
inputs/.TNRS/tnrs/: Create using datasource schema.sql file instead of text header and postprocess.sql, for clarity and to enable using `make inputs/.TNRS/tnrs/install` to clean up the tnrs entries populated by tnrs_db