[rt-users] serial number format
jesse at fsck.com
Mon Jan 22 05:16:40 EST 2001
Indeed. However, if one is going to be doing local customization,
changing serial_num to a BIGINT should get you plenty of breathing room.
On Mon, Jan 22, 2001 at 09:13:30PM -0800, Matthew Horoschun wrote:
> You won't have enough bits... INT is 4 bytes, so you'd only get up to a bit over
> Jesse wrote:
> > We depend on the database to generate those unique serial numbers.
> > If you can get mysql to generate sequence numbers in the apropriate range,
> > it should just work. If you can't make mysql do it, there's not really any way.
> > One way (assuming that the serial #'s INT type has enough bits..which I can't
> > look at right now) is to have a cron job that inserts an entry into the
> > each_req table with a serial number of yyyymmdd0000. As long as you never
> > get more than 9999 tickets in a given day this should be fine. Note that
> > I don't know if _anyone_ who's ever done this.
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90
<Dr_Memory> the point is that words were exchanged. neurolinguistic
programming will do the rest. they should be showing up at my house
any day now.
More information about the rt-users