| UpgradeShopping.java |
1 /**
2 * Copyright (c) 2000-2010 Liferay, Inc. All rights reserved.
3 *
4 * This library is free software; you can redistribute it and/or modify it under
5 * the terms of the GNU Lesser General Public License as published by the Free
6 * Software Foundation; either version 2.1 of the License, or (at your option)
7 * any later version.
8 *
9 * This library is distributed in the hope that it will be useful, but WITHOUT
10 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
11 * FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
12 * details.
13 */
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 /**
23 * <a href="UpgradeShopping.java.html"><b><i>View Source</i></b></a>
24 *
25 * @author Alexander Chow
26 */
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 }