User:Ladsgroup/Test

actor

The "actor" table associates user names or IP addresses with integers for the benefit of other tables that need to refer to either logged-in or logged-out users. If something can only ever be done by logged-in users, it can refer to the user table directly.

Primary Key: actor_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`actor_id`	bigint	No	No default	Unsigned	Unique ID to identify each actor
`actor_user`	integer	Yes	No default	Unsigned	Key to user.user_id, or NULL for anonymous edits
`actor_name`	binary	No	No default	Length: 255	Text username or IP address

Indexes

Name	Columns	Unique	Description
`actor_user`	`actor_user`	Yes
`actor_name`	`actor_name`	Yes

bot_passwords

This table contains a user's bot passwords: passwords that allow access to the account via the API with limited rights.

Primary Key: bp_user, bp_app_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`bp_user`	integer	No	No default	Unsigned	User ID obtained from CentralIdLookup.
`bp_app_id`	binary	No	No default	Length: 32	Application identifier.
`bp_password`	blob	No	No default	Length: 255	Password hashes, like user.user_password.
`bp_token`	binary	No	""	Length: 32	Like user.user_token
`bp_restrictions`	blob	No	No default	Length: 65535	JSON blob for MWRestrictions
`bp_grants`	blob	No	No default	Length: 65535	Grants allowed to the account when authenticated with this bot-password

categorylinks

Track category inclusions *used inline* This tracks a single level of category membership

Primary Key: cl_from, cl_to

Columns

Name	Type	Nullable	Default	Extra options	Description
`cl_from`	integer	No	0	Unsigned	Key to page_id of the page defined as a category member.
`cl_to`	binary	No	""	Length: 255	Name of the category. This is also the page_title of the category's description page; all such pages are in namespace 14 (NS_CATEGORY).
`cl_sortkey`	binary	No	""	Length: 230	A binary string obtained by applying a sortkey generation algorithm (Collation::getSortKey()) to page_title, or cl_sortkey_prefix . "\n" page_title if cl_sortkey_prefix is nonempty.
`cl_sortkey_prefix`	binary	No	""	Length: 255	A prefix for the raw sortkey manually specified by the user, either via or Template:Defaultsort:prefix. If nonempty, it's concatenated with a line break followed by the page title before the sortkey conversion algorithm is run. We store this so that we can update collations without reparsing all pages. Note: If you change the length of this field, you also need to change code in LinksUpdate.php. See T27254.
`cl_timestamp`	datetimetz	No	No default		This isn't really used at present. Provided for an optional sorting method by approximate addition time.
`cl_collation`	binary	No	""	Length: 32	Stores $wgCategoryCollation at the time cl_sortkey was generated. This can be used to install new collation versions, tracking which rows are not yet updated. '' means no collation, this is a legacy row that needs to be updated by updateCollation.php. In the future, it might be possible to specify different collations per category.
`cl_type`	mwenum	No	page		Stores whether cl_from is a category, file, or other page, so we can paginate the three categories separately. This only has to be updated when moving pages into or out of the category namespace, since file pages cannot be moved to other namespaces, nor can non-files be moved into the file namespace.

Indexes

Name	Columns	Unique	Description
`cl_sortkey`	`cl_to, cl_type, cl_sortkey, cl_from`	No	We always sort within a given category, and within a given type. FIXME: Formerly this index didn't cover cl_type (since that didn't exist), so old callers won't be using an index: fix this?
`cl_timestamp`	`cl_to, cl_timestamp`	No	Used by the API (and some extensions)
`cl_collation_ext`	`cl_collation, cl_to, cl_type, cl_from`	No	Used when updating collation (e.g. updateCollation.php)

change_tag

A table to track tags for revisions, logs and recent changes

Primary Key: ct_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`ct_id`	integer	No	No default	Unsigned
`ct_rc_id`	integer	Yes	NULL	Unsigned	RCID for the change
`ct_log_id`	integer	Yes	NULL	Unsigned	LOGID for the change
`ct_rev_id`	integer	Yes	NULL	Unsigned	REVID for the change
`ct_params`	blob	Yes	NULL	Length: 65530	Parameters for the tag; used by some extensions
`ct_tag_id`	integer	No	No default	Unsigned	Foreign key to change_tag_def row

Indexes

Name	Columns	Unique	Description
`change_tag_rc_tag_id`	`ct_rc_id, ct_tag_id`	Yes
`change_tag_log_tag_id`	`ct_log_id, ct_tag_id`	Yes
`change_tag_rev_tag_id`	`ct_rev_id, ct_tag_id`	Yes
`change_tag_tag_id_id`	`ct_tag_id, ct_rc_id, ct_rev_id, ct_log_id`	No	Covering index, so we can pull all the info only out of the index.

change_tag_def

Table defining tag names for IDs. Also stores hit counts to avoid expensive queries on change_tag

Primary Key: ctd_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`ctd_id`	integer	No	No default	Unsigned	Numerical ID of the tag (ct_tag_id refers to this)
`ctd_name`	binary	No	No default	Length: 255	Symbolic name of the tag (what would previously be put in ct_tag)
`ctd_user_defined`	mwtinyint	No	No default	Length: 1	Whether this tag was defined manually by a privileged user using Special:Tags
`ctd_count`	bigint	No	0	Unsigned	Number of times this tag was used

Indexes

Name	Columns	Unique
`ctd_name`	`ctd_name`	Yes
`ctd_count`	`ctd_count`	No
`ctd_user_defined`	`ctd_user_defined`	No

comment

Edits, blocks, and other actions typically have a textual comment describing the action. They are stored here to reduce the size of the main tables, and to allow for deduplication. Deduplication is currently best-effort to avoid locking on inserts that would be required for strict deduplication. There MAY be multiple rows with the same comment_text and comment_data.

