x61EcbcD

1-- MySQL Script generated by MySQL Workbench
2-- Sat Dec 22 22:40:52 2018
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 mydb
12-- -----------------------------------------------------
13DROP SCHEMA IF EXISTS `mydb` ;
14
15-- -----------------------------------------------------
16-- Schema mydb
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
19USE `mydb` ;
20
21-- -----------------------------------------------------
22-- Table `mydb`.`produkt`
23-- -----------------------------------------------------
24DROP TABLE IF EXISTS `mydb`.`produkt` ;
25
26CREATE TABLE IF NOT EXISTS `mydb`.`produkt` (
27  `id` INT NOT NULL AUTO_INCREMENT,
28  `produktcol` VARCHAR(45) NULL,
29  PRIMARY KEY (`id`),
30  UNIQUE INDEX `id_UNIQUE` (`id` ASC))
31ENGINE = InnoDB;
32
33
34-- -----------------------------------------------------
35-- Table `mydb`.`klient`
36-- -----------------------------------------------------
37DROP TABLE IF EXISTS `mydb`.`klient` ;
38
39CREATE TABLE IF NOT EXISTS `mydb`.`klient` (
40  `id` INT NOT NULL,
41  `imie` VARCHAR(45) NULL,
42  `nazwisko` VARCHAR(45) NULL,
43  `email` VARCHAR(45) NULL,
44  `produkt_id` INT NOT NULL,
45  PRIMARY KEY (`id`),
46  UNIQUE INDEX `id_UNIQUE` (`id` ASC),
47  INDEX `fk_klient_produkt_idx` (`produkt_id` ASC),
48  CONSTRAINT `fk_klient_produkt`
49    FOREIGN KEY (`produkt_id`)
50    REFERENCES `mydb`.`produkt` (`id`)
51    ON DELETE NO ACTION
52    ON UPDATE NO ACTION)
53ENGINE = InnoDB;
54
55
56SET SQL_MODE=@OLD_SQL_MODE;
57SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
58SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;