Translations:Manual:Database layout/1/en

The SQL code that creates the $mysql core tables for any MediaWiki version—with extensive comments—is in the $tables source file. The most important tables are probably $page, $revision, $text and $user.