Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

database-understanding, strange table/field


cpedaschus

Recommended Posts

Hi folks,

 

i'm coding some database-interface to map our own shop onto oscommerce and found some strange relationship.

perhaps someone can clearify this for me...?

 

take a look at the following tables:

products_attributes

products_options

 

theyre linked together via the

att.options_id -> opt.products_options_id

 

but where does this id come from?

how does the shop calculate the value for a new option?

 

in my humble opinion the products_options table is missing an auto_increment on the products_options_id field...

 

thx in advance,

christian

 

 

ps. i'm using the 2.2milestone

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...