KmLh2Vpw

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 `eshop` DEFAULT CHARACTER SET cp1250 COLLATE cp1250_czech_cs ;
6USE `eshop` ;
7
8-- -----------------------------------------------------
9-- Table `eshop`.`zakaznik`
10-- -----------------------------------------------------
11CREATE  TABLE IF NOT EXISTS `eshop`.`zakaznik` (
12  `id_zakaznik` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
13  `meno` VARCHAR(30) NOT NULL ,
14  `priezvisko` VARCHAR(30) NOT NULL ,
15  `email` VARCHAR(30) NOT NULL ,
16  `vek` INT NULL ,
17  PRIMARY KEY (`id_zakaznik`) ,
18  UNIQUE INDEX `id_zakaznik_UNIQUE` (`id_zakaznik` ASC) )
19ENGINE = InnoDB
20DEFAULT CHARACTER SET = cp1250
21COLLATE = cp1250_czech_cs;
22
23
24-- -----------------------------------------------------
25-- Table `eshop`.`objednavka`
26-- -----------------------------------------------------
27CREATE  TABLE IF NOT EXISTS `eshop`.`objednavka` (
28  `id_objednavka` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
29  `datum` DATE NOT NULL ,
30  `platba` VARCHAR(15) NOT NULL ,
31  `dodavka` VARCHAR(15) NOT NULL ,
32  `zakaznik_id_zakaznik` INT UNSIGNED NOT NULL ,
33  PRIMARY KEY (`id_objednavka`) ,
34  UNIQUE INDEX `id_objednavka_UNIQUE` (`id_objednavka` ASC) ,
35  INDEX `fk_objednavka_zakaznik` (`zakaznik_id_zakaznik` ASC) ,
36  CONSTRAINT `fk_objednavka_zakaznik`
37    FOREIGN KEY (`zakaznik_id_zakaznik` )
38    REFERENCES `eshop`.`zakaznik` (`id_zakaznik` )
39    ON DELETE NO ACTION
40    ON UPDATE NO ACTION)
41ENGINE = InnoDB
42DEFAULT CHARACTER SET = cp1250
43COLLATE = cp1250_czech_cs;
44
45
46-- -----------------------------------------------------
47-- Table `eshop`.`vyrobca`
48-- -----------------------------------------------------
49CREATE  TABLE IF NOT EXISTS `eshop`.`vyrobca` (
50  `id_vyrobca` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
51  `nazov` VARCHAR(45) NOT NULL ,
52  `stat` VARCHAR(30) NOT NULL ,
53  `dodacia_lehota` INT NOT NULL ,
54  PRIMARY KEY (`id_vyrobca`) ,
55  UNIQUE INDEX `id_vyrobca_UNIQUE` (`id_vyrobca` ASC) )
56ENGINE = InnoDB
57DEFAULT CHARACTER SET = cp1250
58COLLATE = cp1250_czech_cs;
59
60
61-- -----------------------------------------------------
62-- Table `eshop`.`tovar`
63-- -----------------------------------------------------
64CREATE  TABLE IF NOT EXISTS `eshop`.`tovar` (
65  `id_tovar` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
66  `nazov` VARCHAR(45) NOT NULL ,
67  `cena` FLOAT NOT NULL ,
68  `zaruka` INT NOT NULL ,
69  `vyrobca_id_vyrobca` INT UNSIGNED NOT NULL ,
70  PRIMARY KEY (`id_tovar`) ,
71  UNIQUE INDEX `id_tovar_UNIQUE` (`id_tovar` ASC) ,
72  INDEX `fk_tovar_vyrobca1` (`vyrobca_id_vyrobca` ASC) ,
73  CONSTRAINT `fk_tovar_vyrobca1`
74    FOREIGN KEY (`vyrobca_id_vyrobca` )
75    REFERENCES `eshop`.`vyrobca` (`id_vyrobca` )
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 `eshop`.`objednavka_has_tovar`
85-- -----------------------------------------------------
86CREATE  TABLE IF NOT EXISTS `eshop`.`objednavka_has_tovar` (
87  `objednavka_id_objednavka` INT UNSIGNED NOT NULL ,
88  `tovar_id_tovar` INT UNSIGNED NOT NULL ,
89  PRIMARY KEY (`objednavka_id_objednavka`, `tovar_id_tovar`) ,
90  INDEX `fk_objednavka_has_tovar_tovar1` (`tovar_id_tovar` ASC) ,
91  CONSTRAINT `fk_objednavka_has_tovar_objednavka1`
92    FOREIGN KEY (`objednavka_id_objednavka` )
93    REFERENCES `eshop`.`objednavka` (`id_objednavka` )
94    ON DELETE NO ACTION
95    ON UPDATE NO ACTION,
96  CONSTRAINT `fk_objednavka_has_tovar_tovar1`
97    FOREIGN KEY (`tovar_id_tovar` )
98    REFERENCES `eshop`.`tovar` (`id_tovar` )
99    ON DELETE NO ACTION
100    ON UPDATE NO ACTION)
101ENGINE = InnoDB
102DEFAULT CHARACTER SET = cp1250
103COLLATE = cp1250_czech_cs;
104
105
106
107SET SQL_MODE=@OLD_SQL_MODE;
108SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
109SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;