-- phpMyAdmin SQL Dump -- version 3.3.9.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Mar 18, 2011 at 04:46 AM -- Server version: 5.0.92 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `terabyte_dol703` -- -- -------------------------------------------------------- -- -- Table structure for table `sys_countries` -- DROP TABLE IF EXISTS `sys_countries`; CREATE TABLE IF NOT EXISTS `sys_countries` ( `ISO2` varchar(2) NOT NULL default '', `ISO3` varchar(3) NOT NULL default '', `ISONo` smallint(3) NOT NULL default '0', `Country` varchar(100) NOT NULL default '', `Region` varchar(100) default NULL, `Currency` varchar(100) default NULL, `CurrencyCode` varchar(3) default NULL, PRIMARY KEY (`ISO2`), KEY `CurrencyCode` (`CurrencyCode`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `sys_countries` -- INSERT INTO `sys_countries` (`ISO2`, `ISO3`, `ISONo`, `Country`, `Region`, `Currency`, `CurrencyCode`) VALUES ('AD', 'AND', 20, 'Andorra', 'Europe', 'Euro', 'EUR'), ('AE', 'ARE', 784, 'United Arab Emirates', 'Middle East', 'UAE Dirham', 'AED'), ('AF', 'AFG', 4, 'Afghanistan', 'Asia', 'Afghani', 'AFA'), ('AG', 'ATG', 28, 'Antigua and Barbuda', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'), ('AI', 'AIA', 660, 'Anguilla', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'), ('AL', 'ALB', 8, 'Albania', 'Europe', 'Lek', 'ALL'), ('AM', 'ARM', 51, 'Armenia', 'Commonwealth of Independent States', 'Armenian Dram', 'AMD'), ('AN', 'ANT', 530, 'Netherlands Antilles', 'Central America and the Caribbean', 'Netherlands Antillean guilder', 'ANG'), ('AO', 'AGO', 24, 'Angola', 'Africa', 'Kwanza', 'AOA'), ('AQ', 'ATA', 10, 'Antarctica', 'Antarctic Region', NULL, NULL), ('AR', 'ARG', 32, 'Argentina', 'South America', 'Argentine Peso', 'ARS'), ('AS', 'ASM', 16, 'American Samoa', 'Oceania', 'US Dollar', 'USD'), ('AT', 'AUT', 40, 'Austria', 'Europe', 'Euro', 'EUR'), ('AU', 'AUS', 36, 'Australia', 'Oceania', 'Australian dollar', 'AUD'), ('AW', 'ABW', 533, 'Aruba', 'Central America and the Caribbean', 'Aruban Guilder', 'AWG'), ('AX', 'ALA', 248, 'Aland Islands', 'Europe', 'Euro', 'EUR'), ('AZ', 'AZE', 31, 'Azerbaijan', 'Commonwealth of Independent States', 'Azerbaijani Manat', 'AZM'), ('BA', 'BIH', 70, 'Bosnia and Herzegovina', 'Bosnia and Herzegovina, Europe', 'Convertible Marka', 'BAM'), ('BB', 'BRB', 52, 'Barbados', 'Central America and the Caribbean', 'Barbados Dollar', 'BBD'), ('BD', 'BGD', 50, 'Bangladesh', 'Asia', 'Taka', 'BDT'), ('BE', 'BEL', 56, 'Belgium', 'Europe', 'Euro', 'EUR'), ('BF', 'BFA', 854, 'Burkina Faso', 'Africa', 'CFA Franc BCEAO', 'XOF'), ('BG', 'BGR', 100, 'Bulgaria', 'Europe', 'Lev', 'BGL'), ('BH', 'BHR', 48, 'Bahrain', 'Middle East', 'Bahraini Dinar', 'BHD'), ('BI', 'BDI', 108, 'Burundi', 'Africa', 'Burundi Franc', 'BIF'), ('BJ', 'BEN', 204, 'Benin', 'Africa', 'CFA Franc BCEAO', 'XOF'), ('BL', 'BLM', 652, 'Saint Barthelemy', 'Central America and the Caribbean', 'Euro', 'EUR'), ('BM', 'BMU', 60, 'Bermuda', 'North America', 'Bermudian Dollar', 'BMD'), ('BN', 'BRN', 96, 'Brunei Darussalam', 'Southeast Asia', 'Brunei Dollar', 'BND'), ('BO', 'BOL', 68, 'Bolivia', 'South America', 'Boliviano', 'BOB'), ('BR', 'BRA', 76, 'Brazil', 'South America', 'Brazilian Real', 'BRL'), ('BS', 'BHS', 44, 'The Bahamas', 'Central America and the Caribbean', 'Bahamian Dollar', 'BSD'), ('BT', 'BTN', 64, 'Bhutan', 'Asia', 'Ngultrum', 'BTN'), ('BV', 'BVT', 74, 'Bouvet Island', 'Antarctic Region', 'Norwegian Krone', 'NOK'), ('BW', 'BWA', 72, 'Botswana', 'Africa', 'Pula', 'BWP'), ('BY', 'BLR', 112, 'Belarus', 'Commonwealth of Independent States', 'Belarussian Ruble', 'BYR'), ('BZ', 'BLZ', 84, 'Belize', 'Central America and the Caribbean', 'Belize Dollar', 'BZD'), ('CA', 'CAN', 124, 'Canada', 'North America', 'Canadian Dollar', 'CAD'), ('CC', 'CCK', 166, 'Cocos (Keeling) Islands', 'Southeast Asia', 'Australian Dollar', 'AUD'), ('CD', 'COD', 180, 'Congo, Democratic Republic of the', 'Africa', 'Franc Congolais', 'CDF'), ('CF', 'CAF', 140, 'Central African Republic', 'Africa', 'CFA Franc BEAC', 'XAF'), ('CG', 'COG', 178, 'Congo, Republic of the', 'Africa', 'CFA Franc BEAC', 'XAF'), ('CH', 'CHE', 756, 'Switzerland', 'Europe', 'Swiss Franc', 'CHF'), ('CI', 'CIV', 384, 'Cote d''Ivoire', 'Africa', 'CFA Franc BCEAO', 'XOF'), ('CK', 'COK', 184, 'Cook Islands', 'Oceania', 'New Zealand Dollar', 'NZD'), ('CL', 'CHL', 152, 'Chile', 'South America', 'Chilean Peso', 'CLP'), ('CM', 'CMR', 120, 'Cameroon', 'Africa', 'CFA Franc BEAC', 'XAF'), ('CN', 'CHN', 156, 'China', 'Asia', 'Yuan Renminbi', 'CNY'), ('CO', 'COL', 170, 'Colombia', 'South America, Central America and the Caribbean', 'Colombian Peso', 'COP'), ('CR', 'CRI', 188, 'Costa Rica', 'Central America and the Caribbean', 'Costa Rican Colon', 'CRC'), ('CU', 'CUB', 192, 'Cuba', 'Central America and the Caribbean', 'Cuban Peso', 'CUP'), ('CV', 'CPV', 132, 'Cape Verde', 'World', 'Cape Verdean Escudo', 'CVE'), ('CX', 'CXR', 162, 'Christmas Island', 'Southeast Asia', 'Australian Dollar', 'AUD'), ('CY', 'CYP', 196, 'Cyprus', 'Middle East', 'Cyprus Pound', 'CYP'), ('CZ', 'CZE', 203, 'Czech Republic', 'Europe', 'Czech Koruna', 'CZK'), ('DE', 'DEU', 276, 'Germany', 'Europe', 'Euro', 'EUR'), ('DJ', 'DJI', 262, 'Djibouti', 'Africa', 'Djibouti Franc', 'DJF'), ('DK', 'DNK', 208, 'Denmark', 'Europe', 'Danish Krone', 'DKK'), ('DM', 'DMA', 212, 'Dominica', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'), ('DO', 'DOM', 214, 'Dominican Republic', 'Central America and the Caribbean', 'Dominican Peso', 'DOP'), ('DZ', 'DZA', 12, 'Algeria', 'Africa', 'Algerian Dinar', 'DZD'), ('EC', 'ECU', 218, 'Ecuador', 'South America', 'US dollar', 'USD'), ('EE', 'EST', 233, 'Estonia', 'Europe', 'Kroon', 'EEK'), ('EG', 'EGY', 818, 'Egypt', 'Africa', 'Egyptian Pound', 'EGP'), ('EH', 'ESH', 732, 'Western Sahara', 'Africa', 'Moroccan Dirham', 'MAD'), ('ER', 'ERI', 232, 'Eritrea', 'Africa', 'Nakfa', 'ERN'), ('ES', 'ESP', 724, 'Spain', 'Europe', 'Euro', 'EUR'), ('ET', 'ETH', 231, 'Ethiopia', 'Africa', 'Ethiopian Birr', 'ETB'), ('FI', 'FIN', 246, 'Finland', 'Europe', 'Euro', 'EUR'), ('FJ', 'FJI', 242, 'Fiji', 'Oceania', 'Fijian Dollar', 'FJD'), ('FK', 'FLK', 238, 'Falkland Islands (Islas Malvinas)', 'South America', 'Falkland Islands Pound', 'FKP'), ('FM', 'FSM', 583, 'Micronesia, Federated States of', 'Oceania', 'US dollar', 'USD'), ('FO', 'FRO', 234, 'Faroe Islands', 'Europe', 'Danish Krone', 'DKK'), ('FR', 'FRA', 250, 'France', 'Europe', 'Euro', 'EUR'), ('GA', 'GAB', 266, 'Gabon', 'Africa', 'CFA Franc BEAC', 'XAF'), ('GB', 'GBR', 826, 'United Kingdom', 'Europe', 'Pound Sterling', 'GBP'), ('GD', 'GRD', 308, 'Grenada', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'), ('GE', 'GEO', 268, 'Georgia', 'Commonwealth of Independent States', 'Lari', 'GEL'), ('GF', 'GUF', 254, 'French Guiana', 'South America', 'Euro', 'EUR'), ('GG', 'GGY', 831, 'Guernsey', 'Europe', 'Pound sterling', 'GBP'), ('GH', 'GHA', 288, 'Ghana', 'Africa', 'Cedi', 'GHC'), ('GI', 'GIB', 292, 'Gibraltar', 'Europe', 'Gibraltar Pound', 'GIP'), ('GL', 'GRL', 304, 'Greenland', 'Arctic Region', 'Danish Krone', 'DKK'), ('GM', 'GMB', 270, 'The Gambia', 'Africa', 'Dalasi', 'GMD'), ('GN', 'GIN', 324, 'Guinea', 'Africa', 'Guinean Franc', 'GNF'), ('GP', 'GLP', 312, 'Guadeloupe', 'Central America and the Caribbean', 'Euro', 'EUR'), ('GQ', 'GNQ', 226, 'Equatorial Guinea', 'Africa', 'CFA Franc BEAC', 'XAF'), ('GR', 'GRC', 300, 'Greece', 'Europe', 'Euro', 'EUR'), ('GS', 'SGS', 239, 'South Georgia and the South Sandwich Islands', 'Antarctic Region', 'Pound Sterling', 'GBP'), ('GT', 'GTM', 320, 'Guatemala', 'Central America and the Caribbean', 'Quetzal', 'GTQ'), ('GU', 'GUM', 316, 'Guam', 'Oceania', 'US Dollar', 'USD'), ('GW', 'GNB', 624, 'Guinea-Bissau', 'Africa', 'CFA Franc BCEAO', 'XOF'), ('GY', 'GUY', 328, 'Guyana', 'South America', 'Guyana Dollar', 'GYD'), ('HK', 'HKG', 344, 'Hong Kong (SAR)', 'Southeast Asia', 'Hong Kong Dollar', 'HKD'), ('HM', 'HMD', 334, 'Heard Island and McDonald Islands', 'Antarctic Region', 'Australian Dollar', 'AUD'), ('HN', 'HND', 340, 'Honduras', 'Central America and the Caribbean', 'Lempira', 'HNL'), ('HR', 'HRV', 191, 'Croatia', 'Europe', 'Kuna', 'HRK'), ('HT', 'HTI', 332, 'Haiti', 'Central America and the Caribbean', 'Gourde', 'HTG'), ('HU', 'HUN', 348, 'Hungary', 'Europe', 'Forint', 'HUF'), ('ID', 'IDN', 360, 'Indonesia', 'Southeast Asia', 'Rupiah', 'IDR'), ('IE', 'IRL', 372, 'Ireland', 'Europe', 'Euro', 'EUR'), ('IL', 'ISR', 376, 'Israel', 'Middle East', 'New Israeli Sheqel', 'ILS'), ('IM', 'IMN', 833, 'Isle of Man', 'Europe', 'Pound sterling', 'GBP'), ('IN', 'IND', 356, 'India', 'Asia', 'Indian Rupee', 'INR'), ('IO', 'IOT', 86, 'British Indian Ocean Territory', 'World', 'US Dollar', 'USD'), ('IQ', 'IRQ', 368, 'Iraq', 'Middle East', 'Iraqi Dinar', 'IQD'), ('IR', 'IRN', 364, 'Iran', 'Middle East', 'Iranian Rial', 'IRR'), ('IS', 'ISL', 352, 'Iceland', 'Arctic Region', 'Iceland Krona', 'ISK'), ('IT', 'ITA', 380, 'Italy', 'Europe', 'Euro', 'EUR'), ('JE', 'JEY', 832, 'Jersey', 'Europe', 'Pound sterling', 'GBP'), ('JM', 'JAM', 388, 'Jamaica', 'Central America and the Caribbean', 'Jamaican dollar', 'JMD'), ('JO', 'JOR', 400, 'Jordan', 'Middle East', 'Jordanian Dinar', 'JOD'), ('JP', 'JPN', 392, 'Japan', 'Asia', 'Yen', 'JPY'), ('KE', 'KEN', 404, 'Kenya', 'Africa', 'Kenyan shilling', 'KES'), ('KG', 'KGZ', 417, 'Kyrgyzstan', 'Commonwealth of Independent States', 'Som', 'KGS'), ('KH', 'KHM', 116, 'Cambodia', 'Southeast Asia', 'Riel', 'KHR'), ('KI', 'KIR', 296, 'Kiribati', 'Oceania', 'Australian dollar', 'AUD'), ('KM', 'COM', 174, 'Comoros', 'Africa', 'Comoro Franc', 'KMF'), ('KN', 'KNA', 659, 'Saint Kitts and Nevis', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'), ('KP', 'PRK', 408, 'Korea, North', 'Asia', 'North Korean Won', 'KPW'), ('KR', 'KOR', 410, 'Korea, South', 'Asia', 'Won', 'KRW'), ('KW', 'KWT', 414, 'Kuwait', 'Middle East', 'Kuwaiti Dinar', 'KWD'), ('KY', 'CYM', 136, 'Cayman Islands', 'Central America and the Caribbean', 'Cayman Islands Dollar', 'KYD'), ('KZ', 'KAZ', 398, 'Kazakhstan', 'Commonwealth of Independent States', 'Tenge', 'KZT'), ('LA', 'LAO', 418, 'Laos', 'Southeast Asia', 'Kip', 'LAK'), ('LB', 'LBN', 422, 'Lebanon', 'Middle East', 'Lebanese Pound', 'LBP'), ('LC', 'LCA', 662, 'Saint Lucia', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'), ('LI', 'LIE', 438, 'Liechtenstein', 'Europe', 'Swiss Franc', 'CHF'), ('LK', 'LKA', 144, 'Sri Lanka', 'Asia', 'Sri Lanka Rupee', 'LKR'), ('LR', 'LBR', 430, 'Liberia', 'Africa', 'Liberian Dollar', 'LRD'), ('LS', 'LSO', 426, 'Lesotho', 'Africa', 'Loti', 'LSL'), ('LT', 'LTU', 440, 'Lithuania', 'Europe', 'Lithuanian Litas', 'LTL'), ('LU', 'LUX', 442, 'Luxembourg', 'Europe', 'Euro', 'EUR'), ('LV', 'LVA', 428, 'Latvia', 'Europe', 'Latvian Lats', 'LVL'), ('LY', 'LBY', 434, 'Libya', 'Africa', 'Libyan Dinar', 'LYD'), ('MA', 'MAR', 504, 'Morocco', 'Africa', 'Moroccan Dirham', 'MAD'), ('MC', 'MCO', 492, 'Monaco', 'Europe', 'Euro', 'EUR'), ('MD', 'MDA', 498, 'Moldova', 'Commonwealth of Independent States', 'Moldovan Leu', 'MDL'), ('ME', 'MNE', 499, 'Montenegro', 'Europe', 'Euro', 'EUR'), ('MF', 'MAF', 663, 'Saint Martin (French part)', 'Central America and the Caribbean', 'Euro', 'EUR'), ('MG', 'MDG', 450, 'Madagascar', 'Africa', 'Malagasy Franc', 'MGF'), ('MH', 'MHL', 584, 'Marshall Islands', 'Oceania', 'US dollar', 'USD'), ('MK', 'MKD', 807, 'Macedonia, The Former Yugoslav Republic of', 'Europe', 'Denar', 'MKD'), ('ML', 'MLI', 466, 'Mali', 'Africa', 'CFA Franc BCEAO', 'XOF'), ('MM', 'MMR', 104, 'Myanmar', 'Southeast Asia', 'kyat', 'MMK'), ('MN', 'MNG', 496, 'Mongolia', 'Asia', 'Tugrik', 'MNT'), ('MO', 'MAC', 446, 'Macao', 'Southeast Asia', 'Pataca', 'MOP'), ('MP', 'MNP', 580, 'Northern Mariana Islands', 'Oceania', 'US Dollar', 'USD'), ('MQ', 'MTQ', 474, 'Martinique', 'Central America and the Caribbean', 'Euro', 'EUR'), ('MR', 'MRT', 478, 'Mauritania', 'Africa', 'Ouguiya', 'MRO'), ('MS', 'MSR', 500, 'Montserrat', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'), ('MT', 'MLT', 470, 'Malta', 'Europe', 'Maltese Lira', 'MTL'), ('MU', 'MUS', 480, 'Mauritius', 'World', 'Mauritius Rupee', 'MUR'), ('MV', 'MDV', 462, 'Maldives', 'Asia', 'Rufiyaa', 'MVR'), ('MW', 'MWI', 454, 'Malawi', 'Africa', 'Kwacha', 'MWK'), ('MX', 'MEX', 484, 'Mexico', 'North America', 'Mexican Peso', 'MXN'), ('MY', 'MYS', 458, 'Malaysia', 'Southeast Asia', 'Malaysian Ringgit', 'MYR'), ('MZ', 'MOZ', 508, 'Mozambique', 'Africa', 'Metical', 'MZM'), ('NA', 'NAM', 516, 'Namibia', 'Africa', 'Namibian Dollar', 'NAD'), ('NC', 'NCL', 540, 'New Caledonia', 'Oceania', 'CFP Franc', 'XPF'), ('NE', 'NER', 562, 'Niger', 'Africa', 'CFA Franc BCEAO', 'XOF'), ('NF', 'NFK', 574, 'Norfolk Island', 'Oceania', 'Australian Dollar', 'AUD'), ('NG', 'NGA', 566, 'Nigeria', 'Africa', 'Naira', 'NGN'), ('NI', 'NIC', 558, 'Nicaragua', 'Central America and the Caribbean', 'Cordoba Oro', 'NIO'), ('NL', 'NLD', 528, 'Netherlands', 'Europe', 'Euro', 'EUR'), ('NO', 'NOR', 578, 'Norway', 'Europe', 'Norwegian Krone', 'NOK'), ('NP', 'NPL', 524, 'Nepal', 'Asia', 'Nepalese Rupee', 'NPR'), ('NR', 'NRU', 520, 'Nauru', 'Oceania', 'Australian Dollar', 'AUD'), ('NU', 'NIU', 570, 'Niue', 'Oceania', 'New Zealand Dollar', 'NZD'), ('NZ', 'NZL', 554, 'New Zealand', 'Oceania', 'New Zealand Dollar', 'NZD'), ('OM', 'OMN', 512, 'Oman', 'Middle East', 'Rial Omani', 'OMR'), ('PA', 'PAN', 591, 'Panama', 'Central America and the Caribbean', 'balboa', 'PAB'), ('PE', 'PER', 604, 'Peru', 'South America', 'Nuevo Sol', 'PEN'), ('PF', 'PYF', 258, 'French Polynesia', 'Oceania', 'CFP Franc', 'XPF'), ('PG', 'PNG', 598, 'Papua New Guinea', 'Oceania', 'Kina', 'PGK'), ('PH', 'PHL', 608, 'Philippines', 'Southeast Asia', 'Philippine Peso', 'PHP'), ('PK', 'PAK', 586, 'Pakistan', 'Asia', 'Pakistan Rupee', 'PKR'), ('PL', 'POL', 616, 'Poland', 'Europe', 'Zloty', 'PLN'), ('PM', 'SPM', 666, 'Saint Pierre and Miquelon', 'North America', 'Euro', 'EUR'), ('PN', 'PCN', 612, 'Pitcairn Islands', 'Oceania', 'New Zealand Dollar', 'NZD'), ('PR', 'PRI', 630, 'Puerto Rico', 'Central America and the Caribbean', 'US dollar', 'USD'), ('PS', 'PSE', 275, 'Palestinian Territory, Occupied', NULL, NULL, NULL), ('PT', 'PRT', 620, 'Portugal', 'Europe', 'Euro', 'EUR'), ('PW', 'PLW', 585, 'Palau', 'Oceania', 'US dollar', 'USD'), ('PY', 'PRY', 600, 'Paraguay', 'South America', 'Guarani', 'PYG'), ('QA', 'QAT', 634, 'Qatar', 'Middle East', 'Qatari Rial', 'QAR'), ('RE', 'REU', 638, 'Reunion', 'World', 'Euro', 'EUR'), ('RO', 'ROU', 642, 'Romania', 'Europe', 'Leu', 'ROL'), ('RS', 'SRB', 688, 'Serbia', 'Europe', 'Serbian Dinar', 'RSD'), ('RU', 'RUS', 643, 'Russia', 'Asia', 'Russian Ruble', 'RUB'), ('RW', 'RWA', 646, 'Rwanda', 'Africa', 'Rwanda Franc', 'RWF'), ('SA', 'SAU', 682, 'Saudi Arabia', 'Middle East', 'Saudi Riyal', 'SAR'), ('SB', 'SLB', 90, 'Solomon Islands', 'Oceania', 'Solomon Islands Dollar', 'SBD'), ('SC', 'SYC', 690, 'Seychelles', 'Africa', 'Seychelles Rupee', 'SCR'), ('SD', 'SDN', 736, 'Sudan', 'Africa', 'Sudanese Dinar', 'SDD'), ('SE', 'SWE', 752, 'Sweden', 'Europe', 'Swedish Krona', 'SEK'), ('SG', 'SGP', 702, 'Singapore', 'Southeast Asia', 'Singapore Dollar', 'SGD'), ('SH', 'SHN', 654, 'Saint Helena', 'Africa', 'Saint Helenian Pound', 'SHP'), ('SI', 'SVN', 705, 'Slovenia', 'Europe', 'Tolar', 'SIT'), ('SJ', 'SJM', 744, 'Svalbard', 'Arctic Region', 'Norwegian Krone', 'NOK'), ('SK', 'SVK', 703, 'Slovakia', 'Europe', 'Slovak Koruna', 'SKK'), ('SL', 'SLE', 694, 'Sierra Leone', 'Africa', 'Leone', 'SLL'), ('SM', 'SMR', 674, 'San Marino', 'Europe', 'Euro', 'EUR'), ('SN', 'SEN', 686, 'Senegal', 'Africa', 'CFA Franc BCEAO', 'XOF'), ('SO', 'SOM', 706, 'Somalia', 'Africa', 'Somali Shilling', 'SOS'), ('SR', 'SUR', 740, 'Suriname', 'South America', 'Suriname Guilder', 'SRG'), ('ST', 'STP', 678, 'Sao Tome and Principe', 'Africa', 'Dobra', 'STD'), ('SV', 'SLV', 222, 'El Salvador', 'Central America and the Caribbean', 'El Salvador Colon', 'SVC'), ('SY', 'SYR', 760, 'Syria', 'Middle East', 'Syrian Pound', 'SYP'), ('SZ', 'SWZ', 748, 'Swaziland', 'Africa', 'Lilangeni', 'SZL'), ('TC', 'TCA', 796, 'Turks and Caicos Islands', 'Central America and the Caribbean', 'US Dollar', 'USD'), ('TD', 'TCD', 148, 'Chad', 'Africa', 'CFA Franc BEAC', 'XAF'), ('TF', 'ATF', 260, 'French Southern and Antarctic Lands', 'Antarctic Region', 'Euro', 'EUR'), ('TG', 'TGO', 768, 'Togo', 'Africa', 'CFA Franc BCEAO', 'XOF'), ('TH', 'THA', 764, 'Thailand', 'Southeast Asia', 'Baht', 'THB'), ('TJ', 'TJK', 762, 'Tajikistan', 'Commonwealth of Independent States', 'Somoni', 'TJS'), ('TK', 'TKL', 772, 'Tokelau', 'Oceania', 'New Zealand Dollar', 'NZD'), ('TL', 'TLS', 626, 'East Timor', NULL, 'Timor Escudo', 'TPE'), ('TM', 'TKM', 795, 'Turkmenistan', 'Commonwealth of Independent States', 'Manat', 'TMM'), ('TN', 'TUN', 788, 'Tunisia', 'Africa', 'Tunisian Dinar', 'TND'), ('TO', 'TON', 776, 'Tonga', 'Oceania', 'Pa''anga', 'TOP'), ('TR', 'TUR', 792, 'Turkey', 'Middle East', 'Turkish Lira', 'TRL'), ('TT', 'TTO', 780, 'Trinidad and Tobago', 'Central America and the Caribbean', 'Trinidad and Tobago Dollar', 'TTD'), ('TV', 'TUV', 798, 'Tuvalu', 'Oceania', 'Australian Dollar', 'AUD'), ('TW', 'TWN', 158, 'Taiwan', 'Southeast Asia', 'New Taiwan Dollar', 'TWD'), ('TZ', 'TZA', 834, 'Tanzania', 'Africa', 'Tanzanian Shilling', 'TZS'), ('UA', 'UKR', 804, 'Ukraine', 'Commonwealth of Independent States', 'Hryvnia', 'UAH'), ('UG', 'UGA', 800, 'Uganda', 'Africa', 'Uganda Shilling', 'UGX'), ('UM', 'UMI', 581, 'United States Minor Outlying Islands', NULL, 'US Dollar', 'USD'), ('US', 'USA', 840, 'United States', 'North America', 'US Dollar', 'USD'), ('UY', 'URY', 858, 'Uruguay', 'South America', 'Peso Uruguayo', 'UYU'), ('UZ', 'UZB', 860, 'Uzbekistan', 'Commonwealth of Independent States', 'Uzbekistan Sum', 'UZS'), ('VA', 'VAT', 336, 'Holy See (Vatican City)', 'Europe', 'Euro', 'EUR'), ('VC', 'VCT', 670, 'Saint Vincent and the Grenadines', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'), ('VE', 'VEN', 862, 'Venezuela', 'South America, Central America and the Caribbean', 'Bolivar', 'VEB'), ('VG', 'VGB', 92, 'British Virgin Islands', 'Central America and the Caribbean', 'US dollar', 'USD'), ('VI', 'VIR', 850, 'Virgin Islands', 'Central America and the Caribbean', 'US Dollar', 'USD'), ('VN', 'VNM', 704, 'Vietnam', 'Southeast Asia', 'Dong', 'VND'), ('VU', 'VUT', 548, 'Vanuatu', 'Oceania', 'Vatu', 'VUV'), ('WF', 'WLF', 876, 'Wallis and Futuna', 'Oceania', 'CFP Franc', 'XPF'), ('WS', 'WSM', 882, 'Samoa', 'Oceania', 'Tala', 'WST'), ('YE', 'YEM', 887, 'Yemen', 'Middle East', 'Yemeni Rial', 'YER'), ('YT', 'MYT', 175, 'Mayotte', 'Africa', 'Euro', 'EUR'), ('ZA', 'ZAF', 710, 'South Africa', 'Africa', 'Rand', 'ZAR'), ('ZM', 'ZWB', 894, 'Zambia', 'Africa', 'Kwacha', 'ZMK'), ('ZW', 'ZWE', 716, 'Zimbabwe', 'Africa', 'Zimbabwe Dollar', 'ZWD');