Subversion Repositories eFlore/Applications.cel

Rev

Rev 2466 | Rev 2473 | Go to most recent revision | Only display areas with differences | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2466 Rev 2467
1 
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
 1 
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2 
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
 2 
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3 
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
 3 
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
- 
 
 4 
 
- 
 
 5 
SET GLOBAL SQL_MODE = 'NO_ENGINE_SUBSTITUTION,ALLOW_INVALID_DATES';
4 
 
 6 
 
5 
-- Supprime le champ «publiable_eflore»
 7 
-- Supprime le champ «publiable_eflore»
6 
ALTER TABLE `cel_images` DROP `publiable_eflore` ;
 8 
ALTER TABLE `cel_images` DROP `publiable_eflore` ;
7 
 
 9 
 
8 
-- Ajoute le champ «transmission»  dans «cel_images»
 10 
-- Ajoute le champ «transmission»  dans «cel_images»
9 
ALTER TABLE `cel_images` ADD `transmission` TINYINT(1) NOT NULL DEFAULT '1' AFTER `meta_autres`;
 11 
ALTER TABLE `cel_images` ADD `transmission` TINYINT(1) NOT NULL DEFAULT '1' AFTER `meta_autres`;
10 
 
 12 
 
11 
-- Ajoute le champ «date_liaison» dans «cel_images»
 13 
-- Ajoute le champ «date_liaison» dans «cel_images»
12 
ALTER TABLE `cel_images` ADD `date_liaison` DATETIME NOT NULL AFTER `date_creation`;
 14 
ALTER TABLE `cel_images` ADD `date_liaison` DATETIME NOT NULL AFTER `date_creation`;
13 
 
 15 
 
14 
-- Ajoute le champ «date_transmission» dans «cel_images»
 16 
-- Ajoute le champ «date_transmission» dans «cel_images»
15 
ALTER TABLE `cel_images` ADD `date_transmission` DATETIME NULL AFTER `date_liaison`;
 17 
ALTER TABLE `cel_images` ADD `date_transmission` DATETIME NULL AFTER `date_liaison`;
16 
 
 18 
 
17 
-- Ajoute le champ «ce_observation» dans «cel_images»
 19 
-- Ajoute le champ «ce_observation» dans «cel_images»
18 
ALTER TABLE `cel_images` ADD `ce_observation` BIGINT NULL AFTER `id_image`;
 20 
ALTER TABLE `cel_images` ADD `ce_observation` BIGINT NULL AFTER `id_image`;
19 
 
 21 
 
20 
-- Met à jour la table cel_image avec les données de cel_obs_images
 22 
-- Met à jour la table cel_image avec les données de cel_obs_images
21 
START TRANSACTION;
 23 
START TRANSACTION;
22 
UPDATE cel_images, cel_obs_images
24 
UPDATE cel_images, cel_obs_images
23 
SET cel_images.ce_observation = cel_obs_images.id_observation,
25 
SET cel_images.ce_observation = cel_obs_images.id_observation,
24 
	cel_images.date_liaison = cel_obs_images.date_liaison
26 
	cel_images.date_liaison = cel_obs_images.date_liaison
25 
WHERE  cel_images.id_image = cel_obs_images.id_image
27 
WHERE  cel_images.id_image = cel_obs_images.id_image
26 
AND cel_obs_images.id_image != '0';
 28 
AND cel_obs_images.id_image != '0';
27 
COMMIT;
 29 
COMMIT;
28 
 
 30 
 
29 
-- Ajout index sur ce_observation
 31 
-- Ajout index sur ce_observation
30 
CREATE INDEX ce_observation ON cel_images (ce_observation);
 32 
CREATE INDEX ce_observation ON cel_images (ce_observation);
31 
 
 33 
 
32 
-- Mise à jour du champ «transmission» de la table «cel_images» à partir des données de «cel_obs»
 34 
-- Mise à jour du champ «transmission» de la table «cel_images» à partir des données de «cel_obs»
33 
START TRANSACTION;
 35 
START TRANSACTION;
34 
UPDATE cel_images, cel_obs
36 
UPDATE cel_images, cel_obs
35 
SET cel_images.transmission = cel_obs.transmission,
37 
SET cel_images.transmission = cel_obs.transmission,
36 
	cel_images.date_transmission = cel_obs.date_transmission
38 
	cel_images.date_transmission = cel_obs.date_transmission
37 
WHERE  cel_images.ce_observation = cel_obs.id_observation
39 
WHERE  cel_images.ce_observation = cel_obs.id_observation
38 
AND (cel_images.ce_observation IS NOT NULL OR cel_images.ce_observation != 0);
 40 
AND (cel_images.ce_observation IS NOT NULL OR cel_images.ce_observation != 0);
39 
COMMIT;
 41 
COMMIT;
40 
 
 42 
 
41 
-- Suppression de la table cel_obs_image inutile
 43 
-- Suppression de la table cel_obs_image inutile
42 
RENAME TABLE cel_obs_images TO cel_obs_images_obsolete;
 44 
RENAME TABLE cel_obs_images TO cel_obs_images_obsolete;
43 
 
 45 
 
44 
-- -----------------------------------------------------
 46 
-- -----------------------------------------------------
45 
SET SQL_MODE=@OLD_SQL_MODE;
 47 
SET SQL_MODE=@OLD_SQL_MODE;
46 
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
 48 
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
47 
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
 49 
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;