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.BookmarksEntryTable;
21
22
27 public class UpgradeBookmarks extends UpgradeProcess {
28
29 protected void doUpgrade() throws Exception {
30 try {
31 runSQL("alter_column_type BookmarksEntry name VARCHAR(255) null");
32 }
33 catch (Exception e) {
34
35
37 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
38 BookmarksEntryTable.TABLE_NAME,
39 BookmarksEntryTable.TABLE_COLUMNS);
40
41 upgradeTable.setCreateSQL(BookmarksEntryTable.TABLE_SQL_CREATE);
42
43 upgradeTable.updateTable();
44 }
45
46
48 updateGroupId();
49 }
50
51 protected void updateGroupId() throws Exception {
52 StringBuilder sb = new StringBuilder();
53
54 sb.append("update BookmarksEntry set groupId = (select groupId from ");
55 sb.append("BookmarksFolder where BookmarksFolder.folderId = ");
56 sb.append("BookmarksEntry.folderId)");
57
58 runSQL(sb.toString());
59 }
60
61 }