[rt-users] Re: Leaking sensitive information

[seph]

>> Is there a way to assign "random" ticket ids? 

> (mysql solution.. postgres solution is equivalent, but looks different.)
>
> You could have a program run once in a while and increment the
> AUTO_INCREMENT id field in the Tickets table to some random number
> above your current MAX(Tickets.id)

instead of that, you could run something daily that sets it to
something representing the day. such that your ticket ids are of the
form <day><sequence>. If you do it by frobbing the db's
autoincrementing thing directly, the impact on rt is minimal.

I think I saw patches awhile back to get rt to use date-sequnce ids,
but I might have imagined them.

seph