[TYPO3-dev] Request for cleanup of typo3 database schema

[Martin Kutschker]

Martin Kutschker schrieb:
> 
>> looking into the current schema, the most "bugfixing" should be 
>> possible by
>> using TEXT for blobs and INTEGER for (tiny|medium)?int(??).
> 
> Interger types are already handled well by DBAL/ADOdb. The only really 
> not portable type are unsigned ints.

To be precise: DBAL should upscale on PogreSQL tinyint (1 byte) to 
smallint (2 byte) and mediumint (3 byte) to integer (4 byte).

If this is not the case file a bug for it.

Masi

PS: I fear that all integer types are scaled to bigint (8 byte) anyway.