Primary Key: comment_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`comment_id`	bigint	No	No default	Unsigned	Unique ID to identify each comment
`comment_hash`	integer	No	No default		Hash of comment_text and comment_data, for deduplication
`comment_text`	blob	No	No default	Length: 65535	Text comment summarizing the change. This text is shown in the history and other changes lists, rendered in a subset of wiki markup by Linker::formatComment(). Size limits are enforced at the application level, and should take care to crop UTF-8 strings appropriately.
`comment_data`	blob	Yes	No default	Length: 65535	JSON data, intended for localizing auto-generated comments. This holds structured data that is intended to be used to provide localized versions of automatically-generated comments. When not empty, comment_text should be the generated comment localized using the wiki's content language.

Indexes

Name	Columns	Unique	Description
`comment_hash`	`comment_hash`	No

content

The content table represents content objects. It's primary purpose is to provide the necessary meta-data for loading and interpreting a serialized data blob to create a content object.

Primary Key: content_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`content_id`	bigint	No	No default	Unsigned	ID of the content object
`content_size`	integer	No	No default	Unsigned	Nominal size of the content object (not necessarily of the serialized blob)
`content_sha1`	binary	No	No default	Length: 32	Nominal hash of the content object (not necessarily of the serialized blob)
`content_model`	smallint	No	No default	Unsigned	reference to model_id. Note the content format isn't specified; it should be assumed to be in the default format for the model unless auto-detected otherwise.
`content_address`	binary	No	No default	Length: 255	URL-like address of the content blob

content_models

Normalization table for content model names

Primary Key: model_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`model_id`	integer	No	No default
`model_name`	binary	No	No default	Length: 64

Indexes

Name	Columns	Unique	Description
`model_name`	`model_name`	Yes	Index for looking up the internal ID of a model

externallinks

Track links to external URLs

Primary Key: el_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`el_id`	integer	No	No default	Unsigned
`el_from`	integer	No	0	Unsigned	page_id of the referring page
`el_to`	blob	No	No default	Length: 65530	The external link
`el_index`	blob	No	No default	Length: 65530	In the case of HTTP URLs, this is the URL with any username or password removed, and with the labels in the hostname reversed and converted to lower case which will allow faster searching for all pages with WHERE clause. Note: If PHP's intl extension is enabled/disabled, maintenance/refreshExternallinksIndex.php needs to be run to refresh this field
`el_index_60`	binary	No	No default	Length: 60	'el_index' truncated to 60 bytes to allow for sortable queries that aren't supported by a partial index

Indexes

Name	Columns	Unique
`el_from`	`el_from, el_to`	No
`el_to`	`el_to, el_from`	No
`el_index`	`el_index`	No
`el_index_60`	`el_index_60, el_id`	No
`el_from_index_60`	`el_from, el_index_60, el_id`	No

filearchive

Record of deleted file data

Primary Key: fa_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`fa_id`	integer	No	No default		Unique row id
`fa_name`	binary	No	""	Length: 255	Original base filename; key to image.img_name, page.page_title, etc
`fa_archive_name`	binary	Yes	""	Length: 255	Filename of archived file, if an old revision
`fa_storage_group`	binary	Yes	No default	Length: 16	Which storage bin (directory tree or object store) the file data is stored in. Should be 'deleted' for files that have been deleted; any other bin is not yet in use.
`fa_storage_key`	binary	Yes	""	Length: 64	SHA-1 of the file contents plus extension, used as a key for storage. eg 8f8a562add37052a1848ff7771a2c515db94baa9.jpg. If NULL, the file was missing at deletion time or has been purged from the archival storage.
`fa_deleted_user`	integer	Yes	No default
`fa_deleted_timestamp`	mwtimestamp	Yes	No default	Length: 14
`fa_deleted_reason_id`	bigint	No	No default	Unsigned
`fa_size`	integer	Yes	0	Unsigned
`fa_width`	integer	Yes	0
`fa_height`	integer	Yes	0
`fa_metadata`	blob	Yes	No default	Length: 16777215
`fa_bits`	integer	Yes	0
`fa_media_type`	mwenum	Yes	NULL
`fa_major_mime`	mwenum	Yes	unknown
`fa_minor_mime`	binary	Yes	unknown	Length: 100
`fa_description_id`	bigint	No	No default	Unsigned
`fa_actor`	bigint	No	No default	Unsigned
`fa_timestamp`	mwtimestamp	Yes	No default	Length: 14
`fa_deleted`	mwtinyint	No	0	Unsigned	Visibility of deleted revisions, bitfield
`fa_sha1`	binary	No	""	Length: 32	sha1 hash of file content

Indexes

Name	Columns	Unique	Description
`fa_name`	`fa_name, fa_timestamp`	No	pick out by image name
`fa_storage_group`	`fa_storage_group, fa_storage_key`	No	pick out dupe files
`fa_deleted_timestamp`	`fa_deleted_timestamp`	No	sort by deletion time
`fa_actor_timestamp`	`fa_actor, fa_timestamp`	No	sort by uploader
`fa_sha1`	`fa_sha1`	No	find file by sha1, 10 bytes will be enough for hashes to be indexed

image

Uploaded images and other files.

Primary Key: img_name

Columns

Name	Type	Nullable	Default	Extra options	Description
`img_name`	binary	No	""	Length: 255	Filename. This is also the title of the associated description page, which will be in namespace 6 (NS_FILE).
`img_size`	integer	No	0	Unsigned	File size in bytes.
`img_width`	integer	No	0		For images, width in pixels.
`img_height`	integer	No	0		For images, height in pixels.
`img_metadata`	blob	No	No default	Length: 16777215	Extracted Exif metadata stored as a serialized PHP array.
`img_bits`	integer	No	0		For images, bits per pixel if known.
`img_media_type`	mwenum	Yes	NULL		Media type as defined by the MEDIATYPE_xxx constants
`img_major_mime`	mwenum	No	unknown		major part of a MIME media type as defined by IANA see https://www.iana.org/assignments/media-types/ for "chemical" cf. http://dx.doi.org/10.1021/ci9803233 by the ACS
`img_minor_mime`	binary	No	unknown	Length: 100	minor part of a MIME media type as defined by IANA the minor parts are not required to adhere to any standard but should be consistent throughout the database see https://www.iana.org/assignments/media-types/
`img_description_id`	bigint	No	No default	Unsigned	Foreign key to comment table, which contains the description field as entered by the uploader. This is displayed in image upload history and logs.
`img_actor`	bigint	No	No default	Unsigned	actor_id of the uploader.
`img_timestamp`	mwtimestamp	No	No default	Length: 14	Time of the upload.
`img_sha1`	binary	No	""	Length: 32	SHA-1 content hash in base-36

