From 867970063f640edd408f4eb2fb3fcd8db2761f1b Mon Sep 17 00:00:00 2001 From: joannechester Date: Wed, 29 Jul 2015 21:36:25 +1200 Subject: [PATCH] CRM-16876 Change country name to uppercase --- .../phpunit/CRM/Core/BAO/CustomFieldTest.php | 22 +- .../CRM/Core/Payment/PayPalProIPNTest.php | 4 +- .../phpunit/CiviTest/CiviSeleniumTestCase.php | 2 +- tests/phpunit/CiviTest/CiviUnitTestCase.php | 2 +- .../WebTest/ACL/AssignUsersToRolesTest.php | 6 +- .../Admin/Form/Setting/LocalizationTest.php | 16 +- .../Campaign/OnlineEventRegistrationTest.php | 2 +- .../WebTest/Contact/AddCmsUserTest.php | 2 +- .../WebTest/Contact/AddViaProfileTest.php | 2 +- .../WebTest/Contact/AddressParsingTest.php | 2 +- .../WebTest/Contact/AdvanceSearchPaneTest.php | 2 +- .../WebTest/Contact/AdvancedSearchTest.php | 6 +- .../AdvancedSearchedRelatedContactTest.php | 2 +- .../WebTest/Contact/ProfileChecksumTest.php | 2 +- .../WebTest/Contact/SearchBuilderTest.php | 8 +- .../Contribute/OnBehalfOfOrganization.php | 14 +- tests/phpunit/WebTest/Event/AddEventTest.php | 2 +- .../WebTest/Event/EventWaitListTest.php | 2 +- .../phpunit/WebTest/Event/TellAFriendTest.php | 2 +- tests/phpunit/WebTest/Export/ContactTest.php | 2 +- .../WebTest/Import/AddressImportTest.php | 2 +- .../WebTest/Import/AddressParsingTest.php | 8 +- .../WebTest/Import/ContactSubtypeTest.php | 12 +- tests/phpunit/WebTest/Import/ContactTest.php | 12 +- .../phpunit/WebTest/Import/DateFormatTest.php | 24 +- .../WebTest/Import/DuplicateMatchingTest.php | 12 +- tests/phpunit/WebTest/Import/GroupTest.php | 4 +- .../Import/MultipleRelationshipTest.php | 16 +- .../WebTest/Import/SavedMappingTest.php | 4 +- tests/phpunit/WebTest/Import/TagTest.php | 4 +- tests/phpunit/WebTest/Profile/SearchTest.php | 6 +- tests/phpunit/api/v3/ProfileTest.php | 4 +- xml/templates/civicrm_country.tpl | 500 +++++++++--------- 33 files changed, 355 insertions(+), 355 deletions(-) diff --git a/tests/phpunit/CRM/Core/BAO/CustomFieldTest.php b/tests/phpunit/CRM/Core/BAO/CustomFieldTest.php index 506c3a1c33..54bc605697 100644 --- a/tests/phpunit/CRM/Core/BAO/CustomFieldTest.php +++ b/tests/phpunit/CRM/Core/BAO/CustomFieldTest.php @@ -169,7 +169,7 @@ class CRM_Core_BAO_CustomFieldTest extends CiviUnitTestCase { */ public function testMoveField() { $countriesByName = array_flip(CRM_Core_PseudoConstant::country(FALSE, FALSE)); - $this->assertTrue($countriesByName['Andorra'] > 0); + $this->assertTrue($countriesByName['ANDORRA'] > 0); $groups = array( 'A' => Custom::createGroup(array( 'title' => 'Test_Group A', @@ -214,20 +214,20 @@ class CRM_Core_BAO_CustomFieldTest extends CiviUnitTestCase { 'alice' => Contact::createIndividual(array( 'first_name' => 'Alice', 'last_name' => 'Albertson', - 'custom_' . $fields['countryA']->id => $countriesByName['Andorra'], - 'custom_' . $fields['countryB']->id => $countriesByName['Barbados'], + 'custom_' . $fields['countryA']->id => $countriesByName['ANDORRA'], + 'custom_' . $fields['countryB']->id => $countriesByName['BARBADOS'], )), 'bob' => Contact::createIndividual(array( 'first_name' => 'Bob', 'last_name' => 'Roberts', - 'custom_' . $fields['countryA']->id => $countriesByName['Austria'], - 'custom_' . $fields['countryB']->id => $countriesByName['Bermuda'], - 'custom_' . $fields['countryC']->id => $countriesByName['Chad'], + 'custom_' . $fields['countryA']->id => $countriesByName['AUSTRIA'], + 'custom_' . $fields['countryB']->id => $countriesByName['BERMUDA'], + 'custom_' . $fields['countryC']->id => $countriesByName['CHAD'], )), 'carol' => Contact::createIndividual(array( 'first_name' => 'Carol', 'last_name' => 'Carolson', - 'custom_' . $fields['countryC']->id => $countriesByName['Cambodia'], + 'custom_' . $fields['countryC']->id => $countriesByName['CAMBODIA'], )), ); @@ -252,7 +252,7 @@ class CRM_Core_BAO_CustomFieldTest extends CiviUnitTestCase { AND {$fields['countryC']->column_name} is null", array( 1 => array($contacts['alice'], 'Integer'), - 3 => array($countriesByName['Barbados'], 'Integer'), + 3 => array($countriesByName['BARBADOS'], 'Integer'), ) ); @@ -264,8 +264,8 @@ class CRM_Core_BAO_CustomFieldTest extends CiviUnitTestCase { AND {$fields['countryC']->column_name} = %4", array( 1 => array($contacts['bob'], 'Integer'), - 3 => array($countriesByName['Bermuda'], 'Integer'), - 4 => array($countriesByName['Chad'], 'Integer'), + 3 => array($countriesByName['BERMUDA'], 'Integer'), + 4 => array($countriesByName['CHAD'], 'Integer'), ) ); @@ -277,7 +277,7 @@ class CRM_Core_BAO_CustomFieldTest extends CiviUnitTestCase { AND {$fields['countryC']->column_name} = %4", array( 1 => array($contacts['carol'], 'Integer'), - 4 => array($countriesByName['Cambodia'], 'Integer'), + 4 => array($countriesByName['CAMBODIA'], 'Integer'), ) ); diff --git a/tests/phpunit/CRM/Core/Payment/PayPalProIPNTest.php b/tests/phpunit/CRM/Core/Payment/PayPalProIPNTest.php index f5225d7e5c..f7cab575b9 100644 --- a/tests/phpunit/CRM/Core/Payment/PayPalProIPNTest.php +++ b/tests/phpunit/CRM/Core/Payment/PayPalProIPNTest.php @@ -209,7 +209,7 @@ class CRM_Core_Payment_PayPalProIPNTest extends CiviUnitTestCase { 'notify_version' => '3.7', 'custom' => '', 'payer_status' => 'unverified', - 'address_country' => 'United States', + 'address_country' => 'UNITED STATES', 'address_city' => 'Portland', 'quantity' => '1', 'verify_sign' => 'AUyUU3IMAvssa3j4KorlbLnfr.9.AW7GX-sL7Ts1brCHvn13npvO-pqf', @@ -267,7 +267,7 @@ class CRM_Core_Payment_PayPalProIPNTest extends CiviUnitTestCase { 'payer_status' => 'unverified', 'currency_code' => 'USD', 'business' => 'mpa@mainepeoplesalliance.org', - 'address_country' => 'United States', + 'address_country' => 'UNITED STATES', 'address_city' => 'Limestone', 'verify_sign' => 'AXi4DULbes8quzIiq2YNsdTJH5ciPPPzG9PcQvkQg4BjfvWi8aY9GgDb', 'payer_email' => 'passport45051@yahoo.com', diff --git a/tests/phpunit/CiviTest/CiviSeleniumTestCase.php b/tests/phpunit/CiviTest/CiviSeleniumTestCase.php index 14f6fffec8..faafb8f65a 100644 --- a/tests/phpunit/CiviTest/CiviSeleniumTestCase.php +++ b/tests/phpunit/CiviTest/CiviSeleniumTestCase.php @@ -939,7 +939,7 @@ class CiviSeleniumTestCase extends PHPUnit_Extensions_SeleniumTestCase { $this->type('billing_street_address-5', '234 Lincoln Ave'); $this->type('billing_city-5', 'San Bernadino'); - $this->select2('billing_country_id-5', 'United States'); + $this->select2('billing_country_id-5', 'UNITED STATES'); $this->select2('billing_state_province_id-5', 'California'); $this->type('billing_postal_code-5', '93245'); diff --git a/tests/phpunit/CiviTest/CiviUnitTestCase.php b/tests/phpunit/CiviTest/CiviUnitTestCase.php index bc63fe90c6..860a66d2ac 100755 --- a/tests/phpunit/CiviTest/CiviUnitTestCase.php +++ b/tests/phpunit/CiviTest/CiviUnitTestCase.php @@ -1818,7 +1818,7 @@ class CiviUnitTestCase extends PHPUnit_Extensions_Database_TestCase { 'is_primary' => 1, 'name' => 'Saint Helier St', 'county' => 'Marin', - 'country' => 'United States', + 'country' => 'UNITED STATES', 'state_province' => 'Michigan', 'supplemental_address_1' => 'Hallmark Ct', 'supplemental_address_2' => 'Jersey Village', diff --git a/tests/phpunit/WebTest/ACL/AssignUsersToRolesTest.php b/tests/phpunit/WebTest/ACL/AssignUsersToRolesTest.php index 69d1d7932d..1be778fff3 100755 --- a/tests/phpunit/WebTest/ACL/AssignUsersToRolesTest.php +++ b/tests/phpunit/WebTest/ACL/AssignUsersToRolesTest.php @@ -135,7 +135,7 @@ class WebTest_ACL_AssignUsersToRolesTest extends CiviSeleniumTestCase { $this->openCiviPage('contact/search/advanced', 'reset=1'); $this->click("location"); $this->waitForElementPresent("country"); - $this->select("country", "United States"); + $this->select("country", "UNITED STATES"); $this->clickLink("_qf_Advanced_refresh"); $this->waitForElementPresent("task"); $this->click('radio_ts', 'ts_all'); @@ -212,11 +212,11 @@ class WebTest_ACL_AssignUsersToRolesTest extends CiviSeleniumTestCase { $this->openCiviPage('contact/search/advanced', 'reset=1'); $this->click("location"); $this->waitForElementPresent("country"); - $this->select("country", "United States"); + $this->select("country", "UNITED STATES"); $this->clickLink("_qf_Advanced_refresh"); $this->waitForElementPresent("xpath=//div[@class='crm-search-results']"); $this->assertElementNotContainsText("xpath=//form[@id='Advanced']/div[3]/div/div", "No matches found for"); - $this->verifyText("xpath=//div[@class='crm-search-results']//table/tbody/tr[1]/td[8]", 'United States'); + $this->verifyText("xpath=//div[@class='crm-search-results']//table/tbody/tr[1]/td[8]", 'UNITED STATES'); $this->checkEditOnEventProfile(); } diff --git a/tests/phpunit/WebTest/Admin/Form/Setting/LocalizationTest.php b/tests/phpunit/WebTest/Admin/Form/Setting/LocalizationTest.php index 804dec112c..6bdd94321f 100644 --- a/tests/phpunit/WebTest/Admin/Form/Setting/LocalizationTest.php +++ b/tests/phpunit/WebTest/Admin/Form/Setting/LocalizationTest.php @@ -38,16 +38,16 @@ class WebTest_Admin_Form_Setting_LocalizationTest extends CiviSeleniumTestCase { public function testDefaultCountryIsEnabled() { $this->webtestLogin(); $this->openCiviPage("admin/setting/localization", "reset=1"); - $this->addSelection("countryLimit-t", "label=United States"); + $this->addSelection("countryLimit-t", "label=UNITED STATES"); $this->click("//select[@id='countryLimit-t']/option"); $this->click("//input[@name='remove' and @value='<< Remove' and @type='button' and @onclick=\"QFAMS.moveSelection('countryLimit', this.form.elements['countryLimit-f[]'], this.form.elements['countryLimit-t[]'], this.form.elements['countryLimit[]'], 'remove', 'none'); return false;\"]"); - $this->addSelection("countryLimit-f", "label=Afghanistan"); - $this->removeSelection("countryLimit-f", "label=Afghanistan"); - $this->addSelection("countryLimit-f", "label=Cambodia"); - $this->removeSelection("countryLimit-f", "label=Cambodia"); - $this->addSelection("countryLimit-f", "label=Cameroon"); - $this->removeSelection("countryLimit-f", "label=Cameroon"); - $this->addSelection("countryLimit-f", "label=Canada"); + $this->addSelection("countryLimit-f", "label=AFGHANISTAN"); + $this->removeSelection("countryLimit-f", "label=AFGHANISTAN"); + $this->addSelection("countryLimit-f", "label=CAMBODIA"); + $this->removeSelection("countryLimit-f", "label=CAMBODIA"); + $this->addSelection("countryLimit-f", "label=CAMEROON"); + $this->removeSelection("countryLimit-f", "label=CAMEROON"); + $this->addSelection("countryLimit-f", "label=CANADA"); $this->click("//input[@name='add' and @value='Add >>' and @type='button' and @onclick=\"QFAMS.moveSelection('countryLimit', this.form.elements['countryLimit-f[]'], this.form.elements['countryLimit-t[]'], this.form.elements['countryLimit[]'], 'add', 'none'); return false;\"]"); $this->click("_qf_Localization_next-bottom"); $this->waitForPageToLoad($this->getTimeoutMsec()); diff --git a/tests/phpunit/WebTest/Campaign/OnlineEventRegistrationTest.php b/tests/phpunit/WebTest/Campaign/OnlineEventRegistrationTest.php index 72efbc7d84..bc228aaa50 100644 --- a/tests/phpunit/WebTest/Campaign/OnlineEventRegistrationTest.php +++ b/tests/phpunit/WebTest/Campaign/OnlineEventRegistrationTest.php @@ -197,7 +197,7 @@ class WebTest_Campaign_OnlineEventRegistrationTest extends CiviSeleniumTestCase $this->waitForElementPresent('address_1_city'); $this->type("address_1_city", "San Francisco"); $this->type("address_1_postal_code", "94117"); - $this->select('address_1_country_id', 'United States'); + $this->select('address_1_country_id', 'UNITED STATES'); $this->select("address_1_state_province_id", "value=1004"); $this->type("email_1_email", "info@civicrm.org"); diff --git a/tests/phpunit/WebTest/Contact/AddCmsUserTest.php b/tests/phpunit/WebTest/Contact/AddCmsUserTest.php index 83d7e95352..5dc5b0f5e0 100644 --- a/tests/phpunit/WebTest/Contact/AddCmsUserTest.php +++ b/tests/phpunit/WebTest/Contact/AddCmsUserTest.php @@ -101,7 +101,7 @@ class WebTest_Contact_AddCmsUserTest extends CiviSeleniumTestCase { $this->type('street_address-1', '902C El Camino Way SW'); $this->type('city-1', 'Dumfries'); $this->type('postal_code-1', '1234'); - $this->assertTrue($this->isTextPresent('United States')); + $this->assertTrue($this->isTextPresent('UNITED STATES')); $this->select('state_province-1', 'value=1019'); $this->click('edit-submit'); diff --git a/tests/phpunit/WebTest/Contact/AddViaProfileTest.php b/tests/phpunit/WebTest/Contact/AddViaProfileTest.php index dd1d9bb1cf..52eede2b99 100644 --- a/tests/phpunit/WebTest/Contact/AddViaProfileTest.php +++ b/tests/phpunit/WebTest/Contact/AddViaProfileTest.php @@ -54,7 +54,7 @@ class WebTest_Contact_AddViaProfileTest extends CiviSeleniumTestCase { $this->type("street_address-1", "902C El Camino Way SW"); $this->type("city-1", "Dumfries"); $this->type("postal_code-1", "1234"); - $this->assertSelected('country-1', "United States"); + $this->assertSelected('country-1', "UNITED STATES"); $this->select("state_province-1", "value=1019"); // Clicking save. diff --git a/tests/phpunit/WebTest/Contact/AddressParsingTest.php b/tests/phpunit/WebTest/Contact/AddressParsingTest.php index 5e0bf47c23..453a92ff89 100644 --- a/tests/phpunit/WebTest/Contact/AddressParsingTest.php +++ b/tests/phpunit/WebTest/Contact/AddressParsingTest.php @@ -96,7 +96,7 @@ class WebTest_Contact_AddressParsingTest extends CiviSeleniumTestCase { $this->type("address_4_street_address", "121 SW Sherman Way Suite 15"); $this->type("address_4_city", "Birmingham"); $this->type("address_4_postal_code", "5491"); - $this->assertSelected('address_4_country_id', "United States"); + $this->assertSelected('address_4_country_id', "UNITED STATES"); $this->select("address_4_state_province_id", "value=1002"); // Store location type of each address diff --git a/tests/phpunit/WebTest/Contact/AdvanceSearchPaneTest.php b/tests/phpunit/WebTest/Contact/AdvanceSearchPaneTest.php index 5b4b71bcd6..f85b3d83a1 100644 --- a/tests/phpunit/WebTest/Contact/AdvanceSearchPaneTest.php +++ b/tests/phpunit/WebTest/Contact/AdvanceSearchPaneTest.php @@ -186,7 +186,7 @@ class WebTest_Contact_AdvanceSearchPaneTest extends CiviSeleniumTestCase { 'Country' => array( 'type' => 'select', 'locator' => 'country', - 'values' => array('United States'), + 'values' => array('UNITED STATES'), ), 'State' => array( 'type' => 'multiselect2', diff --git a/tests/phpunit/WebTest/Contact/AdvancedSearchTest.php b/tests/phpunit/WebTest/Contact/AdvancedSearchTest.php index 0d3d212ded..7ea7a458bc 100644 --- a/tests/phpunit/WebTest/Contact/AdvancedSearchTest.php +++ b/tests/phpunit/WebTest/Contact/AdvancedSearchTest.php @@ -241,7 +241,7 @@ class WebTest_Contact_AdvancedSearchTest extends CiviSeleniumTestCase { $this->select2("group", "Summer", TRUE); $this->select2("group", "Advisory", TRUE); $this->clickAjaxLink("location", 'country'); - $this->select2("country", "United States", FALSE); + $this->select2("country", "UNITED STATES", FALSE); $this->waitForElementPresent('state_province'); $this->multiselect2("state_province", array( "Ohio", @@ -304,7 +304,7 @@ class WebTest_Contact_AdvancedSearchTest extends CiviSeleniumTestCase { $this->type("postal_code_low", "100010"); $this->type("postal_code_high", "101000"); // select country - $this->select("country", "United States"); + $this->select("country", "UNITED STATES"); // select state-province $this->waitForElementPresent('state_province'); $this->select2("state_province", "Alaska", TRUE); @@ -482,7 +482,7 @@ class WebTest_Contact_AdvancedSearchTest extends CiviSeleniumTestCase { $this->type("address_1_supplemental_address_2", "street supplement 2 $firstName"); $this->type("address_1_city", "city$firstName"); $this->type("address_1_postal_code", "100100"); - $this->select("address_1_country_id", "United States"); + $this->select("address_1_country_id", "UNITED STATES"); $this->select("address_1_state_province_id", "Alaska"); // --- fill few values in communication preferences diff --git a/tests/phpunit/WebTest/Contact/AdvancedSearchedRelatedContactTest.php b/tests/phpunit/WebTest/Contact/AdvancedSearchedRelatedContactTest.php index ba277039b2..22f2dc3a56 100644 --- a/tests/phpunit/WebTest/Contact/AdvancedSearchedRelatedContactTest.php +++ b/tests/phpunit/WebTest/Contact/AdvancedSearchedRelatedContactTest.php @@ -184,7 +184,7 @@ class WebTest_Contact_AdvancedSearchedRelatedContactTest extends CiviSeleniumTes $this->type("address_1_street_address", $streetAddress); $this->type("address_1_city", "San Francisco"); $this->type("address_1_postal_code", "94117"); - $this->select('address_1_country_id', 'United States'); + $this->select('address_1_country_id', 'UNITED STATES'); $this->select("address_1_state_province_id", "value=1004"); $this->type("email_1_email", "info@civicrm.org"); diff --git a/tests/phpunit/WebTest/Contact/ProfileChecksumTest.php b/tests/phpunit/WebTest/Contact/ProfileChecksumTest.php index 081a0b8932..9ebb890c87 100644 --- a/tests/phpunit/WebTest/Contact/ProfileChecksumTest.php +++ b/tests/phpunit/WebTest/Contact/ProfileChecksumTest.php @@ -76,7 +76,7 @@ class WebTest_Contact_ProfileChecksumTest extends CiviSeleniumTestCase { 'location' => 0, 'default_value' => '1228', 'update_value' => '1228', - 'update_value_label' => 'United States', + 'update_value_label' => 'UNITED STATES', 'element_name' => 'country-Primary', 'html_type' => 'select', ), diff --git a/tests/phpunit/WebTest/Contact/SearchBuilderTest.php b/tests/phpunit/WebTest/Contact/SearchBuilderTest.php index b9c20143a9..463d9bb662 100644 --- a/tests/phpunit/WebTest/Contact/SearchBuilderTest.php +++ b/tests/phpunit/WebTest/Contact/SearchBuilderTest.php @@ -44,14 +44,14 @@ class WebTest_Contact_SearchBuilderTest extends CiviSeleniumTestCase { $this->openCiviPage('contact/search/builder', 'reset=1'); $this->enterValues(1, 1, 'Contacts', 'Group(s)', NULL, '=', array($groupName)); - $this->enterValues(1, 2, 'Contacts', 'Country', NULL, '=', array('United States')); + $this->enterValues(1, 2, 'Contacts', 'Country', NULL, '=', array('UNITED STATES')); $this->enterValues(1, 3, 'Individual', 'Gender', NULL, '=', array('Male')); $this->click('_qf_Builder_refresh'); $this->waitForPageToLoad(); // We should get no results. But check the options are all still set $this->waitForTextPresent('No matches found for:'); - foreach (array($groupName, 'United States', 'Male') as $i => $label) { + foreach (array($groupName, 'UNITED STATES', 'Male') as $i => $label) { $this->waitForElementPresent("//span[@id='crm_search_value_1_$i']/select/option[2]"); $this->assertSelectedLabel("//span[@id='crm_search_value_1_$i']/select", $label); } @@ -103,7 +103,7 @@ class WebTest_Contact_SearchBuilderTest extends CiviSeleniumTestCase { $this->type("address_1_supplemental_address_2", "street supplement 2 $firstName"); $this->type("address_1_city", "city$firstName"); $this->type("address_1_postal_code", "100100"); - $this->select("address_1_country_id", "United States"); + $this->select("address_1_country_id", "UNITED STATES"); $this->select("address_1_state_province_id", "Alaska"); // save contact @@ -363,7 +363,7 @@ class WebTest_Contact_SearchBuilderTest extends CiviSeleniumTestCase { $this->type("email_1_email", $email); $this->type("phone_1_phone", "9876543210"); $this->type("address_1_street_address", $streetName); - $this->select("address_1_country_id", "United States"); + $this->select("address_1_country_id", "UNITED STATES"); $this->select("address_1_state_province_id", "Alaska"); $this->type("address_1_postal_code", $postalCode); diff --git a/tests/phpunit/WebTest/Contribute/OnBehalfOfOrganization.php b/tests/phpunit/WebTest/Contribute/OnBehalfOfOrganization.php index 66d80b4c4b..50346adaa8 100644 --- a/tests/phpunit/WebTest/Contribute/OnBehalfOfOrganization.php +++ b/tests/phpunit/WebTest/Contribute/OnBehalfOfOrganization.php @@ -636,7 +636,7 @@ class WebTest_Contribute_OnBehalfOfOrganization extends CiviSeleniumTestCase { $this->type("onbehalf_city-3", "Test City"); $this->type("onbehalf_postal_code-3", substr(sha1(rand()), 0, 6)); $this->click("onbehalf_country-3"); - $this->select("onbehalf_country-3", "label=United States"); + $this->select("onbehalf_country-3", "label=UNITED STATES"); $this->click("onbehalf_state_province-3"); $this->select("onbehalf_state_province-3", "label=Alabama"); @@ -670,7 +670,7 @@ class WebTest_Contribute_OnBehalfOfOrganization extends CiviSeleniumTestCase { $this->type("onbehalf_city-3", "Test City"); $this->type("onbehalf_postal_code-3", substr(sha1(rand()), 0, 6)); $this->click("onbehalf_country-3"); - $this->select("onbehalf_country-3", "label=United States"); + $this->select("onbehalf_country-3", "label=UNITED STATES"); $this->click("onbehalf_state_province-3"); $this->select("onbehalf_state_province-3", "label=Alabama"); @@ -711,7 +711,7 @@ class WebTest_Contribute_OnBehalfOfOrganization extends CiviSeleniumTestCase { $this->type("onbehalf_city-3", "Test City"); $this->type("onbehalf_postal_code-3", substr(sha1(rand()), 0, 6)); $this->click("onbehalf_country-3"); - $this->select("onbehalf_country-3", "label=United States"); + $this->select("onbehalf_country-3", "label=UNITED STATES"); $this->click("onbehalf_state_province-3"); $this->select("onbehalf_state_province-3", "label=Alabama"); @@ -905,7 +905,7 @@ class WebTest_Contribute_OnBehalfOfOrganization extends CiviSeleniumTestCase { $this->type("address_1_street_address", "{$orgName1} street address"); $this->type("address_1_city", "{$orgName1} city"); $this->type("address_1_postal_code", substr(sha1(rand()), 0, 4)); - $this->assertTrue($this->isTextPresent("- select - United States")); + $this->assertTrue($this->isTextPresent("- select - UNITED STATES")); $this->select("address_1_state_province_id", "value=1019"); $this->type("address_1_geo_code_1", "1234"); $this->type("address_1_geo_code_2", "5678"); @@ -1156,7 +1156,7 @@ class WebTest_Contribute_OnBehalfOfOrganization extends CiviSeleniumTestCase { $this->type("address_1_street_address", "{$orgName1} street address"); $this->type("address_1_city", "{$orgName1} city"); $this->type("address_1_postal_code", "9999999999"); - $this->assertTrue($this->isTextPresent("- select - United States")); + $this->assertTrue($this->isTextPresent("- select - UNITED STATES")); $this->select("address_1_state_province_id", "value=1019"); $this->type("address_1_geo_code_1", "1234"); $this->type("address_1_geo_code_2", "5678"); @@ -1189,7 +1189,7 @@ class WebTest_Contribute_OnBehalfOfOrganization extends CiviSeleniumTestCase { $this->type("address_1_street_address", "{$orgName2} street address"); $this->type("address_1_city", "{$orgName2} city"); $this->type("address_1_postal_code", "7777777777"); - $this->assertTrue($this->isTextPresent("- select - United States")); + $this->assertTrue($this->isTextPresent("- select - UNITED STATES")); $this->select("address_1_state_province_id", "value=1019"); $this->type("address_1_geo_code_1", "1224"); $this->type("address_1_geo_code_2", "5628"); @@ -1501,7 +1501,7 @@ class WebTest_Contribute_OnBehalfOfOrganization extends CiviSeleniumTestCase { $this->type("onbehalf_city-3", "Test City"); $this->type("onbehalf_postal_code-3", substr(sha1(rand()), 0, 6)); $this->click("onbehalf_country-3"); - $this->select("onbehalf_country-3", "label=United States"); + $this->select("onbehalf_country-3", "label=UNITED STATES"); $this->click("onbehalf_state_province-3"); $this->select("onbehalf_state_province-3", "label=Alabama"); diff --git a/tests/phpunit/WebTest/Event/AddEventTest.php b/tests/phpunit/WebTest/Event/AddEventTest.php index d3d4cf263b..8f67403bf3 100644 --- a/tests/phpunit/WebTest/Event/AddEventTest.php +++ b/tests/phpunit/WebTest/Event/AddEventTest.php @@ -413,7 +413,7 @@ class WebTest_Event_AddEventTest extends CiviSeleniumTestCase { $this->type("address_1_street_address", $streetAddress); $this->type("address_1_city", "San Francisco"); $this->type("address_1_postal_code", "94117"); - $this->select('address_1_country_id', 'United States'); + $this->select('address_1_country_id', 'UNITED STATES'); $this->select("address_1_state_province_id", "value=1004"); $this->type("email_1_email", "info@civicrm.org"); diff --git a/tests/phpunit/WebTest/Event/EventWaitListTest.php b/tests/phpunit/WebTest/Event/EventWaitListTest.php index eafcccbdd1..73d5492848 100644 --- a/tests/phpunit/WebTest/Event/EventWaitListTest.php +++ b/tests/phpunit/WebTest/Event/EventWaitListTest.php @@ -79,7 +79,7 @@ class WebTest_Event_EventWaitListTest extends CiviSeleniumTestCase { $this->type("address_1_street_address", $streetAddress); $this->type("address_1_city", "San Francisco"); $this->type("address_1_postal_code", "94117"); - $this->select('address_1_country_id', 'United States'); + $this->select('address_1_country_id', 'UNITED STATES'); $this->select("address_1_state_province_id", "value=1004"); $this->type("email_1_email", "info@civicrm.org"); diff --git a/tests/phpunit/WebTest/Event/TellAFriendTest.php b/tests/phpunit/WebTest/Event/TellAFriendTest.php index 8ad9e0543a..49512c7109 100644 --- a/tests/phpunit/WebTest/Event/TellAFriendTest.php +++ b/tests/phpunit/WebTest/Event/TellAFriendTest.php @@ -211,7 +211,7 @@ class WebTest_Event_TellAFriendTest extends CiviSeleniumTestCase { $this->type("address_1_street_address", $streetAddress); $this->type("address_1_city", "San Francisco"); $this->type("address_1_postal_code", "94117"); - $this->select('address_1_country_id', 'United States'); + $this->select('address_1_country_id', 'UNITED STATES'); $this->select("address_1_state_province_id", "value=1004"); $this->type("email_1_email", "info@civicrm.org"); diff --git a/tests/phpunit/WebTest/Export/ContactTest.php b/tests/phpunit/WebTest/Export/ContactTest.php index a4d3e792c1..87a783461f 100644 --- a/tests/phpunit/WebTest/Export/ContactTest.php +++ b/tests/phpunit/WebTest/Export/ContactTest.php @@ -282,7 +282,7 @@ class WebTest_Export_ContactTest extends ExportCiviSeleniumTestCase { $this->type("address_1_street_address", "121A Sherman St. Apt. 12"); $this->type("address_1_city", "Dumfries"); $this->type("address_1_postal_code", "1234"); - $this->select("address_1_country_id", "United States"); + $this->select("address_1_country_id", "UNITED STATES"); $this->select("address_1_state_province_id", "value=1019"); $this->click('_qf_Contact_upload_view'); diff --git a/tests/phpunit/WebTest/Import/AddressImportTest.php b/tests/phpunit/WebTest/Import/AddressImportTest.php index ebad16f4f6..0d2eef4f39 100644 --- a/tests/phpunit/WebTest/Import/AddressImportTest.php +++ b/tests/phpunit/WebTest/Import/AddressImportTest.php @@ -96,7 +96,7 @@ class WebTest_Import_AddressImportTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), ); foreach ($customDataParams['rows'][0] as $key => $values) { diff --git a/tests/phpunit/WebTest/Import/AddressParsingTest.php b/tests/phpunit/WebTest/Import/AddressParsingTest.php index 2cade653c1..9907dde061 100644 --- a/tests/phpunit/WebTest/Import/AddressParsingTest.php +++ b/tests/phpunit/WebTest/Import/AddressParsingTest.php @@ -214,7 +214,7 @@ class WebTest_Import_AddressParsingTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), array( 'first_name' => 'S' . substr(sha1(rand()), 0, 7), @@ -227,7 +227,7 @@ class WebTest_Import_AddressParsingTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), ); @@ -266,7 +266,7 @@ class WebTest_Import_AddressParsingTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), array( 'first_name' => 'S' . substr(sha1(rand()), 0, 7), @@ -279,7 +279,7 @@ class WebTest_Import_AddressParsingTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), ); diff --git a/tests/phpunit/WebTest/Import/ContactSubtypeTest.php b/tests/phpunit/WebTest/Import/ContactSubtypeTest.php index 23783f5b49..aa2aebc8a3 100644 --- a/tests/phpunit/WebTest/Import/ContactSubtypeTest.php +++ b/tests/phpunit/WebTest/Import/ContactSubtypeTest.php @@ -323,7 +323,7 @@ class WebTest_Import_ContactSubtypeTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), array( 'first_name' => substr(sha1(rand()), 0, 7), @@ -335,7 +335,7 @@ class WebTest_Import_ContactSubtypeTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), ); @@ -369,7 +369,7 @@ class WebTest_Import_ContactSubtypeTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), array( 'organization_name' => 'org_' . substr(sha1(rand()), 0, 7), @@ -379,7 +379,7 @@ class WebTest_Import_ContactSubtypeTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), ); @@ -413,7 +413,7 @@ class WebTest_Import_ContactSubtypeTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), array( 'household_name' => 'household_' . substr(sha1(rand()), 0, 7), @@ -423,7 +423,7 @@ class WebTest_Import_ContactSubtypeTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), ); diff --git a/tests/phpunit/WebTest/Import/ContactTest.php b/tests/phpunit/WebTest/Import/ContactTest.php index fbe0753ce4..42e9beb0e9 100644 --- a/tests/phpunit/WebTest/Import/ContactTest.php +++ b/tests/phpunit/WebTest/Import/ContactTest.php @@ -315,7 +315,7 @@ class WebTest_Import_ContactTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), array( 'first_name' => substr(sha1(rand()), 0, 7), @@ -327,7 +327,7 @@ class WebTest_Import_ContactTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), ); @@ -361,7 +361,7 @@ class WebTest_Import_ContactTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), array( 'organization_name' => 'org_' . substr(sha1(rand()), 0, 7), @@ -371,7 +371,7 @@ class WebTest_Import_ContactTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), ); @@ -405,7 +405,7 @@ class WebTest_Import_ContactTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), array( 'household_name' => 'household_' . substr(sha1(rand()), 0, 7), @@ -415,7 +415,7 @@ class WebTest_Import_ContactTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), ); diff --git a/tests/phpunit/WebTest/Import/DateFormatTest.php b/tests/phpunit/WebTest/Import/DateFormatTest.php index 251c85084c..eae2de4f0b 100644 --- a/tests/phpunit/WebTest/Import/DateFormatTest.php +++ b/tests/phpunit/WebTest/Import/DateFormatTest.php @@ -182,7 +182,7 @@ class WebTest_Import_DateFormatTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', 'birth_date' => '1998-12-25', ), array( @@ -195,7 +195,7 @@ class WebTest_Import_DateFormatTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', 'birth_date' => '1999-11-26', ), ); @@ -235,7 +235,7 @@ class WebTest_Import_DateFormatTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', 'birth_date' => '12/23/98', ), array( @@ -248,7 +248,7 @@ class WebTest_Import_DateFormatTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', 'birth_date' => '11/24/88', ), ); @@ -288,7 +288,7 @@ class WebTest_Import_DateFormatTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', 'birth_date' => '11/12/1995', ), array( @@ -301,7 +301,7 @@ class WebTest_Import_DateFormatTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', 'birth_date' => '12/12/1995', ), ); @@ -341,7 +341,7 @@ class WebTest_Import_DateFormatTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', 'birth_date' => 'December 12, 1998', ), array( @@ -354,7 +354,7 @@ class WebTest_Import_DateFormatTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', 'birth_date' => 'December 13, 1998', ), ); @@ -394,7 +394,7 @@ class WebTest_Import_DateFormatTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', 'birth_date' => '25/12/98', ), array( @@ -407,7 +407,7 @@ class WebTest_Import_DateFormatTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', 'birth_date' => '26/12/99', ), ); @@ -447,7 +447,7 @@ class WebTest_Import_DateFormatTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', 'birth_date' => '25/12/1998', ), array( @@ -460,7 +460,7 @@ class WebTest_Import_DateFormatTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', 'birth_date' => '24/11/1996', ), ); diff --git a/tests/phpunit/WebTest/Import/DuplicateMatchingTest.php b/tests/phpunit/WebTest/Import/DuplicateMatchingTest.php index 794e4bc0d4..6d29ed0257 100644 --- a/tests/phpunit/WebTest/Import/DuplicateMatchingTest.php +++ b/tests/phpunit/WebTest/Import/DuplicateMatchingTest.php @@ -380,7 +380,7 @@ class WebTest_Import_DuplicateMatchingTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), array( 'first_name' => substr(sha1(rand()), 0, 7), @@ -392,7 +392,7 @@ class WebTest_Import_DuplicateMatchingTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), ); @@ -428,7 +428,7 @@ class WebTest_Import_DuplicateMatchingTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), array( 'organization_name' => 'org_' . substr(sha1(rand()), 0, 7), @@ -438,7 +438,7 @@ class WebTest_Import_DuplicateMatchingTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), ); @@ -474,7 +474,7 @@ class WebTest_Import_DuplicateMatchingTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), array( 'household_name' => 'household_' . substr(sha1(rand()), 0, 7), @@ -484,7 +484,7 @@ class WebTest_Import_DuplicateMatchingTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), ); diff --git a/tests/phpunit/WebTest/Import/GroupTest.php b/tests/phpunit/WebTest/Import/GroupTest.php index bd5f363d5a..4eb5a7a6e2 100644 --- a/tests/phpunit/WebTest/Import/GroupTest.php +++ b/tests/phpunit/WebTest/Import/GroupTest.php @@ -121,7 +121,7 @@ class WebTest_Import_GroupTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), array( 'first_name' => substr(sha1(rand()), 0, 7), @@ -133,7 +133,7 @@ class WebTest_Import_GroupTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), ); return array($headers, $rows); diff --git a/tests/phpunit/WebTest/Import/MultipleRelationshipTest.php b/tests/phpunit/WebTest/Import/MultipleRelationshipTest.php index 21650d4968..f27421e1eb 100644 --- a/tests/phpunit/WebTest/Import/MultipleRelationshipTest.php +++ b/tests/phpunit/WebTest/Import/MultipleRelationshipTest.php @@ -108,7 +108,7 @@ class WebTest_Import_MultipleRelationshipTest extends ImportCiviSeleniumTestCase 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', 'contact_relationships' => array( '4_a_b' => array( @@ -117,7 +117,7 @@ class WebTest_Import_MultipleRelationshipTest extends ImportCiviSeleniumTestCase 'organization_add' => 'Org Street Address', 'organization_city' => 'Org City', 'organization_state' => 'NY', - 'organization_country' => 'United States', + 'organization_country' => 'UNITED STATES', ), '7_a_b' => array( 'household_name' => 'House ' . substr(sha1(rand()), 0, 7), @@ -125,7 +125,7 @@ class WebTest_Import_MultipleRelationshipTest extends ImportCiviSeleniumTestCase 'household_add' => 'House Street Address', 'household_city' => 'House City', 'household_state' => 'NY', - 'household_country' => 'United States', + 'household_country' => 'UNITED STATES', ), '2_a_b' => array( 'spouse_f_name' => substr(sha1(rand()), 0, 7), @@ -134,7 +134,7 @@ class WebTest_Import_MultipleRelationshipTest extends ImportCiviSeleniumTestCase 'spouse_add' => 'Spouse Street Address', 'spouse_city' => 'Spouse City', 'spouse_state' => 'NY', - 'spouse_country' => 'United States', + 'spouse_country' => 'UNITED STATES', ), ), ), @@ -148,7 +148,7 @@ class WebTest_Import_MultipleRelationshipTest extends ImportCiviSeleniumTestCase 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', 'contact_relationships' => array( '4_a_b' => array( @@ -157,7 +157,7 @@ class WebTest_Import_MultipleRelationshipTest extends ImportCiviSeleniumTestCase 'organization_add' => 'Org Street Address', 'organization_city' => 'Org City', 'organization_state' => 'NY', - 'organization_country' => 'United States', + 'organization_country' => 'UNITED STATES', ), '7_a_b' => array( 'household_name' => 'House ' . substr(sha1(rand()), 0, 7), @@ -165,7 +165,7 @@ class WebTest_Import_MultipleRelationshipTest extends ImportCiviSeleniumTestCase 'household_add' => 'House Street Address', 'household_city' => 'House City', 'household_state' => 'NY', - 'household_country' => 'United States', + 'household_country' => 'UNITED STATES', ), '2_a_b' => array( 'spouse_f_name' => substr(sha1(rand()), 0, 7), @@ -174,7 +174,7 @@ class WebTest_Import_MultipleRelationshipTest extends ImportCiviSeleniumTestCase 'spouse_add' => 'Spouse Street Address', 'spouse_city' => 'Spouse City', 'spouse_state' => 'NY', - 'spouse_country' => 'United States', + 'spouse_country' => 'UNITED STATES', ), ), ), diff --git a/tests/phpunit/WebTest/Import/SavedMappingTest.php b/tests/phpunit/WebTest/Import/SavedMappingTest.php index d7e95ba9ee..9a63a3dbf0 100644 --- a/tests/phpunit/WebTest/Import/SavedMappingTest.php +++ b/tests/phpunit/WebTest/Import/SavedMappingTest.php @@ -116,7 +116,7 @@ class WebTest_Import_SavedMappingTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), array( 'individual_prefix' => 'Mr.', @@ -130,7 +130,7 @@ class WebTest_Import_SavedMappingTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), ); diff --git a/tests/phpunit/WebTest/Import/TagTest.php b/tests/phpunit/WebTest/Import/TagTest.php index 92db99968a..7f2007262e 100644 --- a/tests/phpunit/WebTest/Import/TagTest.php +++ b/tests/phpunit/WebTest/Import/TagTest.php @@ -118,7 +118,7 @@ class WebTest_Import_TagTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), array( 'first_name' => substr(sha1(rand()), 0, 7), @@ -130,7 +130,7 @@ class WebTest_Import_TagTest extends ImportCiviSeleniumTestCase { 'address_2' => 'Add 2', 'city' => 'Watson', 'state' => 'NY', - 'country' => 'United States', + 'country' => 'UNITED STATES', ), ); diff --git a/tests/phpunit/WebTest/Profile/SearchTest.php b/tests/phpunit/WebTest/Profile/SearchTest.php index 1f3cebe803..5edbd4f12e 100644 --- a/tests/phpunit/WebTest/Profile/SearchTest.php +++ b/tests/phpunit/WebTest/Profile/SearchTest.php @@ -173,7 +173,7 @@ class WebTest_Profile_SearchTest extends CiviSeleniumTestCase { $this->click('CIVICRM_QFID_Edu_2'); // fill country, state, county - $this->select('country-Primary', "United States"); + $this->select('country-Primary', "UNITED STATES"); // wait for state data to be populated $this->waitForElementPresent("xpath=//select[@id='state_province-Primary']/option[text()='California']"); @@ -200,7 +200,7 @@ class WebTest_Profile_SearchTest extends CiviSeleniumTestCase { $this->type('email-Primary', "jhon@$lastName.com"); // Fill state, county, country - $this->select('country-Primary', "United States"); + $this->select('country-Primary', "UNITED STATES"); // wait for state data to be populated $this->waitForElementPresent("xpath=//select[@id='state_province-Primary']/option[text()='California']"); @@ -219,7 +219,7 @@ class WebTest_Profile_SearchTest extends CiviSeleniumTestCase { $this->assertTrue($this->isElementPresent("xpath=//table/tbody/tr[2]/td[3][text()='$lastName']")); $this->assertTrue($this->isElementPresent("xpath=//table/tbody/tr[2]/td[4][text()='jhon@$lastName.com']")); $this->assertTrue($this->isElementPresent("xpath=//table/tbody/tr[2]/td[5][text()='Education']")); - $this->assertTrue($this->isElementPresent("xpath=//table/tbody/tr[2]/td[6][text()='United States']")); + $this->assertTrue($this->isElementPresent("xpath=//table/tbody/tr[2]/td[6][text()='UNITED STATES']")); $this->assertTrue($this->isElementPresent("xpath=//table/tbody/tr[2]/td[7][text()='CA']")); $this->assertTrue($this->isElementPresent("xpath=//table/tbody/tr[2]/td[8][text()='Alameda']")); diff --git a/tests/phpunit/api/v3/ProfileTest.php b/tests/phpunit/api/v3/ProfileTest.php index 6b6dd6b189..1d9c9104ab 100644 --- a/tests/phpunit/api/v3/ProfileTest.php +++ b/tests/phpunit/api/v3/ProfileTest.php @@ -743,7 +743,7 @@ class api_v3_ProfileTest extends CiviUnitTestCase { 'is_primary' => 1, 'street_address' => '5 Saint Helier St', 'county' => 'Marin', - 'country' => 'United States', + 'country' => 'UNITED STATES', 'state_province' => 'Michigan', 'supplemental_address_1' => 'Hallmark Ct', 'supplemental_address_2' => 'Jersey Village', @@ -800,7 +800,7 @@ class api_v3_ProfileTest extends CiviUnitTestCase { 'is_primary' => 1, 'name' => 'Saint Helier St', 'county' => 'Marin', - 'country' => 'United States', + 'country' => 'UNITED STATES', 'state_province' => 'Michigan', 'supplemental_address_1' => 'Hallmark Ct', 'supplemental_address_2' => 'Jersey Village', diff --git a/xml/templates/civicrm_country.tpl b/xml/templates/civicrm_country.tpl index a148a0f146..f19cc9372a 100644 --- a/xml/templates/civicrm_country.tpl +++ b/xml/templates/civicrm_country.tpl @@ -42,253 +42,253 @@ INSERT INTO civicrm_worldregion (id, name) VALUES("5", "Africa West, East, Centr INSERT INTO civicrm_worldregion (id, name) VALUES("99", "unassigned"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1001", "Afghanistan", "AF", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1002", "Albania", "AL", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1003", "Algeria", "DZ", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1004", "American Samoa", "AS", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1005", "Andorra", "AD", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1006", "Angola", "AO", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1007", "Anguilla", "AI", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1008", "Antarctica", "AQ", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1009", "Antigua and Barbuda", "AG", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1010", "Argentina", "AR", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1011", "Armenia", "AM", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1012", "Aruba", "AW", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1013", "Australia", "AU", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1014", "Austria", "AT", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1015", "Azerbaijan", "AZ", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1016", "Bahrain", "BH", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1017", "Bangladesh", "BD", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1018", "Barbados", "BB", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1019", "Belarus", "BY", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1020", "Belgium", "BE", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1021", "Belize", "BZ", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1022", "Benin", "BJ", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1023", "Bermuda", "BM", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1024", "Bhutan", "BT", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1025", "Bolivia", "BO", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1026", "Bosnia and Herzegovina", "BA", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1027", "Botswana", "BW", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1028", "Bouvet Island", "BV", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1029", "Brazil", "BR", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1030", "British Indian Ocean Territory", "IO", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1031", "Virgin Islands, British", "VG", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1032", "Brunei Darussalam", "BN", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1033", "Bulgaria", "BG", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1034", "Burkina Faso", "BF", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1035", "Myanmar", "MM", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1036", "Burundi", "BI", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1037", "Cambodia", "KH", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1038", "Cameroon", "CM", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1039", "Canada", "CA", "2", "1"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1040", "Cape Verde", "CV", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1041", "Cayman Islands", "KY", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1042", "Central African Republic", "CF", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1043", "Chad", "TD", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1044", "Chile", "CL", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1045", "China", "CN", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1046", "Christmas Island", "CX", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1047", "Cocos (Keeling) Islands", "CC", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1048", "Colombia", "CO", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1049", "Comoros", "KM", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1050", "Congo, The Democratic Republic of the", "CD", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1051", "Congo, Republic of the", "CG", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1052", "Cook Islands", "CK", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1053", "Costa Rica", "CR", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1054", "Côte d\'Ivoire", "CI", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1055", "Croatia", "HR", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1056", "Cuba", "CU", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1057", "Cyprus", "CY", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1058", "Czech Republic", "CZ", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1059", "Denmark", "DK", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1060", "Djibouti", "DJ", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1061", "Dominica", "DM", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1062", "Dominican Republic", "DO", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1063", "Timor-Leste", "TL", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1064", "Ecuador", "EC", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1065", "Egypt", "EG", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1066", "El Salvador", "SV", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1067", "Equatorial Guinea", "GQ", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1068", "Eritrea", "ER", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1069", "Estonia", "EE", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1070", "Ethiopia", "ET", "5", "0"); --- INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1071", "European Union", "EU", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1072", "Falkland Islands (Malvinas)", "FK", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1073", "Faroe Islands", "FO", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1074", "Fiji", "FJ", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1075", "Finland", "FI", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1076", "France", "FR", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1077", "French Guiana", "GF", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1078", "French Polynesia", "PF", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1079", "French Southern Territories", "TF", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1080", "Gabon", "GA", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1081", "Georgia", "GE", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1082", "Germany", "DE", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1083", "Ghana", "GH", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1084", "Gibraltar", "GI", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1085", "Greece", "GR", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1086", "Greenland", "GL", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1087", "Grenada", "GD", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1088", "Guadeloupe", "GP", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1089", "Guam", "GU", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1090", "Guatemala", "GT", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1091", "Guinea", "GN", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1092", "Guinea-Bissau", "GW", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1093", "Guyana", "GY", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1094", "Haiti", "HT", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1095", "Heard Island and McDonald Islands", "HM", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1096", "Holy See (Vatican City State)", "VA", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1097", "Honduras", "HN", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1098", "Hong Kong", "HK", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1099", "Hungary", "HU", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1100", "Iceland", "IS", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1101", "India", "IN", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1102", "Indonesia", "ID", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1103", "Iran, Islamic Republic of", "IR", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1104", "Iraq", "IQ", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1105", "Ireland", "IE", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1106", "Israel", "IL", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1107", "Italy", "IT", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1108", "Jamaica", "JM", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1109", "Japan", "JP", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1110", "Jordan", "JO", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1111", "Kazakhstan", "KZ", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1112", "Kenya", "KE", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1113", "Kiribati", "KI", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1114", "Korea, Democratic People\'s Republic of", "KP", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1115", "Korea, Republic of", "KR", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1116", "Kuwait", "KW", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1117", "Kyrgyzstan", "KG", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1118", "Lao People\'s Democratic Republic", "LA", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1119", "Latvia", "LV", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1120", "Lebanon", "LB", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1121", "Lesotho", "LS", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1122", "Liberia", "LR", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1123", "Libya", "LY", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1124", "Liechtenstein", "LI", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1125", "Lithuania", "LT", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1126", "Luxembourg", "LU", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1127", "Macao", "MO", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1128", "Macedonia, Republic of", "MK", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1129", "Madagascar", "MG", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1130", "Malawi", "MW", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1131", "Malaysia", "MY", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1132", "Maldives", "MV", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1133", "Mali", "ML", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1134", "Malta", "MT", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1135", "Marshall Islands", "MH", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1136", "Martinique", "MQ", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1137", "Mauritania", "MR", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1138", "Mauritius", "MU", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1139", "Mayotte", "YT", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1140", "Mexico", "MX", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1141", "Micronesia, Federated States of", "FM", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1142", "Moldova", "MD", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1143", "Monaco", "MC", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1144", "Mongolia", "MN", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1145", "Montserrat", "MS", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1146", "Morocco", "MA", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1147", "Mozambique", "MZ", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1148", "Namibia", "NA", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1149", "Nauru", "NR", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1150", "Nepal", "NP", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1152", "Netherlands", "NL", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1153", "New Caledonia", "NC", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1154", "New Zealand", "NZ", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1155", "Nicaragua", "NI", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1156", "Niger", "NE", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1157", "Nigeria", "NG", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1158", "Niue", "NU", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1159", "Norfolk Island", "NF", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1160", "Northern Mariana Islands", "MP", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1161", "Norway", "NO", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1162", "Oman", "OM", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1163", "Pakistan", "PK", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1164", "Palau", "PW", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1165", "Palestinian Territory, Occupied", "PS", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1166", "Panama", "PA", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1167", "Papua New Guinea", "PG", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1168", "Paraguay", "PY", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1169", "Peru", "PE", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1170", "Philippines", "PH", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1171", "Pitcairn", "PN", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1172", "Poland", "PL", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1173", "Portugal", "PT", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1174", "Puerto Rico", "PR", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1175", "Qatar", "QA", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1176", "Romania", "RO", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1177", "Russian Federation", "RU", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1178", "Rwanda", "RW", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1179", "Reunion", "RE", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1180", "Saint Helena", "SH", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1181", "Saint Kitts and Nevis", "KN", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1182", "Saint Lucia", "LC", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1183", "Saint Pierre and Miquelon", "PM", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1184", "Saint Vincent and the Grenadines", "VC", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1185", "Samoa", "WS", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1186", "San Marino", "SM", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1187", "Saudi Arabia", "SA", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1188", "Senegal", "SN", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1189", "Seychelles", "SC", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1190", "Sierra Leone", "SL", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1191", "Singapore", "SG", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1192", "Slovakia", "SK", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1193", "Slovenia", "SI", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1194", "Solomon Islands", "SB", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1195", "Somalia", "SO", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1196", "South Africa", "ZA", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1197", "South Georgia and the South Sandwich Islands", "GS", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1198", "Spain", "ES", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1199", "Sri Lanka", "LK", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1200", "Sudan", "SD", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1201", "Suriname", "SR", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1202", "Svalbard and Jan Mayen", "SJ", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1203", "Swaziland", "SZ", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1204", "Sweden", "SE", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1205", "Switzerland", "CH", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1206", "Syrian Arab Republic", "SY", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1207", "Sao Tome and Principe", "ST", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1208", "Taiwan", "TW", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1209", "Tajikistan", "TJ", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1210", "Tanzania, United Republic of", "TZ", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1211", "Thailand", "TH", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1212", "Bahamas", "BS", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1213", "Gambia", "GM", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1214", "Togo", "TG", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1215", "Tokelau", "TK", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1216", "Tonga", "TO", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1217", "Trinidad and Tobago", "TT", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1218", "Tunisia", "TN", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1219", "Turkey", "TR", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1220", "Turkmenistan", "TM", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1221", "Turks and Caicos Islands", "TC", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1222", "Tuvalu", "TV", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1223", "Uganda", "UG", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1224", "Ukraine", "UA", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1225", "United Arab Emirates", "AE", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1226", "United Kingdom", "GB", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1227", "United States Minor Outlying Islands", "UM", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1228", "United States", "US", "2", "1"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1229", "Uruguay", "UY", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1230", "Uzbekistan", "UZ", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1231", "Vanuatu", "VU", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1232", "Venezuela", "VE", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1233", "Viet Nam", "VN", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1234", "Virgin Islands, U.S.", "VI", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1235", "Wallis and Futuna", "WF", "4", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1236", "Western Sahara", "EH", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1237", "Yemen", "YE", "3", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1238", "Serbia and Montenegro", "CS", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1239", "Zambia", "ZM", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1240", "Zimbabwe", "ZW", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1241", "Åland Islands", "AX", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1242", "Serbia", "RS", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1243", "Montenegro", "ME", "1", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1244", "Jersey", "JE", "99", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1245", "Guernsey", "GG", "99", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1246", "Isle of Man", "IM", "99", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1247", "South Sudan", "SS", "5", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1248", "Curaçao", "CW", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1249", "Sint Maarten (Dutch Part)", "SX", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1250", "Bonaire, Saint Eustatius and Saba", "BQ", "2", "0"); -INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1251", "Kosovo", "XK", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1001", "AFGHANISTAN", "AF", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1002", "ALBANIA", "AL", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1003", "ALGERIA", "DZ", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1004", "AMERICAN SAMOA", "AS", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1005", "ANDORRA", "AD", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1006", "ANGOLA", "AO", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1007", "ANGUILLA", "AI", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1008", "ANTARCTICA", "AQ", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1009", "ANTIGUA AND BARBUDA", "AG", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1010", "ARGENTINA", "AR", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1011", "ARMENIA", "AM", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1012", "ARUBA", "AW", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1013", "AUSTRALIA", "AU", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1014", "AUSTRIA", "AT", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1015", "AZERBAIJAN", "AZ", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1016", "BAHRAIN", "BH", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1017", "BANGLADESH", "BD", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1018", "BARBADOS", "BB", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1019", "BELARUS", "BY", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1020", "BELGIUM", "BE", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1021", "BELIZE", "BZ", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1022", "BENIN", "BJ", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1023", "BERMUDA", "BM", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1024", "BHUTAN", "BT", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1025", "BOLIVIA", "BO", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1026", "BOSNIA AND HERZEGOVINA", "BA", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1027", "BOTSWANA", "BW", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1028", "BOUVET ISLAND", "BV", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1029", "BRAZIL", "BR", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1030", "BRITISH INDIAN OCEAN TERRITORY", "IO", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1031", "VIRGIN ISLANDS, BRITISH", "VG", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1032", "BRUNEI DARUSSALAM", "BN", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1033", "BULGARIA", "BG", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1034", "BURKINA FASO", "BF", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1035", "MYANMAR", "MM", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1036", "BURUNDI", "BI", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1037", "CAMBODIA", "KH", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1038", "CAMEROON", "CM", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1039", "CANADA", "CA", "2", "1"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1040", "CAPE VERDE", "CV", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1041", "CAYMAN ISLANDS", "KY", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1042", "CENTRAL AFRICAN REPUBLIC", "CF", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1043", "CHAD", "TD", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1044", "CHILE", "CL", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1045", "CHINA", "CN", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1046", "CHRISTMAS ISLAND", "CX", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1047", "COCOS (KEELING) ISLANDS", "CC", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1048", "COLOMBIA", "CO", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1049", "COMOROS", "KM", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1050", "CONGO, THE DEMOCRATIC REPUBLIC OF THE", "CD", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1051", "CONGO, REPUBLIC OF THE", "CG", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1052", "COOK ISLANDS", "CK", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1053", "COSTA RICA", "CR", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1054", "CÔTE D\'IVOIRE", "CI", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1055", "CROATIA", "HR", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1056", "CUBA", "CU", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1057", "CYPRUS", "CY", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1058", "CZECH REPUBLIC", "CZ", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1059", "DENMARK", "DK", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1060", "DJIBOUTI", "DJ", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1061", "DOMINICA", "DM", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1062", "DOMINICAN REPUBLIC", "DO", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1063", "TIMOR-LESTE", "TL", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1064", "ECUADOR", "EC", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1065", "EGYPT", "EG", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1066", "EL SALVADOR", "SV", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1067", "EQUATORIAL GUINEA", "GQ", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1068", "ERITREA", "ER", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1069", "ESTONIA", "EE", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1070", "ETHIOPIA", "ET", "5", "0"); +-- INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1071", "EUROPEAN UNION", "EU", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1072", "FALKLAND ISLANDS (MALVINAS)", "FK", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1073", "FAROE ISLANDS", "FO", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1074", "FIJI", "FJ", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1075", "FINLAND", "FI", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1076", "FRANCE", "FR", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1077", "FRENCH GUIANA", "GF", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1078", "FRENCH POLYNESIA", "PF", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1079", "FRENCH SOUTHERN TERRITORIES", "TF", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1080", "GABON", "GA", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1081", "GEORGIA", "GE", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1082", "GERMANY", "DE", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1083", "GHANA", "GH", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1084", "GIBRALTAR", "GI", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1085", "GREECE", "GR", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1086", "GREENLAND", "GL", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1087", "GRENADA", "GD", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1088", "GUADELOUPE", "GP", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1089", "GUAM", "GU", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1090", "GUATEMALA", "GT", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1091", "GUINEA", "GN", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1092", "GUINEA-BISSAU", "GW", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1093", "GUYANA", "GY", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1094", "HAITI", "HT", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1095", "HEARD ISLAND AND MCDONALD ISLANDS", "HM", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1096", "HOLY SEE (VATICAN CITY STATE)", "VA", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1097", "HONDURAS", "HN", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1098", "HONG KONG", "HK", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1099", "HUNGARY", "HU", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1100", "ICELAND", "IS", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1101", "INDIA", "IN", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1102", "INDONESIA", "ID", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1103", "IRAN, ISLAMIC REPUBLIC OF", "IR", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1104", "IRAQ", "IQ", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1105", "IRELAND", "IE", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1106", "ISRAEL", "IL", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1107", "ITALY", "IT", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1108", "JAMAICA", "JM", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1109", "JAPAN", "JP", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1110", "JORDAN", "JO", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1111", "KAZAKHSTAN", "KZ", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1112", "KENYA", "KE", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1113", "KIRIBATI", "KI", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1114", "KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF", "KP", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1115", "KOREA, REPUBLIC OF", "KR", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1116", "KUWAIT", "KW", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1117", "KYRGYZSTAN", "KG", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1118", "LAO PEOPLE\'S DEMOCRATIC REPUBLIC", "LA", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1119", "LATVIA", "LV", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1120", "LEBANON", "LB", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1121", "LESOTHO", "LS", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1122", "LIBERIA", "LR", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1123", "LIBYA", "LY", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1124", "LIECHTENSTEIN", "LI", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1125", "LITHUANIA", "LT", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1126", "LUXEMBOURG", "LU", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1127", "MACAO", "MO", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1128", "MACEDONIA, REPUBLIC OF", "MK", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1129", "MADAGASCAR", "MG", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1130", "MALAWI", "MW", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1131", "MALAYSIA", "MY", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1132", "MALDIVES", "MV", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1133", "MALI", "ML", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1134", "MALTA", "MT", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1135", "MARSHALL ISLANDS", "MH", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1136", "MARTINIQUE", "MQ", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1137", "MAURITANIA", "MR", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1138", "MAURITIUS", "MU", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1139", "MAYOTTE", "YT", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1140", "MEXICO", "MX", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1141", "MICRONESIA, FEDERATED STATES OF", "FM", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1142", "MOLDOVA", "MD", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1143", "MONACO", "MC", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1144", "MONGOLIA", "MN", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1145", "MONTSERRAT", "MS", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1146", "MOROCCO", "MA", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1147", "MOZAMBIQUE", "MZ", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1148", "NAMIBIA", "NA", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1149", "NAURU", "NR", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1150", "NEPAL", "NP", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1152", "NETHERLANDS", "NL", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1153", "NEW CALEDONIA", "NC", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1154", "NEW ZEALAND", "NZ", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1155", "NICARAGUA", "NI", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1156", "NIGER", "NE", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1157", "NIGERIA", "NG", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1158", "NIUE", "NU", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1159", "NORFOLK ISLAND", "NF", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1160", "NORTHERN MARIANA ISLANDS", "MP", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1161", "NORWAY", "NO", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1162", "OMAN", "OM", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1163", "PAKISTAN", "PK", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1164", "PALAU", "PW", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1165", "PALESTINIAN TERRITORY, OCCUPIED", "PS", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1166", "PANAMA", "PA", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1167", "PAPUA NEW GUINEA", "PG", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1168", "PARAGUAY", "PY", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1169", "PERU", "PE", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1170", "PHILIPPINES", "PH", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1171", "PITCAIRN", "PN", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1172", "POLAND", "PL", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1173", "PORTUGAL", "PT", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1174", "PUERTO RICO", "PR", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1175", "QATAR", "QA", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1176", "ROMANIA", "RO", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1177", "RUSSIAN FEDERATION", "RU", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1178", "RWANDA", "RW", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1179", "REUNION", "RE", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1180", "SAINT HELENA", "SH", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1181", "SAINT KITTS AND NEVIS", "KN", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1182", "SAINT LUCIA", "LC", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1183", "SAINT PIERRE AND MIQUELON", "PM", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1184", "SAINT VINCENT AND THE GRENADINES", "VC", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1185", "SAMOA", "WS", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1186", "SAN MARINO", "SM", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1187", "SAUDI ARABIA", "SA", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1188", "SENEGAL", "SN", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1189", "SEYCHELLES", "SC", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1190", "SIERRA LEONE", "SL", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1191", "SINGAPORE", "SG", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1192", "SLOVAKIA", "SK", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1193", "SLOVENIA", "SI", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1194", "SOLOMON ISLANDS", "SB", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1195", "SOMALIA", "SO", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1196", "SOUTH AFRICA", "ZA", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1197", "SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS", "GS", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1198", "SPAIN", "ES", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1199", "SRI LANKA", "LK", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1200", "SUDAN", "SD", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1201", "SURINAME", "SR", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1202", "SVALBARD AND JAN MAYEN", "SJ", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1203", "SWAZILAND", "SZ", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1204", "SWEDEN", "SE", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1205", "SWITZERLAND", "CH", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1206", "SYRIAN ARAB REPUBLIC", "SY", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1207", "SAO TOME AND PRINCIPE", "ST", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1208", "TAIWAN", "TW", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1209", "TAJIKISTAN", "TJ", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1210", "TANZANIA, UNITED REPUBLIC OF", "TZ", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1211", "THAILAND", "TH", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1212", "BAHAMAS", "BS", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1213", "GAMBIA", "GM", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1214", "TOGO", "TG", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1215", "TOKELAU", "TK", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1216", "TONGA", "TO", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1217", "TRINIDAD AND TOBAGO", "TT", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1218", "TUNISIA", "TN", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1219", "TURKEY", "TR", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1220", "TURKMENISTAN", "TM", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1221", "TURKS AND CAICOS ISLANDS", "TC", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1222", "TUVALU", "TV", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1223", "UGANDA", "UG", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1224", "UKRAINE", "UA", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1225", "UNITED ARAB EMIRATES", "AE", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1226", "UNITED KINGDOM", "GB", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1227", "UNITED STATES MINOR OUTLYING ISLANDS", "UM", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1228", "UNITED STATES", "US", "2", "1"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1229", "URUGUAY", "UY", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1230", "UZBEKISTAN", "UZ", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1231", "VANUATU", "VU", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1232", "VENEZUELA", "VE", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1233", "VIET NAM", "VN", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1234", "VIRGIN ISLANDS, U.S.", "VI", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1235", "WALLIS AND FUTUNA", "WF", "4", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1236", "WESTERN SAHARA", "EH", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1237", "YEMEN", "YE", "3", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1238", "SERBIA AND MONTENEGRO", "CS", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1239", "ZAMBIA", "ZM", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1240", "ZIMBABWE", "ZW", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1241", "ÅLAND ISLANDS", "AX", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1242", "SERBIA", "RS", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1243", "MONTENEGRO", "ME", "1", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1244", "JERSEY", "JE", "99", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1245", "GUERNSEY", "GG", "99", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1246", "ISLE OF MAN", "IM", "99", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1247", "SOUTH SUDAN", "SS", "5", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1248", "CURAÇAO", "CW", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1249", "SINT MAARTEN (DUTCH PART)", "SX", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1250", "BONAIRE, SAINT EUSTATIUS AND SABA", "BQ", "2", "0"); +INSERT INTO civicrm_country (id, name,iso_code,region_id,is_province_abbreviated) VALUES("1251", "KOSOVO", "XK", "1", "0"); -- 2.25.1