[rt-users] Re: Changing initial ticket number

Damian damianburke at gmail.com
Mon Feb 14 12:50:14 EST 2005


> ---------- Forwarded message ----------
> From: "mikula mali" <mikulamali at hotmail.com>
> To: rspier at pobox.com
> Date: Mon, 14 Feb 2005 08:45:20 +0000
> Subject: Re: [rt-users] Changing initial ticket number
> I tried SQL "ALTER table ...", as it was suggested earlier on this list but
> it definitely does not work with RT 3.4; is it possible that new 3.4 doesnt
> rely on AUTO INCREMENT?
> 
> >From: Robert Spier <rspier at pobox.com>
> >To: "mikula mali" <mikulamali at hotmail.com>
> >CC: rt-users at lists.bestpractical.com
> >Subject: Re: [rt-users] Changing initial ticket number
> >X-OriginalArrivalTime: 14 Feb 2005 06:24:29.0229 (UTC)
> >FILETIME=[D6A47DD0:01C5125D]
> >
> > > Hi -- is there a simple way to change the new ticket id (in the new
> > > installation) so that new tickets numbers will be created, for
> > > example, starting at #1234 rather than #1? Even better: is there a way
> > > to customize ticket number visible to requesters?
> >
> >http://dev.mysql.com/doc/mysql/en/example-auto-increment.html
> >
> >ALTER TABLE Tickets AUTO_INCREMENT=1234
> >
> 
> 
The ALTER TABLE command to update the auto-increment value
does not work on InnoDB tables.  You can manually insert
a row into the Tickets table with id of 1233, then delete that row.
The next row added will then use id of 1234.

INSERT INTO Tickets (id) VALUES (1233);
DELETE FROM Tickets WHERE id=1233;

   Damian



More information about the rt-users mailing list