-- 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),
(660, 'Anguilla', 'AI', 'AIA', 1),
(28, 'Antigua and Barbuda', 'AG', 'ATG', 1),
(32, 'Argentina', 'AR', 'ARG', 1),
(51, 'Armenia', 'AM', 'ARM', 1),
(533, 'Aruba', 'AW', 'ABW', 1),
(36, 'Australia', 'AU', 'AUS', 1),
(40, 'Austria', 'AT', 'AUT', 1),
(31, 'Azerbaijan Republic', 'AZ', 'AZE', 1),
(44, 'Bahamas', 'BS', 'BHS', 1),
(48, 'Bahrain', 'BH', 'BHR', 1),
(52, 'Barbados', 'BB', 'BRB', 1),
(56, 'Belgium', 'BE', 'BEL', 1),
(84, 'Belize', 'BZ', 'BLZ', 1),
(204, 'Benin', 'BJ', 'BEN', 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),
(92, 'British Virgin Islands', 'VG', 'VGB', 1),
(96, 'Brunei', 'BN', 'BRN', 1),
(100, 'Bulgaria', 'BG', 'BGR', 1),
(854, 'Burkina Faso', 'BF', 'BFA', 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),
(148, 'Chad', 'TD', 'TCD', 1),
(152, 'Chile', 'CL', 'CHL', 1),
(156, 'China', 'CN', 'CHN', 1),
(170, 'Colombia', 'CO', 'COL', 1),
(174, 'Comoros', 'KM', 'COM', 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),
(180, 'Democratic Republic of the Congo', 'CD', 'COD', 1),
(208, 'Denmark', 'DK', 'DNK', 1),
(262, 'Djibouti', 'DJ', 'DJI', 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),
(231, 'Ethiopia', 'ET', 'ETH', 1),
(238, 'Falkland Islands', 'FK', 'FLK', 1),
(234, 'Faroe Islands', 'FO', 'FRO', 1),
(583, 'Federated States of Micronesia', 'FM', 'FSM', 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),
(266, 'Gabon Republic', 'GA', 'GAB', 1),
(270, 'Gambia', 'GM', 'GMB', 1),
(276, 'Germany', 'DE', 'DEU', 1),
(292, 'Gibraltar', 'GI', 'GIB', 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),
(624, 'Guinea Bissau', 'GW', 'GNB', 1),
(324, 'Guinea', 'GN', 'GIN', 1),
(328, 'Guyana', 'GY', 'GUY', 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),
(400, 'Jordan', 'JO', 'JOR', 1),
(398, 'Kazakhstan', 'KZ', 'KAZ', 1),
(404, 'Kenya', 'KE', 'KEN', 1),
(296, 'Kiribati', 'KI', 'KIR', 1),
(414, 'Kuwait', 'KW', 'KWT', 1),
(417, 'Kyrgyzstan', 'KG', 'KGZ', 1),
(418, 'Laos', 'LA', 'LAO', 1),
(428, 'Latvia', 'LV', 'LVA', 1),
(426, 'Lesotho', 'LS', 'LSO', 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),
(584, 'Marshall Islands', 'MH', 'MHL', 1),
(474, 'Martinique', 'MQ', 'MTQ', 1),
(478, 'Mauritania', 'MR', 'MRT', 1),
(480, 'Mauritius', 'MU', 'MUS', 1),
(175, 'Mayotte', 'YT', 'MYT', 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),
(516, 'Namibia', 'NA', 'NAM', 1),
(520, 'Nauru', 'NR', 'NRU', 1),
(524, 'Nepal', 'NP', 'NPL', 1),
(530, 'Netherlands Antilles', 'AN', 'ANT', 1),
(528, 'Netherlands', 'NL', 'NLD', 1),
(540, 'New Caledonia', 'NC', 'NCL', 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),
(512, 'Oman', 'OM', 'OMN', 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),
(634, 'Qatar', 'QA', 'QAT', 1),
(178, 'Republic of the Congo', 'CG', 'COG', 1),
(638, 'Reunion', 'RE', 'REU', 1),
(642, 'Romania', 'RO', 'ROU', 1),
(643, 'Russia', 'RU', 'RUS', 1),
(646, 'Rwanda', 'RW', 'RWA', 1),
(670, 'Saint Vincent and the Grenadines', 'VC', 'VCT', 1),
(882, 'Samoa', 'WS', 'WSM', 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),
(705, 'Slovenia', 'SI', 'SVN', 1),
(90, 'Solomon Islands', 'SB', 'SLB', 1),
(706, 'Somalia', 'SO', 'SOM', 1),
(710, 'South Africa', 'ZA', 'ZAF', 1),
(410, 'South Korea', 'KR', 'KOR', 1),
(724, 'Spain', 'ES', 'ESP', 1),
(144, 'Sri Lanka', 'LK', 'LKA', 1),
(654, 'St. Helena', 'SH', 'SHN', 1),
(659, 'St. Kitts and Nevis', 'KN', 'KNA', 1),
(662, 'St. Lucia', 'LC', 'LCA', 1),
(666, 'St. Pierre and Miquelon', 'PM', 'SPM', 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),
(158, 'Taiwan', 'TW', 'TWN', 1),
(762, 'Tajikistan', 'TJ', 'TJK', 1),
(834, 'Tanzania', 'TZ', 'TZA', 1),
(764, 'Thailand', 'TH', 'THA', 1),
(768, 'Togo', 'TG', 'TGO', 1),
(776, 'Tonga', 'TO', 'TON', 1),
(780, 'Trinidad and Tobago', 'TT', 'TTO', 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),
(784, 'United Arab Emirates', 'AE', 'ARE', 1),
(826, 'United Kingdom', 'GB', 'GBR', 1),
(840, 'United States', 'US', 'USA', 1),
(858, 'Uruguay', 'UY', 'URY', 1),
(548, 'Vanuatu', 'VU', 'VUT', 1),
(336, 'Vatican City State', 'VA', 'VAT', 1),
(862, 'Venezuela', 'VE', 'VEN', 1),
(704, 'Vietnam', 'VN', 'VNM', 1),
(876, 'Wallis and Futuna Islands', 'WF', 'WLF', 1),
(887, 'Yemen', 'YE', 'YEM', 1),
(894, 'Zambia', 'ZM', 'ZMB', 1);