Extension:MirrorTools/Queue table/Sandbox

CREATE TABLE mb_rc_queue( -- Primary key mbrcq_id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, -- anon (from api rc) mbrcq_anon tinyint UNSIGNED NOT NULL DEFAULT 0, -- content (from api rev) mbrcq_text mediumblob NOT NULL, -- redirect (from api rc) mbrcq_redirect tinyint UNSIGNED NOT NULL DEFAULT 0, -- sha1 (from api rev) mbrcq_sha1 varbinary(32) NOT NULL DEFAULT , -- tags (from api rc) mbrcq_tags VARCHAR(255) BINARY NOT NULL DEFAULT , -- user (from api us). This is the user who is being created, not creating mbrcq_user_text VARCHAR(255) BINARY NOT NULL, -- userid (from api us). This is the user who is being created, not creating mbrcq_user INT UNSIGNED NOT NULL DEFAULT 0, -- bot mbrcq_rc_bot tinyint UNSIGNED NOT NULL DEFAULT 0, -- comment mbrcq_rc_comment VARCHAR(255) BINARY NOT NULL DEFAULT '', -- id mbrcq_rc_id INT UNSIGNED NOT NULL DEFAULT 0, -- logaction mbrcq_rc_log_action varbinary(255) NULL DEFAULT NULL, -- logid mbrcq_rc_logid INT UNSIGNED NOT NULL, -- logtype mbrcq_rc_logtype varbinary(32) NOT NULL DEFAULT '', -- minor mbrcq_rc_minor tinyint UNSIGNED NOT NULL DEFAULT 0, -- new mbrcq_rc_new tinyint UNSIGNED NOT NULL DEFAULT 0, -- newlen mbrcq_rc_new_len INT, -- ns mbrcq_rc_namespace INT NOT NULL DEFAULT 0, -- oldlen mbrcq_rc_old_len INT, -- pageid mbrcq_rc_cur_id INT UNSIGNED NOT NULL DEFAULT 0, -- patrolled mbrcq_rc_patrolled tinyint UNSIGNED NOT NULL DEFAULT 0, -- revid mbrcq_rc_thisoldid INT UNSIGNED NOT NULL DEFAULT 0, -- revoldid mbrcq_rc_lastoldidid INT UNSIGNED NOT NULL DEFAULT 0, -- timestamp mbrcq_rc_timestamp varbinary(14) NOT NULL DEFAULT '', -- title (512, because it is prefixed by the namespace) mbrcq_rc_title VARCHAR(512) BINARY NOT NULL DEFAULT '', -- type mbrcq_rc_type varbinary(255) NULL DEFAULT NULL, -- userid mbrcq_rc_user INT UNSIGNED NOT NULL, -- user mbrcq_rc_user_text VARCHAR(255) BINARY NOT NULL, -- contentmodel (obtained from push) mbrcq_push_contentmodel varbinary(32) DEFAULT NULL, -- newrevid (from push) mbrcq_push_newrevid INT UNSIGNED NOT NULL DEFAULT 0, -- newtimestamp (from push) mbrcq_push_newtimestamp varbinary(14) NOT NULL DEFAULT '', -- oldrevid (from push) mbrcq_push_oldrevid INT UNSIGNED NOT NULL DEFAULT 0, -- pageid (from push) mbrcq_push_page_id INT UNSIGNED NOT NULL DEFAULT 0, -- result (from push) mbrcq_push_result VARCHAR(255) BINARY NOT NULL DEFAULT '', -- title (from push) (512, because it is prefixed by the namespace) mbrcq_push_title VARCHAR(512) BINARY NOT NULL DEFAULT '', -- user (from push) mbrcq_push_user INT UNSIGNED NOT NULL, );