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

2009-08-03 Thread 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

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

2009-06-30 Thread Dusty Wilson [Megagram]
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