[rt-users] reset ticket ID#?

Vivek Khera khera at kcilink.com
Fri Aug 10 14:28:29 EDT 2001


>>>>> "MH" == Martin Hemmings <mhemmings at trakonic.com> writes:

MH> How do I go about reseting this number so the next ticket entered
MH> in a clean database starts at #1?

You need to reset whatever counter your particular database uses.  If
it is MySQL, you most likely need to recreate the table with the
autoincrement column.  If it is PostgreSQL, you need to reset the
sequence value.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera at kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/




More information about the rt-users mailing list