[rt-users] How to reset ticket # counter

[William Graboyes]

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 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100209/a136a5b1/attachment.htm>