Manual:blobs table

From mediawiki.org
This page is a translated version of the page Manual:Blobs table and the translation is 20% complete.
Podręcznik:Spis treści Opis i struktura bazy danych MediaWiki Tabela blobs

The blobs table stores the contents of the text table. This table only exists if the wiki is configured to have External 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.

Schema summary

Wersja MediaWiki:
1.10
+-----------+------------------+------+-----+---------+----------------+
| Field     | Type             | Null | Key | Default | Extra          |
+-----------+------------------+------+-----+---------+----------------+
| blob_id   | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| blob_text | longblob         | YES  |     | NULL    |                |
+-----------+------------------+------+-----+---------+----------------+
Wersje MediaWiki:
1.6 – 1.9
+-----------+------------+------+-----+---------+----------------+
| Field     | Type       | Null | Key | Default | Extra          |
+-----------+------------+------+-----+---------+----------------+
| blob_id   | int(8)     | NO   | PRI | NULL    | auto_increment |
| blob_text | mediumtext | YES  |     | NULL    |                |
+-----------+------------+------+-----+---------+----------------+
Wersje MediaWiki:
1.3 – 1.4
+------------+-----------+------+-----+---------+-------+
| Field      | Type      | Null | Key | Default | Extra |
+------------+-----------+------+-----+---------+-------+
| blob_index | char(255) | NO   | PRI |         |       |
| blob_data  | longblob  | NO   |     | NULL    |       |
+------------+-----------+------+-----+---------+-------+