[rt-users] resetting ticket numbers

[Frank Pater]

Hi Jason,

	I was able to do this for my Postgres-based RT installation with the following SQL:

select setval('tickets_id_seq', <starting-ticket-number>);

I'm sure there is similar code that works for MySQL.

Frank


On Fri, Nov 18, 2005 at 10:11:31AM -0500, Jason Bachman wrote:
>    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
> 
>        ------------------------------------------------------------------
> 
>  _______________________________________________
>  [1]http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
>  Be sure to check out the RT Wiki at [2]http://wiki.bestpractical.com
> 
>  Download a free sample chapter of RT Essentials from O'Reilly Media at [3]http://rtbook.bestpractical.com
> 
>  WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
>  San Francisco - Find out more at [4]http://bestpractical.com/services/training.html
> 
> References
> 
>    Visible links
>    1. http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>    2. http://wiki.bestpractical.com/
>    3. http://rtbook.bestpractical.com/
>    4. http://bestpractical.com/services/training.html

> _______________________________________________
> 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
Frank Pater
DCANet
http://www.dca.net
voice: 888-4-DCANET (888-432-2638)
fax: 302-426-6386