Tietokantataulujen etuliitteet

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.

Laajennus/ydin	Taulukko	Kentän etuliite	Versio	Kuvaus
Ydin	actor	actor_	1.31+
	archive	ar_		Tallentaa tiedot poistetulle sivulle
	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_	Versio 1.4 ja vanhemmat	The brokenlinks table stored links to articles that don't exist yet. Obsolete
	bot_passwords	bp_	1.27+
	category	cat_	1.13+	Seuraa kaikkia olemassa olevia luokkia.
	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+	Taulukko kokoonpanomuutosten pitämiseksi.
	content	content_	1.31+
	content_models	model_	1.31+
	cur	cur_	Versio 1.4 ja vanhemmat	Cur-taulukkoa käytettiin MediaWikien vanhemmissa versioissa sivun nykyisen version tallentamiseen.
	externallinks	el_	1.6+	Ulkoisten linkkien taulukossa (externallinks) MediaWiki tallentaa ja seuraa ulkoisia linkkejä.
	external_user	eu_	1.16-1.21	external_user seuraa ulkoisia käyttäjätilejä, jos ExternalAuthia käytetään.
	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_	Versio 1.4 ja vanhemmat	(poistettu versiossa 1.4)
	linkscc	lcc_	Versio 1.4 ja vanhemmat	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_	Versio 1.17 ja vanhemmat	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	(poistettu versiossa 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	(poistettu versiossa 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_
Sisällön kääntäminen	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_
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_