[rt-users] Reset or Clear Old Ticket Data + Reset Ticket ID Value

[Robert Marier]

Hi all.  I'm running RT 3.4.1 and have the following 2 questions.

I need to clear the RT database of all old ticket and ticket related
information as well as reset the the ticket id so that it's back at 1.

Question 1: Which tables do I need to reset/clear?

Question 2: How do I set the ticket id back to its original value?
(After I delete all ticket values,


* What I know concerning Question 1:
I have the following tables in the RT database:
  ACL
  Attachments
  Attributes
  CachedGroupMembers
  CustomFieldValues
  CustomFields
  GroupMembers
  Groups
  Links
  ObjectCustomFieldValues
  ObjectCustomFields
  Principals
  Queues
  ScripActions
  ScripConditions
  Scrips
  Templates
  Tickets
  Transactions
  Users
  sessions

I'm guessing I need to clear (delete * from _table-name_):  Attachments,
Links, Tickets, Transactions.  What else?

Anything else I should know regarding this process?

Thanks in advance,

Robert Marier