Commit | Line | Data |
---|---|---|
0efb08e6 SJ |
1 | -- Import complet des formations |
2 | ||
3 | DROP TABLE IF EXISTS `fusionax_formations_md`; | |
4 | ||
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, | |
11 | PRIMARY KEY (ax_id), | |
12 | INDEX (pid), | |
13 | INDEX (fieldid) | |
14 | ) ENGINE=InnoDB, CHARSET=utf8; | |
15 | ||
16 | LOAD DATA LOCAL INFILE '{?}Formations.txt' INTO TABLE fusionax_formations_md CHARACTER SET utf8 FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' | |
17 | (FO, ax_id, field); | |
18 | ||
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; |