Manual:Database layout/ja

現在のMySQLダイアグラム（豊富な解説付き）は、どのMediaWikiバージョンでも maintenance/tables.sql ソース ファイルにあります. The most important tables are probably page, revision, pagelinks and text.

バージョン履歴
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.

データベース管理システム
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.

関連項目

 * Manual:Database access/ja
 * Proposed Database Schema Changes
 * Database table and field registration
 * ja:Wikipedia:データーベースクエリ
 * nl:Wikipedia:SQL-opdrachten
 * Developer hub/ja
 * Records of edits in the database
 * A research on MediaWiki DB schema evolution