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.util.StringBundler;
019 import com.liferay.portal.upgrade.v5_2_3.util.WikiPageTable;
020
021 import java.sql.SQLException;
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 (SQLException sqle) {
034
035
036
037 upgradeTable(
038 WikiPageTable.TABLE_NAME, WikiPageTable.TABLE_COLUMNS,
039 WikiPageTable.TABLE_SQL_CREATE,
040 WikiPageTable.TABLE_SQL_ADD_INDEXES);
041 }
042
043
044
045 updateGroupId();
046 }
047
048 protected void updateGroupId() throws Exception {
049 StringBundler sb = new StringBundler(2);
050
051 sb.append("update WikiPage set groupId = (select groupId from ");
052 sb.append("WikiNode where WikiNode.nodeId = WikiPage.nodeId)");
053
054 runSQL(sb.toString());
055 }
056
057 }