X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=sidebyside;f=upgrade%2Fmerge-0.0.1%2F02_ax_data.sql;h=1fc96e889aba218d7679e6b2f74a84f772870ea2;hb=0b37833b3b42f608fa0d5864f9d4b2518d9676ae;hp=3ebcc27271ac30e532c509c10d85da981add041b;hpb=b8ed94e96c3e69447bdec8d80dff82b0e8bc9ad0;p=platal.git

diff --git a/upgrade/merge-0.0.1/02_ax_data.sql b/upgrade/merge-0.0.1/02_ax_data.sql
index 3ebcc27..1fc96e8 100644
--- a/upgrade/merge-0.0.1/02_ax_data.sql
+++ b/upgrade/merge-0.0.1/02_ax_data.sql
@@ -1,6 +1,6 @@
 CREATE TABLE IF NOT EXISTS alumni_data (
   uid INT(11) NOT NULL,
-  matricule_ax INT(8) UNSIGNED NOT NULL,
+  matricule_ax CHAR(8) UNSIGNED NOT NULL,
   login_ax VARCHAR(15) NOT NULL,
   passwd_ax INT(11) UNSIGNED DEFAULT NULL,
   promo_type ENUM('', 'A', 'B', 'C', 'N', 'S') NOT NULL,
@@ -15,7 +15,7 @@ CREATE TABLE IF NOT EXISTS alumni_data (
 
 INSERT INTO  alumni_data (uid, matricule_ax, login_ax, passwd_ax, promo_type, membership_type,
              salutation, last_dues_paid_year, represents, checked)
-     SELECT  u.user_id, CONVERT(u.matricule_ax, UNSIGNED), f.Login, f.Password, f.Groupe_promo,
+     SELECT  u.user_id, u.matricule_ax, f.Login, f.Password, f.Groupe_promo,
              f.Type_membre, f.Civilite, f.annee_dernCot, f.Representant, 0
        FROM  fusionax_anciens AS f
  INNER JOIN  auth_user_md5    AS u ON (f.id_ancien = u.matricule_ax);