 -- Indexes for table `airport`
 --
 ALTER TABLE `airport`
-  ADD PRIMARY KEY (`idAirport`,`Region_idRegion`),
+  ADD PRIMARY KEY (`IdAirport`,`Region_idRegion`),
   ADD KEY `fk_Airport_Region1_idx` (`Region_idRegion`);
 
 --

--

INSERT INTO `airplane` (`idAirplane`, `Capacity`, `Speed`, `Fuel`, `Location`) VALUES
(1, 100, 700, 3, '10,10'),
(2, 150, 800, 6, '50,50'),
(3, 90, 750, 7, '64,56'),
(4, 85, 600, 4, '85,45'),
(5, 50, 650, 10, '85,14'),
(6, 150, 700, 3, '45,45'),
(7, 90, 500, 9, '77,58'),
(8, 200, 700, 10, '33,54'),
(9, 120, 500, 5, '88,65'),
(10, 90, 800, 15, '25,36');

-- --------------------------------------------------------


-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Apr 03, 2017 at 07:45 PM
-- Server version: 10.1.13-MariaDB
-- PHP Version: 5.6.23

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
