001
014
015 package com.liferay.portal.upgrade.v5_2_3;
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.kernel.util.StringBundler;
021 import com.liferay.portal.upgrade.v5_2_3.util.BookmarksEntryTable;
022
023
026 public class UpgradeBookmarks extends UpgradeProcess {
027
028 protected void doUpgrade() throws Exception {
029 try {
030 runSQL("alter_column_type BookmarksEntry name VARCHAR(255) null");
031 }
032 catch (Exception e) {
033
034
035
036 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
037 BookmarksEntryTable.TABLE_NAME,
038 BookmarksEntryTable.TABLE_COLUMNS);
039
040 upgradeTable.setCreateSQL(BookmarksEntryTable.TABLE_SQL_CREATE);
041
042 upgradeTable.updateTable();
043 }
044
045
046
047 updateGroupId();
048 }
049
050 protected void updateGroupId() throws Exception {
051 StringBundler sb = new StringBundler(3);
052
053 sb.append("update BookmarksEntry set groupId = (select groupId from ");
054 sb.append("BookmarksFolder where BookmarksFolder.folderId = ");
055 sb.append("BookmarksEntry.folderId)");
056
057 runSQL(sb.toString());
058 }
059
060 }