-- MySQL dump 10.13  Distrib 5.1.33, for Win32 (ia32)
--
-- Host: localhost    Database: thewineclub
-- ------------------------------------------------------
-- Server version	5.1.33-community

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `country`
--

DROP TABLE IF EXISTS `country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `country` (
  `id` int(11) NOT NULL,
  `code` char(2) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `phoneprefix` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `country`
--

LOCK TABLES `country` WRITE;
/*!40000 ALTER TABLE `country` DISABLE KEYS */;
INSERT INTO `country` VALUES (1,'AF','Afghanistan','+93'),(2,'AL','Albania','+355'),(3,'DZ','Algeria','+213'),(4,'AD','Andorra','+376'),(5,'AO','Angola','+244'),(6,'AG','Antigua and Barbuda','+1-268'),(7,'AR','Argentina','+54'),(8,'AM','Armenia','+374'),(9,'AU','Australia','+61'),(10,'AT','Austria','+43'),(11,'AZ','Azerbaijan','+994'),(12,'BS','Bahamas, The','+1-242'),(13,'BH','Bahrain','+973'),(14,'BD','Bangladesh','+880'),(15,'BB','Barbados','+1-246'),(16,'BY','Belarus','+375'),(17,'BE','Belgium','+32'),(18,'BZ','Belize','+501'),(19,'BJ','Benin','+229'),(20,'BT','Bhutan','+975'),(21,'BO','Bolivia','+591'),(22,'BA','Bosnia and Herzegovina','+387'),(23,'BW','Botswana','+267'),(24,'BR','Brazil','+55'),(25,'BN','Brunei','+673'),(26,'BG','Bulgaria','+359'),(27,'BF','Burkina Faso','+226'),(28,'BI','Burundi','+257'),(29,'KH','Cambodia','+855'),(30,'CM','Cameroon','+237'),(31,'CA','Canada','+1'),(32,'CV','Cape Verde','+238'),(33,'CF','Central African Republic','+236'),(34,'TD','Chad','+235'),(35,'CL','Chile','+56'),(36,'CN','China, People\'s Republic of','+86'),(37,'CO','Colombia','+57'),(38,'KM','Comoros','+269'),(39,'CD','Congo, Democratic Republic of the (Congo ? Kinshasa)','+243'),(40,'CG','Congo, Republic of the (Congo ? Brazzaville)','+242'),(41,'CR','Costa Rica','+506'),(42,'CI','Cote d\'Ivoire (Ivory Coast)','+225'),(43,'HR','Croatia','+385'),(44,'CU','Cuba','+53'),(45,'CY','Cyprus','+357'),(46,'CZ','Czech Republic','+420'),(47,'DK','Denmark','+45'),(48,'DJ','Djibouti','+253'),(49,'DM','Dominica','+1-767'),(50,'DO','Dominican Republic','+1-809 and 1-829'),(51,'EC','Ecuador','+593'),(52,'EG','Egypt','+20'),(53,'SV','El Salvador','+503'),(54,'GQ','Equatorial Guinea','+240'),(55,'ER','Eritrea','+291'),(56,'EE','Estonia','+372'),(57,'ET','Ethiopia','+251'),(58,'FJ','Fiji','+679'),(59,'FI','Finland','+358'),(60,'FR','France','+33'),(61,'GA','Gabon','+241'),(62,'GM','Gambia, The','+220'),(63,'GE','Georgia','+995'),(64,'DE','Germany','+49'),(65,'GH','Ghana','+233'),(66,'GR','Greece','+30'),(67,'GD','Grenada','+1-473'),(68,'GT','Guatemala','+502'),(69,'GN','Guinea','+224'),(70,'GW','Guinea-Bissau','+245'),(71,'GY','Guyana','+592'),(72,'HT','Haiti','+509'),(73,'HN','Honduras','+504'),(74,'HU','Hungary','+36'),(75,'IS','Iceland','+354'),(76,'IN','India','+91'),(77,'ID','Indonesia','+62'),(78,'IR','Iran','+98'),(79,'IQ','Iraq','+964'),(80,'IE','Ireland','+353'),(81,'IL','Israel','+972'),(82,'IT','Italy','+39'),(83,'JM','Jamaica','+1-876'),(84,'JP','Japan','+81'),(85,'JO','Jordan','+962'),(86,'KZ','Kazakhstan','+7'),(87,'KE','Kenya','+254'),(88,'KI','Kiribati','+686'),(89,'KP','Korea, Democratic People\'s Republic of (North Korea)','+850'),(90,'KR','Korea, Republic of  (South Korea)','+82'),(91,'KW','Kuwait','+965'),(92,'KG','Kyrgyzstan','+996'),(93,'LA','Laos','+856'),(94,'LV','Latvia','+371'),(95,'LB','Lebanon','+961'),(96,'LS','Lesotho','+266'),(97,'LR','Liberia','+231'),(98,'LY','Libya','+218'),(99,'LI','Liechtenstein','+423'),(100,'LT','Lithuania','+370'),(101,'LU','Luxembourg','+352'),(102,'MK','Macedonia','+389'),(103,'MG','Madagascar','+261'),(104,'MW','Malawi','+265'),(105,'MY','Malaysia','+60'),(106,'MV','Maldives','+960'),(107,'ML','Mali','+223'),(108,'MT','Malta','+356'),(109,'MH','Marshall Islands','+692'),(110,'MR','Mauritania','+222'),(111,'MU','Mauritius','+230'),(112,'MX','Mexico','+52'),(113,'FM','Micronesia','+691'),(114,'MD','Moldova','+373'),(115,'MC','Monaco','+377'),(116,'MN','Mongolia','+976'),(117,'ME','Montenegro','+382'),(118,'MA','Morocco','+212'),(119,'MZ','Mozambique','+258'),(120,'MM','Myanmar (Burma)','+95'),(121,'NA','Namibia','+264'),(122,'NR','Nauru','+674'),(123,'NP','Nepal','+977'),(124,'NL','Netherlands','+31'),(125,'NZ','New Zealand','+64'),(126,'NI','Nicaragua','+505'),(127,'NE','Niger','+227'),(128,'NG','Nigeria','+234'),(129,'NO','Norway','+47'),(130,'OM','Oman','+968'),(131,'PK','Pakistan','+92'),(132,'PW','Palau','+680'),(133,'PA','Panama','+507'),(134,'PG','Papua New Guinea','+675'),(135,'PY','Paraguay','+595'),(136,'PE','Peru','+51'),(137,'PH','Philippines','+63'),(138,'PL','Poland','+48'),(139,'PT','Portugal','+351'),(140,'QA','Qatar','+974'),(141,'RO','Romania','+40'),(142,'RU','Russia','+7'),(143,'RW','Rwanda','+250'),(144,'KN','Saint Kitts and Nevis','+1-869'),(145,'LC','Saint Lucia','+1-758'),(146,'VC','Saint Vincent and the Grenadines','+1-784'),(147,'WS','Samoa','+685'),(148,'SM','San Marino','+378'),(149,'ST','Sao Tome and Principe','+239'),(150,'SA','Saudi Arabia','+966'),(151,'SN','Senegal','+221'),(152,'RS','Serbia','+381'),(153,'SC','Seychelles','+248'),(154,'SL','Sierra Leone','+232'),(155,'SG','Singapore','+65'),(156,'SK','Slovakia','+421'),(157,'SI','Slovenia','+386'),(158,'SB','Solomon Islands','+677'),(159,'SO','Somalia','+252'),(160,'ZA','South Africa','+27'),(161,'ES','Spain','+34'),(162,'LK','Sri Lanka','+94'),(163,'SD','Sudan','+249'),(164,'SR','Suriname','+597'),(165,'SZ','Swaziland','+268'),(166,'SE','Sweden','+46'),(167,'CH','Switzerland','+41'),(168,'SY','Syria','+963'),(169,'TJ','Tajikistan','+992'),(170,'TZ','Tanzania','+255'),(171,'TH','Thailand','+66'),(172,'TL','Timor-Leste (East Timor)','+670'),(173,'TG','Togo','+228'),(174,'TO','Tonga','+676'),(175,'TT','Trinidad and Tobago','+1-868'),(176,'TN','Tunisia','+216'),(177,'TR','Turkey','+90'),(178,'TM','Turkmenistan','+993'),(179,'TV','Tuvalu','+688'),(180,'UG','Uganda','+256'),(181,'UA','Ukraine','+380'),(182,'AE','United Arab Emirates','+971'),(183,'GB','United Kingdom','+44'),(184,'US','United States','+1'),(185,'UY','Uruguay','+598'),(186,'UZ','Uzbekistan','+998'),(187,'VU','Vanuatu','+678'),(188,'VA','Vatican City','+379'),(189,'VE','Venezuela','+58'),(190,'VN','Viet Nam','+84'),(191,'YE','Yemen','+967'),(192,'ZM','Zambia','+260'),(193,'ZW','Zimbabwe','+263'),(194,'GE','Abkhazia','+995'),(195,'TW','China, Republic of (Taiwan)','+886'),(196,'AZ','Nagorno-Karabakh','+374-97'),(197,'CY','Northern Cyprus','+90-392'),(198,'MD','Pridnestrovie (Transnistria)','+373-533'),(199,'SO','Somaliland','+252'),(200,'GE','South Ossetia','+995'),(201,'AU','Ashmore and Cartier Islands',''),(202,'CX','Christmas Island','+61'),(203,'CC','Cocos (Keeling) Islands','+61'),(204,'AU','Coral Sea Islands',''),(205,'HM','Heard Island and McDonald Islands',''),(206,'NF','Norfolk Island','+672'),(207,'NC','New Caledonia','+687'),(208,'PF','French Polynesia','+689'),(209,'YT','Mayotte','+269'),(210,'PM','Saint Pierre and Miquelon','+508'),(211,'WF','Wallis and Futuna','+681'),(212,'TF','French Southern and Antarctic Lands',''),(213,'PF','Clipperton Island',''),(214,'','French Scattered Islands in the Indian Ocean',''),(215,'BV','Bouvet Island',''),(216,'CK','Cook Islands','+682'),(217,'NU','Niue','+683'),(218,'TK','Tokelau','+690'),(219,'GG','Guernsey','+44'),(220,'IM','Isle of Man','+44'),(221,'JE','Jersey','+44'),(222,'AI','Anguilla','+1-264'),(223,'BM','Bermuda','+1-441'),(224,'IO','British Indian Ocean Territory','+246'),(225,'','British Sovereign Base Areas','+357'),(226,'VG','British Virgin Islands','+1-284'),(227,'KY','Cayman Islands','+1-345'),(228,'FK','Falkland Islands (Islas Malvinas)','+500'),(229,'GI','Gibraltar','+350'),(230,'MS','Montserrat','+1-664'),(231,'PN','Pitcairn Islands',''),(232,'SH','Saint Helena','+290'),(233,'GS','South Georgia and the South Sandwich Islands',''),(234,'TC','Turks and Caicos Islands','+1-649'),(235,'MP','Northern Mariana Islands','+1-670'),(236,'PR','Puerto Rico','+1-787 and 1-939'),(237,'AS','American Samoa','+1-684'),(238,'UM','Baker Island',''),(239,'GU','Guam','+1-671'),(240,'UM','Howland Island',''),(241,'UM','Jarvis Island',''),(242,'UM','Johnston Atoll',''),(243,'UM','Kingman Reef',''),(244,'UM','Midway Islands',''),(245,'UM','Navassa Island',''),(246,'UM','Palmyra Atoll',''),(247,'VI','U.S. Virgin Islands','+1-340'),(248,'UM','Wake Island',''),(249,'HK','Hong Kong','+852'),(250,'MO','Macau','+853'),(251,'FO','Faroe Islands','+298'),(252,'GL','Greenland','+299'),(253,'GF','French Guiana','+594'),(254,'GP','Guadeloupe','+590'),(255,'MQ','Martinique','+596'),(256,'RE','Reunion','+262'),(257,'AX','Aland','+358-18'),(258,'AW','Aruba','+297'),(259,'AN','Netherlands Antilles','+599'),(260,'SJ','Svalbard','+47'),(261,'AC','Ascension','+247'),(262,'TA','Tristan da Cunha',''),(263,'AQ','Antarctica',''),(264,'CS','Kosovo','+381'),(265,'PS','Palestinian Territories (Gaza Strip and West Bank)','+970'),(266,'EH','Western Sahara','+212'),(267,'AQ','Australian Antarctic Territory',''),(268,'AQ','Ross Dependency',''),(269,'AQ','Peter I Island',''),(270,'AQ','Queen Maud Land',''),(271,'AQ','British Antarctic Territory',''),(272,'TW','China','+886'),(273,'','Cape Verde Islands',NULL),(274,'KR','Korea','+82'),(275,'YU','Yugoslavia',NULL),(276,'TW','Taiwan','+886'),(277,'WI','West Indies',NULL);
/*!40000 ALTER TABLE `country` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2010-01-08 10:35:12
