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

[Michael Stucki]

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.

Additionally I had to add support for such key definitions in the database 
parser of t3lib_install.

Branches:
TYPO3_4-0 / Trunk

Comments:
Many thanks to Dmitry who helped me to fix this at T3DD06!

Bugtracker reference:
n/A

- michael
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sys_refindex_key_fix.diff
Type: text/x-diff
Size: 2153 bytes
Desc: not available
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20060824/70308853/attachment.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20060824/70308853/attachment.pgp