CRM/Upgrade/Incremental/sql/4.7.11.mysql.tpl

   1 {* file to handle db changes in 4.7.11 during upgrade *}
   2
   3 -- CRM-19134 Missing French overseas departments.
   4 INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
   5   (NULL, 1076, "GP", "Guadeloupe"),
   6   (NULL, 1076, "MQ", "Martinique"),
   7   (NULL, 1076, "GF", "Guyane"),
   8   (NULL, 1076, "RE", "La Réunion"),
   9   (NULL, 1076, "YT", "Mayotte");
  10
  11 -- CRM-17663 Fix missing dashboard names
  12 UPDATE civicrm_dashboard SET name = 'activity' WHERE (name IS NULL OR name = '') AND url LIKE "civicrm/dashlet/activity?%";
  13 UPDATE civicrm_dashboard SET name = 'myCases' WHERE (name IS NULL OR name = '') AND url LIKE "civicrm/dashlet/myCases?%";
  14 UPDATE civicrm_dashboard SET name = 'allCases' WHERE (name IS NULL OR name = '') AND url LIKE "civicrm/dashlet/allCases?%";
  15 UPDATE civicrm_dashboard SET name = 'casedashboard' WHERE (name IS NULL OR name = '') AND url LIKE "civicrm/dashlet/casedashboard?%";
  16
  17 -- CRM-19291 Fix names on dashlets where name is an empty string
  18 {if $multilingual}
  19 UPDATE civicrm_dashboard SET name = label_{$locales.0} WHERE name = '';
  20 {else}
  21 UPDATE civicrm_dashboard SET name = label WHERE name = '';
  22 {/if}
  23
  24 -- CRM-18508 Display State/Province in event address in registration emails
  25 {include file='../CRM/Upgrade/4.7.11.msg_template/civicrm_msg_template.tpl'}
  26
  27 -- CRM-19034 Fix Capitlisation of Country names.
  28 UPDATE civicrm_country SET name = "American Samoa" WHERE lower(name) = lower("American Samoa");
  29 UPDATE civicrm_country SET name = "Andorra" WHERE lower(name) = lower("Andorra");
  30 UPDATE civicrm_country SET name = "Angola" WHERE lower(name) = lower("Angola");
  31 UPDATE civicrm_country SET name = "Anguilla" WHERE lower(name) = lower("Anguilla");
  32 UPDATE civicrm_country SET name = "Antarctica" WHERE lower(name) = lower("Antarctica");
  33 UPDATE civicrm_country SET name = "Antigua and Barbuda" WHERE lower(name) = lower("Antigua and Barbuda");
  34 UPDATE civicrm_country SET name = "Argentina" WHERE lower(name) = lower("Argentina");
  35 UPDATE civicrm_country SET name = "Armenia" WHERE lower(name) = lower("Armenia");
  36 UPDATE civicrm_country SET name = "Aruba" WHERE lower(name) = lower("Aruba");
  37 UPDATE civicrm_country SET name = "Australia" WHERE lower(name) = lower("Australia");
  38 UPDATE civicrm_country SET name = "Austria" WHERE lower(name) = lower("Austria");
  39 UPDATE civicrm_country SET name = "Azerbaijan" WHERE lower(name) = lower("Azerbaijan");
  40 UPDATE civicrm_country SET name = "Bahrain" WHERE lower(name) = lower("Bahrain");
  41 UPDATE civicrm_country SET name = "Bangladesh" WHERE lower(name) = lower("Bangladesh");
  42 UPDATE civicrm_country SET name = "Barbados" WHERE lower(name) = lower("Barbados");
  43 UPDATE civicrm_country SET name = "Belarus" WHERE lower(name) = lower("Belarus");
  44 UPDATE civicrm_country SET name = "Belgium" WHERE lower(name) = lower("Belgium");
  45 UPDATE civicrm_country SET name = "Belize" WHERE lower(name) = lower("Belize");
  46 UPDATE civicrm_country SET name = "Benin" WHERE lower(name) = lower("Benin");
  47 UPDATE civicrm_country SET name = "Bermuda" WHERE lower(name) = lower("Bermuda");
  48 UPDATE civicrm_country SET name = "Bhutan" WHERE lower(name) = lower("Bhutan");
  49 UPDATE civicrm_country SET name = "Bolivia" WHERE lower(name) = lower("Bolivia");
  50 UPDATE civicrm_country SET name = "Bosnia and Herzegovina" WHERE lower(name) = lower("Bosnia and Herzegovina");
  51 UPDATE civicrm_country SET name = "Botswana" WHERE lower(name) = lower("Botswana");
  52 UPDATE civicrm_country SET name = "Bouvet Island" WHERE lower(name) = lower("Bouvet Island");
  53 UPDATE civicrm_country SET name = "Brazil" WHERE lower(name) = lower("Brazil");
  54 UPDATE civicrm_country SET name = "British Indian Ocean Territory" WHERE lower(name) = lower("British Indian Ocean Territory");
  55 UPDATE civicrm_country SET name = "Virgin Islands, U.S." WHERE lower(name) = lower("Virgin Islands, U.S.");
  56 UPDATE civicrm_country SET name = "Brunei Darussalam" WHERE lower(name) = lower("Brunei Darussalam");
  57 UPDATE civicrm_country SET name = "Bulgaria" WHERE lower(name) = lower("Bulgaria");
  58 UPDATE civicrm_country SET name = "Burkina Faso" WHERE lower(name) = lower("Burkina Faso");
  59 UPDATE civicrm_country SET name = "Myanmar" WHERE lower(name) = lower("Myanmar");
  60 UPDATE civicrm_country SET name = "Burundi" WHERE lower(name) = lower("Burundi");
  61 UPDATE civicrm_country SET name = "Cambodia" WHERE lower(name) = lower("Cambodia");
  62 UPDATE civicrm_country SET name = "Cameroon" WHERE lower(name) = lower("Cameroon");
  63 UPDATE civicrm_country SET name = "Canada" WHERE lower(name) = lower("Canada");
  64 UPDATE civicrm_country SET name = "Cape Verde" WHERE lower(name) = lower("Cape Verde");
  65 UPDATE civicrm_country SET name = "Cayman Islands" WHERE lower(name) = lower("Cayman Islands");
  66 UPDATE civicrm_country SET name = "Central African Republic" WHERE lower(name) = lower("Central African Republic");
  67 UPDATE civicrm_country SET name = "Chad" WHERE lower(name) = lower("Chad");
  68 UPDATE civicrm_country SET name = "Chile" WHERE lower(name) = lower("Chile");
  69 UPDATE civicrm_country SET name = "China" WHERE lower(name) = lower("China");
  70 UPDATE civicrm_country SET name = "Christmas Island" WHERE lower(name) = lower("Christmas Island");
  71 UPDATE civicrm_country SET name = "Cocos (Keeling) Islands" WHERE lower(name) = lower("Cocos (Keeling) Islands");
  72 UPDATE civicrm_country SET name = "Colombia" WHERE lower(name) = lower("Colombia");
  73 UPDATE civicrm_country SET name = "Comoros" WHERE lower(name) = lower("Comoros");
  74 UPDATE civicrm_country SET name = "Congo, Republic Of The" WHERE lower(name) = lower("Congo, Republic of The");
  75 UPDATE civicrm_country SET name = "Congo, The Democratic Republic of the" WHERE lower(name) = lower("Congo, The Democratic Republic of the");
  76 UPDATE civicrm_country SET name = "Cook Islands" WHERE lower(name) = lower("Cook Islands");
  77 UPDATE civicrm_country SET name = "Costa Rica" WHERE lower(name) = lower("Costa Rica");
  78 UPDATE civicrm_country SET name = "Côte d'Ivoire" WHERE lower(name) = lower("Côte d'Ivoire");
  79 UPDATE civicrm_country SET name = "Croatia" WHERE lower(name) = lower("Croatia");
  80 UPDATE civicrm_country SET name = "Cuba" WHERE lower(name) = lower("Cuba");
  81 UPDATE civicrm_country SET name = "Cyprus" WHERE lower(name) = lower("Cyprus");
  82 UPDATE civicrm_country SET name = "Czech Republic" WHERE lower(name) = lower("Czech Republic");
  83 UPDATE civicrm_country SET name = "Denmark" WHERE lower(name) = lower("Denmark");
  84 UPDATE civicrm_country SET name = "Djibouti" WHERE lower(name) = lower("Djibouti");
  85 UPDATE civicrm_country SET name = "Dominica" WHERE lower(name) = lower("Dominica");
  86 UPDATE civicrm_country SET name = "Dominican Republic" WHERE lower(name) = lower("Dominican Republic");
  87 UPDATE civicrm_country SET name = "Timor-Leste" WHERE lower(name) = lower("Timor-Leste");
  88 UPDATE civicrm_country SET name = "Ecuador" WHERE lower(name) = lower("Ecuador");
  89 UPDATE civicrm_country SET name = "Egypt" WHERE lower(name) = lower("Egypt");
  90 UPDATE civicrm_country SET name = "El Salvador" WHERE lower(name) = lower("El Salvador");
  91 UPDATE civicrm_country SET name = "Equatorial Guinea" WHERE lower(name) = lower("Equatorial Guinea");
  92 UPDATE civicrm_country SET name = "Eritrea" WHERE lower(name) = lower("Eritrea");
  93 UPDATE civicrm_country SET name = "Estonia" WHERE lower(name) = lower("Estonia");
  94 UPDATE civicrm_country SET name = "Ethiopia" WHERE lower(name) = lower("Ethiopia");
  95 UPDATE civicrm_country SET name = "European Union" WHERE lower(name) = lower("European Union");
  96 UPDATE civicrm_country SET name = "Falkland Islands (Malvinas)" WHERE lower(name) = lower("Falkland Islands (Malvinas)");
  97 UPDATE civicrm_country SET name = "Faroe Islands" WHERE lower(name) = lower("Faroe Islands");
  98 UPDATE civicrm_country SET name = "Fiji" WHERE lower(name) = lower("Fiji");
  99 UPDATE civicrm_country SET name = "Finland" WHERE lower(name) = lower("Finland");
 100 UPDATE civicrm_country SET name = "France" WHERE lower(name) = lower("France");
 101 UPDATE civicrm_country SET name = "French Guiana" WHERE lower(name) = lower("French Guiana");
 102 UPDATE civicrm_country SET name = "French Polynesia" WHERE lower(name) = lower("French Polynesia");
 103 UPDATE civicrm_country SET name = "French Southern Territories" WHERE lower(name) = lower("French Southern Territories");
 104 UPDATE civicrm_country SET name = "Gabon" WHERE lower(name) = lower("Gabon");
 105 UPDATE civicrm_country SET name = "Georgia" WHERE lower(name) = lower("Georgia");
 106 UPDATE civicrm_country SET name = "Germany" WHERE lower(name) = lower("Germany");
 107 UPDATE civicrm_country SET name = "Ghana" WHERE lower(name) = lower("Ghana");
 108 UPDATE civicrm_country SET name = "Gibraltar" WHERE lower(name) = lower("Gibraltar");
 109 UPDATE civicrm_country SET name = "Greece" WHERE lower(name) = lower("Greece");
 110 UPDATE civicrm_country SET name = "Greenland" WHERE lower(name) = lower("Greenland");
 111 UPDATE civicrm_country SET name = "Grenada" WHERE lower(name) = lower("Grenada");
 112 UPDATE civicrm_country SET name = "Guadeloupe" WHERE lower(name) = lower("Guadeloupe");
 113 UPDATE civicrm_country SET name = "Guam" WHERE lower(name) = lower("Guam");
 114 UPDATE civicrm_country SET name = "Guatemala" WHERE lower(name) = lower("Guatemala");
 115 UPDATE civicrm_country SET name = "Guinea" WHERE lower(name) = lower("Guinea");
 116 UPDATE civicrm_country SET name = "Guinea-Bissau" WHERE lower(name) = lower("Guinea-Bissau");
 117 UPDATE civicrm_country SET name = "Guyana" WHERE lower(name) = lower("Guyana");
 118 UPDATE civicrm_country SET name = "Haiti" WHERE lower(name) = lower("Haiti");
 119 UPDATE civicrm_country SET name = "Heard Island and McDonald Islands" WHERE lower(name) = lower("Heard Island and McDonald Islands");
 120 UPDATE civicrm_country SET name = "Holy See (Vatican City State)" WHERE lower(name) = lower("Holy See (Vatican City State)");
 121 UPDATE civicrm_country SET name = "Honduras" WHERE lower(name) = lower("Honduras");
 122 UPDATE civicrm_country SET name = "Hong Kong" WHERE lower(name) = lower("Hong Kong");
 123 UPDATE civicrm_country SET name = "Hungary" WHERE lower(name) = lower("Hungary");
 124 UPDATE civicrm_country SET name = "Iceland" WHERE lower(name) = lower("Iceland");
 125 UPDATE civicrm_country SET name = "India" WHERE lower(name) = lower("India");
 126 UPDATE civicrm_country SET name = "Indonesia" WHERE lower(name) = lower("Indonesia");
 127 UPDATE civicrm_country SET name = "Iran, Islamic Republic of" WHERE lower(name) = lower("Iran, Islamic Republic of");
 128 UPDATE civicrm_country SET name = "Iraq" WHERE lower(name) = lower("Iraq");
 129 UPDATE civicrm_country SET name = "Ireland" WHERE lower(name) = lower("Ireland");
 130 UPDATE civicrm_country SET name = "Israel" WHERE lower(name) = lower("Israel");
 131 UPDATE civicrm_country SET name = "Italy" WHERE lower(name) = lower("Italy");
 132 UPDATE civicrm_country SET name = "Jamaica" WHERE lower(name) = lower("Jamaica");
 133 UPDATE civicrm_country SET name = "Japan" WHERE lower(name) = lower("Japan");
 134 UPDATE civicrm_country SET name = "Jordan" WHERE lower(name) = lower("Jordan");
 135 UPDATE civicrm_country SET name = "Kazakhstan" WHERE lower(name) = lower("Kazakhstan");
 136 UPDATE civicrm_country SET name = "Kenya" WHERE lower(name) = lower("Kenya");
 137 UPDATE civicrm_country SET name = "Kiribati" WHERE lower(name) = lower("Kiribati");
 138 UPDATE civicrm_country SET name = "Korea, Democratic People's Republic of" WHERE lower(name) = lower("Korea, Democratic People's Republic of");
 139 UPDATE civicrm_country SET name = "Korea, Republic of" WHERE lower(name) = lower("Korea, Republic of");
 140 UPDATE civicrm_country SET name = "Kuwait" WHERE lower(name) = lower("Kuwait");
 141 UPDATE civicrm_country SET name = "Kyrgyzstan" WHERE lower(name) = lower("Kyrgyzstan");
 142 UPDATE civicrm_country SET name = "Lao People\'s Democratic Republic" WHERE lower(name) = lower("Lao People\'s Democratic Republic");
 143 UPDATE civicrm_country SET name = "Latvia" WHERE lower(name) = lower("Latvia");
 144 UPDATE civicrm_country SET name = "Lebanon" WHERE lower(name) = lower("Lebanon");
 145 UPDATE civicrm_country SET name = "Lesotho" WHERE lower(name) = lower("Lesotho");
 146 UPDATE civicrm_country SET name = "Liberia" WHERE lower(name) = lower("Liberia");
 147 UPDATE civicrm_country SET name = "Libya" WHERE lower(name) = lower("Libya");
 148 UPDATE civicrm_country SET name = "Liechtenstein" WHERE lower(name) = lower("Liechtenstein");
 149 UPDATE civicrm_country SET name = "Lithuania" WHERE lower(name) = lower("Lithuania");
 150 UPDATE civicrm_country SET name = "Luxembourg" WHERE lower(name) = lower("Luxembourg");
 151 UPDATE civicrm_country SET name = "Macao" WHERE lower(name) = lower("Macao");
 152 UPDATE civicrm_country SET name = "Macedonia, Republic of" WHERE lower(name) = lower("Macedonia, Republic of");
 153 UPDATE civicrm_country SET name = "Madagascar" WHERE lower(name) = lower("Madagascar");
 154 UPDATE civicrm_country SET name = "Malawi" WHERE lower(name) = lower("Malawi");
 155 UPDATE civicrm_country SET name = "Malaysia" WHERE lower(name) = lower("Malaysia");
 156 UPDATE civicrm_country SET name = "Maldives" WHERE lower(name) = lower("Maldives");
 157 UPDATE civicrm_country SET name = "Mali" WHERE lower(name) = lower("Mali");
 158 UPDATE civicrm_country SET name = "Malta" WHERE lower(name) = lower("Malta");
 159 UPDATE civicrm_country SET name = "Marshall Islands" WHERE lower(name) = lower("Marshall Islands");
 160 UPDATE civicrm_country SET name = "Martinique" WHERE lower(name) = lower("Martinique");
 161 UPDATE civicrm_country SET name = "Mauritania" WHERE lower(name) = lower("Mauritania");
 162 UPDATE civicrm_country SET name = "Mauritius" WHERE lower(name) = lower("Mauritius");
 163 UPDATE civicrm_country SET name = "Mayotte" WHERE lower(name) = lower("Mayotte");
 164 UPDATE civicrm_country SET name = "Mexico" WHERE lower(name) = lower("Mexico");
 165 UPDATE civicrm_country SET name = "Micronesia, Federated States of" WHERE lower(name) = lower("Micronesia, Federated States of");
 166 UPDATE civicrm_country SET name = "Moldova" WHERE lower(name) = lower("Moldova");
 167 UPDATE civicrm_country SET name = "Monaco" WHERE lower(name) = lower("Monaco");
 168 UPDATE civicrm_country SET name = "Mongolia" WHERE lower(name) = lower("Mongolia");
 169 UPDATE civicrm_country SET name = "Montserrat" WHERE lower(name) = lower("Montserrat");
 170 UPDATE civicrm_country SET name = "Morocco" WHERE lower(name) = lower("Morocco");
 171 UPDATE civicrm_country SET name = "Mozambique" WHERE lower(name) = lower("Mozambique");
 172 UPDATE civicrm_country SET name = "Namibia" WHERE lower(name) = lower("Namibia");
 173 UPDATE civicrm_country SET name = "Nauru" WHERE lower(name) = lower("Nauru");
 174 UPDATE civicrm_country SET name = "Nepal" WHERE lower(name) = lower("Nepal");
 175 UPDATE civicrm_country SET name = "Netherlands" WHERE lower(name) = lower("Netherlands");
 176 UPDATE civicrm_country SET name = "New Caledonia" WHERE lower(name) = lower("New Caledonia");
 177 UPDATE civicrm_country SET name = "New Zealand" WHERE lower(name) = lower("New Zealand");
 178 UPDATE civicrm_country SET name = "Nicaragua" WHERE lower(name) = lower("Nicaragua");
 179 UPDATE civicrm_country SET name = "Niger" WHERE lower(name) = lower("Niger");
 180 UPDATE civicrm_country SET name = "Nigeria" WHERE lower(name) = lower("Nigeria");
 181 UPDATE civicrm_country SET name = "Niue" WHERE lower(name) = lower("Niue");
 182 UPDATE civicrm_country SET name = "Norfolk Island" WHERE lower(name) = lower("Norfolk Island");
 183 UPDATE civicrm_country SET name = "Northern Mariana Islands" WHERE lower(name) = lower("Northern Mariana Islands");
 184 UPDATE civicrm_country SET name = "Norway" WHERE lower(name) = lower("Norway");
 185 UPDATE civicrm_country SET name = "Oman" WHERE lower(name) = lower("Oman");
 186 UPDATE civicrm_country SET name = "Pakistan" WHERE lower(name) = lower("Pakistan");
 187 UPDATE civicrm_country SET name = "Palau" WHERE lower(name) = lower("Palau");
 188 UPDATE civicrm_country SET name = "Palestinian Territory" WHERE lower(name) = lower("Palestinian Territory");
 189 UPDATE civicrm_country SET name = "Panama" WHERE lower(name) = lower("Panama");
 190 UPDATE civicrm_country SET name = "Papua New Guinea" WHERE lower(name) = lower("Papua New Guinea");
 191 UPDATE civicrm_country SET name = "Paraguay" WHERE lower(name) = lower("Paraguay");
 192 UPDATE civicrm_country SET name = "Peru" WHERE lower(name) = lower("Peru");
 193 UPDATE civicrm_country SET name = "Philippines" WHERE lower(name) = lower("Philippines");
 194 UPDATE civicrm_country SET name = "Pitcairn" WHERE lower(name) = lower("Pitcairn");
 195 UPDATE civicrm_country SET name = "Poland" WHERE lower(name) = lower("Poland");
 196 UPDATE civicrm_country SET name = "Portugal" WHERE lower(name) = lower("Portugal");
 197 UPDATE civicrm_country SET name = "Puerto Rico" WHERE lower(name) = lower("Puerto Rico");
 198 UPDATE civicrm_country SET name = "Qatar" WHERE lower(name) = lower("Qatar");
 199 UPDATE civicrm_country SET name = "Romania" WHERE lower(name) = lower("Romania");
 200 UPDATE civicrm_country SET name = "Russian Federation" WHERE lower(name) = lower("Russian Federation");
 201 UPDATE civicrm_country SET name = "Rwanda" WHERE lower(name) = lower("Rwanda");
 202 UPDATE civicrm_country SET name = "Reunion" WHERE lower(name) = lower("Reunion");
 203 UPDATE civicrm_country SET name = "Saint Helena" WHERE lower(name) = lower("Saint Helena");
 204 UPDATE civicrm_country SET name = "Saint Kitts and Nevis" WHERE lower(name) = lower("Saint Kitts and Nevis");
 205 UPDATE civicrm_country SET name = "Saint Lucia" WHERE lower(name) = lower("Saint Lucia");
 206 UPDATE civicrm_country SET name = "Saint Pierre and Miquelon" WHERE lower(name) = lower("Saint Pierre and Miquelon");
 207 UPDATE civicrm_country SET name = "Saint Vincent and the Grenadines" WHERE lower(name) = lower("Saint Vincent and the Grenadines");
 208 UPDATE civicrm_country SET name = "Samoa" WHERE lower(name) = lower("Samoa");
 209 UPDATE civicrm_country SET name = "San Marino" WHERE lower(name) = lower("San Marino");
 210 UPDATE civicrm_country SET name = "Saudi Arabia" WHERE lower(name) = lower("Saudi Arabia");
 211 UPDATE civicrm_country SET name = "Senegal" WHERE lower(name) = lower("Senegal");
 212 UPDATE civicrm_country SET name = "Seychelles" WHERE lower(name) = lower("Seychelles");
 213 UPDATE civicrm_country SET name = "Sierra Leone" WHERE lower(name) = lower("Sierra Leone");
 214 UPDATE civicrm_country SET name = "Singapore" WHERE lower(name) = lower("Singapore");
 215 UPDATE civicrm_country SET name = "Slovakia" WHERE lower(name) = lower("Slovakia");
 216 UPDATE civicrm_country SET name = "Slovenia" WHERE lower(name) = lower("Slovenia");
 217 UPDATE civicrm_country SET name = "Solomon Islands" WHERE lower(name) = lower("Solomon Islands");
 218 UPDATE civicrm_country SET name = "Somalia" WHERE lower(name) = lower("Somalia");
 219 UPDATE civicrm_country SET name = "South Africa" WHERE lower(name) = lower("South Africa");
 220 UPDATE civicrm_country SET name = "South Georgia and the South Sandwich Islands" WHERE lower(name) = lower("South Georgia and the South Sandwich Islands");
 221 UPDATE civicrm_country SET name = "Spain" WHERE lower(name) = lower("Spain");
 222 UPDATE civicrm_country SET name = "Sri Lanka" WHERE lower(name) = lower("Sri Lanka");
 223 UPDATE civicrm_country SET name = "Sudan" WHERE lower(name) = lower("Sudan");
 224 UPDATE civicrm_country SET name = "Suriname" WHERE lower(name) = lower("Suriname");
 225 UPDATE civicrm_country SET name = "Svalbard and Jan Mayen" WHERE lower(name) = lower("Svalbard and Jan Mayen");
 226 UPDATE civicrm_country SET name = "Swaziland" WHERE lower(name) = lower("Swaziland");
 227 UPDATE civicrm_country SET name = "Sweden" WHERE lower(name) = lower("Sweden");
 228 UPDATE civicrm_country SET name = "Switzerland" WHERE lower(name) = lower("Switzerland");
 229 UPDATE civicrm_country SET name = "Syrian Arab Republic" WHERE lower(name) = lower("Syrian Arab Republic");
 230 UPDATE civicrm_country SET name = "Sao Tome and Principe" WHERE lower(name) = lower("Sao Tome and Principe");
 231 UPDATE civicrm_country SET name = "Taiwan" WHERE lower(name) = lower("Taiwan");
 232 UPDATE civicrm_country SET name = "Tajikistan" WHERE lower(name) = lower("Tajikistan");
 233 UPDATE civicrm_country SET name = "Tanzania, United Republic of" WHERE lower(name) = lower("Tanzania, United Republic of");
 234 UPDATE civicrm_country SET name = "Thailand" WHERE lower(name) = lower("Thailand");
 235 UPDATE civicrm_country SET name = "Bahamas" WHERE lower(name) = lower("Bahamas");
 236 UPDATE civicrm_country SET name = "Gambia" WHERE lower(name) = lower("Gambia");
 237 UPDATE civicrm_country SET name = "Togo" WHERE lower(name) = lower("Togo");
 238 UPDATE civicrm_country SET name = "Tokelau" WHERE lower(name) = lower("Tokelau");
 239 UPDATE civicrm_country SET name = "Tonga" WHERE lower(name) = lower("Tonga");
 240 UPDATE civicrm_country SET name = "Trinidad and Tobago" WHERE lower(name) = lower("Trinidad and Tobago");
 241 UPDATE civicrm_country SET name = "Tunisia" WHERE lower(name) = lower("Tunisia");
 242 UPDATE civicrm_country SET name = "Turkey" WHERE lower(name) = lower("Turkey");
 243 UPDATE civicrm_country SET name = "Turkmenistan" WHERE lower(name) = lower("Turkmenistan");
 244 UPDATE civicrm_country SET name = "Turks and Caicos Islands" WHERE lower(name) = lower("Turks and Caicos Islands");
 245 UPDATE civicrm_country SET name = "Tuvalu" WHERE lower(name) = lower("Tuvalu");
 246 UPDATE civicrm_country SET name = "Uganda" WHERE lower(name) = lower("Uganda");
 247 UPDATE civicrm_country SET name = "Ukraine" WHERE lower(name) = lower("Ukraine");
 248 UPDATE civicrm_country SET name = "United Arab Emirates" WHERE lower(name) = lower("United Arab Emirates");
 249 UPDATE civicrm_country SET name = "United Kingdom" WHERE lower(name) = lower("United Kingdom");
 250 UPDATE civicrm_country SET name = "United States Minor Outlying Islands" WHERE lower(name) = lower("United States Minor Outlying Islands");
 251 UPDATE civicrm_country SET name = "United States" WHERE lower(name) = lower("United States");
 252 UPDATE civicrm_country SET name = "Uruguay" WHERE lower(name) = lower("Uruguay");
 253 UPDATE civicrm_country SET name = "Uzbekistan" WHERE lower(name) = lower("Uzbekistan");
 254 UPDATE civicrm_country SET name = "Vanuatu" WHERE lower(name) = lower("Vanuatu");
 255 UPDATE civicrm_country SET name = "Venezuela" WHERE lower(name) = lower("Venezuela");
 256 UPDATE civicrm_country SET name = "Viet Nam" WHERE lower(name) = lower("Viet Nam");
 257 UPDATE civicrm_country SET name = "Virgin Islands, British" WHERE lower(name) = lower("Virgin Islands, British");
 258 UPDATE civicrm_country SET name = "Wallis and Futuna" WHERE lower(name) = lower("Wallis and Futuna");
 259 UPDATE civicrm_country SET name = "Western Sahara" WHERE lower(name) = lower("Western Sahara");
 260 UPDATE civicrm_country SET name = "Yemen" WHERE lower(name) = lower("Yemen");
 261 UPDATE civicrm_country SET name = "Serbia and Montenegro" WHERE lower(name) = lower("Serbia and Montenegro");
 262 UPDATE civicrm_country SET name = "Zambia" WHERE lower(name) = lower("Zambia");
 263 UPDATE civicrm_country SET name = "Zimbabwe" WHERE lower(name) = lower("Zimbabwe");
 264 UPDATE civicrm_country SET name = "Åland Islands" WHERE lower(name) = lower("Åland Islands");
 265 UPDATE civicrm_country SET name = "Serbia" WHERE lower(name) = lower("Serbia");
 266 UPDATE civicrm_country SET name = "Montenegro" WHERE lower(name) = lower("Montenegro");
 267 UPDATE civicrm_country SET name = "Jersey" WHERE lower(name) = lower("Jersey");
 268 UPDATE civicrm_country SET name = "Guernsey" WHERE lower(name) = lower("Guernsey");
 269 UPDATE civicrm_country SET name = "Isle of Man" WHERE lower(name) = lower("Isle of Man");
 270 UPDATE civicrm_country SET name = "South Sudan" WHERE lower(name) = lower("South Sudan");
 271 UPDATE civicrm_country SET name = "Curaçao" WHERE lower(name) = lower("Curaçao");
 272 UPDATE civicrm_country SET name = "Sint Maarten (Dutch Part)" WHERE lower(name) = lower("Sint Maarten (Dutch Part)");
 273 UPDATE civicrm_country SET name = "Bonaire, Saint Eustatius and Saba" WHERE lower(name) = lower("Bonaire, Saint Eustatius and Saba");
 274 UPDATE civicrm_country SET name = "Kosovo" WHERE lower(name) = lower("Kosovo");
 275 UPDATE civicrm_country SET name = "Saint Barthélemy" WHERE lower(name) = lower("Saint Barthélemy");
 276 UPDATE civicrm_country SET name = "Saint Martin (French part)" WHERE lower(name) = lower("Saint Martin (French part)");
 277 UPDATE civicrm_country SET name = "Afghanistan" WHERE lower(name) = lower("Afghanistan");
 278 UPDATE civicrm_country SET name = "Albania" WHERE lower(name) = lower("Albania");
 279 UPDATE civicrm_country SET name = "Algeria" WHERE lower(name) = lower("Algeria");