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.util.LoggingTimer;
019 import com.liferay.portal.upgrade.v6_1_0.util.BlogsEntryTable;
020
021
025 public class UpgradeBlogs extends UpgradeProcess {
026
027 protected void alterTable() throws Exception {
028 try (LoggingTimer loggingTimer = new LoggingTimer()) {
029 runSQL("alter table BlogsEntry drop column draft");
030
031 alter(
032 BlogsEntryTable.class,
033 new AlterColumnType("smallImageURL", "STRING null"));
034 }
035 catch (Exception e) {
036 }
037 }
038
039 @Override
040 protected void doUpgrade() throws Exception {
041 dropIndexes();
042
043 alterTable();
044 }
045
046 protected void dropIndexes() {
047 try (LoggingTimer loggingTimer = new LoggingTimer()) {
048 runSQL("drop index IX_E0D90212 on BlogsEntry");
049 runSQL("drop index IX_DA53AFD4 on BlogsEntry");
050 runSQL("drop index IX_B88E740E on BlogsEntry");
051 }
052 catch (Exception e) {
053 }
054 }
055
056 }