ahiWiki.revision
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| rev_id | int(10) unsigned | NO | PRI | auto_increment | ||
| rev_page | int(10) unsigned | NO | MUL | |||
| rev_text_id | int(10) unsigned | NO | ||||
| rev_comment | varbinary(767) | NO | ||||
| rev_user | int(10) unsigned | NO | 0 | MUL | ||
| rev_user_text | varbinary(255) | NO | MUL | |||
| rev_timestamp | binary(14) | NO | MUL | |||
| rev_minor_edit | tinyint(3) unsigned | NO | 0 | |||
| rev_deleted | tinyint(3) unsigned | NO | 0 | |||
| rev_len | int(10) unsigned | YES | ||||
| rev_parent_id | int(10) unsigned | YES | ||||
| rev_sha1 | varbinary(32) | NO | ||||
| rev_content_model | varbinary(32) | YES | ||||
| rev_content_format | varbinary(64) | YES |
References
| Local Column | References | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| rev_id |
| ||||||||||
| rev_timestamp |
|