手册:validate表

↑ 手册:索引

MediaWiki数据库布局

validate表

MediaWiki版本：

1.4 – 1.6

validate表在MediaWiki 1.8版本中未使用，可以安全地刪除。

它是自存檔的Extension:Review 的一部分，但是，沒有核心軟件需要它。

Schema summary

MediaWiki版本：

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版本：

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

Indexes

MediaWiki版本：

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