1   /**
2    * Copyright (c) 2000-2010 Liferay, Inc. All rights reserved.
3    *
4    * This library is free software; you can redistribute it and/or modify it under
5    * the terms of the GNU Lesser General Public License as published by the Free
6    * Software Foundation; either version 2.1 of the License, or (at your option)
7    * any later version.
8    *
9    * This library is distributed in the hope that it will be useful, but WITHOUT
10   * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
11   * FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
12   * details.
13   */
14  
15  package com.liferay.portal.upgrade.v4_3_0;
16  
17  import com.liferay.portal.kernel.upgrade.UpgradeProcess;
18  
19  /**
20   * <a href="UpgradeSchema.java.html"><b><i>View Source</i></b></a>
21   *
22   * @author Brian Wing Shun Chan
23   */
24  public class UpgradeSchema extends UpgradeProcess {
25  
26      protected void doUpgrade() throws Exception {
27          runSQLTemplate("update-4.2.0-4.3.0.sql", false);
28  
29          for (int i = 0; i < _OLD_TABLES.length; i++) {
30              try {
31                  runSQL("drop table " + _OLD_TABLES[i]);
32              }
33              catch (Exception e) {
34              }
35          }
36      }
37  
38      private static final String[] _OLD_TABLES = new String[] {
39          "ABContact", "ABContacts_ABLists", "ABList", "AdminConfig", "BJEntry",
40          "BJTopic", "BJVerse", "CalTask", "ComicEntry",
41          "ContactOrgDepartmentLevel", "DLFileProfile", "DLRepository",
42          "MailReceipt", "NetworkAddress", "Note", "OrgDepartment", "ProjFirm",
43          "ProjProject", "ProjTask", "ProjTime", "ResourceType",
44          "Users_ComicEntries", "Users_ProjProjects"
45      };
46  
47  }