· 8 years ago · Jul 20, 2018, 02:10 PM
1CREATE TABLE IF NOT EXISTS `db8626x1643255`.`Land_Artikel_Zuweisung` (
2 `FK_Artikel_ArtikelNr` INT NOT NULL ,
3 `FK_Land_id` INT NOT NULL ,
4 INDEX `index_FK_Artikel_ArtikelNr` (`FK_Artikel_ArtikelNr` ASC) ,
5 INDEX `index_FK_Land_id` (`FK_Land_id` ASC) ,
6 PRIMARY KEY (`FK_Artikel_ArtikelNr`, `FK_Land_id`) ,
7 CONSTRAINT `FK_Artikel_ArtikelNr`
8 FOREIGN KEY (`FK_Artikel_ArtikelNr` )
9 REFERENCES `db8626x1643255`.`Artikel` (`ArtikelNr` )
10 ON DELETE NO ACTION
11 ON UPDATE NO ACTION,
12 CONSTRAINT `FK_Land_id`
13 FOREIGN KEY (`FK_Land_id` )
14 REFERENCES `db8626x1643255`.`Land` (`id` )
15 ON DELETE NO ACTION
16 ON UPDATE NO ACTION)
17ENGINE = InnoDB
18DEFAULT CHARACTER SET = utf8
19COLLATE = utf8_general_ci