David Datenbank mit INSERT

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

-- -----------------------------------------------------
DROP DATABASE IF EXISTS db1;
CREATE DATABASE IF NOT EXISTS db1;

CREATE SCHEMA IF NOT EXISTS db1 DEFAULT CHARACTER SET utf8 ;
USE db1 ;


-- -----------------------------------------------------
-- Kunde
-- -----------------------------------------------------
CREATE TABLE Kunde (
  kid INT NOT NULL AUTO_INCREMENT,
  vorname VARCHAR(255) NOT NULL,
  nachname VARCHAR(45),
  email VARCHAR(45),
  Telefonnummer INT,
  PRIMARY KEY (kid))
  ENGINE = InnoDB;


-- -----------------------------------------------------
-- Auftrag
-- -----------------------------------------------------
CREATE TABLE Auftrag (
  aid INT NOT NULL AUTO_INCREMENT,
  beschreibung VARCHAR(255),
  strasse VARCHAR(45),
  hausnummer VARCHAR(45),
  plz VARCHAR(45),
  datum DATE,
  uhrzeit TIME(6),
  Kunde_kid INT NOT NULL,
  PRIMARY KEY (aid),
  CONSTRAINT fk_Auftrag_Kunde
    FOREIGN KEY (Kunde_kid)
    REFERENCES Kunde (kid)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
    ENGINE = InnoDB;


-- -----------------------------------------------------
--Dienstleistung
-- -----------------------------------------------------
CREATE TABLE Dienstleistung (
  did INT NOT NULL AUTO_INCREMENT,
  livemusik VARCHAR(45) NOT NULL,
  tontechnik VARCHAR(45),
  dj VARCHAR(45),
  fotograf VARCHAR(45),
  PRIMARY KEY (did))
  ENGINE = InnoDB;


-- -----------------------------------------------------
--Dienstleistung2Auftrag
-- -----------------------------------------------------
CREATE TABLE Dienstleistung2Auftrag (
  did INT NOT NULL,
  aid INT NOT NULL,
  PRIMARY KEY (did, aid),
  CONSTRAINT fk_Dienstleistung_has_Auftrag_Dienstleistung1
    FOREIGN KEY (did)
    REFERENCES Dienstleistung (did)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT fk_Dienstleistung_has_Auftrag_Auftrag1
    FOREIGN KEY (aid)
    REFERENCES Auftrag (aid)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
    ENGINE = InnoDB;


-- -----------------------------------------------------
-- Rezensionen
-- -----------------------------------------------------
CREATE TABLE Rezensionen (
  rid INT NOT NULL AUTO_INCREMENT,
  vorname VARCHAR(45) NOT NULL,
  ort VARCHAR(45),
  beschreibung VARCHAR(255),
  Dienstleistung_did INT NOT NULL,
  PRIMARY KEY (rid),
  CONSTRAINT fk_Rezensionen_Dienstleistung1
    FOREIGN KEY (Dienstleistung_did)
    REFERENCES mydb.Dienstleistung (did)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
    ENGINE = InnoDB;
-------------------------------------------
INSERT INTO Kunde (vorname,nachname,email,telefonnummer ) VALUES
('Lindenberg', 'Udo','david.lfveringhaus@gmail.com','1431515235324'),
('Merkel', 'Angelo','david.leveringkaus@gmail.com','3231431253554245'),
('Trump', 'Donald''david.leverhnghaus@gmail.com','1341235145425'),
('Mueller', 'Anke''david.leeeringhaus@gmail.com','53215231235123'),
('Seehofer', 'Horst''david.levhringhaus@gmail.com','1234324213414'),
('Pan', 'Peter','david.leverinehaus@gmail.com','14312431241'),
('Hernandez', 'James','david.lezeringhaus@gmail.com','123412341234'),
('Darm', 'David','david.leveringhuus@gmail.com','4732746123467'),
('Schroeder', 'Haci','david.levejinghaus@gmail.com','31238272626727'),
('Meier', 'Guenther','david.levqringhaus@gmail.com','2323412412412'),
('Baumann', 'Ralf','david.leversnghaus@gmail.com','4341341234241'),
('Abou Hamzel', 'Martin','david.leveringhahs@gmail.com','34881242234'),
('Schmidt', 'Paul','david.leveringhavs@gmail.com','8712374478874');


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;