[rt-users] reset ticket ID#?

[Steve Poirier]

A good URL to 'play' and learn about how your db work with MySQL

http://www.mysql.com/documentation/
__
Steve Poirier
Directeur développement / Projet Manager
Inet Technologies Inc.



----- Original Message -----
From: "Martin Hemmings" <mhemmings at trakonic.com>
To: "rt-users-list" <rt-users at lists.fsck.com>
Sent: August 10, 2001 12:17
Subject: [rt-users] reset ticket ID#?


>
> I've finished setting up users, configuring scrips and testing the queues,
> and now I wish to return the database to it's original condition (ie empty
> and fresh).
>
> I used Steve's script to delete all dead tickets from the database, but
when
> I create a new ticket it continues on with the ticket ID# sequence.
>
> How do I go about reseting this number so the next ticket entered in a
clean
> database starts at #1?
>
> Thanks,
> Martin
>
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>