how the wiki site work i mean the sql structure [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 12 years ago.

any one know that开发者_如何学编程 in wiki sites any one can edit the page i want know how i can make this is mysql i want to know the mysql table structure fot that job and how approve edits

---

That's an extremely broad question — almost like asking, "What tables should I have for an e-commerce site?" It depends entirely on what content you want to store.

If you want to know more about a particular wiki implementation (e.g., MediaWiki, which powers Wikipedia), you can simply download and install the application. The actual tables with real data in them will then be right there for you to look through at your leisure.

If you're designing a new wiki application, you'll have to know a lot more about the data involved before you can begin to define a table structure.

In general, though, any time you want to store a history of revisions, you'll need a table representing revisions. Each row in this table stores the text of a revision, and a foreign key connects it to the page (or other object) it's a revision of.

---

You can take a look to the Mediawiki data base schema:

click here for the full size image

---

You can have a table containing pages and a table containing page history (with a PageID foreign key)