CREATE TABLE Kunde (
  UserID INT AUTO_INCREMENT PRIMARY KEY,
  Vorname VARCHAR(15),
  Nachname VARCHAR(15),
  Email VARCHAR(30) ,
  Username VARCHAR(15) NOT NULL UNIQUE,
  Passwort VARCHAR(15) NOT NULL,
  CHECK(Passwort REGEXP '([A-Z]+[0-9]+[a-z]*)*'),
  CHECK(LENGTH(Passwort) > 5),
  CHECK(Email LIKE '%@%.%')
)ENGINE=InnoDB;

CREATE TABLE Mitarbeiter(
  UserID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  Vorname VARCHAR(15) NOT NULL,
  Nachname VARCHAR(15) NOT NULL,
  Email VARCHAR(30) NOT NULL DEFAULT 'support@online-booking.com',
  Gehalt INT NOT NULL DEFAULT 1500,
  CHECK(Email LIKE '%@%.%')
  )ENGINE=InnoDB;