revision table
Fields
Schema summary
DESCRIBE revision;
6.0
+---------------+---------------------+------+-----+---------+----------------+ | 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(191) | NO | | | | | tag | varchar(191) | NO | MUL | | | | 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(45) | NO | | NULL | | | handler | varchar(30) | NO | | page | | | comment_on_id | int(10) unsigned | NO | MUL | 0 | | | page_lang | varchar(5) | 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 | +----------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | wacko_revision | 0 | PRIMARY | 1 | revision_id | A | 686 | NULL | NULL | | BTREE | | | | wacko_revision | 1 | idx_page_id | 1 | page_id | A | 228 | NULL | NULL | | BTREE | | | | wacko_revision | 1 | idx_version_id | 1 | version_id | A | 228 | NULL | NULL | | BTREE | | | | wacko_revision | 1 | idx_owner_id | 1 | owner_id | A | 8 | NULL | NULL | | BTREE | | | | wacko_revision | 1 | idx_user_id | 1 | user_id | A | 12 | NULL | NULL | | BTREE | | | | wacko_revision | 1 | idx_tag | 1 | tag | A | 228 | NULL | NULL | | BTREE | | | | wacko_revision | 1 | idx_modified | 1 | modified | A | 686 | NULL | NULL | YES | BTREE | | | | wacko_revision | 1 | idx_minor_edit | 1 | minor_edit | A | 4 | NULL | NULL | YES | BTREE | | | | wacko_revision | 1 | idx_deleted | 1 | deleted | A | 2 | NULL | NULL | YES | BTREE | | | | wacko_revision | 1 | idx_reviewed | 1 | reviewed | A | 2 | NULL | NULL | | BTREE | | | | wacko_revision | 1 | idx_comment_on_id | 1 | comment_on_id | A | 2 | NULL | NULL | | BTREE | | | +----------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+