X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fmerge-0.0.1%2F01_emails.sql;h=55de747a6a3dfcf6d55a6b3317418a1aefded3b2;hb=843a2191e4c76f0beb00c754f06974de76791238;hp=30c9ba4a9f4dd44cc18c393a2ff12f5487553650;hpb=32d8754be017db3aa656812fca2a92704ebe29ae;p=platal.git

diff --git a/upgrade/merge-0.0.1/01_emails.sql b/upgrade/merge-0.0.1/01_emails.sql
index 30c9ba4..55de747 100644
--- a/upgrade/merge-0.0.1/01_emails.sql
+++ b/upgrade/merge-0.0.1/01_emails.sql
@@ -1,13 +1,13 @@
 INSERT INTO  profile_directory (uid, email_directory)
      SELECT  user_id, Mel_usage
        FROM  fusionax_anciens AS ax
- INNER JOIN  auth_user_md5    AS u ON (ax.id_ancien = CONVERT(u.matricule_ax, BINARY))
+ INNER JOIN  auth_user_md5    AS u ON (ax.id_ancien = u.matricule_ax)
       WHERE  Mel_publiable != '0' AND Mel_usage != '';
 
 INSERT IGNORE INTO  register_marketing (uid, email, type)
             SELECT  user_id, Mel_usage, 'ax'
               FROM  fusionax_anciens AS ax
-        INNER JOIN  auth_user_md5    AS u ON (ax.id_ancien = CONVERT(u.matricule_ax, BINARY))
+        INNER JOIN  auth_user_md5    AS u ON (ax.id_ancien = u.matricule_ax)
          LEFT JOIN  emails           AS e ON (e.uid = u.user_id AND e.flags = 'active')
              WHERE  Mel_usage != '' AND
                     Mel_usage NOT LIKE '%@polytechnique.edu' AND