 -- Dumping data for table `airport`
 --
 
-INSERT INTO `airport` (`idAirport`, `Name`, `Capacity`, `Location`, `NbOfLanes`, `Region_idRegion`) VALUES
-(1, 'London', 10, '50,50', 6, 1),
-(2, 'Paris', 15, '80,80', 9, 1),
-(3, 'Berlin', 15, '100,100', 5, 1),
-(4, 'Sofia', 5, '10,20', 2, 1),
-(5, 'Eindhoven', 20, '65.35', 5, 1);
+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);
 
 -- --------------------------------------------------------
 

--

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');

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


-- AUTO_INCREMENT for table `airport`
--
ALTER TABLE `airport`
  MODIFY `IdAirport` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `flight`
--
