1
14
15 package com.liferay.portal.upgrade.v6_0_0;
16
17 import com.liferay.portal.kernel.upgrade.UpgradeProcess;
18 import com.liferay.portal.kernel.upgrade.util.UpgradeTable;
19 import com.liferay.portal.kernel.upgrade.util.UpgradeTableFactoryUtil;
20 import com.liferay.portal.upgrade.v6_0_0.util.PollsChoiceTable;
21 import com.liferay.portal.upgrade.v6_0_0.util.PollsQuestionTable;
22
23
28 public class UpgradePolls extends UpgradeProcess {
29
30 protected void doUpgrade() throws Exception {
31 try {
32 runSQL("alter_column_type PollsChoice description STRING null");
33 }
34 catch (Exception e) {
35
36
38 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
39 PollsChoiceTable.TABLE_NAME, PollsChoiceTable.TABLE_COLUMNS);
40
41 upgradeTable.setCreateSQL(PollsChoiceTable.TABLE_SQL_CREATE);
42
43 upgradeTable.updateTable();
44 }
45
46 try {
47 runSQL("alter_column_type PollsQuestion title STRING null");
48 }
49 catch (Exception e) {
50
51
53 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
54 PollsQuestionTable.TABLE_NAME,
55 PollsQuestionTable.TABLE_COLUMNS);
56
57 upgradeTable.setCreateSQL(PollsQuestionTable.TABLE_SQL_CREATE);
58
59 upgradeTable.updateTable();
60 }
61
62 }
63
64 }