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.upgrade.util.UpgradeTable;
019 import com.liferay.portal.kernel.upgrade.util.UpgradeTableFactoryUtil;
020 import com.liferay.portal.kernel.util.StringBundler;
021 import com.liferay.portal.upgrade.v6_0_0.util.ShoppingItemTable;
022
023
026 public class UpgradeShopping extends UpgradeProcess {
027
028 protected void doUpgrade() throws Exception {
029 StringBundler sb = new StringBundler(3);
030
031 sb.append("update ShoppingItem set groupId = (select groupId from ");
032 sb.append("ShoppingCategory where ShoppingCategory.categoryId = ");
033 sb.append("ShoppingItem.categoryId)");
034
035 runSQL(sb.toString());
036
037 try {
038 runSQL("alter_column_type ShoppingItem smallImageURL STRING null");
039 runSQL("alter_column_type ShoppingItem mediumImageURL STRING null");
040 runSQL("alter_column_type ShoppingItem largeImageURL STRING null");
041 }
042 catch (Exception e) {
043 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
044 ShoppingItemTable.TABLE_NAME, ShoppingItemTable.TABLE_COLUMNS);
045
046 upgradeTable.setCreateSQL(ShoppingItemTable.TABLE_SQL_CREATE);
047
048 upgradeTable.updateTable();
049 }
050 }
051
052 }