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.StringBundler;
019 import com.liferay.portal.model.User;
020 import com.liferay.portal.util.PortalUtil;
021
022
025 public class UpgradeUser extends UpgradeProcess {
026
027 @Override
028 protected void doUpgrade() throws Exception {
029 long classNameId = PortalUtil.getClassNameId(User.class);
030
031 runSQL("update Contact_ set classNameId = " + classNameId);
032
033 StringBundler sb = new StringBundler(4);
034
035 sb.append("update Contact_ set classPK = (select User_.userId from ");
036 sb.append("User_ where User_.contactId = Contact_.contactId), ");
037 sb.append("emailAddress = (select User_.emailAddress from User_ ");
038 sb.append("where User_.contactId = Contact_.contactId)");
039
040 runSQL(sb.toString());
041 }
042
043 }