Manual:Database layout

From MediaWiki.org
Jump to navigation Jump to search
Translate this page
Other languages:
Bahasa Indonesia • ‎Deutsch • ‎English • ‎Nederlands • ‎dansk • ‎español • ‎français • ‎italiano • ‎lietuvių • ‎polski • ‎português • ‎português do Brasil • ‎slovenčina • ‎suomi • ‎русский • ‎українська • ‎العربية • ‎മലയാളം • ‎中文 • ‎日本語 • ‎한국어
Schema redirects here; for information about the Schema: namespace, see Extension:EventLoggingExtension:EventLogging.
Tables redirects here; for information about wikitext table syntax, see Help:TablesHelp:Tables.


↑ Manual:ContentsManual:Contents MediaWiki database layoutManual:Database layout database layout


Database schema diagram of MediaWiki
View database schema →

(file description page)

The SQL code that creates the MySQL/MariaDBManual:MySQL core tables for any MediaWiki version—with extensive comments—is in the maintenance/tables.sql source file. The most important tables are probably pageManual:page table, revisionManual:revision table, textManual:text table and userManual:user table.

Version history[edit]

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.

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 1.22 1.23 1.24 1.25 1.26 1.27 1.28 1.29 1.30 1.31 master
  actorManual:actor table
archiveManual:archive table
  blobsManual:blobs table  
  bot_passwordsManual:bot_passwords table
brokenlinksManual:brokenlinks table  
  categoryManual:category table
  categorylinksManual:categorylinks table
  change_tagManual:change_tag table
  commentManual:comment table
  contentManual:content table
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 1.22 1.23 1.24 1.25 1.26 1.27 1.28 1.29 1.30 1.31 master
  content_modelsManual:content_models table
curManual:cur table  
  externallinksManual:externallinks table
  external_userManual:external_user table
  filearchiveManual:filearchive table
hitcounterManual:hitcounter table  
imageManual:image table
imagelinksManual:imagelinks table
  image_comment_tempManual:image_comment_temp table
interwikiManual:interwiki table
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 1.22 1.23 1.24 1.25 1.26 1.27 1.28 1.29 1.30 1.31 master
  ip_changesManual:ip_changes table  
ipblocksManual:ipblocks table
  ipblocks_old
  iwlinksManual:iwlinks table
  jobManual:job table
  l10n_cacheManual:l10n_cache table
  langlinksManual:langlinks table
linksManual:links table  
linksccManual:linkscc table  
  loggingManual:logging table
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 1.22 1.23 1.24 1.25 1.26 1.27 1.28 1.29 1.30 1.31 master
  log_searchManual:log_search table
mathManual:math table  
  module_depsManual:module_deps table  
  msg_resourceManual:msg_resource table
  msg_resource_linksManual:msg_resource_links table
  objectcacheManual:objectcache table
oldManual:old table  
oldimageManual:oldimage table
  pageManual:page table
  pagelinksManual:pagelinks table
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 1.22 1.23 1.24 1.25 1.26 1.27 1.28 1.29 1.30 1.31 master
  page_propsManual:page_props table
  page_restrictionsManual:page_restrictions table
  protected_titlesManual:protected_titles table
  querycacheManual:querycache table
  querycachetwoManual:querycachetwo table
  querycache_infoManual:querycache_info table
  recentchangesManual:recentchanges table
  redirectManual:redirect table
  revisionManual:revision table
  revision_actor_temp
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 1.22 1.23 1.24 1.25 1.26 1.27 1.28 1.29 1.30 1.31 master
  revision_comment_tempManual:revision_comment_temp table
searchindexManual:searchindex table
  sitesManual:sites table
  site_identifiersManual:site_identifiers table
site_statsManual:site_stats table
  slotsManual:slots table
  slot_rolesManual:slot_roles table
  tag_summaryManual:tag summary table
  templatelinksManual:templatelinks table
  textManual:text table
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 1.22 1.23 1.24 1.25 1.26 1.27 1.28 1.29 1.30 1.31 master
trackbacksManual:trackbacks table  
  transcacheManual:transcache table
  updatelogManual:updatelog table
  uploadstashManual:uploadstash table
userManual:user table
  user_former_groupsManual:user_former_groups table
  user_groupsManual:user_groups table
  user_newtalkManual:user_newtalk table
  user_propertiesManual:user_properties table
user_rightsManual:user_rights table  
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 1.22 1.23 1.24 1.25 1.26 1.27 1.28 1.29 1.30 1.31 master


Database management systems[edit]

See the latest MariaDB/MySQL-compatible version from Git: maintenance/tables.sql.

If using PostgreSQLManual:PostgreSQL, the file maintenance/postgres/tables.sql should be viewed instead.

If using Microsoft SQL Server, see maintenance/mssql/tables.sql.

If using Oracle, see maintenance/oracle/tables.sql.

See also[edit]


Engines
Technical documentation
Configuration
Development
Core tables
actor – archive – bot_passwords – category – categorylinks – change_tag – comment – config – content – content_models – externallinks – filearchive – hitcounter – image – imagelinks – image_comment_temp – interwiki – iwlinks – ipblocks – ip_changes – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – revision_comment_temp – searchindex – sites – site_identifiers – site_stats – slots – slot_roles – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist
Retrieved from "https://www.mediawiki.org/w/index.php?title=Manual:Database_layout&oldid=2892006"