 --
 
 CREATE TABLE `airport` (
-  `idAirport` int(10) NOT NULL,
+  `IdAirport` int(10) NOT NULL,
   `Name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
   `Capacity` int(11) DEFAULT NULL,
   `Location` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,

--

INSERT INTO `flight` (`idFlight`, `LandsTo`, `NbOfPassengers`, `EstimatedDuration`, `DepartureTime`, `ArrivalTime`, `Airplane_idAirplane`, `takesOffFrom`) VALUES
(1, 1, 50, '2017-03-01 01:00:00.00', '2017-03-01 13:00:00', '2017-03-01 15:00:00', 2, 2),
(2, 4, 100, '2017-04-29 01:00:00.00', '2017-04-29 02:00:00', '2017-04-29 05:00:00', 1, 2),
(3, 3, 150, '2017-04-08 08:00:00.00', '2017-04-08 06:00:00', '2017-04-08 16:00:00', 10, 1),
(4, 5, 90, '2017-03-14 04:00:00.00', '2017-03-14 12:00:00', '2017-03-14 17:00:00', 6, 3),
(5, 4, 120, '2017-03-17 03:00:00.00', '2017-03-17 14:00:00', '2017-03-17 18:00:00', 4, 3),
(6, 2, 111, '2017-05-05 05:00:00.00', '2017-05-05 05:00:00', '2017-05-05 12:00:00', 8, 1),
(7, 2, 150, '2017-04-08 01:00:00.00', '2017-04-08 13:00:00', '2017-04-08 16:00:00', 3, 5),
(8, 4, 90, '2017-03-11 05:00:00.00', '2017-03-11 10:00:00', '2017-03-11 16:00:00', 9, 2),
(9, 2, 120, '2017-04-17 04:00:00.00', '2017-04-17 14:00:00', '2017-04-17 20:00:00', 5, 1),
(10, 4, 89, '2017-05-17 01:00:00.00', '2017-05-17 18:00:00', '2017-05-17 21:00:00', 2, 3);

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


-- Dumping data for table `airport`
--

INSERT INTO `airport` (`IdAirport`, `Name`, `Capacity`, `Location`, `NbOfLanes`, `Region_idRegion`) VALUES
(1, 'Germany', 100, '480,390', 2, 1),
(2, 'Bulgaria', 100, '675,500', 4, 1),
(3, 'Ukraine', 100, '780,380', 2, 1),
(4, 'Iceland', 100, '270,540', 3, 1),
(5, 'Spain', 100, '250,150', 1, 1);

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

