Manual:Database layout/de

This page is a translated version of the page Manual:Database layout and the translation is 13% complete.

Outdated translations are marked like this.

Languages:

Schema redirects here; for information about the Schema: namespace, see Erweiterung:EventLogging , and for the structure of extension.json, see Handbuch:extenstion.json/Schema .

↑ Handbuch:Inhaltsübersicht

MediaWiki-Datenbank-Layout

database_layout-Tabelle

Database schema diagram of MediaWiki

Datenbankschema ansehen →

The SQL code that creates the MySQL/MariaDB core tables for any MediaWiki version is in the sql/tables.json source file, which is then transformed into platform-specific SQL files, like sql/mysql/tables-generated.sql for MySQL.

Prior to MediaWiki 1.35, the SQL code that created the core tables for any MediaWiki version—with extensive comments—was in the maintenance/tables.sql source file.

Up to MediaWiki 1.37 maintenance/tables.sql continued to be partially in use as some tables hadn't been migrated to maintenance/tables.json yet.

In MediaWiki 1.44, the schema files were moved to a new top-level sql directory.

The most important tables are probably:

Versionsgeschichte

Die folgende Tabelle zeigt die Bandbreite der MediaWiki-Versionen, über die jede Tabelle im Diagramm existierte. Rote Reihen zeigen Tabellen, die in einer bestimmten Version gelöscht wurden. Beachten Sie, Tabellenüberschriften werden alle 10 Zeilen für Klarheit wiederholt. Red rows indicate tables that are no longer used by the core nor added by the installer as of a particular version. They might however still be used by extensions. Note, table headings are repeated every 10 rows for clarity.

Compatibility matrix with MediaWiki versions
1.1	1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	1.32	1.33	1.34	1.35	1.36	1.37	1.38	1.39	1.40	1.41	1.42	1.43	1.44	master
																														actor
archive
																																									block
																																									block_target
		blobs
																										bot_passwords
brokenlinks
												category
		categorylinks
														change_tag
1.1	1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	1.32	1.33	1.34	1.35	1.36	1.37	1.38	1.39	1.40	1.41	1.42	1.43	1.44	master
																															change_tag_def
																																											collation
																													comment
																														content
																														content_models
cur
					externallinks
															external_user
																																											file
						filearchive
1.1	1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	1.32	1.33	1.34	1.35	1.36	1.37	1.38	1.39	1.40	1.41	1.42	1.43	1.44	master
																																											filerevision
																																											filetypes
	hitcounter
image
imagelinks
																													image_comment_temp
interwiki
																													ip_changes
ipblocks
							ipblocks_old
1.1	1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	1.32	1.33	1.34	1.35	1.36	1.37	1.38	1.39	1.40	1.41	1.42	1.43	1.44	master
																															ipblocks_restrictions
																iwlinks
					job
															l10n_cache
						langlinks
links
linkscc
																																					linktarget
			logging
															log_search
1.1	1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	1.32	1.33	1.34	1.35	1.36	1.37	1.38	1.39	1.40	1.41	1.42	1.43	1.44	master
math
																module_deps
																msg_resource
																msg_resource_links
		objectcache
old
oldimage
				page
				pagelinks
												page_props
1.1	1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	1.32	1.33	1.34	1.35	1.36	1.37	1.38	1.39	1.40	1.41	1.42	1.43	1.44	master
									page_restrictions
		profiling
											protected_titles
		querycache
								querycachetwo
						querycache_info
recentchanges
								redirect
				revision
																														revision_actor_temp
1.1	1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	1.32	1.33	1.34	1.35	1.36	1.37	1.38	1.39	1.40	1.41	1.42	1.43	1.44	master
																													revision_comment_temp
searchindex
																				sites
																				site_identifiers
site_stats
																														slots
																														slot_roles
														tag_summary
					templatelinks
				text
1.1	1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	1.32	1.33	1.34	1.35	1.36	1.37	1.38	1.39	1.40	1.41	1.42	1.43	1.44	master
				trackbacks
				transcache
												updatelog
																	uploadstash
user
																																						user_autocreate_serial
																	user_former_groups
				user_groups
user_newtalk
															user_properties
1.1	1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	1.32	1.33	1.34	1.35	1.36	1.37	1.38	1.39	1.40	1.41	1.42	1.43	1.44	master
			user_rights
														valid_tag
			validate
watchlist
																																		watchlist_expiry
1.1	1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	1.32	1.33	1.34	1.35	1.36	1.37	1.38	1.39	1.40	1.41	1.42	1.43	1.44	master

Database management systems

In MediaWiki master, tables.sql has been migrated to sql/tables.json, and documenting comments should be found there instead of the resultant SQL files.

See the latest MariaDB/MySQL-compatible versions from Git: sql/mysql/tables-generated.sql.

If using SQLite , the file sql/sqlite/tables-generated.sql should be viewed instead.

If using PostgreSQL , the files sql/postgres/tables.sql and sql/postgres/tables-generated.sql should be viewed instead.

If using Microsoft SQL Server, see maintenance/mssql/tables.sql. (entfernt in 1.34)

If using Oracle, see maintenance/oracle/tables.sql. (entfernt in 1.34)

Siehe auch

w:Wikipedia:Database queries

Entwickler-Zentrum

Diagram instructions, documents how to update the diagram

Diagramme

