revision table

Fields

Schema summary

 DESCRIBE revision;

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| revision_id   | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| page_id       | int(10) unsigned    | NO   | MUL | 0       |                |
| version_id    | int(10) unsigned    | NO   | MUL | 0       |                |
| owner_id      | int(10) unsigned    | NO   | MUL | 0       |                |
| user_id       | int(10) unsigned    | NO   | MUL | 0       |                |
| title         | varchar(250)        | NO   |     | NULL    |                |
| tag           | varchar(250)        | NO   | MUL | NULL    |                |
| supertag      | varchar(250)        | NO   | MUL | NULL    |                |
| menu_tag      | varchar(250)        | NO   |     | NULL    |                |
| created       | datetime            | YES  |     | NULL    |                |
| modified      | datetime            | YES  | MUL | NULL    |                |
| body          | mediumtext          | NO   |     | NULL    |                |
| body_r        | mediumtext          | NO   |     | NULL    |                |
| formatting    | varchar(20)         | NO   |     | NULL    |                |
| edit_note     | varchar(200)        | NO   |     | NULL    |                |
| minor_edit    | tinyint(1) unsigned | YES  | MUL | 0       |                |
| page_size     | int(10) unsigned    | NO   |     | 0       |                |
| reviewed      | tinyint(1) unsigned | NO   | MUL | 0       |                |
| reviewed_time | datetime            | YES  |     | NULL    |                |
| reviewer_id   | int(10) unsigned    | NO   |     | 0       |                |
| latest        | tinyint(1) unsigned | YES  |     | 0       |                |
| ip            | varchar(15)         | NO   |     | NULL    |                |
| handler       | varchar(30)         | NO   |     | page    |                |
| comment_on_id | int(10) unsigned    | NO   | MUL | 0       |                |
| page_lang     | varchar(2)          | NO   |     | NULL    |                |
| description   | varchar(250)        | NO   |     | NULL    |                |
| keywords      | varchar(250)        | NO   |     | NULL    |                |
| deleted       | tinyint(1) unsigned | YES  | MUL | 0       |                |
+---------------+---------------------+------+-----+---------+----------------+

Indices

 SHOW INDEX IN revision;

+--------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table        | Non_unique | Key_name          | Seq_in_index | Column_name   | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+--------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| dev_revision |          0 | PRIMARY           |            1 | revision_id   | A         |         453 |     NULL | NULL   |      | BTREE      |         |               |
| dev_revision |          1 | idx_page_id       |            1 | page_id       | A         |          56 |     NULL | NULL   |      | BTREE      |         |               |
| dev_revision |          1 | idx_version_id    |            1 | version_id    | A         |         226 |     NULL | NULL   |      | BTREE      |         |               |
| dev_revision |          1 | idx_owner_id      |            1 | owner_id      | A         |           8 |     NULL | NULL   |      | BTREE      |         |               |
| dev_revision |          1 | idx_user_id       |            1 | user_id       | A         |           8 |     NULL | NULL   |      | BTREE      |         |               |
| dev_revision |          1 | idx_tag           |            1 | tag           | A         |          56 |     NULL | NULL   |      | BTREE      |         |               |
| dev_revision |          1 | idx_supertag      |            1 | supertag      | A         |          56 |     NULL | NULL   |      | BTREE      |         |               |
| dev_revision |          1 | idx_modified      |            1 | modified      | A         |         453 |     NULL | NULL   | YES  | BTREE      |         |               |
| dev_revision |          1 | idx_minor_edit    |            1 | minor_edit    | A         |           2 |     NULL | NULL   | YES  | BTREE      |         |               |
| dev_revision |          1 | idx_deleted       |            1 | deleted       | A         |           4 |     NULL | NULL   | YES  | BTREE      |         |               |
| dev_revision |          1 | idx_reviewed      |            1 | reviewed      | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |
| dev_revision |          1 | idx_comment_on_id |            1 | comment_on_id | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |
+--------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+