[rt-users] removing deleted tickets

[Jonathan Chen]

Thanks Mike,
 
I guess this will be something I'll look into when I get back to work.    I'll probably use the php MySQL admin to do my deeds. =)     I am sure I will find commands similar to what you had (hopefully).
 
-Jonathan
 
-----------------------------------------------------------------
Message: 7
Date: Thu, 19 Feb 2004 08:55:12 +1000
From: "Mike Husband" <m.husband at leadup.com.au>
Subject: RE: [rt-users] removing deleted tickets
To: <rt-users at lists.bestpractical.com>
Message-ID: <006a01c3f672$44fdbc50$8f90a8c0 at internal.leadup.com.au>
Content-Type: text/plain; charset="iso-8859-1"

If you want to remove all tickets and restart with ticket #1 you will also
need to reset the ticket counter in the database.

I'm not sure how to do this with mysql, but with postgresql you will need to
do something like the following in psql:
   alter sequence tickets_id_seq restart with 1

You will need to do something similar for the following tables:
  tickets, ticketcustomfieldvalues, transactions, links, attachments

Use \dt to see a list of tables, \ds to see a list of sequence counters.

Hope this helps.

Mike

-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 4249 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20040218/94cf43f5/attachment.bin>