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
I've noticed that in the tables that the ticket ID is not unsigned.
Is there a use for ticket IDs smaller than zero? I've adjusted the
schema for my system to use INT UNSIGNED for all of the ticket ID
fields. I'm needing a big ticket ID number for my purposes. I just
wonder if I'm going to be br