001    /**
002     * Copyright (c) 2000-2011 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.v6_1_0;
016    
017    import com.liferay.portal.kernel.upgrade.UpgradeProcess;
018    
019    /**
020     * @author Kenneth Chang
021     */
022    public class UpgradeCountry extends UpgradeProcess {
023    
024            @Override
025            protected void doUpgrade() throws Exception {
026                    for (String name : _NAMES) {
027                            runSQL(
028                                    "update Country set zipRequired = FALSE where name = '" + name +
029                                            "'");
030                    }
031            }
032    
033            private static final String[] _NAMES = {
034                    "Angola", "Antigua", "Aruba", "Bahamas", "Belize", "Benin", "Botswana",
035                    "Burkina Faso", "Burundi", "Central African Republic", "Comoros",
036                    "Republic of Congo", "Democratic Republic of Congo", "Cook Islands",
037                    "Djibouti", "Dominica", "Equatorial Guinea", "Eritrea", "Fiji Islands",
038                    "Gambia", "Ghana", "Grenada", "Guinea", "Guyana", "Ireland", "Kiribati",
039                    "North Korea", "Macau", "Malawi", "Mali", "Mauritania", "Mauritius",
040                    "Montserrat", "Nauru", "Niue", "Qatar", "Rwanda", "St. Kitts",
041                    "St. Lucia", "Sao Tome & Principe", "Seychelles", "Sierra Leone",
042                    "Solomon Islands", "Somalia", "Suriname", "Syria", "Tanzania", "Tonga",
043                    "Trinidad & Tobago", "Tuvalu", "Uganda", "United Arab Emirates",
044                    "Vanuatu", "Yemen", "Zimbabwe"
045            };
046    
047    }