미디어위키 revision 테이블

1 개요[ | ]

미디어위키 revision 테이블
mw_revision

mysql> DESC mw_revision;
+--------------------+---------------------+------+-----+----------------+----------------+
| Field              | Type                | Null | Key | Default        | Extra          |
+--------------------+---------------------+------+-----+----------------+----------------+
| rev_id             | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
| rev_page           | int(10) unsigned    | NO   | MUL | NULL           |                |
| rev_text_id        | int(10) unsigned    | NO   |     | NULL           |                |
| rev_comment        | varbinary(767)      | NO   |     | NULL           |                |
| rev_user           | int(10) unsigned    | NO   | MUL | 0              |                |
| 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  |     | NULL           |                |
| rev_parent_id      | int(10) unsigned    | YES  |     | NULL           |                |
| rev_sha1           | varbinary(32)       | NO   |     |                |                |
| rev_content_format | varbinary(64)       | YES  |     | NULL           |                |
| rev_content_model  | varbinary(32)       | YES  |     | NULL           |                |
+--------------------+---------------------+------+-----+----------------+----------------+
14 rows in set (0.00 sec)

2 쿼리 예시[ | ]

SELECT rev_user userid, rev_user_text user, MAX(rev_timestamp) timestamp
FROM revision 
WHERE rev_page=?
AND rev_user <> 0
GROUP BY rev_user
ORDER BY timestamp DESC

3 같이 보기[ | ]

4 참고[ | ]

미디어위키"Manual:revision table"