Manual:database layout

↑ Manual:Contents

MediaWiki database layout

database layout

View database schema →

(file description page)

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.

1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	master
archive
	blobs
brokenlinks
											category
	categorylinks
													change_tag
																		config
cur
				externallinks
														external_user
1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	master
					filearchive
hitcounter
image
imagelinks
interwiki
															iwlinks
ipblocks
				ipblocks_old
				job
														l10n_cache
1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	master
					langlinks
links
linkscc
		logging
														log_search
math
															msg_resource
															msg_resource_links
															module_deps
	objectcache
1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	master
old
oldimage
			page
			pagelinks
											page_props
								page_restrictions
										protected_titles
	querycache
							querycachetwo
					querycache_info
1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	master
			recentchanges
							redirect
			revision
searchindex
site_stats
													tag_summary
				templatelinks
			text
			trackbacks
			transcache
1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	master
											updatelog
																uploadstash
user
																user_former_groups
			user_groups
user_newtalk
														user_properties
		user_rights
													valid_tag
		validate
1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	master
watchlist
1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	master

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.

See also

• Manual:Database access
• Proposed Database Schema Changes
• Database table and field registration
• w:Wikipedia:Database queries
• nl:Wikipedia:SQL-opdrachten
• Developer hub
• Records of edits in the database
• A research on MediaWiki DB schema evolution

Databases	Engines: MySQL – Oracle – PostgreSQL – SQLite – IBM DB2 Technical documentation: Schema (tables) – Access