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 id_ancien
VARCHAR(8) NOT NULL COMMENT 'Id unique de l''ancien',
8 Intitule_diplome
VARCHAR(60) collate utf8_general_ci
NOT NULL COMMENT 'Intitulé du diplôme',
9 Intitule_formation
VARCHAR(60) collate utf8_general_ci
NOT NULL COMMENT 'Intitulé de la formation',
10 Descr_formation
VARCHAR(60) collate utf8_general_ci
NOT NULL COMMENT 'Description de la formation',
11 tmp_1
VARCHAR(60) collate utf8_general_ci
NOT NULL,
12 tmp_2
VARCHAR(60) collate utf8_general_ci
NOT NULL,
13 tmp_3
VARCHAR(60) collate utf8_general_ci
NOT NULL,
14 tmp_4
VARCHAR(60) collate utf8_general_ci
NOT NULL,
15 PRIMARY KEY (id_ancien
, Intitule_diplome
, Intitule_formation
)
16 ) ENGINE
=MyISAM
DEFAULT CHARSET
=utf8
COLLATE=utf8_general_ci
;
18 LOAD DATA LOCAL INFILE
'Formations.txt'
19 INTO TABLE fusionax_formations
20 FIELDS TERMINATED
BY '\t' LINES TERMINATED
BY '\r\n' (FO
, id_ancien
, Intitule_diplome
, Intitule_formation
, Descr_formation
, tmp_1
, tmp_2
, tmp_3
, tmp_4
);