001 /** 002 * Copyright (c) 2000-2013 Liferay, Inc. All rights reserved. 003 * 004 * This library is free software; you can redistribute it and/or modify it under 005 * the terms of the GNU Lesser General Public License as published by the Free 006 * Software Foundation; either version 2.1 of the License, or (at your option) 007 * any later version. 008 * 009 * This library is distributed in the hope that it will be useful, but WITHOUT 010 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS 011 * FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more 012 * details. 013 */ 014 015 package com.liferay.portal.upgrade.v6_0_12_to_6_1_0; 016 017 import com.liferay.portal.kernel.upgrade.UpgradeProcess; 018 import com.liferay.portal.upgrade.v6_1_0.util.BlogsEntryTable; 019 020 import java.sql.SQLException; 021 022 /** 023 * @author Brian Wing Shun Chan 024 */ 025 public class UpgradeBlogs extends UpgradeProcess { 026 027 @Override 028 protected void doUpgrade() throws Exception { 029 try { 030 runSQL("alter_column_type BlogsEntry smallImageURL STRING null"); 031 } 032 catch (SQLException sqle) { 033 upgradeTable( 034 BlogsEntryTable.TABLE_NAME, BlogsEntryTable.TABLE_COLUMNS, 035 BlogsEntryTable.TABLE_SQL_CREATE, 036 BlogsEntryTable.TABLE_SQL_ADD_INDEXES); 037 } 038 } 039 040 }