CREATE TABLE City ( ID int(11) NOT NULL, Name char(35) NOT NULL default '', CountryCode char(3) NOT NULL default '', District char(20) NOT NULL default '', Population int(11) NOT NULL default '0', PRIMARY KEY (ID) ) ENGINE=MyISAM; +-------------+----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------+------+-----+---------+----------------+ | ID | int(11) | NO | PRI | | auto_increment | | Name | char(35) | NO | | | | | CountryCode | char(3) | NO | | | | | District | char(20) | NO | | | | | Population | int(11) | NO | | 0 | | +-------------+----------+------+-----+---------+----------------+ CREATE TABLE Country ( Code char(3) NOT NULL default '', Name char(52) NOT NULL default '', Continent enum('Asia','Europe','North America','Africa','Oceania','Antarctica','South America') NOT NULL default 'Asia', Region char(26) NOT NULL default '', SurfaceArea float(10,2) NOT NULL default '0.00', IndepYear smallint(6) default NULL, Population int(11) NOT NULL default '0', LifeExpectancy float(3,1) default NULL, GNP float(10,2) default NULL, GNPOld float(10,2) default NULL, LocalName char(45) NOT NULL default '', GovernmentForm char(45) NOT NULL default '', HeadOfState char(60) default NULL, Capital int(11) default NULL, Code2 char(2) NOT NULL default '', PRIMARY KEY (Code) ) ENGINE=MyISAM; +----------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+-------+ | Code | char(3) | NO | PRI | | | | Name | char(52) | NO | | | | | Continent | enum('Asia',ca') | NO | | Asia | | | Region | char(26) | NO | | | | | SurfaceArea | float(10,2) | NO | | 0.00 | | | IndepYear | smallint(6) | YES | | NULL | | | Population | int(11) | NO | | 0 | | | LifeExpectancy | float(3,1) | YES | | NULL | | | GNP | float(10,2) | YES | | NULL | | | GNPOld | float(10,2) | YES | | NULL | | | LocalName | char(45) | NO | | | | | GovernmentForm | char(45) | NO | | | | | HeadOfState | char(60) | YES | | NULL | | | Capital | int(11) | YES | | NULL | | | Code2 | char(2) | NO | | | | +----------------+------------------+------+-----+---------+-------+ CREATE TABLE CountryLanguage ( CountryCode char(3) NOT NULL default '', Language char(30) NOT NULL default '', IsOfficial enum('T','F') NOT NULL default 'F', Percentage float(3,1) NOT NULL default '0.0', PRIMARY KEY (CountryCode,Language) ) ENGINE=MyISAM; +-------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------+------+-----+---------+-------+ | CountryCode | char(3) | NO | PRI | | | | Language | char(30) | NO | PRI | | | | IsOfficial | enum('T','F') | NO | | F | | | Percentage | float(3,1) | NO | | 0.0 | | +-------------+---------------+------+-----+---------+-------+