Indexes

Name	Columns	Unique	Description
`img_actor_timestamp`	`img_actor, img_timestamp`	No	Used by Special:Newimages and ApiQueryAllImages
`img_size`	`img_size`	No	Used by Special:ListFiles for sort-by-size
`img_timestamp`	`img_timestamp`	No	Used by Special:Newimages and Special:ListFiles
`img_sha1`	`img_sha1`	No	Used in API and duplicate search
`img_media_mime`	`img_media_type, img_major_mime, img_minor_mime`	No	Used to get media of one type

imagelinks

Track links to images *used inline* We don't distinguish live from broken links here, so they do not need to be changed on upload/removal.

Primary Key: il_from, il_to

Columns

Name	Type	Nullable	Default	Extra options	Description
`il_from`	integer	No	0	Unsigned	Key to page_id of the page containing the image / media link.
`il_from_namespace`	integer	No	0		Namespace for this page
`il_to`	binary	No	""	Length: 255	Filename of target image. This is also the page_title of the file's description page; all such pages are in namespace 6 (NS_FILE).

Indexes

Name	Columns	Unique	Description
`il_to`	`il_to, il_from`	No	Reverse index, for Special:Whatlinkshere and file description page local usage
`il_backlinks_namespace`	`il_from_namespace, il_to, il_from`	No	Index for Special:Whatlinkshere with namespace filter

interwiki

Recognized interwiki link prefixes

Primary Key: iw_prefix

Columns

Name	Type	Nullable	Default	Extra options	Description
`iw_prefix`	string	No	No default	Length: 32	The interwiki prefix, (e.g. "Meatball", or the language prefix "de")
`iw_url`	blob	No	No default	Length: 65530	The URL of the wiki, with "$1" as a placeholder for an article name. Any spaces in the name will be transformed to underscores before insertion.
`iw_api`	blob	No	No default	Length: 65530	The URL of the file api.php
`iw_wikiid`	string	No	No default	Length: 64	The name of the database (for a connection to be established with LBFactory::getMainLB( 'wikiid' ))
`iw_local`	mwtinyint	No	No default	Length: 1	A boolean value indicating whether the wiki is in this project (used, for example, to detect redirect loops)
`iw_trans`	mwtinyint	No	0		Boolean value indicating whether interwiki transclusions are allowed.

ip_changes

Every time an edit by a logged out user is saved, a row is created in ip_changes. This stores the IP as a hex representation so that we can more easily find edits within an IP range.

Primary Key: ipc_rev_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`ipc_rev_id`	integer	No	0	Unsigned	Foreign key to the revision table, also serves as the unique primary key
`ipc_rev_timestamp`	mwtimestamp	No	No default		The timestamp of the revision
`ipc_hex`	binary	No	""	Length: 35	Hex representation of the IP address, as returned by Wikimedia\IPUtils::toHex() For IPv4 it will resemble: ABCD1234 For IPv6: v6-ABCD1234000000000000000000000000 BETWEEN is then used to identify revisions within a given range

Indexes

Name	Columns	Unique	Description
`ipc_rev_timestamp`	`ipc_rev_timestamp`	No
`ipc_hex_time`	`ipc_hex, ipc_rev_timestamp`	No

ipblocks

Blocks against user accounts, IP addresses and IP ranges.

Primary Key: ipb_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`ipb_id`	integer	No	No default		Primary key, introduced for privacy.
`ipb_address`	blob	No	No default	Length: 255	Blocked IP address in dotted-quad form or user name.
`ipb_user`	integer	No	0	Unsigned	Blocked user ID or 0 for IP blocks.
`ipb_by_actor`	bigint	No	No default	Unsigned	Actor who made the block.
`ipb_reason_id`	bigint	No	No default	Unsigned	Key to comment_id. Text comment made by blocker.
`ipb_timestamp`	mwtimestamp	No	No default		Creation (or refresh) date in standard YMDHMS form. IP blocks expire automatically.
`ipb_auto`	mwtinyint	No	0	Length: 1	Indicates that the IP address was banned because a banned user accessed a page through it. If this is 1, ipb_address will be hidden, and the block identified by block ID number.
`ipb_anon_only`	mwtinyint	No	0	Length: 1	If set to 1, block applies only to logged-out users
`ipb_create_account`	mwtinyint	No	1	Length: 1	Block prevents account creation from matching IP addresses
`ipb_enable_autoblock`	mwtinyint	No	1	Length: 1	Block triggers autoblocks
`ipb_expiry`	mwtimestamp	No	No default		Time at which the block will expire. May be "infinity"
`ipb_range_start`	blob	No	No default	Length: 255	Start of an address range, in hexadecimal size chosen to allow IPv6. FIXME: this field were originally blank for single-IP blocks, but now it's populated. No migration was ever done. It should be fixed to be blank again for such blocks (T51504).
`ipb_range_end`	blob	No	No default	Length: 255	End of an address range, in hexadecimal size chosen to allow IPv6. FIXME: this field were originally blank for single-IP blocks, but now it's populated. No migration was ever done. It should be fixed to be blank again for such blocks (T51504).
`ipb_deleted`	mwtinyint	No	0	Length: 1	Flag for entries hidden from users and Sysops
`ipb_block_email`	mwtinyint	No	0	Length: 1	Block prevents user from accessing Special:Emailuser
`ipb_allow_usertalk`	mwtinyint	No	0	Length: 1	Block allows user to edit their own talk page
`ipb_parent_block_id`	integer	Yes	NULL		ID of the block that caused this block to exist. Autoblocks set this to the original block so that the original block being deleted also deletes the autoblocks
`ipb_sitewide`	mwtinyint	No	1	Length: 1	Block user from editing any page on the site (other than their own user talk page).

