Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Schema question: products and products_description


dmgraham

Recommended Posts

Posted

I'm new to OSC and am integrating it with my back-end database system. I was surprised to find that the products_id column in products_description was set to auto-increment. The schema makes it appear that the products to products_description is 1 to many based on the languages_id. Since I'm planning on pushing my products via OBDC from our back-end system it seems nuts that I would have to increment both tables or run the risk of descriptions getting out of sync with products. My first thought was to simply turn off auto-incrementing on the foreign key in products_description, but I'm not sure if I'm going to be causing problems. Can anyone please clarify the thinking behind the current setup?

 

TIA,

 

Dave Graham

  • 8 months later...
Posted

Hi, I'd also like to know... Do I have to get the next AUTO_INCREMENT value for products, make sure the MAX value of products_description.products_id is not greater and then do the insert?

 

:-"

 

What might be the reason for this thusness?

Archived

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

×
×
  • Create New...