DROP TABLE IF EXISTS `product_category_desc`;
CREATE TABLE `product_category_desc` (
                                         `id` int NOT NULL AUTO_INCREMENT,
                                         `category_id` int NOT NULL,
                                         `name` varchar(155) NOT NULL,
                                         `language_id` int NOT NULL,
                                         `meta_title` varchar(155) DEFAULT NULL,
                                         `meta_desc` varchar(155) DEFAULT NULL,
                                         `meta_keyword` varchar(155) DEFAULT NULL,
                                         `description` text,
                                         `url` varchar(100) NOT NULL,
                                         PRIMARY KEY (`id`),
                                         KEY `fk_product_category_desc_id` (`category_id`),
                                         CONSTRAINT `fk_product_category_desc_id` FOREIGN KEY (`category_id`) REFERENCES `product_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;