161,7 → 161,7 |
INSERT INTO tb_coel.coel_meta_historique_ligne |
(cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, |
cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip) |
SELECT @idm_tmp := @idm_tmp+1, '113', ID_STAFF, NULL, DATE_DERNIERE_MODIF, |
SELECT @idm_tmp := @idm_tmp+1, '113', 100000+ID_STAFF, NULL, IF(DATE_DERNIERE_MODIF != '0000-00-00 00:00:00', DATE_DERNIERE_MODIF, NOW()), |
CONCAT('Importation de l''utilisateur #', ID_STAFF,' de la table HERBIERS_STAFF'), '1', '1', '162.38.234.1' |
FROM tb_herbiers.HERBIERS_STAFF |
ORDER BY ID_STAFF ASC; |