DROP TABLE IF EXISTS `media_data_desc`;
CREATE TABLE `media_data_desc` (
                                   `id` int NOT NULL AUTO_INCREMENT,
                                   `media_id` int NOT NULL,
                                   `media_data_id` int NOT NULL,
                                   `title` varchar(200) NOT NULL,
                                   `sub_title` varchar(200) NOT NULL,
                                   `language_id` int NOT NULL,
                                   UNIQUE KEY `id` (`id`),
                                   KEY `fk_media_data_desc_id` (`media_id`),
                                   KEY `fk_media_data_desc_id_id` (`media_data_id`),
                                   CONSTRAINT `fk_media_data_desc_id` FOREIGN KEY (`media_id`) REFERENCES `media` (`id`) ON DELETE CASCADE,
                                   CONSTRAINT `fk_media_data_desc_id_id` FOREIGN KEY (`media_data_id`) REFERENCES `media_data` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;