Database field prefixes/es

From MediaWiki.org
Jump to navigation Jump to search
This page is a translated version of the page Database field prefixes and the translation is 11% complete.
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 Tabla Field prefix Versión Descripción
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 y anteriores 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 y anteriores 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 (desaprobado)
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 y anteriores (eliminado en 1.4)
linkscc lcc_ 1.4 y anteriores 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 y anteriores 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 y anteriores 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_ 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 (eliminado en 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 (eliminado en 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.
AbuseFilter abuse_filter_action afa_
abuse_filter_history afh_
abuse_filter_log afl_
abuse_filter af_
Advanced Meta ext_meta N/A Allows per page editing of various meta tags for SEO reasons
AntiSpoof spoofuser su_
Babel babel babel_
BetaFeatures betafeatures_user_counts N/A
BounceHandler bounce_records br_
CentralNotice cn_notices not_
cn_assignments asn_
cn_templates tmp_
cn_notice_languages nl_
cn_notice_projects np_
cn_notice_countries nc_
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 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_
Cognate cognate_pages cgpa_
cognate_sites cgsi_
cognate_titles cgti_
ContentTranslation cx_corpora cxc_
cx_lists cxl_
cx_suggestions cxs_
cx_translations translation_
cx_translators translator_
ContributionTracking contribution_tracking N/A
contribution_tracking_owa_ref

N/A
DataTable2 datatable2_data dtd_
datatable2_meta dtm_
Echo echo_email_batch eeb_
echo_event event_
echo_notification notification_
echo_subscription sub_
echo_target_page etp_
EnhancedAutopromote enh_autopromote eha_
GeoData geo_tags gt_
GlobalBlocking globalblocks gb_
global_block_whitelist gbw_
GlobalPreferences global_preferences gp_
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.
Linter linter linter_
Math math math_
mathlatexml math_
mathoid math_
MathSearch mathindex mathindex_
mathsearch N/A
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_
openstack_tokens N/A
ORES ores_classification oresc_
ores_model oresm_
RPED rped_page rped_page_ List of pages present on the remote wiki. This is superseded by InterwikiExistence
SacredText sacredtext_verses st_
SecurePasswords password_history ph_ archived No longer supports recent releases of MediaWiki.
securepasswords_uninstall su_ archived No longer supports recent releases of MediaWiki.
WikibaseQualityConstraints wbqc_constraints constraint_ Describes how properties should and shouldn’t be used. Imported from statements on Wikibase properties via a job.