Changing initial ticket number

RT Users
1

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?

Basically, I dont want our requestors to get an idea that we’re just serving
very first support requests. Thanks.

-marc

2

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

3

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?

4

---------- Forwarded message ----------
From: “mikula mali” mikulamali@hotmail.com
To: rspier@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@pobox.com
To: “mikula mali” mikulamali@hotmail.com
CC: rt-users@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

5

You could write a script that creates 1,233 tickets and then use
RTx::Shredder to delete them…On Mon, Feb 14, 2005 at 08:45:20AM +0000, mikula mali wrote:

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?