QUERY:

CREATE TABLE `media_gallery_music` (
        `gallery_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
        `value_id` INT(11) UNSIGNED NOT NULL,
        `artwork_url` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
        `name` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
        `position` INT(11) NOT NULL,
        PRIMARY KEY (`gallery_id`)
    ) ENGINE=INNODB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE `media_gallery_music_album` (
        `album_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
        `gallery_id` INT(11) UNSIGNED NOT NULL,
        `name` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
        `artwork_url` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL,
        `podcast_url` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL,
        `artist_name` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL,
        `type` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL,
        PRIMARY KEY (`album_id`),
        KEY `KEY_GALLERY_ID` (`gallery_id`)
    ) ENGINE=INNODB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE `media_gallery_music_elements` (
        `position_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
        `gallery_id` INT(11) UNSIGNED DEFAULT NULL,
        `album_id` INT(11) UNSIGNED DEFAULT NULL,
        `track_id` INT(11) UNSIGNED DEFAULT NULL,
        `position` INT(11) NOT NULL,
        PRIMARY KEY (`position_id`),
        KEY `KEY_GALLERY_ID` (`gallery_id`),
        KEY `KEY_ALBUM_ID` (`album_id`),
        KEY `KEY_TRACK_ID` (`track_id`)
    ) ENGINE=INNODB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 CREATE TABLE `media_gallery_music_track` (
        `track_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
        `album_id` INT(11) UNSIGNED DEFAULT NULL,
        `gallery_id` INT(11) UNSIGNED DEFAULT NULL,
        `name` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
        `duration` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL,
        `artwork_url` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL,
        `artist_name` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL,
        `album_name` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL,
        `price` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL,
        `currency` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL,
        `purchase_url` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL,
        `stream_url` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
        `type` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL,
        `position` INT(11) NOT NULL,
        PRIMARY KEY (`track_id`),
        KEY `KEY_ALBUM_ID` (`album_id`),
        KEY `KEY_GALLERY_ID` (`gallery_id`)
    ) ENGINE=INNODB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
ALTER TABLE `media_gallery_music_album`
        ADD FOREIGN KEY `FK_GALLERY_ID`(`gallery_id`) REFERENCES `media_gallery_music` (`gallery_id`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `media_gallery_music_elements`
        ADD FOREIGN KEY `FK_GALLERY_ID` (`gallery_id`) REFERENCES `media_gallery_music` (`gallery_id`) ON DELETE CASCADE ON UPDATE CASCADE,
        ADD FOREIGN KEY `FK_ALBUM_ID` (`album_id`) REFERENCES `media_gallery_music_album` (`album_id`) ON DELETE CASCADE ON UPDATE CASCADE,
        ADD FOREIGN KEY `FK_TRACK_ID` (`track_id`) REFERENCES `media_gallery_music_track` (`track_id`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `media_gallery_music_track`
        ADD FOREIGN KEY `FK_ALBUM_ID` (`album_id`) REFERENCES `media_gallery_music_album` (`album_id`) ON DELETE CASCADE ON UPDATE CASCADE,
        ADD FOREIGN KEY `FK_GALLERY_ID` (`gallery_id`) REFERENCES `media_gallery_music` (`gallery_id`) ON DELETE CASCADE ON UPDATE CASCADE;

Work perfect MariaDb 5.5.52.

Error MariaDb 10.1.22:

Query : ALTER TABLE `media_gallery_music_elements`         ADD FOREIGN KEY `FK_GALLERY_ID` (`gallery_id`) REFERENCES `media_gallery_musi...

Error Code : 1005
Can't create table `test`.`#sql-c82_1086` (errno: 121 "Duplicate key on write or update")

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

I can manually modify and fix the error, but it is a system with many scripts and updates, is there any way to omit this error in Mariadb 10.1.22.

--