[TYPO3-core] RFC #11023: Table sys_refindex cannot be created with DBAL

[Jigal van Hemert]

Xavier Perseguers wrote:
>>>>>> The syntax to specify only a given number of characters to be 
>>>>>> taken for the index is MySQL-specific and furthermore is not 
>>>>>> supported by t3lib_db parser making it impossible to create this 
>>>>>> table for, e.g., Oracle from the Install Tool.
>>>>>>
>>>>>> Solution:
>>>>>> Make an index with all 255 characters to be DBMS-agnostic:
>>>>>>
>>>>>> KEY lookup_string (ref_table,ref_string)

-1

It is best to keep indexes in MySQL as small as possible, especially if 
the index uses multiple fields.
Also if this is the primary key and this is a table that uses the InnoDB 
engine this index will be part of the record itself instead of a 
seperate index. A large primary key will make the data records much 
larger than necessary.

Regards,
-- 
Jigal van Hemert.