http://www.lensovet.net/~sysadmin/w/index.php?action=history&feed=atom&title=Help%3ADatabase_layout 2026-05-05T10:19:18Z Revision history for this page on the wiki MediaWiki 1.31.16 http://www.lensovet.net/~sysadmin/w/index.php?title=Help:Database_layout&diff=1492&oldid=prev 2006-07-19T05:34:23Z

<p>1 revision(s)</p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr class="diff-title" lang="en"> <td colspan="1" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td> <td colspan="1" style="background-color: #fff; color: #222; text-align: center;">Revision as of 05:34, 19 July 2006</td> </tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div> </td></tr></table>

Wadmin http://www.lensovet.net/~sysadmin/w/index.php?title=Help:Database_layout&diff=1491&oldid=prev 2006-07-18T06:56:13Z

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

130.75.87.146