[rt-users] How to modify the ticket # format?

[Eric_Malenfant at Mitel.com]

Well, modifying the code is what was done years ago for our current 
implementation. It was deployed back before Mitel had purchased E-Smith 
(old Linux distro) and
is actually still in use today, but we have some new requirements which 
warrants an upgrade.

The one thing that would be great to keep, is how we are numbering our 
tickets today.

Today, when a ticket is created, it does get a number like this:

id: 20090414054 

this number would already be considered greater than 2147483647, and I 
believe from what I have heard about the history of this old RT 2.x 
deployment (I believe the old version in use is 2.0.7)
was in fact that we worked with the devs to get this to work, and I can in 
fact see bigint(xx) in some parts of the schema.

I can hack around that part. What I would like to know is where can I set 
the start # to begin with. 

If I do abandon this date format for tickets, I'd then want to start at 
something high, like 10000, not 1.

Is that possible?


Eric Malenfant
Mitel Networks
IT Systems Specialist
AD / UNIX Systems / Network Applications 
Toll Free: 800.267.6244 ext 2864 
Eric_Malenfant at mitel.com

Unix is user friendly, it's just picky who it's friends are!



Tom Lahti <toml at bitstatement.net> 
05/11/2009 03:56 PM

To
Ruslan Zakirov <ruslan.zakirov at gmail.com>
cc
Eric_Malenfant at mitel.com, rt-users at lists.bestpractical.com
Subject
Re: [rt-users] How to modify the ticket # format?






Ruslan Zakirov wrote:
> http://wiki.bestpractical.com/view/SetStartingId + cronjob to set it
> everyday, however you must understand limits on integers in your DB.

>> Example: #200905110001  would be the 1st ticket for today.

A normal signed int in 32-bit mysql has a maximum value of 2147483647, 
which
isn't big enough for the format requested.  You'd need to alter the table
structures to change ticket id's to a bigint.  How much code that would
break inside of RT, I have no idea.

-- 
-- ============================
   Tom Lahti
   BIT Statement LLC

   (425)251-0833 x 117
   http://www.bitstatement.net/
-- ============================

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090512/6ec6ea5d/attachment.htm>