PhycoBank

task #6277

Updated by Andreas Kohlbecker over 7 years ago

use nomenclatural reference as sec. references for all taxa which have the IAPT as sec reference  

 this can be done using the following sql script: 

 ~~~sql 
 update TaxonBase t set t.sec_id = 
     ( select r.id from TaxonNameBase n 
       join Reference r on    n.nomenclaturalReference_id = r.id 
       where n.id = t.name_id 
     ) 
   where sec_id = 14 and ( select r.id from TaxonNameBase n 
       join Reference r on    n.nomenclaturalReference_id = r.id 
       where n.id = t.name_id 
     ) is not null; 


 update TaxonBase t set t.titleCache = null 
 where t.protectedTitleCache = 0 and t.sec_id is not null; 
 ~~~

Back