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
CHAR(60) NOT NULL DEFAULT 0 COMMENT 'Intitulé du diplôme',
9 Intitule_formation
CHAR(60) NOT NULL DEFAULT 0 COMMENT 'Intitulé de la formation',
10 Descr_formation
CHAR(60) NOT NULL COMMENT 'Description de la formation',
11 eduid
INT(4) DEFAULT NULL,
12 degreeid
INT(4) DEFAULT NULL,
13 fieldid
INT(2) DEFAULT NULL,
14 PRIMARY KEY (ax_id
, Intitule_diplome
, Intitule_formation
, Descr_formation
),
15 INDEX (Intitule_diplome
),
16 INDEX (Intitule_formation
),
17 INDEX (Descr_formation
)
18 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
20 LOAD DATA LOCAL INFILE
'{?}Formations.txt' INTO TABLE fusionax_formations FIELDS TERMINATED
BY '\t' LINES TERMINATED
BY '\n'
21 (FO
, ax_id
, Intitule_diplome
, Intitule_formation
, Descr_formation
);