[whups] DB Schema Question

Mike Baptiste mike@msbnetworks.net
Fri Nov 22 02:55:56 2002


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I've noticed that for many of the whups tables with an incremental
primary key, a secondary sequence table ending in _seq with one row is
used to keep track of the ID sequence.   Why wasn't an AUTO_INCREMENT
field for the primary key used instead?  DB Portability?  Just curious.

I'm bringing the whups_attachments table back to life to link tickets to
VFS object IDs and to store attachment attributes.  I figure I'll need a
whups_attachments_seq table as well, but wanted to ask to make sure.

Mike
- --
Mike Baptiste - MSB Networks - mike@msbnetworks.net
Download my GnuPG key at http://msbnetworks.net/msbnet.gpg
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE93Zy7tbf8BjvL+3ERAjF2AKDN+ZV+36nKcZsaTnLlwUMXmvtRKgCdH/UJ
x8xubedTGbydyrTkSd+vxww=
=uf2v
-----END PGP SIGNATURE-----



More information about the whups mailing list