Manual:Database layout

From MediaWiki.org

Jump to: navigation, search
Visual layout of the MediaWiki database schema
Visual layout of the MediaWiki database schema

The current schema for any version - with copious comments - can be found in the maintenance/tables.sql file. See the latest version from SVN. If using Postgres, the file maintenance/postgres/tables.sql should be viewed instead.

1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 1.10 1.11 trunk
archive
  blobs  
brokenlinks  
  categorylinks
cur  
  externallinks
  filearchive
hitcounter
image
imagelinks
1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 1.10 1.11 trunk
interwiki
ipblocks
  job
  langlinks
links  
linkscc  
  logging
math
  objectcache
old  
1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 1.10 1.11 trunk
oldimage
  page
  pagelinks
  page_props
  page_restrictions
  protected_titles
  querycache
  querycache_info
  querycachetwo
recentchanges
1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 1.10 1.11 trunk
  redirect
  revision
searchindex
site_stats
  templatelinks
  text
  trackbacks
  transcache
user
  user_groups
1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 1.10 1.11 trunk
user_newtalk
  validate  
watchlist

[edit] See also

Personal tools