Manual:Database layout/de

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

↑ Handbuch:Inhaltsübersicht

MediaWiki database layout

database_layout table

Datenbankschema ansehen →

Das aktuelle MySQL-Diagramm für jede MediaWiki-Version—mit ausführlichen Kommentaren—kann in der maintenance/tables.sql Datei gefunden werden. Sehen Sie sich die neueste Version aus SVN: maintenance/tables.sql an. Bei Verwendung von Postgres, sollte stattdessen die maintenance/postgres/tables.sql betrachtet werden. Die wichtigsten Tabellen sind wahrscheinlich page, revision, pagelinks und text.

As of 1.35 (and continuing during 1.36), the appropriate file is in the maintenance/tables.json source file, which is then transformed into maintenance/tables-generated.sql. In these versions maintenance/tables.sql is less relevant, though some tables are still in there that haven't been migrated yet.

The most important tables are probably page , revision , text and user .

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.

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	master
																														actor
archive
		blobs
																										bot_passwords
brokenlinks
												category
		categorylinks
														change_tag
																															change_tag_def
																													comment
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	master
																														content
																														content_models
cur
					externallinks
															external_user
						filearchive
	hitcounter
image
imagelinks
																													image_comment_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	master
interwiki
																													ip_changes
ipblocks
					ipblocks_old
																															ipblocks_restrictions
																iwlinks
					job
															l10n_cache
						langlinks
links
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	master
linkscc
			logging
															log_search
math
																module_deps
																msg_resource
																msg_resource_links
		objectcache
old
oldimage
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	master
				page
				pagelinks
												page_props
									page_restrictions
		profiling
											protected_titles
		querycache
								querycachetwo
						querycache_info
recentchanges
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	master
								redirect
				revision
																														revision_actor_temp
																													revision_comment_temp
searchindex
																				sites
																				site_identifiers
site_stats
																														slots
																														slot_roles
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	master
														tag_summary
					templatelinks
				text
				trackbacks
				transcache
												updatelog
																	uploadstash
user
																	user_former_groups
				user_groups
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	master
user_newtalk
															user_properties
			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	master

Database management systems

In MediaWiki master, tables.sql is currently being migrated to maintenance/tables.json, and documenting comments should be found there instead of the resultant sql files.

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

If using SQLite , the file maintenance/sqlite/tables-generated.sql and the unmigrated MySQL tables in maintenance/tables.sql should be viewed instead.

If using PostgreSQL , the files maintenance/postgres/tables.sql and maintenance/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

• Manual:Databank-Zugriff
• Proposed Database Schema Changes
• Database field prefixes

• w:Wikipedia:Database queries

• Entwickler-Zentrum

• Records of edits in the database
• A research on MediaWiki DB schema evolution

• Diagram instructions, documents how to update the diagram