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 file.

See the latest version from SVN: maintenance/tables.sql.

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

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	trunk
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	trunk
					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	trunk
					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	trunk
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	trunk
			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	trunk
											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	trunk
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	trunk

See also

• Manual:Database access
• Proposed Database Schema Changes
• 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