[BNM] mysql tinyint

[Jason Bailey]

> Well, the only trouble you *may* have - is where the joins are made to
> foreign keys in other tables. It may be (and I can't remember whether
> MySQL enforces this) that the data types have to be of the same TYPE....


> Look out for these. We had a nasty one a year or so back where (iirc)
> joining on a negative int foreign key on a heap table caused the
> whole mysql instance to crash. Icky, and thanks to a rigorous
> database restart procedure the only symptom we could see was that
> *suddenly* heap tables emptied themselves...


Thanks for all replies. The table is basically holding newsletter info so 
doesn't appear to be linking elsewhere. One table links to it but on 
another field so it's got a foreign key in there which doesn't seem to be 
affected.

Just saying thanks. Ticket closed!

Jason