Best Way to Implement a Versioning System for User Edited Content

I have a requirement to let users edit each others entries. So in case of bad entries, I need to be able to go ba开发者_如何学运维ck to an earlier version.

What is the best way to implement this in the data layer? Should I have like a triage table? And once the admin approves the edit, the triage version gets copied and put into the main entries table?

How would you guys do this?

Thanks, Alex

This answer may work for you.

Rolling Your Own Plaintext Wiki (Wiki inside a DB)

I know you're thinking in terms of a database, but you may want to look in to using Mercurial or Git as the back-end to your application. It won't work like a database, but you'll have full version control.