001
014
015 package com.liferay.portal.upgrade.v5_2_3;
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.kernel.util.StringBundler;
021 import com.liferay.portal.upgrade.v5_2_3.util.WikiPageTable;
022
023
026 public class UpgradeWiki extends UpgradeProcess {
027
028 @Override
029 protected void doUpgrade() throws Exception {
030 try {
031 runSQL("alter_column_type WikiPage title VARCHAR(255) null");
032 }
033 catch (Exception e) {
034
035
036
037 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
038 WikiPageTable.TABLE_NAME, WikiPageTable.TABLE_COLUMNS);
039
040 upgradeTable.setCreateSQL(WikiPageTable.TABLE_SQL_CREATE);
041 upgradeTable.setIndexesSQL(WikiPageTable.TABLE_SQL_ADD_INDEXES);
042
043 upgradeTable.updateTable();
044 }
045
046
047
048 updateGroupId();
049 }
050
051 protected void updateGroupId() throws Exception {
052 StringBundler sb = new StringBundler(2);
053
054 sb.append("update WikiPage set groupId = (select groupId from ");
055 sb.append("WikiNode where WikiNode.nodeId = WikiPage.nodeId)");
056
057 runSQL(sb.toString());
058 }
059
060 }