candy wrote:
- Does this mean that the database schema of wikipedia has changed ?
Yes.
- The schema looks really simple ! Is that all in the backend of the
mighty wikipedia ?
:D
- I have observed that under the history tab in wikipedia, we get all
the versions of the current page. And we can select any 2 versions and click on compare to find the changes. Apparently it seems that wikipedia stores all the snapshots of every change in the page(Article). I presume its stored in the recentchanges table. Am I correct in my presumption.
See maintenance/tables.sql for the table definitions, which are liberally commented.
- When does a page or Article enters the wikiarchive table ? I
experimented with my own wiki (running on mediawiki 1.5) and discovered that if I add a new article to the wikipedia, its entry is there in the wikirecentchanges, wikipage and wikirevision tables. But not in wikiarchives table. So when does it enter the latter and under what circumstances?
On deletion, revision data is moved to archive.
-- brion vibber (brion @ pobox.com)