Issue Feature Closed

#105455Allow declaring SQL indexes when using TCA-based auto-generation of fields

S P 10/25/24, 06:57 updated 03/25/25, 08:32

Description

It would be nice if something like this could be triggered from TCA when using TCA auto-generation of SQL fields.

CREATE TABLE my_table
(
    INDEX title (title)
);

For example by (or similar)

'config' => [
    'dbCreateIndex' => true
]

or maybe having a separate array in ctrl to even be able define composite keys:

'ctrl' => [
    'dbCreateIndexes' => [
        'my_comp_index' => ['title', 'category'],
        'my_single_index' => ['another_field'],
    ]
]

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.