/trunk/scripts/modules/cel/maj-cleanup-201307.sql |
---|
58,5 → 58,5 |
-- 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; |
UPDATE `BASEEDIT`.`cel_obs` SET date_transmission = date_creation WHERE date_transmission IS NULL AND transmission = 1; |
UPDATE `BASEEDIT`.`cel_obs` SET date_transmission = NULL WHERE date_transmission IS NOT NULL AND transmission = 0; |