  DELETE FROM taxonomie.cor_nom_liste;
  DELETE FROM taxonomie.bib_noms;

  INSERT INTO taxonomie.bib_noms(cd_nom,cd_ref,nom_francais)
  SELECT cd_nom, cd_ref, nom_vern
  FROM taxonomie.taxref
  WHERE id_rang NOT IN ('Dumm','SPRG','KD','SSRG','IFRG','PH','SBPH','IFPH','DV','SBDV','SPCL','CLAD','CL',
     'SBCL','IFCL','LEG','SPOR','COH','OR','SBOR','IFOR','SPFM','FM','SBFM','TR','SSTR');



  INSERT INTO taxonomie.cor_nom_liste (id_liste,id_nom)
  SELECT 500,n.id_nom FROM taxonomie.bib_noms n;


UPDATE gn_commons.t_modules
SET module_picto = 'place'
WHERE module_name = 'occtax';