001    /**
002     * Copyright (c) 2000-2010 Liferay, Inc. All rights reserved.
003     *
004     * The contents of this file are subject to the terms of the Liferay Enterprise
005     * Subscription License ("License"). You may not use this file except in
006     * compliance with the License. You can obtain a copy of the License by
007     * contacting Liferay, Inc. See the License for the specific language governing
008     * permissions and limitations under the License, including but not limited to
009     * distribution rights of the Software.
010     *
011     *
012     *
013     */
014    
015    package com.liferay.portal.upgrade.v4_3_0;
016    
017    import com.liferay.portal.kernel.upgrade.UpgradeProcess;
018    
019    /**
020     * @author Brian Wing Shun Chan
021     */
022    public class UpgradeSchema extends UpgradeProcess {
023    
024            protected void doUpgrade() throws Exception {
025                    runSQLTemplate("update-4.2.0-4.3.0.sql", false);
026    
027                    for (int i = 0; i < _OLD_TABLES.length; i++) {
028                            try {
029                                    runSQL("drop table " + _OLD_TABLES[i]);
030                            }
031                            catch (Exception e) {
032                            }
033                    }
034            }
035    
036            private static final String[] _OLD_TABLES = new String[] {
037                    "ABContact", "ABContacts_ABLists", "ABList", "AdminConfig", "BJEntry",
038                    "BJTopic", "BJVerse", "CalTask", "ComicEntry",
039                    "ContactOrgDepartmentLevel", "DLFileProfile", "DLRepository",
040                    "MailReceipt", "NetworkAddress", "Note", "OrgDepartment", "ProjFirm",
041                    "ProjProject", "ProjTask", "ProjTime", "ResourceType",
042                    "Users_ComicEntries", "Users_ProjProjects"
043            };
044    
045    }