1
14
15 package com.liferay.portal.upgrade.v5_2_3;
16
17 import com.liferay.portal.kernel.upgrade.UpgradeProcess;
18 import com.liferay.portal.kernel.upgrade.util.UpgradeTable;
19 import com.liferay.portal.kernel.upgrade.util.UpgradeTableFactoryUtil;
20 import com.liferay.portal.kernel.util.StringBundler;
21 import com.liferay.portal.upgrade.v5_2_3.util.WikiPageTable;
22
23
28 public class UpgradeWiki extends UpgradeProcess {
29
30 protected void doUpgrade() throws Exception {
31 try {
32 runSQL("alter_column_type WikiPage title VARCHAR(255) null");
33 }
34 catch (Exception e) {
35
36
38 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
39 WikiPageTable.TABLE_NAME, WikiPageTable.TABLE_COLUMNS);
40
41 upgradeTable.setCreateSQL(WikiPageTable.TABLE_SQL_CREATE);
42
43 upgradeTable.updateTable();
44 }
45
46
48 updateGroupId();
49 }
50
51 protected void updateGroupId() throws Exception {
52 StringBundler sb = new StringBundler(2);
53
54 sb.append("update WikiPage set groupId = (select groupId from ");
55 sb.append("WikiNode where WikiNode.nodeId = WikiPage.nodeId)");
56
57 runSQL(sb.toString());
58 }
59
60 }