[TYPO3-v4] Lenght of type int fields in pages and tt_content

Lorenz Ulrich lorenz-typo3 at visol.ch
Fri Apr 15 21:52:31 CEST 2011


Hi Kay

Thanks, but I know that. The question is: Could we change it in general.

Regards,

Lorenz

Am 15.04.2011 21:47, schrieb Kay Strobach:
> Hi,
>
> 1. make an extension
> 2. add ext_tables.sql
>     ->  add modifications (like create table fields, ...) ->  take a look
>        in other extensions
> 3. Install your ext.
> 4. modify DB.
>
> Ready to go ...
>
> Am 15.04.2011 21:39, schrieb Lorenz Ulrich:
>> Hi everone
>>
>> DB fields like
>>
>> pages:layout
>> tt_content:layout
>> tt_content:colPos
>> tt_content:section_frame
>>
>> allow own configuration handled by TSconfig and Typoscript e.g. to have
>> multiple layouts for content elements etc.
>>
>> On bigger sites it's hard to keep track about the already used id's. So
>> I came up with the idea used for throwing exceptions - use the current
>> timestamp so the probability to use one number twice is very small. But
>> this is not possible because their type in the DB is tinyint(3) so the
>> maximum number is 255.
>>
>> What do you think about the idea to have a bigger length for these
>> fields? The new field backend_layout is int(10) and so its maximum is
>> 2147483647 - enough for the next years :).
>>
>>
>> Best regards,
>>
>> Lorenz
>>
>
>



More information about the TYPO3-project-v4 mailing list