001    /**
002     * Copyright (c) 2000-2010 Liferay, Inc. All rights reserved.
003     *
004     * This library is free software; you can redistribute it and/or modify it under
005     * the terms of the GNU Lesser General Public License as published by the Free
006     * Software Foundation; either version 2.1 of the License, or (at your option)
007     * any later version.
008     *
009     * This library is distributed in the hope that it will be useful, but WITHOUT
010     * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
011     * FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
012     * details.
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    }