[BUGFIX] Reduce length of identifier key in sys_file_processedfile 22/28622/2
authorNicole Cordes <typo3@cordes.co>
Fri, 21 Mar 2014 21:13:34 +0000 (22:13 +0100)
committerStefan Neufeind <typo3.neufeind@speedpartner.de>
Fri, 21 Mar 2014 21:35:09 +0000 (22:35 +0100)
To support a smooth upgrade from a 6.0 or 6.1 system, we have to reduce
the length if the identifier field for the key "identifier".

Resolves: #57002
Releases: 6.2
Change-Id: Ic5928ceae1f288cfb3005ad271e493f356679c82
Reviewed-on: https://review.typo3.org/28622
Reviewed-by: Stefan Neufeind
Tested-by: Stefan Neufeind
typo3/sysext/core/ext_tables.sql

index 681ce50..810ef7c 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(249))
+       KEY identifier (storage,identifier(200))
 );
 
 #