Project

General

Profile

« Previous | Next » 

Revision 11641

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/.TNRS/schema.sql: removed no longer used AcceptedTaxon. use taxon_scrub.scrubbed_unique_taxon_name.* instead.

View differences:

schema.sql
208 208 

  		




  209
  209
  
    

  		




  210
  210
  
    
--


  		




  211
  
  
    
-- Name: AcceptedTaxon; Type: VIEW; Schema: TNRS; Owner: -


  		




  212
  
  
    
--


  		




  213
  
  
    

  		




  214
  
  
    
CREATE VIEW "AcceptedTaxon" AS


  		




  215
  
  
    
    SELECT tnrs.batch AS "*Accepted_name.batch", tnrs."Name_submitted" AS "acceptedScientificName", tnrs."Genus_matched" AS "acceptedGenus", tnrs."Specific_epithet_matched" AS "acceptedSpecificEpithet", tnrs."Infraspecific_epithet_matched" AS "acceptedInfraspecificEpithet", tnrs."Taxonomic_status" AS "acceptedTaxonomicStatus", tnrs."Selected" AS "*Accepted_name.Selected", tnrs."Source" AS "*Accepted_name.Source", tnrs."Warnings" AS "*Accepted_name.Warnings", tnrs."Accepted_name_lsid" AS "*Accepted_name.Accepted_name_lsid" FROM tnrs;


  		




  216
  
  
    

  		




  217
  
  
    

  		




  218
  
  
    
--


  		




  219
  211
  
    
-- Name: MatchedTaxon; Type: VIEW; Schema: TNRS; Owner: -


  		




  220
  212
  
    
--


  		




  221
  213
  
    

  		












Also available in:  Unified diff