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.PortalUtil;
019 import com.liferay.portal.upgrade.v6_2_0.util.GroupTable;
020
021 import java.sql.SQLException;
022
023
026 public class UpgradeGroup extends UpgradeProcess {
027
028 @Override
029 protected void doUpgrade() throws Exception {
030 try {
031 runSQL("alter_column_type Group_ typeSettings TEXT null");
032 runSQL("alter_column_type Group_ friendlyURL VARCHAR(255) null");
033 }
034 catch (SQLException sqle) {
035 upgradeTable(
036 GroupTable.TABLE_NAME, GroupTable.TABLE_COLUMNS,
037 GroupTable.TABLE_SQL_CREATE, GroupTable.TABLE_SQL_ADD_INDEXES);
038 }
039
040 long classNameId = PortalUtil.getClassNameId(
041 "com.liferay.portal.model.Company");
042
043 runSQL(
044 "update Group_ set site = TRUE where classNameId = " + classNameId);
045 }
046
047 }