TYPO3 Core

When having an inline field or a select field to another table, it can be useful to declare foreign keys on the relation field (for reeferential integrity, generating SQL relation diagrams or doing ON DELETE/ON UPDATE stuff directly via SQL). When letting the TCA autogenerate the SQL definition it is not possible to declare a foreign key. The DB compare tool will just crash hard. One has to copy the field definition to ext_tables.sql then.

# When letting this field be created by TCA automagic (same SQL defintion) it will crash:
my_field int unsigned DEFAULT NULL,

FOREIGN KEY fk_my_field (my_field) REFERENCES foreign_table (uid)

Note: this bug only affects foreign keys! Normal indexes work just fine on TCA-autogenerated fields!