-- 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');
|