Manual:Database layout

From MediaWiki.org
(Redirected from Database layout)
Jump to: navigation, search
Manual:Contents MediaWiki database layout database layout


(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 and text.

Version history[edit | edit source]

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 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 1.22 1.23 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 1.22 1.23 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 1.22 1.23 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 1.22 1.23 master
  recentchanges
  redirect
  revision
searchindex
  sites
site_stats
  tag_summary
  templatelinks
  text
  trackbacks  
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 master
  transcache
  updatelog
  uploadstash
user
  user_former_groups
  user_groups
user_newtalk
  user_properties
  user_rights  
  valid_tag
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 master
  validate  
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 1.22 1.23 master

Database management systems[edit | edit source]

See the latest Maria/MySQL-compatible version from Git: 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 Oracle, see maintenance/oracle/tables.sql.

See also[edit | edit source]

Databases Engines: MySQLOraclePostgreSQLSQLite
Technical documentation: Schema (tables) – API property associationsField prefixesPrimary key storage in other fieldsWikimedia extension tables
Configuration: SettingsSharing
Development: AccessOptimizationPolicyUpdaterExtension schema updatesPatch file
Core tables: archivecategorycategorylinkschange_tagconfigexternallinksfilearchivehitcounterimageimagelinksinterwikiiwlinksipblocksjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionsearchindexsitessite_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiesvalid_tagwatchlist
Language: English  • Deutsch • français • Bahasa Indonesia • 日本語 • polski • slovenčina