View Issue Details

IDProjectCategoryView StatusLast Update
0002356Composrcore_database_driverspublic2016-03-30 13:38
ReporterChris GrahamAssigned To 
Status non-assignedResolutionopen 
Product Version 
Fixed in Version 
Summary0002356: Support referential integrity via foreign key constraints
DescriptionWe have not supported foreign keys because MyISAM has been the main DB engine, and it doesn't support them.

We do have some code to generate the foreign key constraints.

Support applying this if the DB engine supports it, via a major overhaul of our database code.

The constraints would need to be declared within create_table calls rather than in a separate mapping array as is done now. We'd want to remove that mapping array and anything accessing it would query via a new layer that can query the DB structure better.

A lot of code would need cleaning up to delete things in the right order.

There's code to do an InnoDB export of the database schema, for creating entity diagrams. Remove this and make sure the standard DB code can generate this SQL using inbuilt foreign key constraints.
Additional InformationThis may be an absolutely enormous thing to do, and of limited value. But I wanted to get it down here.
TagsNo tags attached.
Attach Tags
Time estimation (hours)100
Sponsorship open


related to 0002796 non-assigned Deprecate MyISAM; use INNODB (on hold) 


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2016-03-30 13:38 Chris Graham New Issue
2017-04-10 17:36 Chris Graham Relationship added related to 0002796