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