Manual:validate table

The validate table is not used in the MediaWiki 1.8 release, and can be safely deleted.^[1]

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

DESCRIBEvalidate;

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

DESCRIBEvalidate;

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

SHOWINDEXINvalidate;

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

• MediaWiki database tables