Project

General

Profile

« Previous | Next » 

Revision 14111

Added by Aaron Marcuse-Kubitza over 10 years ago

fix: inputs/.TNRS/schema.sql: taxon_match: added back * prefixes on TNRS-namespace column names

View differences:

vegbien.my.sql
15411 15411 
CREATE TABLE taxon_match (
15412 15412 
    batch varchar(255)  NOT NULL,
15413 15413 
    match_num int(11) NOT NULL,
15414 
    `Name_number` int(11) NOT NULL,
15415 
    `Name_submitted` varchar(255) NOT NULL,
15416 
    `Overall_score` double,
15417 
    `Name_matched` varchar(255),
15418 
    `Name_matched_rank` varchar(255),
15419 
    `Name_score` double,
15420 
    `Name_matched_author` varchar(255),
15421 
    `Name_matched_url` varchar(255),
15422 
    `Author_matched` varchar(255),
15423 
    `Author_score` double,
15424 
    `Family_matched` varchar(255),
15425 
    `Family_score` double,
15426 
    `Name_matched_accepted_family` varchar(255),
15427 
    `Genus_matched` varchar(255),
15428 
    `Genus_score` double,
15429 
    `Specific_epithet_matched` varchar(255),
15430 
    `Specific_epithet_score` double,
15431 
    `Infraspecific_rank` varchar(255),
15432 
    `Infraspecific_epithet_matched` varchar(255),
15433 
    `Infraspecific_epithet_score` double,
15434 
    `Infraspecific_rank_2` varchar(255),
15435 
    `Infraspecific_epithet_2_matched` varchar(255),
15436 
    `Infraspecific_epithet_2_score` double,
15437 
    `Annotations` varchar(255),
15438 
    `Unmatched_terms` varchar(255),
15439 
    `Taxonomic_status` varchar(255),
15440 
    `Accepted_name` varchar(255),
15441 
    `Accepted_name_author` varchar(255),
15442 
    `Accepted_name_rank` varchar(255),
15443 
    `Accepted_name_url` varchar(255),
15444 
    `Accepted_name_species` varchar(255),
15445 
    `Accepted_name_family` varchar(255),
15446 
    `Selected` varchar(255),
15447 
    `Source` varchar(255),
15448 
    `Warnings` varchar(255),
15449 
    `Accepted_name_lsid` varchar(255),
15414 
    `*Name_number` int(11) NOT NULL,
15415 
    `*Name_submitted` varchar(255) NOT NULL,
15416 
    `*Overall_score` double,
15417 
    `*Name_matched` varchar(255),
15418 
    `*Name_matched_rank` varchar(255),
15419 
    `*Name_score` double,
15420 
    `*Name_matched_author` varchar(255),
15421 
    `*Name_matched_url` varchar(255),
15422 
    `*Author_matched` varchar(255),
15423 
    `*Author_score` double,
15424 
    `*Family_matched` varchar(255),
15425 
    `*Family_score` double,
15426 
    `*Name_matched_accepted_family` varchar(255),
15427 
    `*Genus_matched` varchar(255),
15428 
    `*Genus_score` double,
15429 
    `*Specific_epithet_matched` varchar(255),
15430 
    `*Specific_epithet_score` double,
15431 
    `*Infraspecific_rank` varchar(255),
15432 
    `*Infraspecific_epithet_matched` varchar(255),
15433 
    `*Infraspecific_epithet_score` double,
15434 
    `*Infraspecific_rank_2` varchar(255),
15435 
    `*Infraspecific_epithet_2_matched` varchar(255),
15436 
    `*Infraspecific_epithet_2_score` double,
15437 
    `*Annotations` varchar(255),
15438 
    `*Unmatched_terms` varchar(255),
15439 
    `*Taxonomic_status` varchar(255),
15440 
    `*Accepted_name` varchar(255),
15441 
    `*Accepted_name_author` varchar(255),
15442 
    `*Accepted_name_rank` varchar(255),
15443 
    `*Accepted_name_url` varchar(255),
15444 
    `*Accepted_name_species` varchar(255),
15445 
    `*Accepted_name_family` varchar(255),
15446 
    `*Selected` varchar(255),
15447 
    `*Source` varchar(255),
15448 
    `*Warnings` varchar(255),
15449 
    `*Accepted_name_lsid` varchar(255),
15450 15450 
    is_valid_match int(1) NOT NULL,
15451 15451 
    scrubbed_unique_taxon_name varchar(255)
15452 15452 
);
......
15783 15783 
-- Name: taxon_match_Name_submitted_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
15784 15784 
--
15785 15785 

  		




  15786
  
  
    
CREATE INDEX `taxon_match_Name_submitted_idx` ON taxon_match  (`Name_submitted`);


  		




  
  15786
  
    
CREATE INDEX `taxon_match_Name_submitted_idx` ON taxon_match  (`*Name_submitted`);


  		




  15787
  15787
  
    

  		




  15788
  15788
  
    

  		




  15789
  15789
  
    
--


  		












Also available in:  Unified diff