DROP TABLE IF EXISTS `searches`;
CREATE TABLE `searches` (
                            `id` int NOT NULL AUTO_INCREMENT,
                            `shop_id` int NOT NULL,
                            `language_id` int NOT NULL,
                            `search` varchar(155) NOT NULL,
                            `location` varchar(50) NOT NULL,
                            `viewed` int NOT NULL,
                            PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;