hqHvVnw8

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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
6
7-- -----------------------------------------------------
8-- Schema CI_kominiarczyk_temp
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema CI_kominiarczyk_temp
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `CI_kominiarczyk_temp` DEFAULT CHARACTER SET utf8 ;
15USE `CI_kominiarczyk_temp` ;
16
17-- -----------------------------------------------------
18-- Table `CI_kominiarczyk_temp`.`User`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `CI_kominiarczyk_temp`.`User` (
21  `idUser` INT NOT NULL AUTO_INCREMENT,
22  `Email` TINYTEXT NULL,
23  `Password` TINYTEXT NULL,
24  PRIMARY KEY (`idUser`))
25ENGINE = InnoDB;
26
27
28-- -----------------------------------------------------
29-- Table `CI_kominiarczyk_temp`.`City`
30-- -----------------------------------------------------
31CREATE TABLE IF NOT EXISTS `CI_kominiarczyk_temp`.`City` (
32  `idCity` INT NOT NULL AUTO_INCREMENT,
33  `Name` TINYTEXT NULL,
34  PRIMARY KEY (`idCity`),
35  UNIQUE INDEX `idCity_UNIQUE` (`idCity` ASC) VISIBLE)
36ENGINE = InnoDB;
37
38
39-- -----------------------------------------------------
40-- Table `CI_kominiarczyk_temp`.`House`
41-- -----------------------------------------------------
42CREATE TABLE IF NOT EXISTS `CI_kominiarczyk_temp`.`House` (
43  `idHouse` INT NOT NULL AUTO_INCREMENT,
44  `HouseNumber` TINYINT NULL,
45  `Owner` MEDIUMTEXT NULL,
46  `LastFailedControl` TINYTEXT NULL,
47  `City_idCity` INT NOT NULL,
48  PRIMARY KEY (`idHouse`),
49  INDEX `fk_House_City_idx` (`City_idCity` ASC) VISIBLE,
50  CONSTRAINT `fk_House_City`
51    FOREIGN KEY (`City_idCity`)
52    REFERENCES `CI_kominiarczyk_temp`.`City` (`idCity`)
53    ON DELETE NO ACTION
54    ON UPDATE NO ACTION)
55ENGINE = InnoDB;
56
57
58-- -----------------------------------------------------
59-- Table `CI_kominiarczyk_temp`.`Building`
60-- -----------------------------------------------------
61CREATE TABLE IF NOT EXISTS `CI_kominiarczyk_temp`.`Building` (
62  `idBuilding` INT NOT NULL AUTO_INCREMENT,
63  `StreetName` TINYTEXT NULL,
64  `BuildingNumber` TINYTEXT NULL,
65  `House_idHouse1` INT NOT NULL,
66  PRIMARY KEY (`idBuilding`),
67  INDEX `fk_Building_House1_idx` (`House_idHouse1` ASC) VISIBLE,
68  CONSTRAINT `fk_Building_House1`
69    FOREIGN KEY (`House_idHouse1`)
70    REFERENCES `CI_kominiarczyk_temp`.`House` (`idHouse`)
71    ON DELETE NO ACTION
72    ON UPDATE NO ACTION)
73ENGINE = InnoDB;
74
75
76-- -----------------------------------------------------
77-- Table `CI_kominiarczyk_temp`.`JsonControl`
78-- -----------------------------------------------------
79CREATE TABLE IF NOT EXISTS `CI_kominiarczyk_temp`.`JsonControl` (
80  `idJsonControl` INT NOT NULL AUTO_INCREMENT,
81  `Json` LONGTEXT NULL,
82  `Building_idBuilding` INT NOT NULL,
83  PRIMARY KEY (`idJsonControl`),
84  INDEX `fk_JsonControl_Building1_idx` (`Building_idBuilding` ASC) VISIBLE,
85  CONSTRAINT `fk_JsonControl_Building1`
86    FOREIGN KEY (`Building_idBuilding`)
87    REFERENCES `CI_kominiarczyk_temp`.`Building` (`idBuilding`)
88    ON DELETE NO ACTION
89    ON UPDATE NO ACTION)
90ENGINE = InnoDB;
91
92
93SET SQL_MODE=@OLD_SQL_MODE;
94SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
95SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;