UpgradeWiki.java |
1 /** 2 * Copyright (c) 2000-2009 Liferay, Inc. All rights reserved. 3 * 4 * Permission is hereby granted, free of charge, to any person obtaining a copy 5 * of this software and associated documentation files (the "Software"), to deal 6 * in the Software without restriction, including without limitation the rights 7 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell 8 * copies of the Software, and to permit persons to whom the Software is 9 * furnished to do so, subject to the following conditions: 10 * 11 * The above copyright notice and this permission notice shall be included in 12 * all copies or substantial portions of the Software. 13 * 14 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR 15 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, 16 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE 17 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER 18 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, 19 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE 20 * SOFTWARE. 21 */ 22 23 package com.liferay.portal.upgrade.v5_1_7; 24 25 import com.liferay.portal.upgrade.UpgradeProcess; 26 import com.liferay.portal.upgrade.util.DefaultUpgradeTableImpl; 27 import com.liferay.portal.upgrade.util.UpgradeTable; 28 import com.liferay.portal.upgrade.v5_1_7.util.WikiPageResourceTable; 29 import com.liferay.portal.upgrade.v5_1_7.util.WikiPageTable; 30 31 /** 32 * <a href="UpgradeWiki.java.html"><b><i>View Source</i></b></a> 33 * 34 * @author Brian Wing Shun Chan 35 */ 36 public class UpgradeWiki extends UpgradeProcess { 37 38 protected void doUpgrade() throws Exception { 39 try { 40 runSQL("alter_column_type WikiPage parentTitle varchar(255) null"); 41 runSQL( 42 "alter_column_type WikiPage redirectTitle varchar(255) null"); 43 } 44 catch (Exception e) { 45 46 // WikiPage 47 48 UpgradeTable upgradeTable = new DefaultUpgradeTableImpl( 49 WikiPageTable.TABLE_NAME, WikiPageTable.TABLE_COLUMNS); 50 51 upgradeTable.setCreateSQL(WikiPageTable.TABLE_SQL_CREATE); 52 53 upgradeTable.updateTable(); 54 } 55 56 try { 57 runSQL( 58 "alter_column_type WikiPageResource title varchar(255) null"); 59 } 60 catch (Exception e) { 61 62 // WikiPageResource 63 64 UpgradeTable upgradeTable = new DefaultUpgradeTableImpl( 65 WikiPageResourceTable.TABLE_NAME, 66 WikiPageResourceTable.TABLE_COLUMNS); 67 68 upgradeTable.setCreateSQL(WikiPageResourceTable.TABLE_SQL_CREATE); 69 70 upgradeTable.updateTable(); 71 } 72 } 73 74 }