-- phpMyAdmin SQL Dump
-- version 3.2.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 07, 2010 at 10:00 PM
-- Server version: 5.1.44
-- PHP Version: 5.3.2

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: `wine`
--

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `name` varchar(140) NOT NULL,
  `id` char(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES('Afghanistan', 'AF');
INSERT INTO `countries` VALUES('Albania', 'AL');
INSERT INTO `countries` VALUES('Algeria', 'DZ');
INSERT INTO `countries` VALUES('American Samoa', 'AS');
INSERT INTO `countries` VALUES('Andorra', 'AD');
INSERT INTO `countries` VALUES('Angola', 'AO');
INSERT INTO `countries` VALUES('Anguilla', 'AI');
INSERT INTO `countries` VALUES('Antarctica', 'AQ');
INSERT INTO `countries` VALUES('Antigua and Barbuda', 'AG');
INSERT INTO `countries` VALUES('Argentina', 'AR');
INSERT INTO `countries` VALUES('Armenia', 'AM');
INSERT INTO `countries` VALUES('Aruba', 'AW');
INSERT INTO `countries` VALUES('Australia', 'AU');
INSERT INTO `countries` VALUES('Austria', 'AT');
INSERT INTO `countries` VALUES('Azerbaijan', 'AZ');
INSERT INTO `countries` VALUES('Bahamas, The', 'BS');
INSERT INTO `countries` VALUES('Bahrain', 'BH');
INSERT INTO `countries` VALUES('Bangladesh', 'BD');
INSERT INTO `countries` VALUES('Barbados', 'BB');
INSERT INTO `countries` VALUES('Belarus', 'BY');
INSERT INTO `countries` VALUES('Belgium', 'BE');
INSERT INTO `countries` VALUES('Belize', 'BZ');
INSERT INTO `countries` VALUES('Benin', 'BJ');
INSERT INTO `countries` VALUES('Bhutan', 'BT');
INSERT INTO `countries` VALUES('Bolivia', 'BO');
INSERT INTO `countries` VALUES('Bosnia and Herzegovina', 'BA');
INSERT INTO `countries` VALUES('Botswana', 'BW');
INSERT INTO `countries` VALUES('Bouvet Island', 'BV');
INSERT INTO `countries` VALUES('Brazil', 'BR');
INSERT INTO `countries` VALUES('British Indian Ocean Territory', 'IO');
INSERT INTO `countries` VALUES('British Virgin Islands', 'VG');
INSERT INTO `countries` VALUES('Brunei Darussalam', 'BN');
INSERT INTO `countries` VALUES('Bulgaria', 'BG');
INSERT INTO `countries` VALUES('Burkina Faso', 'BF');
INSERT INTO `countries` VALUES('Burundi', 'BI');
INSERT INTO `countries` VALUES('Cambodia', 'KH');
INSERT INTO `countries` VALUES('Cameroon', 'CM');
INSERT INTO `countries` VALUES('Canada', 'CA');
INSERT INTO `countries` VALUES('Cape Verde', 'CV');
INSERT INTO `countries` VALUES('Cayman Islands', 'KY');
INSERT INTO `countries` VALUES('Central African Republic', 'CF');
INSERT INTO `countries` VALUES('Chad', 'TD');
INSERT INTO `countries` VALUES('Chile', 'CL');
INSERT INTO `countries` VALUES('China', 'CN');
INSERT INTO `countries` VALUES('Christmas Island', 'CX');
INSERT INTO `countries` VALUES('Cocos (Keeling) Islands', 'CC');
INSERT INTO `countries` VALUES('Colombia', 'CO');
INSERT INTO `countries` VALUES('Comoros', 'KM');
INSERT INTO `countries` VALUES('Congo', 'CG');
INSERT INTO `countries` VALUES('Democratic Republic of the Congo', 'CD');
INSERT INTO `countries` VALUES('Cook Islands', 'CK');
INSERT INTO `countries` VALUES('Costa Rica', 'CR');
INSERT INTO `countries` VALUES('Croatia', 'HR');
INSERT INTO `countries` VALUES('Cuba', 'CU');
INSERT INTO `countries` VALUES('Cyprus', 'CY');
INSERT INTO `countries` VALUES('Czech Republic', 'CZ');
INSERT INTO `countries` VALUES('Denmark', 'DK');
INSERT INTO `countries` VALUES('Djibouti', 'DJ');
INSERT INTO `countries` VALUES('Dominica', 'DM');
INSERT INTO `countries` VALUES('Dominican Republic', 'DO');
INSERT INTO `countries` VALUES('East Timor (Timor-Leste)', 'TP');
INSERT INTO `countries` VALUES('Ecuador', 'EC');
INSERT INTO `countries` VALUES('Egypt', 'EG');
INSERT INTO `countries` VALUES('El Salvador', 'SV');
INSERT INTO `countries` VALUES('Equatorial Guinea', 'GQ');
INSERT INTO `countries` VALUES('Eritrea', 'ER');
INSERT INTO `countries` VALUES('Estonia', 'EE');
INSERT INTO `countries` VALUES('Ethiopia', 'ET');
INSERT INTO `countries` VALUES('European Union', 'EU');
INSERT INTO `countries` VALUES('Falkland Islands (Malvinas)', 'FK');
INSERT INTO `countries` VALUES('Faroe Islands', 'FO');
INSERT INTO `countries` VALUES('Fiji', 'FJ');
INSERT INTO `countries` VALUES('Finland', 'FI');
INSERT INTO `countries` VALUES('France', 'FR');
INSERT INTO `countries` VALUES('French Guiana', 'GF');
INSERT INTO `countries` VALUES('French Polynesia', 'PF');
INSERT INTO `countries` VALUES('French Southern Territory', 'TF');
INSERT INTO `countries` VALUES('Gabon', 'GA');
INSERT INTO `countries` VALUES('Gambia', 'GM');
INSERT INTO `countries` VALUES('Georgia', 'GE');
INSERT INTO `countries` VALUES('Germany', 'DE');
INSERT INTO `countries` VALUES('Ghana', 'GH');
INSERT INTO `countries` VALUES('Gibraltar', 'GI');
INSERT INTO `countries` VALUES('Greece', 'GR');
INSERT INTO `countries` VALUES('Greenland', 'GL');
INSERT INTO `countries` VALUES('Grenada', 'GD');
INSERT INTO `countries` VALUES('Guadeloupe', 'GP');
INSERT INTO `countries` VALUES('Guam', 'GU');
INSERT INTO `countries` VALUES('Guatemala', 'GT');
INSERT INTO `countries` VALUES('Guernsey and Alderney', 'GG');
INSERT INTO `countries` VALUES('Guinea', 'GN');
INSERT INTO `countries` VALUES('Guinea-Bissau', 'GW');
INSERT INTO `countries` VALUES('Guyana', 'GY');
INSERT INTO `countries` VALUES('Haiti', 'HT');
INSERT INTO `countries` VALUES('Heard & McDonald Is.(AU)', 'HM');
INSERT INTO `countries` VALUES('Honduras', 'HN');
INSERT INTO `countries` VALUES('Hong Kong, (China)', 'HK');
INSERT INTO `countries` VALUES('Hungary', 'HU');
INSERT INTO `countries` VALUES('Iceland', 'IS');
INSERT INTO `countries` VALUES('India', 'IN');
INSERT INTO `countries` VALUES('Indonesia', 'ID');
INSERT INTO `countries` VALUES('Iran', 'IR');
INSERT INTO `countries` VALUES('Iraq', 'IQ');
INSERT INTO `countries` VALUES('Ireland', 'IE');
INSERT INTO `countries` VALUES('Israel', 'IL');
INSERT INTO `countries` VALUES('Italy', 'IT');
INSERT INTO `countries` VALUES('Ivory Coast (Cote d''Ivoire)', 'CI');
INSERT INTO `countries` VALUES('Jamaica', 'JM');
INSERT INTO `countries` VALUES('Japan', 'JP');
INSERT INTO `countries` VALUES('Jersey', 'JE');
INSERT INTO `countries` VALUES('Jordan', 'JO');
INSERT INTO `countries` VALUES('Kazakhstan', 'KZ');
INSERT INTO `countries` VALUES('Kenya', 'KE');
INSERT INTO `countries` VALUES('Kiribati', 'KI');
INSERT INTO `countries` VALUES('Democratic People''s Republic of Korea (North Korea)', 'KP');
INSERT INTO `countries` VALUES('Republic of Korea (South Korea)', 'KR');
INSERT INTO `countries` VALUES('Kosovo', 'KV');
INSERT INTO `countries` VALUES('Kuwait', 'KW');
INSERT INTO `countries` VALUES('Kyrgyzstan', 'KG');
INSERT INTO `countries` VALUES('Lao', 'LA');
INSERT INTO `countries` VALUES('Latvia', 'LV');
INSERT INTO `countries` VALUES('Lebanon', 'LB');
INSERT INTO `countries` VALUES('Lesotho', 'LS');
INSERT INTO `countries` VALUES('Liberia', 'LR');
INSERT INTO `countries` VALUES('Libyan Arab Jamahiriya', 'LY');
INSERT INTO `countries` VALUES('Liechtenstein', 'LI');
INSERT INTO `countries` VALUES('Lithuania', 'LT');
INSERT INTO `countries` VALUES('Luxembourg', 'LU');
INSERT INTO `countries` VALUES('Macao, (China)', 'MO');
INSERT INTO `countries` VALUES('Macedonia, TFYR', 'MK');
INSERT INTO `countries` VALUES('Madagascar', 'MG');
INSERT INTO `countries` VALUES('Malawi', 'MW');
INSERT INTO `countries` VALUES('Malaysia', 'MY');
INSERT INTO `countries` VALUES('Maldives', 'MV');
INSERT INTO `countries` VALUES('Mali', 'ML');
INSERT INTO `countries` VALUES('Malta', 'MT');
INSERT INTO `countries` VALUES('Man, Isle of', 'IM');
INSERT INTO `countries` VALUES('Marshall Islands', 'MH');
INSERT INTO `countries` VALUES('Martinique (FR)', 'MQ');
INSERT INTO `countries` VALUES('Mauritania', 'MR');
INSERT INTO `countries` VALUES('Mauritius', 'MU');
INSERT INTO `countries` VALUES('Mayotte (FR)', 'YT');
INSERT INTO `countries` VALUES('Mexico', 'MX');
INSERT INTO `countries` VALUES('Micronesia, Fed. States of', 'FM');
INSERT INTO `countries` VALUES('Moldova', 'MD');
INSERT INTO `countries` VALUES('Monaco', 'MC');
INSERT INTO `countries` VALUES('Mongolia', 'MN');
INSERT INTO `countries` VALUES('Montenegro', 'CS');
INSERT INTO `countries` VALUES('Montserrat', 'MS');
INSERT INTO `countries` VALUES('Morocco', 'MA');
INSERT INTO `countries` VALUES('Mozambique', 'MZ');
INSERT INTO `countries` VALUES('Myanmar (ex-Burma)', 'MM');
INSERT INTO `countries` VALUES('Namibia', 'NA');
INSERT INTO `countries` VALUES('Nauru', 'NR');
INSERT INTO `countries` VALUES('Nepal', 'NP');
INSERT INTO `countries` VALUES('Netherlands', 'NL');
INSERT INTO `countries` VALUES('Netherlands Antilles', 'AN');
INSERT INTO `countries` VALUES('New Caledonia', 'NC');
INSERT INTO `countries` VALUES('New Zealand', 'NZ');
INSERT INTO `countries` VALUES('Nicaragua', 'NI');
INSERT INTO `countries` VALUES('Niger', 'NE');
INSERT INTO `countries` VALUES('Nigeria', 'NG');
INSERT INTO `countries` VALUES('Niue', 'NU');
INSERT INTO `countries` VALUES('Norfolk Island', 'NF');
INSERT INTO `countries` VALUES('Northern Mariana Islands', 'MP');
INSERT INTO `countries` VALUES('Norway', 'NO');
INSERT INTO `countries` VALUES('Oman', 'OM');
INSERT INTO `countries` VALUES('Pakistan', 'PK');
INSERT INTO `countries` VALUES('Palau', 'PW');
INSERT INTO `countries` VALUES('Palestinian Territory', 'PS');
INSERT INTO `countries` VALUES('Panama', 'PA');
INSERT INTO `countries` VALUES('Papua New Guinea', 'PG');
INSERT INTO `countries` VALUES('Paraguay', 'PY');
INSERT INTO `countries` VALUES('Peru', 'PE');
INSERT INTO `countries` VALUES('Philippines', 'PH');
INSERT INTO `countries` VALUES('Pitcairn Island', 'PN');
INSERT INTO `countries` VALUES('Poland', 'PL');
INSERT INTO `countries` VALUES('Portugal', 'PT');
INSERT INTO `countries` VALUES('Puerto Rico', 'PR');
INSERT INTO `countries` VALUES('Qatar', 'QA');
INSERT INTO `countries` VALUES('Reunion (FR)', 'RE');
INSERT INTO `countries` VALUES('Romania', 'RO');
INSERT INTO `countries` VALUES('Russia', 'RU');
INSERT INTO `countries` VALUES('Rwanda', 'RW');
INSERT INTO `countries` VALUES('Saint Barthelemy (FR)', 'BL');
INSERT INTO `countries` VALUES('Saint Helena (UK)', 'SH');
INSERT INTO `countries` VALUES('Saint Kitts and Nevis', 'KN');
INSERT INTO `countries` VALUES('Saint Lucia', 'LC');
INSERT INTO `countries` VALUES('Saint Martin (FR)', 'MF');
INSERT INTO `countries` VALUES('S Pierre & Miquelon (FR)', 'PM');
INSERT INTO `countries` VALUES('S Vincent & Grenadines', 'VC');
INSERT INTO `countries` VALUES('Samoa', 'WS');
INSERT INTO `countries` VALUES('San Marino', 'SM');
INSERT INTO `countries` VALUES('Sao Tome and Principe', 'ST');
INSERT INTO `countries` VALUES('Saudi Arabia', 'SA');
INSERT INTO `countries` VALUES('Senegal', 'SN');
INSERT INTO `countries` VALUES('Serbia', 'RS');
INSERT INTO `countries` VALUES('Seychelles', 'SC');
INSERT INTO `countries` VALUES('Sierra Leone', 'SL');
INSERT INTO `countries` VALUES('Singapore', 'SG');
INSERT INTO `countries` VALUES('Slovakia', 'SK');
INSERT INTO `countries` VALUES('Slovenia', 'SI');
INSERT INTO `countries` VALUES('Solomon Islands', 'SB');
INSERT INTO `countries` VALUES('Somalia', 'SO');
INSERT INTO `countries` VALUES('South Africa', 'ZA');
INSERT INTO `countries` VALUES('S.George & S.Sandwich', 'GS');
INSERT INTO `countries` VALUES('Spain', 'ES');
INSERT INTO `countries` VALUES('Sri Lanka', 'LK');
INSERT INTO `countries` VALUES('Sudan', 'SD');
INSERT INTO `countries` VALUES('Suriname', 'SR');
INSERT INTO `countries` VALUES('Svalbard and Jan Mayen Is.', 'SJ');
INSERT INTO `countries` VALUES('Swaziland', 'SZ');
INSERT INTO `countries` VALUES('Sweden', 'SE');
INSERT INTO `countries` VALUES('Switzerland', 'CH');
INSERT INTO `countries` VALUES('Syrian Arab Republic', 'SY');
INSERT INTO `countries` VALUES('Taiwan', 'TW');
INSERT INTO `countries` VALUES('Tajikistan', 'TJ');
INSERT INTO `countries` VALUES('Tanzania', 'TZ');
INSERT INTO `countries` VALUES('Thailand', 'TH');
INSERT INTO `countries` VALUES('Timor-Leste (East Timor)', 'TL');
INSERT INTO `countries` VALUES('Togo', 'TG');
INSERT INTO `countries` VALUES('Tokelau', 'TK');
INSERT INTO `countries` VALUES('Tonga', 'TO');
INSERT INTO `countries` VALUES('Trinidad and Tobago', 'TT');
INSERT INTO `countries` VALUES('Tunisia', 'TN');
INSERT INTO `countries` VALUES('Turkey', 'TR');
INSERT INTO `countries` VALUES('Turkmenistan', 'TM');
INSERT INTO `countries` VALUES('Turks and Caicos Islands', 'TC');
INSERT INTO `countries` VALUES('Tuvalu', 'TV');
INSERT INTO `countries` VALUES('Uganda', 'UG');
INSERT INTO `countries` VALUES('Ukraine', 'UA');
INSERT INTO `countries` VALUES('United Arab Emirates', 'AE');
INSERT INTO `countries` VALUES('United Kingdom', 'UK');
INSERT INTO `countries` VALUES('United States', 'US');
INSERT INTO `countries` VALUES('US Minor Outlying Isl.', 'UM');
INSERT INTO `countries` VALUES('Uruguay', 'UY');
INSERT INTO `countries` VALUES('Uzbekistan', 'UZ');
INSERT INTO `countries` VALUES('Vanuatu', 'VU');
INSERT INTO `countries` VALUES('Vatican (Holy See)', 'VA');
INSERT INTO `countries` VALUES('Venezuela', 'VE');
INSERT INTO `countries` VALUES('Viet Nam', 'VN');
INSERT INTO `countries` VALUES('Virgin Islands, U.S.', 'VI');
INSERT INTO `countries` VALUES('Wallis and Futuna', 'WF');
INSERT INTO `countries` VALUES('Western Sahara', 'EH');
INSERT INTO `countries` VALUES('Yemen', 'YE');
INSERT INTO `countries` VALUES('Zambia', 'ZM');
INSERT INTO `countries` VALUES('Zimbabwe', 'ZW');