Manual:Database layout/zh


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

为任何MediaWiki版本创建$mysql核心表的SQL代码——以及大量注释——可在$tables源文件中找到. 比较重要的表可能是$page、$revision、$text以及$user.

As of 1.35 (and continuing during 1.36), the appropriate file is in the source file, which is then transformed into. In these versions is less relevant, though some tables are still in there that haven't been migrated yet.

The most important tables are probably, , and.

版本历史
The following table depicts the range of MediaWiki versions over which each table has existed in the schema. 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.

数据库管理系统
In MediaWiki master, tables.sql is currently being migrated to, and documenting comments should be found there instead of the resultant sql files.

从Git中查看最新的MariaDB/MySQL兼容版本：,.

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

如果使用$man-postgres，則應改為查看$postgres文件.

如需使用Microsoft SQL Server，请参考$mssql.

如需使用Oracle，请参考$oracle.

参见

 * 数据查询（仅英语）
 * 数据查询（仅英语）
 * 数据查询（仅英语）
 * 数据查询（仅英语）
 * Records of edits in the database
 * A research on MediaWiki DB schema evolution
 * Diagram instructions, documents how to update the diagram