From 7b3a37af2fce8b8090fb4d891c81aef70cdedbde Mon Sep 17 00:00:00 2001
From: =?utf8?q?St=C3=A9phane=20Jacob?= <sj@m4x.org>
Date: Thu, 21 Jul 2011 09:15:51 +0200
Subject: [PATCH] Fixes errors in accounts names.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

Signed-off-by: Stéphane Jacob <sj@m4x.org>
---
 upgrade/1.1.3/02_names.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100644 upgrade/1.1.3/02_names.sql

diff --git a/upgrade/1.1.3/02_names.sql b/upgrade/1.1.3/02_names.sql
new file mode 100644
index 0000000..b8b452a
--- /dev/null
+++ b/upgrade/1.1.3/02_names.sql
@@ -0,0 +1,12 @@
+UPDATE  profile_public_names
+   SET  lastname_main = REPLACE(lastname_main, '  ', ' ')
+ WHERE  lastname_main LIKE '%  %';
+
+    UPDATE  accounts             AS a
+INNER JOIN  account_profiles     AS ap  ON (ap.uid = a.uid AND FIND_IN_SET('owner', ap.perms))
+INNER JOIN  profile_public_names AS ppn ON (ppn.pid = ap.pid)
+INNER JOIN  profile_display      AS pd  ON (pd.pid = ap.pid)
+       SET  a.lastname = IF(ppn.lastname_ordinary = '', ppn.lastname_main, ppn.lastname_ordinary)
+     WHERE  a.type IN ('x', 'master', 'phd');
+
+-- vim:set syntax=mysql:
-- 
2.1.4