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.UpgradeTable;
019 import com.liferay.portal.kernel.upgrade.util.UpgradeTableFactoryUtil;
020 import com.liferay.portal.upgrade.v6_0_0.util.WikiPageResourceTable;
021 import com.liferay.portal.upgrade.v6_0_0.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 parentTitle varchar(255) null");
032 runSQL(
033 "alter_column_type WikiPage redirectTitle varchar(255) null");
034 }
035 catch (Exception e) {
036
037
038
039 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
040 WikiPageTable.TABLE_NAME, WikiPageTable.TABLE_COLUMNS);
041
042 upgradeTable.setCreateSQL(WikiPageTable.TABLE_SQL_CREATE);
043 upgradeTable.setIndexesSQL(WikiPageTable.TABLE_SQL_ADD_INDEXES);
044
045 upgradeTable.updateTable();
046 }
047
048 try {
049 runSQL(
050 "alter_column_type WikiPageResource title varchar(255) null");
051 }
052 catch (Exception e) {
053
054
055
056 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
057 WikiPageResourceTable.TABLE_NAME,
058 WikiPageResourceTable.TABLE_COLUMNS);
059
060 upgradeTable.setCreateSQL(WikiPageResourceTable.TABLE_SQL_CREATE);
061 upgradeTable.setIndexesSQL(
062 WikiPageResourceTable.TABLE_SQL_ADD_INDEXES);
063
064 upgradeTable.updateTable();
065 }
066 }
067
068 }