7ikGqfj2

1-- MySQL Script generated by MySQL Workbench
2-- Tue Jun 29 19:40:58 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  `quanity` TINYINT NOT NULL,
32  PRIMARY KEY (`id`),
33  UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
34  UNIQUE INDEX `customer_id_UNIQUE` (`customer_id` ASC) VISIBLE,
35  UNIQUE INDEX `goods_id_UNIQUE` (`goods_id` ASC) VISIBLE,
36  CONSTRAINT `customer`
37    FOREIGN KEY (`customer_id`)
38    REFERENCES `dop_zadanie`.`customer` (`id`)
39    ON DELETE CASCADE
40    ON UPDATE CASCADE,
41  CONSTRAINT `goods`
42    FOREIGN KEY (`goods_id`)
43    REFERENCES `dop_zadanie`.`goods` (`id`)
44    ON DELETE CASCADE
45    ON UPDATE CASCADE)
46ENGINE = InnoDB
47AUTO_INCREMENT = 4
48DEFAULT CHARACTER SET = utf8mb3;
49
50
51-- -----------------------------------------------------
52-- Table `dop_zadanie`.`customer`
53-- -----------------------------------------------------
54DROP TABLE IF EXISTS `dop_zadanie`.`customer` ;
55
56CREATE TABLE IF NOT EXISTS `dop_zadanie`.`customer` (
57  `id` INT NOT NULL AUTO_INCREMENT,
58  `fio` VARCHAR(255) NOT NULL,
59  `address` VARCHAR(400) NOT NULL,
60  `phone` VARCHAR(45) NOT NULL,
61  PRIMARY KEY (`id`),
62  UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE)
63ENGINE = InnoDB
64AUTO_INCREMENT = 4
65DEFAULT CHARACTER SET = utf8mb3;
66
67
68-- -----------------------------------------------------
69-- Table `dop_zadanie`.`goods`
70-- -----------------------------------------------------
71DROP TABLE IF EXISTS `dop_zadanie`.`goods` ;
72
73CREATE TABLE IF NOT EXISTS `dop_zadanie`.`goods` (
74  `id` INT NOT NULL,
75  `naming` VARCHAR(45) NOT NULL,
76  `cost` DECIMAL(10,0) NOT NULL,
77  PRIMARY KEY (`id`),
78  UNIQUE INDEX `naming_UNIQUE` (`naming` ASC) VISIBLE)
79ENGINE = InnoDB
80DEFAULT CHARACTER SET = utf8mb3;
81
82
83SET SQL_MODE=@OLD_SQL_MODE;
84SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
85SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
86