Describe the Bug

The schema snapshot is not aligned with the MYSQL database snapshot.

Using mysql and the following schema file (rename to .yaml) we are unable to apply the snapshot again and again.

schemap.txt

To Reproduce

Download and rename the snapshot to schema.yaml

On a fresh database after running npx directus bootstrap

Run directus schema apply ./schema.yaml --yes // should work

Then try once again directus schema apply ./schema.yaml // Notice that it wants to make a lot of updates even though you just applied it.

Saying yes, would attempt to update the db, but will fail due to foreign key constraints.

Directus Version

10.6-10.7

Hosting Strategy

Self-Hosted (Docker Image)