At Thursday 10/25/2007 04:47 PM, you wrote:
Insert a row in the tickets table with id 4999, then the next ticket
will be 5000.
This may depend on which database you're using. Oracle, for example,
uses a sequence object for the next id, so in that case you'd need to
reset the sequence value.
Is anyone aware of a way that I can have my next ticket start at an
arbitrary high value that I select? I'm on a new installation, and I
have created a few test tickets (I believe I'm up to number 4) but if
possible I would like the next ticket to start at 5000.
That was my initial plan, but I wanted to make sure there wasn't an RT
sanctioned way, since the general recommendation seems to be to avoid
messing with the database directly.
I can't imagine this would cause any integrity problems.
Todd Chapman wrote:
Insert a row in the tickets table with