-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Sep 28, 2007 at 06:49 PM
-- Server version: 5.0.41
-- PHP Version: 5.2.2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `melissa`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `uc_countries`
-- 

DROP TABLE IF EXISTS `uc_countries`;
CREATE TABLE `uc_countries` (
  `country_id` mediumint(11) NOT NULL,
  `country_name` varchar(255) collate utf8_unicode_ci NOT NULL,
  `country_iso_code_2` char(2) collate utf8_unicode_ci NOT NULL,
  `country_iso_code_3` char(3) collate utf8_unicode_ci NOT NULL,
  `version` smallint(11) NOT NULL default '0',
  PRIMARY KEY  (`country_id`),
  KEY `country_name` (`country_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table `uc_countries`
-- 

INSERT INTO `uc_countries` (`country_id`, `country_name`, `country_iso_code_2`, `country_iso_code_3`, `version`) VALUES 
(8, 'Albania', 'AL', 'ALB', 1),
(12, 'Algeria', 'DZ', 'DZA', 1),
(20, 'Andorra', 'AD', 'AND', 1),
(24, 'Angola', 'AO', 'AGO', 1),
(28, 'Antigua and Barbuda', 'AG', 'ATG', 1),
(31, 'Azerbaijan', 'AZ', 'AZE', 1),
(32, 'Argentina', 'AR', 'ARG', 1),
(36, 'Australia', 'AU', 'AUS', 1),
(40, 'Austria', 'AT', 'AUT', 1),
(44, 'Bahamas', 'BS', 'BHS', 1),
(48, 'Bahrain', 'BH', 'BHR', 1),
(51, 'Armenia', 'AM', 'ARM', 1),
(52, 'Barbados', 'BB', 'BRB', 1),
(56, 'Belgium', 'BE', 'BEL', 1),
(60, 'Bermuda', 'BM', 'BMU', 1),
(64, 'Bhutan', 'BT', 'BTN', 1),
(68, 'Bolivia', 'BO', 'BOL', 1),
(70, 'Bosnia and Herzegowina', 'BA', 'BIH', 1),
(72, 'Botswana', 'BW', 'BWA', 1),
(76, 'Brazil', 'BR', 'BRA', 1),
(84, 'Belize', 'BZ', 'BLZ', 1),
(90, 'Solomon Islands', 'SB', 'SLB', 1),
(92, 'British Virgin Islands', 'VG', 'VGB', 1),
(96, 'Brunei Darussalam', 'BN', 'BRN', 1),
(100, 'Bulgaria', 'BG', 'BGR', 1),
(108, 'Burundi', 'BI', 'BDI', 1),
(116, 'Cambodia', 'KH', 'KHM', 1),
(124, 'Canada', 'CA', 'CAN', 1),
(132, 'Cape Verde', 'CV', 'CPV', 1),
(136, 'Cayman Islands', 'KY', 'CYM', 1),
(144, 'Sri Lanka', 'LK', 'LKA', 1),
(148, 'Chad', 'TD', 'TCD', 1),
(152, 'Chile', 'CL', 'CHL', 1),
(156, 'China', 'CN', 'CHN', 1),
(158, 'Taiwan', 'TW', 'TWN', 1),
(170, 'Colombia', 'CO', 'COL', 1),
(174, 'Comoros', 'KM', 'COM', 1),
(175, 'Mayotte', 'YT', 'MYT', 1),
(178, 'Republic of the Congo', 'CG', 'COG', 1),
(184, 'Cook Islands', 'CK', 'COK', 1),
(188, 'Costa Rica', 'CR', 'CRI', 1),
(191, 'Croatia', 'HR', 'HRV', 1),
(196, 'Cyprus', 'CY', 'CYP', 1),
(203, 'Czech Republic', 'CZ', 'CZE', 1),
(204, 'Benin', 'BJ', 'BEN', 1),
(208, 'Denmark', 'DK', 'DNK', 1),
(210, 'Ethiopia', 'ET', 'ETH', 1),
(212, 'Dominica', 'DM', 'DMA', 1),
(214, 'Dominican Republic', 'DO', 'DOM', 1),
(218, 'Ecuador', 'EC', 'ECU', 1),
(222, 'El Salvador', 'SV', 'SLV', 1),
(232, 'Eritrea', 'ER', 'ERI', 1),
(233, 'Estonia', 'EE', 'EST', 1),
(234, 'Faroe Islands', 'FO', 'FRO', 1),
(238, 'Falkland Islands (Malvinas)', 'FK', 'FLK', 1),
(242, 'Fiji', 'FJ', 'FJI', 1),
(246, 'Finland', 'FI', 'FIN', 1),
(250, 'France', 'FR', 'FRA', 1),
(254, 'French Guiana', 'GF', 'GUF', 1),
(258, 'French Polynesia', 'PF', 'PYF', 1),
(262, 'Djibouti', 'DJ', 'DJI', 1),
(266, 'Gabon Republic', 'GA', 'GAB', 1),
(270, 'Gambia', 'GM', 'GMB', 1),
(276, 'Germany', 'DE', 'DEU', 1),
(292, 'Gibraltar', 'GI', 'GIB', 1),
(296, 'Kiribati', 'KI', 'KIR', 1),
(300, 'Greece', 'GR', 'GRC', 1),
(304, 'Greenland', 'GL', 'GRL', 1),
(308, 'Grenada', 'GD', 'GRD', 1),
(312, 'Guadeloupe', 'GP', 'GLP', 1),
(320, 'Guatemala', 'GT', 'GTM', 1),
(324, 'Guinea', 'GN', 'GIN', 1),
(328, 'Guyana', 'GY', 'GUY', 1),
(336, 'Vatican City State', 'VA', 'VAT', 1),
(340, 'Honduras', 'HN', 'HND', 1),
(344, 'Hong Kong', 'HK', 'HKG', 1),
(348, 'Hungary', 'HU', 'HUN', 1),
(352, 'Iceland', 'IS', 'ISL', 1),
(356, 'India', 'IN', 'IND', 1),
(360, 'Indonesia', 'ID', 'IDN', 1),
(372, 'Ireland', 'IE', 'IRL', 1),
(376, 'Israel', 'IL', 'ISR', 1),
(380, 'Italy', 'IT', 'ITA', 1),
(388, 'Jamaica', 'JM', 'JAM', 1),
(392, 'Japan', 'JP', 'JPN', 1),
(398, 'Kazakhstan', 'KZ', 'KAZ', 1),
(400, 'Jordan', 'JO', 'JOR', 1),
(404, 'Kenya', 'KE', 'KEN', 1),
(410, 'South Korea', 'KR', 'KOR', 1),
(414, 'Kuwait', 'KW', 'KWT', 1),
(417, 'Kyrgyzstan', 'KG', 'KGZ', 1),
(418, 'Laos', 'LA', 'LAO', 1),
(426, 'Lesotho', 'LS', 'LSO', 1),
(428, 'Latvia', 'LV', 'LVA', 1),
(438, 'Liechtenstein', 'LI', 'LIE', 1),
(440, 'Lithuania', 'LT', 'LTU', 1),
(442, 'Luxembourg', 'LU', 'LUX', 1),
(450, 'Madagascar', 'MG', 'MDG', 1),
(454, 'Malawi', 'MW', 'MWI', 1),
(458, 'Malaysia', 'MY', 'MYS', 1),
(462, 'Maldives', 'MV', 'MDV', 1),
(466, 'Mali', 'ML', 'MLI', 1),
(470, 'Malta', 'MT', 'MLT', 1),
(474, 'Martinique', 'MQ', 'MTQ', 1),
(478, 'Mauritania', 'MR', 'MRT', 1),
(480, 'Mauritius', 'MU', 'MUS', 1),
(484, 'Mexico', 'MX', 'MEX', 1),
(496, 'Mongolia', 'MN', 'MNG', 1),
(500, 'Montserrat', 'MS', 'MSR', 1),
(504, 'Morocco', 'MA', 'MAR', 1),
(508, 'Mozambique', 'MZ', 'MOZ', 1),
(512, 'Oman', 'OM', 'OMN', 1),
(516, 'Namibia', 'NA', 'NAM', 1),
(520, 'Nauru', 'NR', 'NRU', 1),
(524, 'Nepal', 'NP', 'NPL', 1),
(528, 'Netherlands', 'NL', 'NLD', 1),
(530, 'Netherlands Antilles', 'AN', 'ANT', 1),
(533, 'Aruba', 'AW', 'ABW', 1),
(540, 'New Caledonia', 'NC', 'NCL', 1),
(548, 'Vanuatu', 'VU', 'VUT', 1),
(554, 'New Zealand', 'NZ', 'NZL', 1),
(558, 'Nicaragua', 'NI', 'NIC', 1),
(562, 'Niger', 'NE', 'NER', 1),
(570, 'Niue', 'NU', 'NIU', 1),
(574, 'Norfolk Island', 'NF', 'NFK', 1),
(578, 'Norway', 'NO', 'NOR', 1),
(583, 'Federated States of Micronesia', 'FM', 'FSM', 1),
(584, 'Marshall Islands', 'MH', 'MHL', 1),
(585, 'Palau', 'PW', 'PLW', 1),
(591, 'Panama', 'PA', 'PAN', 1),
(598, 'Papua New Guinea', 'PG', 'PNG', 1),
(604, 'Peru', 'PE', 'PER', 1),
(608, 'Philippines', 'PH', 'PHL', 1),
(612, 'Pitcairn Islands', 'PN', 'PCN', 1),
(616, 'Poland', 'PL', 'POL', 1),
(620, 'Portugal', 'PT', 'PRT', 1),
(624, 'Guinea Bissau', 'GW', 'GNB', 1),
(634, 'Qatar', 'QA', 'QAT', 1),
(638, 'Reunion', 'RE', 'REU', 1),
(642, 'Romania', 'RO', 'ROU', 1),
(643, 'Russia', 'RU', 'RUS', 1),
(646, 'Rwanda', 'RW', 'RWA', 1),
(654, 'St. Helena', 'SH', 'SHN', 1),
(659, 'St. Kitts and Nevis', 'KN', 'KNA', 1),
(660, 'Anguilla', 'AI', 'AIA', 1),
(662, 'St. Lucia', 'LC', 'LCA', 1),
(666, 'St. Pierre and Miquelon', 'PM', 'SPM', 1),
(670, 'Saint Vincent and the Grenadines', 'VC', 'VCT', 1),
(674, 'San Marino', 'SM', 'SMR', 1),
(678, 'Sao Tome and Principe', 'ST', 'STP', 1),
(682, 'Saudi Arabia', 'SA', 'SAU', 1),
(686, 'Senegal', 'SN', 'SEN', 1),
(690, 'Seychelles', 'SC', 'SYC', 1),
(694, 'Sierra Leone', 'SL', 'SLE', 1),
(702, 'Singapore', 'SG', 'SGP', 1),
(703, 'Slovakia', 'SK', 'SVK', 1),
(704, 'Vietnam', 'VN', 'VNM', 1),
(705, 'Slovenia', 'SI', 'SVN', 1),
(706, 'Somalia', 'SO', 'SOM', 1),
(710, 'South Africa', 'ZA', 'ZAF', 1),
(724, 'Spain', 'ES', 'ESP', 1),
(740, 'Suriname', 'SR', 'SUR', 1),
(744, 'Svalbard and Jan Mayen Islands', 'SJ', 'SJM', 1),
(748, 'Swaziland', 'SZ', 'SWZ', 1),
(752, 'Sweden', 'SE', 'SWE', 1),
(756, 'Switzerland', 'CH', 'CHE', 1),
(762, 'Tajikistan', 'TJ', 'TJK', 1),
(764, 'Thailand', 'TH', 'THA', 1),
(768, 'Togo', 'TG', 'TGO', 1),
(776, 'Tonga', 'TO', 'TON', 1),
(780, 'Trinidad and Tobago', 'TT', 'TTO', 1),
(784, 'United Arab Emirates', 'AE', 'ARE', 1),
(788, 'Tunisia', 'TN', 'TUN', 1),
(792, 'Turkey', 'TR', 'TUR', 1),
(795, 'Turkmenistan', 'TM', 'TKM', 1),
(796, 'Turks and Caicos Islands', 'TC', 'TCA', 1),
(798, 'Tuvalu', 'TV', 'TUV', 1),
(800, 'Uganda', 'UG', 'UGA', 1),
(804, 'Ukraine', 'UA', 'UKR', 1),
(826, 'United Kingdom (Great Britain)', 'GB', 'GBR', 1),
(834, 'Tanzania', 'TZ', 'TZA', 1),
(840, 'United States', 'US', 'USA', 1),
(854, 'Burkina Faso', 'BF', 'BFA', 1),
(858, 'Uruguay', 'UY', 'URY', 1),
(862, 'Venezuela', 'VE', 'VEN', 1),
(876, 'Wallis And Futuna Islands', 'WF', 'WLF', 1),
(882, 'Samoa', 'WS', 'WSM', 1),
(887, 'Yemen', 'YE', 'YEM', 1),
(894, 'Zambia', 'ZM', 'ZMB', 1);