#105456Auto-generate foreign keys on pure SQL relation fields when doing TCA auto-generation
Description
It would be nice if the core would auto-create foreign keys when generating single-table MM tables or single-table inline relations. Probably optionally/configurable, with ‘dbCreateForeignKey’, ‘dbOnDeleteCascade’, and so on in TCA MM config.
CREATE TABLE tx_package_lcoal_foreign_mm
(
FOREIGN KEY fk_local (uid_local) REFERENCES local_table (uid) ON DELETE CASCADE,
FOREIGN KEY fk_foreign (uid_foreign) REFERENCES foreign_table (uid) ON DELETE CASCADE
);Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.
Fix this issue
Start the commit message of your patch with this. Add what the patch does, and the versions it goes to in "Releases:". How to create a patch
- Commit message
-
[FEATURE] Auto-generate foreign keys on pure SQL relation fields when doing TCA auto-generation Resolves: #105456 Releases: main