[rt-users] resetting ticket numbers

[Drew Barnes]

I think the easiest way would be to drop and re-initialize the 
database.  Unless you did a bunch of custom scrips, templates, etc.

Jason Bachman wrote:
> Thanks Frank... I will give that a try!!
>
> Jason
>
> Frank Pater wrote:
>> 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
>>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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

-- 
Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati