Fm0XdbqU

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  `businessName` VARCHAR(45) NULL,
25  `phone` VARCHAR(45) NULL,
26  `status` VARCHAR(45) NOT NULL,
27  PRIMARY KEY (`idUser`),
28  UNIQUE INDEX `email_UNIQUE` (`email` ASC))
29ENGINE = InnoDB;
30
31
32-- -----------------------------------------------------
33-- Table `sundebygninger`.`building`
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS `sundebygninger`.`building` (
36  `idBuilding` INT NOT NULL AUTO_INCREMENT,
37  `address` VARCHAR(45) NOT NULL,
38  `cadastral` VARCHAR(45) NULL,
39  `area` VARCHAR(45) NULL,
40  `condition` VARCHAR(45) NULL,
41  `service` VARCHAR(45) NULL,
42  `extraText` VARCHAR(2500) NULL,
43  `fk_idUser` INT NOT NULL,
44  PRIMARY KEY (`idBuilding`),
45  INDEX `fk_building_user_idx` (`fk_idUser` ASC),
46  CONSTRAINT `fk_building_user`
47    FOREIGN KEY (`fk_idUser`)
48    REFERENCES `sundebygninger`.`user` (`idUser`)
49    ON DELETE NO ACTION
50    ON UPDATE NO ACTION)
51ENGINE = InnoDB;
52
53
54-- -----------------------------------------------------
55-- Table `sundebygninger`.`picture`
56-- -----------------------------------------------------
57CREATE TABLE IF NOT EXISTS `sundebygninger`.`picture` (
58  `idPicture` INT NOT NULL AUTO_INCREMENT,
59  `description` VARCHAR(500) NULL,
60  `type` VARCHAR(45) NULL,
61  `fk_idBuilding` INT NOT NULL,
62  PRIMARY KEY (`idPicture`),
63  INDEX `fk_picture_building1_idx` (`fk_idBuilding` ASC),
64  CONSTRAINT `fk_picture_building1`
65    FOREIGN KEY (`fk_idBuilding`)
66    REFERENCES `sundebygninger`.`building` (`idBuilding`)
67    ON DELETE NO ACTION
68    ON UPDATE NO ACTION)
69ENGINE = InnoDB;
70
71
72SET SQL_MODE=@OLD_SQL_MODE;
73SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
74SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;