[rt-users] reset ticket ID#?

[Steve Poirier]

Yes exactly, the tickets are deleted with the script, but the id is in
auto_increment, and you don't want to receive tickets that will use already
used #. Is it really a problem? Maybe it's better than your customer begin
receiving auto reply with Request #500 for example than request #3.

Other solution, like Ralph said, a new, empty SQL DB

Also, I'm not sure at 100% that this will  reset the ID, but you could try
to drop the table 'Tickets' and reimport it empty. Like this:

MySQL> use rt2
MySQL> DROP TABLE Tickets;
MySQL> CREATE TABLE Tickets (
  id int(11) NOT NULL auto_increment,
  EffectiveId int(11) default NULL,
  Queue int(11) default NULL,
  Type varchar(16) default NULL,
  IssueStatement int(11) default NULL,
  Resolution int(11) default NULL,
  Owner int(11) default NULL,
  Subject varchar(200) default '[no subject]',
  InitialPriority int(11) default NULL,
  FinalPriority int(11) default NULL,
  Priority int(11) default NULL,
  Status varchar(10) default NULL,
  TimeWorked int(11) default NULL,
  TimeLeft int(11) default NULL,
  Told datetime default NULL,
  Starts datetime default NULL,
  Started datetime default NULL,
  Due datetime default NULL,
  Resolved datetime default NULL,
  LastUpdatedBy int(11) default NULL,
  LastUpdated datetime default NULL,
  Creator int(11) default NULL,
  Created datetime default NULL,
  Disabled smallint(6) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY Queue (Queue,Status),
  KEY id (id,Status)
) TYPE=MyISAM;

Steve Poirier
Directeur développement / Projet Manager
Inet Technologies Inc.



----- Original Message -----
From: "Ralph Angenendt" <ra at letras.de>
To: "rt-users-list" <rt-users at lists.fsck.com>
Sent: August 10, 2001 12:53
Subject: Re: [rt-users] reset ticket ID#?