[rt-users] resetting ticket numbers

[Jason Bachman]

I have a related question to this one.....
Is it possible to change the starting ticket number?  The boss would 
like the ticket numbers to be something like 1001, 1002, 1003... instead 
of 1,2,3...

Thanks,
Jason

Walmach, Joe wrote:

> Is it possible to reset the tickets back to zero? We're finished with 
> our testing and want to go live but it would be good to erase all the 
> test tickets first. Deleting them still holds them in the data base 
> with the counter leaving off with the last ticket number. Truncating 
> the ticket table in mysql (Linux) brought me back to zero but all new 
> tickets include the original data in the history view. For example, 
> ticket number 1 shows what transpired in the original ticket #1. I 
> hope I'm not asking a question that's already been answered. I've 
> searched the archives and only found one incident of this question 
> which went unanswered. Any help would be appreciated.
>
>  
>
> Thanks,
>
>  
>
> Joe
>
>------------------------------------------------------------------------
>
>_______________________________________________
>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
>Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>
>Download a free sample chapter of RT Essentials from O'Reilly Media at http://rtbook.bestpractical.com
>
>WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
>San Francisco - Find out more at http://bestpractical.com/services/training.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20051118/60d07ec4/attachment.htm>