Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 2465 → Rev 2466

/trunk/doc/bdd/2014-09_migration_optimisation/maj_optimisation.sql
12,7 → 12,7
ALTER TABLE `cel_images` ADD `date_liaison` DATETIME NOT NULL AFTER `date_creation`;
 
-- Ajoute le champ «date_transmission» dans «cel_images»
ALTER TABLE `cel_images` ADD `date_transmission` DATETIME NOT NULL AFTER `date_liaison`;
ALTER TABLE `cel_images` ADD `date_transmission` DATETIME NULL AFTER `date_liaison`;
 
-- Ajoute le champ «ce_observation» dans «cel_images»
ALTER TABLE `cel_images` ADD `ce_observation` BIGINT NULL AFTER `id_image`;
44,4 → 44,4
-- -----------------------------------------------------
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;