maintenance/archives/patch-revision_actor_temp-table.sql

   1 CREATE TABLE /*_*/revision_actor_temp (
   2   revactor_rev int unsigned NOT NULL,
   3   revactor_actor bigint unsigned NOT NULL,
   4   revactor_timestamp binary(14) NOT NULL default '',
   5   revactor_page int unsigned NOT NULL,
   6   PRIMARY KEY (revactor_rev, revactor_actor)
   7 ) /*$wgDBTableOptions*/;
   8 CREATE UNIQUE INDEX /*i*/revactor_rev ON /*_*/revision_actor_temp (revactor_rev);
   9 CREATE INDEX /*i*/actor_timestamp ON /*_*/revision_actor_temp (revactor_actor,revactor_timestamp);
  10 CREATE INDEX /*i*/page_actor_timestamp ON /*_*/revision_actor_temp (revactor_page,revactor_actor,revactor_timestamp);