modules/fusionax/Formations.sql

   1 -- Import complet des formations
   2
   3 DROP TABLE IF EXISTS `fusionax_formations`;
   4
   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),
  19   INDEX (pid),
  20   INDEX (eduid),
  21   INDEX (degreeid),
  22   INDEX (fieldid)
  23 ) ENGINE=InnoDB, CHARSET=utf8;
  24
  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);