[rt-users] Altering ticket id #

[Niels Bakker]

* cartera at lei.net.au (Adrian Carter) [Wed 17 Nov 2004, 17:18 CET]:
> I've rebuilt our RT onto a new platform with better queues etc.. but I
> want to reset the Ticket Id to be something like 10000+ so it doesn't
> clash with old-rt tickets.
> 
> Can someone point me in the right direction? im checking the Wiki stuff
> now, but can't find anything.

What database do you use?

For PostgreSQL, connect to the RT database and issue this a few
gazillion times:

   select nextval ('tickets_id_seq');

For MySQL, you can set the sequence number to arbitrary values; I've
only used phpMyAdmin to do so.


	-- Niels.

--