CoPaP Database Script Questions

Development for CoPaP
Post Reply
Furin
Ambassador: Tolmia
Posts: 12
Joined: Mon Nov 10, 2003 5:53 pm
Location: Tolmia

CoPaP Database Script Questions

Post 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
Post Reply