1
14
15 package com.liferay.portal.upgrade.v6_0_0;
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.kernel.util.StringBundler;
21 import com.liferay.portal.upgrade.v6_0_0.util.ShoppingItemTable;
22
23
28 public class UpgradeShopping extends UpgradeProcess {
29
30 protected void doUpgrade() throws Exception {
31 StringBundler sb = new StringBundler(3);
32
33 sb.append("update ShoppingItem set groupId = (select groupId from ");
34 sb.append("ShoppingCategory where ShoppingCategory.categoryId = ");
35 sb.append("ShoppingItem.categoryId)");
36
37 runSQL(sb.toString());
38
39 try {
40 runSQL("alter_column_type ShoppingItem smallImageURL STRING null");
41 runSQL("alter_column_type ShoppingItem mediumImageURL STRING null");
42 runSQL("alter_column_type ShoppingItem largeImageURL STRING null");
43 }
44 catch (Exception e) {
45 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
46 ShoppingItemTable.TABLE_NAME, ShoppingItemTable.TABLE_COLUMNS);
47
48 upgradeTable.setCreateSQL(ShoppingItemTable.TABLE_SQL_CREATE);
49
50 upgradeTable.updateTable();
51 }
52 }
53
54 }