Add RenameIndex support for MariaDB versions >= 10.5.2

[JustusGreiberORGADATA]

Rename index support was added by the following MariaDB issue: https://jira.mariadb.org/browse/MDEV-7318

As far as I can see it is the exact same syntax, that MySQL supports. This syntax is already supported by this library and tests exist as well.

Changing this makes migrations for MariaDB easier, because you can't run into the "Cannot drop index needed in a foreign key constraint" problem.

Fixes: #1793