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 @Override
029 protected void doUpgrade() throws Exception {
030 try {
031 runSQL("alter_column_type PollsChoice description STRING null");
032 }
033 catch (Exception e) {
034
035
036
037 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
038 PollsChoiceTable.TABLE_NAME, PollsChoiceTable.TABLE_COLUMNS);
039
040 upgradeTable.setCreateSQL(PollsChoiceTable.TABLE_SQL_CREATE);
041 upgradeTable.setIndexesSQL(PollsChoiceTable.TABLE_SQL_ADD_INDEXES);
042
043 upgradeTable.updateTable();
044 }
045
046 try {
047 runSQL("alter_column_type PollsQuestion title STRING null");
048 }
049 catch (Exception e) {
050
051
052
053 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
054 PollsQuestionTable.TABLE_NAME,
055 PollsQuestionTable.TABLE_COLUMNS);
056
057 upgradeTable.setCreateSQL(PollsQuestionTable.TABLE_SQL_CREATE);
058 upgradeTable.setIndexesSQL(
059 PollsQuestionTable.TABLE_SQL_ADD_INDEXES);
060
061 upgradeTable.updateTable();
062 }
063
064 }
065
066 }