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.upgrade.v6_0_0.util.PollsChoiceTable;
019 import com.liferay.portal.upgrade.v6_0_0.util.PollsQuestionTable;
020
021 import java.sql.SQLException;
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 runSQL("alter_column_type PollsQuestion title STRING null");
034 }
035 catch (SQLException sqle) {
036
037
038
039 upgradeTable(
040 PollsChoiceTable.TABLE_NAME, PollsChoiceTable.TABLE_COLUMNS,
041 PollsChoiceTable.TABLE_SQL_CREATE,
042 PollsChoiceTable.TABLE_SQL_ADD_INDEXES);
043
044
045
046 upgradeTable(
047 PollsQuestionTable.TABLE_NAME, PollsQuestionTable.TABLE_COLUMNS,
048 PollsQuestionTable.TABLE_SQL_CREATE,
049 PollsQuestionTable.TABLE_SQL_ADD_INDEXES);
050 }
051 }
052
053 }