Database field prefixes

Jump to navigation Jump to search
Translate this page; This page contains changes which are not marked for translation.

Other languages:
Deutsch • ‎English • ‎català • ‎dansk • ‎español • ‎italiano • ‎polski • ‎português • ‎português do Brasil • ‎suomi • ‎русский • ‎中文 • ‎日本語


Extension/core Table Field prefix Version Description
CoreManual:database layout archiveManual:Archive table ar_ Stores information on deleted page
blobsManual:Blobs table blob_ 1.4 and earlier Beginning with the MediaWiki 1.5 release this table is not used, and can be safely deleted
brokenlinksManual:brokenlinks table bl_ 1.4 and earlier The brokenlinks table stored links to articles that don't exist yet. Obsolete
categoryManual:category table cat_ 1.13+ Track all existing categories.
categorylinksManual:categorylinks table cl_ 1.3+ The categorylinks table stores entries corresponding to links of the form [[Category:Title|sortkey]] or [[Category:Title|sortkey]], which when placed anywhere on a page places that page into the category named Title (for which an associated page may or may not exist).
change_tagManual:change_tag table ct_ 1.15+ The change_tag table tracks tags for revisions, logs and recent changes.
configManual:config cf_ 1.20+ Table for holding configuration changes.
curManual:cur table cur_ 1.4 and earlier The cur table was used in older versions of MediaWikis to store the current revision of a page.
externallinksManual:externallinks table el_ 1.6+ The externallinks table is where MediaWiki stores and tracks external links.
external_userManual:external_user table eu_ 1.16+ external_user tracks external user accounts, if ExternalAuth is used.
filearchiveManual:filearchive table fa_ 1.7+ The filearchive table stores all the media that has been deleted, similar to the archive table's job for text
hitcounterManual:hitcounter table hc_ 1.3+ The hitcounter table in MediaWiki is a temporary buffer for storage of page view information.
imageManual:image table img_ The image table describes images and other uploaded files.
imagelinksManual:imagelinks table il_ The imagelinks table stores inclusions of files.
interwikiManual:interwiki table iw_ The interwiki table stores the interwiki prefixes with their targets.
iwlinksManual:iwlinks table iwl_ 1.17+ The iwlinks table stores the interwiki links with their targets.
ipblocksManual:ipblocks table ipb_ The ipblocks table stores details of IP addresses and users who have been blocked from editing.
ipblocks_old 1.6 (deprecated)
jobManual:job table job_ 1.6+ Jobs performed by parallel apache threads or a command-line daemon.
l10_cacheManual:l10n_cache table lc_ 1.16+ The l10n_cache table
langlinksManual:langlinks table ll_ 1.7+ langlinks table tracks interlanguage links.
linksManual:links table l_ 1.4 and earlier (deprecated)
linksccManual:linkscc table lcc_ 1.4 and earlier The linkscc table cached link data for rendering.
loggingManual:logging table log_ 1.4+ Every log action in MediaWiki is logged in the logging table.
log_searchManual:log_search table ls_ 1.16+ The log_search table (added in r50567).
mathManual:math table math_ 1.17 and earlier math table is used by the math module to keep track of previously-rendered items.
msg_resourceManual:msg_resource table mr_ 1.17+ msg_resource caching JSON message blobs for the resource loader.
msg_resource_linksManual:msg_resource_links table mrl_ 1.17+ The msg_resource_links table is for administering which message is contained in which resource.
module_depsManual:module_deps table md_ 1.17+ module_deps table is for caching which local files a module depends on that aren't registered directly.
objectcacheManual:objectcache table N/A 1.3+ Objectcache table is used for a few generic cache operations if not using Memcached.
oldManual:old table old_ 1.4 and earlier The old table is where MediaWiki versions up to MediaWiki 1.4 store historical versions of articles; these MediaWiki versions store the current version of articles in the cur table.
oldimageManual:oldimage table oi_ This table holds information about old revisions of files.
pageManual:page table page_ 1.5+ Each page in a MediaWiki installation has an entry here which identifies it by title and contains some essential metadata.
pagelinksManual:pagelinks table pl_ 1.5+ Tracks all internal links in the Wiki.
page_propsManual:page_props table pp_ 1.13+ Contains properties about pages set by the parser via ParserOutput::setProperty(), such as the display title and the default category sortkey.
page_restrictionsManual:page_restrictions table pr_ 1.10+ The page_restrictions table is used to store page protection levels in MediaWiki 1.10 and later.
protected_titlesManual:protected_titles table pt_ 1.12+ Contains protection of non-existent pages, the list of protected pages can be found at Special:Protectedtitles.
querycacheManual:querycache table qc_ 1.3+ The querycache table is used for caching expensive grouped queries.
querycachetwoManual:querycachetwo table qcc_ 1.9+ querycachetwo is a table used for caching expensive grouped queries that need two links (for example double-redirects).
querycache_infoManual:querycache_info table qci_ 1.7+ querycache_info table contains details of updates to cached special pages.
recentchangesManual:recentchanges table rc_ 1.5+ The recentchanges table contains information about the latest modifications done to the wiki (not older than $wgRCMaxAge; see also below).
redirectManual:redirect table rd_ 1.9+ Contains for each page that is currently a redirect (i.e., not for old revisions which are redirects) the id of the source page and the information about target.
revisionManual:revision table rev_ 1.5+ The revision table holds metadata for every edit done to a page within the wiki.
searchindexManual:searchindex table si_ The searchindex table is used to provide full text searches.
sitesManual:sites table site_ 1.21+
site_statesManual:site_stats table ss_ The site_stats table contains a single row with some aggregate info on the state of the site.
tag_summaryManual:tag_summary table ts_ 1.15+ The tag_summary is used to pull a LIST of tags simply without ugly GROUP_CONCAT that only works on MySQL 4.1+.
templatelinksManual:templatelinks table tl_ 1.6+ Contains for each current page inclusion the id of the host page, the namespace number of the included page, and its title without namespace.
textManual:text table old_ 1.5+ The text table holds the wikitext of individual page revisions.
trackbacksManual:trackbacks table tb_ 1.5-1.18 Stores trackback requests.
transcacheManual:transcache table tc_ 1.5+ The transcache table is used to cache content that has been transcluded from other MediaWiki installations.
updatelogManual:updatelog table ul_ 1.13+ A table to log updates, one text key row per update.
uploadstashManual:uploadstash table us_ 1.18+ The uploadstash table stores information about newly uploaded files before they're moved into the actual filestore.
userManual:user table user_ The user table is where MediaWiki stores information about users.
user_former_groupsManual:user_former_groups table ufg_ 1.18+ Stores the groups the user has once belonged to (will not contain groups the user had belonged to before MW 1.17).
user_groupsManual:user_groups table ug_ 1.5+ The user groups table maps the users in a particular MediaWiki installation to their corresponding user rights.
user_newtalkManual:user_newtalk table user_ user_newtalk table stores notifications of user talk page changes, for the display of the "you have new messages" box.
user_propertiesManual:user_properties table up_ 1.16+ The user_properties table stores user preferences.
user_rightsManual:user_rights table ur_ 1.4 (deprecated)
valid_tagManual:valid_tag table vt_ 1.15+ The valid_tag contains a list of defined tags, to be used by Special:Tags.
validateManual:validate table val_ 1.4-1.6 (deprecated)
watchlistManual:watchlist table wl_ The watchlist table contains for each registered user his or her id and for all the pages the user watches, the namespace number, the page title without namespace, and a notification timestamp, used for page change notification.
Advanced MetaExtension:Advanced Meta ext_meta N/A Allows per page editing of various meta tags for SEO reasons
AntiSpoofExtension:AntiSpoof spoofuserExtension:AntiSpoof/spoofuser table su_
ChatExtension:Chat chathistoryExtension:Chat/chathistory table N/A
CheckUserExtension:CheckUser cu_changesExtension:CheckUser/cu_changes table cuc_
cu_logExtension:CheckUser/cu_log table cul_
CodeReviewExtension:CodeReview code_authorsExtension:CodeReview/code_authors table ca_
code_bugsExtension:CodeReview/code_bugs table cb_
code_commentExtension:CodeReview/code_comment table cc_
code_pathsExtension:CodeReview/code_paths table cp_
code_prop_changesExtension:CodeReview/code_prop_changes table cpc_
code_relationsExtension:CodeReview/code_relations table cf_
code repoExtension:CodeReview/code_repo table repo_
code revExtension:CodeReview/code_rev table cr_
code_signoffsExtension:CodeReview/code_signoffs table cs_
code tagsExtension:CodeReview/code_tags table ct_
DataTable2Extension:DataTable2 datatable2_dataExtension:DataTable2/datatable2_data table dtd_
datatable2_metaExtension:DataTable2/datatable2_meta table dtm_
EnhancedAutopromoteExtension:EnhancedAutopromote enh_autopromoteExtension:EnhancedAutopromote/enh_autopromote table eha_
InterwikiExistenceExtension:InterwikiExistence iwe_pageExtension:InterwikiExistence/iwe_page table iwe_page_ This extension causes interwiki links, e.g. wikipedia:foo, to become existence detecting.
MathExtension:Math mathExtension:Math/math table math_
MathSearchExtension:MathSearch mathindexExtension:MathSearch/mathindex mathindex_
mathsearchExtension:MathSearch/mathsearch table N/A
RPEDExtension:RPED rped_pageExtension:RPED/rped_page table rped_page_ List of pages present on the remote wiki
SacredTextExtension:SacredText sacredtext_versesExtension:SacredText/sacredtext_verses table st_
SecurePasswordsExtension:SecurePasswords password_historyExtension:SecurePasswords/password_history table ph_
securepasswords_uninstallExtension:SecurePasswords/securepasswords_uninstall table su_