[TYPO3] Include static (from extensions) not more than 20?

[Xavier Perseguers]

> Main template id is 1
> sub1 id is 2
> sub2 id is 3
> sub3 id is 4
> 
> so in the template record 1 the field basedOn is filled with 2,3,4
> 
> As the column basedOn is defined as a tinyblob there is a limitation on 
> the DB side for adding new entries to that list...
> 
> MySQL says:
> TINYBLOB, TINYTEXT 	L+1 Byte, L  < 2^8 = 256
> 
> I don't know whether there is another limitation build into TYPO3-core 
> but I encountered the same problem when trying to manage user rights. 
> After a certain amount it is impossible to add more rights to a group / 
> user. Same solution as above, define subgroups and nest them ...

I hope that considerations will be made when (re)designing the DB model 
for the "upcoming" version 5.0 of TYPO3.

If for any reason (such as better performance than performing multiple 
DB queries) the team chooses to go on using this style of creating 
foreign keys, I think it would be wise to make these settings visible 
and let the user alter the DB schema to extend it a bit.

Xavier Perseguers