Manual:Database layout



The current MySQL diagram for any Mediawiki version—with extensive comments—can be found in the maintenance/tables.sql file.

See the latest version from SVN.

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

The most important tables are probably page, revision, pagelinks and text.