[rt-users] reset ticket ID#?

[Martin Hemmings]

> -----Original Message-----
> From: rt-users-admin at lists.fsck.com
> [mailto:rt-users-admin at lists.fsck.com]On Behalf Of Feargal Reilly
> Sent: August 10, 2001 2:08 PM
> To: rt-users at lists.fsck.com
> Subject: Re: [rt-users] reset ticket ID#?
>
>
> Well actually, if all the transactions are deleted, then the key
> can be reset no problem.
> Mehtod varies depending on DB.



That was my thinking...  if everything is deleted from the database then
there should be no reason that the ID# doesnt get reset so that the next
ticket entered starts at 1.   Is this value stored in a variable that I can
access and change?

It's not really life-or-death that I get the counter reset to 1... I'm just
thinking ahead to when I present this system to the boss, get him to run
through the steps that it takes to enter a new ticket and wait for the
inevitable question "if this is ticket number x, what happened to the other
x-1 tickets?".  And I know it's going to be asked...

I'm not sure of the steps needed to drop and rebuild the DB now that I've
got the system running and configured (it was easy to do while I was still
in the setup phase).  Will I lose my configuration if I do a "make dropdb"
and "make install" again ?

Martin