I need some opinions on this. I have an order entry system for my customers to use. I store the order details in a mySQL table, and the usual other stuff in various other tables. My question is this:
I need to give my customers a way to edit orders (only before the order is moved into IN PROCESS status, of course), but I want to be able to track and audit changes they make.
I'm thinking I need to create another table, and when an order is edited, update the details table with the changed information, while storing the old and new information in an auditing table, along with timestamp info, the username that made the changes. etc.
Any thoughts or better ideas?