commons:Category:MediaWiki database schemas, for MediaWiki 1.10 (2007) - MediaWiki 1.28 (2017)

v
t
e

Datenbanken

Enginen

Aktuell	MariaDB MySQL PostgreSQL SQLite
Ehemalige	Oracle SQL Server

Technische Dokumentation

Konfiguration

Entwicklung

Kerntabellen

aktuell

Ehemalige

v t e Wikimedia-Erweiterungsdatenbanktabellen
Missbrauchsfilter	abuse_filter_action abuse_filter_history abuse_filter_log abuse_filter
AntiSpoof	spoofuser
Babel	babel
BetaFeatures	betafeatures_user_counts
BounceHandler	bounce_records
CampaignEvents	campaign_events ce_address ce_event_address ce_event_questions ce_event_topics ce_event_wikis ce_invitation_lists ce_organizers ce_participants ce_question_aggregation ce_question_answers ce_tracking_tools ce_worklist_articles
CentralAuth	globalnames globaluser global_edit_count global_group_permissions global_group_restrictions global_user_autocreate_serial global_user_groups localnames localuser renameuser_queue renameuser_status users_to_rename wikiset
CentralNotice	cn_assignments cn_known_devices cn_known_mobile_carriers cn_notices cn_notice_countries cn_notice_regions cn_notice_languages cn_notice_log cn_notice_mixins cn_notice_mixin_params cn_notice_mobile_carriers cn_notice_projects cn_templates cn_template_devices cn_template_log cn_template_mixins
CheckUser	cu_changes cu_private_event cu_log_event cu_log cu_useragent_clienthints cu_useragent_clienthints_map cu_useragent cuci_wiki_map cuci_temp_edit cuci_user cusi_case cusi_signal
Cognate	cognate_pages cognate_sites cognate_titles
CommunityRequests	communityrequests_counters communityrequests_entities communityrequests_tags communityrequests_translations
Inhaltübersetzung	cx_corpora cx_lists cx_notification_log cx_suggestions cx_translations cx_translators cx_significant_edits cx_section_translations
CreditSource	revsrc srcwork swauthor swauthor_links swsite swsource_links
DiscussionTools	discussiontools_items discussiontools_item_ids discussiontools_item_pages discussiontools_item_revisions discussiontools_subscription
Echo	echo_email_batch echo_event echo_notification echo_push_provider echo_push_subscription echo_push_topic echo_subscription echo_target_page echo_unread_wikis
EntitySchema	entityschema_id_counter
FlaggedRevs	flaggedpages flaggedpage_config flaggedpage_pending flaggedrevs flaggedrevs_promote flaggedrevs_statistics flaggedrevs_tracking
GeoData	geo_tags
GlobalBlocking	globalblocks global_block_whitelist
GlobalPreferences	global_preferences
GlobalUsage	globalimagelinks
GrowthExperiments	growthexperiments_link_recommendations growthexperiments_link_submissions growthexperiments_mentee_data growthexperiments_mentor_mentee growthexperiments_user_impact
Fusselroller	linter
LiquidThreads	historical_thread thread thread_history thread_pending_relationship thread_reaction user_message_state
LoginNotify	loginnotify_seen_net
MediaModeration	mediamoderation_scan
Math	math mathlatexml mathoid
Newsletter	nl_issues nl_newsletters nl_publishers nl_subscriptions
OATHAuth	oathauth_types (eingeführt in 1.41) oathauth_devices (eingeführt in 1.41) oathauth_users (entfernt in 1.40)
OAuth	oauth_accepted_consumer oauth_registered_consumer
ORES	ores_classification ores_model
PageAssessments	page_assessments page_assessments_projects
PageTriage	pagetriage_log pagetriage_page pagetriage_page_tags pagetriage_tags
Proofread Page	pr_index
PropertySuggester	wbs_propertypairs
ReadingLists	reading_list reading_list_entry reading_list_project
SecurePoll	securepoll_cookie_match securepoll_elections securepoll_entity securepoll_lists securepoll_log securepoll_msgs securepoll_options securepoll_properties securepoll_questions securepoll_strike securepoll_voters securepoll_votes
ShortUrl	shorturls
TimedMediaHandler	transcode
Übersetzen	revtag translate_groupreviews translate_groupstats translate_messageindex translate_metadata translate_reviews translate_sections translate_stash translate_tmf translate_tms translate_tmt translate_cache translate_translatable_bundles
UploadWizard	uw_campaigns
UrlShortener	urlshortcodes
WikibaseQualityConstraints	wbqc_constraints
Wikibase Client	wbc_entity_usage
Wikibase Repository	wbt_item_terms wbt_property_terms wbt_term_in_lang wbt_text_in_lang wbt_text wbt_type wb_changes wb_changes_subscriptions wb_id_counters wb_items_per_site wb_property_info
WikiLambda	wikilambda_zobject_function_join wikilambda_zobject_join wikilambda_zobject_labels wikilambda_zobject_label_conflicts wikilambda_ztester_results wikilambda_zlanguages
WikiLove	wikilove_log
WikimediaCampaignEvents	wikimedia_campaign_events_grant
WikimediaEditorTasks	wikimedia_editor_tasks_counts wikimedia_editor_tasks_edit_streak wikimedia_editor_tasks_keys

Retrieved from "https://www.mediawiki.org/w/index.php?title=Manual:Database_layout/de&oldid=7739011"