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