Ср3-код с добавление данных

gistfile1.txt

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

COMMIT;


-- -----------------------------------------------------
-- Data for table `sr3_3.1`.`woker`
-- -----------------------------------------------------
START TRANSACTION;
USE `sr3_3.1`;
INSERT INTO `sr3_3.1`.`woker` (`tab_num`, `lastname_work`, `name_work`, `patron_work`) VALUES ('С01', 'Васильев', 'Артем', 'Алексеевич');
INSERT INTO `sr3_3.1`.`woker` (`tab_num`, `lastname_work`, `name_work`, `patron_work`) VALUES ('С02', 'Позднякова', 'Афродита', 'Михайловна');

COMMIT;


-- -----------------------------------------------------
-- Data for table `sr3_3.1`.`order`
-- -----------------------------------------------------
START TRANSACTION;
USE `sr3_3.1`;
INSERT INTO `sr3_3.1`.`order` (`num_order`, `receipt`, `created`, `tab_num`, `id_client`) VALUES (1, 'Самовывоз', '2023.05.16 15:49:32', 'С01', 'К1');
INSERT INTO `sr3_3.1`.`order` (`num_order`, `receipt`, `created`, `tab_num`, `id_client`) VALUES (2, 'Доставка', '2023.05.16 19:01:01', 'С01', 'К2');
INSERT INTO `sr3_3.1`.`order` (`num_order`, `receipt`, `created`, `tab_num`, `id_client`) VALUES (3, 'Самовывоз', '2023.05.17 10:59:18', 'С02', 'К1');

COMMIT;


-- -----------------------------------------------------
-- Data for table `sr3_3.1`.`order_position`
-- -----------------------------------------------------
START TRANSACTION;
USE `sr3_3.1`;
INSERT INTO `sr3_3.1`.`order_position` (`num_order`, `id_game`, `num_position`) VALUES (1, 1, 1);
INSERT INTO `sr3_3.1`.`order_position` (`num_order`, `id_game`, `num_position`) VALUES (1, 2, 2);
INSERT INTO `sr3_3.1`.`order_position` (`num_order`, `id_game`, `num_position`) VALUES (2, 4, 1);
INSERT INTO `sr3_3.1`.`order_position` (`num_order`, `id_game`, `num_position`) VALUES (3, 2, 3);
INSERT INTO `sr3_3.1`.`order_position` (`num_order`, `id_game`, `num_position`) VALUES (3, 3, 1);
INSERT INTO `sr3_3.1`.`order_position` (`num_order`, `id_game`, `num_position`) VALUES (3, 4, 1);

COMMIT;