DROP TABLE IF EXISTS /*_*/reverted_edits;

CREATE TABLE  /*_*/reverted_edits (
  `re_reversion_id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `re_undid_rev_id` int(11) NOT NULL,
  `re_curr_rev_id` int(11) NOT NULL,
  `re_page` int(11) NOT NULL,
  `re_title` varbinary(255),
  `re_undid_rev_text_id` int(11) NOT NULL,
  `re_curr_rev_text_id` int(11) NOT NULL,
  `re_comment` tinyblob,
  `re_undid_user` int(11) NOT NULL,
  `re_undid_user_text` text,
  `re_curr_user` int(11) NOT NULL,
  `re_curr_user_text` text,
  `re_user` int(11) NOT NULL,
  `re_user_text` text,
  `re_action` varbinary(8),
  `re_spam` bool DEFAULT NULL,
  `re_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) /*$wgDBTableOptions*/;

CREATE INDEX  /*i*/reverted_edits_undid_rev_id ON /*_*/reverted_edits(re_undid_rev_id);
CREATE INDEX  /*i*/reverted_edits_curr_rev_id ON /*_*/reverted_edits(re_curr_rev_id);

