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_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_lastoldidid
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_rc_queue; +--+-+--+-+-++ +--+-+--+-+-++ +--+-+--+-+-++ 30 rows in set (0.03 sec)
 * Field               | Type                | Null | Key | Default | Extra          |
 * mbrcq_id            | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
 * mbrcq_text_id       | int(10) unsigned    | NO   |     | 0       |                |
 * mbrcq_anon          | tinyint(3) unsigned | NO   |     | 0       |                |
 * mbrcq_content_model | varbinary(32)       | YES  |     | NULL    |                |
 * mbrcq_redirect      | tinyint(3) unsigned | NO   |     | 0       |                |
 * mbrcq_sha1          | varbinary(32)       | NO   |     |         |                |
 * mbrcq_tags          | varchar(255)        | NO   |     |         |                |
 * mbrcq_user_text     | varchar(255)        | NO   |     | NULL    |                |
 * mbrcq_user          | int(10) unsigned    | NO   |     | 0       |                |
 * mbrcq_rc_bot        | tinyint(3) unsigned | NO   |     | 0       |                |
 * mbrcq_rc_comment    | varchar(255)        | NO   |     |         |                |
 * mbrcq_rc_id         | int(10) unsigned    | NO   |     | 0       |                |
 * mbrcq_rc_log_action | varbinary(255)      | YES  |     | NULL    |                |
 * mbrcq_rc_logid      | int(10) unsigned    | NO   |     | NULL    |                |
 * mbrcq_rc_logtype    | varbinary(32)       | NO   |     |         |                |
 * mbrcq_rc_minor      | tinyint(3) unsigned | NO   |     | 0       |                |
 * mbrcq_rc_new        | tinyint(3) unsigned | NO   |     | 0       |                |
 * mbrcq_rc_new_len    | int(11)             | YES  |     | NULL    |                |
 * mbrcq_rc_namespace  | int(11)             | NO   |     | 0       |                |
 * mbrcq_rc_old_len    | int(11)             | YES  |     | NULL    |                |
 * mbrcq_rc_cur_id     | int(10) unsigned    | NO   |     | 0       |                |
 * mbrcq_rc_patrolled  | tinyint(3) unsigned | NO   |     | 0       |                |
 * mbrcq_rc_thisoldid  | int(10) unsigned    | NO   |     | 0       |                |
 * mbrcq_rc_lastoldidid | int(10) unsigned   | NO   |     | 0       |                |
 * mbrcq_rc_timestamp  | varbinary(14)       | NO   |     |         |                |
 * mbrcq_rc_title      | varchar(512)        | NO   |     |         |                |
 * mbrcq_rc_type       | varbinary(255)      | YES  |     | NULL    |                |
 * mbrcq_rc_user       | int(10) unsigned    | NO   |     | NULL    |                |
 * mbrcq_rc_user_text  | varchar(255)        | NO   |     | NULL    |                |
 * mbrcq_push_timestamp | varbinary(14)      | NO   |     |         |                |