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 block bl_ 1.42+ Blocks against user accounts, IP addresses and IP ranges. block_target bt_ 1.42+ The targets of blocks brokenlinks bl_ 1.4 and earlier Thebrokenlinks 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 ipb_ 1.6 (deprecated) ipblocks_restrictions ir_ 1.32+ job job_ 1.6+ Jobs performed by parallel apache threads or a command-line daemon. l10n_cache lc_ 1.16+ The l10n_cache table langlinks ll_ 1.7+ langlinks table tracks interlanguage links. linktarget lt_ 1.38+ Holds immutable records of link targets, used mostly for links tables. 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-1.38 revision_comment_temp revcomment_ 1.30-1.40 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_ 1.5-1.18 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. watchlist_expiry we_ 1.35+ AbuseFilter abuse_filter_action afa_ abuse_filter_history afh_ abuse_filter_log afl_ abuse_filter af_ AdvancedMeta ext_meta N/A Allows per page editing of various meta tags for SEO reasons AntiSpoof spoofuser su_ ArticleRatings ratings ratings_ AuthManagerOAuth authmanageroauth_linked_accounts amoa_ Babel babel babel_ BetaFeatures betafeatures_user_counts N/A BounceHandler bounce_records br_ CampaignEvents campaign_events event_ ce_participants cep_ ce_organizers ceo_ ce_address cea_ ce_event_address ceea_ ce_tracking_tools cett_ Cargo cargo_tables N/A cargo_pages N/A cargo_backlinks cbl_ CentralAuth globalnames gn_ globaluser gu_ global_edit_count gec_ global_group_permissions ggp_ global_group_restrictions ggr_ global_user_autocreate_serial uas_ global_user_groups gug_ localnames ln_ localuser lu_ renameuser_queue rq_ renameuser_status ru_ users_to_rename utr_ wikiset ws_ CentralNotice cn_notices not_ cn_assignments asn_ cn_templates tmp_ cn_notice_languages nl_ cn_notice_projects np_ cn_notice_countries nc_ cn_notice_regions nr_ cn_template_mixins tmxn_ cn_notice_mixins nmxn_ cn_notice_mixin_params nmxnp_ cn_known_devices dev_ cn_template_devices tdev_ cn_known_mobile_carriers mc_ cn_notice_mobile_carriers nmc_ cn_notice_log notlog_ cn_template_log tmplog_ Chat chathistory N/A archived No longer supports recent releases of MediaWiki CheckUser cu_changes cuc_ cu_log_event cule_ cu_private_event cupe_ cu_log cul_ cu_useragent_clienthints uach_ cu_useragent_clienthints_map uachm_ cuci_wiki_map ciwm_ 1.43+ cuci_temp_edit cite_ 1.43+ cuci_user ciu_ 1.43+ CloseWikis closedwikis cw_ CodeReview code_authors ca_ archived code_bugs cb_ archived code_comment cc_ archived code_paths cp_ archived code_prop_changes cpc_ archived code_relations cf_ archived code_repo repo_ archived code_rev cr_ archived code_signoffs cs_ archived code_tags ct_ archived Cognate cognate_pages cgpa_ cognate_sites cgsi_ cognate_titles cgti_ Comments Comments Comment_ Comments_Vote Comment_Vote_ Comments_block cb_ CommentStreams cs_comments cst_c_ cs_replies cst_r_ cs_votes cst_v_ cs_watchlist cst_wl_ ConfirmAccount account_requests acr_ account_credentials acd_ ContentTranslation cx_corpora cxc_ cx_lists cxl_ cx_notification_log cxn_ cx_suggestions cxs_ cx_translations translation_ cx_translators translator_ cx_significant_edits cxse_ cx_section_translations cxsx_ ContributionTracking contribution_tracking N/A contribution_tracking_owa_ref N/A Contributors contributors cn_ CreatedPagesList createdpageslist cpl_ CreateWiki cw_comments cw_ cw_requests cw_ cw_wikis wiki_ CreditsSource revsrc revsrc_ srcwork srcwork_ swauthor swa_ swauthor_links swal_ swsite sws_ swsource_links swsl_ DataDump data_dump dumps_ DataTable2 datatable2_data dtd_ datatable2_meta dtm_ DiscussionTools discussiontools_items it_ discussiontools_item_ids itid_ discussiontools_item_pages itp_ discussiontools_item_revisions itr_ discussiontools_subscription sub_ 1.36+ DownloadBook bookrenderingtask brt_ Echo echo_email_batch eeb_ echo_event event_ echo_notification notification_ echo_push_provider epp_ echo_push_subscription eps_ echo_push_topic ept_ echo_subscription sub_ echo_target_page etp_ echo_unread_wikis euw_ EnhancedAutopromote enh_autopromote eha_ archived FanBoxes fantag fantag_ user_fantag userft_ FlaggedRevs flaggedimages fi_ flaggedpages fp_ flaggedpage_config fpc_ flaggedpage_pending fpp_ flaggedrevs fr_ flaggedrevs_promote frp_ flaggedrevs_statistics frs_ flaggedrevs_tracking ftr_ flaggedtemplates ft_ GeoData geo_tags gt_ GlobalBlocking globalblocks gb_ global_block_whitelist gbw_ GlobalPreferences global_preferences gp_ GlobalUsage globalimagelinks gil_ GlobalUserrights global_user_groups gug_ GrowthExperiments growthexperiments_link_recommendations gelr_ growthexperiments_link_submissions gels_ growthexperiments_mentee_data mentee_ growthexperiments_mentor_mentee gemm_ growthexperiments_user_impact geui_ InterwikiExistence iwe_page iwe_page_ archived This extension causes interwiki links, e.g. wikipedia:foo, to become existence detecting. No longer supports recent releases of MediaWiki. LegalLogin legallogin_accepted lla_ legallogin_logged lll_ Linter linter linter_ LiquidThreads historical_thread hthread_ thread thread_ thread_history th_ thread_pending_relationship tpr_ thread_reaction tr_ user_message_state ums_ LoginNotify loginnotify_seen_net lsn_ Math math math_ mathlatexml math_ mathoid math_ MathSearch mathindex mathindex_ mathsearch N/A mathidentifier N/A mathlog math_ mathobservation mathobservation_ mathpagesimilarity pagesimilarity_ mathrevisionstat revstat_ mathsemantics N/A mathvarstat varstat_ math_mlp N/A math_review_list N/A math_wbs_entity_map math_ math_wbs_text_store math_ mathpage9 N/A Moderation moderation mod_ moderation_block mb_ Newsletter nl_issues nli_ nl_newsletters nl_ nl_publishers nlp_ nl_subscriptions nls_ OATHAuth oathauth_users N/A OAuth oauth_accepted_consumer oaac_ oauth_registered_consumer oarc_ OpenStackManager openstack_notification_event event_ archived openstack_tokens N/A archived ORES ores_classification oresc_ ores_model oresm_ PageAssessments page_assessments pa_ page_assessments_projects pap_ PageTriage pagetriage_log prtl_ pagetriage_page prtp_ pagetriage_page_tags ptrpt_ pagetriage_tags ptrt_ Proofread Page pr_index pr_ PropertySuggester wbs_propertypairs N/A ReadingLists reading_list rl_ reading_list_entry rle_ reading_list_project rlp_ RPED rped_page rped_page_ archived List of pages present on the remote wiki. This is superseded by InterwikiExistence SacredText sacredtext_verses st_ archived Sanctions sanctions st_ sanctions_vote stv_ SecurePasswords password_history ph_ archived No longer supports recent releases of MediaWiki. securepasswords_uninstall su_ archived No longer supports recent releases of MediaWiki. SecurePoll securepoll_cookie_match cm_ securepoll_elections el_ securepoll_entity en_ securepoll_lists li_ securepoll_msgs msg_ securepoll_options op_ securepoll_properties pr_ securepoll_questions qu_ securepoll_strike st_ securepoll_voters voter_ securepoll_votes vote_ ShortUrl shorturls su_ TimedMediaHandler transcode transcode_ TitleKey titlekey tk_ Translate revtag rt_ translate_groupreviews tgr_ translate_groupstats tgs_ translate_messageindex tmi_ translate_metadata tmd_ translate_reviews trr_ translate_sections trs_ translate_stash ts_ translate_tmf tmf_ translate_tms tms_ translate_tmt tmt_ translate_cache tc_ translate_translatable_bundles ttb_ UploadWizard uw_campaigns campaign_ UrlShortener urlshortcodes usc_ VoteNY Vote vote_ WikibaseStatementUpdater wsu_batch wsub_ wsu_batchlist wsubl_ WikibaseQualityConstraints wbqc_constraints constraint_ Describes how properties should and shouldn’t be used. Imported from statements on Wikibase properties via a job. Wikibase Client wbc_entity_usage eu_ Wikibase Repository wbt_item_terms wbit_ wbt_property_terms wbpt_ wbt_term_in_lang wbtl_ wbt_text_in_lang wbxl_ wbt_text wbx_ wbt_type wby_ wb_changes change_ wb_changes_subscriptions cs_ wb_id_counters id_ wb_items_per_site ips_ wb_property_info pi_ WikiLove wikilove_log ull_ WikimediaEditorTasks wikimedia_editor_tasks_counts wetc_ wikimedia_editor_tasks_edit_streak wetes_ wikimedia_editor_tasks_keys wet_ Wikispeech wikispeech_utterance wsu_
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4