001
014
015 package com.liferay.portal.upgrade.v6_0_0;
016
017 import com.liferay.portal.kernel.upgrade.UpgradeProcess;
018 import com.liferay.portal.kernel.upgrade.util.TempUpgradeColumnImpl;
019 import com.liferay.portal.kernel.upgrade.util.UpgradeColumn;
020 import com.liferay.portal.kernel.upgrade.util.UpgradeTable;
021 import com.liferay.portal.kernel.upgrade.util.UpgradeTableFactoryUtil;
022 import com.liferay.portal.upgrade.v5_1_0.util.BlogsEntryUrlTitleUpgradeColumnImpl;
023 import com.liferay.portal.upgrade.v6_0_0.util.BlogsEntryTable;
024
025
028 public class UpgradeBlogs extends UpgradeProcess {
029
030 @Override
031 protected void doUpgrade() throws Exception {
032 try {
033 runSQL("drop index IX_E0D90212 on BlogsEntry");
034 runSQL("drop index IX_DA53AFD4 on BlogsEntry");
035 runSQL("drop index IX_B88E740E on BlogsEntry");
036 runSQL("alter table BlogsEntry drop column draft");
037 }
038 catch (Exception e) {
039 }
040
041 UpgradeColumn entryIdColumn = new TempUpgradeColumnImpl("entryId");
042
043 UpgradeColumn titleColumn = new TempUpgradeColumnImpl("title");
044
045 UpgradeColumn urlTitleColumn = new BlogsEntryUrlTitleUpgradeColumnImpl(
046 entryIdColumn, titleColumn);
047
048 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
049 BlogsEntryTable.TABLE_NAME, BlogsEntryTable.TABLE_COLUMNS,
050 entryIdColumn, titleColumn, urlTitleColumn);
051
052 upgradeTable.updateTable();
053 }
054
055 }