1 -- Import complet des formations
3 DROP TABLE IF EXISTS `fusionax_formations`
;
5 CREATE TABLE IF NOT EXISTS `fusionax_formations`
(
6 FO
CHAR(2) NOT NULL COMMENT 'Vaut toujours FO pour cette table',
7 ax_id
VARCHAR(8) NOT NULL COMMENT 'Id unique de l''ancien',
8 Intitule_diplome
VARCHAR(255) NOT NULL DEFAULT 0 COMMENT 'Intitulé du diplôme',
9 Intitule_formation
VARCHAR(255) NOT NULL DEFAULT 0 COMMENT 'Intitulé de la formation',
10 Descr_formation
VARCHAR(255) NOT NULL COMMENT 'Description de la formation',
11 pid
INT(11) UNSIGNED
DEFAULT NULL,
12 eduid
INT(4) DEFAULT NULL,
13 degreeid
INT(4) DEFAULT NULL,
14 fieldid
INT(2) DEFAULT NULL,
15 PRIMARY KEY (ax_id
, Intitule_diplome
, Intitule_formation
, Descr_formation
),
16 INDEX (Intitule_diplome(60)),
17 INDEX (Intitule_formation(60)),
18 INDEX (Descr_formation(60)),
23 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
25 LOAD DATA LOCAL INFILE
'{?}Formations.txt' INTO TABLE fusionax_formations
CHARACTER SET utf8 FIELDS TERMINATED
BY '\t' LINES TERMINATED
BY '\n'
26 (FO
, ax_id
, Intitule_diplome
, Intitule_formation
, Descr_formation
);
28 UPDATE fusionax_formations
AS f
29 INNER JOIN profile_education_enum
AS e
ON (f.Intitule_diplome
= e.abbreviation
)
30 SET f.Intitule_diplome
= e.
name
31 WHERE f.Intitule_diplome
!= '';