PHP Classes

File: countries.sql

Recommend this page to a friend!
  Classes of Mubashir Ali   Complete Pagination   countries.sql   Download  
File: countries.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL table for Countries - to test pagination of DB
Class: Complete Pagination
Generate links or buttons to browse paged listings
Author: By
Last change:
Date: 12 years ago
Size: 21,561 bytes
 

Contents

Class file image Download
-- ---------------------------- -- Table structure for `countries` -- ---------------------------- DROP TABLE IF EXISTS `countries`; CREATE TABLE `countries` ( `ID` smallint(5) unsigned NOT NULL auto_increment, `Country` varchar(255) NOT NULL, `CountryAbbrev` varchar(10) default NULL, `CurrencyAbbr` varchar(4) default NULL, `CurrencyRate` float default NULL, `CurrencyCode` varchar(3) default NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=289 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of countries -- ---------------------------- INSERT INTO `countries` VALUES ('1', 'Albania', 'AL', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('2', 'Algeria', 'DZ', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('3', 'American Samoa', 'AS', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('4', 'Andorra', 'AD', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('5', 'Angola', 'AO', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('6', 'Anguilla', 'AI', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('8', 'Antigua', 'AG', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('9', 'Argentina', 'AR', 'ARP', '4.23', '032'); INSERT INTO `countries` VALUES ('10', 'Armenia', 'AM', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('11', 'Aruba', 'AW', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('12', 'Australia', 'AU', 'AUD', '0.98', '036'); INSERT INTO `countries` VALUES ('13', 'Austria', 'AT', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('14', 'Azerbaijan', 'AZ', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('15', 'Azores', '', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('16', 'Bahamas', 'BS', 'BSD', '1.05', '044'); INSERT INTO `countries` VALUES ('17', 'Bahrain', 'BH', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('18', 'Bangladesh', 'BD', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('19', 'Barbados', 'BB', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('20', 'Belarus', 'BY', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('21', 'Belgium', 'BE', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('22', 'Belize', 'BZ', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('23', 'Benin', 'BJ', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('24', 'Bermuda', 'BM', 'BMD', '1.05', '060'); INSERT INTO `countries` VALUES ('25', 'Bhutan', 'BT', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('26', 'Bonaire', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('27', 'Bolivia', 'BO', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('28', 'Bosnia', 'BA', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('29', 'Botswana', 'BW', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('31', 'Brazil', 'BR', 'BRL', '1.65', '986'); INSERT INTO `countries` VALUES ('33', 'Brunei Darussalam', 'BN', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('34', 'Bulgaria', 'BG', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('35', 'Burkina Faso', 'BF', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('36', 'Burundi', 'BI', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('37', 'Caicos Islands', 'TC', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('38', 'Cambodia', 'KH', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('39', 'Cameroon', 'CM', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('40', 'Canada', 'CA', 'CAD', '1.01', '124'); INSERT INTO `countries` VALUES ('41', 'Canary Islands', '', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('42', 'Cape Verde', 'CV', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('43', 'Cayman Islands', 'KY', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('44', 'Chad', 'TD', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('45', 'Chile', 'CL', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('46', 'China', 'CN', 'CNY', '6.78', '156'); INSERT INTO `countries` VALUES ('47', 'Cocos (Keeling) Islands', 'CC', 'AUD', '0.98', '036'); INSERT INTO `countries` VALUES ('48', 'Colombia', 'CO', 'COP', '1852.98', '170'); INSERT INTO `countries` VALUES ('49', 'Congo Brazzaville and Democratic Republic of Congo', 'CG', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('50', 'Cook Islands', 'CK', 'NZD', '1.25', '554'); INSERT INTO `countries` VALUES ('51', 'Costa Rica', 'CR', 'CRC', '525.56', '188'); INSERT INTO `countries` VALUES ('53', 'Croatia', 'HR', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('54', 'Cuba', 'CU', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('55', 'Curacao', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('56', 'Cyprus', 'CY', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('57', 'Czech Republic', 'CZ', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('58', 'Denmark', 'DK', 'DKK', '5.55', '208'); INSERT INTO `countries` VALUES ('59', 'Djibouti', 'DJ', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('60', 'Kuwait', 'KW', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('61', 'Dominican Republic', 'DO', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('62', 'East Timor', 'TP', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('63', 'Ecuador', 'EC', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('64', 'Egypt', 'EG', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('66', 'El Salvador', 'SV', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('67', 'Equatorial Guinea', 'GQ', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('68', 'Eritrea', 'ER', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('69', 'Estonia', 'EE', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('71', 'Falkland Islands ', 'FK', 'GBP', '0.65', '826'); INSERT INTO `countries` VALUES ('72', 'Faroe Islands', 'FO', 'DKK', '5.55', '208'); INSERT INTO `countries` VALUES ('73', 'Fiji', 'FJ', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('74', 'Finland', 'FI', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('75', 'France', 'FR', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('76', 'French Guiana', 'GF', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('77', 'French Polynesia', 'PF', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('78', 'Futuna Islands', 'WF', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('79', 'Gambia', 'GM', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('80', 'Georgia', 'GE', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('81', 'Germany', 'DE', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('82', 'Gibraltar', 'GI', 'GBP', '0.65', '826'); INSERT INTO `countries` VALUES ('83', 'Greece', 'GR', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('84', 'Greenland', 'GL', 'DKK', '5.55', '208'); INSERT INTO `countries` VALUES ('85', 'Grenada', 'GD', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('86', 'Guadeloupe', 'GP', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('87', 'Guam', 'GU', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('88', 'Guernsey', 'GG', 'GBP', '0.65', '826'); INSERT INTO `countries` VALUES ('89', 'Guatemala', 'GT', 'GTQ', '8.11', '320'); INSERT INTO `countries` VALUES ('90', 'Guinea', 'GN', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('91', 'Guinea-Bissau', 'GW', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('92', 'Guyana', 'GY', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('93', 'Haiti', 'HT', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('94', 'Herzegovina', 'BA', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('95', 'Honduras', 'HN', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('96', 'Hong Kong', 'HK', 'HKD', '8.18', '344'); INSERT INTO `countries` VALUES ('97', 'Hungary', 'HU', 'HUF', '198.05', '348'); INSERT INTO `countries` VALUES ('98', 'Iceland', 'IS', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('99', 'India', 'IN', 'INR', '46.75', '356'); INSERT INTO `countries` VALUES ('100', 'Indonesia', 'ID', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('281', 'Senegal', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('102', 'Iraq', 'IQ', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('103', 'Ireland', 'IE', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('104', 'Israel', 'IL', 'ILS', '3.6', '376'); INSERT INTO `countries` VALUES ('105', 'Italy', 'IT', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('106', 'Jamaica', 'JM', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('107', 'Jan Mayen Islands', 'SJ', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('108', 'Japan', 'JP', 'JPY', '82.49', '392'); INSERT INTO `countries` VALUES ('109', 'Jersey', 'JE', 'GBP', '0.65', '826'); INSERT INTO `countries` VALUES ('110', 'Jordan', 'JO', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('241', 'Kyrgyzstan', 'KG', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('112', 'Kenya', 'KE', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('113', 'Kiribati', 'KI', 'AUD', '0.98', '036'); INSERT INTO `countries` VALUES ('114', 'Korea', 'KR', 'KRW', '1111.84', '410'); INSERT INTO `countries` VALUES ('115', 'Kazakhstan', 'KZ', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('117', 'Kosrae', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('118', 'Laos', 'LA', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('119', 'Latvia', 'LV', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('120', 'Lebanon', 'LB', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('121', 'Lesotho', 'LS', 'ZAR', '7.12', '710'); INSERT INTO `countries` VALUES ('122', 'Liberia', 'LR', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('123', 'Libya', 'LY', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('124', 'Liechtenstein', 'LI', 'CHF', '0.87', '756'); INSERT INTO `countries` VALUES ('125', 'Lithuania', 'LT', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('126', 'Luxembourg', 'LU', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('127', 'Macau', 'MO', 'MOP', '8.41', '446'); INSERT INTO `countries` VALUES ('128', 'Macedonia', 'MK', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('129', 'Madeira', '', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('130', 'Madagascar', 'MG', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('131', 'Malawi', 'MW', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('132', 'Malaysia', 'MY', 'MYR', '3.17', '458'); INSERT INTO `countries` VALUES ('133', 'Maldives', 'MV', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('134', 'Mali', 'ML', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('135', 'Malta', 'MT', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('136', 'Marshall Islands', 'MH', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('137', 'Martinique', 'MQ', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('138', 'Mauritania', 'MR', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('139', 'Mauritius', 'MU', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('140', 'Mayotte', 'YT', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('141', 'Mexico', 'MX', 'MXN', '12.26', '484'); INSERT INTO `countries` VALUES ('142', 'Micronesia', 'FM', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('144', 'Moldova', 'MD', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('145', 'Monaco', 'MC', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('146', 'Mongolia', 'MN', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('147', 'Montserrat', 'MS', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('148', 'Morocco', 'MA', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('149', 'Mozambique', 'MZ', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('150', 'Myanmar', 'MM', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('151', 'Namibia', 'NA', 'ZAR', '7.12', '710'); INSERT INTO `countries` VALUES ('152', 'Nauru', 'NR', 'AUD', '0.98', '036'); INSERT INTO `countries` VALUES ('153', 'Nepal', 'NP', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('154', 'Netherlands', 'NL', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('155', 'New Caledonia', 'NC', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('156', 'New Zealand', 'NZ', 'NZD', '1.25', '554'); INSERT INTO `countries` VALUES ('157', 'Nicaragua', 'NI', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('158', 'Norfolk Island', 'NF', 'AUD', '0.98', '036'); INSERT INTO `countries` VALUES ('159', 'Northern Islands', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('160', 'Northern Mariana Islands', 'MP', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('161', 'Norway', 'NO', 'NOK', '5.82', '578'); INSERT INTO `countries` VALUES ('162', 'Oman', 'OM', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('163', 'Pakistan', 'PK', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('164', 'Palau', 'PW', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('165', 'Panama', 'PA', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('166', 'Papua New Guinea', 'PG', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('167', 'Paraguay', 'PY', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('168', 'Peru', 'PE', 'PEN', '2.88', '604'); INSERT INTO `countries` VALUES ('169', 'Philippines', 'PH', 'PHP', '45.24', '608'); INSERT INTO `countries` VALUES ('170', 'Poland', 'PL', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('171', 'Ponape', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('172', 'Portugal', 'PT', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('173', 'Principe', 'ST', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('174', 'Puerto Rico', 'PR', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('175', 'Qatar', 'QA', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('176', 'Reunion', 'RE', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('177', 'Romania', 'RO', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('178', 'Rota', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('179', 'Russia', 'RU', 'RUB', '29.43', '643'); INSERT INTO `countries` VALUES ('180', 'Rwanda', 'RW', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('181', 'Saba', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('182', 'Saint Helena', 'SH', 'GBP', '0.65', '826'); INSERT INTO `countries` VALUES ('183', 'Saipan', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('184', 'San Marino', 'SM', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('185', 'Sao Tome', 'ST', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('186', 'Saudi Arabia', 'SA', 'SAR', '3.94', '682'); INSERT INTO `countries` VALUES ('275', 'Antigua and Barbuda', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('188', 'Seychelles', 'SY', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('189', 'Singapore', 'SG', 'SGD', '1.28', '702'); INSERT INTO `countries` VALUES ('190', 'Slovakia', 'SK', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('191', 'Slovenia', 'SI', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('192', 'Solomon Islands', 'SB', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('193', 'South Africa', 'ZA', 'ZAR', '7.12', '710'); INSERT INTO `countries` VALUES ('194', 'South Georgia', 'GS', 'GBP', '0.65', '826'); INSERT INTO `countries` VALUES ('195', 'South Sandwich Islands', 'GS', 'GBP', '0.65', '826'); INSERT INTO `countries` VALUES ('196', 'Spain', 'ES', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('197', 'Sri Lanka', 'LK', 'LKR', '115', '144'); INSERT INTO `countries` VALUES ('198', 'Sudan', 'SD', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('199', 'Suriname', 'SR', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('200', 'Svalbard', 'SJ', 'NOK', '5.82', '578'); INSERT INTO `countries` VALUES ('201', 'Swaziland', 'SZ', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('202', 'Sweden', 'SE', 'SEK', '6.84', '752'); INSERT INTO `countries` VALUES ('203', 'Switzerland', 'CH', 'CHF', '0.87', '756'); INSERT INTO `countries` VALUES ('204', 'Syrian Arab Republic', 'SY', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('205', 'Tahiti', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('206', 'Taiwan', 'TW', 'TWD', '30.31', '901'); INSERT INTO `countries` VALUES ('207', 'Tajikistan', 'TJ', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('208', 'Tanzania', 'TZ', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('209', 'Thailand', 'TH', 'THB', '31.59', '764'); INSERT INTO `countries` VALUES ('210', 'The Grenadines', 'VC', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('211', 'Tobago', 'TT', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('212', 'Togo', 'TG', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('213', 'Tokelau', 'TK', 'NZD', '1.25', '554'); INSERT INTO `countries` VALUES ('214', 'Tonga', 'TO', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('215', 'Trinidad', 'TT', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('216', 'Truk', 'TC', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('217', 'Tunisia', 'TN', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('218', 'Turkey', 'TR', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('219', 'Turkmenistan', 'TM', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('220', 'Turks Islands', 'TC', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('221', 'Tuvalu', 'TV', 'AUD', '0.98', '036'); INSERT INTO `countries` VALUES ('222', 'Uganda', 'UG', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('223', 'Ukraine', 'UA', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('224', 'United Arab Emirates', 'AE', 'AED', '3.86', '784'); INSERT INTO `countries` VALUES ('225', 'United Kingdom', 'GB', 'GBP', '0.65', '826'); INSERT INTO `countries` VALUES ('226', 'Uruguay', 'UY', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('228', 'Uzbekistan', 'UZ', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('229', 'Vanuatu', 'VU', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('230', 'Vatican City State', 'VA', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('231', 'Venezuela', 'VE', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('232', 'Vietnam', 'VN', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('233', 'Virgin Islands', 'VI', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('234', 'Wallis', 'WF', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('236', 'Yemen', 'YE', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('237', 'Zaire', 'ZR', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('238', 'AA - Armed Forces Americas', 'ZW', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('239', 'AA - Armed Forces Americas', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('242', 'Dominica', 'DM', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('243', 'Serbia and Montenegro', 'SP', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('244', 'St. Lucia', 'LC', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('245', 'St. Kitts-Nevis', 'KN', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('248', 'Samoa', 'WS', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('250', 'Netherlands Antilles', 'AN', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('251', 'St. Vincent', 'VC', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('252', 'St. Thomas', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('253', 'St. Maarten/St. Martin', '', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('254', 'St. John', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('255', 'St. Eustatius', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('256', 'St. Croix', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('257', 'St. Barts', '', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('258', 'Trinidad and Tobago', 'TT', 'TTD', '6.66', '780'); INSERT INTO `countries` VALUES ('259', 'US Virgin Islands', 'VI', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('260', 'British Virgin Islands', 'VG', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('261', 'Gabon', 'GA', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('262', 'Ethiopia', 'ET', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('263', 'Niger', 'NE', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('264', 'Slovak Republic', 'SK', 'EUR', '0.74', '978'); INSERT INTO `countries` VALUES ('265', 'Zambia', 'ZM', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('266', 'Nigeria', 'NG', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('267', 'United States', 'US', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('274', 'Cote D Ivoire', 'CI', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('276', 'Tortola', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('278', 'AE - Armed Forces Europe', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('279', 'AP - Armed Forces Pacific ', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('280', 'Ghana', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('282', 'United States (Military Address only)', '', 'USD', '1', '840'); INSERT INTO `countries` VALUES ('285', 'United States (Hawaii)', null, 'USD', '1', '840'); INSERT INTO `countries` VALUES ('286', 'United States (Alaska)', null, 'USD', '1', '840'); INSERT INTO `countries` VALUES ('287', 'United States (Guam)', null, 'USD', '1', '840'); INSERT INTO `countries` VALUES ('288', 'Afghanistan', null, 'USD', '1', '840');