   ADD PRIMARY KEY (`idAirplane`);
 
 --
--- Indexes for table `airplanecargo`
---
-ALTER TABLE `airplanecargo`
-  ADD PRIMARY KEY (`idAirplaneCargo`);
-
---
--- Indexes for table `airplanepassenger`
---
-ALTER TABLE `airplanepassenger`
-  ADD PRIMARY KEY (`idAirplanePassenger`);
-
---
 -- Indexes for table `airport`
 --
 ALTER TABLE `airport`

  `DepartureTime` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ArrivalTime` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Airplane_idAirplane` int(10) NOT NULL,
  `takesOffFrom` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `flight`
--

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

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


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