Can't delete items with translations

[lluishi93]

Describe the Bug

A FK constraint is preventing the items to be deleted.

Potentially related to #12478

To Reproduce

1. Create collection A
2. Add translations field to collection A
3. Create some items for collection A with its translations
4. Try to delete the item

Errors Shown

{
  "errors": [
    {
      "message": "delete from `c_cta` where `id` in ('2149') - ER_ROW_IS_REFERENCED_2: Cannot delete or update a parent row: a foreign key constraint fails (`emma_pre_directus9`.`c_cta_translations`, CONSTRAINT `c_cta_translations_entity_foreign` FOREIGN KEY (`entity`) REFERENCES `c_cta` (`id`))",
      "extensions": {
        "code": "INTERNAL_SERVER_ERROR"
      }
    }
  ]
}

What version of Directus are you using?

9.9.1

What version of Node.js are you using?

16.14.0

What database are you using?

MySQL 5.7

What browser are you using?

Chrome

How are you deploying Directus?

Docker

[rijkvanzanten]

You can configure the relational constraints from the relationship configuration tab of the field:

In your use case, you might want to set the second one to: