261,7 → 261,7 |
ORDER BY hi.ID_INDIC ASC; |
|
#------------------------------------------------------------------------------------------------------------------------ |
#HERBIERS_A_UN_TYPE vers coel_collection_a_commentaire |
# HERBIERS_A_UN_TYPE vers coel_collection_a_commentaire |
INSERT INTO tb_coel.coel_collection_a_commentaire |
(ccac_id_collection, ccac_id_commentaire, |
ccac_truk_type, |
281,17 → 281,8 |
GROUP BY hi.ID_INDIC |
ORDER BY hi.ID_INDIC ASC; |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#------------------------------------------------------------------------------------------------------------------------ |
# Mise à jour des id de personne inexistant dans l''annuaire Tela |
UPDATE tb_coel.coel_meta_historique_ligne |
SET cmhl_ce_modifier_par = 1 |
WHERE cmhl_ce_modifier_par NOT IN (SELECT U_ID FROM tb_v4.annuaire_tela); |