#109802[TASK] Adjust creation of indexes on junction tables
Description
- Remove redundant index on `uid_local`, as it is already covered by the composite primary key (`uid_local`, `uid_foreign`) or (`uid_local`, `uid_foreign`, `tablenames`, `fieldname`) if `tablenames` and `fieldname` are provided. A reverse lookup index on `uid_foreign` is sufficient, since it already includes the primary key columns.
- Add a unique index on (`uid_local`, `uid_foreign`) and include `tablenames` and `fieldname` columns if they are provided for the case when a primary key `uid` is needed. A reverse lookup composite index on (`uid_foreign`, `uid_local`) is created in this case.
This issue was automatically created from https://github.com/TYPO3/typo3/pull/640
Reviews 1
History 34
-
Gerrit Code Review pushed patch set 1 for 13.4 to change 94036 status
NewUnder Review 05/08/26, 09:50 -
Garvin Hicking commented and changed status
Under ReviewClosed 05/08/26, 10:19 -
Garvin Hicking changed Duplicated by #109801 05/08/26, 10:20
-
Garvin Hicking changed Duplicates #109803 05/08/26, 10:20
Dupe of https://forge.typo3.org/issues/109803