ib4u2NLL

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema sundebygninger
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema sundebygninger
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `sundebygninger` DEFAULT CHARACTER SET utf8 ;
15USE `sundebygninger` ;
16
17-- -----------------------------------------------------
18-- Table `sundebygninger`.`user`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `sundebygninger`.`user` (
21  `idUser` INT NOT NULL AUTO_INCREMENT,
22  `email` VARCHAR(45) NOT NULL,
23  `password` VARCHAR(45) NOT NULL,
24  `phone` VARCHAR(45) NULL,
25  `status` VARCHAR(45) NOT NULL,
26  PRIMARY KEY (`idUser`),
27  UNIQUE INDEX `email_UNIQUE` (`email` ASC))
28ENGINE = InnoDB;
29
30
31-- -----------------------------------------------------
32-- Table `sundebygninger`.`building`
33-- -----------------------------------------------------
34CREATE TABLE IF NOT EXISTS `sundebygninger`.`building` (
35  `idBuilding` INT NOT NULL AUTO_INCREMENT,
36  `address` VARCHAR(45) NOT NULL,
37  `cadastral` VARCHAR(45) NULL,
38  `area` VARCHAR(45) NULL,
39  `condition` VARCHAR(45) NULL,
40  `service` VARCHAR(45) NULL,
41  `extraText` VARCHAR(2500) NULL,
42  `fk_idUser` INT NOT NULL,
43  PRIMARY KEY (`idBuilding`),
44  INDEX `fk_building_user_idx` (`fk_idUser` ASC),
45  CONSTRAINT `fk_building_user`
46    FOREIGN KEY (`fk_idUser`)
47    REFERENCES `sundebygninger`.`user` (`idUser`)
48    ON DELETE NO ACTION
49    ON UPDATE NO ACTION)
50ENGINE = InnoDB;
51
52
53-- -----------------------------------------------------
54-- Table `sundebygninger`.`picture`
55-- -----------------------------------------------------
56CREATE TABLE IF NOT EXISTS `sundebygninger`.`picture` (
57  `idPicture` INT NOT NULL AUTO_INCREMENT,
58  `description` VARCHAR(500) NULL,
59  `type` VARCHAR(45) NULL,
60  `fk_idBuilding` INT NOT NULL,
61  PRIMARY KEY (`idPicture`),
62  INDEX `fk_picture_building1_idx` (`fk_idBuilding` ASC),
63  CONSTRAINT `fk_picture_building1`
64    FOREIGN KEY (`fk_idBuilding`)
65    REFERENCES `sundebygninger`.`building` (`idBuilding`)
66    ON DELETE NO ACTION
67    ON UPDATE NO ACTION)
68ENGINE = InnoDB;
69
70
71SET SQL_MODE=@OLD_SQL_MODE;
72SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
73SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;