Handbuch:valdate-Tabelle

↑ Handbuch:Inhaltsübersicht

MediaWiki-Datenbank-Layout

validate-Tabelle

MediaWiki Versions:

1.4 – 1.6

Die validate-Tabelle wird nicht in der MediaWiki-Version 1.8 verwendet, und kann sicher gelöscht werden.

It was part of the since-archived Extension:Review , however, no core software needs it.

Schematische Übersicht

MediaWiki Versions:

1.5 – 1.6

DESCRIBE validate;

+--------------+------------------+------+-----+---------+-------+
| Field        | Type             | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+-------+
| val_user     | int(11)          | NO   | MUL | 0       |       |
| val_page     | int(11) unsigned | NO   |     | 0       |       |
| val_revision | int(11) unsigned | NO   |     | 0       |       |
| val_type     | int(11) unsigned | NO   |     | 0       |       |
| val_value    | int(11)          | YES  |     | 0       |       |
| val_comment  | varchar(255)     | NO   |     |         |       |
| val_ip       | varchar(20)      | NO   |     |         |       |
+--------------+------------------+------+-----+---------+-------+

MediaWiki Version:

1.4

DESCRIBE validate;

+---------------+------------------+------+-----+---------+-------+
| Field         | Type             | Null | Key | Default | Extra |
+---------------+------------------+------+-----+---------+-------+
| val_user      | int(11)          | NO   | MUL | 0       |       |
| val_title     | varchar(255)     | NO   |     |         |       |
| val_timestamp | varchar(14)      | NO   |     |         |       |
| val_type      | int(10) unsigned | NO   |     | 0       |       |
| val_value     | int(11)          | YES  |     | 0       |       |
| val_comment   | varchar(255)     | NO   |     |         |       |
+---------------+------------------+------+-----+---------+-------+

Indexe

MediaWiki Versions:

1.5 – 1.6

SHOW INDEX IN validate;

+----------+------------+----------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name | Seq_in_index | Column_name  | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+----------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| validate |          1 | val_user |            1 | val_user     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| validate |          1 | val_user |            2 | val_revision | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+----------+------------+----------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+