WgbLi5Q6

1-- MySQL Script generated by MySQL Workbench
2-- Sun Jun 27 15:39:52 2021
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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
9
10-- -----------------------------------------------------
11-- Schema dop_zadanie
12-- -----------------------------------------------------
13DROP SCHEMA IF EXISTS `dop_zadanie` ;
14
15-- -----------------------------------------------------
16-- Schema dop_zadanie
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS `dop_zadanie` DEFAULT CHARACTER SET utf8 ;
19USE `dop_zadanie` ;
20
21-- -----------------------------------------------------
22-- Table `dop_zadanie`.`catalog`
23-- -----------------------------------------------------
24DROP TABLE IF EXISTS `dop_zadanie`.`catalog` ;
25
26CREATE TABLE IF NOT EXISTS `dop_zadanie`.`catalog` (
27  `id` INT NOT NULL AUTO_INCREMENT,
28  `customer_id` INT NOT NULL,
29  `goods_id` INT NOT NULL,
30  `time_of_buying` TIMESTAMP NOT NULL,
31  PRIMARY KEY (`id`),
32  UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
33  UNIQUE INDEX `customer_id_UNIQUE` (`customer_id` ASC) VISIBLE,
34  UNIQUE INDEX `goods_id_UNIQUE` (`goods_id` ASC) VISIBLE,
35  CONSTRAINT `customer`
36    FOREIGN KEY (`customer_id`)
37    REFERENCES `dop_zadanie`.`customer` (`id`)
38    ON DELETE CASCADE
39    ON UPDATE CASCADE,
40  CONSTRAINT `goods`
41    FOREIGN KEY (`goods_id`)
42    REFERENCES `dop_zadanie`.`goods` (`id`)
43    ON DELETE CASCADE
44    ON UPDATE CASCADE)
45ENGINE = InnoDB;
46
47
48-- -----------------------------------------------------
49-- Table `dop_zadanie`.`customer`
50-- -----------------------------------------------------
51DROP TABLE IF EXISTS `dop_zadanie`.`customer` ;
52
53CREATE TABLE IF NOT EXISTS `dop_zadanie`.`customer` (
54  `id` INT NOT NULL AUTO_INCREMENT,
55  `fio` VARCHAR(255) NOT NULL,
56  `address` VARCHAR(400) NOT NULL,
57  `phone` VARCHAR(45) NOT NULL,
58  UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
59  PRIMARY KEY (`id`))
60ENGINE = InnoDB;
61
62
63-- -----------------------------------------------------
64-- Table `dop_zadanie`.`goods`
65-- -----------------------------------------------------
66DROP TABLE IF EXISTS `dop_zadanie`.`goods` ;
67
68CREATE TABLE IF NOT EXISTS `dop_zadanie`.`goods` (
69  `id` INT NOT NULL,
70  `naming` VARCHAR(45) NOT NULL,
71  `quanity` TINYINT NOT NULL DEFAULT 0,
72  `cost` DECIMAL NOT NULL,
73  PRIMARY KEY (`id`),
74  UNIQUE INDEX `naming_UNIQUE` (`naming` ASC) VISIBLE)
75ENGINE = InnoDB;
76
77
78SET SQL_MODE=@OLD_SQL_MODE;
79SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
80SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
81