Skip to content

Instantly share code, notes, and snippets.

View nasirdn's full-sized avatar

nasirdn

View GitHub Profile
@nasirdn
nasirdn / gist:942223527a4c13b025ddaf3bf95f2439
Created May 12, 2024 12:51
СР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';
-- -----------------------------------------------------
@nasirdn
nasirdn / gist:899309de0f38cce914281d8abfa502b4
Created May 10, 2024 20:07
Ср3-код с добавление данных
-- -----------------------------------------------------
-- Data for table `sr3_3.1`.`game`
-- -----------------------------------------------------
START TRANSACTION;
USE `sr3_3.1`;
INSERT INTO `sr3_3.1`.`game` (`id_game`, `name_game`, `manufacturer`, `min_players`, `max_players`, `min_year`) VALUES (1, 'Интуиция', 'Dream Makers', 4, 8, 12);
INSERT INTO `sr3_3.1`.`game` (`id_game`, `name_game`, `manufacturer`, `min_players`, `max_players`, `min_year`) VALUES (2, 'Манчкин', 'Hobby Word', 3, 6, 12);
INSERT INTO `sr3_3.1`.`game` (`id_game`, `name_game`, `manufacturer`, `min_players`, `max_players`, `min_year`) VALUES (3, 'Бэнг!', 'Hobby Word', 4, 7, 8);
INSERT INTO `sr3_3.1`.`game` (`id_game`, `name_game`, `manufacturer`, `min_players`, `max_players`, `min_year`) VALUES (4, 'Интуиция', 'Origami', 3, 6, 18);
@nasirdn
nasirdn / gist:4493210ca7ba2dcb7fa8969af520140b
Created May 10, 2024 19:51
СР3 - код создания таблиц
-- MySQL Script generated by MySQL Workbench
-- Fri May 10 22:51:19 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';
-- -----------------------------------------------------
@nasirdn
nasirdn / gist:7485ead31dd60d2fb981015175f5ba9e
Last active April 29, 2024 16:14
ЛР6-код добавления данных
-- -----------------------------------------------------
-- Data for table `ЛР6`.`manufacturer`
-- -----------------------------------------------------
START TRANSACTION;
USE `ЛР6`;
INSERT INTO `ЛР6`.`manufacturer` (`name_manufacturer`, `web-site`) VALUES ('Seagate', 'https://www.seagategov.com');
INSERT INTO `ЛР6`.`manufacturer` (`name_manufacturer`, `web-site`) VALUES ('Lenovo', 'https://www.lenovo.com');
COMMIT;
@nasirdn
nasirdn / gist:52fbc9440f1bbb506761774f8240d944
Last active April 29, 2024 16:15
ЛР6 - код создания таблиц
-- 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';
-- -----------------------------------------------------
@nasirdn
nasirdn / gist:fbe0564df3711c2fffd347bd2f1745c3
Created February 28, 2024 10:45
-- 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 ex2
-- -----------------------------------------------------
@nasirdn
nasirdn / gist:37a077c7eb121ed6e9d8aea098ab7b5b
Last active February 28, 2024 10:46
-- -----------------------------------------------------
-- Table `ex2`.`orders`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ex2`.`orders` (
`id` INT NOT NULL AUTO_INCREMENT,
`shop_id` INT NOT NULL,
`product_id` INT NOT NULL,
`fio` INT NOT NULL,
`date` DATE NULL,
`quantity` TINYINT NULL,
@nasirdn
nasirdn / gist:7050e3e6b8d06a5da27a00d279ae32cf
Created February 28, 2024 10:36
Скопированный запрос, соответствующий созданию этой базы данных.
-- MySQL Script generated by MySQL Workbench
-- Wed Feb 28 13:36:17 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';
-- -----------------------------------------------------
@nasirdn
nasirdn / gist:c611062f97837c830a827d91c3f202ef
Created February 26, 2024 17:28
Фрагмент запроса, касающийся создания и настройки таблицы invoice.
-- -----------------------------------------------------
-- Table `firstModel`.`invoice`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `firstModel`.`invoice` (
`idinvoice` INT NOT NULL AUTO_INCREMENT,
`userid` INT NOT NULL,
`productid` INT NOT NULL,
`cost` DECIMAL(10,2) NOT NULL,
PRIMARY KEY (`idinvoice`),
INDEX `user_idx` (`userid` ASC) VISIBLE,
@nasirdn
nasirdn / gist:97f3b98f0ccc2de66ca486ff7813d809
Created February 26, 2024 17:19
Скопированный запрос, соответствующий созданию этой базы данных.
-- MySQL Script generated by MySQL Workbench
-- Mon Feb 26 20:11:43 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';
-- -----------------------------------------------------