Subversion Repositories eFlore/Applications.cel

Rev

Rev 2435 | Rev 2467 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2435 Rev 2466
Line 10... Line 10...
10 
 
 10 
 
11 
-- Ajoute le champ «date_liaison» dans «cel_images»
 11 
-- Ajoute le champ «date_liaison» dans «cel_images»
Line 12... Line 12...
12 
ALTER TABLE `cel_images` ADD `date_liaison` DATETIME NOT NULL AFTER `date_creation`;
 12 
ALTER TABLE `cel_images` ADD `date_liaison` DATETIME NOT NULL AFTER `date_creation`;
13 
 
 13 
 
Line 14... Line 14...
14 
-- Ajoute le champ «date_transmission» dans «cel_images»
 14 
-- Ajoute le champ «date_transmission» dans «cel_images»
15 
ALTER TABLE `cel_images` ADD `date_transmission` DATETIME NOT NULL AFTER `date_liaison`;
 15 
ALTER TABLE `cel_images` ADD `date_transmission` DATETIME NULL AFTER `date_liaison`;
Line 16... Line 16...
16 
 
 16 
 
Line 42... Line 42...
42 
RENAME TABLE cel_obs_images TO cel_obs_images_obsolete;
 42 
RENAME TABLE cel_obs_images TO cel_obs_images_obsolete;
Line 43... Line 43...
43 
 
 43 
 
44 
-- -----------------------------------------------------
 44 
-- -----------------------------------------------------
45 
SET SQL_MODE=@OLD_SQL_MODE;
 45 
SET SQL_MODE=@OLD_SQL_MODE;
46 
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
 - 
 
47 
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
 46 
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
- 
 
 47 
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;