Hi guys. I was just looking at the DB structure, and I noticed, whenever there's an INT primary key, it's UNSIGNED, but whenever there's a foreign key, it's not UNSIGNED. For example, codo_posts.topic_id and codo_topics.topic_id.
Also, why is cat_id in codo_topics SMALLINT instead of INT? Is it not a foreign key into codo_categories?
Anyway, it would be more correct if the keys corresponded, so, I guess they can all be INT UNSIGNED.
Cheers!
Hi guys. I was just looking at the DB structure, and I noticed, whenever there's an INT primary key, it's UNSIGNED, but whenever there's a foreign key, it's not UNSIGNED. For example, codo_posts.topic_id and codo_topics.topic_id.
Also, why is cat_id in codo_topics SMALLINT instead of INT? Is it not a foreign key into codo_categories?
Anyway, it would be more correct if the keys corresponded, so, I guess they can all be INT UNSIGNED.
Cheers!