upgrade/merge-0.0.1/03_corps.sql

   1 INSERT IGNORE INTO  profile_corps (uid, original_corpsid, current_corpsid, rankid, corps_pub)
   2             SELECT  u.user_id, c.id, c.id, r.id, 'ax'
   3               FROM  auth_user_md5           AS u
   4         INNER JOIN  fusionax_anciens        AS f ON (u.matricule_ax = f.id_ancien)
   5         INNER JOIN  profile_corps_enum      AS c ON (f.corps_sortie = c.abbreviation)
   6         INNER JOIN  profile_corps_rank_enum AS r ON (f.grade = r.abbreviation);
   7
   8     UPDATE  profile_corps      AS c
   9 INNER JOIN  profile_corps_enum AS e ON (c.original_corpsid = e.id)
  10  LEFT JOIN  profile_corps_enum AS a ON (a.name = "Aucun (anc. démissionnaire)")
  11        SET  c.original_corpsid = a.id
  12      WHERE  e.name = "Ancien élève étranger";
  13
  14 UPDATE  profile_corps_enum
  15    SET  name = "Aucun"
  16  WHERE  name = "Aucun (anc. démissionnaire)";
  17
  18 DELETE FROM  profile_corps_enum
  19       WHERE  name = "Ancien élève étranger";
  20
  21 --  vim:set syntax=mysql: