VegSFSET

1drop table if exists bestellungen;
2create table bestellungen(
3    bestellungsnummer INT(4) NOT NULL PRIMARY KEY auto_increment,
4    artnr INT(4) NOT NULL,
5    knr INT(4) NOT NULL,
6    menge INT(100) NOT NULL,
7    preis float(6,2) NOT NULL
8)ENGINE = InnoDB;
9
10ALTER TABLE `bestellungen`
11  ADD CONSTRAINT `bestellungen_ibfk_1` FOREIGN KEY (`artnr`) REFERENCES `artikel` (`artikelnummer`);
12  ADD CONSTRAINT `bestellungen_ibfk_2` FOREIGN KEY (`knr`) REFERENCES `kunden` (`kundennummer`);