Hi,
Would you mind putting a FK constraint on itemnumber in aqorders_items (with cascaded delete) ?
Please feel free to join the discussion on report http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11617
Thanks,
Marcel