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