[rt-users] serial number format

Jesse 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
> 2,000,000,000.
> 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.
> Matt.

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 mailing list