| 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; |