How to structure a database for a wiki site


What's does the table look like- is there only one? How do you revert to older versions? Similar to how Stack overflow works.

Best Solution

The best way to go about this is to look at other software such as MediaWiki and see how they structure their database. Then you can pick and choose what you want to use to start off on your own wiki design.

On the other hand, you could always start off with a pretty basic spread of tables that would keep track of Users, Articles, Revisions on an Article, etc. and start spiraling out from there.