Revision 9913
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 14 | 14 |
"Time_submitted" timestamp with time zone NOT NULL DEFAULT now(), |
| 15 | 15 |
"Name_number" integer NOT NULL, |
| 16 | 16 |
"Name_submitted" text NOT NULL, |
| 17 |
"Overall_score" text,
|
|
| 17 |
"Overall_score" double precision,
|
|
| 18 | 18 |
"Name_matched" text, |
| 19 | 19 |
"Name_matched_rank" text, |
| 20 |
"Name_score" text,
|
|
| 20 |
"Name_score" double precision,
|
|
| 21 | 21 |
"Name_matched_author" text, |
| 22 | 22 |
"Name_matched_url" text, |
| 23 | 23 |
"Author_matched" text, |
| 24 |
"Author_score" text,
|
|
| 24 |
"Author_score" double precision,
|
|
| 25 | 25 |
"Family_matched" text, |
| 26 |
"Family_score" text,
|
|
| 26 |
"Family_score" double precision,
|
|
| 27 | 27 |
"Name_matched_accepted_family" text, |
| 28 | 28 |
"Genus_matched" text, |
| 29 |
"Genus_score" text,
|
|
| 29 |
"Genus_score" double precision,
|
|
| 30 | 30 |
"Specific_epithet_matched" text, |
| 31 |
"Specific_epithet_score" text,
|
|
| 31 |
"Specific_epithet_score" double precision,
|
|
| 32 | 32 |
"Infraspecific_rank" text, |
| 33 | 33 |
"Infraspecific_epithet_matched" text, |
| 34 |
"Infraspecific_epithet_score" text,
|
|
| 34 |
"Infraspecific_epithet_score" double precision,
|
|
| 35 | 35 |
"Infraspecific_rank_2" text, |
| 36 | 36 |
"Infraspecific_epithet_2_matched" text, |
| 37 |
"Infraspecific_epithet_2_score" text,
|
|
| 37 |
"Infraspecific_epithet_2_score" double precision,
|
|
| 38 | 38 |
"Annotations" text, |
| 39 | 39 |
"Unmatched_terms" text, |
| 40 | 40 |
"Taxonomic_status" text, |
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs: *_score: changed type to double precision because these fields are always floats. this also avoids the need to manually cast them to double precision each time they are used.