· 9 years ago · Jan 03, 2017, 10:18 AM
1-- MySQL Script generated by MySQL Workbench
2-- 01/03/17 10:14:08
3-- Model: New Model Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema mydb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`materialy`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`materialy` (
24 `id_materialu` INT NOT NULL,
25 `rodzaj` VARCHAR(45) NOT NULL,
26 PRIMARY KEY (`id_materialu`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `mydb`.`oferty`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `mydb`.`oferty` (
34 `id_oferty` INT NOT NULL,
35 `typ_oferty` VARCHAR(45) NOT NULL,
36 `typ_nieruchomosci` VARCHAR(45) NOT NULL,
37 `pokoje` INT NOT NULL,
38 `powierzchnia_m` INT NOT NULL,
39 `powierzchnia_d` INT NULL,
40 `rok` INT NOT NULL,
41 `l_pieter` INT NULL,
42 `pietro` INT NULL,
43 `id_materialu` INT NOT NULL,
44 `stan_l` INT NULL,
45 `stan_b` INT NULL,
46 `cena` INT NOT NULL,
47 `osiedle` VARCHAR(45) NULL,
48 PRIMARY KEY (`id_oferty`),
49 INDEX `id_materialu_idx` (`id_materialu` ASC),
50 CONSTRAINT `id_materialu`
51 FOREIGN KEY (`id_materialu`)
52 REFERENCES `mydb`.`materialy` (`id_materialu`)
53 ON DELETE NO ACTION
54 ON UPDATE NO ACTION)
55ENGINE = InnoDB;
56
57
58-- -----------------------------------------------------
59-- Table `mydb`.`wojewodztwa`
60-- -----------------------------------------------------
61CREATE TABLE IF NOT EXISTS `mydb`.`wojewodztwa` (
62 `id_wojewodztwa` INT NOT NULL,
63 `nazwa` VARCHAR(45) NULL,
64 PRIMARY KEY (`id_wojewodztwa`))
65ENGINE = InnoDB;
66
67
68-- -----------------------------------------------------
69-- Table `mydb`.`powiaty`
70-- -----------------------------------------------------
71CREATE TABLE IF NOT EXISTS `mydb`.`powiaty` (
72 `id_powiatu` INT NOT NULL,
73 `nazwa` VARCHAR(45) NULL,
74 `id_wojewodztwa` INT NULL,
75 PRIMARY KEY (`id_powiatu`),
76 INDEX `wojewodztwa_idx` (`id_wojewodztwa` ASC),
77 CONSTRAINT `id_wojewodztwa`
78 FOREIGN KEY (`id_wojewodztwa`)
79 REFERENCES `mydb`.`wojewodztwa` (`id_wojewodztwa`)
80 ON DELETE NO ACTION
81 ON UPDATE NO ACTION)
82ENGINE = InnoDB;
83
84
85-- -----------------------------------------------------
86-- Table `mydb`.`miasta`
87-- -----------------------------------------------------
88CREATE TABLE IF NOT EXISTS `mydb`.`miasta` (
89 `id_miasta` INT NOT NULL,
90 `nazwa` VARCHAR(45) NOT NULL,
91 `id_powiatu` INT NOT NULL,
92 PRIMARY KEY (`id_miasta`),
93 INDEX `powiaty_idx` (`id_powiatu` ASC),
94 CONSTRAINT `id_powiatu`
95 FOREIGN KEY (`id_powiatu`)
96 REFERENCES `mydb`.`powiaty` (`id_powiatu`)
97 ON DELETE NO ACTION
98 ON UPDATE NO ACTION)
99ENGINE = InnoDB;
100
101
102-- -----------------------------------------------------
103-- Table `mydb`.`adres`
104-- -----------------------------------------------------
105CREATE TABLE IF NOT EXISTS `mydb`.`adres` (
106 `id_oferty` INT NOT NULL,
107 `nr_budynku` INT NOT NULL,
108 `nr_lokalu` INT NULL,
109 `ulica` VARCHAR(45) NOT NULL,
110 `id_miasta` INT NULL,
111 PRIMARY KEY (`id_oferty`),
112 INDEX `miasta_idx` (`id_miasta` ASC),
113 CONSTRAINT `id_oferty_adres`
114 FOREIGN KEY (`id_oferty`)
115 REFERENCES `mydb`.`oferty` (`id_oferty`)
116 ON DELETE NO ACTION
117 ON UPDATE NO ACTION,
118 CONSTRAINT `id_miasta`
119 FOREIGN KEY (`id_miasta`)
120 REFERENCES `mydb`.`miasta` (`id_miasta`)
121 ON DELETE NO ACTION
122 ON UPDATE NO ACTION)
123ENGINE = InnoDB;
124
125
126-- -----------------------------------------------------
127-- Table `mydb`.`zdjecia`
128-- -----------------------------------------------------
129CREATE TABLE IF NOT EXISTS `mydb`.`zdjecia` (
130 `id_zdjecia` INT NOT NULL,
131 `nazwa_zdjecia` VARCHAR(45) NULL,
132 `id_oferty` INT NULL,
133 PRIMARY KEY (`id_zdjecia`),
134 INDEX `id_oferty_idx` (`id_oferty` ASC),
135 CONSTRAINT `id_oferty_zdjecia`
136 FOREIGN KEY (`id_oferty`)
137 REFERENCES `mydb`.`oferty` (`id_oferty`)
138 ON DELETE NO ACTION
139 ON UPDATE NO ACTION)
140ENGINE = InnoDB;
141
142
143-- -----------------------------------------------------
144-- Table `mydb`.`szczegoly`
145-- -----------------------------------------------------
146CREATE TABLE IF NOT EXISTS `mydb`.`szczegoly` (
147 `id_oferty` INT NOT NULL,
148 `telefon` TINYINT(1) NULL,
149 `internet` TINYINT(1) NULL,
150 `tv` TINYINT(1) NULL,
151 `domofon` TINYINT(1) NULL,
152 `tereny` TINYINT(1) NULL,
153 `plac_zabaw` TINYINT(1) NULL,
154 `sport` TINYINT(1) NULL,
155 `kino` TINYINT(1) NULL,
156 `basen` TINYINT(1) NULL,
157 `winda` TINYINT(1) NULL,
158 `garaz` TINYINT(1) NULL,
159 INDEX `id_oferty_idx` (`id_oferty` ASC),
160 CONSTRAINT `id_oferty_szczegoly`
161 FOREIGN KEY (`id_oferty`)
162 REFERENCES `mydb`.`oferty` (`id_oferty`)
163 ON DELETE NO ACTION
164 ON UPDATE NO ACTION)
165ENGINE = InnoDB;
166
167
168SET SQL_MODE=@OLD_SQL_MODE;
169SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
170SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;