Project

General

Profile

task #6279

Updated by Andreas Kohlbecker over 7 years ago

during the import all name which did not have an explicitly stated status, did receive the status 'nom. valid'. This turned out to be not correct in all cases. So we need to remove all the 'nom. val' status from names 

 this can be done using a sql script. 

 ~~~sql 
  delete t_n from TaxonNameBase_NomenclaturalStatus t_n where t_n.status_id in (select n.id from NomenclaturalStatus n where n.type_id = 860); 
  delete n from NomenclaturalStatus n where n.type_id = 860; 
 ~~~

Back