Indexes

Name	Columns	Unique	Description
`ipb_address_unique`	`ipb_address, ipb_user, ipb_auto`	Yes	Unique index to support "user already blocked" messages. Any new options which prevent collisions should be included
`ipb_user`	`ipb_user`	No	For querying whether a logged-in user is blocked
`ipb_range`	`ipb_range_start, ipb_range_end`	No	For querying whether an IP address is in any range
`ipb_timestamp`	`ipb_timestamp`	No	Index for Special:BlockList
`ipb_expiry`	`ipb_expiry`	No	Index for table pruning
`ipb_parent_block_id`	`ipb_parent_block_id`	No	Index for removing autoblocks when a parent block is removed

ipblocks_restrictions

Partial Block Restrictions

Primary Key: ir_ipb_id, ir_type, ir_value

Columns

Name	Type	Nullable	Default	Extra options	Description
`ir_ipb_id`	integer	No	No default		The ipb_id from ipblocks
`ir_type`	mwtinyint	No	No default	Length: 4	The restriction type id.
`ir_value`	integer	No	No default		The restriction id that corresponds to the type. Typically a Page ID or a Namespace ID.

Indexes

Name	Columns	Unique	Description
`ir_type_value`	`ir_type, ir_value`	No	Index to query restrictions by the page or namespace.

iwlinks

Track inline interwiki links

Primary Key: iwl_from, iwl_prefix, iwl_title

Columns

Name	Type	Nullable	Default	Extra options	Description
`iwl_from`	integer	No	0	Unsigned	page_id of the referring page
`iwl_prefix`	binary	No	""	Length: 20	Interwiki prefix code of the target
`iwl_title`	binary	No	""	Length: 255	Title of the target, including namespace

Indexes

Name	Columns	Unique	Description
`iwl_prefix_title_from`	`iwl_prefix, iwl_title, iwl_from`	No	Index for ApiQueryIWBacklinks
`iwl_prefix_from_title`	`iwl_prefix, iwl_from, iwl_title`	No	Index for ApiQueryIWLinks

job

Jobs performed by parallel apache threads or a command-line daemon

Primary Key: job_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`job_id`	integer	No	No default	Unsigned
`job_cmd`	binary	No	""	Length: 60	Command name. Limited to 60 to prevent key length overflow
`job_namespace`	integer	No	No default		Namespace to act on. Should be 0 if the command does not operate on a title
`job_title`	binary	No	No default	Length: 255	Title to act on. Should be '' if the command does not operate on a title
`job_timestamp`	mwtimestamp	Yes	No default		Timestamp of when the job was inserted. NULL for jobs added before addition of the timestamp
`job_params`	blob	No	No default	Length: 16777215	Any other parameters to the command. Stored as a PHP serialized array, or an empty string if there are no parameters
`job_random`	integer	No	0	Unsigned	Random, non-unique, number used for job acquisition (for lock concurrency)
`job_attempts`	integer	No	0	Unsigned	The number of times this job has been locked
`job_token`	binary	No	""	Length: 32	Field that conveys process locks on rows via process UUIDs
`job_token_timestamp`	mwtimestamp	Yes	No default		Timestamp when the job was locked
`job_sha1`	binary	No	""	Length: 32	Base 36 SHA1 of the job parameters relevant to detecting duplicates

Indexes

Name	Columns	Unique
`job_sha1`	`job_sha1`	No
`job_cmd_token`	`job_cmd, job_token, job_random`	No
`job_cmd_token_id`	`job_cmd, job_token, job_id`	No
`job_cmd`	`job_cmd, job_namespace, job_title, job_params`	No
`job_timestamp`	`job_timestamp`	No

l10n_cache

Table for storing localisation data

Primary Key: lc_lang, lc_key

Columns

Name	Type	Nullable	Default	Extra options	Description
`lc_lang`	binary	No	No default	Length: 35	Language code
`lc_key`	string	No	No default	Length: 255	Cache key
`lc_value`	blob	No	No default	Length: 16777215	Value

langlinks

Track interlanguage links.

Primary Key: ll_from, ll_lang

Columns

Name	Type	Nullable	Default	Extra options	Description
`ll_from`	integer	No	0	Unsigned	page_id of the referring page
`ll_lang`	binary	No	""	Length: 35	Language code of the target
`ll_title`	binary	No	""	Length: 255	Title of the target, including namespace

Indexes

Name	Columns	Unique	Description
`ll_lang`	`ll_lang, ll_title`	No	Index for ApiQueryLangbacklinks

log_search

Primary Key: ls_field, ls_value, ls_log_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`ls_field`	binary	No	No default	Length: 32	The type of ID (rev ID, log ID, rev timestamp, username)
`ls_value`	string	No	No default	Length: 255	The value of the ID
`ls_log_id`	integer	No	0	Unsigned	Key to log_id

Indexes

Name	Columns	Unique	Description
`ls_log_id`	`ls_log_id`	No

logging

