[BUGFIX] Index on sys_file_processedfile is still too large 29/28429/2
authorErnesto Baschny <ernst@cron-it.de>
Sat, 15 Mar 2014 20:59:25 +0000 (21:59 +0100)
committerErnesto Baschny <ernst@cron-it.de>
Sat, 15 Mar 2014 21:02:08 +0000 (22:02 +0100)
On some systems even "332" characters is too large. To also cope with
potential utf8mb4 setups (1 char = 4 bytes), and staying under 1000 byte
limit, we reduce the amount of characters in the index to 249.

Resolves: #56786
Related: #54234
Releases: 6.2
Change-Id: I79452224f37ec2b6ca5b3a35044144eed787df67
Reviewed-on: https://review.typo3.org/28429
Reviewed-by: Ernesto Baschny
Tested-by: Ernesto Baschny
typo3/sysext/core/ext_tables.sql

index 8f73c6c..e98eff6 100644 (file)
@@ -380,7 +380,7 @@ CREATE TABLE sys_file_processedfile (
 
        PRIMARY KEY (uid),
        KEY combined_1 (original,task_type,configurationsha1),
-       KEY identifier (storage,identifier(332))
+       KEY identifier (storage,identifier(249))
 );
 
 #