Cannot use Audit add-on with MySQL 8.4+

[knstvk]

Environment

Jmix version: 2.7.1

Bug Description

In MySQL 8.4 MANUAL becomes a reserved word: https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-8-4.html#keywords-8-4-detailed-M

So when executing changelogs, we get the error:

SQL Error [1064] [42000]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MANUAL tinyint DEFAULT NULL, PRIMARY KEY (ID), UNIQUE KEY NAME (NAME) )' at line 7

Steps To Reproduce

Run MySQL 8.4:

docker run -d -p 3306:3306 --name mysql8 -e MYSQL_ROOT_PASSWORD=root mysql:8.4

Create database:

docker exec -it mysql8 mysql -u root -p

mysql> create database demo;

Create a Jmix project and change the database type to MySQL. Set database name to demo. Add allowPublicKeyRetrieval=true to connection parameters.

Try to update database.

[glebfox]

Studio support is needed