Foreign Key Constraints ✨ #5615
Merged
Conversation
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This was referenced May 22, 2021
Oreilles
added a commit
to Oreilles/directus
that referenced
this pull request
May 27, 2021
This reverts commit 9335372.
AustinPhillipTaylor
pushed a commit
to AustinPhillipTaylor/directus
that referenced
this pull request
May 11, 2022
* Bump knex-schema-inspector * Fix cli role name attr * Update relation type * Restructure relations * Restructure relations table * Update api type for relation record * Fetch relations in new structure * Update schema-inspector * Use new relations schema structure in api * Update relations GETters * Add default value to one deselect * Add create relationship on existing field * Add updating existing relationship * Add delete relations * Add relations query resolver * Add graphql mutations for relations * Fix reading from wrong name * Fix wrong method name * No idea why this flip flops every install * Update relation type * Accept null in use-collection composable * Use new relations structure in translations * Use new relations structure in new-collection * Start updating field detail store * Renames for new relations structure * Silently ignore passed collection/field in relation update * Fix setting pk field in m2o relational setup * Small tweaks in o2m setup * Fix m2m setup * Tweak m2o setup * Fix m2a setup * Allow null for related collection (m2a) * Fix languages code name * Fix migration default value * Fix relational cleanup in collections/fields * Fix transaction problem in field delete * Fix inserting relational o2m items * Don't execute updateByQuery on empty item set Fixes directus#5710, fixes directus#5070 * Show referential action input on m2o * Finish language for m2o * Show triggers config on o2m * Delete items on one_deselect_item delete * Fix naming, show relational trigger config on m2m * Tweak language, add setup to m2a * Fix linter warnings * Add trigger setup for translations * fix Edit non-schema relationship issue * Sync existing on_delete triggers in o2m setup * Add migration to setup foreign key constraints * Update illegal FK values before setting constraint * Fix MySQL unsigned vs not-unsigned in FK creation * Use pretty names for labels in relational triggers * Prefix auto-junction when system table Fixes directus#5493 * Add system foreign key triggers Fixes directus#5749 * Update docs
Sign up for free
to subscribe to this conversation on GitHub.
Already have an account?
Sign in.
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
closes #2942
closes #3311
closes #3361
closes #3664
closes #4245
fixes #5493
fixes #5528
fixes #5650
fixes #5749
ref #5070