001
014
015 package com.liferay.portal.upgrade.v7_0_0;
016
017 import com.liferay.portal.kernel.upgrade.UpgradeProcess;
018 import com.liferay.portal.upgrade.v7_0_0.util.ExpandoColumnTable;
019 import com.liferay.portal.upgrade.v7_0_0.util.ExpandoValueTable;
020
021 import java.sql.SQLException;
022
023
026 public class UpgradeExpando extends UpgradeProcess {
027
028 @Override
029 protected void doUpgrade() throws Exception {
030 try {
031 runSQL("alter_column_type ExpandoColumn defaultData TEXT null");
032 }
033 catch (SQLException sqle) {
034 upgradeTable(
035 ExpandoColumnTable.TABLE_NAME, ExpandoColumnTable.TABLE_COLUMNS,
036 ExpandoColumnTable.TABLE_SQL_CREATE,
037 ExpandoColumnTable.TABLE_SQL_ADD_INDEXES);
038 }
039
040 try {
041 runSQL("alter_column_type ExpandoValue data_ TEXT null");
042 }
043 catch (SQLException sqle) {
044 upgradeTable(
045 ExpandoValueTable.TABLE_NAME, ExpandoValueTable.TABLE_COLUMNS,
046 ExpandoValueTable.TABLE_SQL_CREATE,
047 ExpandoValueTable.TABLE_SQL_ADD_INDEXES);
048 }
049 }
050
051 }