1
14
15 package com.liferay.portal.upgrade.v5_1_5;
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.upgrade.v5_1_5.util.WikiPageTable;
21
22
27 public class UpgradeWiki extends UpgradeProcess {
28
29 protected void doUpgrade() throws Exception {
30 try {
31 runSQL("alter_column_type WikiPage title VARCHAR(255) null");
32 }
33 catch (Exception e) {
34
35
37 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
38 WikiPageTable.TABLE_NAME, WikiPageTable.TABLE_COLUMNS);
39
40 upgradeTable.setCreateSQL(WikiPageTable.TABLE_SQL_CREATE);
41
42 upgradeTable.updateTable();
43 }
44
45
47 updateGroupId();
48 }
49
50 protected void updateGroupId() throws Exception {
51 StringBuilder sb = new StringBuilder();
52
53 sb.append("update WikiPage set groupId = (select groupId from ");
54 sb.append("WikiNode where WikiNode.nodeId = WikiPage.nodeId)");
55
56 runSQL(sb.toString());
57 }
58
59 }