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.

mbrcq_id
Primary key

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

mbrcq_text_id
.

mbrcq_content_model
Content model (from api rev ). Comparable to.

mbrcq_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.

mbrcq_sha1
sha1 (from api rev ). Comparable to.

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

mbrcq_user_text
user (from api us ). Comparable to. Possibly redundant with mbrcq_rc_user_text; it's unclear why this field needs to exist.

mbrcq_user
userid (from api us ). Comparable to. Possibly redundant with mbrcq_rc_user; it's unclear why this field needs to exist.

mbrcq_rc_bot
Comparable to.

mbrcq_rc_comment
Comparable to.

mbrcq_rc_id
Comparable to.

mbrcq_rc_log_action
Comparable to.

mbrcq_rc_logid
Comparable to.

mbrcq_rc_logtype
Comparable to.

mbrcq_rc_minor
Comparable to.

mbrcq_rc_new
Comparable to.

mbrcq_rc_new_len
Comparable to.

mbrcq_rc_namespace
Comparable to.

mbrcq_rc_old_len
Comparable to ) (possibly unnecessary)

mbrcq_rc_cur_id
Comparable to.

mbrcq_rc_patrolled
Comparable to.

mbrcq_rc_thisoldid
Comparable to.

mbrcq_rc_lastoldidid
Comparable to.

mbrcq_rc_timestamp
Comparable to.

mbrcq_rc_title
Comparable to.

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

mbrcq_rc_user
Comparable to.

mbrcq_rc_user_text
Comparable to.

mbrcq_push_timestamp
Timestamp of the successful push. Empty if not successfully pushed yet.

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   |     |         |                |