User:Leucosticte/mbq

CREATE TABLE mb_queue( -- Primary key mbq_id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,  mbq_log_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,  mbq_log_type varbinary(32) NOT NULL default ,  mbq_log_action varbinary(32) NOT NULL default ,  mbq_log_timestamp binary(14) NOT NULL default '19700101000000',  mbq_log_user int unsigned NOT NULL default 0,  mbq_log_user_text varchar(255) binary NOT NULL default ,  mbq_log_namespace int NOT NULL default 0,  mbq_log_title varchar(255) binary NOT NULL default ,  mbq_log_page int unsigned NULL,  mbq_log_comment varchar(255) NOT NULL default ,  mbq_log_params blob NOT NULL,  mbq_log_deleted tinyint unsigned NOT NULL default 0,  mbq_rc_id int NOT NULL PRIMARY KEY AUTO_INCREMENT,  mbq_rc_timestamp varbinary(14) NOT NULL default ,  mbq_rc_user int unsigned NOT NULL default 0,  mbq_rc_user_text varchar(255) binary NOT NULL,  mbq_rc_namespace int NOT NULL default 0, mbq_rc_title varchar(255) binary NOT NULL default '', mbq_rc_comment varchar(255) binary NOT NULL default '', mbq_rc_minor tinyint unsigned NOT NULL default 0, mbq_rc_bot tinyint unsigned NOT NULL default 0, mbq_rc_new tinyint unsigned NOT NULL default 0, mbq_rc_cur_id int unsigned NOT NULL default 0, mbq_rc_this_oldid int unsigned NOT NULL default 0, mbq_rc_last_oldid int unsigned NOT NULL default 0, mbq_rc_type tinyint unsigned NOT NULL default 0, mbq_rc_source varchar(16) binary not null default '', mbq_rc_patrolled tinyint unsigned NOT NULL default 0, mbq_rc_ip varbinary(40) NOT NULL default '', mbq_rc_old_len int, mbq_rc_new_len int, mbq_rc_deleted tinyint unsigned NOT NULL default 0, mbq_rc_logid int unsigned NOT NULL default 0, mbq_rc_log_type varbinary(255) NULL default NULL, mbq_rc_log_action varbinary(255) NULL default NULL, mbq_rc_params blob NULL, mbq_rev_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, mbq_rev_page int unsigned NOT NULL, mbq_rev_text_id int unsigned NOT NULL, mbq_rev_comment tinyblob NOT NULL, mbq_rev_user int unsigned NOT NULL default 0, mbq_rev_user_text varchar(255) binary NOT NULL default '', mbq_rev_timestamp binary(14) NOT NULL default '', mbq_rev_minor_edit tinyint unsigned NOT NULL default 0, mbq_rev_deleted tinyint unsigned NOT NULL default 0, mbq_rev_len int unsigned, mbq_rev_parent_id int unsigned default NULL, mbq_rev_sha1 varbinary(32) NOT NULL default '', mbq_rev_content_model varbinary(32) DEFAULT NULL, mbq_rev_content_format varbinary(64) DEFAULT NULL, mbq_user_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, mbq_user_name varchar(255) binary NOT NULL default '', mbq_user_real_name varchar(255) binary NOT NULL default '', mbq_user_password tinyblob NOT NULL, mbq_user_newpassword tinyblob NOT NULL, mbq_user_newpass_time binary(14), mbq_user_email tinytext NOT NULL, mbq_user_touched binary(14) NOT NULL default '', mbq_user_token binary(32) NOT NULL default '', mbq_user_email_authenticated binary(14), mbq_user_email_token binary(32), mbq_user_email_token_expires binary(14), mbq_user_registration binary(14), mbq_user_editcount int, mbq_user_password_expires varbinary(14) DEFAULT NULL -- status ('unready', 'ready', 'pushed') mbrcq_status VARCHAR(255) BINARY NOT NULL DEFAULT '' );