Database field prefixes

Jump to: navigation, search

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

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 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 Meta ext_meta N/A Allows per page editing of various meta tags for SEO reasons
AntiSpoof spoofuserExtension:AntiSpoof/spoofuser table su_
Chat chathistoryExtension:Chat/chathistory table N/A
CheckUser cu_changesExtension:CheckUser/cu_changes table cuc_
cu_logExtension:CheckUser/cu_log table cul_
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_
DataTable2 datatable2_dataExtension:DataTable2/datatable2_data table dtd_
datatable2_metaExtension:DataTable2/datatable2_meta table dtm_
EnhancedAutopromote enh_autopromoteExtension:EnhancedAutopromote/enh_autopromote table eha_
InterwikiExistence iwe_pageExtension:InterwikiExistence/iwe_page table iwe_page_ This extension causes interwiki links, e.g. wikipedia:foo, to become existence detecting.
Math mathExtension:Math/math table math_
MathSearch mathindexExtension:MathSearch/mathindex mathindex_
mathsearchExtension:MathSearch/mathsearch table N/A
RPED rped_pageExtension:RPED/rped_page table rped_page_ List of pages present on the remote wiki
SacredText sacredtext_versesExtension:SacredText/sacredtext_verses table st_
SecurePasswords password_historyExtension:SecurePasswords/password_history table ph_
securepasswords_uninstallExtension:SecurePasswords/securepasswords_uninstall table su_
DatabasesManual:Database layout Engines: MySQL/MariaDBManual:MySQLOracleManual:OraclePostgreSQLManual:PostgreSQLSQLiteManual:SQLiteSQL ServerManual:Microsoft SQL Server

Technical documentation: SchemaManual:Database layout (tablesCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associationsField prefixesDatabase field prefixesPrimary key storage in other fieldsManual:Primary key storage in other fieldsWikimedia extension tablesCategory:Wikimedia extension database tables
Configuration: SettingsManual:Configuration_settings#Database_settingsSharingManual:Shared database
Development: AccessManual:Database accessOptimizationDatabase optimizationPolicyDevelopment policy#Database_patchesUpdaterManual:DatabaseUpdater.phpExtension schema updatesManual:Hooks/LoadExtensionSchemaUpdatesPatch fileManual:SQL patch file

Core tables: archivebot_passwordscategorycategorylinkschange_tagconfigexternallinksfilearchivehitcounterimageimagelinksinterwikiiwlinksipblocksjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionsearchindexsitessite_identifiers - site_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiestag_summaryvalid_tagwatchlist