/* 0.9.11-01 Switch to textual representation of timezones */
ALTER TABLE `cot_users` ADD `user_tz` VARCHAR(32) DEFAULT 'GMT' AFTER `user_country`;
 
UPDATE `cot_users` SET `user_tz` = 'Europe/Andorra' WHERE `user_country` = 'ad' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Dubai' WHERE `user_country` = 'ae' AND `user_timezone` = 4.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Kabul' WHERE `user_country` = 'af' AND `user_timezone` = 4.5;
UPDATE `cot_users` SET `user_tz` = 'America/Antigua' WHERE `user_country` = 'ag' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'America/Anguilla' WHERE `user_country` = 'ai' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Tirane' WHERE `user_country` = 'al' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Yerevan' WHERE `user_country` = 'am' AND `user_timezone` = 4.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Luanda' WHERE `user_country` = 'ao' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Antarctica/Rothera' WHERE `user_country` = 'aq' AND `user_timezone` = -3.0;
UPDATE `cot_users` SET `user_tz` = 'Antarctica/Palmer' WHERE `user_country` = 'aq' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Antarctica/Syowa' WHERE `user_country` = 'aq' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'Antarctica/Davis' WHERE `user_country` = 'aq' AND `user_timezone` = 5.0;
UPDATE `cot_users` SET `user_tz` = 'Antarctica/Vostok' WHERE `user_country` = 'aq' AND `user_timezone` = 6.0;
UPDATE `cot_users` SET `user_tz` = 'Antarctica/DumontDUrville' WHERE `user_country` = 'aq' AND `user_timezone` = 10.0;
UPDATE `cot_users` SET `user_tz` = 'Antarctica/Casey' WHERE `user_country` = 'aq' AND `user_timezone` = 11.0;
UPDATE `cot_users` SET `user_tz` = 'Antarctica/McMurdo' WHERE `user_country` = 'aq' AND `user_timezone` = 12.0;
UPDATE `cot_users` SET `user_tz` = 'America/Argentina/Buenos_Aires' WHERE `user_country` = 'ar' AND `user_timezone` = -3.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Pago_Pago' WHERE `user_country` = 'as' AND `user_timezone` = -11.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Vienna' WHERE `user_country` = 'at' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Australia/Perth' WHERE `user_country` = 'au' AND `user_timezone` = 8.0;
UPDATE `cot_users` SET `user_tz` = 'Australia/Adelaide' WHERE `user_country` = 'au' AND `user_timezone` = 9.5;
UPDATE `cot_users` SET `user_tz` = 'Australia/Sydney' WHERE `user_country` = 'au' AND `user_timezone` = 10.0;
UPDATE `cot_users` SET `user_tz` = 'Australia/Lord_Howe' WHERE `user_country` = 'au' AND `user_timezone` = 10.5;
UPDATE `cot_users` SET `user_tz` = 'America/Aruba' WHERE `user_country` = 'aw' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Mariehamn' WHERE `user_country` = 'ax' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Baku' WHERE `user_country` = 'az' AND `user_timezone` = 4.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Sarajevo' WHERE `user_country` = 'ba' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'America/Barbados' WHERE `user_country` = 'bb' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Dhaka' WHERE `user_country` = 'bd' AND `user_timezone` = 6.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Brussels' WHERE `user_country` = 'be' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Ouagadougou' WHERE `user_country` = 'bf' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Sofia' WHERE `user_country` = 'bg' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Bahrain' WHERE `user_country` = 'bh' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Bujumbura' WHERE `user_country` = 'bi' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Porto-Novo' WHERE `user_country` = 'bj' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'America/St_Barthelemy' WHERE `user_country` = 'bl' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Atlantic/Bermuda' WHERE `user_country` = 'bm' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Brunei' WHERE `user_country` = 'bn' AND `user_timezone` = 8.0;
UPDATE `cot_users` SET `user_tz` = 'America/La_Paz' WHERE `user_country` = 'bo' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'America/Kralendijk' WHERE `user_country` = 'bq' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'America/Noronha' WHERE `user_country` = 'br' AND `user_timezone` = -2.0;
UPDATE `cot_users` SET `user_tz` = 'America/Sao_Paulo' WHERE `user_country` = 'br' AND `user_timezone` = -3.0;
UPDATE `cot_users` SET `user_tz` = 'America/Manaus' WHERE `user_country` = 'br' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'America/Nassau' WHERE `user_country` = 'bs' AND `user_timezone` = -5.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Thimphu' WHERE `user_country` = 'bt' AND `user_timezone` = 6.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Gaborone' WHERE `user_country` = 'bw' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Minsk' WHERE `user_country` = 'by' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'America/Belize' WHERE `user_country` = 'bz' AND `user_timezone` = -6.0;
UPDATE `cot_users` SET `user_tz` = 'America/St_Johns' WHERE `user_country` = 'ca' AND `user_timezone` = -3.5;
UPDATE `cot_users` SET `user_tz` = 'America/Halifax' WHERE `user_country` = 'ca' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'America/Toronto' WHERE `user_country` = 'ca' AND `user_timezone` = -5.0;
UPDATE `cot_users` SET `user_tz` = 'America/Winnipeg' WHERE `user_country` = 'ca' AND `user_timezone` = -6.0;
UPDATE `cot_users` SET `user_tz` = 'America/Edmonton' WHERE `user_country` = 'ca' AND `user_timezone` = -7.0;
UPDATE `cot_users` SET `user_tz` = 'America/Vancouver' WHERE `user_country` = 'ca' AND `user_timezone` = -8.0;
UPDATE `cot_users` SET `user_tz` = 'Indian/Cocos' WHERE `user_country` = 'cc' AND `user_timezone` = 6.5;
UPDATE `cot_users` SET `user_tz` = 'Africa/Kinshasa' WHERE `user_country` = 'cd' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Lubumbashi' WHERE `user_country` = 'cd' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Bangui' WHERE `user_country` = 'cf' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Brazzaville' WHERE `user_country` = 'cg' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Zurich' WHERE `user_country` = 'ch' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Abidjan' WHERE `user_country` = 'ci' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Rarotonga' WHERE `user_country` = 'ck' AND `user_timezone` = -10.0;
UPDATE `cot_users` SET `user_tz` = 'America/Santiago' WHERE `user_country` = 'cl' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Easter' WHERE `user_country` = 'cl' AND `user_timezone` = -6.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Douala' WHERE `user_country` = 'cm' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Shanghai' WHERE `user_country` = 'cn' AND `user_timezone` = 8.0;
UPDATE `cot_users` SET `user_tz` = 'America/Bogota' WHERE `user_country` = 'co' AND `user_timezone` = -5.0;
UPDATE `cot_users` SET `user_tz` = 'America/Costa_Rica' WHERE `user_country` = 'cr' AND `user_timezone` = -6.0;
UPDATE `cot_users` SET `user_tz` = 'America/Havana' WHERE `user_country` = 'cu' AND `user_timezone` = -5.0;
UPDATE `cot_users` SET `user_tz` = 'Atlantic/Cape_Verde' WHERE `user_country` = 'cv' AND `user_timezone` = -1.0;
UPDATE `cot_users` SET `user_tz` = 'America/Curacao' WHERE `user_country` = 'cw' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Indian/Christmas' WHERE `user_country` = 'cx' AND `user_timezone` = 7.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Nicosia' WHERE `user_country` = 'cy' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Prague' WHERE `user_country` = 'cz' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Berlin' WHERE `user_country` = 'de' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Djibouti' WHERE `user_country` = 'dj' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Copenhagen' WHERE `user_country` = 'dk' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'America/Dominica' WHERE `user_country` = 'dm' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'America/Santo_Domingo' WHERE `user_country` = 'do' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Algiers' WHERE `user_country` = 'dz' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'America/Guayaquil' WHERE `user_country` = 'ec' AND `user_timezone` = -5.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Galapagos' WHERE `user_country` = 'ec' AND `user_timezone` = -6.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Tallinn' WHERE `user_country` = 'ee' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Cairo' WHERE `user_country` = 'eg' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/El_Aaiun' WHERE `user_country` = 'eh' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Asmara' WHERE `user_country` = 'er' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'Atlantic/Canary' WHERE `user_country` = 'es' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Madrid' WHERE `user_country` = 'es' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Addis_Ababa' WHERE `user_country` = 'et' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Helsinki' WHERE `user_country` = 'fi' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Fiji' WHERE `user_country` = 'fj' AND `user_timezone` = 12.0;
UPDATE `cot_users` SET `user_tz` = 'Atlantic/Stanley' WHERE `user_country` = 'fk' AND `user_timezone` = -3.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Chuuk' WHERE `user_country` = 'fm' AND `user_timezone` = 10.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Pohnpei' WHERE `user_country` = 'fm' AND `user_timezone` = 11.0;
UPDATE `cot_users` SET `user_tz` = 'Atlantic/Faroe' WHERE `user_country` = 'fo' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Paris' WHERE `user_country` = 'fr' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Libreville' WHERE `user_country` = 'ga' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'America/Grenada' WHERE `user_country` = 'gd' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Tbilisi' WHERE `user_country` = 'ge' AND `user_timezone` = 4.0;
UPDATE `cot_users` SET `user_tz` = 'America/Cayenne' WHERE `user_country` = 'gf' AND `user_timezone` = -3.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Guernsey' WHERE `user_country` = 'gg' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Accra' WHERE `user_country` = 'gh' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Gibraltar' WHERE `user_country` = 'gi' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'America/Scoresbysund' WHERE `user_country` = 'gl' AND `user_timezone` = -1.0;
UPDATE `cot_users` SET `user_tz` = 'America/Godthab' WHERE `user_country` = 'gl' AND `user_timezone` = -3.0;
UPDATE `cot_users` SET `user_tz` = 'America/Thule' WHERE `user_country` = 'gl' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'America/Danmarkshavn' WHERE `user_country` = 'gl' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Banjul' WHERE `user_country` = 'gm' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Conakry' WHERE `user_country` = 'gn' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'America/Guadeloupe' WHERE `user_country` = 'gp' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Malabo' WHERE `user_country` = 'gq' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Athens' WHERE `user_country` = 'gr' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Atlantic/South_Georgia' WHERE `user_country` = 'gs' AND `user_timezone` = -2.0;
UPDATE `cot_users` SET `user_tz` = 'America/Guatemala' WHERE `user_country` = 'gt' AND `user_timezone` = -6.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Guam' WHERE `user_country` = 'gu' AND `user_timezone` = 10.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Bissau' WHERE `user_country` = 'gw' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'America/Guyana' WHERE `user_country` = 'gy' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Hong_Kong' WHERE `user_country` = 'hk' AND `user_timezone` = 8.0;
UPDATE `cot_users` SET `user_tz` = 'America/Tegucigalpa' WHERE `user_country` = 'hn' AND `user_timezone` = -6.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Zagreb' WHERE `user_country` = 'hr' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'America/Port-au-Prince' WHERE `user_country` = 'ht' AND `user_timezone` = -5.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Budapest' WHERE `user_country` = 'hu' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Jakarta' WHERE `user_country` = 'id' AND `user_timezone` = 7.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Makassar' WHERE `user_country` = 'id' AND `user_timezone` = 8.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Jayapura' WHERE `user_country` = 'id' AND `user_timezone` = 9.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Dublin' WHERE `user_country` = 'ie' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Jerusalem' WHERE `user_country` = 'il' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Isle_of_Man' WHERE `user_country` = 'im' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Kolkata' WHERE `user_country` = 'in' AND `user_timezone` = 5.5;
UPDATE `cot_users` SET `user_tz` = 'Indian/Chagos' WHERE `user_country` = 'io' AND `user_timezone` = 6.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Baghdad' WHERE `user_country` = 'iq' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Tehran' WHERE `user_country` = 'ir' AND `user_timezone` = 3.5;
UPDATE `cot_users` SET `user_tz` = 'Atlantic/Reykjavik' WHERE `user_country` = 'is' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Rome' WHERE `user_country` = 'it' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Jersey' WHERE `user_country` = 'je' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'America/Jamaica' WHERE `user_country` = 'jm' AND `user_timezone` = -5.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Amman' WHERE `user_country` = 'jo' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Tokyo' WHERE `user_country` = 'jp' AND `user_timezone` = 9.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Nairobi' WHERE `user_country` = 'ke' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Bishkek' WHERE `user_country` = 'kg' AND `user_timezone` = 6.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Phnom_Penh' WHERE `user_country` = 'kh' AND `user_timezone` = 7.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Tarawa' WHERE `user_country` = 'ki' AND `user_timezone` = 12.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Enderbury' WHERE `user_country` = 'ki' AND `user_timezone` = 13.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Kiritimati' WHERE `user_country` = 'ki' AND `user_timezone` = 14.0;
UPDATE `cot_users` SET `user_tz` = 'Indian/Comoro' WHERE `user_country` = 'km' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'America/St_Kitts' WHERE `user_country` = 'kn' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Pyongyang' WHERE `user_country` = 'kp' AND `user_timezone` = 9.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Seoul' WHERE `user_country` = 'kr' AND `user_timezone` = 9.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Kuwait' WHERE `user_country` = 'kw' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'America/Cayman' WHERE `user_country` = 'ky' AND `user_timezone` = -5.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Oral' WHERE `user_country` = 'kz' AND `user_timezone` = 5.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Almaty' WHERE `user_country` = 'kz' AND `user_timezone` = 6.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Vientiane' WHERE `user_country` = 'la' AND `user_timezone` = 7.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Beirut' WHERE `user_country` = 'lb' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'America/St_Lucia' WHERE `user_country` = 'lc' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Vaduz' WHERE `user_country` = 'li' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Colombo' WHERE `user_country` = 'lk' AND `user_timezone` = 5.5;
UPDATE `cot_users` SET `user_tz` = 'Africa/Monrovia' WHERE `user_country` = 'lr' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Maseru' WHERE `user_country` = 'ls' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Vilnius' WHERE `user_country` = 'lt' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Luxembourg' WHERE `user_country` = 'lu' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Riga' WHERE `user_country` = 'lv' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Tripoli' WHERE `user_country` = 'ly' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Casablanca' WHERE `user_country` = 'ma' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Monaco' WHERE `user_country` = 'mc' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Chisinau' WHERE `user_country` = 'md' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Podgorica' WHERE `user_country` = 'me' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'America/Marigot' WHERE `user_country` = 'mf' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Indian/Antananarivo' WHERE `user_country` = 'mg' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Majuro' WHERE `user_country` = 'mh' AND `user_timezone` = 12.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Skopje' WHERE `user_country` = 'mk' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Bamako' WHERE `user_country` = 'ml' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Rangoon' WHERE `user_country` = 'mm' AND `user_timezone` = 6.5;
UPDATE `cot_users` SET `user_tz` = 'Asia/Hovd' WHERE `user_country` = 'mn' AND `user_timezone` = 7.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Ulaanbaatar' WHERE `user_country` = 'mn' AND `user_timezone` = 8.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Macau' WHERE `user_country` = 'mo' AND `user_timezone` = 8.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Saipan' WHERE `user_country` = 'mp' AND `user_timezone` = 10.0;
UPDATE `cot_users` SET `user_tz` = 'America/Martinique' WHERE `user_country` = 'mq' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Nouakchott' WHERE `user_country` = 'mr' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'America/Montserrat' WHERE `user_country` = 'ms' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Malta' WHERE `user_country` = 'mt' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Indian/Mauritius' WHERE `user_country` = 'mu' AND `user_timezone` = 4.0;
UPDATE `cot_users` SET `user_tz` = 'Indian/Maldives' WHERE `user_country` = 'mv' AND `user_timezone` = 5.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Blantyre' WHERE `user_country` = 'mw' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'America/Mexico_City' WHERE `user_country` = 'mx' AND `user_timezone` = -6.0;
UPDATE `cot_users` SET `user_tz` = 'America/Chihuahua' WHERE `user_country` = 'mx' AND `user_timezone` = -7.0;
UPDATE `cot_users` SET `user_tz` = 'America/Tijuana' WHERE `user_country` = 'mx' AND `user_timezone` = -8.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Kuala_Lumpur' WHERE `user_country` = 'my' AND `user_timezone` = 8.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Maputo' WHERE `user_country` = 'mz' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Windhoek' WHERE `user_country` = 'na' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Noumea' WHERE `user_country` = 'nc' AND `user_timezone` = 11.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Niamey' WHERE `user_country` = 'ne' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Norfolk' WHERE `user_country` = 'nf' AND `user_timezone` = 11.5;
UPDATE `cot_users` SET `user_tz` = 'Africa/Lagos' WHERE `user_country` = 'ng' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'America/Managua' WHERE `user_country` = 'ni' AND `user_timezone` = -6.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Amsterdam' WHERE `user_country` = 'nl' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Oslo' WHERE `user_country` = 'no' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Nauru' WHERE `user_country` = 'nr' AND `user_timezone` = 12.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Niue' WHERE `user_country` = 'nu' AND `user_timezone` = -11.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Auckland' WHERE `user_country` = 'nz' AND `user_timezone` = 12.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Muscat' WHERE `user_country` = 'om' AND `user_timezone` = 4.0;
UPDATE `cot_users` SET `user_tz` = 'America/Panama' WHERE `user_country` = 'pa' AND `user_timezone` = -5.0;
UPDATE `cot_users` SET `user_tz` = 'America/Lima' WHERE `user_country` = 'pe' AND `user_timezone` = -5.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Gambier' WHERE `user_country` = 'pf' AND `user_timezone` = -9.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Marquesas' WHERE `user_country` = 'pf' AND `user_timezone` = -9.5;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Tahiti' WHERE `user_country` = 'pf' AND `user_timezone` = -10.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Port_Moresby' WHERE `user_country` = 'pg' AND `user_timezone` = 10.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Manila' WHERE `user_country` = 'ph' AND `user_timezone` = 8.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Karachi' WHERE `user_country` = 'pk' AND `user_timezone` = 5.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Warsaw' WHERE `user_country` = 'pl' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'America/Miquelon' WHERE `user_country` = 'pm' AND `user_timezone` = -3.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Pitcairn' WHERE `user_country` = 'pn' AND `user_timezone` = -8.0;
UPDATE `cot_users` SET `user_tz` = 'America/Puerto_Rico' WHERE `user_country` = 'pr' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Gaza' WHERE `user_country` = 'ps' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Atlantic/Azores' WHERE `user_country` = 'pt' AND `user_timezone` = -1.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Lisbon' WHERE `user_country` = 'pt' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Palau' WHERE `user_country` = 'pw' AND `user_timezone` = 9.0;
UPDATE `cot_users` SET `user_tz` = 'America/Asuncion' WHERE `user_country` = 'py' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Qatar' WHERE `user_country` = 'qa' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'Indian/Reunion' WHERE `user_country` = 're' AND `user_timezone` = 4.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Bucharest' WHERE `user_country` = 'ro' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Belgrade' WHERE `user_country` = 'rs' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Kaliningrad' WHERE `user_country` = 'ru' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Moscow' WHERE `user_country` = 'ru' AND `user_timezone` = 4.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Yekaterinburg' WHERE `user_country` = 'ru' AND `user_timezone` = 6.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Omsk' WHERE `user_country` = 'ru' AND `user_timezone` = 7.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Krasnoyarsk' WHERE `user_country` = 'ru' AND `user_timezone` = 8.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Irkutsk' WHERE `user_country` = 'ru' AND `user_timezone` = 9.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Yakutsk' WHERE `user_country` = 'ru' AND `user_timezone` = 10.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Vladivostok' WHERE `user_country` = 'ru' AND `user_timezone` = 11.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Magadan' WHERE `user_country` = 'ru' AND `user_timezone` = 12.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Kigali' WHERE `user_country` = 'rw' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Riyadh' WHERE `user_country` = 'sa' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Guadalcanal' WHERE `user_country` = 'sb' AND `user_timezone` = 11.0;
UPDATE `cot_users` SET `user_tz` = 'Indian/Mahe' WHERE `user_country` = 'sc' AND `user_timezone` = 4.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Khartoum' WHERE `user_country` = 'sd' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Stockholm' WHERE `user_country` = 'se' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Singapore' WHERE `user_country` = 'sg' AND `user_timezone` = 8.0;
UPDATE `cot_users` SET `user_tz` = 'Atlantic/St_Helena' WHERE `user_country` = 'sh' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Ljubljana' WHERE `user_country` = 'si' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Arctic/Longyearbyen' WHERE `user_country` = 'sj' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Bratislava' WHERE `user_country` = 'sk' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Freetown' WHERE `user_country` = 'sl' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/San_Marino' WHERE `user_country` = 'sm' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Dakar' WHERE `user_country` = 'sn' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Mogadishu' WHERE `user_country` = 'so' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'America/Paramaribo' WHERE `user_country` = 'sr' AND `user_timezone` = -3.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Juba' WHERE `user_country` = 'ss' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Sao_Tome' WHERE `user_country` = 'st' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'America/El_Salvador' WHERE `user_country` = 'sv' AND `user_timezone` = -6.0;
UPDATE `cot_users` SET `user_tz` = 'America/Lower_Princes' WHERE `user_country` = 'sx' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Damascus' WHERE `user_country` = 'sy' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Mbabane' WHERE `user_country` = 'sz' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'America/Grand_Turk' WHERE `user_country` = 'tc' AND `user_timezone` = -5.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Ndjamena' WHERE `user_country` = 'td' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Indian/Kerguelen' WHERE `user_country` = 'tf' AND `user_timezone` = 5.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Lome' WHERE `user_country` = 'tg' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Bangkok' WHERE `user_country` = 'th' AND `user_timezone` = 7.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Dushanbe' WHERE `user_country` = 'tj' AND `user_timezone` = 5.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Fakaofo' WHERE `user_country` = 'tk' AND `user_timezone` = 14.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Dili' WHERE `user_country` = 'tl' AND `user_timezone` = 9.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Ashgabat' WHERE `user_country` = 'tm' AND `user_timezone` = 5.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Tunis' WHERE `user_country` = 'tn' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Tongatapu' WHERE `user_country` = 'to' AND `user_timezone` = 13.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Istanbul' WHERE `user_country` = 'tr' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'America/Port_of_Spain' WHERE `user_country` = 'tt' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Funafuti' WHERE `user_country` = 'tv' AND `user_timezone` = 12.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Taipei' WHERE `user_country` = 'tw' AND `user_timezone` = 8.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Dar_es_Salaam' WHERE `user_country` = 'tz' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Kiev' WHERE `user_country` = 'ua' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Kampala' WHERE `user_country` = 'ug' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/London' WHERE `user_country` = 'uk' AND `user_timezone` = 0.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Johnston' WHERE `user_country` = 'um' AND `user_timezone` = -10.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Midway' WHERE `user_country` = 'um' AND `user_timezone` = -11.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Wake' WHERE `user_country` = 'um' AND `user_timezone` = 12.0;
UPDATE `cot_users` SET `user_tz` = 'America/New_York' WHERE `user_country` = 'us' AND `user_timezone` = -5.0;
UPDATE `cot_users` SET `user_tz` = 'America/Chicago' WHERE `user_country` = 'us' AND `user_timezone` = -6.0;
UPDATE `cot_users` SET `user_tz` = 'America/Phoenix' WHERE `user_country` = 'us' AND `user_timezone` = -7.0;
UPDATE `cot_users` SET `user_tz` = 'America/Los_Angeles' WHERE `user_country` = 'us' AND `user_timezone` = -8.0;
UPDATE `cot_users` SET `user_tz` = 'America/Anchorage' WHERE `user_country` = 'us' AND `user_timezone` = -9.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Honolulu' WHERE `user_country` = 'us' AND `user_timezone` = -10.0;
UPDATE `cot_users` SET `user_tz` = 'America/Montevideo' WHERE `user_country` = 'uy' AND `user_timezone` = -3.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Samarkand' WHERE `user_country` = 'uz' AND `user_timezone` = 5.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Tashkent' WHERE `user_country` = 'uz' AND `user_timezone` = 5.0;
UPDATE `cot_users` SET `user_tz` = 'Europe/Vatican' WHERE `user_country` = 'va' AND `user_timezone` = 1.0;
UPDATE `cot_users` SET `user_tz` = 'America/St_Vincent' WHERE `user_country` = 'vc' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'America/Caracas' WHERE `user_country` = 've' AND `user_timezone` = -4.5;
UPDATE `cot_users` SET `user_tz` = 'America/Tortola' WHERE `user_country` = 'vg' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'America/St_Thomas' WHERE `user_country` = 'vi' AND `user_timezone` = -4.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Ho_Chi_Minh' WHERE `user_country` = 'vn' AND `user_timezone` = 7.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Efate' WHERE `user_country` = 'vu' AND `user_timezone` = 11.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Wallis' WHERE `user_country` = 'wf' AND `user_timezone` = 12.0;
UPDATE `cot_users` SET `user_tz` = 'Pacific/Apia' WHERE `user_country` = 'ws' AND `user_timezone` = 13.0;
UPDATE `cot_users` SET `user_tz` = 'Asia/Aden' WHERE `user_country` = 'ye' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'Indian/Mayotte' WHERE `user_country` = 'yt' AND `user_timezone` = 3.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Johannesburg' WHERE `user_country` = 'za' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Lusaka' WHERE `user_country` = 'zm' AND `user_timezone` = 2.0;
UPDATE `cot_users` SET `user_tz` = 'Africa/Harare' WHERE `user_country` = 'zw' AND `user_timezone` = 2.0;

ALTER TABLE `cot_users` DROP `user_timezone`;
ALTER TABLE `cot_users` CHANGE `user_tz` `user_timezone` VARCHAR(32) DEFAULT 'GMT';