Skip to content

Instantly share code, notes, and snippets.

@nasirdn
Created May 12, 2024 12:51
Show Gist options
  • Save nasirdn/942223527a4c13b025ddaf3bf95f2439 to your computer and use it in GitHub Desktop.
Save nasirdn/942223527a4c13b025ddaf3bf95f2439 to your computer and use it in GitHub Desktop.
СР4-4.2-повтор таблиц
-- MySQL Script generated by MySQL Workbench
-- Sun May 12 15:50:49 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 sr4_42
-- -----------------------------------------------------
-- -----------------------------------------------------
-- Schema sr4_42
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `sr4_42` DEFAULT CHARACTER SET utf8 ;
USE `sr4_42` ;
-- -----------------------------------------------------
-- Table `sr4_42`.`book`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sr4_42`.`book` (
`BookID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`Author` VARCHAR(100) NULL DEFAULT NULL,
`Title` VARCHAR(100) NULL DEFAULT NULL,
`Publisher` VARCHAR(45) NULL DEFAULT NULL,
`BookYear` INT UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`BookID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `sr4_42`.`bookinlib`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sr4_42`.`bookinlib` (
`LibID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`BookID` INT NULL DEFAULT NULL,
`StatusID` INT NULL DEFAULT NULL,
PRIMARY KEY (`LibID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `sr4_42`.`bookstatus`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sr4_42`.`bookstatus` (
`StatusID` INT NOT NULL,
`StatusName` VARCHAR(45) NULL DEFAULT NULL,
PRIMARY KEY (`StatusID`))
ENGINE = InnoDB;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
-- -----------------------------------------------------
-- Data for table `sr4_42`.`book`
-- -----------------------------------------------------
START TRANSACTION;
USE `sr4_42`;
INSERT INTO `sr4_42`.`book` (`BookID`, `Author`, `Title`, `Publisher`, `BookYear`) VALUES (1, 'Зеленин В.М.', 'Экспертные системы', 'Политехника', 1996);
INSERT INTO `sr4_42`.`book` (`BookID`, `Author`, `Title`, `Publisher`, `BookYear`) VALUES (2, 'Дейт К.', 'Введение в системы баз данных', 'Издательский дом \\\"\\\"Вильямс\\\"\\\"', 1999);
INSERT INTO `sr4_42`.`book` (`BookID`, `Author`, `Title`, `Publisher`, `BookYear`) VALUES (3, 'Кириллов В.В., Громов Г.Ю.', 'Введение в реляционные базы данных', 'БХВ-Петербург', 2009);
INSERT INTO `sr4_42`.`book` (`BookID`, `Author`, `Title`, `Publisher`, `BookYear`) VALUES (4, 'Кастанеда К.', 'Особая реальность: Новые беседы с доном Хуаном.', 'Азбука', 2001);
INSERT INTO `sr4_42`.`book` (`BookID`, `Author`, `Title`, `Publisher`, `BookYear`) VALUES (5, 'Пелевин В.', 'Омон Ра', 'ФТМ', 1998);
INSERT INTO `sr4_42`.`book` (`BookID`, `Author`, `Title`, `Publisher`, `BookYear`) VALUES (6, 'К. Маккарти\'', 'Дорога', 'Азбука', 2018);
COMMIT;
-- -----------------------------------------------------
-- Data for table `sr4_42`.`bookinlib`
-- -----------------------------------------------------
START TRANSACTION;
USE `sr4_42`;
INSERT INTO `sr4_42`.`bookinlib` (`LibID`, `BookID`, `StatusID`) VALUES (1, 1, 1);
INSERT INTO `sr4_42`.`bookinlib` (`LibID`, `BookID`, `StatusID`) VALUES (2, 1, 2);
INSERT INTO `sr4_42`.`bookinlib` (`LibID`, `BookID`, `StatusID`) VALUES (3, 5, 3);
INSERT INTO `sr4_42`.`bookinlib` (`LibID`, `BookID`, `StatusID`) VALUES (4, 6, 1);
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment