ЛР6-код добавления данных

gistfile1.txt

-- -----------------------------------------------------
-- 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;


-- -----------------------------------------------------
-- Data for table `ЛР6`.`model`
-- -----------------------------------------------------
START TRANSACTION;
USE `ЛР6`;
INSERT INTO `ЛР6`.`model` (`name_model`, `name_manufacturer`, `disk_capacity (Gb)`, `rotation_speed`, `interface_type`) VALUES ('ST1000VX013', 'Seagate', 1024, 5400, 'SATA III');
INSERT INTO `ЛР6`.`model` (`name_model`, `name_manufacturer`, `disk_capacity (Gb)`, `rotation_speed`, `interface_type`) VALUES ('7xb7a00028', 'Lenovo', 1800, 10000, 'SAS');

COMMIT;


-- -----------------------------------------------------
-- Data for table `ЛР6`.`hard_drive`
-- -----------------------------------------------------
START TRANSACTION;
USE `ЛР6`;
INSERT INTO `ЛР6`.`hard_drive` (`serial_num`, `name_model`, `date_of_purchase`, `date_of_failure`, `text_comment`) VALUES (2012560, 'ST1000VX013', '24.04.2023', NULL, 'Не проработал и двух лет. Разочарован.');
INSERT INTO `ЛР6`.`hard_drive` (`serial_num`, `name_model`, `date_of_purchase`, `date_of_failure`, `text_comment`) VALUES (1050955, '7xb7a00028', '16.09.2022', '04.01.2024', 'Покупал давно, работал тихо, только грелся.');

COMMIT;