Line 159... |
Line 159... |
159 |
FROM tb_herbiers.HERBIERS_STAFF
|
159 |
FROM tb_herbiers.HERBIERS_STAFF
|
160 |
ORDER BY ID_STAFF ASC;
|
160 |
ORDER BY ID_STAFF ASC;
|
161 |
INSERT INTO tb_coel.coel_meta_historique_ligne
|
161 |
INSERT INTO tb_coel.coel_meta_historique_ligne
|
162 |
(cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement,
|
162 |
(cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement,
|
163 |
cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
|
163 |
cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
|
164 |
SELECT @idm_tmp := @idm_tmp+1, '113', ID_STAFF, NULL, DATE_DERNIERE_MODIF,
|
164 |
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()),
|
165 |
CONCAT('Importation de l''utilisateur #', ID_STAFF,' de la table HERBIERS_STAFF'), '1', '1', '162.38.234.1'
|
165 |
CONCAT('Importation de l''utilisateur #', ID_STAFF,' de la table HERBIERS_STAFF'), '1', '1', '162.38.234.1'
|
166 |
FROM tb_herbiers.HERBIERS_STAFF
|
166 |
FROM tb_herbiers.HERBIERS_STAFF
|
167 |
ORDER BY ID_STAFF ASC;
|
167 |
ORDER BY ID_STAFF ASC;
|
Line 168... |
Line 168... |
168 |
|
168 |
|