Actions
Feature #105456
open
Auto-generate foreign keys on pure SQL relation fields when doing TCA auto-generation
Status:
New
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2024-10-25
Due date:
% Done:
0%
Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:
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
);
No data to display
Actions