Primary Key: log_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`log_id`	integer	No	No default	Unsigned	Log ID, for referring to this specific log entry, probably for deletion and such.
`log_type`	binary	No	""	Length: 32	Symbolic key for the general log type. The output format will be controlled by the log_action field.
`log_action`	binary	No	""	Length: 32	Symbolic key for the log action type.
`log_timestamp`	mwtimestamp	No	19700101000000
`log_actor`	bigint	No	No default	Unsigned
`log_namespace`	integer	No	0		Key to the namespace of the page affected
`log_title`	binary	No	""	Length: 255	Key to the title of the page affected
`log_page`	integer	Yes	No default	Unsigned	Key to the page affected
`log_comment_id`	bigint	No	No default	Unsigned	Key to comment_id. Comment summarizing the change.
`log_params`	blob	No	No default	Length: 65530	LF separated list (old system) or serialized PHP array (new system)
`log_deleted`	mwtinyint	No	0	Unsigned	rev_deleted for logs

Indexes

Name	Columns	Unique	Description
`log_type_time`	`log_type, log_timestamp`	No	Special:Log type filter
`log_actor_time`	`log_actor, log_timestamp`	No	Special:Log performer filter
`log_page_time`	`log_namespace, log_title, log_timestamp`	No	Special:Log title filter, log extract
`log_times`	`log_timestamp`	No	Special:Log unfiltered
`log_actor_type_time`	`log_actor, log_type, log_timestamp`	No	Special:Log filter by performer and type
`log_page_id_time`	`log_page, log_timestamp`	No	Apparently just used for a few maintenance pages (findMissingFiles.php, Flow). Could be removed?
`log_type_action`	`log_type, log_action, log_timestamp`	No	Special:Log action filter

module_deps

Table caching which local files a module depends on that aren't registered directly, used for fast retrieval of file dependency. Currently only used for tracking images that CSS depends on

Primary Key: md_module, md_skin

Columns

Name	Type	Nullable	Default	Extra options	Description
`md_module`	binary	No	No default	Length: 255	Module name
`md_skin`	binary	No	No default	Length: 32	Module context vary (includes skin and language; called "md_skin" for legacy reasons)
`md_deps`	blob	No	No default	Length: 16777215	JSON blob with file dependencies

objectcache

For a few generic cache operations if not using Memcached

Primary Key: keyname

Columns

Name	Type	Nullable	Default	Extra options
`keyname`	binary	No	""	Length: 255
`value`	blob	Yes	No default	Length: 16777215
`exptime`	mwtimestamp	No	No default

Indexes

Name	Columns	Unique	Description
`exptime`	`exptime`	No

oldimage

Previous revisions of uploaded files. Awkwardly, image rows have to be moved into this table at re-upload time.

Columns

Name	Type	Nullable	Default	Extra options	Description
`oi_name`	binary	No	""	Length: 255	Base filename: key to image.img_name
`oi_archive_name`	binary	No	""	Length: 255	Filename of the archived file. This is generally a timestamp and '!' prepended to the base name.
`oi_size`	integer	No	0	Unsigned
`oi_width`	integer	No	0
`oi_height`	integer	No	0
`oi_bits`	integer	No	0
`oi_description_id`	bigint	No	No default	Unsigned
`oi_actor`	bigint	No	No default	Unsigned
`oi_timestamp`	mwtimestamp	No	No default	Length: 14
`oi_metadata`	blob	No	No default	Length: 16777215
`oi_media_type`	mwenum	Yes	NULL
`oi_major_mime`	mwenum	No	unknown
`oi_minor_mime`	binary	No	unknown	Length: 100
`oi_deleted`	mwtinyint	No	0	Unsigned
`oi_sha1`	binary	No	""	Length: 32

Indexes

Name	Columns	Unique	Description
`oi_actor_timestamp`	`oi_actor, oi_timestamp`	No
`oi_name_timestamp`	`oi_name, oi_timestamp`	No
`oi_name_archive_name`	`oi_name, oi_archive_name`	No	oi_archive_name truncated to 14 to avoid key length overflow
`oi_sha1`	`oi_sha1`	No

page_props

Name/value pairs indexed by page_id

Primary Key: pp_page, pp_propname

Columns

Name	Type	Nullable	Default	Extra options
`pp_page`	integer	No	No default
`pp_propname`	binary	No	No default	Length: 60
`pp_value`	blob	No	No default	Length: 65530
`pp_sortkey`	float	Yes	No default

Indexes

Name	Columns	Unique	Description
`pp_propname_page`	`pp_propname, pp_page`	Yes
`pp_propname_sortkey_page`	`pp_propname, pp_sortkey, pp_page`	Yes

page_restrictions

Used for storing page restrictions (i.e. protection levels)

Primary Key: pr_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`pr_id`	integer	No	No default	Unsigned	Field for an ID for this restrictions row (sort-key for Special:ProtectedPages)
`pr_page`	integer	No	No default		Page to apply restrictions to (Foreign Key to page).
`pr_type`	binary	No	No default	Length: 60	The protection type (edit, move, etc)
`pr_level`	binary	No	No default	Length: 60	The protection level (Sysop, autoconfirmed, etc)
`pr_cascade`	mwtinyint	No	No default
`pr_user`	integer	Yes	No default	Unsigned	Field for future support of per-user restriction.
`pr_expiry`	mwtimestamp	Yes	No default		Field for time-limited protection.

Indexes

Name	Columns	Unique
`pr_pagetype`	`pr_page, pr_type`	Yes
`pr_typelevel`	`pr_type, pr_level`	No
`pr_level`	`pr_level`	No
`pr_cascade`	`pr_cascade`	No

pagelinks

Track page-to-page hyperlinks within the wiki. The target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.

Primary Key: pl_from, pl_namespace, pl_title

Columns

Name	Type	Nullable	Default	Extra options	Description
`pl_from`	integer	No	0	Unsigned	Key to the page_id of the page containing the link.
`pl_namespace`	integer	No	0
`pl_title`	binary	No	""	Length: 255
`pl_from_namespace`	integer	No	0		Namespace for pl_from page

Indexes

Name	Columns	Unique	Description
`pl_namespace`	`pl_namespace, pl_title, pl_from`	No	Reverse index, for Special:Whatlinkshere
`pl_backlinks_namespace`	`pl_from_namespace, pl_namespace, pl_title, pl_from`	No	Index for Special:Whatlinkshere with namespace filter

