Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

database confusion


Recommended Posts

Hi all,

I have question concerning the database structure. When looking at the pdf database diagram that comes with oscommerce-2.2ms2-051113. There are refferences to foreign keys. However when I export a table with phpMyadmin the tables are set to myisam engine and there are no foreign keys, hence my confusion. the site is hosted on siteground. The reason I am curious about this is I wanted to create a couple of new tables that have cascade update and cascade delete associated with them. My question is are there actual foreign keys and my export from phpmyadmin is incorrect somehow or is the diagram just a theoretical way of how the database functions and all of the refferences are done through php.


btw incase you have not already figured it out i am a novice with both php and SQL.



Link to comment
Share on other sites


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

  • Create New...