PHP Classes
elePHPant
Icontem

File: locations.sql

Recommend this page to a friend!
  Classes of Manuel Lemos  >  PHP Forms Class with HTML Generator and JavaScript Validation  >  locations.sql  >  Download  
File: locations.sql
Role: Auxiliary data
Content type: text/plain
Description: Locations MySQL database schema dump for the linked select inputs example
Class: PHP Forms Class with HTML Generator and JavaScript Validation
HTML forms generation and validation.
Author: By
Last change: Used a MySQL dump for more recent servers.
Date: 2 months ago
Size: 2,012 bytes
 

Contents

Class file image Download
-- 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');