Manual:Tables.sql

MediaWiki file: tables.sql
Location:	maintenance/
Source code:	master • 1.40.0 • 1.39.4 • 1.35.11
Classes:	Find code • Find documentation

tables.sql is the file that creates the initial tables for the MediaWiki database. It is read and executed by the install script.

See also

Manual:Database layout

Databases

Engines

Current	MariaDB MySQL PostgreSQL SQLite
Former	Oracle SQL Server

Technical documentation

Schema (tables )
API property associations
Field prefixes
Primary key storage in other fields
Wikimedia extension tables

Configuration

Settings
Sharing

Development

Access
Optimization
Policy
Updater
Extension schema updates
Schema changes

Core tables

Current	actor archive bot_passwords category categorylinks change_tag change_tag_def comment content content_models externallinks filearchive image imagelinks interwiki iwlinks ipblocks ipblocks_restrictions ip_changes job l10n_cache langlinks linktarget logging log_search module_deps objectcache oldimage page pagelinks page_props page_restrictions protected_titles querycache querycachetwo querycache_info recentchanges redirect revision revision_actor_temp searchindex sites site_identifiers site_stats slots slot_roles templatelinks text updatelog uploadstash user user_former_groups user_groups user_newtalk user_properties watchlist watchlist_expiry
Former	blobs brokenlinks config cur external_user hitcounter image_comment_temp ipblocks_old links linkscc math msg_resource msg_resource_links old profiling revision_comment_temp tag_summary trackbacks transcache user_rights valid_tag validate
Future	user_autocreate_serial

This article is issued from Mediawiki. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.