Database consistency

[iGoliath]

Tables that rely on the attribute of an item (Like barcode or item_id) need to be updated when an item is deleted. I.e., saleitems table with a barcode of 1234 will not be able to retrieve the item if it is deleted from the database.