001
014
015 package com.liferay.portal.upgrade.v5_1_5;
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.upgrade.v5_1_5.util.BookmarksEntryTable;
021
022
025 public class UpgradeBookmarks extends UpgradeProcess {
026
027 @Override
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 upgradeTable.setIndexesSQL(
042 BookmarksEntryTable.TABLE_SQL_ADD_INDEXES);
043
044 upgradeTable.updateTable();
045 }
046
047
048
049 updateGroupId();
050 }
051
052 protected void updateGroupId() throws Exception {
053 StringBuilder sb = new StringBuilder();
054
055 sb.append("update BookmarksEntry set groupId = (select groupId from ");
056 sb.append("BookmarksFolder where BookmarksFolder.folderId = ");
057 sb.append("BookmarksEntry.folderId)");
058
059 runSQL(sb.toString());
060 }
061
062 }