Manual:Database layout

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

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.

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

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

If 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.