Open main menu

Manual:content table


Other languages:
English • ‎日本語
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.

FieldsEdit

content_idEdit

ID of the content object

content_sizeEdit

Nominal size of the content object (not necessarily of the serialized blob)

content_sha1Edit

Nominal hash of the content object (not necessarily of the serialized blob)

content_modelEdit

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_addressEdit

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 summaryEdit

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    |                |
+-----------------+----------------------+------+-----+---------+----------------+