Text table

From MediaWiki.org

↑ Manual:Contents

MediaWiki database layout

Text table

MediaWiki version:

1.9

MediaWiki version:

1.8

The text table holds the wikitext of individual page revisions. If using Postgres, this table is named pagecontent.

Field names are a holdover from the 'old' revisions table in MediaWiki 1.4 and earlier.

mysql> describe mw_text;
+-----------+-----------------+------+-----+---------+----------------+
| Field     | Type            | Null | Key | Default | Extra          |
+-----------+-----------------+------+-----+---------+----------------+
| old_id    | int(8) unsigned | NO   | PRI | NULL    | auto_increment |
| old_text  | mediumblob      | NO   |     | NULL    |                |
| old_flags | tinyblob        | NO   |     | NULL    |                |
+-----------+-----------------+------+-----+---------+----------------+
3 rows in set

old_id 

revision.rev_text_id in revision table is a key to this column. (In MediaWiki 1.5+, archive.ar_text_id is also a key to this column.)

old_text 

The wikitext of the page.

old_flags 

Comma-separated list of flags. Contains the following possible values:

gzip	Text is compressed with PHP's gzdeflate() function.
utf-8	Text was stored as UTF-8. Note: If the $wgLegacyEncoding option is on, rows *without* this flag will be converted to UTF-8 transparently at load time.
object	Text field contained a serialized PHP object. Note: 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