From 3e9bc1e315b9cf9224625cbd8aa38f41fb526374 Mon Sep 17 00:00:00 2001 From: x2000habouzit Date: Thu, 4 Nov 2004 15:20:48 +0000 Subject: [PATCH] ... --- scripts/migration/0.9.2/del_identification.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/scripts/migration/0.9.2/del_identification.sql b/scripts/migration/0.9.2/del_identification.sql index b12ceb4..9df7b40 100644 --- a/scripts/migration/0.9.2/del_identification.sql +++ b/scripts/migration/0.9.2/del_identification.sql @@ -12,3 +12,5 @@ ALTER TABLE auth_user_md5 ADD COLUMN deces date NOT NULL AFTER flags; UPDATE auth_user_md5 AS a INNER JOIN identification AS i ON (a.matricule = i.matricule) SET a.matricule_ax = i.matricule_ax, a.nom_ini = i.nom, a.prenom_ini = i.prenom, a.nom_ini_soundex = i.nom_soundex, a.prenom_ini_soundex = i.prenom_soundex, a.comment = i.comment, a.appli = i.appli, a.flags = i.flags, a.last_known_email = i.last_known_email, a.deces = i.deces; INSERT INTO auth_user_md5 (matricule, matricule_ax, promo, nom, prenom, nom_ini, prenom_ini, nom_ini_soundex, prenom_ini_soundex, comment, appli, flags, last_known_email, deces, perms) SELECT i.matricule, i.matricule_ax, i.promo, i.nom, i.prenom, i.nom, i.prenom, i.nom_soundex, i.prenom_soundex, i.comment, i.appli, i.flags, i.last_known_email, i.deces, 'non-inscrit' FROM identification AS i LEFT JOIN auth_user_md5 AS a ON a.matricule = i.matricule WHERE a.user_id IS NULL; DROP TABLE identification; + +alter table auth_user_md5 add index (epouse); -- 2.1.4