1 -- remove old_title and old_namespace, replace with old_articleid
5 DROP COLUMN old_namespace
,
6 ADD COLUMN old_articleid
INT(8) UNSIGNED
NOT NULL;
9 SET old_articleid
=cur_id
10 WHERE old_title
=cur_title
11 AND old_namespace
=cur_namespace
;
13 DROP INDEX name_title_timestamp
ON old;
14 DROP INDEX name_title
ON old;
15 CREATE INDEX articleid_timestamp
ON old (old_articleid
, old_timestamp
);
16 CREATE INDEX articleid
ON old (old_articleid
);