[rt-devel] Re: [rt-users] Ticket Number Generation

[Bruce Campbell]

On Thu, 22 Aug 2002, Pat Steffensen wrote:

> it loaded and running (which was the opposite of painless), but don't want
> to start at number 1...I'd like a YYMMDDTicketNumber sort of syntax...any
> advice or direction would be greatfully apprecated!  Thanks,

Hrm, problem - wanting to have something other than bog-standard
id-from-Tickets-table.  It happens often enough, and why not allow free
text as the identifier.  It'd be easy enough to change the identifier
given to requestors/Ccs, and the inputs shown on the web.

Apart from upping the auto_inc value on the table each night, what other
solutions have people come up with?

-- 
                             Bruce Campbell                            RIPE
                   Systems/Network Engineer                             NCC
                 www.ripe.net - PGP562C8B1B             Operations/Security