1
14
15 package com.liferay.portal.upgrade.v5_2_3;
16
17 import com.liferay.portal.kernel.upgrade.UpgradeProcess;
18 import com.liferay.portal.kernel.upgrade.util.UpgradeTable;
19 import com.liferay.portal.kernel.upgrade.util.UpgradeTableFactoryUtil;
20 import com.liferay.portal.kernel.util.StringBundler;
21 import com.liferay.portal.upgrade.v5_2_3.util.UserTable;
22
23
28 public class UpgradeUser extends UpgradeProcess {
29
30 protected void doUpgrade() throws Exception {
31 try {
32 runSQL("alter_column_type User_ greeting VARCHAR(255) null");
33 }
34 catch (Exception e) {
35
36
38 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
39 UserTable.TABLE_NAME, UserTable.TABLE_COLUMNS);
40
41 upgradeTable.setCreateSQL(UserTable.TABLE_SQL_CREATE);
42
43 upgradeTable.updateTable();
44 }
45
46 StringBundler sb = new StringBundler(9);
47
48 sb.append("update User_ set firstName = (select Contact_.firstName ");
49 sb.append("from Contact_ where Contact_.contactId = ");
50 sb.append("User_.contactId), middleName = (select ");
51 sb.append("Contact_.middleName from Contact_ where ");
52 sb.append("Contact_.contactId = User_.contactId), lastName = ");
53 sb.append("(select Contact_.lastName from Contact_ where ");
54 sb.append("Contact_.contactId = User_.contactId), jobTitle = (select ");
55 sb.append("Contact_.jobTitle from Contact_ where ");
56 sb.append("Contact_.contactId = User_.contactId)");
57
58 runSQL(sb.toString());
59 }
60
61 }