Не создаётся таблица в MySql

USE db_auto;
 
DROP TABLE IF EXISTS `auto`;
CREATE TABLE `auto` (
  `mark` varchar(50) NOT NULL,
  `model` varchar(50) NOT NULL,
  `massa` int NOT NULL,
  `max_speed` int NOT NULL,
  `gass_km` varchar(50) NOT NULL, 
  `price` varchar(50) NOT NULL,
  `code_body` varchar(50) NOT NULL,
  `code_motor` varchar(50) NOT NULL,
  PRIMARY KEY  (`mark`, `model`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `auto`(mark, model, massa, max_speed, gass_km, price, code_body, code_motor) VALUES ('BMW', 'X5', 5100, 260, '7.2 l/km', '2.000.000 uah', 'BMW-X5-B2314', 'BMW-X5-M2314');
INSERT INTO `auto`(mark, model, massa, max_speed, gass_km, price, code_body, code_motor) VALUES ('BMW', 'X6', 5250, 270, '7.0 l/km', '2.600.000 uah', 'BMW-X6-B7639', 'BMW-X6-M7639');
INSERT INTO `auto`(mark, model, massa, max_speed, gass_km, price, code_body, code_motor) VALUES ('AUDI', 'A6', 4700, 250, '8.3 l/km', '1.500.000 uah', 'AUDI-A6-B1092', 'AUDI-A6-M1092');
INSERT INTO `auto`(mark, model, massa, max_speed, gass_km, price, code_body, code_motor) VALUES ('AUDI', 'Q8', 4950, 270, '6.9 l/km', '1.900.000 uah', 'AUDI-Q8-B3065', 'AUDI-Q8-M3065');
INSERT INTO `auto`(mark, model, massa, max_speed, gass_km, price, code_body, code_motor) VALUES ('TOYOTA', 'Camry', 4800, 240, '8.0 l/km', '2.200.000 uah', 'TYT-CMR-B2049', 'TYT-CMR-M2049');
INSERT INTO `auto`(mark, model, massa, max_speed, gass_km, price, code_body, code_motor) VALUES ('TOYOTA', 'Corolla', 4690, 260, '8.5 l/km', '1.200.000 uah', 'TYT-CRL-B0233', 'TYT-CRL-M0233');
 
DROP TABLE IF EXISTS `body`;
CREATE TABLE `body` (
  `code_body` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `seat` int NOT NULL,
  `door` int NOT NULL,
  PRIMARY KEY  (`code_body`),
  FOREIGN KEY (`code_body`) REFERENCES `auto` (`code_body`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `body`(code_body, name, seat, door) VALUES ('BMW-X5-B2314', 'Crossover', 7, 5);
INSERT INTO `body`(code_body, name, seat, door) VALUES ('BMW-X6-B7639', 'Crossover', 4, 5);
INSERT INTO `body`(code_body, name, seat, door) VALUES ('AUDI-A6-B1092', 'Sedan', 5, 4);
INSERT INTO `body`(code_body, name, seat, door) VALUES ('AUDI-Q8-B3065', 'Crossover', 5, 5);
INSERT INTO `body`(code_body, name, seat, door) VALUES ('TYT-CMR-B2049', 'Sedan', 5, 4);
INSERT INTO `body`(code_body, name, seat, door) VALUES ('TYT-CRL-B0233', 'Sedan', 5, 4);
 
DROP TABLE IF EXISTS `motor`;
CREATE TABLE `motor` (
  `code_motor` varchar(50) NOT NULL,
  `type_gass` varchar(50) NOT NULL, 
  `volume` varchar(50) NOT NULL,
  `power` varchar(50) NOT NULL,
  PRIMARY KEY  (`code_motor`),
  FOREIGN KEY (`code_motor`) REFERENCES `auto` (`code_motor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `motor`(code_motor, type_gass, volume, power) VALUES ('BMW-X5-M2314', 'diesel', '400 hp', '3.0 l');
INSERT INTO `motor`(code_motor, type_gass, volume, power) VALUES ('BMW-X6-M7639', 'benzine', '306 hp', '3.0 l');
INSERT INTO `motor`(code_motor, type_gass, volume, power) VALUES ('AUDI-A6-M1092', 'diesel', '231 hp', '2.0 l');
INSERT INTO `motor`(code_motor, type_gass, volume, power) VALUES ('AUDI-Q8-M3065', 'diesel', '286 hp', '2.9 l');
INSERT INTO `motor`(code_motor, type_gass, volume, power) VALUES ('TYT-CMR-M2049', 'benzine', '218 hp', '2.4 l');
INSERT INTO `motor`(code_motor, type_gass, volume, power) VALUES ('TYT-CRL-M0233', 'benzine', '140 hp', '1.8 l');
 
DROP TABLE IF EXISTS `manufs`;
CREATE TABLE `manufs` (
  `manuf` varchar(50) NOT NULL,
  `country` varchar(50) NOT NULL, 
  PRIMARY KEY  (`manuf`),
  FOREIGN KEY (`manuf`) REFERENCES `auto` (`mark`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `manufs`(manuf, country) VALUES ('BMW', 'Germany');
INSERT INTO `manufs`(manuf, country) VALUES ('AUDI', 'Germany');
INSERT INTO `manufs`(manuf, country) VALUES ('TOYOTA', 'Japan');