001
014
015 package com.liferay.portal.upgrade.v6_0_0;
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.v6_0_0.util.PollsChoiceTable;
021 import com.liferay.portal.upgrade.v6_0_0.util.PollsQuestionTable;
022
023
026 public class UpgradePolls extends UpgradeProcess {
027
028 protected void doUpgrade() throws Exception {
029 try {
030 runSQL("alter_column_type PollsChoice description STRING null");
031 }
032 catch (Exception e) {
033
034
035
036 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
037 PollsChoiceTable.TABLE_NAME, PollsChoiceTable.TABLE_COLUMNS);
038
039 upgradeTable.setCreateSQL(PollsChoiceTable.TABLE_SQL_CREATE);
040
041 upgradeTable.updateTable();
042 }
043
044 try {
045 runSQL("alter_column_type PollsQuestion title STRING null");
046 }
047 catch (Exception e) {
048
049
050
051 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
052 PollsQuestionTable.TABLE_NAME,
053 PollsQuestionTable.TABLE_COLUMNS);
054
055 upgradeTable.setCreateSQL(PollsQuestionTable.TABLE_SQL_CREATE);
056
057 upgradeTable.updateTable();
058 }
059
060 }
061
062 }