DROP TABLE IF EXISTS `product_search`;
CREATE TABLE `product_search` (
                                  `id` int NOT NULL AUTO_INCREMENT,
                                  `name` varchar(50) NOT NULL,
                                  `search_filter_name` varchar(50) NOT NULL,
                                  `price_start` decimal(10,0) NOT NULL,
                                  `price_end` decimal(10,0) NOT NULL,
                                  `count` int NOT NULL,
                                  `status` tinyint(1) NOT NULL,
                                  `brand_id` int NOT NULL,
                                  `category_id` int NOT NULL,
                                  `code` varchar(30) NOT NULL,
                                  `shop_id` int NOT NULL,
                                  PRIMARY KEY (`id`),
                                  KEY `shop` (`shop_id`),
                                  CONSTRAINT `shop` FOREIGN KEY (`shop_id`) REFERENCES `shops` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;