Project

General

Profile

Actions

Feature #105455

open

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

Added by S P 6 days ago.

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 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'],
    ]
]

No data to display

Actions

Also available in: Atom PDF