Project

General

Profile

« Previous | Next » 

Revision 13440

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: schemas/public_.sql: _plots_20_tnrs_names: morphospeciesSuffix must still be called morphospecies_suffix, not taxon_morphospecies, because that column has not been updated to the taxon_morphospecies yet (fixes r13435)

View differences:

trunk/schemas/public_.sql
9395 9395 
    taxon_scrub.scrubbed_family AS tnrs_accepted_name_family,
9396 9396 
    taxon_scrub.scrubbed_taxon_name_no_author AS tnrs_accepted_name,
9397 9397 
    taxon_scrub.scrubbed_author AS tnrs_accepted_name_author,
9398 
    taxon_scrub."morphospeciesSuffix" AS taxon_morphospecies
9398 
    taxon_scrub."morphospeciesSuffix" AS morphospecies_suffix
9399 9399 
   FROM ((public.taxonverbatim
9400 9400 
   JOIN public.taxonlabel USING (taxonlabel_id))
9401 9401 
   JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname)))
trunk/schemas/vegbien.sql
9395 9395 
    taxon_scrub.scrubbed_family AS tnrs_accepted_name_family,
9396 9396 
    taxon_scrub.scrubbed_taxon_name_no_author AS tnrs_accepted_name,
9397 9397 
    taxon_scrub.scrubbed_author AS tnrs_accepted_name_author,
9398 
    taxon_scrub."morphospeciesSuffix" AS taxon_morphospecies
9398 
    taxon_scrub."morphospeciesSuffix" AS morphospecies_suffix
9399 9399 
   FROM ((public.taxonverbatim
9400 9400 
   JOIN public.taxonlabel USING (taxonlabel_id))
9401 9401 
   JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname)))

Also available in: Unified diff