9AY5Wnby

1-- -----------------------------------------------------
2-- Table `bestellungen`.`benutzer`
3-- -----------------------------------------------------
4DROP TABLE IF EXISTS `bestellungen`.`benutzer` ;
5
6CREATE  TABLE IF NOT EXISTS `bestellungen`.`benutzer` (
7  `ben_id` INT NOT NULL AUTO_INCREMENT ,
8  `ben_vorname` VARCHAR(20) NULL  ,
9  `ben_nachname` VARCHAR(20) NULL ,
10  `ben_kuerz` VARCHAR(5) NULL ,
11  `ben_pass` VARCHAR(50) NULL  ,
12  `ben_admin` TINYINT(1) NULL DEFAULT 0  ,
13  `ben_passexp` TINYINT(1) NULL DEFAULT 0  ,
14  `ben_anlagedatum` TIMESTAMP NULL DEFAULT current_timestamp() ,
15  PRIMARY KEY (`ben_id`) )
16ENGINE = InnoDB
17DEFAULT CHARACTER SET = utf8
18COLLATE = utf8_bin;
19-- -----------------------------------------------------
20-- Table `bestellungen`.`dokumente`
21-- -----------------------------------------------------
22DROP TABLE IF EXISTS `bestellungen`.`dokumente` ;
23
24CREATE  TABLE IF NOT EXISTS `bestellungen`.`dokumente` (
25  `dok_id` INT NOT NULL AUTO_INCREMENT  ,
26  `dok_ben_ben_id` INT NULL ,
27  `dok_name` VARCHAR(20) NULL  ,
28  `dok_pfad` VARCHAR(1024) NULL  ,
29  `dok_admin` TINYINT(1) NULL DEFAULT 0  ,
30  PRIMARY KEY (`dok_id`) ,
31  INDEX `fk_dok_ben_ben_id_idx` (`dok_ben_ben_id` ASC) ,
32  CONSTRAINT `fk_dok_ben_ben_id`
33    FOREIGN KEY (`dok_ben_ben_id` )
34    REFERENCES `bestellungen`.`benutzer` (`ben_id` )
35    ON DELETE NO ACTION
36    ON UPDATE NO ACTION)
37ENGINE = InnoDB;