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); _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com