CREATE TABLE `countries` (
  `id_country` int(11) NOT NULL,
  `country_name` text NOT NULL,
  PRIMARY KEY (`id_country`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO 'country' VALUES (1,'Japan'),(2,'France'),(3,'Germany'),(4,'USA');

CREATE TABLE `cars` (
  `id` int(11) NOT NULL,
  `marc` varchar(255) DEFAULT NULL,
  `id_country` int(11) NOT NULL,
  'state' varchar(255) DEFAULT NULL,
  'owner' varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`id_country`) REFERENCES `countries` (`id_country`)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
INSERT INTO `cars` VALUES (
1,'Toyota','1','stolen','Vasya'),
(2,'BMW','3','unstolen','Dmirtiy'),
(3,'Ford','4','stolen','Victor');