Project

General

Profile

« Previous | Next » 

Revision 9758

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/.TNRS/schema.sql: MatchedTaxon: renamed to ValidMatchedTaxon since this view actually contains only the names with a valid match

View differences:

schema.sql
91 91 
  EXECUTE PROCEDURE tnrs_populate_fields();
92 92 

  		




  93
  93
  
    

  		




  94
  
  
    
CREATE OR REPLACE VIEW "MatchedTaxon" AS


  		




  
  94
  
    
CREATE OR REPLACE VIEW "ValidMatchedTaxon" AS


  		




  95
  95
  
    
SELECT


  		




  96
  96
  
    
  "Time_submitted" AS "*Name_matched.Time_submitted"


  		




  97
  97
  
    
, "Name_submitted" AS "concatenatedScientificName"


  		




  ......




  145
  145
  
    

  		




  146
  146
  
    
CREATE OR REPLACE VIEW "ScrubbedTaxon" AS


  		




  147
  147
  
    
SELECT *


  		




  148
  
  
    
FROM "MatchedTaxon"


  		




  
  148
  
    
FROM "ValidMatchedTaxon"


  		




  149
  149
  
    
NATURAL LEFT JOIN "AcceptedTaxon"


  		




  150
  150
  
    
;


  		












Also available in:  Unified diff