master_2014-04-05.sql

# ************************************************************
# Sequel Pro SQL dump
# Version 4096
#
# http://www.sequelpro.com/
# http://code.google.com/p/sequel-pro/
#
# Host: 8af2809e293652e222219d91ac59e78895a811b2.rackspaceclouddb.com (MySQL 5.1.72-2)
# Database: master
# Generation Time: 2014-04-05 13:37:32 +0000
# ************************************************************


/*!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 */;
/*!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 */;


# Dump of table countries
# ------------------------------------------------------------

DROP TABLE IF EXISTS `countries`;

CREATE TABLE `countries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `abbr` varchar(2) NOT NULL DEFAULT '',
  `name` varchar(100) NOT NULL DEFAULT '',
  `slug` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

LOCK TABLES `countries` WRITE;
/*!40000 ALTER TABLE `countries` DISABLE KEYS */;

INSERT INTO `countries` (`id`, `abbr`, `name`, `slug`)
VALUES
	(1,'US','United States','united-states'),
	(2,'CA','Canada','canada'),
	(3,'AF','Afghanistan','afghanistan'),
	(4,'AL','Albania','albania'),
	(5,'DZ','Algeria','algeria'),
	(6,'DS','American Samoa','american-samoa'),
	(7,'AD','Andorra','andorra'),
	(8,'AO','Angola','angola'),
	(9,'AI','Anguilla','anguilla'),
	(10,'AQ','Antarctica','antarctica'),
	(11,'AG','Antigua and/or Barbuda','antigua-barbuda'),
	(12,'AR','Argentina','argentina'),
	(13,'AM','Armenia','armenia'),
	(14,'AW','Aruba','aruba'),
	(15,'AU','Australia','australia'),
	(16,'AT','Austria','austria'),
	(17,'AZ','Azerbaijan','azerbaijan'),
	(18,'BS','Bahamas','bahamas'),
	(19,'BH','Bahrain','bahrain'),
	(20,'BD','Bangladesh','bangladesh'),
	(21,'BB','Barbados','barbados'),
	(22,'BY','Belarus','belarus'),
	(23,'BE','Belgium','belgium'),
	(24,'BZ','Belize','belize'),
	(25,'BJ','Benin','benin'),
	(26,'BM','Bermuda','bermuda'),
	(27,'BT','Bhutan','bhutan'),
	(28,'BO','Bolivia','bolivia'),
	(29,'BA','Bosnia and Herzegovina','bosnia-and-herzegovina'),
	(30,'BW','Botswana','botswana'),
	(31,'BV','Bouvet Island','bouvet-island'),
	(32,'BR','Brazil','brazil'),
	(33,'IO','British lndian Ocean Territory','british-lndian-ocean-territory'),
	(34,'BN','Brunei Darussalam','brunei-darussalam'),
	(35,'BG','Bulgaria','bulgaria'),
	(36,'BF','Burkina Faso','burkina-faso'),
	(37,'BI','Burundi','burundi'),
	(38,'KH','Cambodia','cambodia'),
	(39,'CM','Cameroon','cameroon'),
	(40,'CV','Cape Verde','cape-verde'),
	(41,'KY','Cayman Islands','cayman-islands'),
	(42,'CF','Central African Republic','central-african-republic'),
	(43,'TD','Chad','chad'),
	(44,'CL','Chile','chile'),
	(45,'CN','China','china'),
	(46,'CX','Christmas Island','christmas-island'),
	(47,'CC','Cocos (Keeling) Islands','cocos-islands'),
	(48,'CO','Colombia','colombia'),
	(49,'KM','Comoros','comoros'),
	(50,'CG','Congo','congo'),
	(51,'CK','Cook Islands','cook-islands'),
	(52,'CR','Costa Rica','costa-rica'),
	(53,'HR','Croatia (Hrvatska)','croatia'),
	(54,'CU','Cuba','cuba'),
	(55,'CY','Cyprus','cyprus'),
	(56,'CZ','Czech Republic','czech-republic'),
	(57,'DK','Denmark','denmark'),
	(58,'DJ','Djibouti','djibouti'),
	(59,'DM','Dominica','dominica'),
	(60,'DO','Dominican Republic','dominican-republic'),
	(61,'TP','East Timor','east-timor'),
	(62,'EC','Ecudaor','ecudaor'),
	(63,'EG','Egypt','egypt'),
	(64,'SV','El Salvador','el-salvador'),
	(65,'GQ','Equatorial Guinea','equatorial-guinea'),
	(66,'ER','Eritrea','eritrea'),
	(67,'EE','Estonia','estonia'),
	(68,'ET','Ethiopia','ethiopia'),
	(69,'FK','Falkland Islands (Malvinas)','falkland-islands'),
	(70,'FO','Faroe Islands','faroe-islands'),
	(71,'FJ','Fiji','fiji'),
	(72,'FI','Finland','finland'),
	(73,'FR','France','france'),
	(74,'FX','France, Metropolitan','france-metropolitan'),
	(75,'GF','French Guiana','french-guiana'),
	(76,'PF','French Polynesia','french-polynesia'),
	(77,'TF','French Southern Territories','french-southern-territories'),
	(78,'GA','Gabon','gabon'),
	(79,'GM','Gambia','gambia'),
	(80,'GE','Georgia','georgia'),
	(81,'DE','Germany','germany'),
	(82,'GH','Ghana','ghana'),
	(83,'GI','Gibraltar','gibraltar'),
	(84,'GR','Greece','greece'),
	(85,'GL','Greenland','greenland'),
	(86,'GD','Grenada','grenada'),
	(87,'GP','Guadeloupe','guadeloupe'),
	(88,'GU','Guam','guam'),
	(89,'GT','Guatemala','guatemala'),
	(90,'GN','Guinea','guinea'),
	(91,'GW','Guinea-Bissau','guinea-bissau'),
	(92,'GY','Guyana','guyana'),
	(93,'HT','Haiti','haiti'),
	(94,'HM','Heard and Mc Donald Islands','heard-and-mc-donald-islands'),
	(95,'HN','Honduras','honduras'),
	(96,'HK','Hong Kong','hong-kong'),
	(97,'HU','Hungary','hungary'),
	(98,'IS','Iceland','iceland'),
	(99,'IN','India','india'),
	(100,'ID','Indonesia','indonesia'),
	(101,'IR','Iran (Islamic Republic of)','iran'),
	(102,'IQ','Iraq','iraq'),
	(103,'IE','Ireland','ireland'),
	(104,'IL','Israel','israel'),
	(105,'IT','Italy','italy'),
	(106,'CI','Ivory Coast','ivory-coast'),
	(107,'JM','Jamaica','jamaica'),
	(108,'JP','Japan','japan'),
	(109,'JO','Jordan','jordan'),
	(110,'KZ','Kazakhstan','kazakhstan'),
	(111,'KE','Kenya','kenya'),
	(112,'KI','Kiribati','kiribati'),
	(113,'KP','Korea, Democratic People\'s Republic of','peoples-republic-of-korea'),
	(114,'KR','Korea, Republic of','republic-of-korea'),
	(115,'KW','Kuwait','kuwait'),
	(116,'KG','Kyrgyzstan','kyrgyzstan'),
	(117,'LA','Lao People\'s Democratic Republic','lao'),
	(118,'LV','Latvia','latvia'),
	(119,'LB','Lebanon','lebanon'),
	(120,'LS','Lesotho','lesotho'),
	(121,'LR','Liberia','liberia'),
	(122,'LY','Libyan Arab Jamahiriya','libyan-arab-jamahiriya'),
	(123,'LI','Liechtenstein','liechtenstein'),
	(124,'LT','Lithuania','lithuania'),
	(125,'LU','Luxembourg','luxembourg'),
	(126,'MO','Macau','macau'),
	(127,'MK','Macedonia','macedonia'),
	(128,'MG','Madagascar','madagascar'),
	(129,'MW','Malawi','malawi'),
	(130,'MY','Malaysia','malaysia'),
	(131,'MV','Maldives','maldives'),
	(132,'ML','Mali','mali'),
	(133,'MT','Malta','malta'),
	(134,'MH','Marshall Islands','marshall-islands'),
	(135,'MQ','Martinique','martinique'),
	(136,'MR','Mauritania','mauritania'),
	(137,'MU','Mauritius','mauritius'),
	(138,'TY','Mayotte','mayotte'),
	(139,'MX','Mexico','mexico'),
	(140,'FM','Micronesia, Federated States of','micronesia'),
	(141,'MD','Moldova, Republic of','moldova'),
	(142,'MC','Monaco','monaco'),
	(143,'MN','Mongolia','mongolia'),
	(144,'MS','Montserrat','montserrat'),
	(145,'MA','Morocco','morocco'),
	(146,'MZ','Mozambique','mozambique'),
	(147,'MM','Myanmar','myanmar'),
	(148,'NA','Namibia','namibia'),
	(149,'NR','Nauru','nauru'),
	(150,'NP','Nepal','nepal'),
	(151,'NL','Netherlands','netherlands'),
	(152,'AN','Netherlands Antilles','netherlands-antilles'),
	(153,'NC','New Caledonia','new-caledonia'),
	(154,'NZ','New Zealand','new-zealand'),
	(155,'NI','Nicaragua','nicaragua'),
	(156,'NE','Niger','niger'),
	(157,'NG','Nigeria','nigeria'),
	(158,'NU','Niue','niue'),
	(159,'NF','Norfork Island','norfork-island'),
	(160,'MP','Northern Mariana Islands','northern-mariana-islands'),
	(161,'NO','Norway','norway'),
	(162,'OM','Oman','oman'),
	(163,'PK','Pakistan','pakistan'),
	(164,'PW','Palau','palau'),
	(165,'PA','Panama','panama'),
	(166,'PG','Papua New Guinea','papua-new-guinea'),
	(167,'PY','Paraguay','paraguay'),
	(168,'PE','Peru','peru'),
	(169,'PH','Philippines','philippines'),
	(170,'PN','Pitcairn','pitcairn'),
	(171,'PL','Poland','poland'),
	(172,'PT','Portugal','portugal'),
	(173,'PR','Puerto Rico','puerto-rico'),
	(174,'QA','Qatar','qatar'),
	(175,'RE','Reunion','reunion'),
	(176,'RO','Romania','romania'),
	(177,'RU','Russian Federation','russian-federation'),
	(178,'RW','Rwanda','rwanda'),
	(179,'KN','Saint Kitts and Nevis','saint-kitts-and-nevis'),
	(180,'LC','Saint Lucia','saint-lucia'),
	(181,'VC','Saint Vincent and the Grenadines','saint-vincent-and-the-grenadines'),
	(182,'WS','Samoa','samoa'),
	(183,'SM','San Marino','san-marino'),
	(184,'ST','Sao Tome and Principe','sao-tome-and-principe'),
	(185,'SA','Saudi Arabia','saudi-arabia'),
	(186,'SN','Senegal','senegal'),
	(187,'SC','Seychelles','seychelles'),
	(188,'SL','Sierra Leone','sierra-leone'),
	(189,'SG','Singapore','singapore'),
	(190,'SK','Slovakia','slovakia'),
	(191,'SI','Slovenia','slovenia'),
	(192,'SB','Solomon Islands','solomon-islands'),
	(193,'SO','Somalia','somalia'),
	(194,'ZA','South Africa','south-africa'),
	(195,'GS','South Georgia South Sandwich Islands','south-georgia-south-sandwich-islands'),
	(196,'ES','Spain','spain'),
	(197,'LK','Sri Lanka','sri-lanka'),
	(198,'SH','St. Helena','st.-helena'),
	(199,'PM','St. Pierre and Miquelon','st.-pierre-and-miquelon'),
	(200,'SD','Sudan','sudan'),
	(201,'SR','Suriname','suriname'),
	(202,'SJ','Svalbarn and Jan Mayen Islands','svalbarn-and-jan-mayen-islands'),
	(203,'SZ','Swaziland','swaziland'),
	(204,'SE','Sweden','sweden'),
	(205,'CH','Switzerland','switzerland'),
	(206,'SY','Syrian Arab Republic','syrian-arab-republic'),
	(207,'TW','Taiwan','taiwan'),
	(208,'TJ','Tajikistan','tajikistan'),
	(209,'TZ','Tanzania, United Republic of','tanzania,-united-republic-of'),
	(210,'TH','Thailand','thailand'),
	(211,'TG','Togo','togo'),
	(212,'TK','Tokelau','tokelau'),
	(213,'TO','Tonga','tonga'),
	(214,'TT','Trinidad and Tobago','trinidad-and-tobago'),
	(215,'TN','Tunisia','tunisia'),
	(216,'TR','Turkey','turkey'),
	(217,'TM','Turkmenistan','turkmenistan'),
	(218,'TC','Turks and Caicos Islands','turks-and-caicos-islands'),
	(219,'TV','Tuvalu','tuvalu'),
	(220,'UG','Uganda','uganda'),
	(221,'UA','Ukraine','ukraine'),
	(222,'AE','United Arab Emirates','united-arab-emirates'),
	(223,'GB','United Kingdom','united-kingdom'),
	(224,'UM','United States minor outlying islands','united-states-minor-outlying-islands'),
	(225,'UY','Uruguay','uruguay'),
	(226,'UZ','Uzbekistan','uzbekistan'),
	(227,'VU','Vanuatu','vanuatu'),
	(228,'VA','Vatican City State','vatican-city-state'),
	(229,'VE','Venezuela','venezuela'),
	(230,'VN','Vietnam','vietnam'),
	(231,'VG','Virigan Islands (British)','british-virigan-islands'),
	(232,'VI','Virgin Islands (U.S.)','us-virgin-islands'),
	(233,'WF','Wallis and Futuna Islands','wallis-and-futuna-islands'),
	(234,'EH','Western Sahara','western-sahara'),
	(235,'YE','Yemen','yemen'),
	(236,'YU','Yugoslavia','yugoslavia'),
	(237,'ZR','Zaire','zaire'),
	(238,'ZM','Zambia','zambia'),
	(239,'ZW','Zimbabwe','zimbabwe');

/*!40000 ALTER TABLE `countries` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_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 */;