[rt-users] Ticket ID as CHAR(32)?

Jesse Vincent jesse at bestpractical.com
Tue Jun 30 17:28:40 EDT 2009




On Tue, Jun 30, 2009 at 03:06:17PM -0500, Dusty Wilson [Megagram] wrote:
> I just sent an email about UNSIGNED INT for the database.  This is a
> separate (but related) question:  Is there a reason why ticket IDs
> can't be CHAR(32)?  I'd love to use a proper UUID as a ticket ID.

That's going to break an awful lot of assumptions in RT's code. Primary
keys are integers. And Ticket Id is as primary as they come. I'd be
interested to see patches, but you're going to have your work cut out
for you.

> If I convert a UUID from hex (base 16) to alphanumeric (case
> sensitive: base 62; case insensitive: base 36), I can use much less
> space to store the UUID.
> 
> Anyone have any thoughts on that?
> 
> Thanks,
> Dusty
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
> 

-- 



More information about the rt-users mailing list