-- MySQL dump 10.13
--
-- Host: localhost    Database: locations
-- ------------------------------------------------------
-- Server version	5.6.37-log

--
-- Table structure for table `continents`
--

DROP TABLE IF EXISTS `continents`;
CREATE TABLE `continents` (
  `code` char(2) NOT NULL DEFAULT '',
  `name` char(16) NOT NULL DEFAULT '',
  PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `continents`
--

INSERT INTO `continents` VALUES ('na','North America'),('eu','Europe'),('sa','South America'),('as','Asia'),('oc','Oceania');

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

DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries` (
  `code` char(2) NOT NULL DEFAULT '',
  `name` char(16) NOT NULL DEFAULT '',
  `continent` char(2) NOT NULL DEFAULT '',
  PRIMARY KEY (`code`,`continent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `countries` VALUES ('us','United States','na'),('ca','Canada','na'),('pt','Portugal','eu'),('de','Germany','eu'),('br','Brazil','sa'),('ar','Argentina','sa'),('jp','Japan','as'),('kr','Korea','as'),('au','Australia','oc'),('nz','New Zeland','oc');

--
-- Table structure for table `locations`
--

DROP TABLE IF EXISTS `locations`;
CREATE TABLE `locations` (
  `code` char(2) NOT NULL DEFAULT '',
  `name` char(16) NOT NULL DEFAULT '',
  `country` char(2) NOT NULL DEFAULT '',
  PRIMARY KEY (`code`,`country`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` VALUES ('ny','New York','us'),('la','Los Angeles','us'),('to','Toronto','ca'),('mo','Montr','ca'),('li','Lisbon','pt'),('av','Aveiro','pt'),('fr','Frankfurt','de'),('be','Berlin','de'),('sa','S','br'),('ri','Rio de Janeiro','br'),('bu','Buenos Aires','ar'),('ma','Mar del Plata','ar'),('to','Tokio','jp'),('os','Osaka','jp'),('se','Seoul','ky'),('yo','Yosu','kr'),('sy','Sydney','au'),('me','Melbourne','au'),('we','Wellington','nz'),('au','Auckland','nz');
