Manual:text table

↑ Manual:Contents

MediaWiki database layout

text table

MediaWiki version:

≥ 1.5

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

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

If you updated your wiki from MediaWiki 1.4 or older to a newer version, and if you have then run update.php at least once, you will still have old columns in the text table, whose contents have been migrated to the page table and the revision table (content is copied, not cut). These columns in the text table will not be used anymore. All fields in the text table except old_id, old_text and old_flags are not needed anymore and can be safely deleted.

Schema summary

MediaWiki version:

1.19

mysql> describe text;
+-----------+------------------+------+-----+---------+----------------+
| Field     | Type             | Null | Key | Default | Extra          |
+-----------+------------------+------+-----+---------+----------------+
| old_id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| old_text  | mediumblob       | NO   |     | NULL    |                |
| old_flags | tinyblob         | NO   |     | NULL    |                |
+-----------+------------------+------+-----+---------+----------------+

MediaWiki version:

1.9

MediaWiki version:

1.8

mysql> describe 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

Fields

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.  Note: If the $wgCompressRevisions option is on, new rows (=current revisions) will be gzipped transparently at save time. Previous revisions can also be compressed by using the script compressOld.php
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

See also

• MediaWiki_architecture_document/text/revision_2#Database_and_text_storage.

Databases

Engines: MySQL – Oracle – PostgreSQL – SQLite 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 – Patch file Core tables: archive – category – categorylinks – change_tag – config – externallinks – filearchive – hitcounter – image – imagelinks – interwiki – iwlinks – ipblocks – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – searchindex – sites – site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist

Language:	English  • 日本語