| MediaWiki versions: | 1.4 – 1.6 |
Thevalidate table is not used in the MediaWiki 1.8 release, and can be safely deleted.[1]
It was part of the since-archivedExtension:Review, however, no core software needs it.
| MediaWiki versions: | 1.5 – 1.6 |
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 | | | |+--------------+------------------+------+-----+---------+-------+
| MediaWiki version: | 1.4 |
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 | | | |+---------------+------------------+------+-----+---------+-------+
| MediaWiki versions: | 1.5 – 1.6 |
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 | | |+----------+------------+----------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+