001
014
015 package com.liferay.portal.upgrade.v6_0_0;
016
017 import com.liferay.portal.kernel.upgrade.UpgradeProcess;
018 import com.liferay.portal.kernel.util.StringBundler;
019 import com.liferay.portal.upgrade.v6_0_0.util.ShoppingItemTable;
020
021 import java.sql.SQLException;
022
023
026 public class UpgradeShopping extends UpgradeProcess {
027
028 @Override
029 protected void doUpgrade() throws Exception {
030 StringBundler sb = new StringBundler(3);
031
032 sb.append("update ShoppingItem set groupId = (select groupId from ");
033 sb.append("ShoppingCategory where ShoppingCategory.categoryId = ");
034 sb.append("ShoppingItem.categoryId)");
035
036 runSQL(sb.toString());
037
038 try {
039 runSQL("alter_column_type ShoppingItem smallImageURL STRING null");
040 runSQL("alter_column_type ShoppingItem mediumImageURL STRING null");
041 runSQL("alter_column_type ShoppingItem largeImageURL STRING null");
042 }
043 catch (SQLException sqle) {
044 upgradeTable(
045 ShoppingItemTable.TABLE_NAME, ShoppingItemTable.TABLE_COLUMNS,
046 ShoppingItemTable.TABLE_SQL_CREATE,
047 ShoppingItemTable.TABLE_SQL_ADD_INDEXES);
048 }
049 }
050
051 }