| 1,3 → 1,7 |
|---|
| SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; |
| SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; |
| SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; |
| |
| -- Supprime le champ «publiable_eflore» |
| ALTER TABLE `cel_images` DROP `publiable_eflore` ; |
| |
| 15,7 → 19,8 |
|---|
| |
| -- Met à jour la table cel_image avec les données de cel_obs_images |
| UPDATE cel_images, cel_obs_images |
| SET cel_images.ce_observation = cel_obs_images.id_observation, cel_images.date_liaison = cel_obs_images.date_liaison |
| SET cel_images.ce_observation = cel_obs_images.id_observation, |
| cel_images.date_liaison = cel_obs_images.date_liaison |
| WHERE cel_images.id_image = cel_obs_images.id_image |
| AND cel_obs_images.id_image != '0'; |
| |
| 22,11 → 27,17 |
|---|
| -- Ajout index sur ce_observation |
| CREATE INDEX ce_observation ON cel_images (ce_observation); |
| |
| -- Mise à jour du champ «transmission» de la table cel_images à partir des données de cel_obs |
| -- Mise à jour du champ «transmission» de la table «cel_images» à partir des données de «cel_obs» |
| UPDATE cel_images, cel_obs |
| SET cel_images.transmission = cel_obs.transmission |
| SET cel_images.transmission = cel_obs.transmission, |
| cel_images.date_transmission = cel_obs.date_transmission |
| WHERE cel_images.ce_observation = cel_obs.id_observation |
| AND (cel_images.ce_observation IS NOT NULL OR cel_images.ce_observation != 0); |
| |
| -- Suppression de la table cel_obs_image inutile |
| DROP TABLE cel_obs_images; |
| DROP TABLE cel_obs_images; |
| |
| -- ----------------------------------------------------- |
| SET SQL_MODE=@OLD_SQL_MODE; |
| SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; |
| SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; |