Project

General

Profile

Actions

Feature #103448

open

Move DB index definition from ext_tables.sql to TCA

Added by JAKOTA Design Group GmbH 2 months ago. Updated about 1 month ago.

Status:
New
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
Start date:
2024-03-21
Due date:
% Done:

0%

Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:

Description

The TCA file should be extended to setup table indexes.

1. option


  'types' => [
  ...
  ],
  'columns' => [
  ...
  ],
  'indexes' => [
    'language_identifier' => ['l10n_parent','sys_language_uid'],
    'mn_key' => ['key_to_other_table'],
    ...
  ],

This would leave more room to also include fields set by Typo3 like pid or uid.

or

2. option


  'columns' => [
    'parent_key' => [
      'config' => [
         ...
        'foreign_table' => 'tx_extname_domain_model_parent',
        'index' => 'index_name',
      ],
    ],
    ...
  ],

With the 2. option one would just set the index by the field and if more than one field have the same index name it becomes an index over the all fields.

Maybe having both options could be useful?

As this is just the idea I have not thought about index types like primary, unique, ... or order.


Related issues 1 (1 open0 closed)

Related to TYPO3 Core - Task #96729: Auto generate database index "language"AcceptedStefan Bürk2022-02-02

Actions
Actions #1

Updated by Chris Müller about 2 months ago

  • Related to Task #96729: Auto generate database index "language" added
Actions #2

Updated by Stefan Bürk about 1 month ago

  • Assignee set to Stefan Bürk
Actions

Also available in: Atom PDF