One thought that occurred to me was instead of deleting the order so you have no record of it at all, you could use an order status like Canceled for these orders.
Had the same thought drifting off to sleep last night. I agree. The suggestion is more elegant. In adding an 'is_revoked' boolean to the table, I can provide a list of revocations that can be compared against the list compiled by the key vendor for administrative reports.
Cheers,
-devon
Joined: 05/07/2008