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 @Override
029 protected void doUpgrade() throws Exception {
030 try {
031 runSQL("alter_column_type BookmarksEntry name VARCHAR(255) null");
032 }
033 catch (Exception e) {
034
035
036
037 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
038 BookmarksEntryTable.TABLE_NAME,
039 BookmarksEntryTable.TABLE_COLUMNS);
040
041 upgradeTable.setCreateSQL(BookmarksEntryTable.TABLE_SQL_CREATE);
042 upgradeTable.setIndexesSQL(
043 BookmarksEntryTable.TABLE_SQL_ADD_INDEXES);
044
045 upgradeTable.updateTable();
046 }
047
048
049
050 updateGroupId();
051 }
052
053 protected void updateGroupId() throws Exception {
054 StringBundler sb = new StringBundler(3);
055
056 sb.append("update BookmarksEntry set groupId = (select groupId from ");
057 sb.append("BookmarksFolder where BookmarksFolder.folderId = ");
058 sb.append("BookmarksEntry.folderId)");
059
060 runSQL(sb.toString());
061 }
062
063 }