Database field prefixes

Jump to navigation Jump to search
Other languages:
English • ‎dansk • ‎español • ‎français • ‎polski • ‎русский • ‎中文 • ‎日本語

This is a list of database tables and field prefixes added by various extensions. Registering your tables and field prefixes here helps other developers to avoid name collisions when they create their own tables and fields.

Extension/core Table Field prefix Version Description
Core actor actor_ 1.31+
archive ar_ Stores information on deleted page
blobs blob_ 1.3-1.4 Beginning with the MediaWiki 1.5 release this table is not used, and can be safely deleted
brokenlinks bl_ 1.4 and earlier The brokenlinks table stored links to articles that don't exist yet. Obsolete
bot_passwords bp_ 1.27+
category cat_ 1.13+ Track all existing categories.
categorylinks cl_ 1.3+ The categorylinks table stores entries corresponding to links of the form [[Category:Title]] 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_tag ct_ 1.15+ The change_tag table tracks tags for revisions, logs and recent changes.
change_tag_def ctd_ 1.32+
comment comment_ 1.30+
config cf_ 1.20+ Table for holding configuration changes.
content content_ 1.31+
content_models model_ 1.31+
cur cur_ 1.4 and earlier The cur table was used in older versions of MediaWikis to store the current revision of a page.
externallinks el_ 1.6+ The externallinks table is where MediaWiki stores and tracks external links.
external_user eu_ 1.16-1.21 external_user tracks external user accounts, if ExternalAuth is used.
filearchive fa_ 1.7+ The filearchive table stores all the media that has been deleted, similar to the archive table's job for text
hitcounter hc_ 1.2-1.24 The hitcounter table in MediaWiki is a temporary buffer for storage of page view information.
image img_ The image table describes images and other uploaded files.
imagelinks il_ The imagelinks table stores inclusions of files.
image_comment_temp imgcomment_ 1.30-1.31
interwiki iw_ The interwiki table stores the interwiki prefixes with their targets.
iwlinks iwl_ 1.17+ The iwlinks table stores the interwiki links with their targets.
ip_changes ipc_ 1.30+
ipblocks ipb_ The ipblocks table stores details of IP addresses and users who have been blocked from editing.
ipblocks_old 1.6 (deprecated)
ipblocks_restrictions ir_ 1.32+
job job_ 1.6+ Jobs performed by parallel apache threads or a command-line daemon.
l10_cache lc_ 1.16+ The l10n_cache table
langlinks ll_ 1.7+ langlinks table tracks interlanguage links.
links l_ 1.4 and earlier (removed in 1.4)
linkscc lcc_ 1.4 and earlier The linkscc table cached link data for rendering.
logging log_ 1.4+ Every log action in MediaWiki is logged in the logging table.
log_search ls_ 1.16+ The log_search table (added in r50567).
math math_ 1.17 and earlier math table is used by the math module to keep track of previously-rendered items.
msg_resource mr_ 1.17-1.26 msg_resource caching JSON message blobs for the resource loader.
msg_resource_links mrl_ 1.17-1.26 The msg_resource_links table is for administering which message is contained in which resource.
module_deps md_ 1.17+ module_deps table is for caching which local files a module depends on that aren't registered directly.
objectcache N/A 1.3+ Objectcache table is used for a few generic cache operations if not using Memcached.
old 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.
oldimage oi_ This table holds information about old revisions of files.
page page_ 1.5+ Each page in a MediaWiki installation has an entry here which identifies it by title and contains some essential metadata.
pagelinks pl_ 1.5+ Tracks all internal links in the Wiki.
page_props 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_restrictions pr_ 1.10+ The page_restrictions table is used to store page protection levels in MediaWiki 1.10 and later.
protected_titles pt_ 1.12+ Contains protection of non-existent pages, the list of protected pages can be found at Special:Protectedtitles.
querycache qc_ 1.3+ The querycache table is used for caching expensive grouped queries.
querycachetwo qcc_ 1.9+ querycachetwo is a table used for caching expensive grouped queries that need two links (for example double-redirects).
querycache_info qci_ 1.7+ querycache_info table contains details of updates to cached special pages.
recentchanges rc_ The recentchanges table contains information about the latest modifications done to the wiki (not older than $wgRCMaxAge; see also below).
redirect 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.
revision rev_ 1.5+ The revision table holds metadata for every edit done to a page within the wiki.
revision_actor_temp revactor_ 1.31+
revision_comment_temp revcomment_ 1.30+
searchindex si_ The searchindex table is used to provide full text searches.
site_identifiers si_ 1.21+
sites site_ 1.21+
site_stats ss_ The site_stats table contains a single row with some aggregate info on the state of the site.
slot_roles role_ 1.31+
slots slot_ 1.31+
tag_summary ts_ 1.15-1.32 The tag_summary is used to pull a LIST of tags simply without ugly GROUP_CONCAT that only works on MySQL 4.1+.
templatelinks 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.
text old_ 1.5+ The text table holds the wikitext of individual page revisions.
trackbacks tb_


Stores trackback requests.
transcache tc_ 1.5-1.31 The transcache table is used to cache content that has been transcluded from other MediaWiki installations.
updatelog ul_ 1.13+ A table to log updates, one text key row per update.
uploadstash us_ 1.18+ The uploadstash table stores information about newly uploaded files before they're moved into the actual filestore.
user user_ The user table is where MediaWiki stores information about users.
user_former_groups 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_groups ug_ 1.5+ The user_groups table maps the users in a particular MediaWiki installation to their corresponding user rights.
user_newtalk user_ user_newtalk table stores notifications of user talk page changes, for the display of the "you have new messages" box.
user_properties up_ 1.16+ The user_properties table stores user preferences.
user_rights ur_ 1.4 (removed in 1.5)
valid_tag vt_ 1.15+ The valid_tag contains a list of defined tags, to be used by Special:Tags.
validate val_ 1.4-1.6 (removed in 1.7)
watchlist wl_ The watchlist table contains for each registered user their 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 Meta ext_meta N/A Allows per page editing of various meta tags for SEO reasons
AntiSpoof spoofuser su_
Chat chathistory N/A
CheckUser cu_changes cuc_
cu_log cul_
CodeReview code_authors ca_
code_bugs cb_
code_comment cc_
code_paths cp_
code_prop_changes cpc_
code_relations cf_
code repo repo_
code rev cr_
code_signoffs cs_
code tags ct_
DataTable2 datatable2_data dtd_
datatable2_meta dtm_
EnhancedAutopromote enh_autopromote eha_
InterwikiExistence iwe_page iwe_page_ This extension causes interwiki links, e.g. wikipedia:foo, to become existence detecting.
Math math math_
MathSearch mathindex mathindex_
mathsearch N/A
RPED rped_page rped_page_ List of pages present on the remote wiki
SacredText sacredtext_verses st_
SecurePasswords password_history ph_
securepasswords_uninstall su_
WikibaseQualityConstraints wbqc_constraints constraint_ Describes how properties should and shouldn’t be used. Imported from statements on Wikibase properties via a job.