001
014
015 package com.liferay.portal.upgrade.v6_1_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.upgrade.v6_1_0.util.BlogsEntryTable;
021
022
026 public class UpgradeBlogs extends UpgradeProcess {
027
028 @Override
029 protected void doUpgrade() throws Exception {
030 try {
031 runSQL("drop index IX_E0D90212 on BlogsEntry");
032 runSQL("drop index IX_DA53AFD4 on BlogsEntry");
033 runSQL("drop index IX_B88E740E on BlogsEntry");
034 runSQL("alter table BlogsEntry drop column draft");
035 }
036 catch (Exception e) {
037 }
038
039 try {
040 runSQL("alter_column_type BlogsEntry smallImageURL STRING null");
041 }
042 catch (Exception e) {
043 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
044 BlogsEntryTable.TABLE_NAME, BlogsEntryTable.TABLE_COLUMNS);
045
046 upgradeTable.updateTable();
047 }
048 }
049
050 }