9md6yGqd

1
2SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
3SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
4SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
5 
6 
7-- -----------------------------------------------------
8DROP DATABASE IF EXISTS webserver1;
9CREATE DATABASE IF NOT EXISTS webserver1;
10 
11CREATE SCHEMA IF NOT EXISTS webserver1 DEFAULT CHARACTER SET utf8 ;
12USE webserver1 ;
13
14-- -----------------------------------------------------
15-- Table mydb.Kunde
16-- -----------------------------------------------------
17CREATE TABLE Kunde (
18  kid INT NOT NULL AUTO_INCREMENT,
19  vorname VARCHAR(45),
20  nachname VARCHAR(45),
21  email VARCHAR(45),
22  telefonnummer INT ,
23  PRIMARY KEY (kid))
24ENGINE = InnoDB;
25
26
27-- -----------------------------------------------------
28-- Table mydb.Dienstleistung
29-- -----------------------------------------------------
30CREATE TABLE Dienstleistung (
31  did INT NOT NULL,
32  livemusik TINYINT,
33  tontechnik TINYINT,
34  dj TINYINT,
35  fotograf TINYINT,
36  PRIMARY KEY (did))
37ENGINE = InnoDB;
38
39
40-- -----------------------------------------------------
41-- Table mydb.Auftrag
42-- -----------------------------------------------------
43CREATE TABLE IF NOT EXISTS mydb.Auftrag (
44  aid INT NOT NULL,
45  beschreibung VARCHAR(255) NULL,
46  strasse VARCHAR(45) NULL,
47  hausnummer VARCHAR(45) NULL,
48  plz VARCHAR(5) NULL,
49  datum DATE NULL,
50  uhrzeit TIME NULL,
51  ort VARCHAR(45) NULL,
52  kid INT NOT NULL,
53  Dienstleistung_did INT NOT NULL,
54  PRIMARY KEY (aid),
55  INDEX fk_Auftrag_Kunde1_idx (kid ASC) VISIBLE,
56  INDEX fk_Auftrag_Dienstleistung1_idx (Dienstleistung_did ASC) VISIBLE,
57  CONSTRAINT fk_Auftrag_Kunde1
58    FOREIGN KEY (kid)
59    REFERENCES mydb.Kunde (nachname)
60    ON DELETE NO ACTION
61    ON UPDATE NO ACTION,
62  CONSTRAINT fk_Auftrag_Dienstleistung1
63    FOREIGN KEY (Dienstleistung_did)
64    REFERENCES mydb.Dienstleistung (did)
65    ON DELETE NO ACTION
66    ON UPDATE NO ACTION)
67ENGINE = InnoDB;
68
69
70-- -----------------------------------------------------
71-- Table mydb.Rezensionen
72-- -----------------------------------------------------
73CREATE TABLE IF NOT EXISTS mydb.Rezensionen (
74  rid INT NOT NULL,
75  vorname VARCHAR(45),
76  ort VARCHAR(45),
77  beschreibung VARCHAR(255),
78  Dienstleistung_did INT NOT NULL,
79  PRIMARY KEY (rid),
80  
81  CONSTRAINT fk_Rezensionen_Dienstleistung1
82    FOREIGN KEY (Dienstleistung_did)
83    REFERENCES mydb.Dienstleistung (did)
84    ON DELETE NO ACTION
85    ON UPDATE NO ACTION)
86ENGINE = InnoDB;
87
88
89SET SQL_MODE=@OLD_SQL_MODE;
90SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
91SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;