Subversion Repositories eFlore/Applications.coel

Compare Revisions

Ignore whitespace Rev 1466 → Rev 1467

/trunk/doc/bdd/correction_historique.sql
New file
0,0 → 1,27
UPDATE coel_meta_historique_ligne SET cmhl_ce_table = 107
WHERE cmhl_ce_table = 102
AND cmhl_cle_ligne NOT LIKE '%-%';
 
UPDATE coel_meta_historique_ligne SET cmhl_cle_ligne = CONCAT_WS('-',
IF (ExtractValue(cmhl_enregistrement, '//csap_id_personne') = '', 0, ExtractValue(cmhl_enregistrement, '//csap_id_personne')),
ExtractValue(cmhl_enregistrement, '//csap_id_role'),
ExtractValue(cmhl_enregistrement, '//csap_id_structure')
)
WHERE cmhl_ce_table = 121
AND cmhl_ce_etat = 1;
 
UPDATE coel_meta_historique_ligne SET cmhl_cle_ligne = CONCAT_WS('-',
SUBSTRING_INDEX(cmhl_cle_ligne, '-', 1), # Premier
SUBSTRING_INDEX(cmhl_cle_ligne, '-', -1), # Dernier
SUBSTRING_INDEX(SUBSTRING_INDEX(cmhl_cle_ligne, '-', 2), '-', -1)# Milieu
)
WHERE cmhl_ce_table = 121
AND cmhl_ce_etat = 2;
 
UPDATE coel_meta_historique_ligne SET cmhl_cle_ligne = CONCAT_WS('-',
SUBSTRING_INDEX(SUBSTRING_INDEX(cmhl_cle_ligne, '-', 2), '-', -1), # Milieu
SUBSTRING_INDEX(cmhl_cle_ligne, '-', -1), # Dernier
SUBSTRING_INDEX(cmhl_cle_ligne, '-', 1) # Premier
)
WHERE cmhl_ce_table = 121
AND cmhl_ce_etat = 3;