Manual:Tabla valid_tag

↑ Manual: Contenidos de

MediaWiki database layout

validate table

Versiones de MediaWiki:

1.4 – 1.6

validate tabla no se usa en la versión MediaWiki 1.5 y puede borrarse sin problemas.

Fue parte de la revisión de $ext-archivo desde entonces, sin embargo, ningún software central lo necesita.

Resumen del esquema

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

Versión de 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

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