001
014
015 package com.liferay.portal.upgrade.v6_2_0;
016
017 import com.liferay.portal.kernel.upgrade.UpgradeProcess;
018 import com.liferay.portal.kernel.util.LoggingTimer;
019 import com.liferay.portal.kernel.util.PortalUtil;
020 import com.liferay.portal.kernel.util.StringBundler;
021
022
025 public class UpgradeUser extends UpgradeProcess {
026
027 @Override
028 protected void doUpgrade() throws Exception {
029 updateContact();
030 }
031
032 protected void updateContact() throws Exception {
033 try (LoggingTimer loggingTimer = new LoggingTimer()) {
034 long classNameId = PortalUtil.getClassNameId(
035 "com.liferay.portal.model.User");
036
037 runSQL("update Contact_ set classNameId = " + classNameId);
038
039 StringBundler sb = new StringBundler(4);
040
041 sb.append(
042 "update Contact_ set classPK = (select User_.userId from ");
043 sb.append("User_ where User_.contactId = Contact_.contactId), ");
044 sb.append("emailAddress = (select User_.emailAddress from User_ ");
045 sb.append("where User_.contactId = Contact_.contactId)");
046
047 runSQL(sb.toString());
048 }
049 }
050
051 }