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

[Dmitry Dulepov]

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...

-- 
Dmitry Dulepov
http://typo3bloke.net/

"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)