Subversion Repositories eFlore/Applications.coel

Compare Revisions

Ignore whitespace Rev 78 → Rev 79

/trunk/doc/bdd/migration_bdd_herbiers_vers_coel.sql
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);