LR6-Inserts

-- Data for table `hard_drive_db`.`serial_numbers`
-- -----------------------------------------------------
START TRANSACTION;
USE `hard_drive_db`;
INSERT INTO `hard_drive_db`.`serial_numbers` (`serial_number`, `model`) VALUES ('1010101', 'SHIRAKAVA');
INSERT INTO `hard_drive_db`.`serial_numbers` (`serial_number`, `model`) VALUES ('202020202', 'KAGEYAMA');

COMMIT;


-- -----------------------------------------------------
-- Data for table `hard_drive_db`.`producer`
-- -----------------------------------------------------
START TRANSACTION;
USE `hard_drive_db`;
INSERT INTO `hard_drive_db`.`producer` (`name_producer`, `web-site`) VALUES ('TOSHIBA', 'TOSHIBA.com');
INSERT INTO `hard_drive_db`.`producer` (`name_producer`, `web-site`) VALUES ('WD Purple', 'Purple.com');

COMMIT;


-- -----------------------------------------------------
-- Data for table `hard_drive_db`.`characteristics`
-- -----------------------------------------------------
START TRANSACTION;
USE `hard_drive_db`;
INSERT INTO `hard_drive_db`.`characteristics` (`model`, `name_producer`, `volume`, `rotation_speed`, `interface`) VALUES ('KAGEYAMA', 'TOSHIBA', '100', '2000', 'TCP');
INSERT INTO `hard_drive_db`.`characteristics` (`model`, `name_producer`, `volume`, `rotation_speed`, `interface`) VALUES ('SHIRAKAVA', 'WD Purple', '200', '2000', 'TCP');

COMMIT;