9kCMtqCj

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,ALLOW_INVALID_DATES';
4
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-- -----------------------------------------------------
16-- Table Kunde
17-- -----------------------------------------------------
18CREATE TABLE Kunde (
19  kid INT NOT NULL AUTO_INCREMENT,
20  vorname VARCHAR(45),
21  nachname VARCHAR(45),
22  email VARCHAR(45),
23  Telefonnummer INT,
24  PRIMARY KEY (kid));
25
26
27-- -----------------------------------------------------
28-- Table Auftrag
29-- -----------------------------------------------------
30CREATE TABLE Auftrag (
31  aid INT NOT NULL AUTO_INCREMENT,
32  beschreibung VARCHAR(255),
33  strasse VARCHAR(45),
34  hausnummer VARCHAR(45),
35  plz VARCHAR(45),
36  datum DATE,
37  uhrzeit TIME(6),
38  ort VARCHAR(45),
39  kid INT NOT NULL,
40  PRIMARY KEY (aid),
41  CONSTRAINT fk_Auftrag_Kunde1
42    FOREIGN KEY (kid)
43    REFERENCES Kunde (kid)
44    ON DELETE NO ACTION
45    ON UPDATE NO ACTION);
46
47
48-- -----------------------------------------------------
49-- Table Rezensionen
50-- -----------------------------------------------------
51CREATE TABLE Rezensionen (
52  rid INT NOT NULL AUTO_INCREMENT,
53  vorname VARCHAR(45),
54  ort VARCHAR(45),
55  beschreibung VARCHAR(255),
56  PRIMARY KEY (rid));
57
58
59-- -----------------------------------------------------
60-- Table Dienstleistung
61-- -----------------------------------------------------
62CREATE TABLE Dienstleistung (
63  did INT NOT NULL AUTO_INCREMENT,
64  livemusik TINYINT,
65  tontechnik TINYINT,
66  dj TINYINT,
67  fotograf TINYINT,
68  aid INT NOT NULL,
69  Rezensionen_rid INT NOT NULL,
70  PRIMARY KEY (did),
71  CONSTRAINT fk_Dienstleistung_Auftrag1
72    FOREIGN KEY (aid)
73    REFERENCES Auftrag (aid)
74    ON DELETE NO ACTION
75    ON UPDATE NO ACTION,
76  CONSTRAINT fk_Dienstleistung_Rezensionen1
77    FOREIGN KEY (Rezensionen_rid)
78    REFERENCES Rezensionen (rid)
79    ON DELETE NO ACTION
80    ON UPDATE NO ACTION);
81
82
83	
84SET SQL_MODE=@OLD_SQL_MODE;
85SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
86SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;