DB Schema Question

Mike Baptiste <[email protected]>
Newsgroups gmane.comp.horde.whups
Organization MSB Networks
Message-ID <[email protected]>
-----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 - [email protected]
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-----


-- 
Whups mailing list
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: [email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.