| UpgradeSchema.java |
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 }