http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12555 --- Comment #15 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 34159 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=34159&action=edit [PASSED QA] Bug 12555: Add a FK on aqorders_items.itemnumber The previous patch assumed that deleting an item will delete the entry in aqorders_items. But the FK did not exist. Looking at the code, we never join aqorders_items and deleteditems, so I think we can add this constraint. Before adding this constraint, we need to delete all entries in aqorders_items if the item has already been deleted. Signed-off-by: Paola Rossi <paola.rossi@cineca.it> Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.