Build a revisioning system for orders

[generalludd]

This is a future project.

Need a table called orders_revisions that is identical to orders with the difference that the orders.id = orders_revisions.order_id and the order_revisions table will have its own auto-increment id.
Anytime an order is altered, a copy is first made to the revision table with a timestamp.

On the interface, there should be a button on each order row that allows users to view revisions.
The orders revisions table will show a list of all revisions for the order
Users could select a revision to recover or it may just show the values so they can add them back to the order as needed.

There should be a purging function to delete all revisions either at the end of a sale year or after so many months.