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

Tom Lahti toml at bitstatement.net
Mon May 11 15:56:13 EDT 2009


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/
-- ============================



More information about the rt-users mailing list