<p>I'm looking at building basic CMS functionality into our web product and am researching tips and design ideas for versioning content. I'm specifically looking for database schemas in use today.</p>

<p>What are you using for content versioning? What patterns apply if you have different types of content that need versions stored? How is question versioning handled on Stack Overflow?</p>

<p>Thanks</p>

My gut instinct is that the best thing for this is (in order of bestitude):
A ready version control system.
A nice list here.
Storing diffs.
What is a diff here.
I guess the obvious database solution of having a "ContentVersion" table, where you have multiple "Versions" per unique "Content".