Handbuch:blobs-Tabelle

This page is a translated version of the page Manual:Blobs table and the translation is 60% complete.

MediaWiki-Datenbank-Layout

blobs-Tabelle

Die blobs-Tabelle speichert den Inhalt der text -Tabelle. 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.

Schematische Übersicht

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