2356: Support referential integrity via foreign key constraints

ID	Project	Category	View Status	Date Submitted	Last Update

2356	Composr	core_database_drivers	public	2016-03-30 13:38	2016-03-30 13:38

Reporter	Chris Graham	Assigned To	Guest
Priority	normal	Severity	feature
Status	new	Resolution	open

Summary	2356: Support referential integrity via foreign key constraints
Description	We 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 Information	This may be an absolutely enormous thing to do, and of limited value. But I wanted to get it down here.
Tags	No tags attached.
Attach Tags	(Separate by ",")

Time estimation (hours)	100
Sponsorship open

Date Added	Member	Amount Sponsored

View Status	Private (for security issues or disclosing of private information; if you submit as a guest, you will not be able to see your submission)
Note
Upload Files Maximum size: 32,768 KiB	Attach files by dragging & dropping, selecting or pasting them.
You are not logged in	You are not logged in. This means you will not get any e-mail notifications. And if you reply, we will not know for sure you are the original poster of the issue.

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 2796