[whups] DB Schema Question

Mike Baptiste mike@msbnetworks.net
Fri Nov 22 14:37:07 2002


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

That's what I figured.  Thanks for the pointer on the auto create of the
table!

Mike

Chuck Hagenbuch wrote:

| In a hellishly unportable standard, AUTO_INCREMENT is one of the _least_
| portable ideas ever; it works with nothing but MySQL. We use PEAR DB::
| sequences to make sure that Whups works with pretty much any database; I
| routinely work on it on my win2k laptop running MS-SQL.
|
|
| >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.
|
|
| You don't create the _seq table; DB:: creates it for you.
|
| -chuck
|
| --
| Charles Hagenbuch,
| "People ask me all the time what it will be like living without otters."
|  - Google, thanks to Harpers
|
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE93kETtbf8BjvL+3ERAnDAAKCJnS0YuoYDzgVCFGxby2LR00OqsQCeO8JK
viZJDDEKIEVgYQxcmj4YULI=
=qQAD
-----END PGP SIGNATURE-----



More information about the whups mailing list