UaEqzY3x

1-- MySQL Script generated by MySQL Workbench
2-- 10/03/16 11:00:54
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 vozidla
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema vozidla
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `vozidla` DEFAULT CHARACTER SET cp1250 ;
18USE `vozidla` ;
19
20-- -----------------------------------------------------
21-- Table `vozidla`.`majitel`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `vozidla`.`majitel` (
24  `id_majitel` INT UNSIGNED NOT NULL AUTO_INCREMENT,
25  `meno` VARCHAR(20) NOT NULL,
26  `priezvisko` VARCHAR(20) NOT NULL,
27  `datum_narodenia` DATE NOT NULL,
28  `telefon` VARCHAR(20) NULL,
29  `email` VARCHAR(45) NULL,
30  PRIMARY KEY (`id_majitel`),
31  UNIQUE INDEX `id_majitel_UNIQUE` (`id_majitel` ASC))
32ENGINE = InnoDB
33DEFAULT CHARACTER SET = cp1250
34COLLATE = cp1250_czech_cs;
35
36
37-- -----------------------------------------------------
38-- Table `vozidla`.`znacka`
39-- -----------------------------------------------------
40CREATE TABLE IF NOT EXISTS `vozidla`.`znacka` (
41  `id_znacka` INT UNSIGNED NOT NULL AUTO_INCREMENT,
42  `vyrobca` VARCHAR(45) NOT NULL,
43  `typ` VARCHAR(45) NULL,
44  `pocet_dveri` INT NULL,
45  `vykon_motora` INT NULL,
46  PRIMARY KEY (`id_znacka`),
47  UNIQUE INDEX `id_znacka_UNIQUE` (`id_znacka` ASC))
48ENGINE = InnoDB
49DEFAULT CHARACTER SET = cp1250
50COLLATE = cp1250_czech_cs;
51
52
53-- -----------------------------------------------------
54-- Table `vozidla`.`vozidlo`
55-- -----------------------------------------------------
56CREATE TABLE IF NOT EXISTS `vozidla`.`vozidlo` (
57  `id_vozidlo` INT UNSIGNED NOT NULL AUTO_INCREMENT,
58  `ev_cislo` VARCHAR(10) NOT NULL,
59  `farba` VARCHAR(15) NOT NULL,
60  `rok_vyroby` YEAR NOT NULL,
61  `pocet_km` INT UNSIGNED NOT NULL,
62  `majitel_id_majitel` INT UNSIGNED NOT NULL,
63  `znacka_id_znacka` INT UNSIGNED NOT NULL,
64  PRIMARY KEY (`id_vozidlo`),
65  UNIQUE INDEX `id_vozidlo_UNIQUE` (`id_vozidlo` ASC),
66  INDEX `fk_vozidlo_majitel1_idx` (`majitel_id_majitel` ASC),
67  INDEX `fk_vozidlo_znacka1_idx` (`znacka_id_znacka` ASC),
68  CONSTRAINT `fk_vozidlo_majitel1`
69    FOREIGN KEY (`majitel_id_majitel`)
70    REFERENCES `vozidla`.`majitel` (`id_majitel`)
71    ON DELETE NO ACTION
72    ON UPDATE NO ACTION,
73  CONSTRAINT `fk_vozidlo_znacka1`
74    FOREIGN KEY (`znacka_id_znacka`)
75    REFERENCES `vozidla`.`znacka` (`id_znacka`)
76    ON DELETE NO ACTION
77    ON UPDATE NO ACTION)
78ENGINE = InnoDB
79DEFAULT CHARACTER SET = cp1250
80COLLATE = cp1250_czech_cs;
81
82
83-- -----------------------------------------------------
84-- Table `vozidla`.`ukon`
85-- -----------------------------------------------------
86CREATE TABLE IF NOT EXISTS `vozidla`.`ukon` (
87  `id_ukon` INT UNSIGNED NOT NULL AUTO_INCREMENT,
88  `nazov` VARCHAR(45) NOT NULL,
89  `popis` VARCHAR(200) NULL,
90  `cena` FLOAT UNSIGNED NULL,
91  PRIMARY KEY (`id_ukon`),
92  UNIQUE INDEX `id_ukon_UNIQUE` (`id_ukon` ASC))
93ENGINE = InnoDB
94DEFAULT CHARACTER SET = cp1250
95COLLATE = cp1250_czech_cs;
96
97
98-- -----------------------------------------------------
99-- Table `vozidla`.`vozidlo_has_ukon`
100-- -----------------------------------------------------
101CREATE TABLE IF NOT EXISTS `vozidla`.`vozidlo_has_ukon` (
102  `vozidlo_id_vozidlo` INT UNSIGNED NOT NULL,
103  `ukon_id_ukon` INT UNSIGNED NOT NULL,
104  PRIMARY KEY (`vozidlo_id_vozidlo`, `ukon_id_ukon`),
105  INDEX `fk_vozidlo_has_ukon_ukon1_idx` (`ukon_id_ukon` ASC),
106  INDEX `fk_vozidlo_has_ukon_vozidlo_idx` (`vozidlo_id_vozidlo` ASC),
107  CONSTRAINT `fk_vozidlo_has_ukon_vozidlo`
108    FOREIGN KEY (`vozidlo_id_vozidlo`)
109    REFERENCES `vozidla`.`vozidlo` (`id_vozidlo`)
110    ON DELETE NO ACTION
111    ON UPDATE NO ACTION,
112  CONSTRAINT `fk_vozidlo_has_ukon_ukon1`
113    FOREIGN KEY (`ukon_id_ukon`)
114    REFERENCES `vozidla`.`ukon` (`id_ukon`)
115    ON DELETE NO ACTION
116    ON UPDATE NO ACTION)
117ENGINE = InnoDB
118DEFAULT CHARACTER SET = cp1250
119COLLATE = cp1250_czech_cs;
120
121
122SET SQL_MODE=@OLD_SQL_MODE;
123SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
124SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;