Database tables structures

[tamplan]

Since version 2.3.x of IPB, the ibf_posts and the ibf_topics don't have the same type for the icon_id field.

Let's imagine this situation, a member can use 127 (tinyint(2)) icons message in a post but much more in a topic (smallint(3)).

We can use API to write topic with a incorrect icon message number we can not change later editing the first post of the topic.

Not really a bug but using the same type for the icon_id field should be better not?

[bfarber]

[quote name='tamplan' date='19 August 2009 - 05:43 AM' timestamp='1250674984' post='1846165']
Since version 2.3.x of IPB, the ibf_posts and the ibf_topics don't have the same type for the icon_id field.

Let's imagine this situation, a member can use 127 (tinyint(2)) icons message in a post but much more in a topic (smallint(3)).

We can use API to write topic with a incorrect icon message number we can not change later editing the first post of the topic.

Not really a bug but using the same type for the icon_id field should be better not?


In practice it shouldn't matter. Any performance differences between the field types are negligible, and the only way you can run into issues is if you are directly inserting/modifying data in those fields outside of the standard IPB interface, so there shouldn't be any associated bugs.