Manual:Database layout

The current MySQL diagram for any MediaWiki version—with extensive comments—can be found in the maintenance/tables.sql file. The most important tables are probably page, revision, pagelinks and text.

Database management systems
See the latest MySQL-compatible version from Gerrit: maintenance/tables.sql.

If using Postgres, the file maintenance/postgres/tables.sql should be viewed instead.

Is using Microsoft SQL Server, see maintenance/mssql/tables.sql.

If using IBM DB2, see maintenance/ibm_db2/tables.sql.

If using Oracle, see maintenance/oracle/tables.sql.

Version history
The following table depicts the range of MediaWiki versions over which each table has existed in the schema. Red rows indicate tables that have been dropped in a particular version. Note, table headings are repeated every 10 rows for clarity.