/trunk/scripts/modules/cel/maj-cleanup-201307.sql |
---|
56,7 → 56,3 |
-- nom_ret = "null" |
UPDATE `BASEEDIT`.`cel_obs` SET nom_ret = NULL WHERE nom_ret = 'null'; |
-- inconsistence de date_transmission avec transmission (cf r1860) |
UPDATE TABLE `BASEEDIT`.`cel_obs` SET date_transmission = date_creation WHERE date_transmission IS NULL AND transmission = 1; |
UPDATE TABLE `BASEEDIT`.`cel_obs` SET date_transmission = NULL WHERE date_transmission IS NOT NULL AND transmission = 0; |