[rt-users] Can the ticket ID fields in the database be INT UNSIGNED?

[Jerrad Pierce]

A note for anyone who does this, be sure to include auto-increment e.g;

ALTER TABLE Tickets CHANGE id id INT UNSIGNED auto_increment;

On MySQL at least, it helpfully drops that "extra" bit--
but not the key!--when you ALTER, so:

ALTER TABLE Tickets CHANGE id id INT UNSIGNED;

Could lead you to a confusing place, especially if you apply
this change while adding some indices to speed things up
like:

ALTER TABLE CachedGroupMembers ADD INDEX(MemberId);
ALTER TABLE Groups ADD INDEX(Instance);
ALTER TABLE Principals ADD INDEX(PrincipalType);