001
014
015 package com.liferay.portal.upgrade.v5_2_3;
016
017 import com.liferay.portal.kernel.upgrade.UpgradeProcess;
018 import com.liferay.portal.kernel.upgrade.util.UpgradeTable;
019 import com.liferay.portal.kernel.upgrade.util.UpgradeTableFactoryUtil;
020 import com.liferay.portal.kernel.util.StringBundler;
021 import com.liferay.portal.upgrade.v5_2_3.util.UserTable;
022
023
026 public class UpgradeUser extends UpgradeProcess {
027
028 protected void doUpgrade() throws Exception {
029 try {
030 runSQL("alter_column_type User_ greeting VARCHAR(255) null");
031 }
032 catch (Exception e) {
033
034
035
036 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
037 UserTable.TABLE_NAME, UserTable.TABLE_COLUMNS);
038
039 upgradeTable.setCreateSQL(UserTable.TABLE_SQL_CREATE);
040
041 upgradeTable.updateTable();
042 }
043
044 StringBundler sb = new StringBundler(9);
045
046 sb.append("update User_ set firstName = (select Contact_.firstName ");
047 sb.append("from Contact_ where Contact_.contactId = ");
048 sb.append("User_.contactId), middleName = (select ");
049 sb.append("Contact_.middleName from Contact_ where ");
050 sb.append("Contact_.contactId = User_.contactId), lastName = ");
051 sb.append("(select Contact_.lastName from Contact_ where ");
052 sb.append("Contact_.contactId = User_.contactId), jobTitle = (select ");
053 sb.append("Contact_.jobTitle from Contact_ where ");
054 sb.append("Contact_.contactId = User_.contactId)");
055
056 runSQL(sb.toString());
057 }
058
059 }