1
14
15 package com.liferay.portal.upgrade.v5_2_8;
16
17 import com.liferay.portal.kernel.upgrade.UpgradeProcess;
18 import com.liferay.portal.kernel.upgrade.util.UpgradeTable;
19 import com.liferay.portal.kernel.upgrade.util.UpgradeTableFactoryUtil;
20 import com.liferay.portal.upgrade.v5_2_8.util.ShoppingItemTable;
21
22
27 public class UpgradeShopping extends UpgradeProcess {
28
29 protected void doUpgrade() throws Exception {
30 try {
31 runSQL("alter_column_type ShoppingItem smallImageURL STRING null");
32 runSQL("alter_column_type ShoppingItem mediumImageURL STRING null");
33 runSQL("alter_column_type ShoppingItem largeImageURL STRING null");
34 }
35 catch (Exception e) {
36 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
37 ShoppingItemTable.TABLE_NAME, ShoppingItemTable.TABLE_COLUMNS);
38
39 upgradeTable.setCreateSQL(ShoppingItemTable.TABLE_SQL_CREATE);
40
41 upgradeTable.updateTable();
42 }
43 }
44
45 }