DROP TABLE IF EXISTS `review`;
CREATE TABLE `review` (
                          `id` int NOT NULL,
                          `review` varchar(155) NOT NULL,
                          `score` int NOT NULL,
                          `status` tinyint(1) NOT NULL,
                          `presenter` varchar(50) NOT NULL,
                          `url` varchar(250) NOT NULL,
                          `presenter_id` int NOT NULL,
                          `readed` tinyint(1) NOT NULL DEFAULT '0',
                          `type` varchar(10) NOT NULL,
                          `user_id` int NOT NULL,
                          `shop_id` int NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;