ЛР6 - код создания таблиц

gistfile1.txt

-- MySQL Script generated by MySQL Workbench
-- Mon Apr 29 18:28:21 2024
-- Model: New Model    Version: 1.0
-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @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';

-- -----------------------------------------------------
-- Schema LR6
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Schema LR6
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `LR6` DEFAULT CHARACTER SET utf8 ;
USE `LR6` ;

-- -----------------------------------------------------
-- Table `LR6`.`Manufacturer`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `LR6`.`Manufacturer` (
  `name_manufacturer` VARCHAR(100) NOT NULL,
  `web-site` VARCHAR(100) NULL,
  PRIMARY KEY (`name_manufacturer`),
  UNIQUE INDEX `name_manufacturer_UNIQUE` (`name_manufacturer` ASC) VISIBLE,
  UNIQUE INDEX `web-site_UNIQUE` (`web-site` ASC) VISIBLE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `LR6`.`Model`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `LR6`.`Model` (
  `name_model` VARCHAR(45) NOT NULL,
  `name_manufacturer` VARCHAR(100) NOT NULL,
  `disk_capacity` INT UNSIGNED NOT NULL,
  `rotation_speed` FLOAT UNSIGNED NOT NULL,
  `interface_type` ENUM("SATA III", "SAS") NOT NULL,
  PRIMARY KEY (`name_model`, `name_manufacturer`),
  UNIQUE INDEX `name_model_UNIQUE` (`name_model` ASC) VISIBLE,
  UNIQUE INDEX `name_manufacturer_UNIQUE` (`name_manufacturer` ASC) VISIBLE,
  CONSTRAINT `manufacturer_key`
    FOREIGN KEY (`name_manufacturer`)
    REFERENCES `LR6`.`Manufacturer` (`name_manufacturer`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `LR6`.`hard_drive`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `LR6`.`hard_drive` (
  `serial_num` INT NOT NULL,
  `name_modul` VARCHAR(45) NOT NULL,
  `date_of_purchase` DATE NOT NULL,
  `date_of_failure` DATE NULL,
  `text_comment` MEDIUMTEXT NULL,
  PRIMARY KEY (`serial_num`, `name_modul`),
  UNIQUE INDEX `serial_num_UNIQUE` (`serial_num` ASC) VISIBLE,
  UNIQUE INDEX `name_modul_UNIQUE` (`name_modul` ASC) VISIBLE,
  CONSTRAINT `modul_key`
    FOREIGN KEY (`name_modul`)
    REFERENCES `LR6`.`Model` (`name_model`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;