Adds title to profiles.

[platal.git] / upgrade / 1.0.1 / merge.php

diff --git a/upgrade/1.0.1/merge.php b/upgrade/1.0.1/merge.php
index 19f82a7..e41905f 100755 (executable)
--- a/upgrade/1.0.1/merge.php
+++ b/upgrade/1.0.1/merge.php
@@ -184,6 +184,11 @@ XDB::rawExecute("UPDATE  profile_corps           AS c
 XDB::rawExecute("DELETE FROM  profile_corps_rank_enum
                        WHERE  name LIKE 'DEL%'");
 
+// Updates title.
+XDB::rawExecute("UPDATE  profiles         AS p
+             INNER JOIN  fusionax_anciens AS f ON (p.pid = f.pid)
+                    SET  p.title = f.Civilite");
+
 // Updates email_directory.
 XDB::rawExecute("UPDATE  profiles         AS p
              INNER JOIN  fusionax_anciens AS f ON (p.pid = f.pid)