DROP TABLE IF EXISTS `blog_category_desc`;
CREATE TABLE `blog_category_desc` (
                                      `id` int NOT NULL AUTO_INCREMENT,
                                      `blog_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_blog_category_id` (`blog_category_id`),
                                      CONSTRAINT `fk_blog_category_desc_id` FOREIGN KEY (`blog_category_id`) REFERENCES `blog_category` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;