   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`

-- phpMyAdmin SQL Dump
-- version 4.5.1
-- 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";

--
ALTER TABLE `flight`
  ADD CONSTRAINT `fk_Flight_Airplane1` FOREIGN KEY (`Airplane_idAirplane`) REFERENCES `airplane` (`idAirplane`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_Flight_Airport` FOREIGN KEY (`LandsTo`) REFERENCES `airport` (`IdAirport`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_Flight_Airport1` FOREIGN KEY (`takesOffFrom`) REFERENCES `airport` (`IdAirport`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `problem`
--
ALTER TABLE `problem`
  ADD CONSTRAINT `fk_Problem_Airport1` FOREIGN KEY (`Airport_idAirport`,`Airport_Region_idRegion`) REFERENCES `airport` (`IdAirport`, `Region_idRegion`) ON DELETE NO ACTION ON UPDATE NO ACTION;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