protected_titles

Used for storing nonexistent pages that have been protected

Primary Key: pt_namespace, pt_title

Columns

Name	Type	Nullable	Default	Extra options
`pt_namespace`	integer	No	No default
`pt_title`	binary	No	No default	Length: 255
`pt_user`	integer	No	No default	Unsigned
`pt_reason_id`	bigint	No	No default	Unsigned
`pt_timestamp`	mwtimestamp	No	No default
`pt_expiry`	mwtimestamp	No	No default
`pt_create_perm`	binary	No	No default	Length: 60

Indexes

Name	Columns	Unique	Description
`pt_timestamp`	`pt_timestamp`	No

querycache

Used for caching expensive grouped queries

Columns

Name	Type	Nullable	Default	Extra options	Description
`qc_type`	binary	No	No default	Length: 32	A key name, generally the base name of of the special page
`qc_value`	integer	No	0	Unsigned	Some sort of stored value. Sizes, counts...
`qc_namespace`	integer	No	0
`qc_title`	binary	No	""	Length: 255

Indexes

Name	Columns	Unique	Description
`qc_type`	`qc_type, qc_value`	No

querycache_info

Details of updates to cached special pages

Primary Key: qci_type

Columns

Name	Type	Nullable	Default	Extra options	Description
`qci_type`	binary	No	""	Length: 32	Special page name. Corresponds to a qc_type value
`qci_timestamp`	mwtimestamp	No	19700101000000	Length: 14	Timestamp of last update

querycachetwo

Used for caching expensive grouped queries that need two links (for example double-redirects)

Columns

Name	Type	Nullable	Default	Extra options	Description
`qcc_type`	binary	No	No default	Length: 32	A key name, generally the base name of of the special page.
`qcc_value`	integer	No	0	Unsigned	Some sort of stored value. Sizes, counts...
`qcc_namespace`	integer	No	0
`qcc_title`	binary	No	""	Length: 255
`qcc_namespacetwo`	integer	No	0
`qcc_titletwo`	binary	No	""	Length: 255

Indexes

Name	Columns	Unique
`qcc_type`	`qcc_type, qcc_value`	No
`qcc_title`	`qcc_type, qcc_namespace, qcc_title`	No
`qcc_titletwo`	`qcc_type, qcc_namespacetwo, qcc_titletwo`	No

redirect

For each redirect, this table contains exactly one row defining its target. Redirect targets are key to page_namespace/page_title of the target page. The target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.

Primary Key: rd_from

Columns

Name	Type	Nullable	Default	Extra options	Description
`rd_from`	integer	No	0	Unsigned	Key to the page_id of the redirect page
`rd_namespace`	integer	No	0
`rd_title`	binary	No	""	Length: 255
`rd_interwiki`	string	Yes	NULL	Length: 32
`rd_fragment`	binary	Yes	NULL	Length: 255

Indexes

Name	Columns	Unique	Description
`rd_ns_title`	`rd_namespace, rd_title, rd_from`	No

revision_actor_temp

Temporary table to avoid blocking on an alter of revision. On large wikis like the English Wikipedia, altering the revision table is a months-long process. This table is being created to avoid such an alter, and will be merged back into revision in the future

Primary Key: revactor_rev, revactor_actor

Columns

Name	Type	Nullable	Default	Extra options	Description
`revactor_rev`	integer	No	No default	Unsigned	Key to rev_id
`revactor_actor`	bigint	No	No default	Unsigned	Key to actor_id
`revactor_timestamp`	mwtimestamp	No	No default		Copy field from revision for indexes
`revactor_page`	integer	No	No default	Unsigned	Copy field from revision for indexes

Indexes

Name	Columns	Unique
`revactor_rev`	`revactor_rev`	Yes
`actor_timestamp`	`revactor_actor, revactor_timestamp`	No
`page_actor_timestamp`	`revactor_page, revactor_actor, revactor_timestamp`	No

revision_comment_temp

Temporary table to avoid blocking on an alter of revision. On large wikis like the English Wikipedia, altering the revision table is a months-long process. This table is being created to avoid such an alter, and will be merged back into revision in the future

Primary Key: revcomment_rev, revcomment_comment_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`revcomment_rev`	integer	No	No default	Unsigned	Key to rev_id
`revcomment_comment_id`	bigint	No	No default	Unsigned	Key to comment_id

Indexes

Name	Columns	Unique	Description
`revcomment_rev`	`revcomment_rev`	Yes

site_identifiers

Links local site identifiers to their corresponding site.

Primary Key: si_type, si_key

Columns

Name	Type	Nullable	Default	Extra options	Description
`si_type`	binary	No	No default	Length: 32	local key type, ie 'interwiki' or 'langlink'
`si_key`	binary	No	No default	Length: 32	local key value, ie 'en' or 'wiktionary'
`si_site`	integer	No	No default	Unsigned	Key on site.site_id

Indexes

Name	Columns	Unique	Description
`site_ids_site`	`si_site`	No
`site_ids_key`	`si_key`	No

site_stats

Contains a single row with some aggregate info on the state of the site.

Primary Key: ss_row_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`ss_row_id`	integer	No	No default	Unsigned	The single row should contain 1 here.
`ss_total_edits`	bigint	Yes	NULL	Unsigned	Total number of edits performed.
`ss_good_articles`	bigint	Yes	NULL	Unsigned	See SiteStatsInit::articles().
`ss_total_pages`	bigint	Yes	NULL	Unsigned	Total pages, theoretically equal to SELECT COUNT(*) FROM page.
`ss_users`	bigint	Yes	NULL	Unsigned	Number of users, theoretically equal to SELECT COUNT(*) FROM user.
`ss_active_users`	bigint	Yes	NULL	Unsigned	Number of users that still edit.
`ss_images`	bigint	Yes	NULL	Unsigned	Number of images, equivalent to SELECT COUNT(*) FROM image.

