Manual:Database layout/id

↑ Manual teknis

Struktur basis data MediaWiki

Database layout/id

Diagram skema basis data untuk MediaWiki

Diagram MySQL saat ini untuk semua versi MediaWiki version—dengan komentar ekstensif—dapat dilihat di dalam berkas maintenance/tables.sql. Lihat versi terakhir di SVN. Diagram Postgres dapat dilihat di sini.

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

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	master
archive
	blobs
brokenlinks
											category
	categorylinks
													change_tag
cur
				externallinks
														external_user
					filearchive
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	master
hitcounter
image
imagelinks
interwiki
															iwlinks
ipblocks
				job
														l10n_cache
					langlinks
links
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	master
linkscc
		logging
														log_search
math
	objectcache
old
oldimage
			page
			pagelinks
											page_props
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	master
								page_restrictions
										protected_titles
	querycache
							querycachetwo
					querycache_info
recentchanges
							redirect
			revision
searchindex
site_stats
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	master
													tag_summary
				templatelinks
			text
			trackbacks
			transcache
											updatelog
user
			user_groups
user_newtalk
														user_properties
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	master
													valid_tag
		validate
watchlist
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	master

• msg_resource (since 1.17)
• msg_resource_links (since 1.17)
• module_deps (since 1.17)

Lihat pula

• Manual:Database access
• Proposed Database Schema Changes
• w:Wikipedia:Database queries
• nl:Wikipedia:SQL-opdrachten
• m:Documentation: Developer's Guide
• Records of edits in the database
• A research on MediaWiki DB schema evolution

Databases	Engines: MySQL – Oracle – PostgreSQL – SQLite – IBM DB2 Technical documentation: Schema (tables) – Access