From 9b66c719ecb619465770e0e2c9bff4f7b1c92946 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Fri, 18 Jun 2010 22:31:43 +0200 Subject: [PATCH] Ensures initial last and first names are not empty. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- upgrade/newdirectory-0.0.1/00_names.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/upgrade/newdirectory-0.0.1/00_names.sql b/upgrade/newdirectory-0.0.1/00_names.sql index 2e9858a..56686f4 100644 --- a/upgrade/newdirectory-0.0.1/00_names.sql +++ b/upgrade/newdirectory-0.0.1/00_names.sql @@ -85,6 +85,12 @@ INSERT INTO profile_name (pid, name, typeid) WHERE nom_ini != ''; INSERT INTO profile_name (pid, name, typeid) + SELECT u.user_id, u.nom, e.id + 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 #x4dat#.auth_user_md5 AS u INNER JOIN profile_name_enum AS e ON (e.name = 'Prénom') @@ -97,6 +103,12 @@ INSERT INTO profile_name (pid, name, typeid) WHERE prenom_ini != ''; INSERT INTO profile_name (pid, name, typeid) + SELECT u.user_id, u.prenom, e.id + 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 #x4dat#.auth_user_md5 AS u INNER JOIN profile_name_enum AS e ON (e.name = 'Nom usuel') -- 2.1.4