[rt-users] Customizing Incident numbers

[MAS]

--On 24 November 2003 08:54 -0500 "Carpenter, Scott (OCTO)"
<Scott.Carpenter at dc.gov> wrote:

> Is it possible to a) customize incident numbers (ddmmyy-xxx) and/or b)
> start renumbering all incidents at xxx (eg. 456 instead of #1) 

Don't know about (a), but (b) is easy (on MySQL, at least):

ALTER TABLE Tickets AUTO_INCREMENT=456;

will make the auto_increment counter on the Tickets table start at 456
instead of 1.

For more info see

<http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html>

mike