CREATE TABLE uthyrning(
        tidendenuthyrdes datetime,
        film VARCHAR (20),
        butik VARCHAR (20),
        exnr VARCHAR (20),
        kund VARCHAR (20),
        inkasso VARCHAR (20),
        uthyrningstid datetime,
        faktisktaterlamningstid datetime,
        FOREIGN KEY (exnr, film, butik) REFERENCES filmex(exnr, film, butik),
        FOREIGN KEY (inkasso) REFERENCES inkasso(telnr),
        FOREIGN KEY (kund) REFERENCES kund(pnr),
        PRIMARY KEY (tidendenuthyrdes, film, butik, exnr, kund)
) Engine = INNODB;