Page 1 of 1

CoPaP Database Script Questions

Posted: Sun Jan 11, 2004 12:49 am
by Furin
Hi,


I'm running through the CoPaP-supplied DB scripts (e.g., table DDLs and treasure DMLs), and I noticed a small thing that may or may not be a bug.

In the table DDL for "merchant_items", the comment and primary key seem to have been copied/pasted from the "containers" table DDL. This is probably not a problem: I just want to confirm that the intended primary key for this table is in fact (container, item), as the DDL indicates. (Also, I've changed the comment in my version of the script to say, "Holds data for persistant merchants." That's about right, isn't it?)

Would whoever owns/wrote/knows about these DDL statements please confirm or disconfirm that the PKs for merchant_items are correct?


Thanks very much,
Furin