How to reset ticket # counter

RT Users
1

Is there any one who can help me to reset the ticket counter to 0. as i have
deleted all test mails from dB so i also want to reset the thicket counter.
which table contains information about ticket counter?
View this message in context: http://old.nabble.com/How-to-reset-ticket---counter-tp27520320p27520320.html

2

Hi,

What database are you using?

MySQL: truncate table Tickets; truncate table Transactions; truncate table
ObjectCustomFieldValues; truncate table Attachments.

Other Databeses, I don’t know. Please note that truncate is a dangerous
command, and literally deletes all information in the tables selected, and
resets the cardinality to 0.On Tue, Feb 9, 2010 at 11:01, softouch razzipk@hotmail.com wrote:

Is there any one who can help me to reset the ticket counter to 0. as i
have
deleted all test mails from dB so i also want to reset the thicket counter.
which table contains information about ticket counter?

View this message in context:
http://old.nabble.com/How-to-reset-ticket---counter-tp27520320p27520320.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

2010 RT Training Sessions!
San Francisco, CA, USA - Feb 22 & 23
Dublin, Ireland - Mar 15 & 16
Boston, MA, USA - April 5 & 6
Washington DC, USA - Oct 25 & 26

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Bill Graboyes
On Assignment At:
Toyota Motor Sales, USA, Inc.
Consumer Portal Delivery
Office: (310) 468-6754
Cell: (714) 515-8312