[BNM] mysql tinyint

[Jason Bailey]

Hello,

I'm just panicking slightly!

I'm looking at someone elses mysql database. The primary key field is set 
as a tinyint and they've hit the 127 value. I'm trying to fix the problem 
by using a bigger integer type.

I was just going to set it to smallint. Can you see any problems with that; 
other than hitting 32767 key value? The database is accessed using php 
-insert/edit/update queries etc?

Jas