Notes-up icon indicating copy to clipboard operation
Notes-up copied to clipboard

Database should enforce referential integrity.

Open ChristopherNugent opened this issue 7 years ago • 2 comments

The database should enforce referential integrity using SQLite foreign keys. I don't think it's causing any issues at the moment, but its better design.

If there's no reason not to do this, I can make the fixes.

ChristopherNugent avatar Nov 07 '18 18:11 ChristopherNugent

The only reason why not to do it would be to avoid breaking backwards compatibility. I've avoided upgrading the database since the first time it's been released. If you can do it without breaking anything though, then yeah sure :)

Philip-Scott avatar Nov 07 '18 19:11 Philip-Scott

I'll have some free time over Thanksgiving break.

ChristopherNugent avatar Nov 13 '18 04:11 ChristopherNugent