[TASK] Add key to uid_local of sys_file_reference

To improve the performance, an additional key
is added to the table 'sys_file_reference'.

Resolves: #76940
Releases: master, 7.6
Change-Id: Ie552e016ceeedc6fd26916798b06815ba5d1219e
Reviewed-on: https://review.typo3.org/49938
Tested-by: TYPO3com <no-reply@typo3.com>
Reviewed-by: Oliver Klee <typo3-coding@oliverklee.de>
Reviewed-by: Stefan Neufeind <typo3.neufeind@speedpartner.de>
Tested-by: Stefan Neufeind <typo3.neufeind@speedpartner.de>
Reviewed-by: Markus Klein <markus.klein@typo3.org>
Tested-by: Markus Klein <markus.klein@typo3.org>

diff --git a/typo3/sysext/core/ext_tables.sql b/typo3/sysext/core/ext_tables.sql
index aeebeda..5ad60ad 100644 (file)
--- a/typo3/sysext/core/ext_tables.sql
+++ b/typo3/sysext/core/ext_tables.sql
@@ -422,6 +422,7 @@ CREATE TABLE sys_file_reference (
        KEY parent (pid,deleted),
        KEY tablenames_fieldname (tablenames(32),fieldname(12)),
        KEY deleted (deleted),
+       KEY uid_local (uid_local),
        KEY uid_foreign (uid_foreign)
 );