vwBZQ34c

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