CREATE TABLE Buchung_Mietauto(
      BuchungsNr INT NOT NULL PRIMARY KEY,
      AutoID INT NOT NULL PRIMARY KEY,
      Abholort VARCHAR(40) NOT NULL,
      von DATE NOT NULL,
      Rückgabeort VARCHAR(40) NOT NULL,
      bis DATE NOT NULL,
      CONSTRAINT bim FOREIGN KEY(Buchungsnr) REFERENCES Buchung(Buchungsnr),
      CONSTRAINT aim FOREIGN KEY(AutoID) REFERENCES Mietauto(AutoID)
      )ENGINE=InnoDB;