gistfile1.txt

> explain revision;
+--------------------+---------------------+------+-----+---------+----------------+
| Field              | Type                | Null | Key | Default | Extra          |
+--------------------+---------------------+------+-----+---------+----------------+
| rev_id             | int(8) unsigned     | NO   | PRI | NULL    | auto_increment |
| rev_page           | int(8) unsigned     | NO   | MUL | 0       |                |
| rev_text_id        | int(8) unsigned     | NO   |     | 0       |                |
| rev_comment        | varbinary(255)      | YES  |     |         |                |
| rev_user           | int(5) unsigned     | NO   | MUL | 0       |                |
| rev_user_text      | varbinary(255)      | NO   | MUL |         |                |
| rev_timestamp      | varbinary(14)       | NO   | MUL |         |                |
| rev_minor_edit     | tinyint(1) unsigned | NO   |     | 0       |                |
| rev_deleted        | tinyint(1) unsigned | NO   |     | 0       |                |
| rev_len            | int(8) unsigned     | YES  |     | NULL    |                |
| rev_parent_id      | int(8) unsigned     | YES  |     | NULL    |                |
| rev_sha1           | varbinary(32)       | NO   |     |         |                |
| rev_content_model  | varbinary(32)       | YES  |     | NULL    |                |
| rev_content_format | varbinary(64)       | YES  |     | NULL    |                |
+--------------------+---------------------+------+-----+---------+----------------+
14 rows in set (0.01 sec)