macinville Posted October 25, 2012 Share Posted October 25, 2012 Is there a reason why the database structure of PrestaShop does not have any foreign key constraint defined? If I am going to add new tables, will there be any disadvantage if I create relationships between tables? Link to comment Share on other sites More sharing options...
tuk66 Posted October 28, 2012 Share Posted October 28, 2012 Don't do it! Data is not in perfect condition and many relations between records are broken in real shop. Link to comment Share on other sites More sharing options...
tomboul Posted September 26, 2014 Share Posted September 26, 2014 Hello, If i look via Msyql Workbench the mwb file of the database structure of prestahsop, i can see relational schema. But if y look the same structure of database on phpmyadmin there is no foreign key cosntraint defined. I begin a new prestashop website and my base is completly empty, So why prestashop doesnt define any foreign key constraint ? this will cause many broken relation between records and innodb engine will be inefficient. 1 Link to comment Share on other sites More sharing options...
Recommended Posts