[rt-users] removing deleted tickets

[Mike Husband]

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
 

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com]On Behalf Of Jonathan Chen
Sent: Wednesday, 18 February 2004 2:43 AM
To: rt-users at lists.bestpractical.com; pape-rt at inf.fu-berlin.de
Subject: [rt-users] removing deleted tickets


This script is interesting.   I'm not a perl programmer but I'm wondering if
it can be modified to delete ALL tickets from ALL queues so RT would start
assigning tickets with #1 again.  If it is, how would I go about it?  If
there is a script like this already available, please lead me to one.   
 
Thanks!
 
-Jonathan

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