[TYPO3-core] RFC: Getting rid of blob fields in TYPO3 databases

[Martin Kutschker]

Michael Stucki schrieb:
> Committed to Trunk.
> 
> - michael
> 
> Michael Stucki wrote:
> 
>> This is a SVN patch request.
>>
>> Problem:
>> TYPO3 uses a lot of blob fields all over the place. This is a misuse since
>> the content is always text (no binary content at all!).
>>
>> Additionally, I've changed some int(11) fields to tinyint(1) because they
>> are all just boolean :-)
>>
>> Solution:
>> See patch.
>>
>> Branches:
>> Trunk only
>>
>> Comments:
>> Thanks to Dmitry Dulepov and Bernhard Janetzki for supporting me at this.
>>
>> - michael
> 
> Committed to Trunk.

There are still BLOBs in system extensions:

./typo3/sysext/cms/ext_tables-index.sql
./typo3/sysext/cms/ext_tables.sql
./typo3/sysext/cms/ext_tables_static+adt.sql
./typo3/sysext/dbal/ext_tables.sql
./typo3/sysext/sys_action/ext_tables.sql
./typo3/sysext/indexed_search/ext_tables.sql
./typo3/sysext/impexp/ext_tables.sql
./typo3/sysext/tsconfig_help/ext_tables.sql
./typo3/sysext/tsconfig_help/ext_tables_static+adt.sql

Shall we change them too? Note that there is a bu report for FE sessions 
(#4628).

Masi