Theblobs table stores the contents of thetext table.This table only exists if the wiki is configured to haveExternal Storage, usually on a separate database than the other tables of the wiki.
Before MediaWiki 1.5, this table had an undocumented usage, but since MediaWiki 1.5 this table is no longer used for its original purpose.
MediaWiki version: | ≥ 1.10 |
+-----------+------------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+-----------+------------------+------+-----+---------+----------------+| blob_id | int(10) unsigned | NO | PRI | NULL | auto_increment || blob_text | longblob | YES | | NULL | |+-----------+------------------+------+-----+---------+----------------+
MediaWiki versions: | 1.6 – 1.9 |
+-----------+------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+-----------+------------+------+-----+---------+----------------+| blob_id | int(8) | NO | PRI | NULL | auto_increment || blob_text | mediumtext | YES | | NULL | |+-----------+------------+------+-----+---------+----------------+
MediaWiki versions: | 1.3 – 1.4 |
+------------+-----------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+------------+-----------+------+-----+---------+-------+| blob_index | char(255) | NO | PRI | | || blob_data | longblob | NO | | NULL | |+------------+-----------+------+-----+---------+-------+