UpgradeSchema.java |
1 /** 2 * Copyright (c) 2000-2007 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.v4_3_0; 24 25 import com.liferay.portal.upgrade.SmartUpgradeSchema; 26 27 import org.apache.commons.logging.Log; 28 import org.apache.commons.logging.LogFactory; 29 30 /** 31 * <a href="UpgradeSchema.java.html"><b><i>View Source</i></b></a> 32 * 33 * @author Brian Wing Shun Chan 34 * 35 */ 36 public class UpgradeSchema extends SmartUpgradeSchema { 37 38 protected void upgradeOnce() throws Exception { 39 runSQLTemplate("update-4.2.0-4.3.0.sql", false); 40 41 for (int i = 0; i < _OLD_TABLES.length; i++) { 42 try { 43 runSQL("drop table " + _OLD_TABLES[i]); 44 } 45 catch (Exception e) { 46 } 47 } 48 } 49 50 private static final String[] _OLD_TABLES = new String[] { 51 "ABContact", "ABContacts_ABLists", "ABList", "AdminConfig", "BJEntry", 52 "BJTopic", "BJVerse", "CalTask", "ComicEntry", 53 "ContactOrgDepartmentLevel", "DLFileProfile", "DLRepository", 54 "MailReceipt", "NetworkAddress", "Note", "OrgDepartment", "ProjFirm", 55 "ProjProject", "ProjTask", "ProjTime", "ResourceType", 56 "Users_ComicEntries", "Users_ProjProjects" 57 }; 58 59 private static Log _log = LogFactory.getLog(UpgradeSchema.class); 60 61 }