[TASK] Add key to uid_local of sys_file_reference 80/49980/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:21 +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/49980
Reviewed-by: Markus Klein <markus.klein@typo3.org>
Tested-by: Markus Klein <markus.klein@typo3.org>
typo3/sysext/core/ext_tables.sql

index ae6feb2..7693941 100644 (file)
@@ -423,6 +423,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)
 );