-- phpMyAdmin SQL Dump -- version 2.6.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Nov 14, 2008 at 08:41 PM -- Server version: 4.1.22 -- PHP Version: 4.4.8-dev -- -- Database: `****` -- -- -------------------------------------------------------- -- -- Table structure for table `jos_vm_country` -- CREATE TABLE `jos_vm_country` ( `country_id` int(11) NOT NULL auto_increment, `zone_id` int(11) NOT NULL default '1', `country_name` varchar(64) default NULL, `country_3_code` varchar(3) default NULL, `country_2_code` varchar(2) default NULL, PRIMARY KEY (`country_id`), KEY `idx_country_name` (`country_name`) ) ENGINE=MyISAM AUTO_INCREMENT=245 DEFAULT CHARSET=utf8 COMMENT='Country records' AUTO_INCREMENT=245 ; -- -- Dumping data for table `jos_vm_country` -- INSERT INTO `jos_vm_country` VALUES (1, 5, 'Afghanistan', 'AFG', 'AF'); INSERT INTO `jos_vm_country` VALUES (2, 3, 'Albania', 'ALB', 'AL'); INSERT INTO `jos_vm_country` VALUES (3, 5, 'Algeria', 'DZA', 'DZ'); INSERT INTO `jos_vm_country` VALUES (4, 5, 'American Samoa', 'ASM', 'AS'); INSERT INTO `jos_vm_country` VALUES (5, 3, 'Andorra', 'AND', 'AD'); INSERT INTO `jos_vm_country` VALUES (6, 5, 'Angola', 'AGO', 'AO'); INSERT INTO `jos_vm_country` VALUES (7, 5, 'Anguilla', 'AIA', 'AI'); INSERT INTO `jos_vm_country` VALUES (8, 5, 'Antarctica', 'ATA', 'AQ'); INSERT INTO `jos_vm_country` VALUES (9, 5, 'Antigua and Barbuda', 'ATG', 'AG'); INSERT INTO `jos_vm_country` VALUES (10, 5, 'Argentina', 'ARG', 'AR'); INSERT INTO `jos_vm_country` VALUES (11, 5, 'Armenia', 'ARM', 'AM'); INSERT INTO `jos_vm_country` VALUES (12, 5, 'Aruba', 'ABW', 'AW'); INSERT INTO `jos_vm_country` VALUES (13, 5, 'Australia', 'AUS', 'AU'); INSERT INTO `jos_vm_country` VALUES (14, 2, 'Austria', 'AUT', 'AT'); INSERT INTO `jos_vm_country` VALUES (15, 5, 'Azerbaijan', 'AZE', 'AZ'); INSERT INTO `jos_vm_country` VALUES (16, 5, 'Bahamas', 'BHS', 'BS'); INSERT INTO `jos_vm_country` VALUES (17, 4, 'Bahrain', 'BHR', 'BH'); INSERT INTO `jos_vm_country` VALUES (18, 5, 'Bangladesh', 'BGD', 'BD'); INSERT INTO `jos_vm_country` VALUES (19, 5, 'Barbados', 'BRB', 'BB'); INSERT INTO `jos_vm_country` VALUES (20, 3, 'Belarus', 'BLR', 'BY'); INSERT INTO `jos_vm_country` VALUES (21, 1, 'Belgium', 'BEL', 'BE'); INSERT INTO `jos_vm_country` VALUES (22, 5, 'Belize', 'BLZ', 'BZ'); INSERT INTO `jos_vm_country` VALUES (23, 5, 'Benin', 'BEN', 'BJ'); INSERT INTO `jos_vm_country` VALUES (24, 5, 'Bermuda', 'BMU', 'BM'); INSERT INTO `jos_vm_country` VALUES (25, 5, 'Bhutan', 'BTN', 'BT'); INSERT INTO `jos_vm_country` VALUES (26, 5, 'Bolivia', 'BOL', 'BO'); INSERT INTO `jos_vm_country` VALUES (27, 3, 'Bosnia and Herzegowina', 'BIH', 'BA'); INSERT INTO `jos_vm_country` VALUES (28, 5, 'Botswana', 'BWA', 'BW'); INSERT INTO `jos_vm_country` VALUES (29, 5, 'Bouvet Island', 'BVT', 'BV'); INSERT INTO `jos_vm_country` VALUES (30, 5, 'Brazil', 'BRA', 'BR'); INSERT INTO `jos_vm_country` VALUES (31, 5, 'British Indian Ocean Territory', 'IOT', 'IO'); INSERT INTO `jos_vm_country` VALUES (32, 4, 'Brunei Darussalam', 'BRN', 'BN'); INSERT INTO `jos_vm_country` VALUES (33, 7, 'Bulgaria', 'BGR', 'BG'); INSERT INTO `jos_vm_country` VALUES (34, 5, 'Burkina Faso', 'BFA', 'BF'); INSERT INTO `jos_vm_country` VALUES (35, 5, 'Burundi', 'BDI', 'BI'); INSERT INTO `jos_vm_country` VALUES (36, 4, 'Cambodia', 'KHM', 'KH'); INSERT INTO `jos_vm_country` VALUES (37, 5, 'Cameroon', 'CMR', 'CM'); INSERT INTO `jos_vm_country` VALUES (38, 4, 'Canada', 'CAN', 'CA'); INSERT INTO `jos_vm_country` VALUES (39, 5, 'Cape Verde', 'CPV', 'CV'); INSERT INTO `jos_vm_country` VALUES (40, 5, 'Cayman Islands', 'CYM', 'KY'); INSERT INTO `jos_vm_country` VALUES (41, 5, 'Central African Republic', 'CAF', 'CF'); INSERT INTO `jos_vm_country` VALUES (42, 5, 'Chad', 'TCD', 'TD'); INSERT INTO `jos_vm_country` VALUES (43, 5, 'Chile', 'CHL', 'CL'); INSERT INTO `jos_vm_country` VALUES (44, 4, 'China', 'CHN', 'CN'); INSERT INTO `jos_vm_country` VALUES (45, 5, 'Christmas Island', 'CXR', 'CX'); INSERT INTO `jos_vm_country` VALUES (46, 5, 'Cocos (Keeling) Islands', 'CCK', 'CC'); INSERT INTO `jos_vm_country` VALUES (47, 5, 'Colombia', 'COL', 'CO'); INSERT INTO `jos_vm_country` VALUES (48, 5, 'Comoros', 'COM', 'KM'); INSERT INTO `jos_vm_country` VALUES (49, 0, 'Congo', 'COG', 'CG'); INSERT INTO `jos_vm_country` VALUES (50, 5, 'Cook Islands', 'COK', 'CK'); INSERT INTO `jos_vm_country` VALUES (51, 5, 'Costa Rica', 'CRI', 'CR'); INSERT INTO `jos_vm_country` VALUES (52, 5, 'Cote D''Ivoire', 'CIV', 'CI'); INSERT INTO `jos_vm_country` VALUES (53, 3, 'Croatia', 'HRV', 'HR'); INSERT INTO `jos_vm_country` VALUES (54, 5, 'Cuba', 'CUB', 'CU'); INSERT INTO `jos_vm_country` VALUES (55, 7, 'Cyprus', 'CYP', 'CY'); INSERT INTO `jos_vm_country` VALUES (56, 7, 'Czech Republic', 'CZE', 'CZ'); INSERT INTO `jos_vm_country` VALUES (57, 2, 'Denmark', 'DNK', 'DK'); INSERT INTO `jos_vm_country` VALUES (58, 5, 'Djibouti', 'DJI', 'DJ'); INSERT INTO `jos_vm_country` VALUES (59, 5, 'Dominica', 'DMA', 'DM'); INSERT INTO `jos_vm_country` VALUES (60, 5, 'Dominican Republic', 'DOM', 'DO'); INSERT INTO `jos_vm_country` VALUES (61, 5, 'East Timor', 'TMP', 'TP'); INSERT INTO `jos_vm_country` VALUES (62, 5, 'Ecuador', 'ECU', 'EC'); INSERT INTO `jos_vm_country` VALUES (63, 5, 'Egypt', 'EGY', 'EG'); INSERT INTO `jos_vm_country` VALUES (64, 5, 'El Salvador', 'SLV', 'SV'); INSERT INTO `jos_vm_country` VALUES (65, 5, 'Equatorial Guinea', 'GNQ', 'GQ'); INSERT INTO `jos_vm_country` VALUES (66, 5, 'Eritrea', 'ERI', 'ER'); INSERT INTO `jos_vm_country` VALUES (67, 7, 'Estonia', 'EST', 'EE'); INSERT INTO `jos_vm_country` VALUES (68, 5, 'Ethiopia', 'ETH', 'ET'); INSERT INTO `jos_vm_country` VALUES (69, 5, 'Falkland Islands (Malvinas)', 'FLK', 'FK'); INSERT INTO `jos_vm_country` VALUES (70, 5, 'Faroe Islands', 'FRO', 'FO'); INSERT INTO `jos_vm_country` VALUES (71, 5, 'Fiji', 'FJI', 'FJ'); INSERT INTO `jos_vm_country` VALUES (72, 7, 'Finland', 'FIN', 'FI'); INSERT INTO `jos_vm_country` VALUES (73, 2, 'France', 'FRA', 'FR'); INSERT INTO `jos_vm_country` VALUES (74, 5, 'France, Metropolitan', 'FXX', 'FX'); INSERT INTO `jos_vm_country` VALUES (75, 5, 'French Guiana', 'GUF', 'GF'); INSERT INTO `jos_vm_country` VALUES (76, 5, 'French Polynesia', 'PYF', 'PF'); INSERT INTO `jos_vm_country` VALUES (77, 5, 'French Southern Territories', 'ATF', 'TF'); INSERT INTO `jos_vm_country` VALUES (78, 5, 'Gabon', 'GAB', 'GA'); INSERT INTO `jos_vm_country` VALUES (79, 5, 'Gambia', 'GMB', 'GM'); INSERT INTO `jos_vm_country` VALUES (80, 5, 'Georgia', 'GEO', 'GE'); INSERT INTO `jos_vm_country` VALUES (81, 1, 'Germany', 'DEU', 'DE'); INSERT INTO `jos_vm_country` VALUES (82, 5, 'Ghana', 'GHA', 'GH'); INSERT INTO `jos_vm_country` VALUES (83, 3, 'Gibraltar', 'GIB', 'GI'); INSERT INTO `jos_vm_country` VALUES (84, 2, 'Greece', 'GRC', 'GR'); INSERT INTO `jos_vm_country` VALUES (85, 5, 'Greenland', 'GRL', 'GL'); INSERT INTO `jos_vm_country` VALUES (86, 5, 'Grenada', 'GRD', 'GD'); INSERT INTO `jos_vm_country` VALUES (87, 5, 'Guadeloupe', 'GLP', 'GP'); INSERT INTO `jos_vm_country` VALUES (88, 5, 'Guam', 'GUM', 'GU'); INSERT INTO `jos_vm_country` VALUES (89, 5, 'Guatemala', 'GTM', 'GT'); INSERT INTO `jos_vm_country` VALUES (90, 5, 'Guinea', 'GIN', 'GN'); INSERT INTO `jos_vm_country` VALUES (91, 5, 'Guinea-bissau', 'GNB', 'GW'); INSERT INTO `jos_vm_country` VALUES (92, 5, 'Guyana', 'GUY', 'GY'); INSERT INTO `jos_vm_country` VALUES (93, 5, 'Haiti', 'HTI', 'HT'); INSERT INTO `jos_vm_country` VALUES (94, 5, 'Heard and Mc Donald Islands', 'HMD', 'HM'); INSERT INTO `jos_vm_country` VALUES (95, 5, 'Honduras', 'HND', 'HN'); INSERT INTO `jos_vm_country` VALUES (96, 4, 'Hong Kong', 'HKG', 'HK'); INSERT INTO `jos_vm_country` VALUES (97, 7, 'Hungary', 'HUN', 'HU'); INSERT INTO `jos_vm_country` VALUES (98, 3, 'Iceland', 'ISL', 'IS'); INSERT INTO `jos_vm_country` VALUES (99, 4, 'India', 'IND', 'IN'); INSERT INTO `jos_vm_country` VALUES (100, 4, 'Indonesia', 'IDN', 'ID'); INSERT INTO `jos_vm_country` VALUES (101, 5, 'Iran (Islamic Republic of)', 'IRN', 'IR'); INSERT INTO `jos_vm_country` VALUES (102, 5, 'Iraq', 'IRQ', 'IQ'); INSERT INTO `jos_vm_country` VALUES (103, 2, 'Ireland', 'IRL', 'IE'); INSERT INTO `jos_vm_country` VALUES (104, 5, 'Israel', 'ISR', 'IL'); INSERT INTO `jos_vm_country` VALUES (105, 2, 'Italy', 'ITA', 'IT'); INSERT INTO `jos_vm_country` VALUES (106, 5, 'Jamaica', 'JAM', 'JM'); INSERT INTO `jos_vm_country` VALUES (107, 4, 'Japan', 'JPN', 'JP'); INSERT INTO `jos_vm_country` VALUES (108, 5, 'Jordan', 'JOR', 'JO'); INSERT INTO `jos_vm_country` VALUES (109, 5, 'Kazakhstan', 'KAZ', 'KZ'); INSERT INTO `jos_vm_country` VALUES (110, 5, 'Kenya', 'KEN', 'KE'); INSERT INTO `jos_vm_country` VALUES (111, 5, 'Kiribati', 'KIR', 'KI'); INSERT INTO `jos_vm_country` VALUES (112, 4, 'Korea, Democratic People''s Republic of', 'PRK', 'KP'); INSERT INTO `jos_vm_country` VALUES (113, 4, 'Korea, Republic of', 'KOR', 'KR'); INSERT INTO `jos_vm_country` VALUES (114, 5, 'Kuwait', 'KWT', 'KW'); INSERT INTO `jos_vm_country` VALUES (115, 5, 'Kyrgyzstan', 'KGZ', 'KG'); INSERT INTO `jos_vm_country` VALUES (116, 5, 'Lao People''s Democratic Republic', 'LAO', 'LA'); INSERT INTO `jos_vm_country` VALUES (117, 7, 'Latvia', 'LVA', 'LV'); INSERT INTO `jos_vm_country` VALUES (118, 5, 'Lebanon', 'LBN', 'LB'); INSERT INTO `jos_vm_country` VALUES (119, 5, 'Lesotho', 'LSO', 'LS'); INSERT INTO `jos_vm_country` VALUES (120, 5, 'Liberia', 'LBR', 'LR'); INSERT INTO `jos_vm_country` VALUES (121, 5, 'Libyan Arab Jamahiriya', 'LBY', 'LY'); INSERT INTO `jos_vm_country` VALUES (122, 3, 'Liechtenstein', 'LIE', 'LI'); INSERT INTO `jos_vm_country` VALUES (123, 7, 'Lithuania', 'LTU', 'LT'); INSERT INTO `jos_vm_country` VALUES (124, 1, 'Luxembourg', 'LUX', 'LU'); INSERT INTO `jos_vm_country` VALUES (125, 4, 'Macau', 'MAC', 'MO'); INSERT INTO `jos_vm_country` VALUES (126, 3, 'Macedonia, The Former Yugoslav Republic of', 'MKD', 'MK'); INSERT INTO `jos_vm_country` VALUES (127, 5, 'Madagascar', 'MDG', 'MG'); INSERT INTO `jos_vm_country` VALUES (128, 5, 'Malawi', 'MWI', 'MW'); INSERT INTO `jos_vm_country` VALUES (129, 4, 'Malaysia', 'MYS', 'MY'); INSERT INTO `jos_vm_country` VALUES (130, 5, 'Maldives', 'MDV', 'MV'); INSERT INTO `jos_vm_country` VALUES (131, 5, 'Mali', 'MLI', 'ML'); INSERT INTO `jos_vm_country` VALUES (132, 7, 'Malta', 'MLT', 'MT'); INSERT INTO `jos_vm_country` VALUES (133, 5, 'Marshall Islands', 'MHL', 'MH'); INSERT INTO `jos_vm_country` VALUES (134, 5, 'Martinique', 'MTQ', 'MQ'); INSERT INTO `jos_vm_country` VALUES (135, 5, 'Mauritania', 'MRT', 'MR'); INSERT INTO `jos_vm_country` VALUES (136, 5, 'Mauritius', 'MUS', 'MU'); INSERT INTO `jos_vm_country` VALUES (137, 5, 'Mayotte', 'MYT', 'YT'); INSERT INTO `jos_vm_country` VALUES (138, 5, 'Mexico', 'MEX', 'MX'); INSERT INTO `jos_vm_country` VALUES (139, 5, 'Micronesia, Federated States of', 'FSM', 'FM'); INSERT INTO `jos_vm_country` VALUES (140, 3, 'Moldova, Republic of', 'MDA', 'MD'); INSERT INTO `jos_vm_country` VALUES (141, 3, 'Monaco', 'MCO', 'MC'); INSERT INTO `jos_vm_country` VALUES (142, 5, 'Mongolia', 'MNG', 'MN'); INSERT INTO `jos_vm_country` VALUES (143, 5, 'Montserrat', 'MSR', 'MS'); INSERT INTO `jos_vm_country` VALUES (144, 5, 'Morocco', 'MAR', 'MA'); INSERT INTO `jos_vm_country` VALUES (145, 5, 'Mozambique', 'MOZ', 'MZ'); INSERT INTO `jos_vm_country` VALUES (146, 5, 'Myanmar', 'MMR', 'MM'); INSERT INTO `jos_vm_country` VALUES (147, 5, 'Namibia', 'NAM', 'NA'); INSERT INTO `jos_vm_country` VALUES (148, 5, 'Nauru', 'NRU', 'NR'); INSERT INTO `jos_vm_country` VALUES (149, 5, 'Nepal', 'NPL', 'NP'); INSERT INTO `jos_vm_country` VALUES (150, 1, 'Netherlands', 'NLD', 'NL'); INSERT INTO `jos_vm_country` VALUES (151, 5, 'Netherlands Antilles', 'ANT', 'AN'); INSERT INTO `jos_vm_country` VALUES (152, 5, 'New Caledonia', 'NCL', 'NC'); INSERT INTO `jos_vm_country` VALUES (153, 5, 'New Zealand', 'NZL', 'NZ'); INSERT INTO `jos_vm_country` VALUES (154, 5, 'Nicaragua', 'NIC', 'NI'); INSERT INTO `jos_vm_country` VALUES (155, 5, 'Niger', 'NER', 'NE'); INSERT INTO `jos_vm_country` VALUES (156, 5, 'Nigeria', 'NGA', 'NG'); INSERT INTO `jos_vm_country` VALUES (157, 5, 'Niue', 'NIU', 'NU'); INSERT INTO `jos_vm_country` VALUES (158, 5, 'Norfolk Island', 'NFK', 'NF'); INSERT INTO `jos_vm_country` VALUES (159, 5, 'Northern Mariana Islands', 'MNP', 'MP'); INSERT INTO `jos_vm_country` VALUES (160, 3, 'Norway', 'NOR', 'NO'); INSERT INTO `jos_vm_country` VALUES (161, 5, 'Oman', 'OMN', 'OM'); INSERT INTO `jos_vm_country` VALUES (162, 5, 'Pakistan', 'PAK', 'PK'); INSERT INTO `jos_vm_country` VALUES (163, 5, 'Palau', 'PLW', 'PW'); INSERT INTO `jos_vm_country` VALUES (164, 5, 'Panama', 'PAN', 'PA'); INSERT INTO `jos_vm_country` VALUES (165, 5, 'Papua New Guinea', 'PNG', 'PG'); INSERT INTO `jos_vm_country` VALUES (166, 5, 'Paraguay', 'PRY', 'PY'); INSERT INTO `jos_vm_country` VALUES (167, 5, 'Peru', 'PER', 'PE'); INSERT INTO `jos_vm_country` VALUES (168, 4, 'Philippines', 'PHL', 'PH'); INSERT INTO `jos_vm_country` VALUES (169, 5, 'Pitcairn', 'PCN', 'PN'); INSERT INTO `jos_vm_country` VALUES (170, 7, 'Poland', 'POL', 'PL'); INSERT INTO `jos_vm_country` VALUES (171, 2, 'Portugal', 'PRT', 'PT'); INSERT INTO `jos_vm_country` VALUES (172, 5, 'Puerto Rico', 'PRI', 'PR'); INSERT INTO `jos_vm_country` VALUES (173, 5, 'Qatar', 'QAT', 'QA'); INSERT INTO `jos_vm_country` VALUES (174, 5, 'Reunion', 'REU', 'RE'); INSERT INTO `jos_vm_country` VALUES (175, 7, 'Romania', 'ROM', 'RO'); INSERT INTO `jos_vm_country` VALUES (176, 5, 'Russian Federation', 'RUS', 'RU'); INSERT INTO `jos_vm_country` VALUES (177, 5, 'Rwanda', 'RWA', 'RW'); INSERT INTO `jos_vm_country` VALUES (178, 5, 'Saint Kitts and Nevis', 'KNA', 'KN'); INSERT INTO `jos_vm_country` VALUES (179, 5, 'Saint Lucia', 'LCA', 'LC'); INSERT INTO `jos_vm_country` VALUES (180, 5, 'Saint Vincent and the Grenadines', 'VCT', 'VC'); INSERT INTO `jos_vm_country` VALUES (181, 5, 'Samoa', 'WSM', 'WS'); INSERT INTO `jos_vm_country` VALUES (182, 3, 'San Marino', 'SMR', 'SM'); INSERT INTO `jos_vm_country` VALUES (183, 5, 'Sao Tome and Principe', 'STP', 'ST'); INSERT INTO `jos_vm_country` VALUES (184, 5, 'Saudi Arabia', 'SAU', 'SA'); INSERT INTO `jos_vm_country` VALUES (185, 5, 'Senegal', 'SEN', 'SN'); INSERT INTO `jos_vm_country` VALUES (186, 5, 'Seychelles', 'SYC', 'SC'); INSERT INTO `jos_vm_country` VALUES (187, 5, 'Sierra Leone', 'SLE', 'SL'); INSERT INTO `jos_vm_country` VALUES (188, 4, 'Singapore', 'SGP', 'SG'); INSERT INTO `jos_vm_country` VALUES (189, 7, 'Slovakia (Slovak Republic)', 'SVK', 'SK'); INSERT INTO `jos_vm_country` VALUES (190, 7, 'Slovenia', 'SVN', 'SI'); INSERT INTO `jos_vm_country` VALUES (191, 5, 'Solomon Islands', 'SLB', 'SB'); INSERT INTO `jos_vm_country` VALUES (192, 5, 'Somalia', 'SOM', 'SO'); INSERT INTO `jos_vm_country` VALUES (193, 5, 'South Africa', 'ZAF', 'ZA'); INSERT INTO `jos_vm_country` VALUES (194, 5, 'South Georgia and the South Sandwich Islands', 'SGS', 'GS'); INSERT INTO `jos_vm_country` VALUES (195, 2, 'Spain', 'ESP', 'ES'); INSERT INTO `jos_vm_country` VALUES (196, 5, 'Sri Lanka', 'LKA', 'LK'); INSERT INTO `jos_vm_country` VALUES (197, 5, 'St. Helena', 'SHN', 'SH'); INSERT INTO `jos_vm_country` VALUES (198, 5, 'St. Pierre and Miquelon', 'SPM', 'PM'); INSERT INTO `jos_vm_country` VALUES (199, 5, 'Sudan', 'SDN', 'SD'); INSERT INTO `jos_vm_country` VALUES (200, 5, 'Suriname', 'SUR', 'SR'); INSERT INTO `jos_vm_country` VALUES (201, 5, 'Svalbard and Jan Mayen Islands', 'SJM', 'SJ'); INSERT INTO `jos_vm_country` VALUES (202, 5, 'Swaziland', 'SWZ', 'SZ'); INSERT INTO `jos_vm_country` VALUES (203, 2, 'Sweden', 'SWE', 'SE'); INSERT INTO `jos_vm_country` VALUES (204, 3, 'Switzerland', 'CHE', 'CH'); INSERT INTO `jos_vm_country` VALUES (205, 5, 'Syrian Arab Republic', 'SYR', 'SY'); INSERT INTO `jos_vm_country` VALUES (206, 4, 'Taiwan', 'TWN', 'TW'); INSERT INTO `jos_vm_country` VALUES (207, 5, 'Tajikistan', 'TJK', 'TJ'); INSERT INTO `jos_vm_country` VALUES (208, 5, 'Tanzania, United Republic of', 'TZA', 'TZ'); INSERT INTO `jos_vm_country` VALUES (209, 4, 'Thailand', 'THA', 'TH'); INSERT INTO `jos_vm_country` VALUES (210, 5, 'Togo', 'TGO', 'TG'); INSERT INTO `jos_vm_country` VALUES (211, 5, 'Tokelau', 'TKL', 'TK'); INSERT INTO `jos_vm_country` VALUES (212, 5, 'Tonga', 'TON', 'TO'); INSERT INTO `jos_vm_country` VALUES (213, 5, 'Trinidad and Tobago', 'TTO', 'TT'); INSERT INTO `jos_vm_country` VALUES (214, 5, 'Tunisia', 'TUN', 'TN'); INSERT INTO `jos_vm_country` VALUES (215, 3, 'Turkey', 'TUR', 'TR'); INSERT INTO `jos_vm_country` VALUES (216, 5, 'Turkmenistan', 'TKM', 'TM'); INSERT INTO `jos_vm_country` VALUES (217, 5, 'Turks and Caicos Islands', 'TCA', 'TC'); INSERT INTO `jos_vm_country` VALUES (218, 5, 'Tuvalu', 'TUV', 'TV'); INSERT INTO `jos_vm_country` VALUES (219, 5, 'Uganda', 'UGA', 'UG'); INSERT INTO `jos_vm_country` VALUES (220, 3, 'Ukraine', 'UKR', 'UA'); INSERT INTO `jos_vm_country` VALUES (221, 5, 'United Arab Emirates', 'ARE', 'AE'); INSERT INTO `jos_vm_country` VALUES (222, 2, 'United Kingdom', 'GBR', 'GB'); INSERT INTO `jos_vm_country` VALUES (223, 4, 'United States', 'USA', 'US'); INSERT INTO `jos_vm_country` VALUES (224, 5, 'United States Minor Outlying Islands', 'UMI', 'UM'); INSERT INTO `jos_vm_country` VALUES (225, 5, 'Uruguay', 'URY', 'UY'); INSERT INTO `jos_vm_country` VALUES (226, 5, 'Uzbekistan', 'UZB', 'UZ'); INSERT INTO `jos_vm_country` VALUES (227, 5, 'Vanuatu', 'VUT', 'VU'); INSERT INTO `jos_vm_country` VALUES (228, 5, 'Vatican City State (Holy See)', 'VAT', 'VA'); INSERT INTO `jos_vm_country` VALUES (229, 5, 'Venezuela', 'VEN', 'VE'); INSERT INTO `jos_vm_country` VALUES (230, 4, 'Viet Nam', 'VNM', 'VN'); INSERT INTO `jos_vm_country` VALUES (231, 5, 'Virgin Islands (British)', 'VGB', 'VG'); INSERT INTO `jos_vm_country` VALUES (232, 5, 'Virgin Islands (U.S.)', 'VIR', 'VI'); INSERT INTO `jos_vm_country` VALUES (233, 5, 'Wallis and Futuna Islands', 'WLF', 'WF'); INSERT INTO `jos_vm_country` VALUES (234, 5, 'Western Sahara', 'ESH', 'EH'); INSERT INTO `jos_vm_country` VALUES (235, 5, 'Yemen', 'YEM', 'YE'); INSERT INTO `jos_vm_country` VALUES (236, 5, 'Yugoslavia', 'YUG', 'YU'); INSERT INTO `jos_vm_country` VALUES (237, 5, 'The Democratic Republic of Congo', 'DRC', 'DC'); INSERT INTO `jos_vm_country` VALUES (238, 5, 'Zambia', 'ZMB', 'ZM'); INSERT INTO `jos_vm_country` VALUES (239, 5, 'Zimbabwe', 'ZWE', 'ZW'); INSERT INTO `jos_vm_country` VALUES (240, 5, 'East Timor', 'XET', 'XE'); INSERT INTO `jos_vm_country` VALUES (241, 5, 'Jersey', 'XJE', 'XJ'); INSERT INTO `jos_vm_country` VALUES (242, 5, 'St. Barthelemy', 'XSB', 'XB'); INSERT INTO `jos_vm_country` VALUES (243, 5, 'St. Eustatius', 'XSE', 'XU'); INSERT INTO `jos_vm_country` VALUES (244, 5, 'Canary Islands', 'XCA', 'XC');