Manual:content table
Jump to navigation
Jump to search
↑ Manual:Contents | MediaWiki database layout | content table |
MediaWiki version: | ≥ 1.31 |
The content table represents content objects. Its primary purpose is to provide the necessary meta-data for loading and interpreting a serialized data blob to create a content object.
Fields[edit]
content_id[edit]
ID of the content object
content_size[edit]
Nominal size of the content object (not necessarily of the serialized blob)
content_sha1[edit]
Nominal hash of the content object (not necessarily of the serialized blob)
content_model[edit]
Reference to content_models.model_id. Note the serialization format isn't specified; it should be assumed to be in the default format for the model unless auto-detected otherwise.
content_address[edit]
URL-like address of the content blob.
Currently the structure is: tt:<id>
where <id>
is a number referencing the text.old_id column.
Schema summary[edit]
MediaWiki version: | ≥ 1.31 |
DESCRIBE content;
+-----------------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+----------------------+------+-----+---------+----------------+ | content_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | content_size | int(10) unsigned | NO | | NULL | | | content_sha1 | varbinary(32) | NO | | NULL | | | content_model | smallint(5) unsigned | NO | | NULL | | | content_address | varbinary(255) | NO | | NULL | | +-----------------+----------------------+------+-----+---------+----------------+