rMHDax1W

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4
5
6-- -----------------------------------------------------
7-- Table `Adresse`
8-- -----------------------------------------------------
9DROP TABLE IF EXISTS `Adresse` ;
10
11SHOW WARNINGS;
12CREATE  TABLE IF NOT EXISTS `Adresse` (
13  `idAdresse`  NOT NULL ,
14  `Strasse` VARCHAR(45) NULL ,
15  `PLZ` VARCHAR(45) NULL ,
16  `Stadt` VARCHAR(45) NULL ,
17  PRIMARY KEY (`idAdresse`) )
18ENGINE = InnoDB;
19
20SHOW WARNINGS;
21
22-- -----------------------------------------------------
23-- Table `Mitglied`
24-- -----------------------------------------------------
25DROP TABLE IF EXISTS `Mitglied` ;
26
27SHOW WARNINGS;
28CREATE  TABLE IF NOT EXISTS `Mitglied` (
29  `idMitglied`  NOT NULL ,
30  `Name` VARCHAR(45) NULL ,
31  `Nachname` VARCHAR(45) NULL ,
32  `Adresse_idAdresse`  NULL ,
33  PRIMARY KEY (`idMitglied`) ,
34  CONSTRAINT `fk_Mitglied_Adresse`
35    FOREIGN KEY (`Adresse_idAdresse` )
36    REFERENCES `mydb`.`Adresse` (`idAdresse` )
37    ON DELETE NO ACTION
38    ON UPDATE NO ACTION)
39ENGINE = InnoDB;
40
41SHOW WARNINGS;
42CREATE INDEX `fk_Mitglied_Adresse` ON `Mitglied` (`Adresse_idAdresse` ASC) ;
43
44SHOW WARNINGS;
45
46
47SET SQL_MODE=@OLD_SQL_MODE;
48SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
49SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;