Extension:MirrorTools/mb queue table

The mb_rc_queue table has data pulled from Wikipedia by MirrorPullBot that is to be pushed to the local wiki by MirrorPushBot. This table is organized according to the following principles:
 * 1) Primary key (mbq_id)
 * 2) Other mirrorbot primary keys (e.g. mbq_text_id), in alphabetical order by field name
 * 3) Other mirrorbot fields (e.g. mbq_push_timestamp), in alphabetical order by field name
 * 4) Fields used in multiple tables (e.g. mbq_user), in alphabetical order by field name
 * 5) Fields used in only one table (e.g. mbq_rev_sha1), in alphabetical order by field name
 * 6) Fields not used anywhere, but which eventually might be (e.g. mbq_tags), in alphabetical order by field name

mbq_id
Primary key

mbq_text_id
.

mbq_action
Action to take (e.g. mirroredit, mirrorcreateuser).

mbq_push_timestamp
Timestamp of push. Empty if not pushed yet.

mbq_status
Status. 'ignore' means there's not yet capability to push this item. 'pushed' means it was pushed to the local wiki. If empty, means that nothing has been done with this row yet.

mbq_comment
Comparable to, , and.

mbq_content_model
Comparable to and. (from api rev ).

mbq_len
Comparable to and.

mbq_log_action
Comparable to and.

mbq_log_id
Comparable to and.

mbq_log_type
Comparable to and.

mbq_minor
Comparable to and.

mbq_namespace
Comparable to and.

mbq_page_id
Comparable to and.

mbq_params
Comparable to and.

mbq_rev_id
Comparable to and.

mbq_timestamp
Comparable to, , , and.

mbq_title
Comparable to, , and.

mbq_user
Comparable to, , and.

mbq_user_text
Comparable to, , and.

mbq_rev_sha1
sha1 (from api rev ). Comparable to.

mbq_rc_anon
Anon (from api rc ). Either 0 or 1. Comparable to.

mbq_rc_bot
Comparable to.

mbq_rc_id
Comparable to.

mbq_rc_new
Comparable to.

mbq_rc_old_len
Comparable to ) (possibly unnecessary)

mbq_rc_patrolled
Comparable to.

mbq_rc_last_oldidid
Comparable to.

mbq_rc_source
Comparable to.

mbq_rc_type
Comparable to. As usual, there are five types: "edit", "new", "move", "log", and "external".

mbq_page_is_redirect
Redirect (from api rc ). Either 0 or 1. Comparable to (or something). Not much use is made of it, so it's not a big deal.

mbq_tags
tags (from api rc ). Comparable to (or at least it's supposed to be).

Schema
mysql> describe mb_queue; +--+-+--+-+-++ +--+-+--+-+-++ +--+-+--+-+-++ 32 rows in set (0.00 sec)
 * Field               | Type                | Null | Key | Default | Extra          |
 * mbq_id              | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
 * mbq_text_id         | int(10) unsigned    | NO   |     | 0       |                |
 * mbq_action          | varchar(255)        | NO   |     |         |                |
 * mbq_push_timestamp  | varbinary(14)       | NO   | MUL |         |                |
 * mbq_status          | varchar(255)        | NO   |     |         |                |
 * mbq_comment         | varchar(255)        | NO   |     |         |                |
 * mbq_content_model   | varbinary(32)       | YES  |     | NULL    |                |
 * mbq_len             | int(11)             | YES  |     | NULL    |                |
 * mbq_log_action      | varbinary(255)      | YES  |     | NULL    |                |
 * mbq_log_id          | int(10) unsigned    | NO   |     | NULL    |                |
 * mbq_log_params      | blob                | YES  |     | NULL    |                |
 * mbq_log_type        | varbinary(32)       | NO   |     |         |                |
 * mbq_minor           | tinyint(3) unsigned | NO   |     | 0       |                |
 * mbq_namespace       | int(11)             | NO   |     | 0       |                |
 * mbq_page_id         | int(10) unsigned    | NO   |     | NULL    |                |
 * mbq_rev_id          | int(10) unsigned    | NO   |     | 0       |                |
 * mbq_timestamp       | varbinary(14)       | NO   |     |         |                |
 * mbq_title           | varchar(512)        | NO   |     |         |                |
 * mbq_user            | int(10) unsigned    | NO   |     | 0       |                |
 * mbq_user_text       | varchar(255)        | NO   |     | NULL    |                |
 * mbq_rc_anon         | tinyint(3) unsigned | NO   |     | 0       |                |
 * mbq_rc_bot          | tinyint(3) unsigned | NO   |     | 0       |                |
 * mbq_rc_id           | int(10) unsigned    | NO   |     | 0       |                |
 * mbq_rc_lastoldidid  | int(10) unsigned    | NO   |     | 0       |                |
 * mbq_rc_new          | tinyint(3) unsigned | NO   |     | 0       |                |
 * mbq_rc_old_len      | int(11)             | YES  |     | NULL    |                |
 * mbq_rc_patrolled    | tinyint(3) unsigned | NO   |     | 0       |                |
 * mbq_rc_source       | varchar(16)         | NO   |     |         |                |
 * mbq_rc_type         | varbinary(255)      | YES  |     | NULL    |                |
 * mbq_rev_sha1        | varbinary(32)       | NO   |     |         |                |
 * mbq_page_is_redirect | tinyint(3) unsigned | NO  |     | 0       |                |
 * mbq_tags            | varchar(255)        | NO   |     |         |                |