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

-- Indexes for table `airport`
--
ALTER TABLE `airport`
  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, '480,390'),
(2, 150, 800, 6, '250,150'),
(3, 90, 750, 7, '270,540'),
(4, 85, 600, 4, '780,380'),
(5, 50, 650, 10, '250,150'),
(6, 150, 700, 3, '675,500'),
(7, 90, 500, 9, '270,540'),
(8, 200, 700, 10, '780,380'),
(9, 120, 500, 5, '270,540'),
(10, 90, 800, 15, '675,500');

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

