[rt-users] Changing initial ticket number

mikula mali mikulamali at hotmail.com
Mon Feb 14 03:45:20 EST 2005


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
>





More information about the rt-users mailing list