DROP TABLE IF EXISTS `user_shops`;
CREATE TABLE `user_shops` (
                              `user_id` int NOT NULL,
                              `shop_id` int NOT NULL,
                              KEY `user_id` (`user_id`) USING BTREE,
                              KEY `shop_id` (`shop_id`),
                              CONSTRAINT `user_shop_id` FOREIGN KEY (`shop_id`) REFERENCES `shops` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
                              CONSTRAINT `user_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;