[Image] MySQL 8.4 restrict_fk_on_non_standard_key

[sprankhub]

Version of Warden

0.15.0

Operating System and Installation Method

Ubuntu 24.04 via Brew

Image

docker.io/wardenenv/mysql:8.4

Describe the Bug

Importing a database might lead to this error:

ERROR 6125 (HY000) at line XXX: Failed to add the foreign key constraint. Missing unique key for constraint 'CAT_PRD_FRONTEND_ACTION_PRD_ID_CAT_PRD_ENTT_ENTT_ID' in the referenced table 'catalog_product_entity'

To Reproduce

Import a database.

Expected Behavior

No response

Additional context

For MySQL 8.4, we should probably set restrict_fk_on_non_standard_key to Off by default, see https://experienceleague.adobe.com/en/docs/commerce-operations/upgrade-guide/prepare/prerequisites#mysql-84-changes.