sites

Holds all the sites known to the wiki.

Primary Key: site_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`site_id`	integer	No	No default	Unsigned	Numeric id of the site
`site_global_key`	binary	No	No default	Length: 64	Global identifier for the site, ie 'enwiktionary'
`site_type`	binary	No	No default	Length: 32	Type of the site, ie 'mediawiki'
`site_group`	binary	No	No default	Length: 32	Group of the site, ie 'wikipedia'
`site_source`	binary	No	No default	Length: 32	Source of the site data, ie 'local', 'wikidata', 'my-magical-repo'
`site_language`	binary	No	No default	Length: 35	Language code of the sites primary language.
`site_protocol`	binary	No	No default	Length: 32	Protocol of the site, ie 'http://', 'irc://', '//'. This field is an index for lookups and is build from type specific data in site_data.
`site_domain`	string	No	No default	Length: 255	Domain of the site in reverse order, ie 'org.mediawiki.www.'. This field is an index for lookups and is build from type specific data in site_data.
`site_data`	blob	No	No default	Length: 65530	Type dependent site data.
`site_forward`	mwtinyint	No	No default	Length: 1	If site.tld/path/key:pageTitle should forward users to the page on the actual site, where "key" is the local identifier.
`site_config`	blob	No	No default	Length: 65530	Type dependent site config. For instance if template transclusion should be allowed if it's a MediaWiki.

Indexes

Name	Columns	Unique
`site_global_key`	`site_global_key`	Yes
`site_type`	`site_type`	No
`site_group`	`site_group`	No
`site_source`	`site_source`	No
`site_language`	`site_language`	No
`site_protocol`	`site_protocol`	No
`site_domain`	`site_domain`	No
`site_forward`	`site_forward`	No

slot_roles

Normalization table for role names

Primary Key: role_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`role_id`	integer	No	No default
`role_name`	binary	No	No default	Length: 64

Indexes

Name	Columns	Unique	Description
`role_name`	`role_name`	Yes	Index for looking up the internal ID of a role

slots

Slots represent an n:m relation between revisions and content objects. A content object can have a specific "role" in one or more revisions. Each revision can have multiple content objects, each having a different role.

Primary Key: slot_revision_id, slot_role_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`slot_revision_id`	bigint	No	No default	Unsigned	reference to rev_id or ar_rev_id
`slot_role_id`	smallint	No	No default	Unsigned	reference to role_id
`slot_content_id`	bigint	No	No default	Unsigned	reference to content_id
`slot_origin`	bigint	No	No default	Unsigned	The revision ID of the revision that originated the slot's content. To find revisions that changed slots, look for slot_origin = slot_revision_id. TODO: Is that actually true? Rollback seems to violate it by setting slot_origin to an older rev_id. Undeletions could result in the same situation.

Indexes

Name	Columns	Unique	Description
`slot_revision_origin_role`	`slot_revision_id, slot_origin, slot_role_id`	No	Index for finding revisions that modified a specific slot

templatelinks

Track template inclusions. The target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.

Primary Key: tl_from, tl_namespace, tl_title

Columns

Name	Type	Nullable	Default	Extra options	Description
`tl_from`	integer	No	0	Unsigned	Key to the page_id of the page containing the link.
`tl_from_namespace`	integer	No	0		Namespace for this page
`tl_namespace`	integer	No	0
`tl_title`	binary	No	""	Length: 255

Indexes

Name	Columns	Unique	Description
`tl_namespace`	`tl_namespace, tl_title, tl_from`	No	Reverse index, for Special:Whatlinkshere
`tl_backlinks_namespace`	`tl_from_namespace, tl_namespace, tl_title, tl_from`	No	Index for Special:Whatlinkshere with namespace filter

text

Holds text of individual page revisions. Field names are a holdover from the 'old' revisions table in MediaWiki 1.4 and earlier: an upgrade will transform that table into the 'text' table to minimize unnecessary churning and downtime. If upgrading, the other fields will be left unused.

Primary Key: old_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`old_id`	integer	No	No default	Unsigned	Unique text storage key number. Note that the 'oldid' parameter used in URLs does not refer to this number anymore, but to rev_id. content.content_address refers to this column
`old_text`	blob	No	No default	Length: 16777215	Depending on the contents of the old_flags field, the text may be convenient plain text, or it may be funkily encoded.
`old_flags`	blob	No	No default	Length: 255	Comma-separated list of flags: gzip: text is compressed with PHP's gzdeflate() function. utf-8: text was stored as UTF-8. If $wgLegacyEncoding option is on, rows without this flag will be converted to UTF-8 transparently at load time. Note that due to a bug in a maintenance script, this flag may have been stored as 'utf8' in some cases (T18841). object: text field contained a serialized PHP object. The object either contains multiple versions compressed together to achieve a better compression ratio, or it refers to another row where the text can be found. external: text was stored in an external location specified by old_text. Any additional flags apply to the data stored at that URL, not the URL itself. The 'object' flag is not set for URLs of the form 'DB://cluster/id/itemid', because the external storage system itself decompresses these.

updatelog

A table to log updates, one text key row per update.

Primary Key: ul_key

Columns

Name	Type	Nullable	Default	Extra options	Description
`ul_key`	string	No	No default	Length: 255
`ul_value`	blob	Yes	No default	Length: 65530

uploadstash

Store information about newly uploaded files before they're moved into the actual filestore

