[ic] Defining new complex key database table

Alex Lofaso (Planetanime.com) interchange-users@icdevgroup.org
Thu Nov 21 15:11:01 2002


Hello List!

I am trying to define a new mysql table for ic.  It has a complex primary
key of sku and id.
I tried the following but got errors:

Database  products  KEY          sku, id

also I tried

Database  products  KEY          sku
Database  products  KEY          id

but ended up with 2 ids in the UI.

Any suggestions?  Or can complex primary keys not be used?

Thanks

Alex