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 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
),
17 INDEX (Intitule_formation
),
18 INDEX (Descr_formation
),
23 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
25 LOAD DATA LOCAL INFILE
'{?}Formations.txt' INTO TABLE fusionax_formations FIELDS TERMINATED
BY '\t' LINES TERMINATED
BY '\n'
26 (FO
, ax_id
, Intitule_diplome
, Intitule_formation
, Descr_formation
);