Changes
no edit summary
{{MoveToMediaWiki}}
{{H:h|system admin toc}}
<- [[MediaWiki architecture]]
Most data for the wiki is stored in a database. See [[MySQL config]] for setup info.
(Some data lives only in the [[MediaWiki file usage|filesystem]], other data is just cached there. Data may also be cached in [[memcached]], but lives permanently in the database.)
'''NB: the current schema for any version - with copious comments - can be found in the <tt>maintenance/tables.sql</tt> file. The latest version can be obtained [http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/maintenance/tables.sql?view=markup from SVN].'''
Version 1.6 uses the following tables:
*[[archive table]]
*[[categorylinks table]]
*[[externallinks table]]
*[[hitcounter table]]
*[[image table]]
*[[imagelinks table]]
*[[interwiki table]]
*[[ipblocks table]]
*[[job table]]
*[[logging table]]
*[[math table]]
*[[objectcache table]]
*[[oldimage table]]
*[[page table]]
*[[pagelinks table]]
*[[querycache table]]
*[[recentchanges table]]
*[[revision table]]
*[[searchindex table]]
*[[site_stats table]]
*[[templatelinks table]]
*[[text table]]
*[[trackbacks table]]
*[[user table]]
*[[user_groups table]]
*[[user_newtalk table]]
*[[validate table]]
*[[watchlist table]]
Version 1.5 uses the following tables:
*[[archive table]]
*[[categorylinks table]]
*[[hitcounter table]]
*[[image table]]
*[[imagelinks table]]
*[[interwiki table]]
*[[ipblocks table]]
*[[logging table]]
*[[math table]]
*[[objectcache table]]
*[[oldimage table]]
*[[page table]]
*[[pagelinks table]]
*[[querycache table]]
*[[recentchanges table]]
*[[revision table]]
*[[searchindex table]]
*[[site_stats table]]
*[[text table]]
*[[trackbacks table]]
*[[user table]]
*[[user_groups table]]
*[[user_newtalk table]]
*[[validate table]]
*[[watchlist table]]
Version 1.4 uses the following tables:
*[[archive table]] - "deleted" pages
*[[blobs table]]
*[[brokenlinks table]] - links in internal link style to non-existing pages in the same project (see below)
*[[categorylinks table]]
*[[cur table]] - current pages
*[[hitcounter table]]
*[[image table]]
*[[imagelinks table]] tracks usage of images in wikipages (see below)
*[[interwiki table]]
*[[ipblocks table]]
*[[links table]] - links in internal link style to existing pages in the same project (see below)
*[[linkscc table]] - (see below)
*[[math table]]
*[[objectcache table]]
*[[old table]] - old versions of pages
*[[oldimage table]]
*[[querycache table]]
*[[recentchanges table]]
*[[searchindex table]]
*[[site_stats table]]
*[[testac table]]
*[[text table]]
*[[user table]]
*[[user_newtalk table]]
*[[watchlist table]]
==Explanation of the link tables==
There are presently three link tables: ''links'', ''brokenlinks'' and ''imagelinks''. There are a couple of uses for these tables:
* enables "What links here" and "Related changes" to work, looking at incoming or outgoing links
* provides the list of pages that use an image shown on an image's description page
* allows making reports of pages that aren't linked (Orphans, Unused images) or are linked to but don't exist (Most wanted pages)
* slightly speed up page rendering by avoiding individual checks for the existence of each linked page to determine how to render its link
The latest software also adds a 'linkscc' table which caches data from the other three tables. This is used only for speeding rendering.
=== Maintenance of link tables ===
If you import data to the cur table and don't [[rebuild link tables|rebuild the links]], you
won't be able to use "[[What links here]]", "[[Related changes]]", "[[Orphans]]",
etc. If you don't want to, well I suppose that's okay... (Brion Vibber)
== [[:en:Entity-relationship model|ERD]] Diagram ==
This is an overview of the mediawiki database 1.6.X version.
<center>
[[Image:Mediawiki.jpg]]
</center>
This is the diagram from the mediawiki database 1.4.X version.
<center>
[[Image:DER Mediawiki.PNG]]
</center>
It shows the main tables and relations from the database.
==See also==
*[[Experimental new database schema]] ''22:55, 24 Jul 2003''
*[[Proposed Database Schema Changes]] ''18:19, 23 Dec 2003''
*[[en:Wikipedia:Database queries]]
*[[nl:Wikipedia:SQL opdrachten]]
*[[Documentation: Developer's Guide]]
Next page: [[MediaWiki User's Guide: Installation| Installation]] >
[[Category:MediaWiki Development]]
[[Category:MediaWiki database tables|*]]
{{H:h|system admin toc}}
<- [[MediaWiki architecture]]
Most data for the wiki is stored in a database. See [[MySQL config]] for setup info.
(Some data lives only in the [[MediaWiki file usage|filesystem]], other data is just cached there. Data may also be cached in [[memcached]], but lives permanently in the database.)
'''NB: the current schema for any version - with copious comments - can be found in the <tt>maintenance/tables.sql</tt> file. The latest version can be obtained [http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/maintenance/tables.sql?view=markup from SVN].'''
Version 1.6 uses the following tables:
*[[archive table]]
*[[categorylinks table]]
*[[externallinks table]]
*[[hitcounter table]]
*[[image table]]
*[[imagelinks table]]
*[[interwiki table]]
*[[ipblocks table]]
*[[job table]]
*[[logging table]]
*[[math table]]
*[[objectcache table]]
*[[oldimage table]]
*[[page table]]
*[[pagelinks table]]
*[[querycache table]]
*[[recentchanges table]]
*[[revision table]]
*[[searchindex table]]
*[[site_stats table]]
*[[templatelinks table]]
*[[text table]]
*[[trackbacks table]]
*[[user table]]
*[[user_groups table]]
*[[user_newtalk table]]
*[[validate table]]
*[[watchlist table]]
Version 1.5 uses the following tables:
*[[archive table]]
*[[categorylinks table]]
*[[hitcounter table]]
*[[image table]]
*[[imagelinks table]]
*[[interwiki table]]
*[[ipblocks table]]
*[[logging table]]
*[[math table]]
*[[objectcache table]]
*[[oldimage table]]
*[[page table]]
*[[pagelinks table]]
*[[querycache table]]
*[[recentchanges table]]
*[[revision table]]
*[[searchindex table]]
*[[site_stats table]]
*[[text table]]
*[[trackbacks table]]
*[[user table]]
*[[user_groups table]]
*[[user_newtalk table]]
*[[validate table]]
*[[watchlist table]]
Version 1.4 uses the following tables:
*[[archive table]] - "deleted" pages
*[[blobs table]]
*[[brokenlinks table]] - links in internal link style to non-existing pages in the same project (see below)
*[[categorylinks table]]
*[[cur table]] - current pages
*[[hitcounter table]]
*[[image table]]
*[[imagelinks table]] tracks usage of images in wikipages (see below)
*[[interwiki table]]
*[[ipblocks table]]
*[[links table]] - links in internal link style to existing pages in the same project (see below)
*[[linkscc table]] - (see below)
*[[math table]]
*[[objectcache table]]
*[[old table]] - old versions of pages
*[[oldimage table]]
*[[querycache table]]
*[[recentchanges table]]
*[[searchindex table]]
*[[site_stats table]]
*[[testac table]]
*[[text table]]
*[[user table]]
*[[user_newtalk table]]
*[[watchlist table]]
==Explanation of the link tables==
There are presently three link tables: ''links'', ''brokenlinks'' and ''imagelinks''. There are a couple of uses for these tables:
* enables "What links here" and "Related changes" to work, looking at incoming or outgoing links
* provides the list of pages that use an image shown on an image's description page
* allows making reports of pages that aren't linked (Orphans, Unused images) or are linked to but don't exist (Most wanted pages)
* slightly speed up page rendering by avoiding individual checks for the existence of each linked page to determine how to render its link
The latest software also adds a 'linkscc' table which caches data from the other three tables. This is used only for speeding rendering.
=== Maintenance of link tables ===
If you import data to the cur table and don't [[rebuild link tables|rebuild the links]], you
won't be able to use "[[What links here]]", "[[Related changes]]", "[[Orphans]]",
etc. If you don't want to, well I suppose that's okay... (Brion Vibber)
== [[:en:Entity-relationship model|ERD]] Diagram ==
This is an overview of the mediawiki database 1.6.X version.
<center>
[[Image:Mediawiki.jpg]]
</center>
This is the diagram from the mediawiki database 1.4.X version.
<center>
[[Image:DER Mediawiki.PNG]]
</center>
It shows the main tables and relations from the database.
==See also==
*[[Experimental new database schema]] ''22:55, 24 Jul 2003''
*[[Proposed Database Schema Changes]] ''18:19, 23 Dec 2003''
*[[en:Wikipedia:Database queries]]
*[[nl:Wikipedia:SQL opdrachten]]
*[[Documentation: Developer's Guide]]
Next page: [[MediaWiki User's Guide: Installation| Installation]] >
[[Category:MediaWiki Development]]
[[Category:MediaWiki database tables|*]]