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