X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fnewdirectory-0.0.1%2F00_names.sql;h=39d1b1d28c7a37d30ee0b544459b8b53f860bfad;hb=9d5e108738768e57f6d445fbdf433b94afc419f2;hp=6260e327a1a51f288f515990e96046b44b3fd4dc;hpb=ee71865181e96e7b0754ef9e7da4b3cb26f4c1d7;p=platal.git

diff --git a/upgrade/newdirectory-0.0.1/00_names.sql b/upgrade/newdirectory-0.0.1/00_names.sql
index 6260e32..39d1b1d 100644
--- a/upgrade/newdirectory-0.0.1/00_names.sql
+++ b/upgrade/newdirectory-0.0.1/00_names.sql
@@ -20,8 +20,8 @@ INSERT INTO  profile_display (pid, yourself, public_name, private_name, director
              CONCAT(IF(u.nom_usage != '', CONCAT(u.nom_usage, ' (', u.nom, ')') , u.nom), ' ', u.prenom),
              CONCAT(u.prenom, ' ', IF(u.nom_usage != '', u.nom_usage, u.nom)),
              CONCAT(IF(u.nom_usage != '', u.nom_usage, u.nom), ' ', u.prenom)
-       FROM  auth_user_md5   AS u
-  LEFT JOIN  auth_user_quick AS q ON (u.user_id = q.user_id);
+       FROM  #x4dat#.auth_user_md5   AS u
+  LEFT JOIN  #x4dat#.auth_user_quick AS q ON (u.user_id = q.user_id);
 
 
 DROP TABLE IF EXISTS profile_name_enum;
@@ -73,37 +73,37 @@ CREATE TABLE IF NOT EXISTS profile_name (
 
 INSERT INTO  profile_name (pid, name, typeid)
      SELECT  u.user_id, u.nom, e.id
-       FROM  auth_user_md5     AS u
+       FROM  #x4dat#.auth_user_md5     AS u
  INNER JOIN  profile_name_enum AS e ON (e.name = 'Nom patronymique')
       WHERE  nom != '';
 
 INSERT INTO  profile_name (pid, name, typeid)
      SELECT  u.user_id, u.nom_ini, e.id
-       FROM  auth_user_md5     AS u
+       FROM  #x4dat#.auth_user_md5     AS u
  INNER JOIN  profile_name_enum AS e ON (e.name = 'Nom initial')
       WHERE  nom_ini != '';
 
 INSERT INTO  profile_name (pid, name, typeid)
      SELECT  u.user_id, u.prenom, e.id
-       FROM  auth_user_md5     AS u
+       FROM  #x4dat#.auth_user_md5     AS u
  INNER JOIN  profile_name_enum AS e ON (e.name = 'Prénom')
       WHERE  prenom != '';
 
 INSERT INTO  profile_name (pid, name, typeid)
      SELECT  u.user_id, u.prenom_ini, e.id
-       FROM  auth_user_md5     AS u
+       FROM  #x4dat#.auth_user_md5     AS u
  INNER JOIN  profile_name_enum AS e ON (e.name = 'Prénom initial')
       WHERE  prenom_ini != '';
 
 INSERT INTO  profile_name (pid, name, typeid)
      SELECT  u.user_id, u.nom_usage, e.id
-       FROM  auth_user_md5     AS u
+       FROM  #x4dat#.auth_user_md5     AS u
  INNER JOIN  profile_name_enum AS e ON (e.name = 'Nom usuel')
       WHERE  nom_usage != '';
 
 INSERT INTO  profile_name (pid, name, typeid)
      SELECT  q.user_id, q.profile_nick, e.id
-       FROM  auth_user_quick   AS q
+       FROM  #x4dat#.auth_user_quick   AS q
  INNER JOIN  profile_name_enum AS e ON (e.name = 'Surnom')
       WHERE  profile_nick != '';