Hi all,
First of all I have my own wiki installed running on mediawiki 1.5. I have the latest current pages database dump in xml format which I imported to the mediawiki using the php import script.
Now before I installed the mediawiki 1.5 I had mediawiki 1.4. I find that the database schema has changed. My observations can be summarized by the following table :
MediaWiki 1.5 (under command "show tables;" in mysql ) N.B I used the prefix "wiki" during installation for the tables.
wikiarchive wikicategorylinks wikihitcounter wikiimage wikiimagelinks wikiinterwiki wikiipblocks wikilogging wikimath wikiobjectcache wikioldimage wikipage wikipagelinks wikiquerycache wikirecentchanges wikirevision wikisearchindex wikisite_stats wikitext wikitrackbacks wikiuser wikiuser_groups wikiuser_newtalk wikivalidate wikiwatchlist
Apart from the above said tables Mediawiki 1.4 also had the tables as listed below.
wikiblobs wikibrokenlinks wikicur wikilinks wikilinkscc wikilogging wikitranscache wikiuser_rights wikivalidate
Having specified the background I have the following questions :
1. Does this mean that the database schema of wikipedia has changed ?
2. The schema looks really simple ! Is that all in the backend of the mighty wikipedia ?
3. 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.
4. 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?
Please clarify these querries. In case you know the answer to some please feel to reply to them.
Thanking you C
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)
wikitech-l@lists.wikimedia.org