Hello community,
I have some questions about OpenCart's database integrity. Having installed the latest 3.x version, which I am studying, I've seen that the database engine is ISAM. I have seen that some developers offer automatic migration from the ISAM engine towards the InnoDb engine through their plugin\extension's automation. I have looked at the CDM (Conceptual Data Model) of the OpenCart 3.x tables: it seems easy to understand the homonymous primary keys ←→ foreign key relationships. It should be therefore easy (with PhpMyadmin) to create 1←→+\master←→details\1←→∞ relationships, relationships between the different tables in order to specify the detail\+\∞\infinity records, so that UPDATE SQL statements update, DELETE SQL statement delete, etc (by the InnoDb engine itself, on the server side, no matter if it's already coded with PHP, or not).
Nevertheless, my questions are:
• Have some people already created these referential integrity relationships (under InnoDb engine) like “ADD CONSTRAINT ... FOREIGN KEY ... REFERENCES ... ON DELETE CASCADE...” and if so, does the OpenCart's core correctly continue to interpret its specifications (I am inclined to think so, but I do not know for sure)?
• I have found no extension doing that, that creates referential integrity relationships with SQL. Have I searched incorrectly?
• If there is no extension that does this, would this kind of improvement (deleting orphaned records, updating foreign keys, on the SQL server engine side) written in as an extension be of interest to some people, or is it something useless (even futile, perhaps)?
Best regards.
Who is online
Users browsing this forum: No registered users and 3 guests
