[rt-users] reset ticket ID#?

[Feargal Reilly]

Well actually, if all the transactions are deleted, then the key can be reset no problem.
Mehtod varies depending on DB.

On Fri, 10 Aug 2001 18:53:03 +0200
Ralph Angenendt <ra at letras.de> wrote:

> Martin Hemmings wrote:
> > 
> > How do I go about reseting this number so the next ticket entered in a clean
> > database starts at #1?
> 
> You don't, that's the primary key of the database, which gets
> counted up internally. The only solution I can see is dropping the
> database and begin with a fresh install :-)
> 
> Ralph
> -- 
> __________________________________________________________________________
> Ralph Angenendt       | "Military justice is to justice what military
> http://www.letras.de  |  music is to music"
> ra at letras.de          |                -- Groucho Marx
> 


-- 
Feargal Reilly,
Systems Administrator,
The CIA.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 230 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20010810/5868ae7b/attachment.sig>