How to reset ticket # counter

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

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.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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

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?
Other than being fussy, there’s really no reason to do this.
The ticket ID is what it is. Are you going to reset it whenever
you get SPAM? Indeed, one could argue that having your
tickets not start at one, and having SPAM randomly inserted
is a minor gain for “security;” most notably if you have to
allow anyone write-access to any ticket as a means of
coping with people using their half-dozen addresses interchangeably**.

** MergeUsers presumes you know of the alternate addresses beforehand,
or can afford to reject otherwise legitimate messages until you are
aware of them.
Cambridge Energy Alliance: Save money. Save the planet.