Manual:Database layout/de


 * Schema redirects here; for information about the Schema: namespace, see, and for the structure of extension.json, see.

Prior to MediaWiki 1.35, the SQL code that creates the core tables for any MediaWiki version—with extensive comments—is in the  source file.

Since MediaWiki 1.35, the appropriate file is in the source file, which is then transformed into. Up to MediaWiki 1.37 continued to be partially in use as some tables hadn't been migrated to  yet.

The most important tables are probably:



Versionsgeschichte
Die folgende Tabelle zeigt die Bandbreite der MediaWiki-Versionen, über die jede Tabelle im Diagramm existierte. Rote Reihen zeigen Tabellen, die in einer bestimmten Version gelöscht wurden. Beachten Sie, Tabellenüberschriften werden alle 10 Zeilen für Klarheit wiederholt. Red rows indicate tables that are no longer used by the core nor added by the installer as of a particular version. They might however still be used by extensions. Note, table headings are repeated every 10 rows for clarity.

Database management systems
In MediaWiki master, tables.sql is currently being migrated to, and documenting comments should be found there instead of the resultant SQL files.

See the latest MariaDB/MySQL-compatible versions from Git:,.

If using, the file and the unmigrated MySQL tables in  should be viewed instead.

If using, the files and  should be viewed instead.

If using Microsoft SQL Server, see.

If using Oracle, see.

Siehe auch

 * w:Wikipedia:Database queries
 * Records of edits in the database
 * Research on MediaWiki DB schema evolution
 * Diagram instructions, documents how to update the diagram