[TASK] Add key to uid_local of sys_file_reference 38/49938/2
authorGeorg Ringer <georg.ringer@gmail.com>
Wed, 14 Sep 2016 06:52:22 +0000 (08:52 +0200)
committerMarkus Klein <markus.klein@typo3.org>
Tue, 20 Sep 2016 12:10:05 +0000 (14:10 +0200)
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>
typo3/sysext/core/ext_tables.sql

index aeebeda..5ad60ad 100644 (file)
@@ -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)
 );