Primary Key: us_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`us_id`	integer	No	No default	Unsigned
`us_user`	integer	No	No default	Unsigned	the user who uploaded the file.
`us_key`	string	No	No default	Length: 255	file key. this is how applications actually search for the file. this might go away, or become the primary key.
`us_orig_path`	string	No	No default	Length: 255	the original path
`us_path`	string	No	No default	Length: 255	the temporary path at which the file is actually stored
`us_source_type`	string	Yes	No default	Length: 50	which type of upload the file came from (sometimes)
`us_timestamp`	mwtimestamp	No	No default	Length: 14	the date/time on which the file was added
`us_status`	string	No	No default	Length: 50
`us_chunk_inx`	integer	Yes	No default	Unsigned	chunk counter starts at 0, current offset is stored in us_size
`us_props`	blob	Yes	No default	Length: 65530	Serialized file properties from FSFile::getProps()
`us_size`	integer	No	No default	Unsigned	file size in bytes
`us_sha1`	string	No	No default	Length: 31	this hash comes from FSFile::getSha1Base36(), and is 31 characters
`us_mime`	string	Yes	No default	Length: 255
`us_media_type`	mwenum	Yes	NULL		Media type as defined by the MEDIATYPE_xxx constants, should duplicate definition in the image table
`us_image_width`	integer	Yes	No default	Unsigned	image-specific properties
`us_image_height`	integer	Yes	No default	Unsigned
`us_image_bits`	smallint	Yes	No default	Unsigned

Indexes

Name	Columns	Unique	Description
`us_user`	`us_user`	No	sometimes there's a delete for all of a user's stuff.
`us_key`	`us_key`	Yes	pick out files by key, enforce key uniqueness
`us_timestamp`	`us_timestamp`	No	the abandoned upload cleanup script needs this

user_former_groups

Stores the groups the user has once belonged to. The user may still belong to these groups (check user_groups). Autopromotion of users to groups from which they were removed can be restricted by using wgAutopromoteOnce instead of wgAutopromote.

Primary Key: ufg_user, ufg_group

Columns

Name	Type	Nullable	Default	Extra options	Description
`ufg_user`	integer	No	0	Unsigned	Key to user_id
`ufg_group`	binary	No	""	Length: 255

user_groups

User permissions have been broken out to a separate table; this allows sites with a shared user table to have different permissions assigned to a user in each project. This table replaces the old user_rights field which used a comma-separated blob.

Primary Key: ug_user, ug_group

Columns

Name	Type	Nullable	Default	Extra options	Description
`ug_user`	integer	No	0	Unsigned	Key to user_id
`ug_group`	binary	No	""	Length: 255	Group names are short symbolic string keys. The set of group names is open-ended, though in practice only some predefined ones are likely to be used. At runtime $wgGroupPermissions will associate group keys with particular permissions. A user will have the combined permissions of any group they're explicitly in, plus the implicit '*' and 'user' groups.
`ug_expiry`	mwtimestamp	Yes	NULL		Time at which the user group membership will expire. Set to NULL for a non-expiring (infinite) membership.

Indexes

Name	Columns	Unique	Description
`ug_group`	`ug_group`	No
`ug_expiry`	`ug_expiry`	No

user_newtalk

Stores notifications of user talk page changes, for the display of the 'you have new messages' box

Columns

Name	Type	Nullable	Default	Extra options	Description
`user_id`	integer	No	0	Unsigned
`user_ip`	binary	No	""	Length: 40	If the user is an anonymous user their IP address is stored here since the user_id of 0 is ambiguous
`user_last_timestamp`	mwtimestamp	Yes	No default		The highest timestamp of revisions of the talk page viewed by this user

Indexes

Name	Columns	Unique	Description
`un_user_id`	`user_id`	No
`un_user_ip`	`user_ip`	No

user_properties

User preferences and perhaps other fun stuff. :) Replaces the old user.user_options blob, with a couple nice properties: 1) We only store non-default settings, so changes to the defaults are now reflected for everybody, not just new accounts. 2) We can more easily do bulk lookups, statistics, or modifications of saved options since it's a sane table structure.

Primary Key: up_user, up_property

Columns

Name	Type	Nullable	Default	Extra options	Description
`up_user`	integer	No	No default	Unsigned	Foreign key to user.user_id
`up_property`	binary	No	No default	Length: 255	Name of the option being saved. This is indexed for bulk lookup.
`up_value`	blob	Yes	No default	Length: 65530	Property value as a string.

Indexes

Name	Columns	Unique	Description
`up_property`	`up_property`	No

watchlist

Primary Key: wl_id

Columns

Name	Type	Nullable	Default	Extra options	Description
`wl_id`	integer	No	No default	Unsigned
`wl_user`	integer	No	No default	Unsigned
`wl_namespace`	integer	No	0
`wl_title`	binary	No	""	Length: 255
`wl_notificationtimestamp`	mwtimestamp	Yes	No default		Timestamp used to send notification e-mails and show 'updated since last visit' markers. Set to NULL when the user visits the latest revision of the page, which means that they should be sent an e-mail on the next change.

Indexes

Name	Columns	Unique	Description
`wl_user`	`wl_user, wl_namespace, wl_title`	Yes	Special:Watchlist
`wl_namespace_title`	`wl_namespace, wl_title`	No	Special:Movepage (WatchedItemStore::duplicateEntry)
`wl_user_notificationtimestamp`	`wl_user, wl_notificationtimestamp`	No	ApiQueryWatchlistRaw changed filter

watchlist_expiry

Allows setting an expiry for watchlist items.

Primary Key: we_item

Columns

Name	Type	Nullable	Default	Extra options	Description
`we_item`	integer	No	No default	Unsigned	Key to watchlist.wl_id
`we_expiry`	mwtimestamp	No	No default		Expiry time

Indexes

Name	Columns	Unique	Description
`we_expiry`	`we_expiry`	No

Name	Type	Nullable	Default	Extra options	Description
`cat_id`	integer	No	No default	Unsigned	Primary key
`cat_title`	binary	No	No default	Length: 255	Name of the category, in the same form as page_title (with underscores). If there is a category page corresponding to this category, by definition, it has this name (in the Category namespace).
`cat_pages`	integer	No	0
`cat_subcats`	integer	No	0
`cat_files`	integer	No	0