1 -- Import complet des formations
3 DROP TABLE IF EXISTS `fusionax_formations_md`
;
5 CREATE TABLE IF NOT EXISTS `fusionax_formations_md`
(
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 field
VARCHAR(255) DEFAULT NULL COMMENT 'Domaine de la formation',
9 pid
INT(11) UNSIGNED
DEFAULT NULL,
10 fieldid
INT(2) DEFAULT NULL,
14 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
16 LOAD DATA LOCAL INFILE
'{?}Formations.txt' INTO TABLE fusionax_formations_md
CHARACTER SET utf8 FIELDS TERMINATED
BY '\t' LINES TERMINATED
BY '\n'
19 UPDATE fusionax_formations_md
SET field
= TRIM(field
);
20 UPDATE fusionax_formations_md
AS f
21 INNER JOIN profile_education_field_enum
AS e
ON (f.field
= e.field
)
22 SET f.fieldid
= e.
id, f.field
= NULL;