title: Store all data changes with every details (like Stackoverflow)
body: <p>I have system written using Codeigniter and as a database using MySQL. System have user, usergroups with different privileges and etc. Have lots of mysql tables which have many to many relationships. </p>
  
  <p>Some of the tables I have:</p>
  
  <ul>
  <li>items</li>
  <li>contracts</li>
  <li>customers</li>
  <li>products</li>
  <li>product_features</li>
  <li>orders</li>
  <li>order_features</li>
  <li>order_products</li>
  <li>etc...</li>
  </ul>
  
  <p>Currently I am logging every change on data for these tables which made by users. Users can change these datas due to their privilege. Storing change of logs only simple form like</p>
  
  <pre><code>A user changed product features with id of A8767
  B user added new customer with id 56
  C user edited content of orderlist
  A user added new product (id: A8767) to order (id: or67)
  ...
  </code></pre>
  
  <p>I want keep all changes which made with every detail, like edit history of question Stackoverflow. I can think about <code>log_table</code> design to keep all data changes from various tables. Is there any way, tutorial, engine , plugin to do that ? Only i can think make duplicate of every table and keep storing changes on them, but i dont think its good way.</p>