Have transactionnal migrations again

[damien-carcel]

Following the migration to PHP 8 and the related dependencies update, we had to declare the migrations as non-transactional.

This should eventually be fixed in doctrine/dbal 3.1. However, this is also an opportunity to check for other databases than MySQL (MariaDB or PostgreSQL).