[TYPO3-core] RFC: Fix sys_refindex problem when using multiplyDBfieldSize=2

[Franz Holzinger]

Dmitry Dulepov a écrit :

>Hi!
>
>Michael Stucki wrote:
>  
>
>>This is a SVN patch request.
>>
>>Problem:
>>When using multiplyDBfieldSize=2 the whole sys_refindex table cannot be 
>>created.
>>
>>The reason for this is that the field "ref_string" is part of the key 
>>"lookup_string". The field is defined to be varchar(200), and this is where 
>>the problem occurs:
>>multiplyDBfieldSize=2 changes the field type to "text", and since text fields 
>>have no size limitation, it cannot be part of the key.
>>
>>Solution:
>>Define the key to be only 199 characters long. For some reason it didn't work 
>>with a length of 200 chars.
>>    
>>
>
>+1 since it was seen already on t3dd06...
>
>  
>
+1 based on reading the code


- Franz